In the ever-evolving domain of Financial Planning and Analysis (FP&A), professionals constantly seek tools that align with their strategic, analytical, and forward-looking tasks. The Cube Workspace is designed with these needs in mind, ensuring you have a comprehensive and powerful platform for your FP&A activities.
Let's take a look at everything your Workspace has to offer.
Analytics
Dashboards
Dashboards offer a personalized, visual overview of your most vital data, allowing you to gauge your company's health quickly.
For example, you may want to instantly view month-to-date expenses against your projected budget, highlighting areas that might require attention.
Learn more about building dashboards.
Reports
Create templates to standardize data presentation for recurring financial tasks, such as budgeting or forecasting. Templates will appear in this reports area of the Cube web portal.
Develop a monthly financial performance template, ensuring consistent reporting parameters and easing the analysis process.
Note: Template permissions can vary, allowing you to create personal or shared company templates.
Learn more about templates and reports.
Analysis
Quickly uncover variances in your data with our AI report builder.
Learn more about Smart Analysis.
Inputs
Dimensions
Dimensions are the foundation of how your data is structured and accessed, enabling swift data manipulation for planning, budgeting, and forecasting.
Cube offers four predefined dimensions: Account, Department, Scenario, and Time. You can also introduce up to four custom dimensions, such as Product or Vendor.
Each dimension encompasses a hierarchy of child dimension members. Data in the Cube resides at intersections of these child dimension members, ensuring a comprehensive data categorization. For instance, data about "Q1 Sales of Product X in Department Y" provides multifaceted insights, allowing for granular analysis.
Further, you can merge data between scenarios, aiding in year-over-year comparisons.
Formulas
Enhance your FP&A models by creating formula dimension members that compute based on existing data, reducing the need for redundant spreadsheet updates.
Streamline your profitability analysis by defining a Gross Profit formula in Cube that automatically calculates the difference between Revenue and Cost of Goods Sold anytime those values change.
Tags
Create alternative hierarchies for your dimensions using tags to support additional analysis without restructuring your primary dimension architecture.
Differentiate accounts by tagging them as Fixed or Variable Costs, or group departments under specific management domains, enhancing the clarity of your reports.
Source Data
The heart of your analysis in Cube comes from your data integrations, where the synchronization of your organization's data meets Cube's powerful analytics hub. Here, you can manage:
-
Source Systems: Cube integrates with your ERP, CRM, HRIS, or BI tools using an API connection, making data retrieval secure and effortless. Currently, we support integrations with QuickBooks, Xero, NetSuite, Salesforce, Sage Intacct, ChartHop, Tableau, and more.
-
Data Tables: Data tables allow additional sources for organizations looking for more flexibility. While they offer a manual approach to data integration using flat files, they promise unparalleled customization. Whether it's a unique financial metric or a specific data set worth exploring, infuse Cube with this data table and make your analysis even more comprehensive.
Learn more about importing data to Cube.
Outputs
Audit Trail
Maintain the integrity of your financial data using the audit trail to track modifications to Cube data. It's an assurance of transparency and accountability for your team as you work across the Cube ecosystem.
Example: Trace an unexpected spike in the marketing budget for next quarter to a particular input change made by a team member using the Cube spreadsheet add-on two weeks ago and read their change message.
Learn more about the audit trail.
Library
Store and manage cloud-based data and files in the library so your team can pull reports directly from the Cube Workspacel. The library provides a centralized location to keep track of all the spreadsheets that non-finance users or budget owners can use. It is particularly helpful for non-finance Cubers.
For example, a marketing manager could open the "Marketing Budget 2022" from the library, update their budget detail, and publish the data to the cloud with one click.
Note: While Library reports are available to all users in Cube, the ability to fetch and publish data within each report depends on that user's specific permissions.
Learn more about using the library to share files.
Data Exporter
Filter and extract data directly from Cube, customizing your datasets for specialized tasks.
Example: Export quarterly revenue figures for a specific region to craft a tailored sales strategy.
Learn how to export data from Cube.
Settings
User Management
Invite users and manage their permissions, ensuring data security and functional integrity.
In addition to the permissions automatically granted based on role, each user's permissions can be customized to make certain dimensions or categories of your data private and allow or prevent the user from modifying certain financial data.
Learn how to invite users and modify permissions.
Currencies
Operate in a global marketplace? Manage and set up currency conversion rates to ensure accurate financial reporting.
Note: This page is only available if currencies are enabled in your Cube. If you would like to upgrade your Cube to use multiple currencies, please contact our support team.
Learn how to work with multiple currencies in Cube
Apps
Access the installation pages to integrate Cube with Microsoft Excel or Google Sheets, bridging the gap between traditional spreadsheet modeling and advanced FP&A software capabilities. Learn more about using our spreadsheet Apps.
Or install Cube for Slack or Teams to get insights into your data from our agentic AI. Learn more about using AI at Cube.