cancel
Showing results for 
Search instead for 
Did you mean: 

model periodic report ytd bpc 10 nw

michele_medaglia5
Active Participant
0 Kudos

Dear BPC Friends

I have a preiodic model

If I run a periodic report is ok but if I select ytd I have the following error:

Bad request.

Server message:

code: UJO_READ_EXCEPTION_018

severity: error

description: MDX statement error: Value 2014.APR 0HIER_NODE for characteristic /CPMB/E3D7QGZ unknown

log id: ziiy15vf7kITgl0jGm44{0

DATAVALUE:Value 2014.APR 0HIER_NODE for characteristic /CPMB/E3D7QGZ unknown

MDX:  SELECT NON EMPTY  {[/CPMB/E3DJ2VS].[NO_PC] } ON 0  from  [/CPMB/E3MM4MM/!!O/CPMB/E3MM4MM]  WHERE ( [Measures].[/CPMB/SDATA] ,[/CPMB/E3DH8F4                 PARENTH1].[CATEGORY_ALL                    /CPMB/E3DH8F4] ,[/CPMB/E3DYGFI                 PARENTH1].[CE_IMR_COSTE                    /CPMB/E3DYGFI] ,[/CPMB/E3DK2QI                 PARENTH1].[ALLCYCLE_PCA                    /CPMB/E3DK2QI] ,[/CPMB/E3DJ8RU                 PARENTH1].[TOTAL_FINANCE                   /CPMB/E3DJ8RU] ,[/CPMB/E3D26DN                 PARENTH1].[ALLFUNCTIONAL_AREA              /CPMB/E3D26DN] ,[/CPMB/E3DD9VY].[EUR] ,[/CPMB/E3DPSHO                 PARENTH1].[ALLOC_SKF                       /CPMB/E3DPSHO] ,[/CPMB/E3D7QGZ                 YTD_PARENTH1].[2014.APR                        0HIER_NODE] )

V1:Value 2014.APR 0HIER_NODE for characteristic /CPMB

V2:/E3D7QGZ unknown

V3:

V4:

Accepted Solutions (1)

Accepted Solutions (1)

lucas_costa3
Active Contributor
0 Kudos

Ops, it seems your time dimension is bugged.

Make sure your time dimension hierarchy is in order and properties such as TIMEID, LEVEL, PERIOD, YEAR... are filled.

Also, process the dimension and check your measure formula (T-code SE38 --> Program: UJA_MAINTAIN_MEASURE_FORMULA) - It should be like in ENVIRONMENTSHELL.

Cheers,

Lucas

michele_medaglia5
Active Participant
0 Kudos

Hi Lucas

We have checked and the formula it looks right:

What else we can try?

Thanks

'IIF([%COST_ELEMENT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC",SUM(PERIODSTODATE([%TIME%].[%TIMEYEARLEVEL%], [%TIME%].CURRENTMEMBER),-[MEASURES].[/CPMB/SDATA]),IIF([%COST_ELEMENT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP",SUM(PERIODSTODATE([%TIME%].[%TIMEYEARLEVEL%], [%TIME%].CURRENTMEMBER),[MEASURES].[/CPMB/SDATA]),IIF([%COST_ELEMENT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="AST",([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])),IIF([%COST_ELEMENT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ",-([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])),-[MEASURES].[/CPMB/SDATA]))))';SOLVE_ORDER=3

lucas_costa3
Active Contributor
0 Kudos

It seems alright indeed,

Did you check the time dim as I told you?

Also process the dimension.

Lucas

michele_medaglia5
Active Participant
0 Kudos

Hi

I have checked the time dimension and it looks ok

I can't process the dimension if I don't do any change

what else I could try?

lucas_costa3
Active Contributor
0 Kudos

Create a dummy property and save & process, after that delete the dummy property.

Lucas

michele_medaglia5
Active Participant
0 Kudos

good Idea

I tried and I have this error

lucas_costa3
Active Contributor
0 Kudos

Hi Michele,

Were you able to create property earlier or for other dims?

lucas_costa3
Active Contributor
0 Kudos

Because this error can be security in BW side, name space configuration...

Also, check the notes in this thread:

michele_medaglia5
Active Participant
0 Kudos

Hi

I tried to add a dummy properties in a different dimension and I have the same issue

I think because it is production system

So what could be the time issue?

lucas_costa3
Active Contributor
0 Kudos

Most probably to be a security issue.

Run an SU53 in BW after save the dimension in BPC and check if there is any red message.

Lucas

michele_medaglia5
Active Participant
0 Kudos

THANKS

THE ISSUE WAS DUE TO SOME GARBAGE VALUES IN THE DIMENSION TIME

Answers (0)