def test_mdx_hierarchy_set_except(self):
hierarchy_set = MdxHierarchySet.member(Member.of("DIMENSION", "ELEMENT1")). \
except_(MdxHierarchySet.member(Member.of("DIMENSION", "ELEMENT2")))
self.assertEqual(
"{EXCEPT({[DIMENSION].[DIMENSION].[ELEMENT1]},{[DIMENSION].[DIMENSION].[ELEMENT2]})}",
hierarchy_set.to_mdx())
def test_mdx_hierarchy_set_union(self):
hierarchy_set = MdxHierarchySet.member(Member.of("DIMENSION", "ELEMENT1")). \
union(MdxHierarchySet.member(Member.of("DIMENSION", "ELEMENT2")))
self.assertEqual(
"{UNION({[DIMENSION].[DIMENSION].[ELEMENT1]},{[DIMENSION].[DIMENSION].[ELEMENT2]})}",
hierarchy_set.to_mdx())
def test_mdx_hierarchy_set_intersect(self):
hierarchy_set = MdxHierarchySet.member(Member.of("DIMENSION", "ELEMENT1")). \
intersect(MdxHierarchySet.member(Member.of("DIMENSION", "ELEMENT2")))
self.assertEqual(
"{INTERSECT({[DIMENSION].[DIMENSION].[ELEMENT1]},{[DIMENSION].[DIMENSION].[ELEMENT2]})}",
hierarchy_set.to_mdx())
def test_mdx_hierarchy_set_intersect(self):
hierarchy_set = MdxHierarchySet.member(Member.of("dimension", "element1")). \
intersect(MdxHierarchySet.member(Member.of("dimension", "element2")))
self.assertEqual(
"{INTERSECT({[dimension].[dimension].[element1]},{[dimension].[dimension].[element2]})}",
hierarchy_set.to_mdx())
def test_mdx_hierarchy_set_except(self):
hierarchy_set = MdxHierarchySet.member(Member.of("dimension", "element1")). \
except_(MdxHierarchySet.member(Member.of("dimension", "element2")))
self.assertEqual(
"{EXCEPT({[dimension].[dimension].[element1]},{[dimension].[dimension].[element2]})}",
hierarchy_set.to_mdx())
def test_mdx_hierarchy_set_union(self):
hierarchy_set = MdxHierarchySet.member(Member.of("dimension", "element1")). \
union(MdxHierarchySet.member(Member.of("dimension", "element2")))
self.assertEqual(
"{UNION({[dimension].[dimension].[element1]},{[dimension].[dimension].[element2]})}",
hierarchy_set.to_mdx())
def test_mdx_set_cross_joins(self):
mdx_set = MdxSet.cross_joins([
MdxHierarchySet.children(Member.of("Dimension", "element1")),
MdxHierarchySet.member(Member.of("Dimension", "element2")),
MdxHierarchySet.member(Member.of("Dimension", "element3"))
])
self.assertEqual(
"{{[dimension].[dimension].[element1].CHILDREN}"
" * {[dimension].[dimension].[element2]}"
" * {[dimension].[dimension].[element3]}}", mdx_set.to_mdx())
def test_mdx_set_unions_allow_duplicates(self):
hierarchy_set = MdxSet.unions([
MdxHierarchySet.children(Member.of("Dimension", "element1")),
MdxHierarchySet.member(Member.of("Dimension", "element2")),
MdxHierarchySet.member(Member.of("Dimension", "element3"))
], True)
self.assertEqual(
"{{[dimension].[dimension].[element1].CHILDREN},"
"{[dimension].[dimension].[element2]},"
"{[dimension].[dimension].[element3]}}", hierarchy_set.to_mdx())
def test_mdx_hierarchy_set_unions_no_duplicates(self):
hierarchy_set = MdxHierarchySet.unions([
MdxHierarchySet.children(Member.of("Dimension", "element1")),
MdxHierarchySet.member(Member.of("Dimension", "element2")),
MdxHierarchySet.member(Member.of("Dimension", "element3"))
])
self.assertEqual(
"{{[DIMENSION].[DIMENSION].[ELEMENT1].CHILDREN}"
" + {[DIMENSION].[DIMENSION].[ELEMENT2]}"
" + {[DIMENSION].[DIMENSION].[ELEMENT3]}}", hierarchy_set.to_mdx())
def test_mdx_builder_multi_axes(self):
mdx = MdxBuilder.from_cube("cube") \
.add_hierarchy_set_to_axis(0, MdxHierarchySet.member(Member.of("Dim1", "Elem1"))) \
.add_hierarchy_set_to_axis(1, MdxHierarchySet.member(Member.of("Dim2", "Elem2"))) \
.add_hierarchy_set_to_axis(2, MdxHierarchySet.member(Member.of("Dim3", "Elem3"))) \
.add_hierarchy_set_to_axis(3, MdxHierarchySet.member(Member.of("Dim4", "Elem4"))) \
.add_hierarchy_set_to_axis(4, MdxHierarchySet.member(Member.of("Dim5", "Elem5"))) \
.to_mdx()
self.assertEqual(
"SELECT\r\n"
"{[dim1].[dim1].[elem1]} ON 0,\r\n"
"{[dim2].[dim2].[elem2]} ON 1,\r\n"
"{[dim3].[dim3].[elem3]} ON 2,\r\n"
"{[dim4].[dim4].[elem4]} ON 3,\r\n"
"{[dim5].[dim5].[elem5]} ON 4\r\n"
"FROM [cube]", mdx)
def test_mdx_builder_single_axes(self):
mdx = MdxBuilder.from_cube("cube") \
.add_hierarchy_set_to_axis(0, MdxHierarchySet.member(Member.of("Dim1", "Elem1"))) \
.to_mdx()
self.assertEqual(
"SELECT\r\n"
"{[dim1].[dim1].[elem1]} ON 0\r\n"
"FROM [cube]", mdx)
def test_mdx_builder_multi_no_where(self):
mdx = MdxBuilder.from_cube("cube") \
.rows_non_empty() \
.add_hierarchy_set_to_row_axis(MdxHierarchySet.all_leaves("Dim1")) \
.columns_non_empty() \
.add_hierarchy_set_to_column_axis(MdxHierarchySet.member(Member.of("Dim2", "Elem2"))) \
.to_mdx()
self.assertEqual(
"SELECT\r\n"
"NON EMPTY {[dim2].[dim2].[elem2]} ON 0,\r\n"
"NON EMPTY {TM1FILTERBYLEVEL({TM1SUBSETALL([dim1].[dim1])},0)} ON 1\r\n"
"FROM [cube]", mdx)
def test_mdx_builder_simple(self):
mdx = MdxBuilder.from_cube("CUBE") \
.rows_non_empty() \
.add_hierarchy_set_to_row_axis(MdxHierarchySet.all_leaves("Dim1")) \
.columns_non_empty() \
.add_hierarchy_set_to_column_axis(MdxHierarchySet.member(Member.of("Dim2", "Elem2"))) \
.where(Member.of("Dim3", "Elem3"), Member.of("Dim4", "Elem4")) \
.to_mdx()
self.assertEqual(
"SELECT\r\n"
"NON EMPTY {[DIM2].[DIM2].[ELEM2]} ON 0,\r\n"
"NON EMPTY {TM1FILTERBYLEVEL({TM1SUBSETALL([DIM1].[DIM1])},0)} ON 1\r\n"
"FROM [CUBE]\r\n"
"WHERE ([DIM3].[DIM3].[ELEM3],[DIM4].[DIM4].[ELEM4])", mdx)
def test_mdx_builder_tm1_ignore_bad_tuples(self):
mdx = MdxBuilder.from_cube("cube") \
.tm1_ignore_bad_tuples() \
.rows_non_empty() \
.add_hierarchy_set_to_row_axis(MdxHierarchySet.all_leaves("Dim1")) \
.columns_non_empty() \
.add_hierarchy_set_to_column_axis(MdxHierarchySet.member(Member.of("Dim2", "Elem2"))) \
.where(Member.of("Dim3", "Elem3"), Member.of("Dim4", "Elem4")) \
.to_mdx()
self.assertEqual(
"SELECT\r\n"
"NON EMPTY TM1IGNORE_BADTUPLES {[dim2].[dim2].[elem2]} ON 0,\r\n"
"NON EMPTY TM1IGNORE_BADTUPLES {TM1FILTERBYLEVEL({TM1SUBSETALL([dim1].[dim1])},0)} ON 1\r\n"
"FROM [cube]\r\n"
"WHERE ([dim3].[dim3].[elem3],[dim4].[dim4].[elem4])", mdx)