|
Hello,
I have a model for sales revenue where Sales Exec, Region, Products, Accounts, Version and Time are the DIMS with revenue, qty sold, margin are measures. I want to measure this activity against a pre-determined quota (ie, $1M) and wondering if anyone has approached this before. The quota is by sales executive over time (Annual and Quarterly). I don't think the sales excutive's quota would be broken dowwn by product, account, etc. I'm thinking that I would have a "quota" cube separate from my sales planning cube. Quota cube would have Time and Sales Exec as DIMS. Measure here would be Revenue. Not sure about including Version here as I see Quota as a static value. I could compare quota to sales (cube to cube) and enable Drill from quota cube to sales cube.
Thanks in advance for any feedback.
Tony |
|