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
Loading metdata changes via MDS to TM1
-
- MVP
- Posts: 2831
- 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
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.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
-
- Posts: 5
- 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
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?
-
- Posts: 119
- 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
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.
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.