HI,
I am fairly new to TI processes and i am struggling to get a TI process together to add new element to and existing Dim based on a load file.
So i have a Product Dim and every month a flat file is generated to load into TM1.
I wanted to get a TI process that checks the Product Code in the flat file and compare that to the Dimension and if there is a new product on the file that's not in the Dim, The TI to add the new product to the Dimension before the load takes place.
Can you help please.
Many thanks
Tquest
TI to add element to existing DIM from flat file
-
- Posts: 3
- Joined: Thu Mar 20, 2014 4:25 pm
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
TI to add element to existing DIM from flat file
Last edited by Tquest on Tue Jun 17, 2014 1:07 pm, edited 1 time in total.
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: TI to add element to existing DIM from flat file
This is probably the simplest TI process you can write. There are plenty of examples in the manual. Why don't you actually give it a try and then come back with specific questions instead of asking someone here to write it for you.
- jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: TI to add element to existing DIM from flat file
There also many blogs and resources like Bedrock available that will help you expand your knowledge.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 3
- Joined: Thu Mar 20, 2014 4:25 pm
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: TI to add element to existing DIM from flat file
Thanks for your response.
I did get it to work.
I did get it to work.
-
- Posts: 3
- Joined: Thu Mar 20, 2014 4:25 pm
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: TI to add element to existing DIM from flat file
Thanks Jim thats much appreciated.