Is there a way to run 'Optimize Schema' on a cube using private dimensions?
The cube has a number of parent_child dimensions which have source table filters specified.
If I create the cube using shared dimensions and select optimize schema it works correctly and only the fact table is queried in the population of the cube.
If I create the cube using private dimensions it doesn't allow the optimize schema option to be run.
Building the cube generates a query that joins to all the dimension tables. As well as being slow the result is incorrect because the source table filters of the dimensions haven't been applied to the join (resulting in a 1 to many linkage).
Any ideas?
The cube has a number of parent_child dimensions which have source table filters specified.
If I create the cube using shared dimensions and select optimize schema it works correctly and only the fact table is queried in the population of the cube.
If I create the cube using private dimensions it doesn't allow the optimize schema option to be run.
Building the cube generates a query that joins to all the dimension tables. As well as being slow the result is incorrect because the source table filters of the dimensions haven't been applied to the join (resulting in a 1 to many linkage).
Any ideas?