Determining Which Fields Populate Analysis Cubes

If you use Vision Analysis Cubes, you can select which Vision fields (dimensions and measures) populate the data cubes.

Initially, all the possible Vision fields that can populate the data cubes as dimensions and measures are selected by default to populate the data cubes. Reducing the number of fields that populate the data cubes will reduce the time it takes to refresh the data cubes.

• This topic applies only if you purchased the Performance Management application and activated it in Configuration > Module Activation. If you have not purchased Performance Management, you still have access to Analysis Cubes, but you do not have access to the Analysis Cubes Configuration.

• The Analysis Cubes feature does not use Vision security. If you require different users to access different Vision fields to create reports, you must use SQL Server Analysis Services security to set up permissions by role or by user to define who can access specific dimensions and measures.

• You can select or clear (deselect) dimensions and measures to populate the data cubes at any time. After you make selections or modifications on the Analysis Cubes form, a system administrator must use the Vision Resource Kit to update the Vision data cubes with the dimensions and measures.

• If you remove fields from the data cubes after they populate the data cubes and you have reports that include these removed fields, the fields are removed automatically from custom reports after you refresh report data. You must rebuild the reports.

• The selection instructions apply for standard Vision fields only.

• To select user-defined fields to populate the data cubes, you must select the Available for Analysis Cubes check box for each user-defined field on the Fields tab in Configuration > General > User Defined Tabs. See "Select User-Defined Fields for Analysis Cubes" for related information.