When using expression calculation error
When using expression calculation error，
filter(measure using filter_expr)
but filter_expr = 0.00 The expression is invalid
I can't read anything on your screenshot so I'll need to ask some follow-up questions:
a) Is what you are filtering really a measure?
b) What are you trying to filter the measure BY?
If you filter the analysis directly with your condition " filter_expr = 0.00 " does it work? Define the filter there to get the right filter and then move it back inside the FILTER.
Why are you writing 0.00 ? 0.00 == 0, it's just zero. Isn't you column maybe a varchar and so you need '0.00' ? That's why I suggest to define the filter as an analysis filter first to find out the exact syntax OBIEE accepts/wants for your condition.
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
