Look up on dimension

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

Look up on dimension

Post by manu0521 » Thu Jun 03, 2021 11:39 pm


I have a master product diemnsion which has 20000 items in it . I am having a sales cube that uses that dimension.

I am planning to do a look up on this dimension on whicheve item has sales to add it to a new dimension , .

Should i have my dimension insert on meta data of the sales cube laod process.

I should get the hierarchy from the attributes of the main dimension , and also check if the parent is same and also check for the parents of the existing items.

Is there a sample code to do this on the meta data of the sales cube .I am not sure on how to move the existing items if their hierarchy is chnaged.


Post Reply