TI to add element to existing DIM from flat file

Post Reply
Tquest
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

Post by Tquest »

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
Last edited by Tquest on Tue Jun 17, 2014 1:07 pm, edited 1 time in total.
tomok
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

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
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

Post by jim wood »

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
Tquest
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

Post by Tquest »

Thanks for your response.

I did get it to work.
Tquest
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

Post by Tquest »

Thanks Jim thats much appreciated.
Post Reply