Hi,
We have monthly budgets broken out by business segment (Commercial, Retail, etc). and market (states, like CA & MA). Each customer is associated to each:
Company 1 Commercial CA
Company 2 Retail CA
Company 3 Commercial MA
etc.
We'd like to do actual vs budget results in the cube. Is there a way to tie the budget measure group back to the customers using these two non-related attributes? I'm guessing I have to define an attribute relationship on the dimension that includes the two somehow.
Any help as to the best way to handle this would be much appreciated.
Thanks.