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 aggregation order

Started by en1, 06 Jul 2016 04:20:26 PM

Previous topic - Next topic

en1

Hi!
In framework i made fact as count(distinct ID)
in Report Studio i need count this with filter set days [2016-01-01] [2016-01-02] [2016-01-03]
cognos calculate sum of count distinct each day but i need apply this filter and after that calculate count distinct
what is wrong?



en1

it works OK if i use detail filer :(

bdbits

Not a lot of information to go on here...
Is your FM model DMR?
Is the filter against a time dimension?
How did you create the non-detail filter in your report?

en1

DMR model, measure as count(distinct ID)
when i use slicer in RS with  set days [2016-01-01] [2016-01-02] [2016-01-03]
measure calculates as sum of count distinct for each day

en1

Thank you all for help!!
I solve this probem ;D

bdbits

For the sake of those reading this in the future, it would be good form to provide details on your solution.

en1

the problem is that i use regular aggregation SUM and expression count(distinct id) in measure
instead i use ID in expression and regular aggregation count distinct and this works OK

en1

and in Report studio in expresion like Total([*count distinct measure*] within set) need use
Aggregate instead Total : Aggregate([*count distinct measure*] within set)