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?