MultiDataProvider Specific Measures
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
Apperciate your help.