nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Filter based on a report in DV

Swetha Cheerla

Organization Name

Verizon Wireline IT

Description

In regular OBIEE Answers , there is an option to filter the report based on the results of another analysis. BI Server generates a subquery and filters the data . Our Business users are looking for similar functionality in DV.

Use Case and Business Need

This feature is extensively used in answers today . Users want to visualize the data similarly in DV .

More details

We have few use cases where the report needs to be dynamically filtered . This is achieved today using the filter ( filter on results of another analysis) . These use cases cannot be achieved in DV.

Original Idea Number: 66cca02d43

Find more posts tagged with

Developers

Needs Votes

Status: Needs Votes

Comments

Lakshmi Sampath-Oracle

We were looking for similar option to demo to Executives.

gmigotto

There are to similar features now (the "use as filter" and the action) that relates to that, but probably don't do exactly what you're looking for ...

Costin Domozina

It would be good to also have the option to filter based on the values of a Column from a Data Set (External Data Sets, Local Subject Areas, etc.).

Greg Faris

We need this functionality to be able to handle subqueries that allow for queries where we have one-to-many relationships.

For example, we have customer orders that have multiple types of products associated with them. Users need to be able to filter dynamically to a specific product type and return KPIs based only on the orders that have that product associated with it. With DV, there's no way to subquery and if we inner join the tables, we would dupe the orders in our KPI calculations causing incorrect values.

There are other use cases as well such as linking disconnected datasets via a common identifier. Some of that may be more easily done through other methods, but both of these can be done with the Answers functionality mentioned above.

Luis E. Rivas -Oracle

Please review this video for a potential workaround and let us know if this allows you to accomplish the immediate requirement while we review a feature to address it. https://youtu.be/Ot3hnI1sIzY.

Oracle Analytics : How to Filter a Canvas on Results of Another Viz/Canvas

This video shows how to leverage a simple trick in expression filters (Self Service Analytics) to filter a canvas based on results from another visualization...

Sabine Kooman-Oracle

Hi Luis, thanks for the suggestion but this is a hard-coded and cumbersome work around. We would need the filter to handle changes in the underlying visualization automatically, not having to copy code around.

Michal Zima

https://community.oracle.com/products/oracleanalytics/discussion/comment/35303#Comment_35303

@Luis E. Rivas -Oracle The video from @Philippe Lions-Oracle is fine, but procedure described here has several "drawbacks" (compared to method used in "Classical" - filter based on result of another analysis):

1) It requires from author some "literacy" of logical SQL statements (which is not the case for all authors - this is simple reality....)

2) Logical SQL used for filtering must have all WHERE condition hardcoded (I can possibly, now refer Parameters here. but again this requires even more advanced authors) , as opposed to solution in "Classical" where analysis (hidden used just for filtering "main" analysis) can be filtered dynamically using dashboard prompts - everything in declarative way - no need to "boher" with logical SQL expertise...

So pls, consider those arguments when planning new features for DV (beside nice new augmented analytics stuff). Thanks

Richa Singh Kushwaha

Recently implemented such a requirement:

Created a variable using logical sql
Placed that variable in global filters
Capture the variable selection in another variable using logical sql.(This is the part where your calculation based on another analysis is taken care of)
Now you have this variable which hold the calculation based on the other variable which user is selecting from prompts
Use this variable to filter the data in your reports

Hope this helps!

Adrian Nedelcu-Oracle

https://community.oracle.com/products/oracleanalytics/discussion/comment/48916#Comment_48916

Hi,

Can you please provide some additional examples of how this was achieved in Oracle DV and what version of DV is your instance running.

The examples that would be appreciated are as follows.

Code used for creating the functionality and in what object the variable was created in (Workbook, LSA, DATASET, DATAFLOW).
Where were the Global Filters applied in Oracle DV. If they were done in a workbook was this a canvas filter or a viz filter. If this was another DV Object please specify object type from the list above.
How was the variable selection captured.

Ideally if you can please share your process in a simple video recording showing the performed steps.

Your help is greatly appreciated.

Thanks,

Adrian

Richa Singh Kushwaha

Hi Adrian

The variable was created in the 4th option F(x) section.
Global Filter can be applied in the top section of the Can or else you can also go for Dashboard Filter Visual.
Once we create a variable in F(x) Section its name becomes a place holder for the selected values, which can further be used in the logical sqls of another variable. It has a Syntax with which it is to be used.

Please let me know if this helps

Regards

Richa