How FCCS View dimension helps in improving the performance of data loads!

How FCCS View dimension helps in improving the performance of data loads!

In FCCS Application- Under View dimension, there are three members under a parent member “FCCS_View_System Members”: “FCCS_QTD_RULE”, “FCCS_HYTD_RULE”, and “FCCS_YTD_RULE”. 

Details -

FCCS provides an Application Settings option to disable View calculations. By Turning this setting to "Yes" -

1. This option disables computation and storing of YTD, HYTD, and QTD data for data input (through forms, data import, Data Management, and so on) in the YTD, HYTD, and QTD members. 

2. Turning this setting to "Yes" will help in improving the performance of data loads.

3. Once data is loaded, ese the required YTD_RULE, HYTD_RULE, and QTD_RULE members to see the respective View data after data load. 

4. Data will not be populated and updated in the YTD, HYTD, and QTD members after data load.

To disable View calculations:

1. Click Application, and then click Settings.
2. Set the Disable To-Date View Calculations option to Yes.
3. Load data.
4. Use the YTD_RULE, HYTD_RULE and QTD_RULE members to see the YTD, HYTD and QTD data.

However, if there is requirement to use the YTD, HYTD, and QTD members, you will have to run the Update View Calculations rule for all the Scenario/Year/Period/Entities for which data was loaded when this option was set to "Yes", and pass QTD, HYTD, and YTD as parameters so that the values are correctly computed and stored.

This will make sure future data loads will correctly populate the "Never Share" YTD, QTD, and HYTD members.

Update View Calculations rule can be run at any time, regardless of the calculation status.

To update View calculations:

1. On the Home page, click Rules.
2. From the Business Rules list, select UpdateViewCalculations.
3. Select or enter dimension members for Entities, Period, Scenario, Year, View, and Currency, and click OK.
4. Click Launch to run the rule.

   
   

Thank you!