Skip to Content
0
Former Member
Aug 31, 2006 at 07:30 PM

Query executation taking somuch time

19 Views

Hi

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.

Thanks

Madhu