Dynamic Planning Overview
  • 1 Minute to read
  • Dark
    Light
  • PDF

Dynamic Planning Overview

  • Dark
    Light
  • PDF

Article summary

Article Summary

This article provides an overview of Dynamic Planning, Planful’s multi-dimensional engine for operational planning and analysis. It highlights key capabilities such as ad hoc querying, model creation, and formatted reporting via SpotlightXL (Excel), Spotlight Web, and Google Sheets. The solution enables access to the Planful Financial Cube for flexible, self-service financial modeling.

Dynamic Planning is an advanced multi-dimensional engine and analysis tool for operational planning and comprehensive analysis. It features web and Microsoft Excel interfaces, enabling rapid ad hoc querying, self-service data access within and beyond finance, formatted reporting, and more. You can access Planful and other datasets by logging in and specifying environment details within the Dynamic Planning interface. Once connected, you can utilize all data stored in the Planful Financial Cube to work with existing models, performing tasks such as:

  • Create sub-models (also known as Analytic models)

  • Generate flexible custom reports and charts for distribution

  • Perform analysis using your Planful data as a foundation

Dynamic Planning allows you to add, remove, or modify models and sub-models as needed to analyze the required data. It provides Web, Microsoft Excel, and Google Sheets user interfaces:

  • Spotlight: The Web front-end, offers Analyze, Report, and Model Manager functionality

  • SpotlightXL: The Excel front-end, provides functionality for all Dynamic Planning capabilities, including Analyze, Report, Excel Report, Model, and Manage

  • Spotlight for Google Sheets: Offers Analyze and Report functionality

    Note:

    To ensure full access to all features and functionalities of Dynamic Planning, we recommend maintaining the locale setting as en_US (English - United States).

Getting Started

User Security

Users should define certain roles and access when starting with Dynamic Planning.

Download and Installation

This article provides complete information on downloading, installing, and other important details.

Dynamic Planning Interfaces

  • SpotlightXL - the Excel front-end, provides functionality for all Dynamic Planning capabilities including Analyze, Report, Excel Report, Model, and Manage.

  • Spotlight Web - provides functions like Analyze, Report, and Model Manager.

  • Spotlight for Google Sheets - offers Analyze and Report functionality.

Find the table below to view the functionalities available across different Dynamic Planning interfaces, SpotlightXL, Spotlight Web, and Spotlight for Google Sheets.

Functionality

SpotlightXL

Spotlight Web

Spotlight for Google Sheets

Analyze

Yes

Yes

Yes

Report

Yes

Yes

Yes

Excel Report

Yes

No

No

Model

Yes

Yes

No

Manage

Yes

No

No

Note:

While Spotlight for Google Sheets supports Analyze and Report functionalities, it operates in a read-only mode, meaning users cannot create new views or models within this interface.



Was this article helpful?