Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
5.3.1 Migrating from OLAP Center to Design Studio Migration from the OLAP Center to the Design Studio in DWE V9.1 is easy. All the OLAP metadata from the OLAP Center resides in the OLAP-enabled database. Use the Design Studio Database Explorer to connect to the OLAP-enabled database and the OLAP objects will appear and be valid in the OLAP objects folder under the database schema. If the DB2 V8 database was previously at maintenance Fixpack level 7 (FP7), FP8, or FP9 and DWE V9.1 (which includes DB2 V8 FP10) is installed, the OLAP metadata will need to be migrated to the FP10 level. Upon connecting to the database with Database Explorer and browsing the OLAP metadata, a message will appear notifying that the metadata is back-level and ask if the metadata should be migrated. On answering yes to the prompt, the metadata will be migrated. The metadata can also be migrated using the DWE Admin Console. The import/export wizards in the Design Studio import and export an XML file in the OLAP Center format. This is the same behavior as the import wizard and export dialog in OLAP Center. Consequently, any XML file exchanged with the OLAP Center should work with Design Studio. 5.4 Modeling OLAP with DWE Design Studio