https://store-images.s-microsoft.com/image/apps.12167.af07987f-8425-4052-b6e6-a21257758fce.23986e15-03f5-4842-bd89-3c92fb9dc2e3.6b7b4d63-2079-4914-a2e4-2cb949988a2c

Acterys Matrix Planning For Power BI Gen2

by Managility

(60 ratings)
Download SampleInstructions

Acterys Matrix enables comprehensive write back & planning from Power BI

Acterys Matrix is an evolution of the classic Acterys Matrix Power BI visual that adds support for handling DAX subtotals. It enables write-back and planning on any level of the data model with flexible allocation options. It is part of Acterys an integrated solution for data warehouse automation, business modelling as well as planning & forecasting with connectivity to accounting and SaaS platforms like Dynamics, SAP, Oracle NetSuite, Xero, QuickBooks, HubSpot, Xero etc.

Acterys enables business users to build and manage analytical applications supported by a variety of templates like budgeting/forecasting, legal consolidation, CAPEX, cash flow, risk/ compliance, ESG and HR among others and enter data for all these purposes directly from Power BI.

Features:

  • Top down / bottom-up entry on any level of the matrix with automated distribution to detail level
  • Wide variety of entry options: fill right to end of period, same amount to every child, custom distributions
  • Conditional formatting
  • Comment markers
  • Drill down in columns
  • Persistent state of visual: drill down in hierarchy not lost after refresh
  • Custom aggregations and in-visual calculations
  • Custom tool tips & drill through
  • Dynamic cell locking
  • Data entry validation rules

Benefits

  • The quickest way to setup your budget, planning and forecasting forms
  • Automated integration with ERP & SaaS systems
  • Governance and audit trail

IMPORTANT

The read features of Acterys Matrix will work without an Acterys subscription. All write-back features require a free trial at: https://www.acterys.com

Visual capabilities

When this visual is used, it
  • Can access external services or resources

At a glance

https://store-images.s-microsoft.com/image/apps.39125.af07987f-8425-4052-b6e6-a21257758fce.6a00468a-b440-4ba5-ae94-d6f9256bd728.12bd8e81-b689-487f-b8e6-02d2240f693b
/staticstorage/6f4f0c1/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.39125.af07987f-8425-4052-b6e6-a21257758fce.6a00468a-b440-4ba5-ae94-d6f9256bd728.12bd8e81-b689-487f-b8e6-02d2240f693b
https://store-images.s-microsoft.com/image/apps.17551.af07987f-8425-4052-b6e6-a21257758fce.c39cbcd4-acf4-43e5-8eea-d00654504000.6b515b78-4323-4ef0-8956-9bb21c7111d7
https://store-images.s-microsoft.com/image/apps.12707.af07987f-8425-4052-b6e6-a21257758fce.23986e15-03f5-4842-bd89-3c92fb9dc2e3.2f57213b-7a43-4460-9fb2-3c00322e01d6
https://store-images.s-microsoft.com/image/apps.5574.af07987f-8425-4052-b6e6-a21257758fce.6a00468a-b440-4ba5-ae94-d6f9256bd728.d04da319-40c2-4378-a0a4-5ed333362083