Skip to Content
0
Former Member
May 26, 2010 at 10:40 AM

Multiproviders and Hints - RRKMULTIPROVHINT

199 Views

Hi Dudes,

Can anybody help me with the "Multiproviders and Hints" and the table "RRKMULTIPROVHINT"?

I found a document [20 technical Tips and Tricks|http://www.comeritinc.com/UserFiles/file/tips%20tricks%20to%20speed%20%20NW%20BI%20%202009.ppt] in which the 1st optimization Tip is "Multiproviders and Hints".

I don't understand how to fill the table "RRKMULTIPROVHINT" mainly the fields POSIT & MAXOR.

Q: What are the values to fill in the table if you have a MultiCube with a logical partitionning by Time Period (2005 to 2010)?

Q: Is that optimization efficient if one has a logical partitionning by Year (for example) and one always accesses to the queries with Period and Company criteria?

Thanks in advance for your replies.

Samuel