Table of Contents

Acterys 20.1 introduces revolutionary new features for analytics and planning processes setting new standards for:

Watch the Launch Event here:

Major New Features in Acterys 20.1

Write Back From Power BI to any source

Virtual Data Warehousing

  • Add nearly any data source (Analysis Services, SaaS, any database, SharePoint, etc.) instantly AND write directly to that source

Visuals

Conditional Formatting, Comment Markers, Custom Aggregations in Power BI

Acterys Matrix Power BI Visual:

  • Custom aggregations
  • Cell-based comments
  • Conditional formatting

Acterys Variance Analysis for Power BI

Acterys Variance Power BI Visual

Acterys Gantt Chart Power BI Visual + Write Back

New Acterys Gantt Power BI Visual

Task Planning in Power BI with Microsoft Planner

Table Edit

  •  Dynamic Linked Columns

Apps

Cube Wizard

  • Update dimensions, saving of SQL profiles

Acterys Apps/Connectors

  • HubSpot and Dear Inventory Connectors
  • New Xero Cashflow forecasting template
  • New “Trial Balance Report” Table for Xero that includes “unrealised currency gains” and other items that are not available via the journals API
  • New “Users” table for Xero that provides a comprehensive view of all users in a group
  • New “Quotes” table for Xero

Acterys Modeller

  • Web User Rights Admin UI

Excel

  • New high-performance Cell Formulas replacing slow Excel CUBEVALUE formulas

AI_ML_assisted_ planning_for_Power_BI

Advanced Analytics, Machine Learning, AI

  • R/Python Integration and write back
  • New algorithms for ARIMA, XG Boost, Regression Trees