a collaborative multidimensional web-based spreadsheet designed for
Financial Planning and Analysis (FP&A)
Corporate Performance Management (CPM)
What-if Scenario Simulations
than a spreadsheet
- Multidimensional data model: Thousands of worksheets can be managed efficiently. Transform, aggregate or copy millions of cells with just several clicks. The data is always ready for BI and dashboards.
- Reliable formulas: No broken references or endless copy/pasting. Express complex logic with just formulas by using the relations inside the data model instead of error prone VLOOKUPs.
- Multi-user access: Hundreds of users can work with the model simultaneously.
- Security by design: You decide which part of each worksheet is shared with others. Special permissions can be granted to add or remove rows. Only model designers can see or change the formulas.
Easier to use
than a database
- Easy to use, easy to learn: People familiar with spreadsheets can master the system in a matter of one or two days. You can use the same standard functions. Many spreadsheet models can be translated one to one to CubeWeaver.
- No code, only formulas: Data queries, computations, data aggregation, workflow logic, what-if simulations can all be expressed with familiar spreadsheet formulas. A novel cell addressing syntax is the only thing you will need to learn.
- Excel export: Your customer/employer wants to see Excel and nothing else? Export a fully functional model with all formulas to Excel with a single click. Check out the examples.
- Masterdata management: Business objects (like products or customers) are stored as list items. List items can have relations between them. These relations can be used to build hierarchies.
- Multidimensional data model: List items are used to label rows and columns in worksheets. A row is added in all relevant worksheets as soon as a new list item is created.
- Reliable formulas: No broken references and copy/paste errors. The 'area of effect' concept can be used to apply a formula to any number of cells with just several clicks.
- Fine-grained access control: User access can be restricted with a cell-by-cell precision.
- Workflow models: Buttons inside cells with formulas attached to them can be used to create workflow logic and to move the data between years/versions/etc.
- Dynamic cell formatting: Everything is controlled by formulas. You can hide/show cells and change cell color and content based on the data in you worksheets and lists.
- Integration: Data exchange with office software, databases and dashboarding tools is possible via ODATA protocol, REST APIs or .XLSX and .CSV files
- Data visualization: Simple charts and diagrams can be generated inside the application.
- High scalability: Billions of cells and millions of masterdata items can be managed on a dedicated CubeWeaver instance.
- High performance: Even very large models are updated instantly as you update input cells.
- What-if analysis: Multiple sets of parameters can be stored in a separate worksheet with a scenario dimension. Other worksheets will than use these parameters to produce different result for each scenario.
- Excel export: The whole model can be translated to Excel with a single click. All formulas will still work. Check out the examples.