TM1 Forum

Hi,

I have many dimensions in my cube like product ,region,goods,time, etc...

I have a measure population which is related only to my region dimension and time dimension.
That is for level in region dimension say state, I show a population with respect to a time.

So now I have to load only the population value to a level in a dimension and this level is not the lowest level.

Its like Region -> States ->Cities some thing like this and load the population for the intermediate level.

But as of I knew, in tm1 while loading data you need to mention values from all the dimension that the cube uses in the order specified,
But in cognos you can directly assign value to a level with respect to a measure,

Is this possible in TM1 ?

I appreciate your suggestions.

Thanks,
Manu

manu0521 wrote:But in cognos you can directly assign value to a level with respect to a measure,

Is this possible in TM1 ?

Short answer, no. You have to populate values at the leaf level in every dimension. Common practice for scenarios like yours is to add elements to each dimension that is for data not broken out at that level. For example, you may have an element called "No product", or "No customer", etc. When the data is not at the customer level you load it into "No customer". Extremely easy to do. Issue here is user training to make them aware that data in the cube is not always at the same granularity.