Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Filter based on a report in DV
Comments
-
Perhaps I'm not following Richa's instructions but I don't believe that will work the way we need it to, at least in OAS at this time. The issue is that we need the users to be able to select a specific filter value in one workbook, pass those filter selections into a second workbook that would then return it's results to the first workbook. We use this today in Answers to resolve one-to-many issues in data.
I need to somehow make the logical sql statement dynamic so that it passes in whatever values are stored in the filter prompt into the WHERE clause.
0 -
I believe that @Richa Singh Kushwaha's recommendations only apply more or less for static code.This does not replicate functionality from OBIEE classic (SI Classic Home)
Lets hope this is considered somewhere down the line for the DV Product Roadmap.
Though currently this feature is not yet planned as per official channels, link below.
https://community.oracle.com/products/oracleanalytics/kb/articles/32-product-roadmaps.
1 -
Sub queries from another reports are very commonly used one.
Many good functionalities in OBIEE is ignored in OAC DVs.
Finally Parameter functionality is came but it has limitation of 1000 results output using logical SQL.
0
