This discussion is archived
2 Replies Latest reply: Feb 4, 2013 1:20 PM by Ganesh A Moovera 25 RSS

OBIEE 11.1.1.6 Paretto Chart drill down

Ganesh A Moovera 25 Newbie
Currently Being Moderated
A Pareto chart when created using OBIEE 11.1.1.6 drills down to the incorrect hierarchial map. This was a bug with OBIEE 10g:

BUG:8769813 - DRILL DOWN IN PARETO GOES TO WRONG CHILD
NOTE:517727.1 - pareto charts

It was originally an issue with the use of Corda charts. This was supposed to be fixed with the move to OBIEE 11g but it does not seem to be so in our case, since we encounter the same error.

Original OBIEE 10g error: https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=738674755173621&id=1200914.1&_afrWindowMode=0&_adf.ctrl-state=k53hrt132_215

I will look around on the forum, but any insight would help
  • 1. Re: OBIEE 11.1.1.6 Paretto Chart drill down
    Ganesh A Moovera 25 Newbie
    Currently Being Moderated
    I will try and explain the sequence of occurances on an Oracle "Sample Sales Lite" analysis, in case it needs to be recreated.

    It is a very simple analysis using the “Sample Sales lite” subject area provided by Oracle. The criteria is just company from within offices as the dimension and revenue from within base fact as the fact.

    The typical hierarchial drill path for the “Company” dimension within offices as per the RPD definition is Company > Organization > Department > Office.

    When viewed as a table this drill path works perfectly fine. When we represent the same as a Paretto chart, on clicking on “Stockplus Inc”, the output drills down to a breakdown of "Genmind Corp" instead. This is the same when viewed as an analysis and on a dashboard.

    I have seen similar occurances with bubble charts as well. Do let me know.
  • 2. Re: OBIEE 11.1.1.6 Paretto Chart drill down
    Ganesh A Moovera 25 Newbie
    Currently Being Moderated
    Another interesting pointer is that this is not always the case. Certain combinations of fact-dimensions work just fine and this discrepancy is observed with just certain combinations. I am unable to decipher why this is so.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points