Hi,
We are currently migrating from Hyperion to OBIEE.
In Hyperion we were able to take the results of a query and then use that as the data source for another query. I am struggling at the moment to replicate this functionality in OBIEE indeed if it is even possible to do so ? I am aware of the filtering option “is based on the results of another analysis” but this is not the same as taking a set of analysis results then using these as the basis of another analysis. i.e. we need to be able to combine data from the following tables.
The way we did that in Hyperion was...
(1) Query Fact_USERACCESSLOGSTATUS for a certain list of users in Dim_USER.
(2) Using the query result from 1. we query Fact_DWH_USERS to add additional user information i.e. Users Manager and Team Leader etc required for the final report.
(3) Using the query result from 2. we query Fact_USERACTIVITYLOG to add the user activity logs.
(4) We now have single results table consisting of data from all the tables from which we can then build a pivot table report.
A similar question has been raised previously but not answered..
Answer based on another answer?
so I am trying to get a definitive answer on whether this is possible or not in OBIEE, or any alternative ways of accomplishing this.
Regards,
Tom Rowe.