3. Creating and initializing a reporting datamart
You can create and initialize a Reporting Datamart from an RDBMS HOPEX repository of your HOPEX Environment as follows:
|
Step
|
Reporting Datamart
|
Description
|
See
|
|
|
1
|
Creation
|
- Reporting Datamart data language definition
- User and profile selection
|
||
|
2
|
Initialization
|
Structure
(optional)
|
Creation of all the tables and columns according to the HOPEX repository metamodel
|
|
|
Data
|
Creation and feeding of all the Reporting Datamart tables, columns and rows according to the HOPEX repository content
|
|||
Note: you can also initialize the Reporting Datamart using APIs, see HOPEX power Studio > Initializing and synchronizing a Reporting Datamart.
3.1. Creating a Reporting Datamart
At Reporting Datamart creation you define:
the Reporting Datamart storagethe data language of the Reporting DatamartNote: not translated data appears in its Idabs format.
the user and its profileThey both define and filter the HOPEX repository data according to their access rights (confidentiality: reading access areas of object occurrences and of linked objects for link occurrences) and permissions.
To create a Reporting Datamart (SQL Server format) from a HOPEX repository:
1) Launch HOPEX Administration application.
2) Connect to the environment from which you want to replicate the data.
3) In the Repositories folder, expand the repository folder concerned.
4) Right-click Reporting Datamart and select New.
The Create a Reporting Datamart window opens.
5) In the Connection pane:
a) In the Name field, enter your Reporting Datamart name.
b) (If needed) Modify the HOPEX repository Instance set by default as well as its connection parameters (User, Password, Parameters), see RDBMS Repository Installation Guide for detailed information.
c) In the Storage pane, use the drop-down menu to select the Reporting Datamart storage type: “SQL Server (dbo schema - default)”.
d) (If you do not have the right to create a database) Select Use existing SQL Server database.
Note: if you selects Use existing SQL Server database, in the Name field you must enter the name of the existing database you want to use.
6) In the Reporting Datamart pane:
a) In the Language field, select the data language of the Reporting Datamart.
Note: select a language in which the data is available, so that you can read it.
b) In the User field, select the user that defines the access to HOPEX repository.
c) In the Profile field, select the profile that defines the access to HOPEX repository.
7) Click Test Connection.
8) Click Test GRANT's.
9) Click OK.
The Reporting Datamart is created.
The Reporting Datamart is added in the Reporting Datamart folder with the following format:
<Language> - <Reporting Datamart name> - <Storage type>
Example: EN – Paris production Repository – Sql Server
3.2. Initializing the Reporting Datamart structure
Once the Reporting Datamart is created you can initialize the structure with the HOPEX repository metamodel.
All the tables and columns are created even if there is no data to feed them. The table remains empty, so that the Reporting Datamart structure is always consistent. This ensures the user that any of his queries run properly on the Reporting Datamart.
To initialize the Reporting Datamart structure from the HOPEX repository:
1) Launch HOPEX Administration application.
2) Connect to the environment concerned.
3) In the Repositories folder, expand the repository folder concerned.
4) In the Reporting Datamart folder, right-click the Reporting Datamart concerned and select Initialize > Structure.
The Reporting Datamart structure creation starts.
The Reporting Datamart is initialized according to the HOPEX repository metamodel: all the tables (columns and rows) are created.
If you have already initialized the Reporting Datamart data, only the empty tables and columns are added.
Else initialize the Reporting Datamart data to feed the tables, rows and columns (see Initializing the Reporting Datamart data section).
3.3. Initializing the Reporting Datamart data
Once the Reporting Datamart is created you need to initialize the Reporting Datamart data with the HOPEX repository content according to the user/profile permissions and the object type selected.
To initialize the Reporting Datamart data from the HOPEX repository:
1) Launch HOPEX Administration application.
2) Connect to the environment concerned.
3) In the Repositories folder, expand the repository folder concerned.
4) In the Reporting Datamart folder, right-click the Reporting Datamart concerned and select Initialize > Data.
5) Click Start.
The Reporting Datamart data initialization starts.
The Reporting Datamart Data is initialized according to the HOPEX repository content.