Measure specific to specific dimensions in a cube

Post Reply
manu0521
Posts: 124
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: IBM TM1, Planning Analytics
Version: PA 2.0.5
Excel Version: 2016

Measure specific to specific dimensions in a cube

Post by manu0521 »

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
tomok
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

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply