I have a query on Inventory management scenario on the multiprovider which includes 0IC_C03 and 6 others. When I am trying to execute the query it takes 2 r 3 mints to get populated with the GL Account Hierarchie and some keyfigure values.
When Iam trying to Swap GL/Account with Material(which is in the Free characteristics of the query) the execution takes around 2 -3 mints to populate but the moment when i deactivate the material hierarchy it takes around 30 mints to populate.
Can any one suggest the way to decrease the hierarchy de-activation time of materials..
For your reference iam giving the Query Design
Global Filters of the query are :
Company code hierarchy,
Valuation class Hierarchy
Movement type Hierarchy
Maaterial, Storage Loaction, Material type etc..
Some keyvalues , and other calculated keyfigures etc