Overview of Dimension Values in Reporting

For Standard Balances Cube dimensions, there are default values that if used in Smart View and on financial reports created in Financial Reporting Studio cause #MISSING to appear when balances are returned on a report output.

If #MISSING appears, check that all dimensions are properly set. Particularly, check the Accounting Period, Ledger, Scenario, and Currency dimensions, which all must have a value selected other than the default highest level value called Gen1.

By using combinations of values for the Accounting Period, Balance Amount, and Amount Type dimensions, you can derive different amounts to meet financial reporting requirements. In some cases, more than one combination of query values can return the wanted information. Some duplication in the calculations for the balances cube exists to ensure complete reporting requirements.