Summary:
This article troubleshoots an issue when using "Sheet per value," the amount is not displayed in detail worksheets. However, the summary sheet displays the appropriate data.
Article Sections:
Symptoms:
When a user runs a report with SPV the amounts on the summary worksheet are displayed correctly, but the detail worksheet does not display the amounts.
Causes:
The Data Warehouse contains special characters for some dimensions.
Resolution:
1. Open the Data Warehouse Manager.
2. Select the Dimensions.
3. Expand General Ledger.
4. Go to the dimension having the issue and ensure Dimension codes have no special characters (i.e. Spaces, *, &).
Properties:
4.x Data Warehouse Manager