Skip to Content
0
Former Member
Nov 18, 2010 at 08:38 PM

BPC : Inception to date Measure ( MDX Formula )

38 Views

Hi

We have implemented SAP BPC NW 7.0 and we want to create a new measure for u201CInception to dateu201D, meaning from the very beginning till the current member. We have created the new measure using the program UJA_MAINTAIN_MEASURE_FORMULA through tcode SE38. But we canu2019t just find the right MDX formula. I have implemented this in BPC MS version successfully but the MDX code just doesnu2019t work in the NW version. Has anyone implemented a measure like this?

Here are the different MDX codes we have tried:

SUM(NULL:[%TIME%].CURRENTMEMBER,[MEASURE].[/CPMB/SDATA])

SUM({[%TIME%].CURRENTMEMBER.LEVEL.MEMBERS}.ITEM(0):[%TIME%].CURRENTMEMBER,[MEASURE].[/CPMB/SDATA])

Please let me know

Mubeen

Edited by: mubeen241615 on Nov 18, 2010 9:40 PM