Duplicate data from BCS Multiprovider

[Former Member]

Hi All

  Recently I had datamarted the BCS reporting cube with data.After this, the query is displaying data both from Basis cube(some data) and Reporting cube(all data) from the Multiprovider. I am populating the data using virtual cube to the reporting cube. Any idea on what might have happened? If I clear the data from Reporting cube, the report is correct. Any clues please.

Example.

The multiprovider contains the virtual cube and reporting cube.

Non Current Assets
Reporting Cube	Reporting Cube	Basis Cube(Virtual Cube)	Total	Expected Result
Property	100	50	150	100
Investment	200	20	220	200

The column from Reporting Cube is correct. The column from Basis Cube is wrong.

Regards

Bharath

[Former Member]

We are in SEM version 6 and BW version 7

[Former Member]

Hi All

  I had solved this issue by implementing delta cache and delta pair.