4 Replies Latest reply: Sep 13, 2013 2:42 PM by 897863 RSS

    Drill through using Ragged Hierrachy from Essbase

    897863

      Problem Description

      ---------------------------------------------------

      I have a requirement to provide the drill through functionality after drilling down to the lowest level for unbalanced ragged heirrachy but the issue was that

      the lowest level grain was shared across different level. This we overcame in RDBMS by introducing skipped ( jumping the all leaf level to the last column) or Psedo balanced

      ( repeating the leaf level till the last column) and then using the Action link and providing the leaf level member as the parameter.

       

       

      But now the problem is we need to do the drill through in Essbase sourced cube in obiee where the heirarchy is ragged unbalanced and I cannot change it to skipped / psedo balanced.

       

      Pls. suggest how to achieve the drill through after drilling down to teh leaf level as the leaf level is shared acros sdiffernet levels.

       

      Regds