Microsoft SSAS Solution: Cube Design Considerations

Hi guys, today i read James Serra’ post – whether 1 single BIG cube is good as comapred to multiple small cubes. Check out the advantages and disadvantages with both design approaches. he made a pretty nifty list of both of these. i would also recommend you to read this post. here is the link: …

Continue reading ‘Microsoft SSAS Solution: Cube Design Considerations’ »

Behavior Changes to Analysis Services Features in SQL Server 2012

Hi all, I would like to draw your attention to the few modifications in SSAS behaviors in SQL 2012. The most important difference you will find is the “Cube Browser”. Yes, it’s totally changed. According to Microsoft “The cube browser control that let you drag and drop fields onto a PivotTable structure in Management Studio …

Continue reading ‘Behavior Changes to Analysis Services Features in SQL Server 2012’ »

Spot/Highlight Minimum and Maximum value(s) in each row in Matrix report in SSRS :)

Hi all, How are you doing? Today I would show you; how you can highlight minimum and maximum values in an each row of matrix report in SSRS. Again, “there are lots of ways“, but that depends on what is your solution framework. If you are using standard T-SQL queries for reporting, then it’s easier …

Continue reading ‘Spot/Highlight Minimum and Maximum value(s) in each row in Matrix report in SSRS :)’ »

MDX Query Parameterization for displaying Last 12 month’s SSRS Report

Hi All, While working with SSRS reports for displaying some financial data; many a times we have to display data for particular time-frame. Or most commonly – last 12 month’s data. I am talking about the case where you are pulling data from SSAS Cube using MDX queries. In this particular example, I need to …

Continue reading ‘MDX Query Parameterization for displaying Last 12 month’s SSRS Report’ »

Browse an SSAS Cube using Excel – Automatic Setup done by SQL Server Data Tools

Hi All, Most of us; who are working on SQL BI solutions are aware of connecting SSAS Cube using Excel (as client) for browsing. Because we know that how much the clients/financial users likes to work with Excel 🙂 In SQL 2012 RC0, there is one handy-dandy quick-link which enables us to make this whole …

Continue reading ‘Browse an SSAS Cube using Excel – Automatic Setup done by SQL Server Data Tools’ »

Demo Site is ready with full featured “SQL Server 2012 RC0” to play with

Note: This site requires Windows 7, Windows Vista with SP1/SP2 or Windows XP wth SP3 to have the correct RDP client to use this site. Go to this site http://fs.mssalesdemos.com/, Login with your live ID. Select the “Catalog” tab. Select “New SQL Server 2012-RC0 fully integrated Demo“. The new SQL Server 2012-RC0 demo is fully …

Continue reading ‘Demo Site is ready with full featured “SQL Server 2012 RC0” to play with’ »