.Note: Information on SAP BW metadata is in Working with SAP BW Metadata.
After importing metadata, you must ensure that it is set up to meet your users' reporting requirements, and provide any additional information that they require. Enhancements you make in Framework Manager do not affect the original data source.
Tip: To verify that the model meets the reporting requirements, you can select objects that will appear in a report and test them. The test results show you the report that your users will see as well as the SQL and messages from IBM Cognos 8, if any. Or you can publish a package at any time and then use the package to create reports.
You can check the project at any time to ensure that the references
between the objects it contains are valid .
We recommend that you create at least two views: the import view
and the business view. Using two, or more, views makes it easier
to remap items to a new data source .
The import view contains the metadata you imported from the data source. To ensure that the metadata is set up correctly in the import view, do the following:
Ensure that the relationships reflect the reporting requirements
Optimize and customize the data retrieved by query subjects
Optimize and customize the data retrieved by dimensions
Handle support for multilingual metadata
Control how data is used and formatted by checking query item properties
The business view provides a layer to the information in the source data so that it is easier for your users to build reports. To enhance the metadata in the business view, do the following:
Add business rules, such as calculations and filters, that define the information users can retrieve
Organize the model by creating separate views for each user group that reflect the business concepts familiar to your users
You can analyze the metadata to ensure that the model
is following current modeling guidelines by using the Model
Advisor .
