254 IBM Cognos Dynamic Cubes
9.3.2 Use consistent data source, schema, and table names in all
environments
In the cube model, the metadata objects for a dynamic cube contain references to the name
of the relational data source, the relational tables, and the table columns. Having the fact and
dimension tables defined with identical schema and table names in all environments helps to
more easily move a cube between environments.
This approach offers the following benefits:
You can use deployment archives to move a dynamic cube between environments.
The same scripts can be used in all environments to create the in-database aggregates.
Inconsistent data source name and table schema names between environments can be
addressed with a little e ...