Import Meta Data
In order to import Meta Data you must have a database open. You may want to import Meta Data into a pre-existing database-for example, to re-create a Cube whose Meta Data you exported from another database; or to add Members to a Dimension in the database. Or, you may create a new database, as in this example-therefore, create a new database, giving it the name, e.g., TestImp.
1. From the PowerOLAP ribbon, go to Data tab, then in the Import control group select Metadata icon or Import Metadata command.
The Import Metadata dialog box is displayed.
2. Click Browse to select the file to import.
3. Select <file name> to import and press Open.
(For example, pick the AvonMargin.txt, created previously in the
Export Meta Data topic.)
You are returned to the Import Metadata dialog box.
4. Select Tab, Comma, Period or Other as the file Delimiter.
Note that you must select the correct delimeter that was used in the import file, otherwise data will not successfully be imported.
5. Click OK.
At this point in the import process-whether for Fact Data or Meta Data-PowerOLAP will immediately determine whether the selected file is a valid import script. If the file is invalid, a message box will appear, stating Incorrect Import File Type, and you will be returned to the main application window.
6. Select OK.
The database is updated by the Meta Data import file.
7. Having completed the Meta Data import, you can examine the Cubes/Dimensions/Formulas and confirm that all the Meta Data elements that existed in the text file now exist in the database into which you imported the file (in our example, TestImp.olp).
An important point about Formulas brought in via a Meta Data import: check to determine whether there are any cross-cube Formulas that refer to Cubes that did not exist in the import file. If this is the case, be aware of the implications and determine how you want this (formerly) formula-driven data to report.
8. Once you are satisfied with the results of the Meta Data import,
Save changes to the database.
Changes made to Meta Data, including those made by a Meta Data import, are not saved until you save the database.