Be able to set a SQL for a default value in DV — Oracle Analytics

Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Be able to set a SQL for a default value in DV

Needs Votes
51
Views
2
Comments

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

3
3 votes

Needs Votes · Last Updated

Comments