Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MultiDataProvider Specific Measures

Hi All,

I have an tricky requirement below:

I have merged common dimensions dim1,dim2, dim3 from three bex queris as one.

Now i have below where Products belong to query 1 dataprovider name,  Services belong to query 2 dataprovider name..

dataprovider([Query1].[Dim1]) = Products

dataprovider([Query2].[Dim2]) = Services

dataprovider([Query3].[Dim3]) = Support



Query/datpdr Name      Common Dimensions      Measures


Products query1          =   Dim1                          Sales Amt

Services query2         =   Dim2                           Sales Amt

Support   query3         =   Dim3                           Sales Amt



My reports has to display 2 columns consist of one merged dimensions and dataprovider specific measures as measures cannot be merged:



Merge(Dim1+Dim2+Dim3)       Products query1.SalesAmt

Merge(Dim1+Dim2+Dim3)       Services query2.SalesAmt

Merge(Dim1+Dim2+Dim3)       Support   query3.SalesAmt


In Screenshot:




Apperciate your help.

Thanks,

Dinya.






replied

Hi,

try this.

in the measured columns put objects like this.

=query1.SalesAmt+query2.SalesAmt+query3.SalesAmt

See attached screenshot.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question