TI process question - Mapping greyed out
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
TI process question - Mapping greyed out
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);
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);
- Attachments
-
- variables.PNG (20.28 KiB) Viewed 6146 times
-
- dataSource.PNG (21.78 KiB) Viewed 6146 times
-
- timeDim.PNG (13.77 KiB) Viewed 6146 times
-
- Site Admin
- Posts: 1457
- Joined: Wed May 28, 2008 9:09 am
Re: TI process question - Mapping greyed out
You have set all element 'contents' to 'other' (good idea IMO). Just write your own code above or below the (empty) generated code.
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: TI process question - Mapping greyed out
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...
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: TI process question - Mapping greyed out
I see what you mean, I'll give it a try in Prolog, thanks!
-
- Community Contributor
- Posts: 288
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: TI process question - Mapping greyed out
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.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"?
Reference:
https://www.ibm.com/support/knowledgece ... rator.html
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: TI process question - Mapping greyed out
Thank you so much!!
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: TI process question - Mapping greyed out
it worked, thanks both for your kind help!
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: TI process question - Mapping greyed out
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!
DIMENSIONSORTORDER('Monthss','BYINPUT','ASCENDING','BYINPUT','ASCENDING');
how can I fix the order so it appears:
01, 02,03....12?
thanks!
- Attachments
-
- Capture.PNG (44.71 KiB) Viewed 6132 times
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: TI process question - Mapping greyed out
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.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!
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: TI process question - Mapping greyed out
Thank you very much! I'll go read it now...
-
- Posts: 139
- Joined: Tue May 21, 2019 3:33 pm
- OLAP Product: TM1
- Version: PA 2.0.x
- Excel Version: 2016
- Location: The Internet
Re: TI process question - Mapping greyed out
Use the following code.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!
Code: Select all
DimensionSortOrder( sDimName , 'ByName' , 'Ascending' , 'ByHierarchy' , 'Ascending' );
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: TI process question - Mapping greyed out
It works now thanks everyone!!