on 04-07-2010 9:41 AM
Hi guys
I have some questions about maintaining BI...I couldnot find answers for these....
1.How do we analyse if we have to do partitioning or not?(I came to know that SAP has some recommendations for this)
2.Whats the problem we face with aggregates on navigational attributes?
Thanks in adv foryour help...
Regards
Schand
Hi,
You can run an analysis in ST03N, where you look at the ratio between data the queries run through and the data shown. If you have high DB time, you can also look at aggregates. But try partitions first.
Also, check that data statistics are up to date.
For info on partitioning check:
http://help.sap.com/saphelp_nw70ehp1/helpdata/en/0a/cd6e3a30aac013e10000000a114084/frameset.htm
If OLAP time is high, you can check the queries in RSRT.
Br,
Sonni
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.