Help Desk App Developed in TM1

[Natlandry]

Hey Gurus! Anyone ever use TM1 to develop a Help Desk ticket tracking application? The requirement is to enter new tickets into TM1 and then use Cognos BI for reporting. The tracking cube should be pretty easy. The problem comes with automated status emails. The other issue is auto generating numbers in TM1.

Thanks in advance!

[jim wood]

This isn't very difficult. If you do a search on goodle there are scripts that you can imbed in to a TI script to send out html based emails. As for auto generating numbers, that also easy especially if you use a combination of TI and excel for ticket entry front end.

[tomok]

You can cobble something together in TM1 but why would you want to create something in TM1 that is clearly the domain of a relational database. This would be sooooo much easier in SQL Server.

[lotsaram]

I've done this once before and wouldn't bother again. More to the point why would you want to develop a help desk application at all regardless of tool considering there are many free open source ones out there? Even more so with an unsuited tool.

[Natlandry]

Thanks for the replies. The solution has to utilize TM1 and/or SharePoint. No custom development like asp.net is allowed in this environment.