Skip to main content

Budgets for Cubes

Budgets in Nectari OLAP cubes enable you to plan, compare, and analyze financial targets alongside your actual results. By configuring budgets, you can forecast performance, set financial goals, and monitor how your organization is tracking against those objectives across multiple versions and cubes.

Benefits of using budgets in OLAP cubes​

  • Planning and forecasting: Enter or update budget values to support financial planning cycles and future projections.
  • Tracking performance: Compare actual results to budget for variance analysis in dashboards and reports.
  • Adapting targets: Adjust budget data as business conditions change, ensuring that your analytic cubes remain aligned with your current business strategy.

Configure a budget​

  1. In the navigation panel, select Data Models and Views.
  2. Expand OLAP Cube, then Budget for Finance Cube.
  3. Open the Budget Configuration worksheet.
  4. In the Cube and Version columns, enter or update your budget values. Use the prompt icon to search for specific values.
    Cells with entered values turn green.
  5. In the Toolbar panel, select Save or Save As to save your changes.

Refresh the X3 Financial Cube​

If the X3 Financial Cube is already loaded, you must refresh it to apply your budget changes.

  1. In the navigation panel, click the gear icon to open the Administration section.
  2. On the left panel, click OLAP Manager. This opens the OLAP Manager in a new window.
  3. Select X3 Financial Cube from the list. The Cube Details dialog opens on the right.
  4. In the Options panel, click the Manage icon.
  5. In the Action dropdown list, select Refresh.
  6. Select the environment.
  7. Click Confirm.
  8. Close the OLAP Manager window when complete.