Have some TM1 API experience and more yrs coding than I'd like to admit.
Trying to use the API to create a custom logging utility. No problem listing servers, cubes, and dims. Having issues trying to get TM1ServerLogOpen and TM1ServerLogNext working. Specifically, which function(s) do you use to pull the values out given return values they generate? Also, how do you know when you're finished - not sure my method is working? Anyone have a working example? Thanks in advance!
TM1 API Access to Log Files
-
rickthomas1
- Posts: 2
- Joined: Thu Jan 06, 2011 5:53 pm
- OLAP Product: TM1, Hyperion, BPC, etc.
- Version: 9.5
- Excel Version: 2007
-
tomok
- MVP
- Posts: 2836
- 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: TM1 API Access to Log Files
Why anyone would ever attempt to use the API for this escapes me. The logs are just simple text files. You'll find it much easier to use the facilities already available in VB for manipulating text files than you will anything in the API, IMO.rickthomas1 wrote:Have some TM1 API experience and more yrs coding than I'd like to admit.
Trying to use the API to create a custom logging utility. No problem listing servers, cubes, and dims. Having issues trying to get TM1ServerLogOpen and TM1ServerLogNext working. Specifically, which function(s) do you use to pull the values out given return values they generate? Also, how do you know when you're finished - not sure my method is working? Anyone have a working example? Thanks in advance!
-
rickthomas1
- Posts: 2
- Joined: Thu Jan 06, 2011 5:53 pm
- OLAP Product: TM1, Hyperion, BPC, etc.
- Version: 9.5
- Excel Version: 2007
Re: TM1 API Access to Log Files
VBA is certainly an option. My perceived benefits in trying to access the log files through the API are that it treats all the log files as one so you avoid all the complexity of dealing with multiple files in the right order while applying the proper time filters. Also parses out the fields and auto filters by cube name, etc - not a big deal but not completely trivial either. Another reason is that I couldn't find a way to retrieve the logging directory for a server (help?) from VBA which means the user must have a facility to choose the directory which adds complexity. Unfortunately, haven't been able to find one example online.