def test1_create_view(self): # create instance of native View native_view = NativeView(cube_name='Plan_BudgetPlan', view_name=self.native_view_name) # set up native view - put subsets on Rows, Columns and Titles subset = self.tm1.get_subset(dimension_name='plan_version', subset_name='FY 2004 Budget', private=False) native_view.add_row(dimension_name='plan_version', subset=subset) subset = self.tm1.get_subset(dimension_name='plan_business_unit', subset_name='n level business unit', private=False) native_view.add_row(dimension_name='plan_business_unit', subset=subset) subset = self.tm1.get_subset(dimension_name='plan_department', subset_name='n level departments', private=False) native_view.add_row(dimension_name='plan_department', subset=subset) subset = self.tm1.get_subset(dimension_name='plan_chart_of_accounts', subset_name='Consolidations', private=False) native_view.add_row(dimension_name='plan_chart_of_accounts', subset=subset) subset = self.tm1.get_subset(dimension_name='plan_exchange_rates', subset_name='local', private=False) native_view.add_title(dimension_name='plan_exchange_rates', subset=subset, selection='local') subset = self.tm1.get_subset(dimension_name='plan_time', subset_name='2004 Total Year', private=False) native_view.add_column(dimension_name='plan_time', subset=subset) subset = self.tm1.get_subset(dimension_name='plan_source', subset_name='budget', private=False) native_view.add_column(dimension_name='plan_source', subset=subset) # create native view on Server self.tm1.create_view(view=native_view, private=self.random_boolean) # create instance of MDXView nv_view = self.tm1.get_native_view(cube_name='Plan_BudgetPlan', view_name=self.native_view_name, private=self.random_boolean) mdx = nv_view.as_MDX mdx_view = MDXView(cube_name='Plan_BudgetPlan', view_name=self.mdx_view_name, MDX=mdx) # create mdx view on Server self.tm1.create_view(view=mdx_view, private=self.random_boolean)
def test1_create_view(self): # create instance of native View native_view = NativeView(name_cube='Plan_BudgetPlan', name_view=self.native_view_name) # set up native view - put subsets on Rows, Columns and Titles subset = self.tm1.get_subset(dimension_name='plan_version', subset_name='FY 2004 Budget') native_view.add_row(dimension_name='plan_version', subset=subset) subset = self.tm1.get_subset(dimension_name='plan_business_unit', subset_name='n level business unit') native_view.add_row(dimension_name='plan_business_unit', subset=subset) subset = self.tm1.get_subset(dimension_name='plan_department', subset_name='n level departments') native_view.add_row(dimension_name='plan_department', subset=subset) subset = self.tm1.get_subset(dimension_name='plan_chart_of_accounts', subset_name='Consolidations') native_view.add_row(dimension_name='plan_chart_of_accounts', subset=subset) subset = self.tm1.get_subset(dimension_name='plan_source', subset_name='budget') native_view.add_row(dimension_name='plan_source', subset=subset) subset = self.tm1.get_subset(dimension_name='plan_exchange_rates', subset_name='actual') native_view.add_title(dimension_name='plan_exchange_rates', subset=subset, selection='actual') subset = self.tm1.get_subset(dimension_name='plan_time', subset_name='2003 Total Year') native_view.add_column(dimension_name='plan_time', subset=subset) # create native view on Server self.tm1.create_view(view=native_view, private=self.random_boolean) # create instance of MDXView mdx = "SELECT {([plan_version].[FY 2003 Budget], [plan_department].[105], [plan_chart_of_accounts].[61030], " \ "[plan_exchange_rates].[local], [plan_source].[goal] , [plan_time].[Jan-2004]) } on COLUMNS," \ "{[plan_business_unit].[10110]} on ROWS FROM [plan_BudgetPlan]" mdx_view = MDXView(cube_name='Plan_BudgetPlan', view_name=self.mdx_view_name, MDX=mdx) # create mdx view on Server self.tm1.create_view(view=mdx_view, private=self.random_boolean)
view = NativeView(cube_name="Bike Shares", view_name="Bike Shares By City", suppress_empty_columns=True, suppress_empty_rows=True) view.add_row(dimension_name="Date", subset=AnonymousSubset(dimension_name="Date", expression="{Tm1SubsetAll([Date])}")) view.add_row(dimension_name="Bike Shares Measure", subset=AnonymousSubset(dimension_name="Bike Shares Measure", elements=["Count"])) view.add_column(dimension_name="City", subset=AnonymousSubset(dimension_name="City", elements=["NYC", "Chicago"])) view.add_title(dimension_name="Version", selection="Actual", subset=AnonymousSubset(dimension_name="Version", elements=["Actual"])) with TM1Service(**config['tm1srv01']) as tm1: if tm1.cubes.views.exists(cube_name="Bike Shares", view_name="Bike Shares By City", private=False): tm1.cubes.views.delete(cube_name="Bike Shares", view_name="Bike Shares By City", private=False) tm1.cubes.views.create(view=view, private=False) pivot = tm1.cubes.cells.execute_view_dataframe_pivot( cube_name="Bike Shares", view_name="Bike Shares By City")
# establish connection to TM1 Server q = TM1Queries(ip='', port=8008, user='******', password='******', ssl=True) # random text random_string = str(uuid.uuid4()) # create native view view = NativeView(name_cube='plan_Budgetplan', name_view=random_string) # assign subsets to rows, columns, titles view.add_row(dimension_name='plan_version', subset_name='FY 2004 Budget') view.add_row(dimension_name='plan_business_unit', subset_name='n level business unit') view.add_row(dimension_name='plan_department', subset_name='n level departments') view.add_row(dimension_name='plan_chart_of_accounts', subset_name='Consolidations') view.add_row(dimension_name='plan_source', subset_name='budget') view.add_title(dimension_name='plan_exchange_rates', subset_name='actual', selection='actual') view.add_column(dimension_name='plan_time', subset_name='2003 Total Year') # create native view against TM1 Server q.create_view(view=view) # delete native view from server q.delete_view(view.get_cube(), view.get_name()) # random text random_string = str(uuid.uuid4()) # create mdx view mdx = "SELECT {([plan_version].[FY 2003 Budget], [plan_department].[105], [plan_chart_of_accounts].[61030], " \ "[plan_exchange_rates].[local], [plan_source].[goal] , [plan_time].[Jan-2004]) } on COLUMNS," \ "{[plan_business_unit].[10110]} on ROWS FROM [plan_BudgetPlan]"
suppress_empty_columns=False, suppress_empty_rows=False) view.add_row( dimension_name="Py Quarter", subset=AnonymousSubset( dimension_name="Py Quarter", expression="{Tm1SubsetAll([Py Quarter])}")) view.add_column( dimension_name="Py Project", subset=AnonymousSubset( dimension_name="Py Project", elements=[project])) view.add_title( dimension_name="Py Project Planning Measure", selection="Cashflow", subset=AnonymousSubset( dimension_name="Py Project Planning Measure", elements=["Cashflow"]) ) if tm1.cubes.views.exists(cube_name=view.cube, view_name=view.name, private=False): tm1.cubes.views.delete(cube_name=view.cube, view_name=view.name, private=False) tm1.cubes.views.create(view=view, private=False) # write to cube 1 cellset = { ('Project1', '2018-Q1', 'Cashflow'): -100000, ('Project1', '2018-Q2', 'Cashflow'): 10000, ('Project1', '2018-Q3', 'Cashflow'): 10000, ('Project1', '2018-Q4', 'Cashflow'): 10000, ('Project1', '2019-Q1', 'Cashflow'): 10000, ('Project1', '2019-Q2', 'Cashflow'): 10000,
# establish connection to TM1 Server with TM1(ip='', port=8001, login=login, ssl=False) as tm1: native_view = NativeView(cube_name='Plan_BudgetPlan', view_name='TM1py View') # set up native view - put subsets on Rows, Columns and Titles subset = tm1.get_subset(dimension_name='plan_version', subset_name='FY 2004 Budget', private=False) native_view.add_row(dimension_name='plan_version', subset=subset) subset = tm1.get_subset(dimension_name='plan_business_unit', subset_name='n level business unit', private=False) native_view.add_row(dimension_name='plan_business_unit', subset=subset) subset = tm1.get_subset(dimension_name='plan_department', subset_name='n level departments', private=False) native_view.add_row(dimension_name='plan_department', subset=subset) subset = tm1.get_subset(dimension_name='plan_chart_of_accounts', subset_name='Consolidations', private=False) native_view.add_row(dimension_name='plan_chart_of_accounts', subset=subset) subset = tm1.get_subset(dimension_name='plan_exchange_rates', subset_name='local', private=False) native_view.add_title(dimension_name='plan_exchange_rates', subset=subset, selection='local') subset = tm1.get_subset(dimension_name='plan_time', subset_name='2004 Total Year', private=False) native_view.add_column(dimension_name='plan_time', subset=subset) subset = tm1.get_subset(dimension_name='plan_source', subset_name='budget', private=False) native_view.add_column(dimension_name='plan_source', subset=subset) # create native view on Server tm1.create_view(view=native_view, private=False)