Skip to Content
0
Former Member
Apr 23, 2014 at 01:57 PM

calculated measures in Excel with MDX

273 Views

Hi

I have a calculation view with measures and dimensions.

What I'd like to do now are calculated measrues.

I need the MDX function PERIODSTODATE. I didn't find a way to implement that in HANA Studio.

therefore I thought I could use the Excel OLAP Tools to do that.

The MDX would look something like this:

-----------------------------------------

SUM

PERIODSTODATE

(

[Date_Calendar].[Date_Calendar].[(ALL)],

[Date_Calendar].[Date_Calendar].CURRENTMEMBER

),

(

[TimeUtility].[TimeUtility].&[1],

[Measures].[BalanceLC_Change]

)

)

-------------------------------------

What this MDX does, it sums up all values for the Measure from the beginning of the Date Dimension to the current displayed Date.

This doesn't seem to work though.

Any ideas?

Thank you

Lukas