TM1 Forum

Hi All,

We have an application in TM1 Web, which contains data in list format, bar graph etc. (Single Report)
Users manually go and export in excel as snapshot.
We are looking to automate that scenario.

Approach we are trying is to build same reports in BI and burst them and send using scheduler.

I was looking, if we can get this done by using things within TM1 rather than building same report in BI.

1. Is it possible to get snapshot of report automatically? if yes, please share information.
2. I will have to use some third party tool to send an email to users, right?

Regards,
Deepak Jain

Doesn't it sound familiar:
http://www.tm1forum.com/viewtopic.php?f=3&t=12321 Thanks

HI BariAbdul,

Thanks for sending ref link.
I went through that post, and yes we can do things in BI and then burst it, as mentioned in my post.
I was looking to understand that, is there any way to automatically get snapshot of an application i.e. accessed via TM1 Web.

Regards,
Deepak Singhvi

deepakjain2020 wrote:I was looking to understand that, is there any way to automatically get snapshot of an application i.e. accessed via TM1 Web.

No.

Thanks Tomok

Is it not possible to pass parameters into a vb script through the use of a TI that would open your excel book change certain cells, refresh the workbook, then save the workbook in a temp location. Then after that you would call a TI process that could email attachments, (Take a look at blat.exe or some of the other posts on sending email from TM1).

Essentially you could create some kind of loop based on a user list and generate their report using vb and email it to that user.