Check for Poor Application Design
Incorrect metadata property settings in Financial Consolidation and Close are primary responsible for numbers mismatch. A Service Administrator must review the consolidation application design and identify and fix metadata errors to ensure the accuracy of numbers during consolidation.
Review and Fix Metadata Errors
Accuracy during consolidation is predicated on the metadata properties of each dimension in the application being accurate. Use the Simplified Dimension Editor to verify that your metadata abides by the best practices for consolidation.
Review application dimensions to ensure that they are defined with the correct member properties. For information on reviewing member properties, see Editing Member Properties in the Simplified Dimension Editor in Financial Consolidation and Close Administrator's Guide.
To review and fix errors using the Simplified Dimension Editor:
- Sign in to Financial Consolidation and Close as a Service Administrator.
- On the Home page, click Application and then Overview.
-
On the Dimensions tab, click the name of the dimension, for example, Account, that you want to evaluate.
The Edit Member Properties screen for the selected dimension is displayed.
- Click Zoom In All Levels
.
- Click Validate Metadata Definition
.
A validation pane, which lists the validation errors in the current dimension, is displayed at the bottom of the screen.
- Use Fix Validation Errors to select and fix each validation error. Click Apply to apply changes to the metadata property value.
- Click Save after fixing all validation errors.
- Click Cancel to return to the Dimensions tab.
- Click Zoom In All Levels
- Repeat Step 3 for each dimension.
- Refresh the database.
- From Actions, select Refresh Database.
- Click Create.
- In Refresh the database, set actions that are to be completed before and after refreshing the database.
Validating Metadata
Use the Metadata Validator to ensure that metadata properties, such as assigned default and consol cube data storage, consolidation operator, and parent member are valid. Invalid metadata property assignment may cause errors during consolidation.
To validate metadata using the Metadata Validator:
- Sign in to Financial Consolidation and Close as a Service Administrator.
- On the Home page, click Application and then Overview.
- From Actions, select Validate Metadata.
- In Validate Metadata, click Run.
Errors, if any, are displayed in [Parent].[Child] format along with an error description. For detailed information on error messages, see Metadata Validation Messages in Financial Consolidation and Close Administrator's Guide.
- Open the Dimension Editor and correct all reported metadata errors. See About Editing Dimensions in the Simplified Dimension Editor in Financial Consolidation and Close Administrator's Guide.
-
Rerun consolidation and check results.
If data inaccuracies are not resolved, you can assume that metadata definitions are not responsible for inaccurate consolidation results.