on 12-09-2009 10:38 AM
When activating the InfoCube 0TCT_C01 one gets detailed performance information about the navigational steps. If the value for TCTTIMEDM is very high, then one can check the database why the performance was bad. But what about TCTMEOLAP ? Is there any possibility to troubleshoot an unexpectedly high processing time of the OLAP processor? Or where could I find more detailed information?
Regards,
Mark
If you OLAP time is very high : check the following :
1. Check your run schedules in RSRT ( Debug mode )- this is usually DM time that is shown but worth a try
2. See if the query has exception aggregations - this slows query performance in terms of OLAp time drastically
3. Result rows
4. Filters in the rows / columns
5. Cell definitions
6. Excessive use of RKFs - if you are using RKFs - they are like Nested Selects
Some of them might be mandatory given the query result expected- but then if you can get some attributes out to free characteristics etc - this might give you a big boost in perfoirmance which can be used to see the changes to requirements to the end user...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.