I was wondering if anybody can lend me a hand. Since its a lil different linking planning with TM1.
I have a data entry cube where there is drop down dates. I need the value from this cell intersection base on the chosen drop down by the user to transfer to its respective date. I decided to create a TM1 cube exactly the same as the data entry cube except it has the date dimension. I was thinking if there's any way to define the dimension intersection to a string element. Cause I'm planning to do if the dimension date and the chosen date of the user is the same. Data should be transferred else it should skip it.
Other approach for a resolution to my problem would be very much appreciated. Thanks guys.
String reference to dimension
-
- Regular Participant
- Posts: 269
- Joined: Tue Apr 21, 2009 3:43 am
- OLAP Product: Cognos TM1, Planning
- Version: 9.1 SP3 9.4 MR1 FP1 9.5
- Excel Version: 2003
-
- Community Contributor
- Posts: 211
- Joined: Tue Sep 15, 2009 11:13 pm
- OLAP Product: IBMPA
- Version: PA 2.0 Cloud
- Excel Version: 2010
Re: String reference to dimension
Hi, hard to follow your paragraph but would you have an IF argument in either a rule or TI process
TI method could be like:
#source date format yyyy/mm/dd
myStartMonthN= stringtonumber(subst (s_DateS,6,2)
myStartYear = stringtonumber(subst (s_DateS,1,4));
IF(ATTRn('Month', myMonth, 'Month_Number') = myStartMonth & ATTRn('Year', myloadYear, 'Year_Number') = myStartYear);
TI method could be like:
#source date format yyyy/mm/dd
myStartMonthN= stringtonumber(subst (s_DateS,6,2)
myStartYear = stringtonumber(subst (s_DateS,1,4));
IF(ATTRn('Month', myMonth, 'Month_Number') = myStartMonth & ATTRn('Year', myloadYear, 'Year_Number') = myStartYear);
GG