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?
it works OK if i use detail filer :(
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?
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
Thank you all for help!!
I solve this probem ;D
For the sake of those reading this in the future, it would be good form to provide details on your solution.
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
and in Report studio in expresion like Total([*count distinct measure*] within set) need use
Aggregate instead Total : Aggregate([*count distinct measure*] within set)