4 Replies Latest reply: Dec 27, 2012 12:13 AM by Maqs-Oracle RSS

    Drill Report

    user13653962
      how can i create a drill down report ? if i have a summary column in Rows pane of OBIEE pivot , now i want to upon clicking this column i would have detail of this summary column.
        • 1. Re: Drill Report
          Srini VEERAVALLI
          You need to have Dimension hierarchy in your BMM to deal with this..
          Best doc is to read Admin tool help file for the same

          if not check these
          http://gerardnico.com/wiki/dat/obiee/drill
          http://obiee2go.wordpress.com/2012/06/06/obiee-11g6-drill-down-to-sub-reports-passing-multiple-prompts-values/

          If helps pls mark
          • 2. Re: Drill Report
            user13653962
            but the data which i drill is not of dimension , it is an another table data.
            • 3. Re: Drill Report
              Srini VEERAVALLI
              That is called as Navigation.
              Check this
              http://gerardnico.com/wiki/dat/obiee/navigate

              if helps pls mark
              • 4. Re: Drill Report
                Maqs-Oracle
                You have 3 options

                1> Create a dimension hierarchy. Even if the tables are different they can be part of same logical table. Like Country and State can be from different tables but you add these 2 tables in LTS and create hierarchy.

                2> Create a summary report and a Detail report. Provide action link from summary to detail report.

                3> Use Master detail link between summary and Detail report. You will have to keep Master and Detail reports in same dashboard.


                Thanks