on 09-27-2013 8:23 PM
Hello Experts,
We have created a new model which uses a dimension called "TIME_WEEKLY" for the time-type dimension. However, whenever we send any data to the database using input forms, we get a message saying
Error running default logic ()
Invalid dimension "TIME" in model "XYZ".
Can you please help me understand the issue here? Do we always need to name the time-type dimension as "TIME" only?
Thanks in advance for all your help.
Regards,
Vijay.
Hi Vijay,
The problem is with the measures formula.
Go to SE38. Execute the program UJA_MAINTAIN_MEASURE_FORMULA. Ensure that in all the formulae, the name of the time dimension is denoted as %TIME_WEEKLY% (instead of %TIME%).
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nilanjan,
Thanks for the response. However, I believe the measures formulas are set up correctly. Please take a look below:
PERIODIC:
MEMBER [MEASURES].[YTD] AS 'IIF([%ACCT_COPA%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC",SUM(PERIODSTODATE([%TIME_WEEKLY%].[%TIMEYEARLEVEL%], [%TIME_WEEKLY%].CURRENTMEMBER),-[MEASURES].[/CPMB/SDATA]),IIF([%ACCT_COPA%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP",SUM(PERIODSTODATE([%TIME_WEEKLY%].[%TIMEYEARLEVEL%], [%TIME_WEEKLY%].CURRENTMEMBER),[MEASURES].[/CPMB/SDATA]),IIF([%ACCT_COPA%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="AST",([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME_WEEKLY%].[%TIMEBASELEVEL%])),IIF([%ACCT_COPA%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ",-([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME_WEEKLY%].[%TIMEBASELEVEL%])),-[MEASURES].[/CPMB/SDATA]))))';SOLVE_ORDER=3
QTD:
MEMBER [MEASURES].[QTD] AS 'IIF([%ACCT_COPA%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC",SUM(PERIODSTODATE([%TIME_WEEKLY%].[%TIMEQUARTERLEVEL%], [%TIME_WEEKLY%].CURRENTMEMBER),-[MEASURES].[/CPMB/SDATA]),IIF([%ACCT_COPA%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP",SUM(PERIODSTODATE([%TIME_WEEKLY%].[%TIMEQUARTERLEVEL%], [%TIME_WEEKLY%].CURRENTMEMBER),[MEASURES].[/CPMB/SDATA]),IIF([%ACCT_COPA%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="AST",([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME_WEEKLY%].[%TIMEBASELEVEL%])),IIF([%ACCT_COPA%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ",-([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME_WEEKLY%].[%TIMEBASELEVEL%])),-[MEASURES].[/CPMB/SDATA]))))';SOLVE_ORDER=3
YTD:
MEMBER [MEASURES].[YTD] AS 'IIF([%ACCT_COPA%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC",SUM(PERIODSTODATE([%TIME_WEEKLY%].[%TIMEYEARLEVEL%], [%TIME_WEEKLY%].CURRENTMEMBER),-[MEASURES].[/CPMB/SDATA]),IIF([%ACCT_COPA%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP",SUM(PERIODSTODATE([%TIME_WEEKLY%].[%TIMEYEARLEVEL%], [%TIME_WEEKLY%].CURRENTMEMBER),[MEASURES].[/CPMB/SDATA]),IIF([%ACCT_COPA%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="AST",([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME_WEEKLY%].[%TIMEBASELEVEL%])),IIF([%ACCT_COPA%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ",-([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME_WEEKLY%].[%TIMEBASELEVEL%])),-[MEASURES].[/CPMB/SDATA]))))';SOLVE_ORDER=3
Any other thoughts as to why this is happening?
Thanks in advance for your guidance.
Best regards,
Vijay.
Hi Vijay,
Please check your model's Default.LGF and make sure u did not specify TIME isatead of TIME_WEEKLY.
Regards,
Kalyan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.