TM1 Forum

Hello,

I'm trying to create a reporting cube for an Income Statement cube with different time dimensions. the source cube has one time dimension (please see attachment timeDim) and I need to split it into two dimensions: months and Year while skipping all YTD elements

I don't understand why Mapping is greyed out...(please see attached screenshot variables.png), is it because there is no measure dimension so no need to map? but I need to get to mapping to select "Create Cube"...

also I need to modify the codes under metadata to skip all YTD elements from conversion (metadata.png). I was taught during training that changing Contents to other will eliminate auto generated codes, but in this case the lines remain in there. can someone please let me know how to make this work? thanks so much for your time.

#****Begin: Generated Statements***
vMonth=SUBST(vTime,6,2);
vYear=SUBST(vTime,1,4);
#****End: Generated Statements****

IF(SUBST(vTime,1,3)@='YTD';
ITEMSKIP;
ENDIF;
vMonth=SUBST(vTime,6,2);
vYear=SUBST(vTime,1,4);

You have set all element 'contents' to 'other' (good idea IMO). Just write your own code above or below the (empty) generated code.

Thanks for replying, can you please let me know why Mapping is greyed out and how can I get to it so I can select "Create Cube"? this is literally the first time I'm doing something like this, please bear with me...

I see what you mean, I'll give it a try in Prolog, thanks!

lynnsong986 wrote: ↑Mon Oct 28, 2019 2:58 pm can you please let me know why Mapping is greyed out and how can I get to it so I can select "Create Cube"?

As David Usherwood said, it's because you have the Contents defined as "Other" in the variables tab. You'll want to change the contents to "element" and "data" for the variables that correspond to dimension element and data values in order to enable the mapping tab option.


Reference:
https://www.ibm.com/support/knowledgece ... rator.html

Thank you so much!!

it worked, thanks both for your kind help!

sorry one more question, somehow the months get sorted wrong (please see attached capture.png), the generated line:
DIMENSIONSORTORDER('Monthss','BYINPUT','ASCENDING','BYINPUT','ASCENDING');

how can I fix the order so it appears:

01, 02,03....12?

thanks!

lynnsong986 wrote: ↑Mon Oct 28, 2019 3:46 pm sorry one more question, somehow the months get sorted wrong (please see attached capture.png), the generated line:
DIMENSIONSORTORDER('Monthss','BYINPUT','ASCENDING','BYINPUT','ASCENDING');

how can I fix the order so it appears:

01, 02,03....12?

thanks!

Have you taken a look at the documentation for TI processes? Read the section about dimension maintenance and ordering. You want to set it to BYNAME, which means in alpa order.

Thank you very much! I'll go read it now...

lynnsong986 wrote: ↑Mon Oct 28, 2019 3:46 pm sorry one more question, somehow the months get sorted wrong (please see attached capture.png), the generated line:
DIMENSIONSORTORDER('Monthss','BYINPUT','ASCENDING','BYINPUT','ASCENDING');

how can I fix the order so it appears:

01, 02,03....12?

thanks!

Use the following code.

It works now thanks everyone!!