1 Reply Latest reply: Jan 21, 2014 7:44 AM by Francisco Amores RSS

    Can Drill-through functionality breakdown aggregated members?

    atsoi

      Hi All,


      I am currently looking into the drill-through functionality integrating a Hyperion Planning application with ERPi, drilling back to a PeopleSoft Ledger.

      For example, if I have an aggregated member in a custom dimension (e.g. Product);

       

      Total Products

      - Product 1

      - Product 2

       

      Through an FR report showing Total Products, when I perform a drill-through, will this be able to separate Total Products into Product 1 and Product 2 level?


      Thanks

      Aaron

        • 1. Re: Can Drill-through functionality breakdown aggregated members?
          Francisco Amores

          Hi,

          it will not separate it.

          Let's say that you loaded data to Product 1 and Product 2, then they were aggregated in Planning.

          If you drill from Total Products, ERPI will not find any intersection for Total Products as you were not loading data to that intersection.

          You will be able to drill-through from Planning to the intersections you loaded data with ERPI (intersection for Product 1 and Product 2)

           

          Think of drill-through as passing the intersection details from Planning back to ERPI. If ERPI does not find that intersection, it will show an error.

           

          HTH