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.
I'm running into a similar issue and can provide you with a use case. I'm making a workbook to summarize data for a single customer so our Customer Service reps can work with them while on a call. I have millions of customers, all with multiple bills, multiple services we offer and multiple other data points that need included in said workbook. Pulling all the data for all the customers is extremely slow and caching is not even an option as it's too much data. The Semantic modeler seems to be the answer, but it's a lot more work to set it up than a dataset…
This sounds like more of a filtering situation than a security situation. The filters you set on a canvas or chart will be passed down to the queries. I would recommend having a required parameter such as customer or account and when it is not set, you will just see blank charts.
has a walk through.
Hi @Henrikues
With that much data I would suggest building it into the semantic model. This will enable you to pre-calculate the results rather than it being done at runtime.
Personally, I have always considered the dataset capability to be more for self service exploration and proof of concept work to prove the value of adding data before creating a governed model in the semantic modeller.
That's what I need to do... I built in Classic / BIP for now as it's a lot simpler to build even though it's rather limited for the users as far as functionality goes. When I load all of the data in dataset, I get the error below when trying to make visuals: State: HY000. Code: 43121. [nQSError: 43121] Max Row Limit Exceeded (HY000) Thanks for the reply, I'll proceed with the Semantic Model!
State: HY000. Code: 43121. [nQSError: 43121] Max Row Limit Exceeded (HY000)
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
I tried the following expression and it blows up when I select more that one value in the list see image
We are using Oracle Analytics Server 2026 with WebLogic Server 14.1.2. Our Account Statement report is accessed through '/xmlpserver'. We need to capture the following details in the OAS/Publisher log files whenever a user runs the report: Username Report name and path Report execution timestamp Account Number From Date To…
We need to download a report with the order number as the file name. In the main report, we have a data action (hyperlink) on each order number. When we click an order number, the linked report is downloaded with the corresponding order details. Currently, the file is downloaded using the report name. We need to download…
Hi all I work in UK healthcare across 30 hospitals nationwide, and we're currently reviewing our Oracle estate and roadmap. Part of that is deciding whether to make a case for investing further in Oracle Analytics Cloud for workforce reporting, or whether OTBI and our existing tools are enough for now. Our HR data sits in…
