Excel - TI Error Message

[ThomasCS]

Hey,

I've searched this but didn't found a solution and I fear there isn't one (yet).

I would like to give the end user, who runs a TI-process from excel, more feedback especially when the process fails. Because one succes and one fail message is way to limited for the end user to understand what went wrong. They don't want to search in error logs...

I've been thinking about creating a "error-log cube" that displays one line, with the latest error message, in an excel-cell after running a process?
TM1 is a great program, but it's lacking some fundamental items especially towards end-users.

Any suggestions?

Many thanks in advance
Thomas

[jim wood]

Another possibility (if you are able to access such systems) is to load the error log in to a database. (Microsoft SQL would be ideal as you would be able to kick off a dts very easily from TI via a batch file.) You could then (using TI) load the error messages only in to a TM1 cube using a distinct query. (You might want to add something like file name and process run time to make it easier to find things.) While this is a bit long and drawn out it would give you only valid error messages.

[jstrygner]

ThomasCS,
That is exactly what I did. I put the DBRW reference to error-log-cube and was displaying a text message from that cube. To make sure another user will not "overwrite" my log message by callling TI process later, my error-log-cube had '}Clients' dimension in it, so after recalculating the excel sheet users had only "their" log comments. I also did a 'Status' cell where "OK" or "Error" was displayed and I could easily do conditional formatting for the log message (green or red text).
Regards