Issue with Periodic Calculation for April Month

[former_member225135]

Dear Experts,

I am facing an issue with periodic calculation. Periodic measure works fine for all months except April.

I have even copied the periodic formula from delivered environment shell

Formula for Periodic Measure:

MEMBER [MEASURES].[YTD] AS 'IIF(([%C_ACCT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC" OR [%C_ACCT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ"),-([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])), ([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])))' SOLVE_ORDER=3

MEMBER [MEASURES].[PERIODIC] AS 'IIF(([%C_ACCT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC" OR [%C_ACCT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP") AND NOT ([%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="TOTAL" OR [%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="Q1" OR [%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="JAN" ), [MEASURES].[YTD]-([MEASURES].[YTD],[%TIME%].LAG(1)), [MEASURES].[YTD])' SOLVE_ORDER=3

System is calculating Periodic values of April by subtracting YTD April & YTD March.

Time Dimension Looks this:

Even the Total of all the months are getting populated on 2015.TOTAL

VERSION:

BW :SAPKW74013

BPC: SAPK-81008INCPMBPC

Regards,

Rahul Periwal

[former_member186338 · Accepted solution]

Hi Rahul,

First table is completely unreadable, please use screenshot or table in the advanced editor!

Second - please show all months of the year, starting from Jan. And on the screenshot clearly show the value with issue.

What is the model default storage type - YTD or Periodic?

Vadim

OK, Now I can see that the cube is YTD

[former_member186338 · Accepted solution]

Ups, looks like your fiscal Year starts from Apr!

Can you show TIME dimension members as list, not as hierarchy?

[former_member225135 · Accepted solution]

Hi Vadim,

Sorry for late reply.

Model is YTD.

I have attached  the Time dimension as list for Year 2015.

Fiscal Year starts from April

Regards,

Rahul

[former_member186338 · Accepted solution]

In PERIOD property you have to use fiscal month id's, not calendar!

2015.APR - JAN (not APR!)

...

Vadim

[former_member186338 · Accepted solution]

If you need calendar month ID in your reports you can create a new custom property like CALPERIOD and fill it with APR for 2015.APR etc...

[former_member186338 · Accepted solution]

P.S. Don't change PERIOD in the MEASURE formula, use standard CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="JAN"

[former_member225135 · Accepted solution]

Hi Vadim,

I have not changed the formula. I have updated TIME dimension only.

Regards,
Rahul Periwal

[former_member186338 · Accepted solution]

And now you have correct result in April? Then close the discussion!

[former_member225135 · Accepted solution]

Yes.

[jrg_finster3]

Hi Rahul,

and I think you have a Problem in understanding accounttypes in BPC

In your case the account you mentioned is defined as "INC" a P&L accounttype.

P&L accounts in periodic are always calculated as Month - previous month.

Normally accounts beginning wit "3" are used in the Balance sheet.

Try to configure the account as "LEQ" not "INC"

Helpful to understand accounttype Basics:

http://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=281773431

Regards

Jörg

[former_member186338]

But author model is YTD...

[jrg_finster3]

Thats right, they have YTD.

What did I explain wrong?

I like the 3 Points respect.

Regards...

Jörg...

[former_member186338]

In YTD model P&L accounts are also YTD!

P.S. In YTD there is no difference between P&L and BS accounts calculation...

[jrg_finster3]

Thats true, never said that they are not.

The thread opener ask for a result in PERIODIC that he does not "understand".

Even in a YTD model the P&L accounts are calculated as Prior month - Month as you can see in the measure formula for periodic

you are right!

P.S.

you got me discussing again. sorry

You are right!

[jrg_finster3]

Hi Rahul,

in your Formula you see "JAN" as hardcoded member try to change this with "APR"

OR [%TIME%].CURRENTMEMBER.PROPERTIES("2/CPMB/PERIOD")="JAN" )

Your formula is only valid for a year structure beginning with January.

Regards

Jörg

[former_member186338]

Hi Jorg,

"Your formula is only valid for a year structure beginning with January." - incorrect if 2015.APR has PERIOD property set to JAN (and it's a correct setting)

Vadim

[jrg_finster3]

yes you are right,

Sorry i am sure they have set the property to JAN in April.

Thats for sure why April is calculated as  Mar-Apr. Because period is set to JAN in Apr...

My fault. Sorry that i wanted to help. I will stop that in future...your Forum again.

Regards

Jörg

[former_member186338]

I am not sure how the TIME dimension was configured, that's why I asked topic author to "show TIME dimension members as list"