TM1 Forum

I was wondering I have 1 cube as a data entry wherein he can drop down months as a picklist then filters the number of days available in a month to determine the date to be used.

I need to create a reports of all items for all hierarchy that chose the date. Is it possible to make the String value from another cube as reference to the reporting cube.

Can I for example do this:
['Cost']=('cube1',dimension1,dimension2, dimension3,'2012-|MONTH('cube1',dimension1, dimension2,'DateUsed')|DAYS('cube1,dimension1,dimension2,DataUsed),'Cost']).

Any suggestion on this approach...its a lil different approach to TM1 from planning. This is just what I could think of rather than providing a long drop down list as a dimension.

Technically, that's a valid rule IF
1) '2012-|MONTH('cube1',dimension1, dimension2,'DateUsed')|DAYS('cube1,dimension1,dimension2,DataUsed) evaluates to a string value AND
2) there is an element in the next to last dimension of cube1 that equals the string from above