Skip to main content

Configuring the Finance Open Balance

In order to get the Opening Balance from the Finance cube, you need to run the SEI GL Opening Balance from the GL Transaction Details Data Model.

  1. Make sure the data sources are activated before loading the cubes:
    • In the upper right-hand corner, click on Administration to access the Administration section.
    • In the left pane, click on OLAP Manager.
    • Select X3 Financial Cube, click on Navigation, and select Data Sources.
  2. Make sure the Active checkbox is ticked for X3 Open Balance (Simulated) and X3 Open Balance (Simulated) LY. If not, tick the Active checkbox and click Save.
  3. Make sure closed year amounts are not duplicated in the cube:
    • Select X3 This Year Transactions, click on Data Source, and choose Edit Data Source.
  4. Remove the comment section from the WHERE statement shown below.
  5. In OLAP Manager, select and load the X3 Financial Cube.
  6. From the Data Model and Views tab, in the Finance folder, right-click on GL Transaction Details and select View Info Pages.
  7. Enter the beginning and ending fiscal years and click Calculate Open Balance depending on your server (SQL or Oracle).