Authorities
and privilegesUse the Export Warehouse Schema notebook to export warehouse schemas to the OLAP Integration server (as OLAP models).
Note: Only warehouse schemas that have the same database properties (with tables from a single database) will be shown in the tree; since only these can be exported. The Use only one database check-box must be selected in the Define Warehouse Schema or Warehouse Schema Properties notebook.
To export warehouse schemas to the OLAP Integration Server:
On the Warehouse Schemas page, select the warehouse schemas that you want to export by moving them from the Available list to the Selected list.
On the Integration Server page:
In the Catalog name field, type the name of the OLAP Integration Server catalog that will be used for the export.
In the Catalog table schema name field, type the name of the catalog table schema entered or accepted during installation.
Optional: In the Time dimension table field, select the name that is the Time dimension table. If you do not select a name, or if there are no tables in the list, the "General" dimension type will be used. If multiple schemas are selected, this field is available only when the selected schemas have common dimension tables.
Note: You will not be able to change the dimension type after the schema is stored in the OLAP Integration Server catalog.
Optional: In the Accounts dimension table field, select the name that is the Accounts dimension table. If you do not select a name, or if there are no tables in the list, the "General" dimension type will be used. If multiple schemas are selected, this field is available only when the selected schemas have common dimension tables.
Note: You will not be able to change the dimension type after the schema is stored in the OLAP Integration Server catalog.
In the User ID, Password, and Verify password fields, type the user ID and password that will be used to access the OLAP Integration Server catalog.
Select the action to take if the OLAP model already exists.
Click OK to export the selected warehouse schemas to the OLAP Integration Server catalog.
The notebook closes and a progress indicator is displayed until the export is complete. When all the specified warehouse schemas are exported, the Export Information window opens, displaying success or failure information about the export. Click OK to close this window.
Related information