/scripts/ahub.form.attachments.js
0

EPMFORMATTINGSHEET - SAP IBP - TIMEPERIOD / PERIODID PARAMETERS MISSING

May 25, 2017 at 03:42 PM

199

avatar image
Former Member

Hi,

Let's say I want to format "Current and Futur Values" of an "PAST editable KeyFigure" on a Weekly TimePeriod (PERIODID4) when I have 6 PERIODID levels....it seems possible but I CANNOT find:

- "C" or "CF" in the "Value" Field in (for exemple) "Weekly" dimension

- "PAST" in the "Value" field of KeyFigure dimension

At the end, we want for exemple the following line to appear in EPMFormattingSheet:

KEY_FIGURES.Editable Indicator = PAST || PERIODID4.Past Current Future Indicator = CF.

Could you please tell me how to obtain this above?

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

Please see below my steps to achieve it:

1) GO in EPMFormatting Sheet -> Section "2-Dimension Member/Property Formatting" -> area "ROW" -> Click on "Add Member/Property" -> Select Member/Property appears -> click "Property Selection" Tab -> choose "Key Figures" as "Dimensions" -> Choose "Editable Indicator" as a "Property" -> Choose "=" as "Operator" -> Choose "Future" as a Value -> click "add to Multiple Selection"

2) Then once first step done, choose "Weekly" as "Dimensions" -> Choose "Past Current Future Indicator" as a "Property" -> Choose "=" as "Operator" -> Choose "F" for Future as a "Value"-> click "Add to Mupltiple Selection"

3) Click "OK". You should see a new line in the Row Section that looks like that: KEY_FIGURES.Editable Indicator = FUTURE || PERIODID4.Past Current Future Indicator =F.

10 |10000 characters needed characters left characters exceeded
Former Member

Anyone here?

0

You have to provide very detailed info and number of screenshots...

0
Former Member

Hello Chikhaoui, the following reference will help you with some suggestions to handle missing parameters of the sheet.

Reference : SAP Support

-Bhanu Prasad

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers

Skip to Content