Skip to main content
Ctrl
+
K
0.8.5
Site Navigation
Getting Started
Deployment
How to
Reference
Changelog
GitHub
Twitter
LinkedIn
Medium
Site Navigation
Getting Started
Deployment
How to
Reference
Changelog
GitHub
Twitter
LinkedIn
Medium
Ctrl
+
K
Section Navigation
API
atoti
Aggregation functions
count_distinct()
long()
max()
max_member()
mean()
median()
min()
min_member()
prod()
quantile()
short()
single_value()
square_sum()
std()
sum()
sum_product()
var()
AggregateProvider
AggregatesCache
capacity
App extensions
Array functions
len()
max()
mean()
min()
n_greatest()
n_greatest_indices()
n_lowest()
n_lowest_indices()
negative_values()
nth_greatest()
nth_lowest()
positive_values()
prefix_sum()
prod()
quantile()
quantile_index()
replace()
sort()
std()
sum()
var()
ClientSideEncryptionConfig
Column
data_type
default_value
isin()
isnull()
name
Session config
Authentication
BrandingConfig
ClientCertificateConfig
HttpsConfig
I18nConfig
JwtConfig
KeyPair
LoggingConfig
UserContentStorageConfig
Cube
aggregate_providers
aggregates_cache
create_date_hierarchy()
create_parameter_hierarchy_from_column()
create_parameter_hierarchy_from_members()
create_parameter_simulation()
explain_query()
hierarchies
levels
measures
name
query()
schema
shared_context
CubeContext
Cubes
DirectQuery
ExternalTables
MultiColumnArrayConversion
MultiRowArrayConversion
Experimental features
Experimental aggregation functions
Experimental finance functions
Experimental statistics functions
General functions
at()
date_diff()
date_shift()
filter()
first()
last()
lookup()
parent_value()
rank()
shift()
switch()
total()
where()
Hierarchies
Hierarchy
dimension
isin()
levels
name
slicing
virtual
visible
Level
data_type
dimension
hierarchy
isin()
isnull()
name
order
Levels
Math functions
abs()
ceil()
cos()
erf()
erfc()
exp()
floor()
isnan()
log()
log10()
max()
min()
round()
sin()
sqrt()
tan()
Measure
data_type
description
folder
formatter
isnull()
name
visible
Measures
Level order
CustomOrder
NaturalOrder
Custom endpoints
HttpRequest
User
Aggregation scopes
CumulativeScope
OriginScope
SiblingsScope
Session
add_external_table()
close()
closed
connect_to_external_database()
create_cube()
create_scenario()
create_table()
cubes
delete_scenario()
endpoint()
explain_mdx_query()
export_translations_template()
link
logs_path
name
port
query_mdx()
read_arrow()
read_csv()
read_numpy()
read_pandas()
read_parquet()
read_spark()
read_sql()
scenarios
security
start_transaction()
tables
wait()
widget
String functions
concat()
Table
append()
columns
drop()
head()
join()
keys
load_arrow()
load_csv()
load_kafka()
load_numpy()
load_pandas()
load_parquet()
load_spark()
load_sql()
name
scenario
scenarios
Tables
schema
Data types
atoti-aws
Client side encryption
AwsKeyPair
AwsKmsConfig
atoti-azure
Client side encryption
AzureKeyPair
atoti-directquery-bigquery
BigqueryConnection
cache
tables
BigqueryConnectionInfo
BigqueryTable
columns
name
BigqueryTableOptions
atoti-directquery-clickhouse
ClickhouseConnection
cache
tables
ClickhouseConnectionInfo
ClickhouseTable
columns
name
ClickhouseTableOptions
atoti-directquery-databricks
DatabricksConnection
tables
DatabricksConnectionInfo
DatabricksTable
columns
name
DatabricksTableOptions
atoti-directquery-mssql
MsSqlConnection
tables
MsSqlConnectionInfo
MsSqlTable
columns
name
MsSqlTableOptions
atoti-directquery-redshift
RedshiftConnection
cache
tables
RedshiftConnectionInfo
RedshiftTable
columns
name
RedshiftTableOptions
atoti-directquery-snowflake
SnowflakeConnection
cache
tables
SnowflakeConnectionInfo
SnowflakeTable
columns
name
SnowflakeTableOptions
atoti-directquery-synapse
SynapseConnection
tables
SynapseConnectionInfo
SynapseTable
columns
name
SynapseTableOptions
atoti-gcp
atoti-jupyterlab
atoti-kafka
atoti-query
Auth
BasicAuthentication
ClientCertificate
OAuth2ResourceOwnerPasswordAuthentication
QueryCube
hierarchies
levels
measures
name
query()
QueryCubes
QueryHierarchies
QueryHierarchy
dimension
isin()
levels
name
slicing
QueryLevel
dimension
hierarchy
isin()
isnull()
name
QueryLevels
QueryMeasure
description
folder
formatter
isnull()
name
visible
QueryMeasures
QueryResult
style
QuerySession
cubes
link
query_mdx()
url
widget
Security
BasicSecurity
DefaultRoles
IndividualRoles
KerberosSecurity
LdapSecurity
OidcSecurity
RoleMapping
Security
TokenAuthentication
atoti-sql
Drivers
Reference
atoti.Hierarchy
atoti.Hierarchy.visible
atoti.Hierarchy.visible
#
property
Hierarchy.
visible
:
bool
#
Whether the hierarchy is visible or not.