MDX and DAX Query Formatter …. is back :)
Hi Friends, Just to share with you quickly that “MDX and DAX Query Formatter” site is back online. Here is the link: http://formatmdx.azurewebsites.net/ Thanks, Khilit
May 13, 2013
· 
Khilitchandra Prajapati · 
No Comments
Tags: DAX, Formatting, MDX, Microsoft, Query · Posted in: Business Intelligence, Data Mining, DMX, General, Interview QA, MDX, Query Tuning, 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 [...]
April 26, 2012
· Khilitchandra Prajapati · 8 Comments
Tags: Business Intelligence, MDX, SSAS, SSRS · 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 [...]
March 8, 2012
· Khilitchandra Prajapati · 3 Comments
Tags: MDX, SSAS, VB Script · 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
February 19, 2012
· Khilitchandra Prajapati · No Comments
Tags: MDX, SSAS · Posted in: MDX, SSAS
