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(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)
