Is there an easy alternative to DistinctCount by using an ActivePivot Post processor

Question

I have a slow MDX query that does the following:

WITH MEMBER Measures.DistinctCode as 'DistinctCount({[CODE].Children})'
SELECT 
NON EMPTY Hierarchize({DrilldownLevel({[DATE].[ALL].[AllMember]})}) ON ROWS,
NON EMPTY Hierarchize({DrilldownLevel({[SYSTEM].[ALL].[AllMember]})}) ON COLUMNS
FROM [CUBE]
WHERE ([Measures].[DistinctCode])

How could I write a post processed measure in ActivePivot that returns the same as my Distinct Count calculated member? I imagine this would be a lot faster?

Thanks

Possible duplicate of [How can I create a "distinct count" measure with ActivePivot](https://stackoverflow.com/questions/23412641/how-can-i-create-a-distinct-count-measure-with-activepivot) — Benjamin Amelot, Jun 15 '18 at 14:50

Antoine CHAMBILLE · Accepted Answer · 2012-11-29T15:40:35.307

1

Have you looked at the LeafCountPostProcessor that ships out of the box in the open-source activepivot-ext artifact?

com.quartetfs.biz.pivot.postprocessing.impl.LeafCountPostProcessor

edited Nov 29 '12 at 15:40

answered Nov 29 '12 at 15:33

Antoine CHAMBILLE

1,676
2
13
29

Is there an easy alternative to DistinctCount by using an ActivePivot Post processor

1 Answers1