1) Always maintian aggregates for the info cubes in the multi provider.
2) Try to use the info object 0INFORPROV and maintain the info cube names ( Usually a query on multi provider with even 10 cubes uses 1 or 2 info cubes.you cantrace it in ST03N or RSRT)
3) Analyze the query on multiprovider through RSRT transaction and use "multi-provider" explain to identify the characteristics on which a logical partition can be made. ( partition can be done by maintianing table "RRKMULTIPROVHINT"
very good article on this :
how to create efficient multiprovider queries
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment