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);
- 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?
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.