TM1 Forum

I'm attempting to create a cube that users can input data to, it's a mix of numeric input and text input. I've mocked it up below MixedTextandNumeric.PNG The dimension displayed on the rows with elements 'Source' through to 'Deal100' has Source formatted to allow a pick list of Country. The dimensio...

Thanks Tomok, I'm interested in your second solution but not clear if it's appropriate. Here's what I'm trying to do My cube is a Profit and Loss cube which is dimensioned by P&L, Month and Versions (Versions with the rule you fixed). I have another two dimensional cube called Calendar where the...

Still a newbie I have a dimension of Versions that contains numeric items 'Rolling Forecast', 'Forecast', 'Actual' and a string item 'Act/For Flag' that contains either the word 'Forecast' or 'Actual' My rule is testing for the 'Forecast' or 'Actual' and depending on the result makes 'Rolling Foreca...

Thankyou all for informed and quick replies, as an aside and probably talking in ignorance could the first question be done with TI ?

I'm very new to TM1 but have done the IBM 5 day training, but obviously wasn't concentrating enough. :?: I have a cube called Sales_Margins dimensioned by Months, Countries, Versions, Products and a measure called Sales_Margins. One item in the Sales_Margins dimension is called Volume. I want to pas...