Managing TM1 database assets with Git

Post Reply
Nitrel
Posts: 19
Joined: Fri Oct 08, 2010 9:40 pm
OLAP Product: TM1
Version: all Versions
Excel Version: all Versions

Managing TM1 database assets with Git

Post by Nitrel »

Hello Community,

i am searching "RedBook" or "BestPractise" or any deepdive-samples how we can use GIT (BitBucket) and TM1 (Planning Analystics)
Is there any experiance around?

Chris
Paul Segal
Community Contributor
Posts: 306
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: TM1 11 and up
Excel Version: Too many to count

Re: Managing TM1 database assets with Git

Post by Paul Segal »

You could do a lot worse than start here: https://ykud.com/blog/cognos/tm1-cognos ... tm1-part-1
Paul
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Managing TM1 database assets with Git

Post by macsir »

After several testing with Bitbucket, I don't think PA is mature enough to integrated with Git at this stage (We are on PA 2.0.8).
With those documents from IBM, you will find yourself struggling with the syntax of tm1project file eventually. Yes, it can do a few things with Git but very hard to use. :?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
ykud
MVP
Posts: 148
Joined: Sat Jan 10, 2009 10:52 am
Contact:

Re: Managing TM1 database assets with Git

Post by ykud »

macsir wrote: Tue May 12, 2020 10:26 pm With those documents from IBM, you will find yourself struggling with the syntax of tm1project file eventually. Yes, it can do a few things with Git but very hard to use. :?
Do you mind sharing what in tm1project file was confusing?

I agree it's very far from intuitive, it's more of an API to build future tools on, but I still think it's quite useful even in the current shape.
Maybe it's the case when of having more examples out there might help, especially for tm1project?

Y
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Managing TM1 database assets with Git

Post by macsir »

Hi, ykud
Yes, I agree with the point that it is an API which some tools can build on. But the questions I have so far are
1. How to use Objects section in tm1project file rather than use Ignore section all the time to include/exclude objects?
2. How to use Pre/PostPull, Pre/PostPush, Dependencies/Preconditions and Links? The examples in IBM document are very raw and hard to understand.
3. Is it possible to hot promote cube data files via this method? I can push/pull the data files but looks like I have to reboot the tm1 server to get data file loaded.

Overall, I don't see any detailed examples from IBM apart from some detailed articles from other developers.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
luizg2019
Posts: 41
Joined: Thu Sep 12, 2019 11:02 pm
OLAP Product: TM1 - PAX-PAW-Perspectiv-Arc
Version: PA 2.0.9 - PAW 2.0.73
Excel Version: office 2016

Re: Managing TM1 database assets with Git

Post by luizg2019 »

macsir wrote: Wed May 13, 2020 4:49 am 3. Is it possible to hot promote cube data files via this method? I can push/pull the data files but looks like I have to reboot the tm1 server to get data file loaded.

Overall, I don't see any detailed examples from IBM apart from some detailed articles from other developers.
I agree with you that the documentation is very lacking and those examples leave you more confused than they explain how to use it.

And answering #3 the official answer from IBM support is NO, manually including the .cub files in the "files" section in tm1project and then doing a server reboot after a GitPull is not recomended by IBM, that's what they told me when I opened a support ticket. Also If we have .cub files over 100MB it won't upload to free git servers like github for example.
So we have to create a process that loads the attribute values from a file somewhere. One more thing to version and ensure that the file is updated with the latest values. Very disappointing. :x

Also, github is deactivating the basic auth that the tm1git uses to connect to their server in august 2021. Now they'll only accept tokens or SSH Key authentication, but tm1git doesn't have support for that!
User avatar
ykud
MVP
Posts: 148
Joined: Sat Jan 10, 2009 10:52 am
Contact:

Re: Managing TM1 database assets with Git

Post by ykud »

luizg2019 wrote: Fri May 21, 2021 1:40 pm Also, github is deactivating the basic auth that the tm1git uses to connect to their server in august 2021. Now they'll only accept tokens or SSH Key authentication, but tm1git doesn't have support for that!
SSH is supported : https://www.ibm.com/docs/en/planning-an ... ntegration
luizg2019
Posts: 41
Joined: Thu Sep 12, 2019 11:02 pm
OLAP Product: TM1 - PAX-PAW-Perspectiv-Arc
Version: PA 2.0.9 - PAW 2.0.73
Excel Version: office 2016

Re: Managing TM1 database assets with Git

Post by luizg2019 »

ykud wrote: Fri May 21, 2021 7:37 pm
luizg2019 wrote: Fri May 21, 2021 1:40 pm Also, github is deactivating the basic auth that the tm1git uses to connect to their server in august 2021. Now they'll only accept tokens or SSH Key authentication, but tm1git doesn't have support for that!
SSH is supported : https://www.ibm.com/docs/en/planning-an ... ntegration
oops my bad :oops:

Thank you!
marko_p
Posts: 3
Joined: Fri Oct 01, 2021 12:10 pm
OLAP Product: TM1
Version: 2.0.7.
Excel Version: Excel 2016

Re: Managing TM1 database assets with Git

Post by marko_p »

Hi,
did you manage to connect to Github via SSH?

I get response:
"error": {
"code": "278",
"message": "Invalid parameter in payload \"PublicKey\". GitInit failed."
}
And I followed instructions from IBM pages:

{
"URL":"git@github.com:username/repository.git",
"Deployment":"main",
"PublicKey" : "ssh-ed25519 xxx",
"PrivateKey" : "-----BEGIN OPENSSH PRIVATE KEY-----xxx-----END OPENSSH PRIVATE KEY-----",
"Passphrase" : ""
}
User avatar
ykud
MVP
Posts: 148
Joined: Sat Jan 10, 2009 10:52 am
Contact:

Re: Managing TM1 database assets with Git

Post by ykud »

marko_p wrote: Tue Oct 05, 2021 9:55 am Hi,
did you manage to connect to Github via SSH?
Yep, works for me, but you need the 2.9.0.4 or later ( https://www.ibm.com/docs/en/planning-an ... er-17-2020 )
User avatar
scrumthing
Posts: 81
Joined: Tue Jan 26, 2016 4:18 pm
OLAP Product: TM1
Version: 11.x
Excel Version: MS365

Re: Managing TM1 database assets with Git

Post by scrumthing »

Works for us as well. Unfortunately it is only possible to use ssh for all users or for none. That is a bit annoying.
There is no OLAP database besides TM1!
bobgillvan
Posts: 3
Joined: Tue May 24, 2022 9:14 pm
OLAP Product: TM1
Version: PA 2.0.9
Excel Version: 365

Re: Managing TM1 database assets with Git

Post by bobgillvan »

I've been messing around with GitHub and PA Cloud and it seems to be working well. I did a video to help share what I did to make it work.

https://www.youtube.com/watch?v=9XT9ALcKf4k
andreykadysh
Posts: 18
Joined: Fri Aug 27, 2021 5:41 pm
OLAP Product: IBM Cognos Planning Analytics
Version: 2.0.9.19
Excel Version: 2016

Re: Managing TM1 database assets with Git

Post by andreykadysh »

Hi, folks!

I'm diving into tm1 git integration and implementation of ci cd concept to tm1 development.
Just have read discussions here, but they seems to be a bit outdated. Since then some things happened, e.g. PAW 2.0.92 released.
I want to revive this discussion and aggregate here more useful links and tm1git related info.

I've got familiar with materials from links below and tested it on my environment (PAW 2.0.92 on linux, PA 2.0.9.19 on windows server 2019).
And want to say big THANKS to all who made this instructions and demos!

Yuri Kudryavcev's topics on doing this via REST API calls:
https://www.ykud.com/blog/cognos/tm1-co ... m1-part-1/
https://www.ykud.com/blog/cognos/tm1-co ... m1-part-2/
https://www.ykud.com/blog/tm1-git-challenges/

Bob Gillvan's videos on REST API and new PAW feature:
https://www.youtube.com/@robsonmedia9499

Stuart King's explanation of pre/post push/pull feature and its usage.
https://www.youtube.com/watch?v=TjDKiPS ... x=2&t=316s

Cubewise technote about TM1Project and overall approach:
https://cubewise-code.github.io/tm1py-t ... oject.html

But for me there is still no clear and precise picture how to manage branches and organise continuous ci cd.

It would be great if you share your experience of using git with tm1, your approaches to ci cd workflow, branches managing, prod deployment, etc...

Examples of your own git implementations (without REST API Git feature) would be great too!

Or everybody just give up this and use stop\copy\start approach or hot promotion via reading the code & patching it?
Post Reply