Welcome in Dinesh Patel Blog

http://demos7.dundas.com/Sonatica.aspx  

WITH MEMBER [Direct] AS (([dimExpenseDimension].[Direct Indirect].&[1]&[1], [Measures].[YTD Expense Sum]) / [Measures].[YTD Gross Earned Premium]) MEMBER [Regional Office Recharges] AS (([dimExpenseDimension].[Major Expenses].&[1]&[2]&[6], [Measures].[YTD Expense Sum]) / [Measures].[YTD Gross Earned Premium]) MEMBER [Platform Recharge] AS (([dimExpenseDimension].[Major Expenses].&[1]&[2]&[5], [Measures].[YTD Expense Sum]) / [Measures].[YTD Gross Earned Premium]) select {[Direct],[Regional Office Recharges],[Platform Recharge]} on columns , [dimLocationDimension].[Country]. CHILDREN on rows from [cubeExpenseFact] where ([dimTimeDimension].[Month Wise].[Month].&[2009]&[12])

Who Should Read This Guide This guide is intended for software architects and developers who are developing Business Intelligence applications on the Microsoft .NET Framework using SQL Server 2005 - Integration Services, Analysis Services, Reporting Services and Microsoft Office . What You Must Know To most effectively use this guidance, you should already have experience using SQL Server 2005, .NET development techniques and technologies. You should be familiar with general distributed application architecture challenges, and, if you have already implemented business intelligence solutions, you should know your own application architecture and deployment pattern. Where we are               We are in the early stage of Business intelligence architecture guide. This guide address architectural and design aspects of Business intelligence. We anticipate gaps in this guide as we are doing release at the very early stage....

·          Null values in measures —For each fact table measure that is loaded into the partition, you can decide how Analysis Services interprets null values. Consider the following example. Your sales fact table contains a record that has a sales amount of 1000 and a discount amount of null . When discount is loaded into the cube, by default it is interpreted as a zero , which means that it is not considered empty . How Analysis Services interprets null values is controlled by a property called NullProcessing . The NullProcessing property is set on a measure-by-measure basis. By default, it is set to Automatic which means that Analysis Services converts the null values to zero. If you want to preserve the null value from the source system, such as in the example of the discount measure, configure the NullProcessingProperty of that measure to Preserve instead of Automatic . ·          Null values in calc...

MSDN Virtual Labs for Developers: SQL Server 2005 Virtual Labs: http://msdn.microsoft.com/en-us/aa740409.aspx MSDN Virtual Lab Express: What's new in SQL Server 2005   MSDN Virtual Lab: Mapping Your Objects to Database Tables with LINQ to SQL MSDN Virtual Lab: Using the Microsoft SQL Server 2005 Data Mining Add-Ins for the 2007 Microsoft Office System MSDN Virtual Lab: Getting Started with Microsoft Visual Studio Team Edition for Database Professionals MSDN Virtual Lab: SQL Server 2005 Hosted Trial MSDN Virtual Lab: SQL Server 2005 Integration Services MSDN Virtual Lab: SQL Server 2005- Introduction to SQL Server Management Studio MSDN Virtual Lab: Analysis Services in SQL Server 2005 MSDN Virtual Lab: SQL Server 2005 Reporting Services MSDN Virtual Lab: SQL Server 2005 Report Builder MSDN Virtual Lab: SQL Server 2005 Report Viewer Controls MSDN Virtual Lab: SQL Server 2005 Service Broker MSDN Virtual Lab: SQL Server 2005 and ADO.NET (Lab A) MSDN Virtual ...

WITH SET [TopCountCustomers] AS { TopCount ( NONEMPTY ( [dimCustomerDimension].[Full Name]. CHILDREN *    [dimPolicydimension].[Policy Number]. CHILDREN *          [dimLocationDimension].[Branch]. CHILDREN * [dimChannelDimension].[Intermediary]. CHILDREN * [dimClaimsTransactionFact].[Claim Serial Number]. CHILDREN * [dimPolicydimension].[Reinsurer Code]. CHILDREN * [dimPolicydimension].[RI TYPE]. CHILDREN * [dimClaimsTransactionFact].[Occurrence Date]. CHILDREN * [dimClaimsTransactionFact].[Claim Transaction Date]. CHILDREN ),20, [Measures].[YTD Gross Claims Incurred WO IBNR])} SELECT { [Measures].[YTD Gross Claims Incurred WO IBNR],[Measures].[YTD RI Share of Claim], [Measures].[YTD AXA Share] } on columns ,{ [TopCountCustomers]  } on rows from ( SELECT TopCount ( NONEMPTY ([dimPolicydimension].[Policy Number]. CHILDREN ),20, [Measures].[YTD Gross Claims Incurred WO IBNR] ) on columns from [cubeClaimsT...