Datafilters in OBIEE with Essbase cube data

Question

We have imported financial general ledger cubes into our repository that have account hierarchies pre-built. When we try to make analyses with them though, how does one get the filters in the analysis (or is this something that is accomplished in the repository) to work to show a pie chart that can give values from more than one account level. For example: we want a pie chart that can show the EBITA, a level 3 account, and 5 level 4 accounts only in the pi chart. Right now we do this with an "or" statement in the data filter and this makes all the level 4 accounts under level 3 EBITA in the pie chart while we only want these summed up and left as EBITA in the pie chart.

Gianni Ceresa · Answer

So you want all your number to be positive? Just edit your measure column and use the ABS function: ABS("Facts"."Balance")

bjbreitling · Answer

This is correct but now I have a new problem. The account values for the 5 account level 4 are negative. How would I go about changing them to positive and still have them display in the chart. I tried making a new calculated item that is 0- 'the account name' forthe 5 accounts in the level 4 and that seems to work but then EBITA doesn't show up in the chart any more. Is this some bug or something I don't understand?

Gianni Ceresa · Answer

Hi,

If you use the Account hierarchy you can simple use Selection Steps to replace the "Start with all members" by "Start with selected members".

And in the Edit Membership Step screen you can select members from different levels of the hierarchy and your analysis will display only these members and so your pie chart will display EBITA and your 5 accounts of the level 4 of your hierarchy.