def test_mdx_hierarchy_set_filter_by_level(self):
hierarchy_set = MdxHierarchySet.all_members(
"Dimension", "Hierarchy").filter_by_level(0)
self.assertEqual(
"{TM1FILTERBYLEVEL({[dimension].[hierarchy].MEMBERS},0)}",
hierarchy_set.to_mdx())
def test_mdx_hierarchy_set_filter_by_wildcard(self):
hierarchy_set = MdxHierarchySet.all_members(
"Dimension", "Hierarchy").filter_by_pattern("2011*")
self.assertEqual(
"{TM1FILTERBYPATTERN({[dimension].[hierarchy].MEMBERS},'2011*')}",
hierarchy_set.to_mdx())
def test_mdx_hierarchy_set_filter_by_element_type_str(self):
hierarchy_set = MdxHierarchySet.all_members(
"Dimension", "Hierarchy").filter_by_element_type("Numeric")
self.assertEqual(
"{FILTER({[dimension].[hierarchy].MEMBERS},"
"[dimension].[hierarchy].CURRENTMEMBER.PROPERTIES('ELEMENT_TYPE')='1')}",
hierarchy_set.to_mdx())
def test_mdx_hierarchy_set_order_by_attribute(self):
hierarchy_set = MdxHierarchySet.all_members("Dimension1", "Hierarchy1").order_by_attribute(
attribute_name="Attribute1",
order='asc')
self.assertEqual(
'{ORDER({[DIMENSION1].[HIERARCHY1].MEMBERS},'
'[DIMENSION1].[HIERARCHY1].CURRENTMEMBER.PROPERTIES("ATTRIBUTE1"), ASC)}',
hierarchy_set.to_mdx())
def test_mdx_hierarchy_set_order(self):
hierarchy_set = MdxHierarchySet.all_members("Dimension1", "Hierarchy1").order(
cube="Cube",
mdx_tuple=MdxTuple.of(
Member.of("Dimension2", "Hierarchy2", "ElementA"),
Member.of("Dimension3", "Hierarchy3", "ElementB")))
self.assertEqual(
"{ORDER({[DIMENSION1].[HIERARCHY1].MEMBERS},"
"[CUBE].([DIMENSION2].[HIERARCHY2].[ELEMENTA],[DIMENSION3].[HIERARCHY3].[ELEMENTB]),BASC)}",
hierarchy_set.to_mdx())
def test_mdx_hierarchy_set_filter_by_cell_value_string(self):
hierarchy_set = MdxHierarchySet.all_members("Dimension1", "Hierarchy1").filter_by_cell_value(
cube="Cube",
mdx_tuple=MdxTuple.of(
Member.of("Dimension2", "ElementA"),
Member.of("Dimension3", "ElementB")),
operator="=",
value='ABC')
self.assertEqual(
"{FILTER({[DIMENSION1].[HIERARCHY1].MEMBERS},"
"[CUBE].([DIMENSION2].[DIMENSION2].[ELEMENTA],[DIMENSION3].[DIMENSION3].[ELEMENTB])='ABC')}",
hierarchy_set.to_mdx())
def test_mdx_hierarchy_set_filter_by_cell_value_string(self):
hierarchy_set = MdxHierarchySet.all_members(
"Dimension1", "Hierarchy1").filter_by_cell_value(
cube="Cube",
mdx_tuple=MdxTuple.of(Member.of("Dimension2", "ElementA"),
Member.of("Dimension3", "ElementB")),
operator="=",
value='ABC')
self.assertEqual(
"{FILTER({[dimension1].[hierarchy1].MEMBERS},"
"[cube].([dimension2].[dimension2].[elementa],[dimension3].[dimension3].[elementb])='ABC')}",
hierarchy_set.to_mdx())
def test_mdx_hierarchy_set_order(self):
hierarchy_set = MdxHierarchySet.all_members(
"Dimension1",
"Hierarchy1").order(cube="Cube",
mdx_tuple=MdxTuple.of(
Member.of("Dimension2", "Hierarchy2",
"ElementA"),
Member.of("Dimension3", "Hierarchy3",
"ElementB")))
self.assertEqual(
"{ORDER({[dimension1].[hierarchy1].MEMBERS},"
"[cube].([dimension2].[hierarchy2].[elementa],[dimension3].[hierarchy3].[elementb]),BASC)}",
hierarchy_set.to_mdx())
def test_mdx_hierarchy_set_all_members(self):
hierarchy_set = MdxHierarchySet.all_members("Dimension", "Hierarchy")
self.assertEqual(
"{[DIMENSION].[HIERARCHY].MEMBERS}",
hierarchy_set.to_mdx())
def test_mdx_hierarchy_set_all_members(self):
hierarchy_set = MdxHierarchySet.all_members("Dimension", "Hierarchy")
self.assertEqual("{[dimension].[hierarchy].MEMBERS}",
hierarchy_set.to_mdx())
