Key figures double when pulling form views

[Former Member]

Hi Experts,

In BI, our key figures are doubling (number of records are doubling) when we are pulling from datasources based on views in ECC.

We have two clients in ECC, but only one contains the data (to which our BI system is pointing)

Also if I run extraction in RSA3, in the right client of ECC, it shows the correct data.

I also added the client(MANDT) as the first field in the views hoping that will resolve the issue, but it didn't.

Anyone came across such issue? Any solutions?

Thanks!

[MartinMaruskin]

How is your data flow set up? Seems that you load the data from datasource directly to cube in cumulative mode?

You might need an DSO layer in between datasource and cube in order to consolidate the data.

[Former Member]

Seems like the issue is that we have two DTP's under the direct access cube. So note that we can have only one DTP under the remote cube/direct access cube.