# TM1 Code Migrate
tm1cm is a utility for moving TM1 Planning Analytics objects between TM1 applications, or your local file system. It can be used to manage the software development lifecycle of a TM1 application.
## Installation
Use the package manager [pip](https://pip.pypa.io/en/stable/) to install tm1cm.
```bash
pip install tm1cm
```
## Setup
First things first, you must 'scaffold' a new TM1 application on your local system, and then update settings.
```bash
tm1cm --mode scaffold --path ./mytm1application
```
This command will create the folder structure expected by the tm1cm utility
```text
mytestapplication/
config/
default/
connect.yaml
credentials.yaml
tm1cm.yaml
test/
staging/
prod/
data/
files/
scripts/
```
Under the 'config' directory, modify the folders (ignoring 'default' folder) for any environments (i.e test/staging/prod). Remove any that you won't use.
### Update connect.yaml
Copy connect.yaml from the default/ folder into each of the environment subfolders.
Update each connect.yaml file to contain the connection parameters for your TM1 application. You must be able to access the REST API endpoint of your TM1 application. For on-prem TM1 applications, this may look like:
```yaml
base_url: https://myonpremapplication:10000
```
If you are using the IBM Cloud, your connect.yaml may look like
```yaml
base_url: https://mycompany.planning-analytics.ibmcloud.com:443/tm1/api/tm1
```
### Update credentials.yaml
If your credentials are the same in all environments, you can update credentials.yaml within the default/ directory
If your credentials are different across each environment, copy credentials.yaml into each environment subfolder (as with connect.yaml) and update your credentials for each environment
```yaml
namespace: LDAP
user: mysecureusername
password: mysecurepassword
```
**NOTE:** If you are using IBM Cloud, You must use an automation user that was included in the IBM Cloud Welcome Back. It is not possible to connect to use tm1cm with your IBM ID
### Update tm1cm.yaml
tm1cm.yaml is the primary configuration file that determines what objects SHOULD and SHOULD NOT be included in migrations.
Because some parts of TM1 applications are generally dynamic, you may not want to include every single TM1 hierarchy, subset, dimension, etc in your tm1cm configuration.
At runtime, the model is passed through a series of filters that are defined below. You can define one or many filters for each type of object. The yaml config is fairly flexible. You can be fairly selective about what you migrate.
```yaml
# Turbo Integrator Processes:
# Define a list of TI processes to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter
# it further using the 'exclude' filter. Use * as a wildcard character anywhere within the cube name
# Filters can be defined as a single item, or as a list of items.
#
# Format: <ProcessName>
# Examples:
# - Actual.Call.* -- include all processes that start with Actual.Call
# - * -- include all processes
include_process: '*'
exclude_process:
- '}tp*'
# This will apply standard case/indentation/formatting for TI Processes
autoformat_ti_process: true
# Cubes:
# Define a list of cubes to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter
# it further using the 'exclude' filter. Use * as a wildcard character anywhere within the cube name
# Filters can be defined as a single item, or as a list of items.
#
# Format: <CubeName>
# Example: }ClientGroups
include_cube: '*'
exclude_cube:
- '}ClientCAMAssociatedGroups'
- '}ClientProperties'
- '}ClientSettings'
- '}ElementProperties*'
- '}HierarchyProperties'
- '}Stats*'
- '}Hold*'
- '}CubeProperties'
- '}DimensionProperties'
- '}ElementAttributes_}*'
- '}ElementAttributes_}Clients'
- '}Capabilities'
- '}CubeSecurityProperties'
- '}PickList*'
- '*}tp*'
- '}CellAnnotations*'
# Rules:
# Define a list of cube rules to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter
# it further using the 'exclude' filter. Use * as a wildcard character anywhere within the cube name
# Filters can be defined as a single item, or as a list of items.
#
# Format: <CubeName>
# Example: }ClientGroups
include_rule: '*'
exclude_rule: ''
# Cube Views:
# Define a list of cubes views to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter
# it further using the 'exclude' filter. Use * as a wildcard character anywhere within the cube name
# Filters can be defined as a single item, or as a list of items.
#
# Note: This only includes the view definition, it does not include any data. It is recommended that any subsets included
# in the view definition also be included using 'include_dimension_hierarchy_subset' otherwise the migration will fail
#
# Note: Only public views are supported
#
# Format: <CubeName>/<ViewName>
# Examples:
# - afReporting/Default -- include the 'Default' view for 'afReporting' cube
# - */Default -- Match the 'Default' view for all cubes
# - afReporting/* -- Match all views for afReporting cube
include_cube_view: ''
exclude_cube_view: ''
# Cube View Data:
# Define a list of cube view data to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter
# it further using the 'exclude' filter. Use * as a wildcard character anywhere within the cube name
# Filters can be defined as a single item, or as a list of items.
#
# Note: This is generally intended for moving smaller sets of data, like control cube values. It is not intended for moving large
# data sets.
#
# Note: Only public views are supported. It's recommended to disable zero suppression on the view otherwise stale data may
# be left behind on the target
#
# Format: <CubeName>/<ViewName>
# Examples:
# - afReporting/Default -- include the 'Default' view data for 'afReporting' cube
# - */Default -- Match the 'Default' view data for all cubes
# - afReporting/* -- Match all view data for afReporting cube
include_cube_view_data: ''
exclude_cube_view_data: ''
# Dimensions:
# Define a list of dimensionss to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter
# it further using the 'exclude' filter. Use * as a wildcard character anywhere. Filters can be defined as a single item,
# or as a list of items.
#
# Note: A 'dimension' is only a container of hierarchies. You must also configure 'include_dimension_hierarchy'
#
# Note: Only public views are supported. It's recommended to disable zero suppression on the view otherwise stale data may
# be left behind on the target
#
# Format: <DimensionName>
# Examples:
# - af* -- include all dimensions starting with af
# - *_Measure -- include all dimensions that end with _Measure
include_dimension: '*'
exclude_dimension:
- '}Stats*'
- '}Hierarchies*'
- '}ApplicationEntries'
- '}CAMAssociatedGroups'
- '}Chores'
- '}Client*'
- '}Connection*'
- '}Cube Functions'
- '}CubeProperties'
- '}CubeSecurityProperties'
- '}Cubes'
- '}Cultures'
- '}DimensionFormatAttributes'
- '}DimensionFormatItems'
- '}DimensionProperties'
- '}ElementAttributes_}*'
- '}ElementProperties'
- '}Features'
- '}Groups'
- '}PickList'
- '}Processes'
- '}RuleStats'
- '}Subsets*'
- '}Views*'
- '}*'
- 'Sandboxes'
# Dimension Hierarchy:
# Define a list of dimension hierarchies to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter
# it further using the 'exclude' filter. Use * as a wildcard character anywhere. Filters can be defined as a single item,
# or as a list of items.
#
# Note: This will manage the migration of hierarchies, but will not explicitly include the elements of a hierarchy. In order to configure
# including/excluding a hierarchies elements, see 'include_dimension_hierarchy_element'
#
# Format: <DimensionName>/<HierarchyName>
# Examples:
# - afLocation/afLocation -- Include only the primary hierarchy for dimension afLocation
# - afLocation/* -- include all hierarchies for dimension afLocation
include_dimension_hierarchy: '*/*'
exclude_dimension_hierarchy:
- '}*/*'
- '*/Leaves'
# Dimension Hierarchy Elements:
# Define a list of dimension hierarchy elements to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter
# it further using the 'exclude' filter. Use * as a wildcard character anywhere. Filters can be defined as a single item,
# or as a list of items.
#
# Note: It is not recommended to include elements for hierarchies that are managed from other data sources (like upstream ERP)
#
# Format: <DimensionName>/<HierarchyName>
# Examples:
# - afLocation/afLocation -- Include only the primary hierarchy elements for dimension afLocation
# - afLocation/* -- include all hierarchy elements for dimension afLocation
include_dimension_hierarchy_element: '*/*'
exclude_dimension_hierarchy_element: ''
# Dimension Hierarchy Attributes:
# Define a list of dimension hierarchy attributes to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter
# it further using the 'exclude' filter. Use * as a wildcard character anywhere. Filters can be defined as a single item,
# or as a list of items.
#
# Note: This will only manage attributes themselves, it will not populate attribute values. In order to do that, see the
# include_dimension_hierarchy_attribute_value
#
# Format: <DimensionName>/<HierarchyName>/<AttributeName>
# Examples:
# - afLocation/afLocation/* -- include all attributes for afLocation dimension/hierarchy
# - afLocation/*/Name -- include 'Name' attribute for all hierarchies of afLocation
# - */*/Name -- include 'Name' attribute for all hierarchies of all dimensions
include_dimension_hierarchy_attribute: '*/*/*'
exclude_dimension_hierarchy_attribute: '*/*/}SYS*'
# Dimension Hierarchy Attribute Values:
# Define a list of dimension hierarchy attributes values to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter
# it further using the 'exclude' filter. Use * as a wildcard character anywhere. Filters can be defined as a single item,
# or as a list of items.
#
# Note: This will, for any included elements, manage the attribute values for each element.
#
# Format: <DimensionName>/<HierarchyName>/<AttributeName>
# Examples:
# - afLocation/afLocation/* -- include all attribute values for afLocation dimension/hierarchy
# - afLocation/*/Name -- include 'Name' attribute values for all hierarchies of afLocation
# - */*/Name -- include 'Name' attribute values for all hierarchies of all dimensions
include_dimension_hierarchy_attribute_value: '*/*/*'
exclude_dimension_hierarchy_attribute_value: ''
# Dimension Hierarchy Subset:
# Define a list of subsets to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter
# it further using the 'exclude' filter. Use * as a wildcard character anywhere. Filters can be defined as a single item,
# or as a list of items.
#
# Note: This supports only public subsets. It will work for both Dynamic and Static subsets.
#
# Format: <DimensionName>/<HierarchyName>/<SubsetName>
# Examples:
# - afLocation/afLocation/* -- include all subsets for afLocation dimension/hierarchy
# - */*/Level 0 -- include all subsets with name 'Level 0' for all dimensions/hierarchies
include_dimension_hierarchy_subset: ''
exclude_dimension_hierarchy_subset: ''
# Backup on migrate
# Configure these settings to set up running a TI process to perform a backup prior to doing migration
#
# Note: These parameters are only relevant in Interactive Mode and have no effect in Command Line mode
#
# backup_on_migrate: true/false -- default value to perform backup on migration
# backup_allow_override: true/false -- allow backup setting to be overridden
# backup_process: The name of the TI process that will be executed to perform the system backup
backup_on_migrate: false
backup_allow_override: false
backup_process: ''
# JSON or YAML -- recommended to use YAML as its human-readable
text_output_format: YAML
# File operations -- do not touch, currently unsupported
do_file_operations: false
file_to_blob_update_process: ''
include_file: ''
exclude_file: ''
```
## Usage
tm1cm has two different modes, Interactive and Command Line.
### Interactive Mode
Interactive mode allows you to pick and choose exactly what objects you would like to move between environments
To launch interactive mode, navigate in your terminal (or command prompt) to your application folder and run:
```
tm1cm
```
You will be presented with the tm1cm splash screen and a special (tm1cm) command prompt:
```
----------------------------------
TM1 Code Migrate
----------------------------------
Created By: Andrew Myers (me@ajmyers.net) -- https://www.linkedin.com/in/andrew-myers-3112248/
Homepage: https://github.com/ajmyers/tm1cm
Issues & Bugs: https://github.com/ajmyers/tm1cm/issues
-----------------------------------
Welcome to TM1 Code Migrate interactive!
(tm1cm) $
```
Use the 'help' command to see all possible commands
```
(tm1cm) $ help
```
use the 'ls apps' command to see all of the configurations you can migrate between
```
(tm1cm) $ ls apps
mytestapplication.local
mytestapplication.test
mytestapplication.prod
```
Begin a migration between two environments using 'migrate appfrom appto'
```
(tm1cm) $ migrate mytestapplication.test mytestapplication.prod
```
Once the migrate command completes, use the 'ls' command to see what operations are available.
NOTE: Operations that are NOT staged are in <span style="color:red">red</span>, whereas staged operations are in <span style="color:green">green</span>. By default, there are no staged operations
```
(tm1cm) $ ls
DELETE_PROCESS: ztemp ai check date
DELETE_SUBSET: afReclass_Index, afReclass_Index, Complete Reclasses
UPDATE_PROCESS: Actual.Call.Load Currency Rates
UPDATE_PROCESS: Actual.Data.Build Drill Table Query
UPDATE_PROCESS: Actual.Data.Load Actual Cash Data
UPDATE_PROCESS: Actual.Data.Load Actual Data
UPDATE_PROCESS: Actual.Data.Load from Ingestion
UPDATE_PROCESS: Actual.Data.Populate Drill Table
UPDATE_PROCESS: Actual.Data.Update Budget Rate Data
UPDATE_DIMENSION: afActualCash_Measure
UPDATE_HIERARCHY: afActualCash_Measure, afActualCash_Measure
UPDATE_CUBE: afActualCash
UPDATE_RULE: afActualCash
```
You can stage and unstage changes by using the 'add' and 'remove' commands. These commands support the use of wildcards in order to stage multiple changes with one command.
```
(tm1cm) $ add UPDATE_PROCESS: *
UPDATE_PROCESS: Actual.Call.Load Currency Rates
UPDATE_PROCESS: Actual.Data.Build Drill Table Query
UPDATE_PROCESS: Actual.Data.Load Actual Cash Data
UPDATE_PROCESS: Actual.Data.Load Actual Data
UPDATE_PROCESS: Actual.Data.Load from Ingestion
UPDATE_PROCESS: Actual.Data.Populate Drill Table
UPDATE_PROCESS: Actual.Data.Update Budget Rate Data
```
```
(tm1cm) $ remove UPDATE_PROCESS: Actual.Data.Load Actual Cash Data
```
Use the 'ls stage' command to view the list of staged changes.
Use the 'ls' command to view all operations.
Use the 'do' command to perform the staged operations.
```
(tm1cm) $ do
Perform STAGED operations? (7/104)
[y/n]? y
Doing: UPDATE_PROCESS: Actual.Call.Load Currency Rates
Doing: UPDATE_PROCESS: Actual.Data.Build Drill Table Query
Doing: UPDATE_PROCESS: Actual.Data.Load Actual Data
Doing: UPDATE_PROCESS: Actual.Data.Load from Ingestion
Doing: UPDATE_PROCESS: Actual.Data.Populate Drill Table
Doing: UPDATE_PROCESS: Actual.Data.Update Budget Rate Data
```
### Command Line
Command line mode is useful for automating migrations. There are two modes. 'get' and 'put'
Generally, you would run the 'get' command against your test environment, and then run the 'put' command against your prod environment.
You can also use this functionality along with git version control systems and tools like Stash to do code reviews.
#### GET
This will connect to the test environment for mytestapplication, and take all of the TM1 model objects and write them to your local disk.
From your terminal, run the command:
```
tm1cm --mode get --environment test
```
#### PUT
This will connect to the test environment for mytestapplication, and update all of the model objets with the definition stored on the local computer
From your terminal, run the command:
```
tm1cm --mode put --environment prod
```
## Contributing
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
## License
[GNU General Public License v3.0](https://choosealicense.com/licenses/gpl-3.0/)
Raw data
{
"_id": null,
"home_page": "https://github.com/ajmyers/tm1cm",
"name": "tm1cm",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.7, <4",
"maintainer_email": "",
"keywords": "tm1,planning analytics,ibm,pa,olap,cube",
"author": "Andrew Myers",
"author_email": "me@ajmyers.net",
"download_url": "https://files.pythonhosted.org/packages/7a/42/4a7674ec821eb12c1882877b3cda7af5c134c49b1d5dd371e95a1ee19bc9/tm1cm-0.9.5.tar.gz",
"platform": null,
"description": "# TM1 Code Migrate\n\ntm1cm is a utility for moving TM1 Planning Analytics objects between TM1 applications, or your local file system. It can be used to manage the software development lifecycle of a TM1 application.\n\n## Installation\n\nUse the package manager [pip](https://pip.pypa.io/en/stable/) to install tm1cm.\n\n```bash\npip install tm1cm\n```\n\n## Setup\n\nFirst things first, you must 'scaffold' a new TM1 application on your local system, and then update settings.\n\n```bash\ntm1cm --mode scaffold --path ./mytm1application\n```\n\nThis command will create the folder structure expected by the tm1cm utility\n\n```text\nmytestapplication/\n config/ \n default/\n connect.yaml\n credentials.yaml\n tm1cm.yaml\n test/\n staging/\n prod/\n data/\n files/\n scripts/\n```\n\nUnder the 'config' directory, modify the folders (ignoring 'default' folder) for any environments (i.e test/staging/prod). Remove any that you won't use.\n\n### Update connect.yaml\n\nCopy connect.yaml from the default/ folder into each of the environment subfolders.\n\nUpdate each connect.yaml file to contain the connection parameters for your TM1 application. You must be able to access the REST API endpoint of your TM1 application. For on-prem TM1 applications, this may look like:\n\n```yaml\nbase_url: https://myonpremapplication:10000\n```\n\nIf you are using the IBM Cloud, your connect.yaml may look like\n\n```yaml\nbase_url: https://mycompany.planning-analytics.ibmcloud.com:443/tm1/api/tm1\n```\n\n### Update credentials.yaml\n\nIf your credentials are the same in all environments, you can update credentials.yaml within the default/ directory\n\nIf your credentials are different across each environment, copy credentials.yaml into each environment subfolder (as with connect.yaml) and update your credentials for each environment\n\n```yaml\nnamespace: LDAP\nuser: mysecureusername\npassword: mysecurepassword\n```\n\n**NOTE:** If you are using IBM Cloud, You must use an automation user that was included in the IBM Cloud Welcome Back. It is not possible to connect to use tm1cm with your IBM ID\n\n### Update tm1cm.yaml\n\ntm1cm.yaml is the primary configuration file that determines what objects SHOULD and SHOULD NOT be included in migrations.\n\nBecause some parts of TM1 applications are generally dynamic, you may not want to include every single TM1 hierarchy, subset, dimension, etc in your tm1cm configuration.\n\nAt runtime, the model is passed through a series of filters that are defined below. You can define one or many filters for each type of object. The yaml config is fairly flexible. You can be fairly selective about what you migrate.\n\n```yaml\n# Turbo Integrator Processes:\n# Define a list of TI processes to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter\n# it further using the 'exclude' filter. Use * as a wildcard character anywhere within the cube name\n# Filters can be defined as a single item, or as a list of items.\n#\n# Format: <ProcessName>\n# Examples:\n# - Actual.Call.* -- include all processes that start with Actual.Call\n# - * -- include all processes\n\ninclude_process: '*'\nexclude_process:\n - '}tp*'\n\n# This will apply standard case/indentation/formatting for TI Processes\nautoformat_ti_process: true\n\n# Cubes:\n# Define a list of cubes to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter\n# it further using the 'exclude' filter. Use * as a wildcard character anywhere within the cube name\n# Filters can be defined as a single item, or as a list of items.\n#\n# Format: <CubeName>\n# Example: }ClientGroups\n\ninclude_cube: '*'\nexclude_cube:\n - '}ClientCAMAssociatedGroups'\n - '}ClientProperties'\n - '}ClientSettings'\n - '}ElementProperties*'\n - '}HierarchyProperties'\n - '}Stats*'\n - '}Hold*'\n - '}CubeProperties'\n - '}DimensionProperties'\n - '}ElementAttributes_}*'\n - '}ElementAttributes_}Clients'\n - '}Capabilities'\n - '}CubeSecurityProperties'\n - '}PickList*'\n - '*}tp*'\n - '}CellAnnotations*'\n\n# Rules:\n# Define a list of cube rules to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter\n# it further using the 'exclude' filter. Use * as a wildcard character anywhere within the cube name\n# Filters can be defined as a single item, or as a list of items.\n#\n# Format: <CubeName>\n# Example: }ClientGroups\n\ninclude_rule: '*'\nexclude_rule: ''\n\n# Cube Views:\n# Define a list of cubes views to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter\n# it further using the 'exclude' filter. Use * as a wildcard character anywhere within the cube name\n# Filters can be defined as a single item, or as a list of items.\n#\n# Note: This only includes the view definition, it does not include any data. It is recommended that any subsets included\n# in the view definition also be included using 'include_dimension_hierarchy_subset' otherwise the migration will fail\n#\n# Note: Only public views are supported\n#\n# Format: <CubeName>/<ViewName>\n# Examples:\n# - afReporting/Default -- include the 'Default' view for 'afReporting' cube\n# - */Default -- Match the 'Default' view for all cubes\n# - afReporting/* -- Match all views for afReporting cube\n\ninclude_cube_view: ''\nexclude_cube_view: ''\n\n# Cube View Data:\n# Define a list of cube view data to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter\n# it further using the 'exclude' filter. Use * as a wildcard character anywhere within the cube name\n# Filters can be defined as a single item, or as a list of items.\n#\n# Note: This is generally intended for moving smaller sets of data, like control cube values. It is not intended for moving large\n# data sets.\n#\n# Note: Only public views are supported. It's recommended to disable zero suppression on the view otherwise stale data may\n# be left behind on the target\n#\n# Format: <CubeName>/<ViewName>\n# Examples:\n# - afReporting/Default -- include the 'Default' view data for 'afReporting' cube\n# - */Default -- Match the 'Default' view data for all cubes\n# - afReporting/* -- Match all view data for afReporting cube\n\ninclude_cube_view_data: ''\nexclude_cube_view_data: ''\n\n# Dimensions:\n# Define a list of dimensionss to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter\n# it further using the 'exclude' filter. Use * as a wildcard character anywhere. Filters can be defined as a single item, \n# or as a list of items.\n# \n# Note: A 'dimension' is only a container of hierarchies. You must also configure 'include_dimension_hierarchy' \n#\n# Note: Only public views are supported. It's recommended to disable zero suppression on the view otherwise stale data may\n# be left behind on the target\n#\n# Format: <DimensionName>\n# Examples:\n# - af* -- include all dimensions starting with af\n# - *_Measure -- include all dimensions that end with _Measure\n\ninclude_dimension: '*'\nexclude_dimension:\n - '}Stats*'\n - '}Hierarchies*'\n - '}ApplicationEntries'\n - '}CAMAssociatedGroups'\n - '}Chores'\n - '}Client*'\n - '}Connection*'\n - '}Cube Functions'\n - '}CubeProperties'\n - '}CubeSecurityProperties'\n - '}Cubes'\n - '}Cultures'\n - '}DimensionFormatAttributes'\n - '}DimensionFormatItems'\n - '}DimensionProperties'\n - '}ElementAttributes_}*'\n - '}ElementProperties'\n - '}Features'\n - '}Groups'\n - '}PickList'\n - '}Processes'\n - '}RuleStats'\n - '}Subsets*'\n - '}Views*'\n - '}*'\n - 'Sandboxes'\n\n# Dimension Hierarchy:\n# Define a list of dimension hierarchies to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter\n# it further using the 'exclude' filter. Use * as a wildcard character anywhere. Filters can be defined as a single item,\n# or as a list of items.\n#\n# Note: This will manage the migration of hierarchies, but will not explicitly include the elements of a hierarchy. In order to configure\n# including/excluding a hierarchies elements, see 'include_dimension_hierarchy_element'\n#\n# Format: <DimensionName>/<HierarchyName>\n# Examples:\n# - afLocation/afLocation -- Include only the primary hierarchy for dimension afLocation\n# - afLocation/* -- include all hierarchies for dimension afLocation\n\ninclude_dimension_hierarchy: '*/*'\nexclude_dimension_hierarchy:\n - '}*/*'\n - '*/Leaves'\n\n# Dimension Hierarchy Elements:\n# Define a list of dimension hierarchy elements to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter\n# it further using the 'exclude' filter. Use * as a wildcard character anywhere. Filters can be defined as a single item,\n# or as a list of items.\n#\n# Note: It is not recommended to include elements for hierarchies that are managed from other data sources (like upstream ERP)\n#\n# Format: <DimensionName>/<HierarchyName>\n# Examples:\n# - afLocation/afLocation -- Include only the primary hierarchy elements for dimension afLocation\n# - afLocation/* -- include all hierarchy elements for dimension afLocation\n\ninclude_dimension_hierarchy_element: '*/*'\nexclude_dimension_hierarchy_element: ''\n\n# Dimension Hierarchy Attributes:\n# Define a list of dimension hierarchy attributes to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter\n# it further using the 'exclude' filter. Use * as a wildcard character anywhere. Filters can be defined as a single item,\n# or as a list of items.\n#\n# Note: This will only manage attributes themselves, it will not populate attribute values. In order to do that, see the\n# include_dimension_hierarchy_attribute_value\n#\n# Format: <DimensionName>/<HierarchyName>/<AttributeName>\n# Examples:\n# - afLocation/afLocation/* -- include all attributes for afLocation dimension/hierarchy\n# - afLocation/*/Name -- include 'Name' attribute for all hierarchies of afLocation\n# - */*/Name -- include 'Name' attribute for all hierarchies of all dimensions\n\ninclude_dimension_hierarchy_attribute: '*/*/*'\nexclude_dimension_hierarchy_attribute: '*/*/}SYS*'\n\n# Dimension Hierarchy Attribute Values:\n# Define a list of dimension hierarchy attributes values to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter\n# it further using the 'exclude' filter. Use * as a wildcard character anywhere. Filters can be defined as a single item,\n# or as a list of items.\n#\n# Note: This will, for any included elements, manage the attribute values for each element.\n#\n# Format: <DimensionName>/<HierarchyName>/<AttributeName>\n# Examples:\n# - afLocation/afLocation/* -- include all attribute values for afLocation dimension/hierarchy\n# - afLocation/*/Name -- include 'Name' attribute values for all hierarchies of afLocation\n# - */*/Name -- include 'Name' attribute values for all hierarchies of all dimensions\n\ninclude_dimension_hierarchy_attribute_value: '*/*/*'\nexclude_dimension_hierarchy_attribute_value: ''\n\n# Dimension Hierarchy Subset:\n# Define a list of subsets to include, and then exclude from tm1cm. Build a list using the 'include' filter, then filter\n# it further using the 'exclude' filter. Use * as a wildcard character anywhere. Filters can be defined as a single item,\n# or as a list of items.\n#\n# Note: This supports only public subsets. It will work for both Dynamic and Static subsets.\n#\n# Format: <DimensionName>/<HierarchyName>/<SubsetName>\n# Examples:\n# - afLocation/afLocation/* -- include all subsets for afLocation dimension/hierarchy\n# - */*/Level 0 -- include all subsets with name 'Level 0' for all dimensions/hierarchies\n\ninclude_dimension_hierarchy_subset: ''\nexclude_dimension_hierarchy_subset: ''\n\n# Backup on migrate\n# Configure these settings to set up running a TI process to perform a backup prior to doing migration\n#\n# Note: These parameters are only relevant in Interactive Mode and have no effect in Command Line mode\n#\n# backup_on_migrate: true/false -- default value to perform backup on migration\n# backup_allow_override: true/false -- allow backup setting to be overridden\n# backup_process: The name of the TI process that will be executed to perform the system backup\n\nbackup_on_migrate: false\nbackup_allow_override: false\nbackup_process: ''\n\n# JSON or YAML -- recommended to use YAML as its human-readable\ntext_output_format: YAML\n\n# File operations -- do not touch, currently unsupported\ndo_file_operations: false\nfile_to_blob_update_process: ''\ninclude_file: ''\nexclude_file: ''\n```\n\n## Usage\n\ntm1cm has two different modes, Interactive and Command Line.\n\n### Interactive Mode\n\nInteractive mode allows you to pick and choose exactly what objects you would like to move between environments\n\nTo launch interactive mode, navigate in your terminal (or command prompt) to your application folder and run:\n\n```\ntm1cm\n```\n\nYou will be presented with the tm1cm splash screen and a special (tm1cm) command prompt:\n\n```\n----------------------------------\nTM1 Code Migrate\n---------------------------------- \n Created By: Andrew Myers (me@ajmyers.net) -- https://www.linkedin.com/in/andrew-myers-3112248/\n Homepage: https://github.com/ajmyers/tm1cm\n Issues & Bugs: https://github.com/ajmyers/tm1cm/issues\n-----------------------------------\n\nWelcome to TM1 Code Migrate interactive!\n\n(tm1cm) $ \n```\n\nUse the 'help' command to see all possible commands\n\n```\n(tm1cm) $ help\n```\n\nuse the 'ls apps' command to see all of the configurations you can migrate between\n\n```\n(tm1cm) $ ls apps\nmytestapplication.local\nmytestapplication.test\nmytestapplication.prod\n```\n\nBegin a migration between two environments using 'migrate appfrom appto'\n\n```\n(tm1cm) $ migrate mytestapplication.test mytestapplication.prod\n```\n\nOnce the migrate command completes, use the 'ls' command to see what operations are available.\n\nNOTE: Operations that are NOT staged are in <span style=\"color:red\">red</span>, whereas staged operations are in <span style=\"color:green\">green</span>. By default, there are no staged operations\n\n```\n(tm1cm) $ ls\nDELETE_PROCESS: ztemp ai check date\nDELETE_SUBSET: afReclass_Index, afReclass_Index, Complete Reclasses\nUPDATE_PROCESS: Actual.Call.Load Currency Rates\nUPDATE_PROCESS: Actual.Data.Build Drill Table Query\nUPDATE_PROCESS: Actual.Data.Load Actual Cash Data\nUPDATE_PROCESS: Actual.Data.Load Actual Data\nUPDATE_PROCESS: Actual.Data.Load from Ingestion\nUPDATE_PROCESS: Actual.Data.Populate Drill Table\nUPDATE_PROCESS: Actual.Data.Update Budget Rate Data\nUPDATE_DIMENSION: afActualCash_Measure\nUPDATE_HIERARCHY: afActualCash_Measure, afActualCash_Measure\nUPDATE_CUBE: afActualCash\nUPDATE_RULE: afActualCash\n```\n\nYou can stage and unstage changes by using the 'add' and 'remove' commands. These commands support the use of wildcards in order to stage multiple changes with one command.\n\n```\n(tm1cm) $ add UPDATE_PROCESS: *\nUPDATE_PROCESS: Actual.Call.Load Currency Rates\nUPDATE_PROCESS: Actual.Data.Build Drill Table Query\nUPDATE_PROCESS: Actual.Data.Load Actual Cash Data\nUPDATE_PROCESS: Actual.Data.Load Actual Data\nUPDATE_PROCESS: Actual.Data.Load from Ingestion\nUPDATE_PROCESS: Actual.Data.Populate Drill Table\nUPDATE_PROCESS: Actual.Data.Update Budget Rate Data\n```\n\n```\n(tm1cm) $ remove UPDATE_PROCESS: Actual.Data.Load Actual Cash Data \n```\n\nUse the 'ls stage' command to view the list of staged changes.\n\nUse the 'ls' command to view all operations.\n\nUse the 'do' command to perform the staged operations.\n\n```\n(tm1cm) $ do\nPerform STAGED operations? (7/104)\n[y/n]? y\nDoing: UPDATE_PROCESS: Actual.Call.Load Currency Rates\nDoing: UPDATE_PROCESS: Actual.Data.Build Drill Table Query\nDoing: UPDATE_PROCESS: Actual.Data.Load Actual Data\nDoing: UPDATE_PROCESS: Actual.Data.Load from Ingestion\nDoing: UPDATE_PROCESS: Actual.Data.Populate Drill Table\nDoing: UPDATE_PROCESS: Actual.Data.Update Budget Rate Data\n```\n\n### Command Line\n\nCommand line mode is useful for automating migrations. There are two modes. 'get' and 'put'\n\nGenerally, you would run the 'get' command against your test environment, and then run the 'put' command against your prod environment.\n\nYou can also use this functionality along with git version control systems and tools like Stash to do code reviews.\n\n#### GET\n\nThis will connect to the test environment for mytestapplication, and take all of the TM1 model objects and write them to your local disk.\n\nFrom your terminal, run the command:\n\n```\ntm1cm --mode get --environment test\n```\n\n#### PUT\n\nThis will connect to the test environment for mytestapplication, and update all of the model objets with the definition stored on the local computer\n\nFrom your terminal, run the command:\n\n```\ntm1cm --mode put --environment prod\n```\n\n## Contributing\n\nPull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.\n\n## License\n\n[GNU General Public License v3.0](https://choosealicense.com/licenses/gpl-3.0/)\n\n",
"bugtrack_url": null,
"license": "",
"summary": "A model migration library for TM1 Planning Analytics",
"version": "0.9.5",
"project_urls": {
"Bug Reports": "https://github.com/ajmyers/tm1cm/issues",
"Homepage": "https://github.com/ajmyers/tm1cm",
"Source": "https://github.com/ajmyers/tm1cm"
},
"split_keywords": [
"tm1",
"planning analytics",
"ibm",
"pa",
"olap",
"cube"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "e3ac81877c1f1aebd38073be22ecaeaaefcaf25af6cc2ee4a289d8e7dd9c7ac7",
"md5": "45aae86f483821fa14293d25d24ca9e3",
"sha256": "ea497cb6ca74e74de5b05c2ebdf9122374bc6a76d4b340845ca4067711999e41"
},
"downloads": -1,
"filename": "tm1cm-0.9.5-py3-none-any.whl",
"has_sig": false,
"md5_digest": "45aae86f483821fa14293d25d24ca9e3",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.7, <4",
"size": 41742,
"upload_time": "2024-02-06T17:27:12",
"upload_time_iso_8601": "2024-02-06T17:27:12.269014Z",
"url": "https://files.pythonhosted.org/packages/e3/ac/81877c1f1aebd38073be22ecaeaaefcaf25af6cc2ee4a289d8e7dd9c7ac7/tm1cm-0.9.5-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "7a424a7674ec821eb12c1882877b3cda7af5c134c49b1d5dd371e95a1ee19bc9",
"md5": "c285fafdf555318ff3bab5881812f412",
"sha256": "9872fadad9706a898f3aeb21f0fbbac88c5e5a0385d12d019f29c3e3e0d3a54c"
},
"downloads": -1,
"filename": "tm1cm-0.9.5.tar.gz",
"has_sig": false,
"md5_digest": "c285fafdf555318ff3bab5881812f412",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.7, <4",
"size": 44032,
"upload_time": "2024-02-06T17:27:19",
"upload_time_iso_8601": "2024-02-06T17:27:19.605905Z",
"url": "https://files.pythonhosted.org/packages/7a/42/4a7674ec821eb12c1882877b3cda7af5c134c49b1d5dd371e95a1ee19bc9/tm1cm-0.9.5.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-02-06 17:27:19",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "ajmyers",
"github_project": "tm1cm",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"tox": true,
"lcname": "tm1cm"
}
JSON
