RSS

Tag Archives: MDX

MDX, Multi-Dimensional Expressions, SSAS, SQL Server Analysis Services, Business Intelligence

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

 

Tags: , , , ,

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 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 you don’t have to write MDX to achieve this functionality and implementation will be easier, faster & fun :)

Ok, let’s begin step by step.

Read the rest of this entry »

 

Tags: , , ,

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 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 EndDate parameter. We also have to determine the date of 12 month’s back to today’s date for StartDate parameter.

Read the rest of this entry »

 
 

Tags: , ,

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

 
Leave a comment

Posted by on February 19, 2012 in MDX, SSAS

 

Tags: ,