URGENT: Error with query on MultiProvider

[Former Member]

Hi,

I am designing a query on a MultiProvider that combines a cube and ODS. the common characterisitics in the cube & ODS are Material, fiscal period, country.

I have 2 rows & 1 column and several free characterisitics (mostly navigational attributes of Material).

Rows: KF1 (from cube) & KF2 (from ODS)

Column: Fiscal Period

I have done all the selections & Identification in the multiprovider and set the ODS for BW reporting.

I am not able to get data from ODS with query on MultiProvider.

And i need to add another row that calculates the product of KF1 & KF2. KF1 is sales quantity and KF2 is price identified uniquely by Material/Country combination. When we report at Country level wihtout any material selection the output revenue should be SUM of individual products between KF1 & KF2 (if there are 3 materials (A) sold that have a price of X and 2 materials (B) sold that have a price of Y, the answer should be 3X + 2Y instead of (32) * (XY)/2.

and also i have geographical hierarchy for 0country which is used in ODS & cube. can i use the geographical hierarchy for ODS as well for aggregation of values?

Regards

Emil

[former_member213594 · Accepted solution]

Hi,

Does material nav attributes were available from ODS also ?

If so , please create 2 restricted key figures <b>RKF1 (ODS), RKF2(cube)</b> ,limit the specific selections (variable) from specific info provider to specific key figure.

Can leave the free charecterstics just with fields without variable value selection.

As we aware any uncomman reference in multiprovider brings empty cell.

Hope this helps.

Thanks

Martin

[Former Member · Accepted solution]

Hi, i have solved the issue by impementing an SAP note.

and the issue is the in Query i need to calculate a key figure based on the other 2 key figures.

KF3 = KF1 * KF2

the only issue here is i need to find the KF1 for each material/country/fiscal period from cube 1 and KF2 for each material/country/fiscal period.

and multiply and then aggregate according to the filter & selection conditions.

can anyone let me know how to do it..

its very urgent..

thank you

Emil

[Former Member · Accepted solution]

In selection you can also choose the infoprovider from where to take data (if i well remeber the IO is Structure).

Check for that.

Hope it helps.

Regards

[Former Member]

How did you resolve the multiply and sum result?

I met the same problem:

The result of hierarchy node is (32) * (XY)/2, while I wanted to be 3X + 2Y