Location Does Not Display Data on Sheet per Value Reports

Summary:

In some cases, on a report using "Sheet per value," amount is not displayed in detail worksheets. However the summary sheet displays the appropriate data.

Symptoms:

Amounts on the summary worksheet are displayed correctly, but detail worksheet do not display amounts.

Cause:

The Data Warehouse contains special characters for some dimensions.

Resolution:

This section will explain the steps taken to workaround the issue, or resolve the issue permanently;

1. Open the Data Warehouse Manager.
2. Select the Dimensions.
3. Expand the General Ledger.
4. Go to the dimension having the issue and ensure Dimension codes have no special characters (i.e. Spaces, *,  &).

Properties:

Applies To:

• 4.x Data Warehouse Manager