Loading metdata changes via MDS to TM1

Post Reply
Nidhik
Posts: 2
Joined: Thu Jun 20, 2019 1:08 am
OLAP Product: TM1
Version: 2.0.37
Excel Version: 365

Loading metdata changes via MDS to TM1

Post by Nidhik » Mon Jun 24, 2019 3:34 pm

Hi, Our business uses MDS to update three Center dimensions used in TM1. We have several hierarchy center dimension changes that I wanted to find out if there is an automated way to update in MDS rather than manual one at a time like adding base level centers and nodes. Any guidance is appreciated.

Thanks,
Nidhi

tomok
MVP
Posts: 2561
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: Loading metdata changes via MDS to TM1

Post by tomok » Mon Jun 24, 2019 4:28 pm

Nidhik wrote:
Mon Jun 24, 2019 3:34 pm
Hi, Our business uses MDS to update three Center dimensions used in TM1. We have several hierarchy center dimension changes that I wanted to find out if there is an automated way to update in MDS rather than manual one at a time like adding base level centers and nodes. Any guidance is appreciated.

Thanks,
Nidhi
Yes, there is a tool for that in TM1. It's called Turbointegrator. You can write a TI process that reads from the MDS tables and updates the dimension(s) in question. I suggest you read the TI manual to gain an understanding of how to write a process that will update a dimension and it's hierarchies.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Nidhik
Posts: 2
Joined: Thu Jun 20, 2019 1:08 am
OLAP Product: TM1
Version: 2.0.37
Excel Version: 365

Re: Loading metdata changes via MDS to TM1

Post by Nidhik » Tue Jun 25, 2019 2:00 pm

Thankyou. We have TI process to integrate between MDS and TM1 already in place. My question was more for MDS- when we have mass "Center" dimension changes- new adds, movements, new rollups, is there an automated way to load in MDS instead of manually updating each change?

Bakkone
Posts: 94
Joined: Mon Oct 27, 2014 10:50 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Loading metdata changes via MDS to TM1

Post by Bakkone » Tue Jun 25, 2019 2:15 pm

Yes, if its Microsoft MDS you are talking about its all in the manual:

https://docs.microsoft.com/en-us/sql/ma ... erver-2017

Which method to use will depend totally upon your architecture in your DW. You can probably find a guide on some SQL forum. But basically you want to to a bulk load into the entity staging tables. Your DBA will know how to fix it.

Post Reply