String reference to dimension

Post Reply
appleglaze28
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

String reference to dimension

Post by appleglaze28 »

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.
BigG
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

Post by BigG »

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);
GG
Post Reply