Challenge in BEx reporting - combine two infoproviders

[lakshminarasimhan_n4]

Dear All

I have 2 DSO's and reports over the 2 DSO,

1st DSO Report:

                          costcenter1 costcenter2 costcenter3  

cost_element       amount      amount      amount

Costelement in rows & costcenter in columns ( query designer )

2nd DSO report :

                             project1     project2      project3  

cost_element       amount1     amount2     amount3

Costelement in rows & project in columns ( query designer )

Now user wants to combine these reports and presnt the data in single report in the structure given below,

                          costcenter1 costcenter2  costcenter3   project1     project2      project3 

cost_element       amount      amount         amount        amount1     amount2     amount3

Now i am able to combine the data using Multiprovider and Infoset, but i am unable to bring the data in the structure requested by the user because,

• I am unable to split the keyfigure between the costcenter and project, always the KF's comes under one structure only.Please see the screen shot attached
• Also when i include both costcenter and project in the columns, project comes under the costcenter which is not desired as per the layout suggested by the user.

Is there any way out? Please help me gurus.

[Former Member]

Hi Lakshi,

As per my experience, you should not try to do heavy stuff in queries! It makes queries slow and break as well!

Why don't you create new DSO/Cube ans create structure as below:

Column1                       Column2            Column3

CostElement 1              CostCenter1        Amount

CostElement 2              Project1               Amount

CostElement 1              CostCenter2        Amount

CostElement 2              CostCenter1        Amount

Use APD's to do complex calculations and do overnight process to populate this DSO/Cube!

Hope this helps!

Regards

Amandeep

[former_member209202]

Hi,
One approach can be, Keep both the queries individual and as the structure of the of colums are fixed in both the queries assign the second query in BEX analyzer after the last column of the first query.

In this case the column "COSTELEMNT" will be repetitive and but you can use another tab in the analyzer to keep the common cost elements out the both individual queries, if required.

Let me know, if you have understood my explanaton.

Regards
Sourav

[lakshminarasimhan_n4]

Dear Sourav,

I have not understood your explanantion please give me in detail. Thanks.

[Former Member]

Hi - What you are expecting is NOT POSSIBLE to achieve

Workaround will be to have

1. 2 Queries and have both in one Web template. Show them one below the other

2. Use the same structure, and request user to use "Swap option"..so at any time he/she can see either cost center or project

[lakshminarasimhan_n4]

any thoughts gurus?