cancel
Showing results for 
Search instead for 
Did you mean: 

Time Dimension - BPC 10 NW

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Vijay,

What is the storage type of your model?

What is the measure you are using while storing any data?

Former Member
0 Kudos

Hi Nilanjan,

The model is periodic, and I am using periodic measure while inputting data.

Thanks,

Vijay.

Former Member
0 Kudos

Hi Vijay,

Please check your model's Default.LGF and make sure u did not specify TIME  isatead of TIME_WEEKLY.

Regards,

Kalyan.

Former Member
0 Kudos

Hi Kalyan,

Actually, there is nothing in my Default logic file.  (All the more reason for me to not understand the issue).

Thanks,

Vijay.

Former Member
0 Kudos

Hi Vijay,

If you are having reference model Rate/Ownership, please ensure they too use the same time dimension.

Regards,

Kalyan.

Former Member
0 Kudos

Hi Kalyan,

I am not sure that fixed the issue.  Just to test it out, I created another rates model with the "TIME_WEEKLY" dimension and referenced the new Rates model to my model. 

The issue with the default logic still exists.  Any other thoughts?

Thanks,

Vijay.