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)
Agenda Presentation: EPM Integrator connectors and Salesforce CRM Connector. Join us to learn more about the EPM Integrator connectors and Salesforce CRM Connector in Oracle FDI. We will explore the enhanced capabilities of the EPM integrator connectors and how you can load data from EPM modules to FDI to deliver a…
Hi! I am looking for audit logging for Analytics objects, such as users creating, modifying, or deleting datasets, dataflows, schedules, etc. The traditional Presentation Services component provides such logging in domains/oas/servers/obips1/logs/auditjson.log, which contains audit information for catalog objects,…
Hello Team, While building a Pivot Table view for my report, 2 out of the 4 metric columns contain completely null values. I'm looking for a way to automatically exclude or hide metric columns whenever they are entirely null or zero. Could you please advise on how to achieve this? Thanks.
I'm trying to index a Local Subject Area so I can use it in my AI Agent, however, I keep receiving the generic error below. Request status(500) : error = {"prefix":"DSS","code":50000,"message":"There was an unexpected error while processing this request. Please try again."}
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
