# Atoti Hub

## Docs

- [How to configure Auto-Explain](https://docs.activeviam.com/atoti-intelligence/6.1/developer-guide/enable-ai-tools/atoti-java-sdk/auto-explain/configuration.md): How to configure Auto-Explain in `application.yaml` for an Atoti Java project, covering per-cube hierarchy inclusion and exclusion, algorithm constants such as `max-depth`, `max-entropy`, contribution thresholds, and a worked example of the recursive tree search.
- [How to set up Auto-Explain](https://docs.activeviam.com/atoti-intelligence/6.1/developer-guide/enable-ai-tools/atoti-java-sdk/auto-explain/setup.md): How to add the Auto-Explain Spring Boot starter to an Atoti Java project, including the `pom.xml` dependency for Atoti Intelligence Essentials and steps to verify the context menu option in the Atoti UI pivot table.
- [How to configure Visualize This](https://docs.activeviam.com/atoti-intelligence/6.1/developer-guide/enable-ai-tools/atoti-java-sdk/chat/configuration.md): How to supply cube context to Visualize This via `application.yaml`, covering `system-prompt-paths`, cube and dimension descriptions, hierarchy levels, the `XMLA_DESCRIPTION` OLAP schema property as an alternative, and partial configuration for selective elements.
- [How to set up Visualize This](https://docs.activeviam.com/atoti-intelligence/6.1/developer-guide/enable-ai-tools/atoti-java-sdk/chat/setup.md): How to add the Visualize This Spring Boot starter to an Atoti Java project, including the `pom.xml` dependency, the required LLM configuration prerequisite, and verification that the AI assistant appears in Atoti UI.
- [Customize the AI disclaimer](https://docs.activeviam.com/atoti-intelligence/6.1/developer-guide/enable-ai-tools/atoti-java-sdk/disclaimer.md)
- [How to set up and configure Amazon Bedrock](https://docs.activeviam.com/atoti-intelligence/6.1/developer-guide/enable-ai-tools/atoti-java-sdk/llm-set-up/amazon-bedrock.md): How to add Amazon Bedrock as the LLM provider for Atoti Intelligence via Spring AI, including the `starter-ai-bedrock` Maven dependency, `application.yaml` configuration for AWS credentials, region, and Converse API model selection.
- [LLM configuration](https://docs.activeviam.com/atoti-intelligence/6.1/developer-guide/enable-ai-tools/atoti-java-sdk/llm-set-up/llm-config.md): LLM configuration overview for Atoti Intelligence using Spring AI, explaining why a custom model is required, which providers are supported (Amazon Bedrock, OpenAI), and where to find provider-specific `application.yaml` guides.
- [How to set up and configure OpenAI](https://docs.activeviam.com/atoti-intelligence/6.1/developer-guide/enable-ai-tools/atoti-java-sdk/llm-set-up/openai.md): How to add OpenAI as the LLM provider for Atoti Intelligence via Spring AI, including the `spring-ai-starter-model-openai` Maven dependency, `application.yaml` API key and model configuration, and support for OpenAI-compatible APIs.
- [How to add custom tools](https://docs.activeviam.com/atoti-intelligence/6.1/developer-guide/mcp-server/custom-tools.md): How to extend the Atoti MCP Server with user-defined tools using Spring AI `@Tool`, `@ToolParam`, and `MethodToolCallbackProvider`, including an implementation example, tool method requirements, and verification steps.
- [What is the Atoti MCP server?](https://docs.activeviam.com/atoti-intelligence/6.1/developer-guide/mcp-server/introduction.md): What the Atoti MCP Server is and why to use it, covering how it exposes Atoti cubes, hierarchies, measures, and custom tools to any MCP-compatible LLM client such as Claude Desktop, with no vendor lock-in via a standardized protocol.
- [Atoti MCP server setup guide](https://docs.activeviam.com/atoti-intelligence/6.1/developer-guide/mcp-server/setup/atoti-mcp-server-setup.md): How to add the Atoti MCP Server to an Atoti Java project via the `starter-ai-mcp-server` and `mcp-server-spring` Maven dependencies, with steps to verify the MCP server initializes and the `/sse` endpoint is accessible.
- [How to connect with Claude](https://docs.activeviam.com/atoti-intelligence/6.1/developer-guide/mcp-server/setup/connect-with-claude.md): How to configure Claude Desktop to connect to the Atoti MCP Server, including the `mcpServers` JSON configuration block, `mcp-remote` via `npx`, Base64 Basic Auth passkey generation, and tool discovery verification steps.
- [How to connect with Postman](https://docs.activeviam.com/atoti-intelligence/6.1/developer-guide/mcp-server/setup/connect-with-postman.md): How to test and debug the Atoti MCP Server with Postman, including Basic Auth configuration, tool discovery via SSE, JSON-RPC `tools/call` POST request format, response interpretation, and custom tool validation.
- [What is the MCP credentials page?](https://docs.activeviam.com/atoti-intelligence/6.1/developer-guide/mcp-server/setup/mcp-credentials-page.md)
- [Monitoring](https://docs.activeviam.com/atoti-intelligence/6.1/developer-guide/monitoring.md): How to collect diagnostic information for Atoti Intelligence at runtime, including DEBUG logging for Auto-Explain and Visualize This in `application.yaml`, Spring AI logback configuration, and resolutions for MCP server context path and keep-alive issues.
- [How to set up the frontend](https://docs.activeviam.com/atoti-intelligence/6.1/developer-guide/ui-chat/setup.md): How to add the `@activeviam/ai-extension` to the Atoti UI for Visualize This and Auto-Explain, covering the integrated `extensions.json` approach for Java projects and the standalone `package.json` and `pnpm` build approach.
- [Introduction to Atoti Intelligence](https://docs.activeviam.com/atoti-intelligence/6.1/intro/intro.md): Atoti Intelligence lets risk managers, traders, and analysts query live financial data in natural language, with accurate and auditable results that general-purpose AI tools cannot deliver.
- [How Atoti connects with LLMs](https://docs.activeviam.com/atoti-intelligence/6.1/intro/intro-LLM-and-MCP.md): How Atoti Intelligence connects to external LLMs using Spring AI, covering the two integration modes: direct LLM configuration for Atoti UI and the Atoti MCP Server bridge for third-party tools such as Claude Desktop and ChatGPT.
- [Atoti Intelligence tools](https://docs.activeviam.com/atoti-intelligence/6.1/intro/tools.md): What Auto-Explain and Visualize This do in Atoti Intelligence, including automated root-cause analysis of metric variations, natural language visualization creation, and cube structure querying via an integrated LLM assistant.
- [Changelog](https://docs.activeviam.com/atoti-intelligence/6.1/releases-and-upgrades/changelog.md)
- [Compatibility](https://docs.activeviam.com/atoti-intelligence/6.1/releases-and-upgrades/compatibility.md)
- [Release notes](https://docs.activeviam.com/atoti-intelligence/6.1/releases-and-upgrades/release-notes.md)
- [Auto-Explain user guide](https://docs.activeviam.com/atoti-intelligence/6.1/user-guide/auto-explain.md): How to access and use Auto-Explain in Atoti UI to identify the root causes of metric changes, covering pivot table cell selection, context menu access, result interpretation, and contribution percentage output.
- [Visualize This user guide](https://docs.activeviam.com/atoti-intelligence/6.1/user-guide/chat.md): How to interact with the Visualize This AI assistant in Atoti UI, covering natural language requests for charts and dashboards, cube knowledge queries, and the types of visualizations the assistant generates from Atoti-specific tool context.
- [Atoti Intelligence documentation](https://docs.activeviam.com/atoti-intelligence/atoti-intelligence.md)
- [How Atoti connects data sources to visualization tools](https://docs.activeviam.com/concepts/atoti-and-data-analytics/atoti-data-analytics.md): Connect Atoti to Atoti UI, Excel, Tableau, and Power BI, or build a custom front end using the XMLA endpoint, REST APIs, and WebSocket API for real-time pivot table and dashboard queries.
- [What is the Atoti Content Server?](https://docs.activeviam.com/concepts/atoti-components/atoti-content-server.md): The Atoti Content Server provides the content service, a required hierarchical key-value store exposed via REST API, storing dashboards, calculated measures, and user settings across embedded or standalone deployments with optional Hibernate-backed relational storage.
- [Introduction to Atoti dimensions and hierarchies](https://docs.activeviam.com/concepts/cube/hierarchies.md): How Atoti organizes multidimensional data using dimensions, hierarchies, and levels, including single-level and multi-level hierarchies, slicing hierarchies, derived hierarchies, and data bucketing.
- [Introduction to measures](https://docs.activeviam.com/concepts/cube/measures.md): How Atoti supports aggregated measures, store look-up measures, and user-defined measures, including measure chains, filters, logical-level aggregation, measure shifting, and null handling.
- [What is the database in Atoti?](https://docs.activeviam.com/concepts/database/database.md): How Atoti handles fact-level data using an in-memory datastore with columnar storage and indexes, and DirectQuery for external databases, including a hybrid approach for cost and performance optimization.
- [What is a database schema?](https://docs.activeviam.com/concepts/database/database-schema.md): How Atoti database schemas work, including star and snowflake schema structures, table references and joins, isolated tables for lookup data, and supported field types including vectors.
- [What is Atoti?](https://docs.activeviam.com/concepts/intro.md): Atoti is a real-time analytics platform combining an aggregation engine, an in-memory datastore, and a multidimensional semantic model to deliver fast and consistent analytics across applications and workflows.
- [How DirectQuery connects to external databases](https://docs.activeviam.com/concepts/load-data/DirectQuery.md): How DirectQuery connects Atoti to external databases such as Snowflake and BigQuery without loading data into memory, covering data requirements, versioning with native and emulated time-travel, and incremental or full refresh.
- [How Atoti manages ETL](https://docs.activeviam.com/concepts/load-data/etl.md): How the Atoti Java SDK ETL framework extracts and transforms data using Sources, Channels, and Tuple Publishers, covering CSV, Parquet, JDBC, cloud storage, and column calculators for data enrichment.
- [How to bring data into Atoti](https://docs.activeviam.com/concepts/load-data/load-data.md): How to bring data into Atoti's in-memory datastore from CSV, Parquet, JDBC, Kafka, and cloud sources using datastore transactions, or query large external databases without loading via DirectQuery.
- [How aggregate providers can speed query time](https://docs.activeviam.com/concepts/performance/aggregate-providers.md): How Atoti aggregate providers control pre-aggregation strategy, covering the JIT provider for on-demand aggregation, leaf provider for pre-aggregated indexes, and bitmap provider for high-concurrency workloads.
- [How modifying the aggregates cache can speed query time](https://docs.activeviam.com/concepts/performance/aggregates-cache.md): How the Atoti aggregates cache stores previously computed measure-location pairs to avoid recalculation, including cache size configuration, caching strategies, and when to enable or avoid the cache.
- [How to understand the data journey](https://docs.activeviam.com/concepts/performance/data-journey.md): How data flows through Atoti from extraction and transformation to loading, including column calculators, tuple publishers, partitioning, NUMA-aware memory allocation, and the impact of each stage on performance.
- [How JVM tuning can improve Atoti performance](https://docs.activeviam.com/concepts/performance/jvm-tuning.md): How JVM tuning improves Atoti Java SDK performance by sizing heap memory for query execution and off-heap memory for datastore structures, and when to tune to avoid OutOfMemoryError and GC pauses.
- [How partitioning and NUMA awareness can improve data loading and query time](https://docs.activeviam.com/concepts/performance/partitioning.md): How Atoti partitioning distributes data across partitions for parallel processing and partition skipping, NUMA-aware placement on multi-socket servers, modulo and value-based strategies, and partitioning constraints.
- [How to optimize Atoti performance](https://docs.activeviam.com/concepts/performance/performance-strategies.md): How to identify the right Atoti performance strategy based on whether the bottleneck is in the data journey or query journey, covering aggregate providers, partitioning, virtual hierarchies, JVM tuning, aggregate cache, query plan, and query limits.
- [How to understand the query journey](https://docs.activeviam.com/concepts/performance/query-journey.md): How Atoti executes MDX queries through GAQs and a computation graph, resolving measures from the aggregate cache, aggregate providers, datastore, or DirectQuery, and how the query plan and query limits affect performance.
- [How query limits prevent resource overloads](https://docs.activeviam.com/concepts/performance/query-limits.md): How Atoti query limits control resource usage by restricting query processing time, intermediate and transient result sizes, and concurrent MDX query counts to prevent overloads and keep dashboards responsive.
- [How the query plan can help troubleshoot slow queries](https://docs.activeviam.com/concepts/performance/query-plan.md): How the Atoti query plan records execution steps, dependencies, timing, result sizes, and retrieval methods for each query, and how to use the Atoti Query Analyser to diagnose slow queries.
- [How virtual hierarchies can speed data loading](https://docs.activeviam.com/concepts/performance/virtual-hierarchies.md): How Atoti virtual hierarchies reduce data loading time and memory usage by deferring member population to query time, when to use them for high-cardinality fields, and when to avoid them.
- [What are one-off and continuous loading?](https://docs.activeviam.com/concepts/versions/one-off-vs-continuous.md): How Atoti supports one-off and continuous data loading, including file-based watching, streaming query updates, long polling, and incremental refresh for DirectQuery, with source-by-source loading capabilities.
- [What are datastore transactions in Atoti?](https://docs.activeviam.com/concepts/versions/transactions.md): How Atoti datastore transactions apply changes atomically, lock tables to maintain referential integrity, support isolated table concurrency, and expose timing metrics for monitoring throughput.
- [How Atoti manages data versioning](https://docs.activeviam.com/concepts/versions/versions.md): How Atoti manages data versioning using versions, epochs, and branches in the in-memory datastore, and how DirectQuery versioning depends on external database time-travel support and manual refresh.
- [How to connect to the Atoti documentation MCP server](https://docs.activeviam.com/connect-mcp-server.md): Connection instructions for the Atoti documentation MCP server, covering Claude, Claude Code, Cursor, and VS Code with GitHub Copilot
- [Data visualization](https://docs.activeviam.com/data-visualization/data-visualization.md)
- [Changelog](https://docs.activeviam.com/data-visualization/excel-addin/changelog.md)
- [Atoti Excel Add-in: enhance your experience of Atoti in Excel](https://docs.activeviam.com/data-visualization/excel-addin/overview.md)
- [Atoti Engine documentation](https://docs.activeviam.com/engine/engine.md)
- [Atoti Concepts in a Nutshell](https://docs.activeviam.com/engine/java-sdk/6.1/concepts/concepts_in_a_nutshell.md)
- [Data Versioning (MVCC)](https://docs.activeviam.com/engine/java-sdk/6.1/concepts/data_versioning.md)
- [Dimensions and Hierarchies](https://docs.activeviam.com/engine/java-sdk/6.1/concepts/dimensions_and_hierarchies.md)
- [Partitioning and NUMA awareness in Atoti](https://docs.activeviam.com/engine/java-sdk/6.1/concepts/partitioning.md)
- [Internationalization](https://docs.activeviam.com/engine/java-sdk/6.1/configuration/internationalization.md)
- [Java version compatibility](https://docs.activeviam.com/engine/java-sdk/6.1/configuration/java_version.md)
- [Memory Management](https://docs.activeviam.com/engine/java-sdk/6.1/configuration/memory_management.md)
- [Configuration Overview](https://docs.activeviam.com/engine/java-sdk/6.1/configuration/overview.md)
- [Serving Atoti on a subpath](https://docs.activeviam.com/engine/java-sdk/6.1/configuration/serving_on_a_subpath.md)
- [Content service](https://docs.activeviam.com/engine/java-sdk/6.1/content_server/cs_overview.md)
- [Advanced topics](https://docs.activeviam.com/engine/java-sdk/6.1/copper/copper_advanced.md)
- [The API](https://docs.activeviam.com/engine/java-sdk/6.1/copper/copper_api.md)
- [Creating and publishing hierarchies](https://docs.activeviam.com/engine/java-sdk/6.1/copper/copper_hierarchies.md)
- [Presentation](https://docs.activeviam.com/engine/java-sdk/6.1/copper/copper_intro.md)
- [Joining isolated stores in Copper](https://docs.activeviam.com/engine/java-sdk/6.1/copper/copper_join.md)
- [Creating and publishing measures](https://docs.activeviam.com/engine/java-sdk/6.1/copper/copper_measures.md)
- [Measure and hierarchy publication](https://docs.activeviam.com/engine/java-sdk/6.1/copper/copper_publication.md)
- [Handling Dates](https://docs.activeviam.com/engine/java-sdk/6.1/core_features/dates.md)
- [Numerical data in Atoti Server](https://docs.activeviam.com/engine/java-sdk/6.1/core_features/numerical_data.md)
- [Vectors in Atoti Server](https://docs.activeviam.com/engine/java-sdk/6.1/core_features/vectors.md)
- [How to Checkpoint an Atoti application](https://docs.activeviam.com/engine/java-sdk/6.1/crac/how_to_checkpoint.md)
- [How to Restore an Atoti application](https://docs.activeviam.com/engine/java-sdk/6.1/crac/how_to_restore.md)
- [Checkpoint and Restore an Atoti application](https://docs.activeviam.com/engine/java-sdk/6.1/crac/overview.md)
- [CRaC Command-Line Options](https://docs.activeviam.com/engine/java-sdk/6.1/crac/vm_options.md)
- [Aggregate Cache](https://docs.activeviam.com/engine/java-sdk/6.1/cube/aggregate_cache.md)
- [Aggregation Functions](https://docs.activeviam.com/engine/java-sdk/6.1/cube/aggregation-functions.md)
- [Analysis hierarchies](https://docs.activeviam.com/engine/java-sdk/6.1/cube/analysis_hierarchies.md)
- [Cube Configuration](https://docs.activeviam.com/engine/java-sdk/6.1/cube/configuration.md)
- [Context Values](https://docs.activeviam.com/engine/java-sdk/6.1/cube/context_values.md)
- [Continuous Queries Overview](https://docs.activeviam.com/engine/java-sdk/6.1/cube/continuous_queries_overview.md)
- [Continuous Query Engine](https://docs.activeviam.com/engine/java-sdk/6.1/cube/continuous_query_engine.md)
- [Cube Filters](https://docs.activeviam.com/engine/java-sdk/6.1/cube/filtering.md)
- [Aggregates Continuous Handlers](https://docs.activeviam.com/engine/java-sdk/6.1/cube/handlers.md)
- [Dimension and hierarchy Configuration](https://docs.activeviam.com/engine/java-sdk/6.1/cube/hierarchy_configuration.md)
- [Level Configuration](https://docs.activeviam.com/engine/java-sdk/6.1/cube/level_configuration.md)
- [Cube Locations](https://docs.activeviam.com/engine/java-sdk/6.1/cube/locations.md)
- [Custom Member Properties](https://docs.activeviam.com/engine/java-sdk/6.1/cube/member_properties.md)
- [Aggregation & Analytics Overview](https://docs.activeviam.com/engine/java-sdk/6.1/cube/overview.md)
- [Post-Processors](https://docs.activeviam.com/engine/java-sdk/6.1/cube/postprocessors.md)
- [Aggregate Provider](https://docs.activeviam.com/engine/java-sdk/6.1/cube/providers/aggregate_provider.md)
- [AI-based Optimizer](https://docs.activeviam.com/engine/java-sdk/6.1/cube/providers/ai_optimizer.md)
- [Dynamic Aggregate Provider (experimental)](https://docs.activeviam.com/engine/java-sdk/6.1/cube/providers/dynamic_aggregate_provider.md)
- [Streaming Overview](https://docs.activeviam.com/engine/java-sdk/6.1/cube/streaming_overview.md)
- [Database API](https://docs.activeviam.com/engine/java-sdk/6.1/database/database_api.md)
- [Database Overview](https://docs.activeviam.com/engine/java-sdk/6.1/database/database_overview.md)
- [Database Queries](https://docs.activeviam.com/engine/java-sdk/6.1/database/database_queries.md)
- [Chunks](https://docs.activeviam.com/engine/java-sdk/6.1/datastore/chunks.md)
- [Datastore Configuration](https://docs.activeviam.com/engine/java-sdk/6.1/datastore/datastore_config.md)
- [Monitoring on the Datastore](https://docs.activeviam.com/engine/java-sdk/6.1/datastore/datastore_monitoring.md)
- [Datastore Transactions](https://docs.activeviam.com/engine/java-sdk/6.1/datastore/datastore_transactions.md)
- [How to edit datastore content](https://docs.activeviam.com/engine/java-sdk/6.1/datastore/how_to_edit_datastore_content.md)
- [How to register update-where procedures](https://docs.activeviam.com/engine/java-sdk/6.1/datastore/how_to_register_update_where_procedures.md)
- [How to use Transaction Record Blocks](https://docs.activeviam.com/engine/java-sdk/6.1/datastore/how_to_use_transaction_record_blocks.md)
- [Indexing the Stores](https://docs.activeviam.com/engine/java-sdk/6.1/datastore/store_indexing.md)
- [Update-where procedures](https://docs.activeviam.com/engine/java-sdk/6.1/datastore/update_where_procedures.md)
- [Aggregate Tables](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/aggregate-tables.md)
- [Compatibility with Databases](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/compatibility.md)
- [Composite Database](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/composite-database.md)
- [Connect to BigQuery](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/connect_to_external/connect_to_bigquery.md)
- [Connect to ClickHouse](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/connect_to_external/connect_to_clickhouse.md)
- [Connect to Databricks](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/connect_to_external/connect_to_databricks.md)
- [Connect to Microsoft SQL Server](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/connect_to_external/connect_to_mssql.md)
- [Connect to Redshift](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/connect_to_external/connect_to_redshift.md)
- [Connect to Snowflake](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/connect_to_external/connect_to_snowflake.md)
- [Connect to Synapse](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/connect_to_external/connect_to_synapse.md)
- [Connecting to remote Database](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/connect_to_external/intro.md)
- [Google BigQuery](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/databases/bigquery.md)
- [ClickHouse](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/databases/clickhouse.md)
- [Databricks](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/databases/databricks.md)
- [Introduction](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/databases/introduction.md)
- [Generic JDBC](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/databases/jdbc.md)
- [Microsoft SQL Server](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/databases/mssql.md)
- [Amazon Redshift](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/databases/redshift.md)
- [Snowflake](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/databases/snowflake.md)
- [Microsoft Azure Synapse](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/databases/synapse.md)
- [Supported aggregation functions with DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/directquery-agg-functions.md)
- [Clustering fields in DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/directquery-clustering-fields.md)
- [Performance considerations with DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/directquery-performance-considerations.md)
- [Vectors in DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/directquery-vectors.md)
- [DirectQuery Local Cache](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/directquery_local_cache.md)
- [Monitoring in DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/directquery_monitoring.md)
- [Time-Travel Emulation](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/emulated-time-travel.md)
- [External data validation](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/external-data-validation.md)
- [Getting Started](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/getting_started.md)
- [Create and customize a Table](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/how_to/customize_table.md)
- [Create and use a DirectQuery local cache](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/how_to/define_and_use_cache.md)
- [Incremental Refresh](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/how_to/incremental-refresh-how-to.md)
- [Use custom types](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/how_to/use_custom_types.md)
- [How-to use hierarchies](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/how_to/use_hierarchies_with_direct_query.md)
- [How to use vectors](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/how_to/use_vector_in_table.md)
- [User Defined Aggregation Functions](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/how_to/user_defined_aggregation.md)
- [Wait for cube feeding](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/how_to/wait_cube_feeding.md)
- [How-To Guides](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/how_to_guides.md)
- [Incremental Refresh](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/incremental-refresh.md)
- [Incremental Refresh advanced](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/incremental-refresh-advanced.md)
- [Relationship Optionality](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/relationship-optionality.md)
- [Split granular data between in-memory datastore and DirectQuery database](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/split-in-memory-directquery.md)
- [Versioning](https://docs.activeviam.com/engine/java-sdk/6.1/directquery/versioning.md)
- [Distributed Architecture Communication Flows](https://docs.activeviam.com/engine/java-sdk/6.1/distributed/communication_flow.md)
- [What is data overlap?](https://docs.activeviam.com/engine/java-sdk/6.1/distributed/data_overlap.md)
- [Distributed Data Roll Over](https://docs.activeviam.com/engine/java-sdk/6.1/distributed/distributed_data_roll_over.md)
- [Distributed Architecture Guide](https://docs.activeviam.com/engine/java-sdk/6.1/distributed/distributed_getting_started.md)
- [Distributed Architecture Overview](https://docs.activeviam.com/engine/java-sdk/6.1/distributed/distributed_intro.md)
- [Distributed Post-Processors](https://docs.activeviam.com/engine/java-sdk/6.1/distributed/distributed_post_processors.md)
- [Distribution Properties](https://docs.activeviam.com/engine/java-sdk/6.1/distributed/distributed_properties.md)
- [Recommendations](https://docs.activeviam.com/engine/java-sdk/6.1/distributed/distributed_recommendations.md)
- [What-If](https://docs.activeviam.com/engine/java-sdk/6.1/distributed/distributed_what_ifs.md)
- [Distribution Monitoring](https://docs.activeviam.com/engine/java-sdk/6.1/distributed/distribution_monitoring.md)
- [Distribution Testing](https://docs.activeviam.com/engine/java-sdk/6.1/distributed/distribution_testing.md)
- [Protocol Configuration](https://docs.activeviam.com/engine/java-sdk/6.1/distributed/jgroups_protocol_configuration.md)
- [JGroups Cluster Security](https://docs.activeviam.com/engine/java-sdk/6.1/distributed/jgroups_security_configuration.md)
- [How to safely remove data in overlap configuration](https://docs.activeviam.com/engine/java-sdk/6.1/distributed/remove_data_overlap.md)
- [MDX Drillthrough](https://docs.activeviam.com/engine/java-sdk/6.1/drillthrough/mdx_drillthrough.md)
- [XMLA endpoint](https://docs.activeviam.com/engine/java-sdk/6.1/endpoints/xmla.md)
- [What is the Atoti Java SDK?](https://docs.activeviam.com/engine/java-sdk/6.1/intro/overview.md)
- [MDX Engine Configuration](https://docs.activeviam.com/engine/java-sdk/6.1/mdx/engine_configuration.md)
- [Understanding MDX CellSets](https://docs.activeviam.com/engine/java-sdk/6.1/mdx/mdx_cellset.md)
- [MDX Filtering](https://docs.activeviam.com/engine/java-sdk/6.1/mdx/mdx_filtering.md)
- [MDX formats](https://docs.activeviam.com/engine/java-sdk/6.1/mdx/mdx_formatting.md)
- [List of Supported MDX Functions by Atoti](https://docs.activeviam.com/engine/java-sdk/6.1/mdx/mdx_functions.md)
- [List of Supported MDX Operators by Atoti](https://docs.activeviam.com/engine/java-sdk/6.1/mdx/mdx_operators.md)
- [MDX examples to Run Non-trivial Analysis in Atoti](https://docs.activeviam.com/engine/java-sdk/6.1/mdx/mdx_snippets.md)
- [Application Performance Monitoring](https://docs.activeviam.com/engine/java-sdk/6.1/monitoring/application_performance_monitoring.md)
- [Monitoring via the Global Health Dispatcher](https://docs.activeviam.com/engine/java-sdk/6.1/monitoring/health_dispatcher.md)
- [JFR events](https://docs.activeviam.com/engine/java-sdk/6.1/monitoring/jfr_events.md)
- [JMX monitoring](https://docs.activeviam.com/engine/java-sdk/6.1/monitoring/jmx_monitoring.md)
- [Logging overview](https://docs.activeviam.com/engine/java-sdk/6.1/monitoring/logging_overview.md)
- [Metrics Overview](https://docs.activeviam.com/engine/java-sdk/6.1/monitoring/metrics.md)
- [Monitoring Query Execution](https://docs.activeviam.com/engine/java-sdk/6.1/monitoring/monitoring_query_execution.md)
- [Off-heap memory monitoring](https://docs.activeviam.com/engine/java-sdk/6.1/monitoring/off-heap_memory.md)
- [How to set up Observability with OpenTelemetry SDK](https://docs.activeviam.com/engine/java-sdk/6.1/monitoring/otel_how_to.md)
- [Monitoring Overview](https://docs.activeviam.com/engine/java-sdk/6.1/monitoring/overview.md)
- [Query Execution Plan](https://docs.activeviam.com/engine/java-sdk/6.1/monitoring/query_execution_plan.md)
- [Tracing](https://docs.activeviam.com/engine/java-sdk/6.1/monitoring/tracing.md)
- [Properties in Atoti Server](https://docs.activeviam.com/engine/java-sdk/6.1/properties/ap_properties.md)
- [Get Aggregate Query](https://docs.activeviam.com/engine/java-sdk/6.1/querying/get_aggregate_query.md)
- [Location-Based Queries](https://docs.activeviam.com/engine/java-sdk/6.1/querying/location_based_queries.md)
- [Backward Compatibility](https://docs.activeviam.com/engine/java-sdk/6.1/release/backward_compatibility.md)
- [Changelog](https://docs.activeviam.com/engine/java-sdk/6.1/release/changelog.md)
- [Dependencies](https://docs.activeviam.com/engine/java-sdk/6.1/release/dependencies.md)
- [API Reference (Javadoc)](https://docs.activeviam.com/engine/java-sdk/6.1/release/javadoc.md)
- [Migration notes](https://docs.activeviam.com/engine/java-sdk/6.1/release/migration_notes.md)
- [Prepare Next Version](https://docs.activeviam.com/engine/java-sdk/6.1/release/migration_notes_next.md)
- [Changelog 5.10](https://docs.activeviam.com/engine/java-sdk/6.1/release/previous/5_10/changelog_5_10.md)
- [Deprecated features in 5.10](https://docs.activeviam.com/engine/java-sdk/6.1/release/previous/5_10/deprecations_5_10.md)
- [Migration notes 5.10](https://docs.activeviam.com/engine/java-sdk/6.1/release/previous/5_10/migration_notes_5_10.md)
- [What's new in 5.10](https://docs.activeviam.com/engine/java-sdk/6.1/release/previous/5_10/whats_new_5_10.md)
- [Changelog 5.11](https://docs.activeviam.com/engine/java-sdk/6.1/release/previous/5_11/changelog_5_11.md)
- [Deprecated features in 5.11](https://docs.activeviam.com/engine/java-sdk/6.1/release/previous/5_11/deprecations_5_11.md)
- [Migration notes 5.11](https://docs.activeviam.com/engine/java-sdk/6.1/release/previous/5_11/migration_notes_5_11.md)
- [What's new in 5.11](https://docs.activeviam.com/engine/java-sdk/6.1/release/previous/5_11/whats_new_5_11.md)
- [Deprecated features in 5.9](https://docs.activeviam.com/engine/java-sdk/6.1/release/previous/5_9/deprecations_5_9.md)
- [Migration notes 5.9](https://docs.activeviam.com/engine/java-sdk/6.1/release/previous/5_9/migration_notes_5_9.md)
- [What's new in 5.9](https://docs.activeviam.com/engine/java-sdk/6.1/release/previous/5_9/whats_new_5_9.md)
- [Changelog 6.0](https://docs.activeviam.com/engine/java-sdk/6.1/release/previous/6_0/changelog_6_0.md)
- [Deprecations in 6.0](https://docs.activeviam.com/engine/java-sdk/6.1/release/previous/6_0/deprecations_6_0.md)
- [Migration notes 6.0](https://docs.activeviam.com/engine/java-sdk/6.1/release/previous/6_0/migration_notes_6_0.md)
- [What's new in 6.0](https://docs.activeviam.com/engine/java-sdk/6.1/release/previous/6_0/whats_new_6_0.md)
- [Release notes](https://docs.activeviam.com/engine/java-sdk/6.1/release/whats_new.md)
- [Cube REST API](https://docs.activeviam.com/engine/java-sdk/6.1/rest-api/atoti_rest_api.md)
- [Continuous GAQ REST API](https://docs.activeviam.com/engine/java-sdk/6.1/rest-api/continuous_gaq_rest_api.md)
- [ContentServer REST API](https://docs.activeviam.com/engine/java-sdk/6.1/rest-api/cs_rest_api.md)
- [Database REST API](https://docs.activeviam.com/engine/java-sdk/6.1/rest-api/database_rest_api.md)
- [Data Export REST API](https://docs.activeviam.com/engine/java-sdk/6.1/rest-api/dataexport_rest_api.md)
- [Diagnostics REST API](https://docs.activeviam.com/engine/java-sdk/6.1/rest-api/diagnostics_rest_api.md)
- [GAQ REST API](https://docs.activeviam.com/engine/java-sdk/6.1/rest-api/gaq_rest_api.md)
- [REST APIs](https://docs.activeviam.com/engine/java-sdk/6.1/rest-api/rest-apis-overview.md)
- [Atoti Access Control](https://docs.activeviam.com/engine/java-sdk/6.1/security/atoti_access_control.md)
- [Atoti Security: Authentication](https://docs.activeviam.com/engine/java-sdk/6.1/security/authentication.md)
- [Atoti Security: Authorization and Entitlements](https://docs.activeviam.com/engine/java-sdk/6.1/security/authorization.md)
- [Branch Permission Manager](https://docs.activeviam.com/engine/java-sdk/6.1/security/branch_permission.md)
- [Database Access Control](https://docs.activeviam.com/engine/java-sdk/6.1/security/database_access_control.md)
- [Atoti Security Overview](https://docs.activeviam.com/engine/java-sdk/6.1/security/security_overview.md)
- [Amazon S3 Cloud Source](https://docs.activeviam.com/engine/java-sdk/6.1/sources/cloud/aws_cloud_source.md)
- [Azure Cloud Source](https://docs.activeviam.com/engine/java-sdk/6.1/sources/cloud/azure_cloud_source.md)
- [Cloud Source](https://docs.activeviam.com/engine/java-sdk/6.1/sources/cloud/cloud_source.md)
- [Google Cloud Source](https://docs.activeviam.com/engine/java-sdk/6.1/sources/cloud/google_cloud_source.md)
- [CSV Source](https://docs.activeviam.com/engine/java-sdk/6.1/sources/csv_source.md)
- [ETL in Atoti](https://docs.activeviam.com/engine/java-sdk/6.1/sources/data_sources_introduction.md)
- [Load a CSV file](https://docs.activeviam.com/engine/java-sdk/6.1/sources/how-to/load_a_csv_file.md)
- [Load data from a JDBC source](https://docs.activeviam.com/engine/java-sdk/6.1/sources/how-to/load_data_from_jdbc.md)
- [JDBC Source](https://docs.activeviam.com/engine/java-sdk/6.1/sources/jdbc_source.md)
- [Parquet Source](https://docs.activeviam.com/engine/java-sdk/6.1/sources/parquet_source.md)
- [Source Monitoring](https://docs.activeviam.com/engine/java-sdk/6.1/sources/source_monitoring.md)
- [Getting Started: Development Environment](https://docs.activeviam.com/engine/java-sdk/6.1/start/dev_env.md)
- [Getting Started: Download](https://docs.activeviam.com/engine/java-sdk/6.1/start/download.md)
- [Getting Started: Overview](https://docs.activeviam.com/engine/java-sdk/6.1/start/getting_started_overview.md)
- [Getting Started: License](https://docs.activeviam.com/engine/java-sdk/6.1/start/license.md)
- [Getting Started with the Sandbox Project (Deprecated)](https://docs.activeviam.com/engine/java-sdk/6.1/start/sandbox.md)
- [Getting Started with the Atoti Spring Boot Template](https://docs.activeviam.com/engine/java-sdk/6.1/start/spring_boot_template.md)
- [The Atoti Admin UI Starter](https://docs.activeviam.com/engine/java-sdk/6.1/starters/atoti_admin_ui_starter.md)
- [The Atoti Excel Add-in Starter](https://docs.activeviam.com/engine/java-sdk/6.1/starters/atoti_excel_addin_starter.md)
- [The Query History Starter](https://docs.activeviam.com/engine/java-sdk/6.1/starters/atoti_query_history_starter.md)
- [The Atoti Server Application Starter](https://docs.activeviam.com/engine/java-sdk/6.1/starters/atoti_server_application_starter.md)
- [Atoti Server Extension reference page](https://docs.activeviam.com/engine/java-sdk/6.1/starters/atoti_server_extension.md)
- [The Atoti Server Starter](https://docs.activeviam.com/engine/java-sdk/6.1/starters/atoti_starter.md)
- [The Atoti UI Starter](https://docs.activeviam.com/engine/java-sdk/6.1/starters/atoti_ui_starter.md)
- [How to configure a content service](https://docs.activeviam.com/engine/java-sdk/6.1/starters/how-to/configure-content-service.md)
- [How to secure REST services](https://docs.activeviam.com/engine/java-sdk/6.1/starters/how-to/configure-rest-endpoint-security.md)
- [How to use Atoti Server Extension to create your own measures](https://docs.activeviam.com/engine/java-sdk/6.1/starters/how-to/create-custom-measures.md)
- [How to create a custom REST service in an Atoti Server Extension](https://docs.activeviam.com/engine/java-sdk/6.1/starters/how-to/create-custom-rest-service.md)
- [How to expose an Atoti application to Atoti Python SDK](https://docs.activeviam.com/engine/java-sdk/6.1/starters/how-to/expose-app-to-python.md)
- [How-to guides](https://docs.activeviam.com/engine/java-sdk/6.1/starters/how-to/index.md)
- [How to set up an XMLA interceptor in an Atoti application](https://docs.activeviam.com/engine/java-sdk/6.1/starters/how-to/setup-xmla-interceptor.md)
- [List of Spring Boot Starters](https://docs.activeviam.com/engine/java-sdk/6.1/starters/starters_directory.md)
- [Microsoft Excel](https://docs.activeviam.com/engine/java-sdk/6.1/user_guide/querying/front_ends/excel_xmla.md)
- [Power BI](https://docs.activeviam.com/engine/java-sdk/6.1/user_guide/querying/front_ends/power_bi.md)
- [Atoti Tableau Adapter](https://docs.activeviam.com/engine/java-sdk/6.1/user_guide/querying/front_ends/tableau/tableau_adapter.md)
- [How to use Tableau Adapter](https://docs.activeviam.com/engine/java-sdk/6.1/user_guide/querying/front_ends/tableau/tableau_adapter_how_to.md)
- [Tableau MSSAS connector](https://docs.activeviam.com/engine/java-sdk/6.1/user_guide/querying/front_ends/tableau/tableau_mssas_connector.md)
- [Querying Atoti Server with Atoti UI](https://docs.activeviam.com/engine/java-sdk/6.1/user_guide/querying/front_ends/user_guide_querying_front_ends_atoti_ui.md)
- [Atoti Excel Add-in](https://docs.activeviam.com/engine/java-sdk/6.1/user_guide/querying/front_ends/user_guide_querying_front_ends_excel_add-in.md)
- [Business Front Ends Overview](https://docs.activeviam.com/engine/java-sdk/6.1/user_guide/querying/front_ends/user_guide_querying_front_ends_overview.md)
- [Querying Atoti](https://docs.activeviam.com/engine/java-sdk/6.1/user_guide/querying/user_guide_querying_overview.md)
- [Atoti Websocket API](https://docs.activeviam.com/engine/java-sdk/6.1/ws-api/pivot_ws_api.md)
- [ContentServer Websocket API](https://docs.activeviam.com/engine/java-sdk/6.1/ws-api/ws_api_contentserver.md)
- [End of Support policies](https://docs.activeviam.com/eos.md): ActiveViam's support lifecycle policies for all commercial products. Version 2.1 – August 27, 2024.
- [Atoti Hub](https://docs.activeviam.com/index.md): Find user guides, developer guides, API references, tutorials, and more.
- [Minimum technical requirements](https://docs.activeviam.com/minimum-technical-requirements.md): Minimum hardware, OS, and software specifications for Atoti deployment, development, and end user machines.
- [Pre-production releases](https://docs.activeviam.com/preproduction-releases.md): How ActiveViam handles alpha, milestone, beta, and RC releases before a production (GA) release.
- [Requirements & EOS](https://docs.activeviam.com/requirements-and-eos.md)
- [Atoti Solutions documentation](https://docs.activeviam.com/solutions/solutions.md)
- [Atoti Notification and Audit Services](https://docs.activeviam.com/videos/atoti-common-services.md): Explore video tutorials on the Audit and Notification Services.
- [Atoti FRTB](https://docs.activeviam.com/videos/atoti-frtb.md): Explore video tutorials of our risk solutions.
- [Atoti Limits](https://docs.activeviam.com/videos/atoti-limits.md): Explore video tutorials on Atoti operational workflows, including Limits and Sign-Off.
- [Atoti Market Risk](https://docs.activeviam.com/videos/atoti-market-risk.md): Explore video tutorials of our risk solutions.
- [Atoti Sign-Off](https://docs.activeviam.com/videos/atoti-signoff.md): Explore video tutorials on Atoti operational workflows, including Limits and Sign-Off.
- [Atoti UI](https://docs.activeviam.com/videos/atoti-ui.md): Explore our video tutorials on Atoti UI.
- [Multi-dimensional data analysis](https://docs.activeviam.com/videos/multi-dimensional-data-analysis.md): Explore our video tutorials on core Atoti concepts.
- [Videos](https://docs.activeviam.com/videos/videos.md)

## OpenAPI Specs

- [openapi](https://docs.activeviam.com/engine/rest/6.1.20/openapi.json)