AspAlliance.com - Nidal Arabi http://aspalliance.com/author.aspx?uId=61925 AspAlliance articles by Nidal Arabi SQL Server Analysis Services - Manipulating Data Source Views In this article, Nidal demonstrates the steps required to manipulate Data Source Views using SQL Server Analysis Services. After a short introduction, he examines the steps in detail with the help of relevant screenshots and code listing. http://aspalliance.com/1739_SQL_Server_Analysis_Services__Manipulating_Data_Source_Views Nidal Arabi Fri, 10 Oct 2008 00:00:00 GMT SQL Server Analysis Services - Creating Data Source Views Now it is time to go practical in our business intelligence project as we have provided enough concepts. The first step in creating BI projects is to provide data sources to build your model out of. In this article, Nidal examines the different aspects of creating data source views using SQL Server 2008. After providing a short introduction, he outlines the procedure involved in a series of steps with the help of relevant screenshots. http://aspalliance.com/1732_SQL_Server_Analysis_Services__Creating_Data_Source_Views Nidal Arabi Mon, 06 Oct 2008 00:00:00 GMT SQL Server Analysis Services - UDM In this article, Nidal examines the concept of Unified Dimensional Model (UDM) in SQL Server. After a short introduction, he provides a short overview of Relational and Dimensional model in addition to UDM. http://aspalliance.com/1729_SQL_Server_Analysis_Services__UDM Nidal Arabi Thu, 02 Oct 2008 00:00:00 GMT SQL Server Analysis Services - Dimensional Modeling Concepts Building relational databases has evolved. However, building OLAP databases requires different skills. In this article, Nidal explains some building blocks of these kind of databases. He examines the concept behind Dimensions and Measures in detail with relevant screenshots. http://aspalliance.com/1730_SQL_Server_Analysis_Services__Dimensional_Modeling_Concepts Nidal Arabi Mon, 29 Sep 2008 00:00:00 GMT SQL Server Analysis Services Concepts In this series of articles, Nidal explains how Microsoft has done a great job in the world of business intelligence using Microsoft SQL Server Analysis Services (SSAS). The author deeply examines the concept of OLAP Services and Unified Dimensional Model. He also points out where SSAS fits in SQL Server and also the requirements to work with it in a step-by-step manner. http://aspalliance.com/1728_SQL_Server_Analysis_Services_Concepts Nidal Arabi Mon, 22 Sep 2008 00:00:00 GMT SQL Server Analysis Services Work Flow The Analysis services project has a series of predefined steps that you can follow to create your end result. In this article, Nidal examines the work flow steps of SQL Server Analysis Services in detail. He begins with a short introduction to SQL Server Analysis Services and then provides comprehensive explanation of the concept with the help of related screenshots. http://aspalliance.com/1726_SQL_Server_Analysis_Services_Work_Flow Nidal Arabi Tue, 16 Sep 2008 00:00:00 GMT SQL Server 2008 New Features - Hierarchy Data Type The hierarchy data in SQL Server 2008 is best used to implement organization chart as well as tree based kind of variables. In this article, Nidal demonstrates this data type in a step-by-step way. He examines each step in detail with the help of relevant SQL statements and screenshots of the final result. http://aspalliance.com/1722_SQL_Server_2008_New_Features__Hierarchy_Data_Type Nidal Arabi Fri, 12 Sep 2008 00:00:00 GMT SQL Server 2008 New Features - Table-Value Parameter With the ability to pass a table or a number of rows as parameter, SQL Server has reduced the repeated number of calls between your application components. Table-value parameters are going to change the way you work with SQL Server programming. Nidal examines this feature in detail with the help of relevant SQL statements along with step-by-step analysis and screenshots. http://aspalliance.com/1718_SQL_Server_2008_New_Features__TableValue_Parameter Nidal Arabi Wed, 10 Sep 2008 00:00:00 GMT SQL Server 2008 New Features - Grouping Sets In this article, Nidal talks about the available enhancements in the group by clause of SQL Server 2008. The grouping sets feature allows the developer to group data selected in the same select statement into different groups. He examines the techniques involved with the help of relevant SQL statements followed by analysis and a screen shot. http://aspalliance.com/1716_SQL_Server_2008_New_Features__Grouping_Sets Nidal Arabi Thu, 04 Sep 2008 00:00:00 GMT SQL Server 2008 New Features - Date and Time SQL Server has been long accused of not having a complete representation of Date and Time variables. However, SQL Server 2008 brings new date and time variables to allow for more precise control over these variables types, which Nidal examines in this article. He demonstrates the concept with the help of relevant SQL statements and screenshots of the generated output. http://aspalliance.com/1717_SQL_Server_2008_New_Features__Date_and_Time Nidal Arabi Mon, 01 Sep 2008 00:00:00 GMT