Devops in PA/TM1

Post Reply
prushbalaji
Posts: 2
Joined: Sun Nov 24, 2019 1:36 pm
OLAP Product: IBM Planning Analytics
Version: 2.8.6
Excel Version: Office 365

Devops in PA/TM1

Post by prushbalaji » Mon Nov 25, 2019 5:27 pm

Any devops tool can be leveraged to do the operational activities such deployment/logfile movement / Data validation /Server monitoring in TM1/Planning analytics ??

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

Re: Devops in PA/TM1

Post by Bakkone » Tue Nov 26, 2019 11:25 am

Notepad++ is great... I also write my TI-processes in Architect.

prushbalaji
Posts: 2
Joined: Sun Nov 24, 2019 1:36 pm
OLAP Product: IBM Planning Analytics
Version: 2.8.6
Excel Version: Office 365

Re: Devops in PA/TM1

Post by prushbalaji » Wed Nov 27, 2019 10:16 am

Hi thanks for your response . Can you please let me know what are all the activities you are performing through Notepad++

lotsaram
MVP
Posts: 3325
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Devops in PA/TM1

Post by lotsaram » Wed Nov 27, 2019 2:07 pm

I rather think that Bakkone was pulling your leg. :roll:
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

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

Re: Devops in PA/TM1

Post by Bakkone » Mon Dec 02, 2019 6:03 pm

Devops is not about tools. Devops is about processes.

Part of my development process is looking in log files. I use notepad++ for that.

luizg2019
Posts: 14
Joined: Thu Sep 12, 2019 11:02 pm
OLAP Product: TM1 - PAW & Architect
Version: PA 2.0.7 - PAW 2.0.44
Excel Version: office 2016

Re: Devops in PA/TM1

Post by luizg2019 » Mon Dec 02, 2019 6:25 pm

prushbalaji wrote:
Mon Nov 25, 2019 5:27 pm
Any devops tool can be leveraged to do the operational activities such deployment/logfile movement / Data validation /Server monitoring in TM1/Planning analytics ??
Deployment: Managing TM1 database assets with Git

Server monitoring: If you're talking about RAM, CPU, etc, P.A.Workspace has a nice monitoring feature. Or if you want more detailed data you should use Performance Monitor

PlanningDev
Community Contributor
Posts: 340
Joined: Tue Aug 17, 2010 6:31 am
OLAP Product: Planning Analytics
Version: 2.0.5
Excel Version: 2016

Re: Devops in PA/TM1

Post by PlanningDev » Tue Dec 03, 2019 9:51 pm

Searching log files - Notepad++ and FileSeek (FileSeek is amazing as you can search the transaction logs and filter for keywords, by modified dates, etc.

Dev Lifecycle - JIRA and for a lite version of code compare you can use BitBucket/Fisheye although I wouldn't reccommend using for direct deployment
(As posted above, the GIT integration is new but could be interesting)

Deployment - TM1 REST API, we have tools to search for text in TI processes, deploy objects live, etc. Take a look at Postman, Cubewise has a blog about it

EvgenyT
Community Contributor
Posts: 277
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: Cognos TM 1
Version: 10.2.2
Excel Version: 2013
Location: Sydney, Australia

Re: Devops in PA/TM1

Post by EvgenyT » Wed Dec 04, 2019 9:55 am

Although not free, Pulse (by Cubewise) has all monitoring, deployment and change control tools you need.
Also, their Arc product is good for writing code (snippets, auto-indent etc).

Likewise, I used Rest API for hot promotion, although not extensively. Furthermore, I have got a few PowerShell scrips I use for regular model maintenance. There are also some Python libraries that can be used.

P.s. Not paid advertisement :)

Thanks

Evgeny

MGrain
Posts: 15
Joined: Wed Nov 15, 2017 11:36 am
OLAP Product: TM1
Version: Various
Excel Version: Various

Re: Devops in PA/TM1

Post by MGrain » Wed Dec 04, 2019 11:25 am

I recently discovered BareTail https://www.baremetalsoft.com/baretail/

Very useful for looking at log files on a running TM1 instance.

kaazimraza
Posts: 90
Joined: Mon Jun 25, 2012 6:58 am
OLAP Product: TM1, SSAS, Power BI
Version: 10.2.2
Excel Version: 2016

Re: Devops in PA/TM1

Post by kaazimraza » Sun Dec 08, 2019 9:00 am

EvgenyT wrote:
Wed Dec 04, 2019 9:55 am
Although not free, Pulse (by Cubewise) has all monitoring, deployment and change control tools you need.
Also, their Arc product is good for writing code (snippets, auto-indent etc).

Likewise, I used Rest API for hot promotion, although not extensively. Furthermore, I have got a few PowerShell scrips I use for regular model maintenance. There are also some Python libraries that can be used.

P.s. Not paid advertisement :)

Thanks

Evgeny
Are you able to share the code for hot promotion? I have been trying to do it via REST API with no success. Appreicaite.

Thanks
Kaz
Thanks,

Kaz

Post Reply