tm1py-samples/Metadata/process_run_code.py at master · cubewise-code/tm1py-samples · GitHub

31 lines (27 loc) · 1.05 KB

"""

Run loose statements of TI

"""

import configparser

config = configparser.ConfigParser()

# storing the credentials in a file is not recommended for purposes other than testing.

# it's better to setup CAM with SSO or use keyring to store credentials in the windows credential manager. Sample:

# Samples/credentials_best_practice.py

config.read(r'..\config.ini')

from TM1py.Services import TM1Service

with TM1Service(**config['tm1srv01']) as tm1:

# Sample 1

ti_statements = [

"DimensionCreate ( 'TM1py' );",

"DimensionElementInsert ( 'TM1py' , '' , 'tm1' , 'N');",

"DimensionElementInsert ( 'TM1py' , '' , 'is' , 'N');",

"DimensionElementInsert ( 'TM1py' , '' , 'awesome' , 'N');"

]

tm1.processes.execute_ti_code(lines_prolog=ti_statements, lines_epilog=[])

# Sample 2

ti_statements = [

"SaveDataAll;",

"DeleteAllPersistentFeeders;",

"SecurityRefresh;",

"CubeProcessFeeders('Plan_BudgetPlan');"

]

tm1.processes.execute_ti_code(lines_prolog=ti_statements, lines_epilog=[])

Expand file tree