Hello,
I used ABS formula → abs(qty)
Results for individual records are ok, but Grand Total is incorrect.
For example:
In RPD I have set → Aggregation SUM.
What am I doing wrong?
Please help me.
@User_BCACP -
If you want the absolute value of the total sum, update the measure formula in RPD → Logical Column as: ABS(SUM(QTY)) from SUM(ABS(QTY)) and then validate.
Hope this helps!
Hi,
I would say that what you see is correct, even if not what you expected.
You are facing a pre vs post aggregation behaviour: SUM(ABS(quantity)) <> ABS(SUM(quantity)).
Is this a measure you need often? If yes, I would definitely add the ABS in the column mapping between the physical and the logical layer in the RPD, and make that ABS Quantity column available next to the default Quantity column in the logical model and subject area.
I don't have an OBIEE 12c available, and in OAS 2025 is just does work as you would expect it (applying the expression before the aggregation).
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
How can you put a total number of records in your oracle OAC table footer
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.
