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
Hi @User_SYYDG
Curious on the use case for this one. Are you trying to restrict the dataset itself or just the output?
Generally, when creating a dataset you would load the whole set then add Workbook filters or dashboard prompts to restrict the output.
If you are trying to apply security to the dataset I don't believe this is possible.
One thing you could try is to create a Parameter on a workbook under the (x) tab of the data panel and then use that parameter in the sql so it would be something like WHERE A.SAAR_ID= @parameter("SAAR_ID")('').
Dan
A dataset is meant to be the same object for everybody, therefore there isn't a real concept of "passing a filter to the SQL query defining the dataset".
There is an exception that is meant to bring a feature a bit like row-level security in the semantic model: you can set dataset filters by application role. https://docs.oracle.com/en/middleware/bi/analytics-server/user-oas/use-role-based-filters-dataset.html
It is probably not what you have in mind anyway. Therefore your closest option is what Daniel mentioned above: you have a filter applied to the dataset when you use it. Of course this mean that your user can potentially get rid of the filter and have access to the whole dataset (and here is where the filter by application role plays a role as those can't be removed).
Depending on what you try to achieve, if it's for security reasons to not show the whole data to everybody or a functional/performance reason, your choice on how to implement what you need will be different.
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))
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.
