Error when opening Dimension in Data Warehouse Manager

Summary:

User receives the error "Error in getting data for the selected dimension".

Symptoms:

When selecting a dimension in the Data Warehouse Manager, the error messqage occur.

Cause:

When selecting a dimension in the Data Warehouse Manager, filte(r) missing

Resolution:

Check the data filters for the user’s Warehouse and Planning roles.

There should be filters added to the

• Planning Admin and
• Warehouse Admin roles

To check for this:

1. Select Administration
2. Select Roles
3. Select the Planning Admin role
4. Go to the Data tab
5. Delete any data filters
6. Do the same for the Warehouse Admin role

Properties:

Applies To:

• Data Warehouse Manager all versions