I have created a cube with fact table view which has joined with total hierarchy, created share dimensions work fine
then created a second cube of raw materials with fact view joined on with total hierarchy works fine
now created a virtual cube combining both. say for example i need to display total power consumed(from first cube) for the raw material crushed on for particular day for the hierarchy.
both actual fact table has the field in common is the last field in the hierarchy table
In virtual cube the analysis work fine for the parameters of individual cube, but when i tried to do cross analysis (fact1 to dim 2 or viceversa or dim1 dim2 fact1 fact2) it's not working
Thank u for ur time