# Atoti Hub: Atoti Engine Atoti Java SDK ## Atoti Java SDK - [Atoti Engine / Atoti Java SDK / Atoti Java SDK 6.2 (latest) (220 pages)](https://docs.activeviam.com/_llms/atoti-engine/atoti-java-sdk/atoti-java-sdk-6-2-latest.md): Documentation for Atoti Engine / Atoti Java SDK / Atoti Java SDK 6.2 (latest). - [Atoti Engine / Atoti Java SDK / Atoti Java SDK 6.1 (217 pages)](https://docs.activeviam.com/_llms/atoti-engine/atoti-java-sdk/atoti-java-sdk-6-1.md): Documentation for Atoti Engine / Atoti Java SDK / Atoti Java SDK 6.1. ### Atoti Java SDK 6.0 #### Introduction - [Atoti Overview](https://docs.activeviam.com/engine/java-sdk/6.0/intro/overview.md) - [What's new](https://docs.activeviam.com/engine/java-sdk/6.0/release/whats_new.md) #### Getting started - [Getting Started : Overview](https://docs.activeviam.com/engine/java-sdk/6.0/start/getting_started_overview.md) - [Getting Started: Development Environment](https://docs.activeviam.com/engine/java-sdk/6.0/start/dev_env.md) - [Getting Started : Download](https://docs.activeviam.com/engine/java-sdk/6.0/start/download.md) - [Getting Started : License](https://docs.activeviam.com/engine/java-sdk/6.0/start/license.md) - [Getting Started with the Sandbox Project](https://docs.activeviam.com/engine/java-sdk/6.0/start/sandbox.md) #### Concepts - [Atoti Concepts Overview](https://docs.activeviam.com/engine/java-sdk/6.0/concepts/overview.md) - [Atoti Concepts in a Nutshell](https://docs.activeviam.com/engine/java-sdk/6.0/concepts/concepts_in_a_nutshell.md) - [Data Versioning (MVCC)](https://docs.activeviam.com/engine/java-sdk/6.0/concepts/data_versioning.md) - [Dimensions and Hierarchies](https://docs.activeviam.com/engine/java-sdk/6.0/concepts/dimensions_and_hierarchies.md) - [Partitioning and NUMA awareness in Atoti](https://docs.activeviam.com/engine/java-sdk/6.0/concepts/partitioning.md) #### Step 1: Getting your data into Atoti - [Database Overview](https://docs.activeviam.com/engine/java-sdk/6.0/database/database_overview.md) - [Database API](https://docs.activeviam.com/engine/java-sdk/6.0/database/database_api.md) - [Database Queries](https://docs.activeviam.com/engine/java-sdk/6.0/database/database_queries.md) ##### Datastore - [Datastore Configuration](https://docs.activeviam.com/engine/java-sdk/6.0/datastore/datastore_config.md) - [Datastore Transactions](https://docs.activeviam.com/engine/java-sdk/6.0/datastore/datastore_transactions.md) - [Indexing the Stores](https://docs.activeviam.com/engine/java-sdk/6.0/datastore/store_indexing.md) ###### ETL - [ETL in Atoti](https://docs.activeviam.com/engine/java-sdk/6.0/sources/data_sources_introduction.md) - [CSV Source](https://docs.activeviam.com/engine/java-sdk/6.0/sources/csv_source.md) - [JDBC Source](https://docs.activeviam.com/engine/java-sdk/6.0/sources/jdbc_source.md) - [Parquet Source](https://docs.activeviam.com/engine/java-sdk/6.0/sources/parquet_source.md) ###### How-to Guides - [Load a CSV file](https://docs.activeviam.com/engine/java-sdk/6.0/sources/how-to/load_a_csv_file.md) ###### Load from the cloud - [Cloud Source](https://docs.activeviam.com/engine/java-sdk/6.0/sources/cloud/cloud_source.md) - [Amazon S3 Cloud Source](https://docs.activeviam.com/engine/java-sdk/6.0/sources/cloud/aws_cloud_source.md) - [Azure Cloud Source](https://docs.activeviam.com/engine/java-sdk/6.0/sources/cloud/azure_cloud_source.md) - [Google Cloud Source](https://docs.activeviam.com/engine/java-sdk/6.0/sources/cloud/google_cloud_source.md) ###### Specific data types - [Handling Dates](https://docs.activeviam.com/engine/java-sdk/6.0/core_features/dates.md) - [Vectors in Atoti Server](https://docs.activeviam.com/engine/java-sdk/6.0/core_features/vectors.md) ##### Direct Query - [Getting Started](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/getting_started.md) - [Compatibility with Databases](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/compatibility.md) ###### Connect to remote database - [Connecting to remote Database](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/connect_to_external/intro.md) - [Connect to BigQuery](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/connect_to_external/connect_to_bigquery.md) - [Connect to ClickHouse](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/connect_to_external/connect_to_clickhouse.md) - [Connect to Databricks](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/connect_to_external/connect_to_databricks.md) - [Connect to Microsoft SQL Server](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/connect_to_external/connect_to_mssql.md) - [Connect to Redshift](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/connect_to_external/connect_to_redshift.md) - [Connect to Snowflake](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/connect_to_external/connect_to_snowflake.md) - [Connect to Synapse](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/connect_to_external/connect_to_synapse.md) ###### DirectQuery concepts - [Relationship Optionality](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/relationship-optionality.md) - [Versioning](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/versioning.md) - [Incremental Refresh](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/incremental-refresh.md) - [Incremental Refresh advanced](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/incremental-refresh-advanced.md) - [Vectors in DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/directquery-vectors.md) - [Supported aggregation functions with DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/directquery-agg-functions.md) - [Clustering fields in DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/directquery-clustering-fields.md) - [Aggregate Tables](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/aggregate-tables.md) - [External data validation](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/external-data-validation.md) - [Split granular data between in-memory datastore and DirectQuery database](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/split-in-memory-directquery.md) ###### Database specifics - [Introduction](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/databases/introduction.md) - [Google BigQuery](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/databases/bigquery.md) - [ClickHouse](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/databases/clickhouse.md) - [Databricks](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/databases/databricks.md) - [Microsoft SQL Server](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/databases/mssql.md) - [Amazon Redshift](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/databases/redshift.md) - [Snowflake](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/databases/snowflake.md) - [Microsoft Azure Synapse](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/databases/synapse.md) ###### How-to Guides - [How-To Guides](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/how_to_guides.md) - [Customize Table](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/how_to/customize_table.md) - [How to use vectors](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/how_to/use_vector_in_table.md) - [User Defined Aggregation Functions](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/how_to/user_defined_aggregation.md) - [Use custom types](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/how_to/use_custom_types.md) - [Incremental Refresh](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/how_to/incremental-refresh-how-to.md) #### Step 2: Designing your cube - [Aggregation & Analytics Overview](https://docs.activeviam.com/engine/java-sdk/6.0/cube/overview.md) - [Cube Configuration](https://docs.activeviam.com/engine/java-sdk/6.0/cube/configuration.md) ##### Cube structure - [Dimension and hierarchy Configuration](https://docs.activeviam.com/engine/java-sdk/6.0/cube/hierarchy_configuration.md) - [Level Configuration](https://docs.activeviam.com/engine/java-sdk/6.0/cube/level_configuration.md) ##### Copper API - [Presentation](https://docs.activeviam.com/engine/java-sdk/6.0/copper/copper_intro.md) - [The API](https://docs.activeviam.com/engine/java-sdk/6.0/copper/copper_api.md) - [Creating and publishing measures](https://docs.activeviam.com/engine/java-sdk/6.0/copper/copper_measures.md) - [Creating and publishing hierarchies](https://docs.activeviam.com/engine/java-sdk/6.0/copper/copper_hierarchies.md) - [Measure and hierarchy publication](https://docs.activeviam.com/engine/java-sdk/6.0/copper/copper_publication.md) - [Joining isolated stores in Copper](https://docs.activeviam.com/engine/java-sdk/6.0/copper/copper_join.md) - [Advanced topics](https://docs.activeviam.com/engine/java-sdk/6.0/copper/copper_advanced.md) ##### Advanced APIs - [Cube Locations](https://docs.activeviam.com/engine/java-sdk/6.0/cube/locations.md) - [Post-Processors](https://docs.activeviam.com/engine/java-sdk/6.0/cube/postprocessors.md) - [Cube Filters](https://docs.activeviam.com/engine/java-sdk/6.0/cube/filtering.md) - [Aggregation Functions](https://docs.activeviam.com/engine/java-sdk/6.0/cube/aggregation-functions.md) - [Analysishierarchies](https://docs.activeviam.com/engine/java-sdk/6.0/cube/analysishierarchies.md) - [Custom Member Properties](https://docs.activeviam.com/engine/java-sdk/6.0/cube/member_properties.md) - [Context Values](https://docs.activeviam.com/engine/java-sdk/6.0/cube/context_values.md) ##### Configure distributed architecture for Atoti - [Distributed Architecture Overview](https://docs.activeviam.com/engine/java-sdk/6.0/distributed/distributed_intro.md) - [Distributed Architecture Communication Flows](https://docs.activeviam.com/engine/java-sdk/6.0/distributed/distributed_flows.md) - [Distributed Post-Processors](https://docs.activeviam.com/engine/java-sdk/6.0/distributed/distributed_post_processors.md) - [Security in a Distributed Environment](https://docs.activeviam.com/engine/java-sdk/6.0/distributed/distributed_cube_security.md) - [What-If](https://docs.activeviam.com/engine/java-sdk/6.0/distributed/distributed_what_ifs.md) - [Recommendations](https://docs.activeviam.com/engine/java-sdk/6.0/distributed/distributed_recommendations.md) - [Distribution Properties](https://docs.activeviam.com/engine/java-sdk/6.0/distributed/distributed_properties.md) #### Step 3: Access your data with front ends or custom clients ##### Business Front Ends - [Querying ActivePivot : Business Front Ends Overview](https://docs.activeviam.com/engine/java-sdk/6.0/user_guide/querying/front_ends/user_guide_querying_front_ends_overview.md) - [Querying ActivePivot with Atoti UI](https://docs.activeviam.com/engine/java-sdk/6.0/user_guide/querying/front_ends/user_guide_querying_front_ends_atoti_ui.md) - [Querying Atoti: Third Party Front Ends](https://docs.activeviam.com/engine/java-sdk/6.0/user_guide/querying/front_ends/user_guide_querying_front_ends_third_party.md) ##### MDX - [MDX Engine Configuration](https://docs.activeviam.com/engine/java-sdk/6.0/mdx/engine_configuration.md) - [List of Supported MDX Functions by ActivePivot](https://docs.activeviam.com/engine/java-sdk/6.0/mdx/mdx_functions.md) - [List of Supported MDX Operators by ActivePivot](https://docs.activeviam.com/engine/java-sdk/6.0/mdx/mdx_operators.md) - [MDX formats](https://docs.activeviam.com/engine/java-sdk/6.0/mdx/mdx_formatting.md) - [MDX Filtering](https://docs.activeviam.com/engine/java-sdk/6.0/mdx/mdx_filtering.md) - [MDX examples to Run Non-trivial Analysis in ActivePivot](https://docs.activeviam.com/engine/java-sdk/6.0/mdx/mdx_snippets.md) - [Understanding MDX CellSets](https://docs.activeviam.com/engine/java-sdk/6.0/mdx/mdx_cellset.md) - [MDX Drillthrough](https://docs.activeviam.com/engine/java-sdk/6.0/drillthrough/mdx_drillthrough.md) ##### Custom clients - [Location-Based Queries](https://docs.activeviam.com/engine/java-sdk/6.0/querying/location_based_queries.md) - [ActivePivot Excel Add-in: enhance your experience of Atoti in Excel](https://docs.activeviam.com/engine/java-sdk/6.0/user_guide/querying/user_guide_querying_excel_add-in.md) ###### Server endpoints - [XMLA endpoint](https://docs.activeviam.com/engine/java-sdk/6.0/endpoints/xmla.md) - [Database REST API](https://docs.activeviam.com/engine/java-sdk/6.0/rest-api/database_rest_api.md) - [Cube REST API](https://docs.activeviam.com/engine/java-sdk/6.0/rest-api/atoti_rest_api.md) - [Data Export REST API](https://docs.activeviam.com/engine/java-sdk/6.0/rest-api/dataexport_rest_api.md) - [ActivePivot Websocket API](https://docs.activeviam.com/engine/java-sdk/6.0/ws-api/pivot_ws_api.md) ###### Streaming API - [Continuous Queries Overview](https://docs.activeviam.com/engine/java-sdk/6.0/cube/continuous_queries_overview.md) - [Streaming Overview](https://docs.activeviam.com/engine/java-sdk/6.0/cube/streaming_overview.md) - [Continuous Query Engine](https://docs.activeviam.com/engine/java-sdk/6.0/cube/continuous_query_engine.md) - [Aggregates Continuous Handlers](https://docs.activeviam.com/engine/java-sdk/6.0/cube/handlers.md) #### Configure Atoti Options - [Configuration Overview](https://docs.activeviam.com/engine/java-sdk/6.0/configuration/overview.md) - [Content Server](https://docs.activeviam.com/engine/java-sdk/6.0/content_server/cs_overview.md) - [Internationalization](https://docs.activeviam.com/engine/java-sdk/6.0/configuration/internationalization.md) - [Java 17](https://docs.activeviam.com/engine/java-sdk/6.0/configuration/java17.md) - [Memory Management](https://docs.activeviam.com/engine/java-sdk/6.0/configuration/memory_management.md) - [Properties in Atoti Server](https://docs.activeviam.com/engine/java-sdk/6.0/properties/ap_properties.md) #### Set up security and entitlements for Atoti - [ActivePivot Security Overview](https://docs.activeviam.com/engine/java-sdk/6.0/security/security_overview.md) ##### Client/Server communication - [ActivePivot Security: Authentication](https://docs.activeviam.com/engine/java-sdk/6.0/security/authentication.md) - [ActivePivot Security: Authorization and Entitlements](https://docs.activeviam.com/engine/java-sdk/6.0/security/authorization.md) ##### Data access control - [Database Access Control](https://docs.activeviam.com/engine/java-sdk/6.0/security/database_access_control.md) - [Atoti Access Control](https://docs.activeviam.com/engine/java-sdk/6.0/security/atoti_access_control.md) - [Branch Permission Manager](https://docs.activeviam.com/engine/java-sdk/6.0/security/branch_permission.md) #### Monitoring and running Atoti Server - [Operations Overview](https://docs.activeviam.com/engine/java-sdk/6.0/operations/overview.md) ##### Monitoring - [Monitoring via the Global Health Dispatcher](https://docs.activeviam.com/engine/java-sdk/6.0/monitoring/health_dispatcher.md) - [Query Execution Plan](https://docs.activeviam.com/engine/java-sdk/6.0/monitoring/query_execution_plan.md) - [Monitoring Query Execution](https://docs.activeviam.com/engine/java-sdk/6.0/monitoring/monitoring_query_execution.md) - [JMX monitoring](https://docs.activeviam.com/engine/java-sdk/6.0/monitoring/jmx_monitoring.md) - [Producing off-heap memory exports for detailed analysis](https://docs.activeviam.com/engine/java-sdk/6.0/monitoring/mac.md) ###### Tracing - [Tracing Overview](https://docs.activeviam.com/engine/java-sdk/6.0/monitoring/tracing.md) - [Tracing REST API](https://docs.activeviam.com/engine/java-sdk/6.0/rest-api/tracing_rest_api.md) - [Tracing in DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.0/directquery/directquery-tracing.md) - [Application Performance Monitoring](https://docs.activeviam.com/engine/java-sdk/6.0/monitoring/application_performance_monitoring.md) #### Release & Migration Notes - [Changelog](https://docs.activeviam.com/engine/java-sdk/6.0/release/changelog.md) - [Migration notes](https://docs.activeviam.com/engine/java-sdk/6.0/release/migration_notes.md) - [Deprecated features](https://docs.activeviam.com/engine/java-sdk/6.0/release/deprecations.md) #### Reference - [API Reference (Javadoc)](https://docs.activeviam.com/engine/java-sdk/6.0/release/javadoc.md) - [REST APIs](https://docs.activeviam.com/engine/java-sdk/6.0/rest-api/rest-apis-overview.md) ##### Content Server - [ContentServer REST API](https://docs.activeviam.com/engine/java-sdk/6.0/rest-api/cs_rest_api.md) - [ContentServer Websocket API](https://docs.activeviam.com/engine/java-sdk/6.0/ws-api/ws_api_contentserver.md) ### Atoti Java SDK 6.0-sb3 #### Introduction - [Atoti Overview](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/intro/overview.md) - [What's new](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/release/whats_new.md) #### Getting started - [Getting Started : Overview](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/start/getting_started_overview.md) - [Getting Started : Development Environment](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/start/dev_env.md) - [Getting Started : Download](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/start/download.md) - [Getting Started : License](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/start/license.md) - [Getting Started with the Sandbox Project](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/start/sandbox.md) #### Concepts - [Atoti Concepts Overview](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/concepts/overview.md) - [Atoti Concepts in a Nutshell](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/concepts/concepts_in_a_nutshell.md) - [Data Versioning (MVCC)](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/concepts/data_versioning.md) - [Dimensions and Hierarchies](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/concepts/dimensions_and_hierarchies.md) - [Partitioning and NUMA awareness in Atoti](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/concepts/partitioning.md) #### Step 1: Getting your data into Atoti - [Database Overview](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/database/database_overview.md) - [Database API](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/database/database_api.md) - [Database Queries](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/database/database_queries.md) ##### Datastore - [Datastore Configuration](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/datastore/datastore_config.md) - [Datastore Transactions](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/datastore/datastore_transactions.md) - [Indexing the Stores](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/datastore/store_indexing.md) ###### ETL - [ETL in Atoti](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/sources/data_sources_introduction.md) - [CSV Source](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/sources/csv_source.md) - [JDBC Source](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/sources/jdbc_source.md) - [Parquet Source](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/sources/parquet_source.md) ###### How-to Guides - [Load a CSV file](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/sources/how-to/load_a_csv_file.md) ###### Load from the cloud - [Cloud Source](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/sources/cloud/cloud_source.md) - [Amazon S3 Cloud Source](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/sources/cloud/aws_cloud_source.md) - [Azure Cloud Source](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/sources/cloud/azure_cloud_source.md) - [Google Cloud Source](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/sources/cloud/google_cloud_source.md) ###### Specific data types - [Handling Dates](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/core_features/dates.md) - [Vectors in Atoti Server](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/core_features/vectors.md) ##### Direct Query - [Getting Started](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/getting_started.md) - [Compatibility with Databases](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/compatibility.md) ###### Connect to remote database - [Connecting to remote Database](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/connect_to_external/intro.md) - [Connect to BigQuery](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/connect_to_external/connect_to_bigquery.md) - [Connect to ClickHouse](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/connect_to_external/connect_to_clickhouse.md) - [Connect to Databricks](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/connect_to_external/connect_to_databricks.md) - [Connect to Microsoft SQL Server](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/connect_to_external/connect_to_mssql.md) - [Connect to Redshift](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/connect_to_external/connect_to_redshift.md) - [Connect to Snowflake](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/connect_to_external/connect_to_snowflake.md) - [Connect to Synapse](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/connect_to_external/connect_to_synapse.md) ###### DirectQuery concepts - [Relationship Optionality](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/relationship-optionality.md) - [Versioning](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/versioning.md) - [Incremental Refresh](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/incremental-refresh.md) - [Incremental Refresh advanced](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/incremental-refresh-advanced.md) - [Vectors in DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/directquery-vectors.md) - [Supported aggregation functions with DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/directquery-agg-functions.md) - [Clustering fields in DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/directquery-clustering-fields.md) - [Aggregate Tables](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/aggregate-tables.md) - [External data validation](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/external-data-validation.md) - [Split granular data between in-memory datastore and DirectQuery database](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/split-in-memory-directquery.md) ###### Database specifics - [Introduction](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/databases/introduction.md) - [Google BigQuery](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/databases/bigquery.md) - [ClickHouse](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/databases/clickhouse.md) - [Databricks](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/databases/databricks.md) - [Microsoft SQL Server](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/databases/mssql.md) - [Amazon Redshift](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/databases/redshift.md) - [Snowflake](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/databases/snowflake.md) - [Microsoft Azure Synapse](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/databases/synapse.md) ###### How-to Guides - [How-To Guides](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/how_to_guides.md) - [Customize Table](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/how_to/customize_table.md) - [How to use vectors](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/how_to/use_vector_in_table.md) - [User Defined Aggregation Functions](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/how_to/user_defined_aggregation.md) - [Use custom types](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/how_to/use_custom_types.md) - [Incremental Refresh](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/how_to/incremental-refresh-how-to.md) #### Step 2: Designing your cube - [Aggregation & Analytics Overview](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/cube/overview.md) - [Cube Configuration](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/cube/configuration.md) ##### Cube structure - [Dimension and hierarchy Configuration](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/cube/hierarchy_configuration.md) - [Level Configuration](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/cube/level_configuration.md) ##### Copper API - [Presentation](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/copper/copper_intro.md) - [The API](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/copper/copper_api.md) - [Creating and publishing measures](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/copper/copper_measures.md) - [Creating and publishing hierarchies](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/copper/copper_hierarchies.md) - [Measure and hierarchy publication](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/copper/copper_publication.md) - [Joining isolated stores in Copper](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/copper/copper_join.md) - [Advanced topics](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/copper/copper_advanced.md) ##### Advanced APIs - [Cube Locations](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/cube/locations.md) - [Post-Processors](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/cube/postprocessors.md) - [Cube Filters](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/cube/filtering.md) - [Aggregation Functions](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/cube/aggregation-functions.md) - [Analysishierarchies](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/cube/analysishierarchies.md) - [Custom Member Properties](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/cube/member_properties.md) - [Context Values](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/cube/context_values.md) ##### Configure distributed architecture for Atoti - [Distributed Architecture Overview](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/distributed/distributed_intro.md) - [Distributed Architecture Communication Flows](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/distributed/distributed_flows.md) - [Distributed Post-Processors](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/distributed/distributed_post_processors.md) - [Security in a Distributed Environment](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/distributed/distributed_cube_security.md) - [What-If](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/distributed/distributed_what_ifs.md) - [Recommendations](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/distributed/distributed_recommendations.md) - [Distribution Properties](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/distributed/distributed_properties.md) #### Step 3: Access your data with front ends or custom clients ##### Business Front Ends - [Querying ActivePivot : Business Front Ends Overview](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/user_guide/querying/front_ends/user_guide_querying_front_ends_overview.md) - [Querying ActivePivot with Atoti UI](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/user_guide/querying/front_ends/user_guide_querying_front_ends_atoti_ui.md) - [Querying Atoti: Third Party Front Ends](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/user_guide/querying/front_ends/user_guide_querying_front_ends_third_party.md) ##### MDX - [MDX Engine Configuration](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/mdx/engine_configuration.md) - [List of Supported MDX Functions by ActivePivot](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/mdx/mdx_functions.md) - [List of Supported MDX Operators by ActivePivot](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/mdx/mdx_operators.md) - [MDX formats](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/mdx/mdx_formatting.md) - [MDX Filtering](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/mdx/mdx_filtering.md) - [MDX examples to Run Non-trivial Analysis in ActivePivot](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/mdx/mdx_snippets.md) - [Understanding MDX CellSets](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/mdx/mdx_cellset.md) - [MDX Drillthrough](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/drillthrough/mdx_drillthrough.md) ##### Custom clients - [Location-Based Queries](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/querying/location_based_queries.md) - [ActivePivot Excel Add-in: enhance your experience of Atoti in Excel](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/user_guide/querying/user_guide_querying_excel_add-in.md) ###### Server endpoints - [XMLA endpoint](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/endpoints/xmla.md) - [Database REST API](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/rest-api/database_rest_api.md) - [Cube REST API](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/rest-api/atoti_rest_api.md) - [Data Export REST API](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/rest-api/dataexport_rest_api.md) - [ActivePivot Websocket API](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/ws-api/pivot_ws_api.md) ###### Streaming API - [Continuous Queries Overview](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/cube/continuous_queries_overview.md) - [Streaming Overview](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/cube/streaming_overview.md) - [Continuous Query Engine](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/cube/continuous_query_engine.md) - [Aggregates Continuous Handlers](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/cube/handlers.md) #### Configure Atoti Options - [Configuration Overview](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/configuration/overview.md) - [Content Server](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/content_server/cs_overview.md) - [Internationalization](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/configuration/internationalization.md) - [Java 17](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/configuration/java17.md) - [Memory Management](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/configuration/memory_management.md) - [Properties in Atoti Server](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/properties/ap_properties.md) #### Set up security and entitlements for Atoti - [ActivePivot Security Overview](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/security/security_overview.md) ##### Client/Server communication - [ActivePivot Security: Authentication](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/security/authentication.md) - [ActivePivot Security: Authorization and Entitlements](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/security/authorization.md) ##### Data access control - [Database Access Control](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/security/database_access_control.md) - [Atoti Access Control](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/security/atoti_access_control.md) - [Branch Permission Manager](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/security/branch_permission.md) #### Monitoring and running Atoti Server - [Operations Overview](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/operations/overview.md) ##### Monitoring - [Monitoring via the Global Health Dispatcher](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/monitoring/health_dispatcher.md) - [Query Execution Plan](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/monitoring/query_execution_plan.md) - [Monitoring Query Execution](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/monitoring/monitoring_query_execution.md) - [JMX monitoring](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/monitoring/jmx_monitoring.md) - [Producing off-heap memory exports for detailed analysis](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/monitoring/mac.md) ###### Tracing - [Tracing Overview](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/monitoring/tracing.md) - [How to set up Tracing with OpenTelemetry SDK](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/monitoring/tracing_how_to.md) - [Tracing REST API](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/rest-api/tracing_rest_api.md) - [Tracing in DirectQuery](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/directquery/directquery-tracing.md) - [Application Performance Monitoring](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/monitoring/application_performance_monitoring.md) #### Release & Migration Notes - [Changelog](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/release/changelog.md) - [Migration notes](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/release/migration_notes.md) - [Deprecated features](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/release/deprecations.md) #### Reference - [API Reference (Javadoc)](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/release/javadoc.md) - [REST APIs](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/rest-api/rest-apis-overview.md) ##### Content Server - [ContentServer REST API](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/rest-api/cs_rest_api.md) - [ContentServer Websocket API](https://docs.activeviam.com/engine/java-sdk/6.0-sb3/ws-api/ws_api_contentserver.md) ### Atoti Java SDK previous versions - [Previous versions](https://docs.activeviam.com/engine/java-sdk/previous-versions.md): Documentation for Atoti Java SDK versions older than 6.1