1.3.2

What's Changed

• Add drilldown hierarchy with levels by @vishn90 in #43

Full Changelog: 1.3...1.3.2

1.3

What's Changed

• Introduce head and skip_dimension_properties in to_mdx function by @MariusWirtz in #41

Full Changelog: 1.2...1.3

1.2

Add pyproject.toml

1.1

What's Changed

• add hierarchize function by @vishn90 in #39
• reintroduce unions function on MdxHierarchySet by @MariusWirtz in c88a41a

1.0

Allow Dimension Properties Per Axis

Allows dimension properties per axis (#18, #34 ). Sample:

from TM1py import TM1Service

from mdxpy import MdxBuilder, MdxHierarchySet, Member, DimensionProperty

with TM1Service(address='localhost', port=12354, ssl=True, user="admin", password="apple") as tm1:
    query = MdxBuilder.from_cube("c1")
    query.add_hierarchy_set_to_row_axis(MdxHierarchySet.all_leaves("d1", "d1"))
    query.add_properties_to_row_axis(DimensionProperty("d1", "d1", "Description"))
    query.rows_non_empty()
    query.add_hierarchy_set_to_column_axis(MdxHierarchySet.member(Member.of("d2", "e1")))
    query.columns_non_empty()

    print(query.to_mdx())

    df = tm1.cells.execute_mdx_dataframe(mdx=query.to_mdx(), include_attributes=True)
    print(df.head(4).to_markdown())

Output

SELECT
NON EMPTY {[d2].[d2].[e1]} DIMENSION PROPERTIES MEMBER_NAME ON 0,
NON EMPTY {TM1FILTERBYLEVEL({TM1SUBSETALL([d1].[d1])},0)} DIMENSION PROPERTIES [d1].[d1].[description] ON 1
FROM [c1]

	d1	Description	d2	Value
0	e1	a1	e1	1
1	e2	a2	e1	2
2	e3	a3	e1	3
3	e4	a4	e1	10

0.4

What's Changed

• Object names lower case by @MariusWirtz in #23
• Add MdxHierarchySet cross_joins by @cubewise-gng in #27
• feature filter_by_element_type by @cubewise-gng in #30
• Break MdxHierarchySet and MdxSet into two by @MariusWirtz in #31
• MDX Levels and Descendants Updates by @rclapp in #36
• Make MdxSet useable in MdxBuilder by @MariusWirtz in #35
• Add tests for level classes by @MariusWirtz in #37

New Contributors

• @cubewise-gng made their first contribution in #27

Full Changelog: 0.3...0.4

0.3

Update setup.py