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
Measure specific to specific dimensions in a cube
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Measure specific to specific dimensions in a cube
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.manu0521 wrote:But in cognos you can directly assign value to a level with respect to a measure,
Is this possible in TM1 ?