Skip to Content
Former Member
Nov 23, 2008 at 04:34 AM

Top N condition in hierarchy


I have a typical requirement where I have attached a Factory hierarchy to MRP controller infoobject . This MRP controller is part of my inventory cube characteristic. Now when I create a query I would liek to display the top 5 factories with max inventory. Factory is a hierarchy based on MRP controller grouping. I find that after attaching the condition to MRP controller the TOP5 FACTORIES in the hierarchy do not appear. System shows all the factories.

Please let me know if conditions can be applied to hierarchy or not. Is there a workaround


V Prabhakar