Question:
Hi,
I need someone to help me...
This is the first year of BW usage in my company.
Up to now, there are only two users: me and someone from controlling area.
We're using reports from 0ECCS_C01, 0PCA_C01, 0CCA_C01, 0OPA_C11, 0SD_C03.
In these infocubes there are information since January/2003.
The smallest one is 0SD_C03 with less than 5000 entries.
The others has, on average, 500.000 entries.
I have some reports that takes more than 3 minutes to execute.
Is it normal?
Please help me.
If you have examples from your companies, please mention it.
P.S.: I'm using BW 3.0B SP8. My front end is Excel. The BW machine is very good (so,
Basis team think that is not a hardware problem, because BW is not using
50% of it's machine memory, processors, etc...) and so users computers.
Thanks,
Marllovy
Answer:
Try this
/forums/viewtopic.php?t=7980&highlight=rsrt+performance
Answer:
Marllovy,
If you have access to Sapnet, check out the Collective Performance notes:
Note 567745: DB specific Settings
Note 567746: Query and Web Performance
Note 567747: Extraction and Loading
_________________
Ciao.
AQ