> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Cube.create_parameter_hierarchy_from_column()

<span id="atoti.Cube.create_parameter_hierarchy_from_column" />

> Cube.create\_parameter\_hierarchy\_from\_column(<br />
>     *name*: [str](https://docs.python.org/3/library/stdtypes.html#str),<br />
>     *column*: [Column](./atoti.Column#atoti.Column),<br />
> ) → [None](https://docs.python.org/3/library/constants.html#None)

Create a single-level hierarchy which dynamically takes its members from a column.

### Parameters

<h4 id="atoti.Cube.create_parameter_hierarchy_from_column.name">
  *name*
</h4>

Name given to the created dimension, hierarchy and its single level.

<h4 id="atoti.Cube.create_parameter_hierarchy_from_column.column">
  *column*
</h4>

Column from which to take members.

***

```pycon theme={"languages":{"custom":["/engine/python-sdk/0.9/languages/pycon.tmLanguage.json"]}}
>>> df = pd.DataFrame(
...     {
...         "Seller": ["Seller_1", "Seller_1", "Seller_2", "Seller_2"],
...         "ProductId": ["aBk3", "ceJ4", "aBk3", "ceJ4"],
...         "Price": [2.5, 49.99, 3.0, 54.99],
...     }
... )
>>> table = session.read_pandas(df, table_name="Seller")
>>> cube = session.create_cube(table)
>>> l, m = cube.levels, cube.measures
>>> cube.create_parameter_hierarchy_from_column("Competitor", table["Seller"])
>>> m["Price"] = tt.agg.single_value(table["Price"])
>>> m["Competitor price"] = tt.at(m["Price"], l["Seller"] == l["Competitor"])
>>> cube.query(
...     m["Competitor price"],
...     levels=[l["Seller"], l["ProductId"]],
... )
                   Competitor price
Seller   ProductId
Seller_1 aBk3                  2.50
         ceJ4                 49.99
Seller_2 aBk3                  2.50
         ceJ4                 49.99
>>> cube.query(
...     m["Competitor price"],
...     levels=[l["Seller"], l["ProductId"]],
...     filter=l["Competitor"] == "Seller_2",
... )
                   Competitor price
Seller   ProductId
Seller_1 aBk3                  3.00
         ceJ4                 54.99
Seller_2 aBk3                  3.00
         ceJ4                 54.99
```