Chapter 9. Dynamic cube lifecycle 255
9.3.5 Include complete dimensional data in development environment
The development environment will usually have a substantially smaller subset of the fact
table. However, if possible, the development environment should have complete dimension
data or at least all dimension data that would be explicitly referenced in reports, calculations,
or security.
When modeling dimensional security, the expressions for the security filters require modelers
to drag in members from the member browser. The members that are displayed in the
member browser are based on the data in the dimension tables. Without all the dimension
data, users might not be able to define the security filters they want.
In addition, if there are problematic reports from the production environment, you want to be
able to run the report in the development environment. If the development environment does
not contain all the dimension data, the report specification might include members that do not
exist in the development environment, and will fail to run.
9.3.6 Make the test system similar to the production system
The test system must be sufficiently similar to the production system in scale so that
performance testing and optimization is meaningful.
In ideal circumstances, the database that is used in the test system is a mirror copy of the
production database. This way allows the optimization and testing to occur in the test
environment, and allows the recommended aggregates to remain applicable for the
production environment. Even if the test system is not a mirror copy, if the test and production
systems are of comparable scales (such as within a factor of two), then the recommended
aggregates should still be acceptable. If a greater variance exists between the systems, the
recommended aggregates might not work as well.
Running the advisor on the production system is generally undesirable, because the advisor
might generate some resource-intensive queries while creating the aggregate
recommendations.
256 IBM Cognos Dynamic Cubes
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.