4 Replies Latest reply on Dec 27, 2012 6:13 AM by Maqs-Oracle

    Drill Report

      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
          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

          If helps pls mark
          1 person found this helpful
          • 2. Re: Drill Report
            but the data which i drill is not of dimension , it is an another table data.
            • 3. Re: Drill Report
              That is called as Navigation.
              Check this

              if helps pls mark
              1 person found this helpful
              • 4. Re: Drill Report
                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.

                1 person found this helpful