BPC Measure to Display OPENING BALANCES

[Former Member]

Trying to generate custom measure (PER_OPEN) to display previous month into current month .  and Month 1 into Q1  and Y.

Example :

i have copied periodic measure into PER_OPEN custom measure and changes CLOSINGPERIOD to OPENINGPERIOD  but values are not populated as per expected results. is there any work around about this ?

Thanks,

Satya.

[former_member186338]

Ups, please read the description of MDX statements like CLOSINGPERIOD on the Microsoft site: ClosingPeriod (MDX)

The result can't be achieved by changing CLOSINGPERIOD to OPENINGPERIOD

What is the cube type? PERIODIC or YTD?

What is the logic for all quarters?

What is the logic for Half Year

Show the TIME dimension screenshot...

Vadim

[Former Member]

Hi Vadim ,

Model TYPE : PEriodic.

Currently we are getting PERIODIC values,user required new measure Per_open similar to attachment.

Thanks,

Satya.

[former_member186338]

You have shown the figures for INC/EXP Account types... What about AST/LEQ?

[former_member186338]

For base members you can use LAG(1), for Parent members - something more complicated...

[former_member186338]

For parents try something like:

CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%],[%TIME%].LAG(1))