Input error

[Former Member]

Hi Folks,

Please  I want to put  the value of inventory for each last day of the month in the month ( wich is the parent) .

I have in the hiearchy time Day month quarter and year .

Here is the script i wrote but it's not working because we can not input a value in a parent , could anyone help me .

Thank you.

*XDIM_MEMBERSET KPI_EXTRACTION = EXTR0015

*SUB Inventory("D","M")

*WHEN TIME

*IS "D"

*REC(EXPRESSION = %VALUE%, TIME = "M")

*ENDWHEN

*COMMIT

*ENDSUB

Inventory(31.01.2015,2015.01)

Inventory(28.02.2015,2015.02)

Inventory(31.03.2015,2015.03)

Inventory(30.04.2015,2015.04)

Inventory(31.05.2015,2015.05)

Inventory(30.06.2015,2015.06)

Inventory(31.07.2015,2015.07)

Inventory(30.08.2015,2015.08)

Inventory(30.09.2015,2015.09)

Inventory(30.10.2015,2015.10)

Inventory(30.11.2015,2015.11)

Inventory(30.12.2015,2015.12)

Inventory(31.01.2016,2016.01)

Inventory(29.02.2016,2016.02)

Inventory(31.03.2016,2016.03)

Inventory(30.04.2016,2016.04)

Inventory(31.05.2016,2016.05)

Inventory(30.06.2016,2016.06)

Inventory(31.07.2016,2016.07)

Inventory(30.08.2016,2016.08)

Inventory(30.09.2016,2016.09)

Inventory(30.10.2016,2016.10)

Inventory(30.11.2016,2016.11)

Inventory(30.12.2016,2016.12)

Inventory(2016.12,2016)

Inventory(2015.12,2015)

[former_member186338 · Accepted solution]

A lot of required info is missing. Please read

[Former Member · Accepted solution]

Hi Vadim , Please you find the informations you asked for .

Thank you

1-

*SAP_BW    740    0009    SAPKW74009    SAP Business Warehouse

*CPMBPC    801    0009    SAPK-80109INCPMBPC    CPM Business Planning and Consolidation

2- After validating the script I did not get any error

3- I have  The Extractio Model, it contains  5 dimensions:

TIME:01.01.2015, 2015.01,2015.01,2015

KPI_Extraction:Inventory,.....

Version: Type C Contains , Forecast , Budget...

4-Default.LGF

5- I have an input form when i want to input data( inventory) in 01.01.31 and want to have in the parent wich is the month 2015.01 the same value and not the sum of all days .

6-

*XDIM_MEMBERSET KPI_EXTRACTION = EXTR0015

*SUB Inventory("D","M")

*WHEN TIME

*IS "D"

*REC(EXPRESSION = %VALUE%, TIME = "M")

*ENDWHEN

*COMMIT

*ENDSUB

Inventory(31.01.2015,2015.01)

Inventory(28.02.2015,2015.02)

Inventory(31.03.2015,2015.03)

Inventory(30.04.2015,2015.04)

Inventory(31.05.2015,2015.05)

Inventory(30.06.2015,2015.06)

Inventory(31.07.2015,2015.07)

Inventory(30.08.2015,2015.08)

Inventory(30.09.2015,2015.09)

Inventory(30.10.2015,2015.10)

Inventory(30.11.2015,2015.11)

Inventory(30.12.2015,2015.12)

Inventory(31.01.2016,2016.01)

Inventory(29.02.2016,2016.02)

Inventory(31.03.2016,2016.03)

Inventory(30.04.2016,2016.04)

Inventory(31.05.2016,2016.05)

Inventory(30.06.2016,2016.06)

Inventory(31.07.2016,2016.07)

Inventory(30.08.2016,2016.08)

Inventory(30.09.2016,2016.09)

Inventory(30.10.2016,2016.10)

Inventory(30.11.2016,2016.11)

Inventory(30.12.2016,2016.12)

Inventory(2016.12,2016)

Inventory(2015.12,2015)

7- Data like 7800

8-

#dim_memberset=0

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 0  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

NO RECORDS GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 0  RECORDS ARE GENERATED.

[INFO] GET_DIM_LIST(): I_APPL_ID="Extraction", #dimensions=4

TIME,KPI_EXTRACTION,MEASURES,VERSION

9-The script is not working.

[former_member186338 · Accepted solution]

"I have an input form when i want to input data( inventory) in 01.01.31 and want to have in the parent wich is the month 2015.01 the same value and not the sum of all days" - you can't store value in the parent! No way!

The parent value depends on the ACCTYPE and MEASURE:

For PERIODIC Measure and ACCTYPE INC/EXP - it's the sum of children

For YTD MEASURE for all ACCTYPE and for PERIODIC MEASURE for AST/LEQ - it will be the value of last children.

Vadim

[Former Member · Accepted solution]

Thank you so much Vadim for your reply , but why when I have AST or LEQ in the parenth  i don't have anything in the parent month or year it's  empty  ?

[former_member186338 · Accepted solution]

"but why when I have AST or LEQ in the parenth  i don't have anything in the parent month or year it's  empty" - the value in the parent is the value in the last children. If it's empty - then parent is empty.

Example:

29.01.2015 - 10

30.01.2015 - 15

31.01.2015 - Empty

2015.01 - Empty

P.S.

29.01.2015 - 10

30.01.2015 - 15

31.01.2015 - 17

2015.01 - 17

[Former Member · Accepted solution]

Absolutely  right , excuse my ignorance ,  but how could I put the last inputed  value  in the parent for ?

For example

till

29.01.2015 - 10

30.01.2015 - 15

i want in the parent  the value of 30.01.2015 even its not the last in the month?

[former_member186338 · Accepted solution]

"i want in the parent  the value of 30.01.2015 even its not the last in the month?" - not possible by design (look on the MEASURE formula!)

The only way is to copy value from 30.01.2015 to 31.01.2015!

Vadim

[Former Member · Accepted solution]

Thank you so much Vadim .