Hi, you maybe don't know that questions get more attention when some effort is provided in asking them.
Remember that nobody else can see your screen or know what you are thinking, trying to do and what you are working with. What you don't describe is unknown, and when there is too much unknown no reply is posted.
On a different point: don't you think a good practice would already be to avoid executing unnecessary operations?
CASE WHEN <something> is null THEN y ELSE n END = y : can you think of a more direct and simpler (= quicker) way to write that condition? Doing a IF-ELSE to then check for one of the values is a waste of time. You already know the condition as it's written in the IF-ELSE, so use that condition directly.
Now thinking at your error: an aggregate is not allowed in the USING clause of a FILTER operator. Is your "Workload (k$)" an aggregate? If it is, well, the message is explicit: it isn't allowed there. The USING clause only takes attributes, not aggregated measures.
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (ERP). The session will cover updates on Finance, Projects, and Procurement. Presented by: Ashlesh Bajpai - Vice President, Product Management, Fusion Data Intelligence Shobana…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
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
