Skip to Content
0
Former Member
Nov 29, 2006 at 09:26 AM

BEx Issue

67 Views

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