Configuring the Finance Open Balance

In order to get the Opening Balance from the Finance cube, you will need to run the NectariGL Opening Balance from the GL Transaction DetailsData Model.

1. Make sure the data sources are activated before loading the cubes:
   1. In the upper right-hand corner, click on the to access the Administration section.
   2. On the left pane, click on OLAP Manager.
   3. In the list, select X3 Financial Cube,click on Navigation and select Data Sources.
      
   4. Select X3 Open Balance (Simulated) and X3 Open Balance (Simulated) LY and make sure their Active checkbox is ticked. If not, tick the Active checkbox and click on Save.
      
      
2. Make sure that closed year amount will not be loaded and duplicated in the cube:
   1. In the list, select X3 This Year Transactions, click on Data Source and choose Edit Data Source .
      
      
   2. The following WHERE statement must be applied. Remove the comment section (“/*” and “*/”) in the red box.
      
      
   3. In OLAP Manager, select and load the X3 Financial Cube.
3. From the Data Model and Views tab, in the Finance folder, right-click on one GL Transaction Details and select View Info Pages.
4. In the From and To fields, enter the beginning of the fiscal year and the last fiscal year for which you want to run the Opening Balance and click on Calculate Open Balance depending on the server you are using (SQL or Oracle).