Categories
- All Categories
- 14 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.6K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Be able to set a SQL for a default value in DV

Organization Name
Outfront Media Inc. (US)
Description
When creating reports in DV, we either have to set our filters as "all" or as one specific value for ex: market selection: Atlanta.
This causes many issues for our users as reports error out or they see information they are not suppose to be seeing, which could create individuals not trusting our data. What we would be asking for is to be able to set a SQL statement as the default value like we can do in classic.
Use Case and Business Need
We have a market selection filter so people look at the data by market. We either do not set a market which shows "all markets" or we have to select one market and alphabetically we have chosen Atlanta. Reason why this doesn't work is with our security either the users see everything with the all market selection and are seeing way too much data or if they don't have access to that defaulted market value such as Atlanta then the report errors out showing no data. This is not ideal when releasing reports to our entire business.
More details
We have created SR's for this and were told to change up our security model with creating joins to fact tables and that solution is not ideal for our business and will not working going forward. This is a huge issue that users keep complaining about and we would appreciate some action on this as soon as possible.
Original Idea Number: 8e41d10a20
Comments
-
There is already another idea concerning the enhancement of filters: https://cloudcustomerconnect.oracle.com/posts/22bb585802 and it seems like this is already planned for this year.
0 -
Good comments cited in the earlier post on the future of filters in DV. I agree completely that this should be a lot easier than it is right now.
Also wanted to mention that you can use expression filters in DV either in the filter bar or in a visualization. With expression filters you can write SQL, call session variables using a ValueOf statement, use a where clause, etc. There are all kinds of exotic things you can do with expression filters. Here is a link to some documentation https://docs.oracle.com/en/middleware/bi/analytics-desktop/bidvd/expression-editor-reference.html#GUID-17D67DA8-DE8E-4C05-9B9F-4D0244B263CA
See if you can get a hold of the init block SQL from the repository for the variable you're interested in and you may be able to repurpose in DV. Or, you may be able to call it directly.
0