def test_as_mdx_registered_subsets(self): s1 = Subset("s1", "d1", "d1", None, None, ["e1", "e2"]) s2 = Subset("s2", "d2", "d2", None, None, ["e1", "e2"]) s3 = Subset("s3", "d3", "d3", None, None, ["e1", "e2"]) native_view = NativeView(cube_name="c1", view_name="not_relevant", suppress_empty_columns=True, suppress_empty_rows=False, titles=[ViewTitleSelection("d1", s1, "e1")], columns=[ViewAxisSelection("d2", s2)], rows=[ViewAxisSelection("d3", s3)]) self.assertEqual( "SELECT\r\n" "NON EMPTY {TM1SUBSETTOSET([D2].[D2],\"s2\")} ON 0,\r\n" "{TM1SUBSETTOSET([D3].[D3],\"s3\")} ON 1\r\n" "FROM [C1]\r\n" "WHERE ([D1].[D1].[E1])", native_view.mdx)
def setUp(self): if self.tm1.cubes.exists(self.cube_name): self.tm1.cubes.delete(self.cube_name) for dimension in (self.dim1, self.dim2, self.dim3, self.dim4): if self.tm1.dimensions.exists(dimension.name): self.tm1.dimensions.delete(dimension.name) self.tm1.dimensions.create(dimension) self.tm1.cubes.create(self.cube) # Build Subset self.dim4_subset_Name = PREFIX + "Subset" self.tm1.dimensions.subsets.create(Subset( subset_name=self.dim4_subset_Name, dimension_name=self.dim4_name, hierarchy_name=self.dim4_name, expression="HEAD([{}].Members, 1)".format(self.dim4_name)))
def setUpClass(cls) -> None: # Build Dimensions for dimension_name in DIMENSION_NAMES: elements = [ Element('Element {}'.format(str(j)), 'Numeric') for j in range(1, 1001) ] element_attributes = [ ElementAttribute("Attr1", "String"), ElementAttribute("Attr2", "Numeric"), ElementAttribute("Attr3", "Numeric") ] hierarchy = Hierarchy(dimension_name=dimension_name, name=dimension_name, elements=elements, element_attributes=element_attributes) dimension = Dimension(dimension_name, [hierarchy]) if cls.tm1.dimensions.exists(dimension.name): cls.tm1.dimensions.update(dimension) else: cls.tm1.dimensions.create(dimension) # Build Cube cube = Cube(CUBE_NAME, DIMENSION_NAMES) if not cls.tm1.cubes.exists(CUBE_NAME): cls.tm1.cubes.create(cube) # Build cube view view = NativeView(cube_name=CUBE_NAME, view_name=VIEW_NAME, suppress_empty_columns=True, suppress_empty_rows=True) view.add_row(dimension_name=DIMENSION_NAMES[0], subset=AnonymousSubset(dimension_name=DIMENSION_NAMES[0], expression='{[' + DIMENSION_NAMES[0] + '].Members}')) view.add_row(dimension_name=DIMENSION_NAMES[1], subset=AnonymousSubset(dimension_name=DIMENSION_NAMES[1], expression='{[' + DIMENSION_NAMES[1] + '].Members}')) view.add_column( dimension_name=DIMENSION_NAMES[2], subset=AnonymousSubset(dimension_name=DIMENSION_NAMES[2], expression='{[' + DIMENSION_NAMES[2] + '].Members}')) if not cls.tm1.cubes.views.exists(CUBE_NAME, view.name, private=False): cls.tm1.cubes.views.create(view=view, private=False) # Build subset subset = Subset(SUBSET_NAME, DIMENSION_NAMES[0], DIMENSION_NAMES[0], None, None, ["Element 1"]) if cls.tm1.dimensions.hierarchies.subsets.exists( subset.name, subset.dimension_name, subset.hierarchy_name, False): cls.tm1.dimensions.hierarchies.subsets.delete( subset.name, subset.dimension_name, subset.hierarchy_name, False) cls.tm1.dimensions.hierarchies.subsets.create(subset, False) # Build process p1 = Process(name=PROCESS_NAME) p1.add_parameter('pRegion', 'pRegion (String)', value='US') if cls.tm1.processes.exists(p1.name): cls.tm1.processes.delete(p1.name) cls.tm1.processes.create(p1) # Build chore c1 = Chore(name=CHORE_NAME, start_time=ChoreStartTime(datetime.now().year, datetime.now().month, datetime.now().day, datetime.now().hour, datetime.now().minute, datetime.now().second), dst_sensitivity=False, active=True, execution_mode=Chore.MULTIPLE_COMMIT, frequency=ChoreFrequency(days=int(random.uniform(0, 355)), hours=int(random.uniform(0, 23)), minutes=int(random.uniform(0, 59)), seconds=int(random.uniform(0, 59))), tasks=[ ChoreTask(0, PROCESS_NAME, parameters=[{ 'Name': 'pRegion', 'Value': 'UK' }]) ]) cls.tm1.chores.create(c1) # create Folder app = FolderApplication("", TM1PY_APP_FOLDER) cls.tm1.applications.create(application=app, private=False)
import uuid from TM1py import Subset, TM1pyQueries as TM1, TM1pyLogin login = TM1pyLogin.native('admin', 'apple') with TM1(ip='', port=8001, login=login, ssl=False) as tm1: subset_name = str(uuid.uuid4()) # create subset s = Subset(dimension_name='Plan_Department', subset_name=subset_name, alias='', elements=['200', '405', '410']) tm1.create_subset(s, True) # get it and print out the elements s = tm1.get_subset(dimension_name='Plan_Department', subset_name=subset_name, private=True) print(s.elements) # update it s.add_elements(['105', '115']) tm1.update_subset(s, True) # get it and print out the elements s = tm1.get_subset(dimension_name='Plan_Department', subset_name=subset_name, private=True) print(s.elements)
def setUpClass(cls) -> None: """ Establishes a connection to TM1 and creates TM1 objects to use across all tests """ # Connection to TM1 cls.config = configparser.ConfigParser() cls.config.read(Path(__file__).parent.joinpath('config.ini')) cls.tm1 = TM1Service(**cls.config['tm1srv01']) # Build Dimensions for dimension_name in cls.dimension_names: elements = [ Element('Element {}'.format(str(j)), 'Numeric') for j in range(1, 1001) ] element_attributes = [ ElementAttribute("Attr1", "String"), ElementAttribute("Attr2", "Numeric"), ElementAttribute("Attr3", "Numeric") ] hierarchy = Hierarchy(dimension_name=dimension_name, name=dimension_name, elements=elements, element_attributes=element_attributes) dimension = Dimension(dimension_name, [hierarchy]) if cls.tm1.dimensions.exists(dimension.name): cls.tm1.dimensions.update(dimension) else: cls.tm1.dimensions.create(dimension) # Build Cube cube = Cube(cls.cube_name, cls.dimension_names) if not cls.tm1.cubes.exists(cls.cube_name): cls.tm1.cubes.create(cube) # Build cube view view = NativeView(cube_name=cls.cube_name, view_name=cls.view_name, suppress_empty_columns=True, suppress_empty_rows=True) view.add_row( dimension_name=cls.dimension_names[0], subset=AnonymousSubset(dimension_name=cls.dimension_names[0], expression='{[' + cls.dimension_names[0] + '].Members}')) view.add_row( dimension_name=cls.dimension_names[1], subset=AnonymousSubset(dimension_name=cls.dimension_names[1], expression='{[' + cls.dimension_names[1] + '].Members}')) view.add_column( dimension_name=cls.dimension_names[2], subset=AnonymousSubset(dimension_name=cls.dimension_names[2], expression='{[' + cls.dimension_names[2] + '].Members}')) if not cls.tm1.cubes.views.exists( cls.cube_name, view.name, private=False): cls.tm1.cubes.views.create(view=view, private=False) # Build subset subset = Subset(cls.subset_name, cls.dimension_names[0], cls.dimension_names[0], None, None, ["Element 1"]) if cls.tm1.dimensions.hierarchies.subsets.exists( subset.name, subset.dimension_name, subset.hierarchy_name, False): cls.tm1.dimensions.hierarchies.subsets.delete( subset.name, subset.dimension_name, subset.hierarchy_name, False) cls.tm1.dimensions.hierarchies.subsets.create(subset, False) # Build process p1 = Process(name=cls.process_name) p1.add_parameter('pRegion', 'pRegion (String)', value='US') if cls.tm1.processes.exists(p1.name): cls.tm1.processes.delete(p1.name) cls.tm1.processes.create(p1) # Build chore c1 = Chore(name=cls.chore_name, start_time=ChoreStartTime(datetime.now().year, datetime.now().month, datetime.now().day, datetime.now().hour, datetime.now().minute, datetime.now().second), dst_sensitivity=False, active=True, execution_mode=Chore.MULTIPLE_COMMIT, frequency=ChoreFrequency(days=int(random.uniform(0, 355)), hours=int(random.uniform(0, 23)), minutes=int(random.uniform(0, 59)), seconds=int(random.uniform(0, 59))), tasks=[ ChoreTask(0, cls.process_name, parameters=[{ 'Name': 'pRegion', 'Value': 'UK' }]) ]) cls.tm1.chores.create(c1) # create Folder app = FolderApplication("", cls.tm1py_app_folder) cls.tm1.applications.create(application=app, private=False)
import uuid from TM1py import Subset, TM1pyQueries as TM1, TM1pyLogin random_string1 = str(uuid.uuid4()) random_string2 = str(uuid.uuid4()) login = TM1pyLogin.native('admin', 'apple') tm1 = TM1(ip='', port=8001, login=login, ssl=False) # create dynamic subset s = Subset(dimension_name='plan_business_unit', subset_name='TM1py_' + random_string1, alias='', expression='{ HIERARCHIZE( {TM1SUBSETALL( [plan_business_unit] )} ) }') tm1.create_subset(s) # create static subset s = Subset(dimension_name='plan_business_unit', subset_name='TM1py_' + random_string2, alias='', elements=['10000', '10000', '10000', '10000', '10000', '10000', '10000', '10000', '10000']) tm1.create_subset(s) # delete subset tm1.delete_subset(dimension_name='plan_business_unit', subset_name='TM1py_' + random_string1) tm1.delete_subset(dimension_name='plan_business_unit', subset_name='TM1py_' + random_string2) # logout tm1.logout()
import uuid from TM1py import Subset, TM1pyQueries as TM1, TM1pyLogin login = TM1pyLogin.native('admin', 'apple') with TM1(ip='', port=8001, login=login, ssl=False) as tm1: subset_name = str(uuid.uuid4()) # create subset s = Subset(dimension_name='Plan_Department', subset_name=subset_name, alias='', elements=['200', '405', '410']) tm1.create_subset(s, True) # get it and print out the elements s = tm1.get_subset(dimension_name='Plan_Department', subset_name=subset_name, private=True) print(s.elements) # update it s.add_elements(['105', '115']) tm1.update_subset(s, True) # get it and print out the elements s = tm1.get_subset(dimension_name='Plan_Department', subset_name=subset_name, private=True) print(s.elements) # delete it tm1.delete_subset(dimension_name='Plan_Department', subset_name=subset_name , private=True)