4 Replies Latest reply on Jan 21, 2013 3:32 AM by Turbokat

    Drill-down to multiple columns at same time

    e_macmill
      Hello,

      Is it possible to simultaneously drill down to multiple columns on the same level with one click? I have several attributes that the user will want to see together at all times, so I want to be able to drill from level1 to level2a,2b, and 2c with one click.

      Thanks,
      Elliot
        • 1. Re: Drill-down to multiple columns at same time
          Srini VEERAVALLI
          May not be but I would like to explore any options other than going with Navigation.

          If it feasible try create 2 reports, show 1st report to user onclick on column call another report which has all columns..
          • 2. Re: Drill-down to multiple columns at same time
            e_macmill
            Thanks for the reply.

            That's a shame. What would be the point of having the ability to select multiple display columns in a hierarchy level?
            • 3. Re: Drill-down to multiple columns at same time
              e_macmill
              Any other ideas out there?

              Thanks.
              • 4. Re: Drill-down to multiple columns at same time
                Turbokat
                This drilling down to all the levels may not be available with the OBIEE drill level based hierarchy feature OOTB but as an alternative you can try this at you DB level to create a hierarchy within you data using START WITH and CONNECT BY PRIOR to generate the parent->child levels hierarchy within the view instead of creating multiple hierarchical columns.

                Or may be you can try to create separate columns in a table for each hierarchy level. That table could either be in the database or be a logical one in the repository. For example:

                Level 1 Level 2 Level 3 Description
                1 2A 3A
                1 2A 3B
                1 2B 3A
                1 2B 3B
                etc

                You then create separate reports for each level, so one report has only level1 in it for this dimension, another report has levels 1 an 2 and a third report has levels 1, 2 and 3 etc.
                In each report you put an action link on the levels' cells so that if you click on them you drill up or down by displaying a new report with either less or more level columns.

                Hope this helps. Pls mark if it does.

                Thanks,
                SVS
                1 person found this helpful