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