Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Reporting off of three main fact tables

Hello all, we're starting work on a new universe and have run into some headaches.

Here's some background : Our datawarehouse splits our charges, payments and adjustments into three separate tables. Previously we've used a materialized view to join these three for Universe and reporting needs.

We'd like to get away from using this mview, hence the new Universe.

The issues we're running into are incorrect details and data aggregation.

Have any of you successfully gotten around a similar issue without using a materialized view?


Helpful Answer

Not what you were looking for? View more on this topic or Ask a question