Tag Archives: SSAS

Microsoft SSAS Solution: Cube Design Considerations

Khilitchandra's Business Intelligence Blog Posted on by

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: http://www.jamesserra.com/archive/2013/01/ssas-one-giant-cube-or-many-small-ones i hope you also find this interesting. thanks, khilit

Continue reading →

Behavior Changes to Analysis Services Features in SQL Server 2012

Khilitchandra's Business Intelligence Blog Posted on by

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 or in Cube Designer has been removed from the product. The control was an Office Web Control (OWC) component. OWC was deprecated by Office and is no longer available.”

Continue reading →

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

Khilitchandra's Business Intelligence Blog Posted on by

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 to write this min-max logic in query itself. But if you are using SSAS cube then you have to write custom MDX (i.e. calculated column/”Member” in Cube’s term) and do comparison in SSRS report in each row. I can show you even simpler way where … Continue reading →

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

Khilitchandra's Business Intelligence Blog Posted on by

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 display SSRS report for last 12 month’s data from SSAS Cube. So I need to provide 2 things: StartDate and EndDate. But as the default expected behavior of the Report requires EndDate to be today’s date so we have to dynamically configure today’s date in … Continue reading →

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

Khilitchandra's Business Intelligence Blog Posted on by

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 functionality ready-made in few seconds. Believe it or not, try the following: Open “SQL Server Data Tools” (This is new name assigned to Visual Studio IDE/BIDS in SQL Server 2012 RC0) Use MultiDimensionalProject & create a cube with any method you want. Process & Deploy … Continue reading →

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

Khilitchandra's Business Intelligence Blog Posted on by

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 integrated with SQL Server 2012, SharePoint 2010 and Office 2010 including: • PowerPivot and MDS Excel integration • Reporting Services integration with SharePoint • Power View integrated with SharePoint • Data Quality Services

Continue reading →