on 11-26-2014 10:34 AM
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:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.