Dear All,
I am writing a query wherein I have to display the Sales District that come under Sales Division.
In this query I have to display Sales Actuals values of Sales districts under two heads - A districts and B districts.
For a sales district to fall under B, the condition these sales districts should fulfill is, Sales Commitment=0.
So, I wanted to know if I need to build this query over a multiprovider that will fetch me Sales Commitment values and also Sales Actuals (then put a condition on it) ? Or can I calculate the B districts through a pre-query (based on Sales Commitments cube) and then use it in a variable (replacement path) in the Sales query (based on Sales Actuals cube).
Thanks and warm regards,
SB