Poor Application Design

Faced with performance issues, a Service Administrator must review the application design and validate metadata to ensure that the application will yield optimal performance.

Using the Simplified Dimension Editor to Review and Fix Errors

Optimal consolidation performance requires that metadata properties of each dimension in the application are set correctly. Incorrect metadata properties may cause consolidation errors, leading to poor performance. 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:

1. Sign in to Financial Consolidation and Close as a Service Administrator.
2. On the Home page, click Application and then Overview.
3. 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.

   1. Click Zoom In All Levels .
   2. Click Validate Metadata Definition .

      A validation pane, which lists the validation errors in the current dimension, is displayed at the bottom of the screen.

   3. Use Fix Validation Errors to select and fix each validation error. Click Apply to apply changes to the metadata property value.
   4. Click Save after fixing all validation errors.
   5. Click Cancel to return to the Dimensions tab.
4. Repeat Step 3 for each dimension.
5. Refresh the database.
   1. From Actions, select Refresh Database.
   2. Click Create.
   3. In Refresh the database, set actions that are to be completed before and after refreshing the database.
   4. Click Refresh Database.
6. Run Consolidation to check if performance has improved.

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, leading to poor performance.

To validate metadata using the Metadata Validator:

1. Sign in to Financial Consolidation and Close as a Service Administrator.
2. On the Home page, click Application and then Overview.
3. From Actions, select Validate Metadata.
4. 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.

5. Open the Dimension Editor and correct the reported metadata errors. See About Editing Dimensions in the Simplified Dimension Editor in Financial Consolidation and Close Administrator's Guide.