I have created query on Inventory Cube(Copied from 0IC_C03).
In cube maintainance i have changed the 'maintain non cumulative values' from calday and plant to only calday,
because to get the correct data on day basis
The query is based on material and vendor.
it is taking so much time like 50 min to execute.
I am thinking this is because of changing the 'maintain non cumulative values' in cube maintainance.
But if i don't do that i can't get the correct values.
Hope i explained the pbm very clearly.
can anybody help me on this issue.
I appreciate if anybody help me.