Reporting from two box

[Former Member]

I have required 4 fields in the cube which is pulled for the SCem Box and 3 required which is pulled from R/3 box . Is that possible to report 4 fields from SCEM and 3 fields from R/3.

I am thinking build one cube for SCEm data and other cube to pull the R/3 data add to together as a multi cube . Then I will report 4 plus 3 fields from the Multi cube.

Please correct me If I am wrong.

Thanks in advance

Taj

[Former Member]

yeah you can do that. Infact multi provider is the best solution. Do you have common chars in both the cubes to relate the data? if so you can do that.

[Former Member]

Is

[Former Member]

Okay Thanks

How do I make as Generic delta extraction. What fields I suppose to have in the Datasource fields.

Thanks

Taj

[Former Member]

Is this applicable. Different time the changes are get updated means the scheduling of the load from R/3 and SCEM is different .

Will the data get synchronize. Will I get I data what I want in the report.

Please advise me.

Thanks in advance

taj

[Former Member]

Yeah the data would synchronize. And regarding the load times, they dont matter unless there is dependency related .. meaning some look up table to populate certain fields etc. And the report would only have the data that has been loaded till the last request.