mdxpy

mdxpy copied to clipboard

I have an MDX Query that I am trying to mirror, WITH SET [Virtual Measure:Virtual Measure:}rollup_1] AS {[Virtual Measure].[Virtual Measure].[Value]} MEMBER [Virtual Measure].[Virtual Measure].[}rollup_1] AS AGGREGATE({[Virtual Measure:Virtual Measure:}rollup_1]}) SELECT {[Virtual...

stevenorsini

Generated MDX is incorrect with multiple dimensions on row or column Axis.

3

When using: ``` python for dim in dims: elements_dict = tm1.elements.get_leaf_elements(dimension_name=dim, hierarchy_name=dim) print(dim) element_sample = elements_dict if elements_dict.__len__() > 10: k = int(round(len(elements_dict) * percent, 0)) element_sample = random.sample(elements_dict, k=1)...

swaterbury-CW

Descendants on multiple members

1

Unable to build the DESCENDANTS mdx expression against a set of multiple members. ``` hierarchy_set = MdxHierarchySet.descendants( MdxHierarchySet.members([Member.of('Dimension', 'Hierarchy', 'Member1'), Member.of('Dimension', 'Hierarchy', 'Member2')]).to_mdx() ``` getting error: AttributeError: 'ElementsHierarchySet' object has...

cubewise-gng

feat: convert MDX query to TM1py Native View

10

# Introduction this proposal is to add a MDX compiler to analyze Cube MDX expression and build TM1py Native View Object. ```python mdx = """ SELECT {[DIM A].[HIE A].[ELE A]}...

Cubewise-JoeCHK