Log Management for PA

Post Reply
mars_22
Posts: 3
Joined: Thu Nov 28, 2019 9:10 am
OLAP Product: TM1
Version: PAL 2.0.6
Excel Version: 2013

Log Management for PA

Post by mars_22 » Fri Jan 10, 2020 11:09 am

Hello all,

I was wondering, how are you usually dealing with Log Management for Planning Analytics (2.0.6)?
We're currently using PAW (2.0.46) as an interface for users. When the user is running a process from there, he's getting only basic info about the process run - basically if it was successful or not. Some of our processes then generate quite extensive log files with information (e.g. list of rejected rows from database/file when it is process for data upload etc.) We're of course saving these log files on the server (RHEL 7.5). Then, when the user want's to see the log, he has to use FTP client and retrieve the log from the server, but our users are not happy with the FTP solution. I was wondering if there's a better way we didn't think of.
I know that there's this "Download log" functionality in PAW Administration now, but that only lets the user download general system logs, not the custom ones (also you have to be administrator in PAW which means you can freely restart instances etc., not a good idea).

Just wanted to know how are other companies usually handling this. Will be thankful for any idea or comment.

Thanks a lot in advance!

tomok
MVP
Posts: 2702
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: Log Management for PA

Post by tomok » Fri Jan 10, 2020 2:26 pm

The only option that I know of is to roll your own solution. The three that come to mind are:

1. Copy the log files to a share on the network that people have access to.
2. Write a process to upload the log transactions to a SQL table
2. Write a Powershell script to email the file to the user.

All of these are possible since you can call external routines from a TI process. Good luck.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

User avatar
Steve Rowe
Site Admin
Posts: 2000
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Log Management for PA

Post by Steve Rowe » Sun Jan 12, 2020 2:56 pm

and option 4, load the log files back into TM1 again.

Unless the logs are huge there's no reason why you can't load (or even write them in the first place) to a TM1 cube fir easy viewing by the end user.

mars_22
Posts: 3
Joined: Thu Nov 28, 2019 9:10 am
OLAP Product: TM1
Version: PAL 2.0.6
Excel Version: 2013

Re: Log Management for PA

Post by mars_22 » Wed Jan 15, 2020 1:36 pm

Thank you both for the comments!
@Steve, we're using the option to write them back to the cube for the short logs already, but, as you mentioned, I was asking mainly because of the huge logs we're generating.

Then we will probably use the emailing option. It is actually something that was kind-of already suggested by the users, but I wanted to explore all possibilities first.

There's one related thing though - we're using CAM for authentication. Then, of course, in Cognos we can see the users email addresses as they are taken from LDAP. But in TM1 we do not have this information, we basically get only the user ids from Cognos. I wasn't able to think of an easy way how to get the email addresses from Cognos to TM1. Any ideas there? The rest (trigger the script to email the file to the user) is easy.

Thanks!

tomok
MVP
Posts: 2702
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: Log Management for PA

Post by tomok » Wed Jan 15, 2020 1:42 pm

mars_22 wrote:
Wed Jan 15, 2020 1:36 pm
I wasn't able to think of an easy way how to get the email addresses from Cognos to TM1. Any ideas there? The rest (trigger the script to email the file to the user) is easy.
Just create an attribute on the }Clients dimension called "EmailAddress" and store them there. Of course you'll have to figure out a way to keep those values updated......
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

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

Re: Log Management for PA

Post by lotsaram » Wed Jan 15, 2020 4:09 pm

mars_22 wrote:
Wed Jan 15, 2020 1:36 pm
There's one related thing though - we're using CAM for authentication. Then, of course, in Cognos we can see the users email addresses as they are taken from LDAP. But in TM1 we do not have this information, we basically get only the user ids from Cognos. I wasn't able to think of an easy way how to get the email addresses from Cognos to TM1. Any ideas there? The rest (trigger the script to email the file to the user) is easy.
If AD is the source for CAM it is actually quite easy via PowerShell to query AD and retrieve AD attributes of the user name. Matching the user name to the CAM ID is also relatively easy (concatenate NamespaceID back- or forward-slash with windows user name = the display alias in TM1) in order to know which users to send the emailaddress to.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

mars_22
Posts: 3
Joined: Thu Nov 28, 2019 9:10 am
OLAP Product: TM1
Version: PAL 2.0.6
Excel Version: 2013

Re: Log Management for PA

Post by mars_22 » Thu Jan 16, 2020 3:24 pm

tomok wrote:
Wed Jan 15, 2020 1:42 pm
Just create an attribute on the }Clients dimension called "EmailAddress" and store them there. Of course you'll have to figure out a way to keep those values updated......
Exactly, it is not an issue where to store them but what's the best way to get them/keep them updated.
lotsaram wrote:
Wed Jan 15, 2020 4:09 pm
If AD is the source for CAM it is actually quite easy via PowerShell to query AD and retrieve AD attributes of the user name. Matching the user name to the CAM ID is also relatively easy (concatenate NamespaceID back- or forward-slash with windows user name = the display alias in TM1) in order to know which users to send the emailaddress to.
We will probably do something like this, yes. I was just wondering if there's an easy way how to get them directly from Cognos as we have them there already.

Thank you all for the inputs.

tomok
MVP
Posts: 2702
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: Log Management for PA

Post by tomok » Thu Jan 16, 2020 5:02 pm

mars_22 wrote:
Thu Jan 16, 2020 3:24 pm
Exactly, it is not an issue where to store them but what's the best way to get them/keep them updated.
How often does someone's email address change? Seriously. We have approx 250 users and we had one person last year that had a name change and thus email address change. I wouldn't spend any time automating that update. The only time you'll really have to edit an email address is for a new user. Make that part of the new user routine and be done with it.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Post Reply