Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Essbase descendantas reporting using OBIEE similar to HFR
Hi
I have question about OBIEE reporting with Essbase Data source connection. We are aware of that using HFR, we can select a member and apply a function like Children, or descendants to it, so when the report open, it gets all the members underlying under the selected member.
We can even allow the users to choose member at run time and let the report display data to that member at lower level (level 0) .
Is this similar functionality possible in OBIEE? i see we have prompt where user can choose a member from dimension, however it only fetches the data what is present in result set.
How can I create a report in obiee, where users chooses a member from a dimension, and then report displays the data for all the level 0 members of it, instead just showing the data for the member selected.
Answers
-
Yes, possible. You can use Evaluate . Look at this blog ...
Oraculam: OBIEE: Generate Level 0 members dynamically for an Essbase upper level member
In the blog you will see how you can generate level 0...in the same way you can also generate children ...
For children , you can use
EVALUATE('Children([@{presentation variable}{default}])/*%1*/' ,"table"."column")
Once you have list of values (children or level 0) use that report in main report filter with 'based on another analysis'
0 -
Thanks, I am newbie to OBIEE, i see this blogs says that pass the base member to a relational data source to pull its children/descendants. Do i need to build any relational db model with essbase metadata in OBIEE for that?
In OBIEE, one can actually connect to Essbase to get the metadata information and then pass it to relational database with the help of OBIEE feature "is beased on another Analysis"
0 -
look at solution 1 or solution 2 section ...you don't need relational database.
It talks about all the different ways you can get the children of a particular member.
0 -
Thank you. Let me explore them. Appreciate your help.
0 -
Hi,
You can maybe also explore prompts on hierarchy, they allow to play with hierarchical relationship of members in a dimension.
They work in a slightly different way than normal prompts as it isn't a filter in the analysis but you set in selection steps that the hierarchy is prompted.
0 -
hi Gianni, Yes i was exploring that today. It pulls the level 0 members for the base member i select from prompt, for which i already have done "New Hierarchy Selection Step",
My challenge is that how can i dynamically pass the selected member from prompts to selection step? When working on selection steps I don't see anything like use it from prompt or /any variable
0 -
The idea is to have the hierarchy as prompt, so you don't pass a member to the selection step but you pass directly all the selected items. And inside the prompt you play with the hierarchy to get what you need.
(Let's be honest: HFR was really good in these things because that was its job, OBIEE is a generalist universal analytical platform, so it must be good with everything and not just cubes)
0 -
OBIEE hierarchical prompt is rudimentary and hardly usable. One of the main issue is that it starts at generation 1 even when you have specific value selected. Most of the cases essbase hierarchy is deep and starting at the top is not an option.
0 -
That would be great if i can get the entire hierarchy in prompts. When i tried that, I see all the members of dimension are flatten and was not showing the typical Essbase like hierarchy.
However even If i can get hierarchy in prompts, Can i make selection of a member and its children with a single click of check box, or do i have to select each and every member from hierarchy?
Its may not be acceptable for users to select each member what they want to see in report, rather prefer selecting just the parent/ anscester they want to see the data underlying data.
thanks
0 -
Hierarchical prompt only works with hierarchical columns.
you need to use hierarchical column in the prompt with a presentation variable and then in the selection area of hierarchical column you need check override with presentation variable.
0
