Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Filter based on a report in DV
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
Comments
-
We were looking for similar option to demo to Executives.
0 -
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 ...
0 -
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.).
0 -
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.
0 -
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...
0 -
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.
0 -
@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
0 -
Hi
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!
0 -
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
1 -
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
0
