Hello experts,
we are currently creating a report within the SAP Datasphere that is used by SAP Analytics Cloud. While checking the numbers in the frontend (SAC) I noticed that these numbes do not match those in the SAP Datasphere. At the moment I know two sources of error
- graphical views
The number of entries is multiplied by five. This seemed so strange to me that I couldn't believe it. Therefore, I checked the data (number of entries and amount) from the source system up to where the mistake appears. In an graphical view with left joins the data is multiplied by five. Recreating this faulty view as a sql view will lead to the correct data. Creating a new graphical view, deleting all joins, deploying, adding the joins and deploying againalso results in the correct data.
The correct data is on the left side of the image. The sql statement referes to the newly create graphical view with deleting an readding the joins. On the right side is the original view where I noticed the error.
Is this a known issue or am I doing something wrong here?
- Analytic Model
When creating an analytic model from an view (fact), the values are also distorted.
The fact view shows the correct data and when I create an Analytic Model that use the fact view I get double the amount and double entries. I haven't found a workaround for this problem yet.
Has anyone had similar experiences and found a way to avoid these problems?
Thanks in advance and
BR
Philipp