It depends on your business model, can you check the query behind
If I create a measure in the RPD for the formula COUNT(DISTINCT "Transaction Details"."Document Number") and use that column in the analysis, AGO works fine. But when I try to do count distinct in answers, it is not working and just displays the same value as shown in the above screenshot.
This seems to be a defect in 12c. I faced the same issue and Oracle Provided a workaround to fix this.
You can add one of the below in the Advance Tab --> Prefix
SET VARIABLE OBIS_REDUNDANT_DISTINCT_OPTIMIZATION = 'DISABLED' ;
SET VARIABLE OBIS_REDUNDANT_DISTINCT_OPTIMIZATION = 'LEAF_ONLY'
My issue is not related to distinct. It is with using formula in AGO in report. I face the same issue even if I just use count instead of count distinct.
Just want to confirm if there is any restriction on measure that it should be defined in the RPD ?
1 person found this helpful
Check this SR 3-16820476571 I created for the Ago issue.
Bug 26642083 was reported in 12c version. I dont think you need to do anything specific in the RPD for Ago function to work.