Aggregate Persistence Wizard
Oracle Business Intelligence provides
an aggregate persistence feature that automates the creation and loading of the
aggregate tables and their corresponding Oracle Business Intelligence metadata
mappings. The Aggregate Persistence Wizard enables the administrator to
automate the creation of physical aggregate tables and their corresponding
objects in the repository.
Step-by-step (I've got training by OU)
1. Open
the Aggregate Persistence Wizard.
2. Specify a file name and location.
3. Select the business model and measures.
4. Select dimensions and levels.
5. Select the connection pool, container, and
name.
6. Review the aggregate definition.
7. View the complete aggregate script.
8. Verify that the script is created.
9. Run the aggregate persistence script.
10. Verify
aggregates in the Physical layer.
11. Verify
aggregates in the BMM layer.
12. Verify
aggregates in the database.
13. Verify
your work.
ไม่มีความคิดเห็น:
แสดงความคิดเห็น