We are preparing the design for a BI solution to our customer.
Wich is the correct way to create and use the aggregate tables, I have searched and there is a "persistance aggregate wizard" that is provided by OBI, but I'm not very sure If it is the correct solution for a production environment.
Can you give me some advise or the best practices please?
Create DDL scripts for your aggregate tables and run it in your database.
Create ETL mappings to populate these aggregate tables with data. ( You can do this in OWB, Informatica , ODI or any other ETL / ELT tool)