Unlock a new universe of possibilities together with Abacum by using our new MATRIX function 🚀 

The new MATRIX function allows you to multiply a variable by another variable without losing dimensionality.

Let's look at a simple example:

- Variable 1 displays data by Tier.
- Variable 2 displays data by City.

As a result of using MATRIX, variable 3 displays data by BOTH Tier and City.

Considerations

The following is a collection of considerations to ensure the correct best usage of MATRIX:

• If you are only using the MATRIX method in a formula, SUM and FUNCTION dimension aggregation will return the same result.

  The system will auto-assign the SUM dimension aggregation, and we recommend you keep it this way since it will be more performant than using FUNCTION.

Also if you want to find out more about how to use this and other functions, click here.

We've exciting news for you!

Easily transform data in Abacum with our new concatenate transformation 🚀

Effortlessly connect text columns with the & operator - as in Excel or Google Sheets.

To learn more about concatenating columns, please visit this Abacum Academy article.

MANUAL INPUT PANEL is now available on Tables in Spaces too 🧮

Previously, we could only use the Manual Input Panel in the Module Builder. Enabling it for Tables allows Budget Manager users to also enjoy this seamless forecasting experience 🚀

When in either a Tree or Tabular Table used for forecasting, simply double/right-click on any version cell of a manual input line to bring up the panel and edit the underlying values with the input type that the admin has set on the selected variable.

Additionally, you no longer need all dimensions visible for editing forecast inputs ✨
Keep your visualisation nice and clean by customizing your table's dimensions in the Table Builder's Grouping menu. The Manual Input Panel displays all dimensions when opened to allow you to select or create new items as needed.

Finally, if you wish to visualise your output in a quarterly or yearly view, even though the underlying values are set with a monthly input, no problemo, the table timeframe is no longer relevant 📆
Set the table's timeframe that suits your data analysis best, and budget owners will still be able to add their inputs.

Abacum VLOOKUP is here! 🚀

How does it work?

Imagine having the following datasets and you want to bring the department dimension to the Location dataset:

1. Employees, with employee id and department as dimensions.

2. LOCATIONS, with employee id and region as dimensions.

Formula: VLOOKUP department FROM EMPLOYEES on employee_id = employee_id

Organize your variables with custom sections in the Module Builder!

Previously, you were restricted to only three default sections – assumptions, calculations, and output – when arranging your variables and group of variables in a module. 

With our new feature, you can create and personalize your own module sections according to your preferences 🙌  

This should help you improve your modeling experience keeping your data structure clean and organized.

We have exciting news for you! 🚀

You can now sort dimension items both alphabetically (ascending and descending) and by the amount

This new release will help you customize your items order and will save you time analyzing your figures. 

Hint: Currently we are only supporting the sorting option in tree tables.

Add your comparison to your Metric Cards!

Compare important key performance indicators (KPIs) against a version or a previous period in a visually striking manner ⚡

Like in tables, set a comparison against:

• vs last period
• vs the same period from last year
• vs forecast
• vs budget

Keep on using them by typing our command palette "/"

No more unclear mapping fields! Take control and easily customize your  rename dimension levels ✍️

Gone are the days of confusion caused by using level labels in dimension mapping fields. By enabling personalized mapping headers, we improve the readability and clarity of the dimension mappings when building your reports. Once a dimension level label has been updated, the new label values are available for you to work with in all areas of the platform. 

We understand the importance of empowering our customers to be more autonomous on our platform 💪 so we're happy to announce the latest features release:

Create Google Drive datasets directly from the Abacum web app 🚀

No need to rely on our support to handle the creation of these two integration-based datasets from the back office anymore!

After having the API integration setup for these services, you can then take charge and create your datasets autonomously, eliminating unnecessary delays and streamlining your data management process.

Gain insight into your calculations with our advanced transparency featureFORMULA Calculation diagram 

When modeling and performing variable calculations, understanding the processes behind value computation is crucial. Such transparency is not always readily available, and the time it takes to perform these calculations often remains hidden. That's why we have developed this new module builder feature to allow you to delve into the inner workings of your formulas. 

Now you can visualize a calculation diagram that showcases each step in the variable calculation process to understand how a value is derived. By providing you with a clear graphical representation, including the performance metrics at each stage and the ability to download the results of each calculation, we enable you to gain valuable insights into the efficiency of your model.

This transparency opens doors to optimizing your model's performance, by being able to identify potential bottlenecks and pinpoint areas for improvement with ease. 

Say goodbye to uncertainty and unlock the full potential of your calculations with the formula calculation diagram feature!

📝 Note: The calculation diagram is only available for the Actuals formulas at the moment. It will soon be available for the Version (forecast/budget) formulas too!