Skip to Content
0
Former Member
Jul 10, 2012 at 10:59 AM

Query logic

40 Views

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.