Hi
I need to build one query whose result should be like this:
Sales Region 1 Sales Region 2
Revenue
Costs
Logistic Costs
Revenue,Costs and Logistic Costs are based on CKF.
Sales Region 1&2 are based on Characteristic 'Sales Region' which is there in cube.My user wants to have an option where he can enter all Sales Regions he wish to see information for and he want to see each Sales Region in a seperate column as I showed above..How can I design this query...
Thanks alot.