atoti.level module#

class atoti.Level#

Level of a Hierarchy.

A level is a sub category of a hierarchy. Levels have a specific order with a parent-child relationship.

In a Pivot Table, a single-level hierarchy will be displayed as a flat attribute while a multi-level hierarchy will display the first level and allow users to expand each member against the next level and display sub totals.

For example, a Geography hierarchy can have a Continent as the top level where Continent expands to Country which in turn expands to the leaf level: City.

property data_type: DataType#

Type of the level members.

property dimension: str#

Name of the dimension holding the level.

property hierarchy: str#

Name of the hierarchy holding the level.


Return a condition to check that the level is on one of the given members.

level.isin(a, b) is equivalent to (level == a) | (level == b).


members (ConstantValue) – One or more members on which the level should be.

Return type:

Condition[LevelIdentifier, Literal[‘isin’], Constant, None]


>>> df = pd.DataFrame(
...     columns=["City", "Price"],
...     data=[
...         ("Berlin", 150.0),
...         ("London", 240.0),
...         ("New York", 270.0),
...         ("Paris", 200.0),
...     ],
... )
>>> table = session.read_pandas(
...     df, keys=["City"], table_name="isin example"
... )
>>> cube = session.create_cube(table)
>>> l, m = cube.levels, cube.measures
>>> m["Price.SUM in London and Paris"] = tt.filter(
...     m["Price.SUM"], l["City"].isin("London", "Paris")
... )
>>> cube.query(
...     m["Price.SUM"],
...     m["Price.SUM in London and Paris"],
...     levels=[l["City"]],
... )
         Price.SUM Price.SUM in London and Paris
Berlin      150.00
London      240.00                        240.00
New York    270.00
Paris       200.00                        200.00

Return a condition evaluating to True when a level is not expressed in a query and False otherwise.

Use ~level.isnull() for the opposite behavior.


>>> df = pd.DataFrame(
...     columns=["Country", "City", "Price"],
...     data=[
...         ("France", "Paris", 200.0),
...         ("Germany", "Berlin", 120),
...     ],
... )
>>> table = session.read_pandas(df, table_name="isnull example")
>>> cube = session.create_cube(table)
>>> l, m = cube.levels, cube.measures
>>> m["City.isnull"] = l["City"].isnull()
>>> m["City.notnull"] = ~l["City"].isnull()
>>> cube.query(
...     m["City.isnull"],
...     m["City.notnull"],
...     levels=[l["Country"], l["City"]],
...     include_totals=True,
... )
               City.isnull City.notnull
Country City
Total                 True        False
France                True        False
        Paris        False         True
Germany               True        False
        Berlin       False         True
Return type:

Condition[LevelIdentifier, Literal[‘eq’], None, None]

property name: str#

Name of the level.

property order: CustomOrder | NaturalOrder#

Order in which to sort the level’s members.

Defaults to ascending atoti.NaturalOrder.