Melick's Blog

Configuration Summary Install SQL Server 2012 SP1 (SQLServer2012SP1-FullSlipstream-ENU-x64) Uninstall Report Services - Native If you have installed it Install Reporting Services – SharePoint & Reporting Services Add-In for SharePoint Product Install Analysis Services In Tabular Mode and Data Tools Install SharePoint Reporting Service Install and Configure Power Pivot for SharePoint Configure Performance Point Services Configure Reporting Services Check SharePoint Power Pivot Integration Install SQL Server 2012 SP1 CTP3 First you need need at least SQL Server 2012 SP1 CTP 3 installed in your farm.  If not you can download and install it from here Better if you can restart the machine after installation. Uninstall Report Services – Native If You have already installed Reporting services Native go to Control Panel and Uninstall SQL Server and remove the Reporting Services – Native Feature. Install Reporting Services – SharePoint & Reporting Services Add-In fo...

I encountered a problem when using the slowly changing dimension (SCD) in large databases. SCD is easy and fast when it comes to less number of records. therefore I used following mechanism to  speed up the process using available SSIS components. First record set is send through Lookup command . in there we are checking that item is already available with the table. If yes we are redirecting to UPDARE Command and If not we are redirecting to Insert Command . But make sure following redirect option (Redirect rows to no match output) is set in the lookup component.

This is not a complete post. I came across a situation that I needed to show [Date] dimension values which is not empty as report parameter. But I need yeas that only have values in measure. there for I used following MDX to get that. with member yKey as [ Date ].[ Year ].currentmember.uniquename member yValue as [ Date ].[ Year ].currentmember.MEMBER_CAPTION select {yKey,yValue} on 0, { filter([ Date ].[ Year ].[ Year ],[Measures].[Total Amount]<> null ) } on 1 from [RetailigenceBI] this code result in getting