Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt

Use this file to discover all available pages before exploring further.

Atoti is designed to fit into any data analytics architecture. It operates between data sources and visualization tools and delivers fast, precise and interactive analytics. Business users can query Atoti using multiple front ends. The recommended interface is Atoti UI, but users can also connect through third-party tools like Excel, Tableau, and Power BI. This flexibility allows users to work with Atoti using the tools they are most comfortable with.

​
Use Atoti UI

Atoti UI is the native graphical interface for Atoti. It enables users to explore large-scale financial data using advanced pivot tables, interactive dashboards, and customizable visualizations. Atoti UI supports all Atoti features, including context values and real-time updates. It is continuously tested and updated alongside the Atoti platform to ensure full compatibility and reliability. Atoti Python SDK automatically contains Atoti UI. No further set up is required. Find out how to install Atoti UI for Atoti Java SDK.

​
Prepare Atoti UI for business users

Atoti UI can be deployed as soon as it is installed. However, many of our clients choose to extend and personalize the interface. This includes simple tasks like applying your organization’s brand colors, as well as more complex ones such as building custom widgets. Find out more about how to prepare Atoti UI for business users.

​
Use Excel to query Atoti

Access Atoti from an Excel pivot table, using the built-in drivers for Microsoft Analysis Services. Find out more about how to do this: The Atoti Excel Add-In provides some additional features for a more powerful and user-friendly experience. It is available for Atoti Java SDK. It requires an additional installation step.

​
Advantages of Atoti Excel Add-in

  • Allow users to drillthrough into special datagrids and widgets in Excel and bypass the Excel row limit
  • Refresh the pivot table when real-time updates occur
  • Move through sliced filters more easily using next and previous buttons
  • View and configure context values
  • View MDX queries executed by the pivot table
Find out how to

​
Use Tableau to query Atoti

Tableau can be used to query Atoti using the Atoti BI Adapter. Users are able to access data and query Atoti using dedicated widgets. The Atoti BI Adapter requires an extra installation step which is carried out by the developer team in your company. Follow this link to find out more about Atoti BI Adapter for Tableau.

​
Use Power BI to query Atoti

Power BI can be used to query Atoti by importing data from Atoti into Power BI. Find out more about working with Atoti and Power BI.

​
Prepare a custom front end for business users

We recommend using Atoti UI as the front end for business users. However, it is also possible to integrate Atoti into a custom front end. If you are preparing a custom front end for business users you will need to take the following into account. Click on the links to find out more: We make available a series of REST APIs and websockets to help with this: