Hi,
I am working on Dynamic Cubes and facing one issue. I have created two cubes based on similar structure. One is for Historical data and the other one for Incremental data.
Both the cubes have set of measure. I am facing issue with one measure. There is one calculated measure on fact ID in both cubes which has aggregation of Count Distinct. The individual cubes measures works fine using this aggregate. But when I add them in virtual cubes and try to apply the summary rule, I can't find the count distinct. And the result from both the incremental and historical cubes gets added and because both underlying cubes might have overlapping ID's, it gives wrong data.
Please guide. Thanks.