Hierarchy.virtual

property Hierarchy.virtual: bool | None

• The hierarchy has a cardinality of 10000 or more;
• The activeviam.experimental.forceVirtualHierarchies property is set to true.

>>> from atoti_directquery_clickhouse import ConnectionConfig, TableConfig
>>> connection_config = ConnectionConfig(
...     url=f"clickhouse:http://localhost:{clickhouse_server_port}/{schema_name}",
... )
>>> table_config = TableConfig(keys={"id"})

• Without activeviam.experimental.forceVirtualHierarchies:
  >>> session = tt.Session.start()
  >>> external_database = session.connect_to_external_database(
  ...     connection_config
  ... )
  >>> sales_table = session.add_external_table(
  ...     external_database.tables["sales"], config=table_config
  ... )
  >>> cube = session.create_cube(sales_table)
  >>> cube.hierarchies["product"].virtual
  False
  
• With activeviam.experimental.forceVirtualHierarchies:
  >>> session_config = tt.SessionConfig(
  ...     java_options=["-Dactiveviam.experimental.forceVirtualHierarchies=true"]
  ... )
  >>> session = tt.Session.start(session_config)
  >>> external_database = session.connect_to_external_database(
  ...     connection_config
  ... )
  >>> sales_table = session.add_external_table(
  ...     external_database.tables["sales"], config=table_config
  ... )
  >>> cube = session.create_cube(sales_table)
  >>> cube.hierarchies["product"].virtual
  True