コード例 #1
0
 def test_tm1io_input_values_output_view(self):
     # define output view
     mdx_output = MDX_TEMPLATE_SHORT.format(
         rows="{[" + DIMENSION_NAMES[0] + "].[Element_1]}",
         columns="{[" + DIMENSION_NAMES[1] + "].[Element_1]}",
         cube=CUBE_NAME_TARGET)
     view_output = MDXView(cube_name=CUBE_NAME_TARGET,
                           view_name=VIEW_NAME_TARGET,
                           MDX=mdx_output)
     self.tm1.cubes.views.create(view=view_output, private=False)
     # execute method
     stdev_p(tm1_services={"tm1srv01": self.tm1},
             tm1_target="tm1srv01",
             cube_target=CUBE_NAME_TARGET,
             view_target=VIEW_NAME_TARGET,
             values=STDEV_INPUT_VALUES,
             tidy=False)
     # do check
     result = next(
         self.tm1.cubes.cells.execute_view_values(
             cube_name=CUBE_NAME_TARGET,
             view_name=VIEW_NAME_TARGET,
             private=False))
     self.assertAlmostEqual(result,
                            STDEV_P_EXPECTED_RESULT,
                            delta=STDEV_TOLERANCE)
コード例 #2
0
 def test_tm1tidy_false_input_view(self):
     # define input view and output view
     mdx_input = MDX_TEMPLATE_SHORT.format(
         rows="{ HEAD ( { [" + DIMENSION_NAMES[0] + "].Members}," +
         str(len(STDEV_INPUT_VALUES)) + ") }",
         columns="{[" + DIMENSION_NAMES[1] + "].[Element_1]}",
         cube=CUBE_NAME_SOURCE)
     view_input = MDXView(cube_name=CUBE_NAME_SOURCE,
                          view_name=VIEW_NAME_SOURCE,
                          MDX=mdx_input)
     self.tm1.cubes.views.create(view=view_input, private=False)
     # write values into input view
     mdx = view_input.MDX
     self.tm1.cubes.cells.write_values_through_cellset(
         mdx, STDEV_INPUT_VALUES)
     # execute method
     stdev_p(tm1_services={"tm1srv01": self.tm1},
             tm1_source="tm1srv01",
             cube_source=CUBE_NAME_SOURCE,
             view_source=VIEW_NAME_SOURCE,
             tidy=False)
     self.assertTrue(
         self.tm1.cubes.views.exists(cube_name=CUBE_NAME_SOURCE,
                                     view_name=VIEW_NAME_SOURCE,
                                     private=False))
コード例 #3
0
 def test_stdev_p(self):
     result = stdev_p(values=STDEV_INPUT_VALUES)
     self.assertAlmostEqual(result,
                            STDEV_P_EXPECTED_RESULT,
                            delta=STDEV_TOLERANCE)