For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Is oracle database express edition XE 19c available? If not, when will the release date be?
Hey Ebin,
Yes Ago function works from Answers too. You need to ensure you have the Hierarchy Tree pulled in to answers to do this calculation and reference the "level" with right level of field.
In the example below the level would be "Time"."Time"."Year".
It depends on your business model, can you check the query behind
Hi,
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' ;
OR
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 ?
Thanks
Ebin
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.