I have a sales cube and a stock cube that share a store dimension. The store dimension has some extra members for "phantom" stores that are used for storing stock which I don't want to be visible in the sales cube. For example so that they are not visible
I've tried to use security in combination with a role, but it makes it difficult to develop reports.
I've also created a specific stock location dimension and limited the store location just to "true" stores thus having 2 dimensions which works, but this then affects a cube I have that combines sales and stock.
Is there a better way to do this? For example can I do anything in the cube script?
View Complete Post