Implementing custom rollup/account intelligence with tabular model

Hello Experts,

I am trying to figure out how to implement custom rollup with tabular model. Going through whitepaper "Choosing a Tabular or Multipdimensional modeling experience in SQL Server 2012 Analysis services", I came across following suggestion:

In tabular models, parent-child or account intelligence is not built-in, but you can build your own solution using a combination of calculated columns and measures to build out the parent child hierarchy and apply the custom rollup.

Internet search for this didn't yield any result. Do we have any examples/code samples for doing it? Any pointers will be much appreciated

Thanks

Anil

August 29th, 2015 3:54am

Hi aprasad,

According to your description, you want to implement cumulative total logic in SSAS Tabular. Right?

In SSAS Tabular, we can use DAX to achieve running total in calculated column. We just need to use FILTER() to specify a set of date members for sum calculation. You can use expression like below:

Cumulative Sales :=
CALCULATE (
    SUM ( Sales[Sales] ),
    FILTER (
        ALL ( 'Date'[Date] ),
        'Date'[Date] <= MAX ( 'Date'[Date] )
    )
)

For more information, please refer to links below:

Cumulative Total

Running Total Techniques in DAX

Regards,

Free Windows Admin Tool Kit Click here and download it now
August 29th, 2015 6:14am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics