The Control To-Date View Storage application setting provides the option of whether or not to store the To-Date View member values. The Control To-Date View Storage option is only available for Extended DimensionĬhoosing not to calculate and store To-Date View member values can result in smaller application size, faster consolidation times, faster restructure times, and easier maintenance. Note: Before you enable the Control To-Date View Storage option, you should consider the possible effects on your application. Make sure you review and understand the following steps before enabling the feature, and to see the best performance results. When you enable this feature, the system automatically adds the following Consolidate and Translate rules to the application: You enable the Control To-Date View Storage option during application creation, or from the Application Configuration screen for existing applications. The consolidation or translation process, the system runs the calculations for only In the "Consolidate or Translate - by Selected View" rules, you select the required Viewĭimension members (Periodic is selected by default and is always calculated). The View member or members that you selected. When you run these rules, the To-Date values are deleted from the application. For best performance, you should also restructure the cube. If you want to reduce the application size by removing the To-Date values for already locked periods, you must unlock the period and reconsolidate the Scenario/Year/Period/Entity combinations as outlined below. The performance improvement will be best if you perform this step for all Scenario/Year/Period/Entity combinations. Using the Control To-Date Storage Feature If you prefer not to do these steps, you can continue to use the existing ConsolidateĪnd Translate rules, even after enabling this feature. Important: Since these actions will take a while to complete depending on the size of the application, you must disable any scheduled jobs, Automated Maintenance Window (AMW) processes or any background processes until this process is completed. On the Home page, click Application, select Configuration, then from the Enable Features screen, enable the Control To-Date View Storage feature. Wait for the functionality to be enabled, then log out and log back into the application. On the Home page, click Rules and from the Rules list, verify that the Consolidate and Translate "by Selected View" rules have been added to the application.įrom Rules, run Consolidate –by selected View on all months loaded to the application. This process will delete all QTD, HYTD and YTD data currently stored in the application.įrom Rules, run the ClearEmptyBlocks rule.įrom the Navigator, select Jobs from the Application column. Run a database refresh, then test consolidation times using the Consolidate – by Selected View rule. Tip: You can use the Disable To-Date View Calculations setting in Application Settings to skip computing and storing View members as part of data loads to see improvements in data loads as well. Possible Business Flows for To-Date View ValuesĪpproach 1: Continue using the existing Consolidate and Translate rules. You do not need to enable the Control To-Date View Storage feature. To retrieve the data in the QTD, YTD, and HYTD When these rules are run, only the Periodic data Translate - by Selected View option by selecting Note that this will make the cube size very large.Īpproach 2: Use the new Consolidate - by Selected View and If you select Consolidate or Translate, then during the consolidation or translation process, the system automatically calculates and stores the QTD, YTD, and HYTD values for every intersection in the system. View members, use the associated View dimension system _Rule members:įCCS_QTD_RULE, FCCS_YTD_RULE, and FCCS_HYTD_RULE. Members and the performance of retrieval will depend on your application. See Troubleshooting Financial Consolidation and Close Retrieval PerformanceĪnd make sure you follow all the steps. If you are not satisfied with the results, useĪpproach 3: Use the new Consolidate - by Selected View and Translate - by Selected View option by selecting only the Periodic member. Then run the Update View Calculations rule. When these rules are run, only the Periodic data is consolidated and stored.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |