TM1 Forum

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.

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);