Published on InterSystems Developer Community (https://community.intersystems.com)

Home > How to get the total sum of accounts until a certain date?

Question
Blaise ZARKA · Jun 8, 2016

How to get the total sum of accounts until a certain date?

In DeepSee, having a customer account cube. The cube includes a time dimension AccountCreationDate.

How do you create a calculated measure to get the total number of accounts from the beginning to a certain date in abscissa ?

I tried many things including this:
AGGREGATE(%TIMERANGE([AccountCreationDate].[H1].[MonthYear].&[190001],[AccountCreationDate].[H1].[MonthYear].CURRENTMEMBER) ,[Measures].[%Count])

But I don't get the right result because the date in abscissa creates a filter on the first date.

I tried also with %MDX function, but then I loose the context for the CURRENTMEMBER.

#InterSystems IRIS BI (DeepSee) #MDX

Source URL:https://community.intersystems.com/post/how-get-total-sum-accounts-until-certain-date