Look up on dimension
Posted: Thu Jun 03, 2021 11:39 pm
Hi,
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.
Thanks,
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.
Thanks,