loader image


Share on facebook
Share on twitter
Share on linkedin

Acterys 20.1 Released!

Acterys 20.1 Is Here!

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

  • Versatility
  • Ease of Data Integration and
  • Value For Money

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


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

  • Small multiples analysis & planning

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


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


  • 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

Recent Posts

I can’t help smiling when I see legacy BI/Planning application vendors -that were not so long ago laughing away Power BI- coming out with their own “Power BI Integration” after Microsoft has turned around the industry. These are more often than not nothing but “a marketing spiel” to build on Power BI’s awareness and of very limited use in real life application scenarios.

Across many mid-sized and large companies, finance and operations teams are at crossroads. This was one of the findings from the recent BPM Pulse 2021 survey which revealed that only a third of companies had truly harmonized strategic, financial, and operational plans.

Power BI offers unparalleled features for analysis and visualization: in this post we explain the quickest way to connect Oracle Netsuite in Power BI Deskop and how you can add comprehensive planning and budgeting.After your account has been setup, click on the “Integration” menu and go to the “Oracle Netsuite” section:

The default visuals in Power BI are not perfectly suited for financial reporting. There are ways to realize more advanced financial reporting requirements using DAX as Managility describes in Income Statement using DAX These, though typically require intermediate knowledge of DAX that many financial professional don’t necessarily have.

The Acterys Modeller is cloud based service (with on-premise installation option) that allows enables business users to automatically create optimal analysis models (star schema data warehouse) from a variety to ERP. accounting and SaaS systems. The created models are write and planning enabled and can be edited and extended as needed by business users e.g. for adding new products/attributes, account mappings, new scenarios etc.