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 ...