Use the Publish OLAP Server Metadata notebook to publish metadata for DB2 OLAP Server or Essbase server objects to the information catalog.
To publish OLAP Server metadata:
Specify the objects whose metadata you want to publish to the information catalog:
Import file is selected by
default when you open the notebook. If you have a control file that
contains a list of the objects that you want to publish, type the
path and file name in the File
name field. To
search for a file, click 
to open a window that you can use to view the available files and
select one.
If you want to create your own control file that lists objects to publish, click Create object list.
In the File name field, type a path and directory for the file.
In the Object name field, type the name of the Essbase object.
Click Add. The object is added to the Object list. Repeat this process for all the objects that you want to publish.
Click the Synchronization Settings tab.
In the Supervisor user ID field, type the user ID of the supervisor for the DB2 OLAP Server or the Essbase server.
In the Supervisor password field, type the password for the supervisor user ID.
Type the password again in the Verify password field.
In the Catalog name field, type the name of the information catalog to which you want to publish metadata.
In the Administrator user ID field, type a user ID that has access to the information catalog. The user ID can be the ID of the information catalog administrator or that of an information catalog user who has certain administrative privileges.
Type the password that corresponds to the user ID in the Administrator password field.
Type the password again in the Verify password field.
Optional: Select one of the following check boxes to determine how published metadata will be updated:
Select Generate object names and descriptions in the information catalog on update to replace existing object names and descriptions with the names and descriptions of the same objects in the Essbase outline. Do not select this check box if you want to keep existing objects and descriptions in the information catalog. For example, if you specified additional business information for an object in the information catalog and do not want to overwrite the information with updated values, you would not check this box. This check box is not available if you select Delete existing objects in information catalog before updating.
Select Delete existing objects in information catalog before updating to delete objects that exist in the information catalog before you publish Essbase objects. Do not select this check box if you want to keep and update existing objects in the information catalog. If you select this check box, the Information Catalog Manager deletes all objects that are related to a deleted object. The Tree view is updated so that there are no objects unrelated to other objects.
Optional: You can make the tree structure shown in the Information Catalog Manager less complex by limiting the number of levels of objects published and displayed in the Tree view:
Select Limit the levels of objects in the tree to limit the number of levels of objects that are published and displayed in the Tree view. If you do not select this check box, all objects and underlying objects you select are published and displayed.
Click the up or down arrow to specify a limit for the number of levels of objects published and displayed in the Tree view. The default limit value is 1. The lower the limit you specify the less complex the tree structure will be.
Optional: You can make the tree structure shown in the Information Catalog Manager less complex for each level published by limiting the number of dimensions and members for each level:
Select Limit the number of dimensions and members for each level to limit the number of dimensions and members within each dimension that are published and displayed in the Tree view. If you do not select this check box, for each level of the Tree view, all objects that represent dimensions and all objects that represent members within those dimensions in the Essbase outline are published and displayed.
Click the up or down arrow to specify a limit for the number of dimensions and members within each dimension that are published and displayed in the Tree view of the Information Catalog Manager. The default limit value is 1. The lower the limit that you specify, the less complex the tree structure will be.
Click OK.
When you click OK, the Publish Information window opens and displays a message that tells you if the publish process completed successfully. If errors occurred, the notebook remains open when you close the Publication Information window so you can try to the publish process again. You can find more information about a particular error message in the DB2 UDB Messages Reference.
If the publication is successful, the notebook closes when you close the Publication Information window and a publication object is added to the List of publications in the Publish Metadata window.
Related information:
Publishing Data Warehouse Center metadata
Scheduling regular updates of published metadata
Creating a cascade relationship based on success or failure of a publication
Creating notification messages for a publication
Modifying properties for a Data Warehouse Center publication