Documentation Index
Fetch the complete documentation index at: https://pluvo-02a06e95.mintlify.app/llms.txt
Use this file to discover all available pages before exploring further.
Please contact support@pluvo.io to activate dimensions in your organization.
Why Use Dimensions?
While variables are the backbone of your financial model, dimensions help you slice and segment those variables in meaningful ways. For example:- Break down headcount by department
- Track revenue by region
- Allocate expenses across projects
- Analyze COGS by SKU
When to Use Dimensions
You’ll want to use dimensions any time you’re managing repeating categories that share the same structure. This is especially useful when:- You want to compare multiple entities or segments side by side
- You want to build formulas that adapt to different dimension values
- You want to roll up or filter data in reports without manual rework
Example:
Forecasting Salaries with Hierarchical Dimensions Let’s say you’re building a salary forecast for your company. Without dimensions, you’d need to create separate variables for every department or team—likeSalary_Engineering, Salary_Sales, Salary_CS, etc. That gets messy fast, especially if your org grows or restructures.
Instead, you create a single variable: Employee SalariesThen, you assign a Department dimension to it, which might look like:
- Engineering
- Sales
- Customer Success
- Marketing
Adding a Hierarchical Dimension
Let’s say your company operates in multiple regions—US, EMEA, and APAC—and each department exists in each region. Rather than creating 15+ individual variables (Sales_US, Sales_EMEA, Sales_APAC…), you add a Region dimension nested under Department. For example:Department → RegionEngineering → USEngineering → EMEASales → USSales → APAC
Now you can plan and report salaries at any level of granularity:
For Reporting
- Roll up salaries across all departments in APAC
- Compare Engineering salaries between US and EMEA
- Show total Sales salaries across all regions
- Filter a report down to just Customer Success in EMEA
For Planning
- Model hiring plans by department and region (e.g. 3 engineers in EMEA, 5 in US)
- Apply different assumptions by region (e.g. higher salaries in the US)
- Forecast regional expansions just by adding a new region to the dimension—no need to restructure your mode
Why It Matters
Dimensions make your models scalable. Hierarchical dimensions make them powerful. They allow you to:- Keep your models clean, even as your org becomes more complex
- Plan and report across many views—without duplicating logic
- Build once, then slice, filter, and explore however you need
Ready to get started with Dimensions?
- Dimension Basics
Learn how to create and manage dimensions, and see examples of common use cases. - Dimensions in Formulas
Learn how to reference dimensions in formulas, use functions likesumifandcountif, and build dynamic logic across categories.