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: […]

bigatorJanuary 16, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , ,  · Posted in: Business Intelligence, General, Interview QA, Quick Fix, SQL Server, SQL Server 2012, SSAS

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 […]

bigatorAugust 11, 2012 · bigatorKhilitchandra Prajapati · bigatorOne Comment
bigatorTags: , , , , ,  · Posted in: Business Intelligence, MDX, New Features, Pivot Table, SQL Server, SQL Server 2012, SSAS

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 […]

bigatorApril 26, 2012 · bigatorKhilitchandra Prajapati · bigator12 Comments
bigatorTags: , , ,  · Posted in: Business Intelligence, MDX, Quick Tips, SQL Server, SSAS, SSRS, Tutorial

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 […]

bigatorMarch 8, 2012 · bigatorKhilitchandra Prajapati · bigator3 Comments
bigatorTags: , ,  · Posted in: MDX, Quick Tips, SSAS, Tutorial, VB Script

How to set default dimension measure in Cube ?

Hi All, Following script will help you to set default dimension measure for Cube. ALTER CUBE [Adventure Works] UPDATE DIMENSION [Geography].[Geography] , DEFAULT_MEMBER = [Geography].[Geography].[Country].&[United States] Thanks, Khilit

bigatorFebruary 19, 2012 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: ,  · Posted in: MDX, SSAS

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 […]

bigatorFebruary 12, 2012 · bigatorKhilitchandra Prajapati · bigator2 Comments
bigatorTags: , , ,  · Posted in: Excel, New Features, Pivot Table, Quick Tips, SQL Server, SSAS

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, 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 […]

bigatorFebruary 2, 2012 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , ,  · Posted in: Business Intelligence, Quick Tips, SSAS, SSIS, SSRS, Suggestion, Visio