Key figures double when pulling form views
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?