If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Count Distinct in Virtual Cubes

Started by AneeqAhmad, 05 Aug 2015 09:16:44 AM

Previous topic - Next topic

AneeqAhmad

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.