A DataMart is an export of data from one or more views to a set of tables in a SQL or Oracle database. Use the DataMart export tables to create customized reports using Actuate report technology, which includes BIRT and spreadsheet. Using DataMart requires the separately purchased DataMart Generation module.
You create a DataMart export in Metrics Management, and run the DataMart export manually from Metrics Management or on an automated schedule using pbvcon. For more information, see About pbvcon.
You base a DataMart export on single or multiple views. Choose to export the commentary types linked to each view or specify a subset of commentary types.
The base data in a DataMart export are known as DataMart facts and consist of:
Calculated data
Calculated indexes
Categories and category objects
Commentaries
User data
The data that describe the DataMart facts are known as DataMart dimensions and consist of:
Comparatives
Commentary types
Locations
Location trees
Measures
Measure formulas
Measure links
Measure owners and owners’ assistants
Measure trees
Periods
Period ranges
Period trees
Series
Users
Views
The DataMart also contains two extensions to the export:
Calculated data