Hii OCA Community…..In direct dataset creation there is option for Manual/custom query . But in Semantics model ,we couldn't find this option .Can anyone pls advise how to create tables using Manual/Custom query in Semantics Model .Thank you.
Hi,
You just change the source of your physical table from "Table" to "Select Statement", and then enter the query in the columns tab.
This is your database SQL language, not LSQL or things like that. You should also consider to create a view in your database directly, this would give you a better auditing and tracking instead of hiding business logic into the select statement behind a physical table in your model.
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.
