Tm1Web Export without Toolbar

[ThePencil]

Hello all,

an old problem is coming up again for me. I have to disable the web toolbar, but i still need a possibility that users can print or export a TM1sheet.

Any suggestions for this. Is there perhaps a shortcut to export or is there any other workaround.

Thanks a lot in advance.

[jim wood]

I'm not expert on this but there is no right click short cut menu that gives you the open as part of the standard install so you may have to re-enable the bar. For what reason did you remove it? Did you do a search on the forum on this? Somebody else may have come across this.

[ThePencil]

It had to be removed because of the undo function.
Between different sheets we have some process running which may not be undone.
So the solution is deactivating the toolbar. But we can't disclaim the toolbar now because of the export functions.

[declanr]

You can disable cube logging during the TI process do that it can't be undone (as long as you have a record of what it did... e.g. if its from an odbc source your fine or you may need to do your own logging)

The other option is to keep the bar disabled and set up TI processes to do your exports using vb script etc.

[ThePencil]

Hello declanr,

can you describe the scenario with TI and vb script a bit more in detail. How would this work? I run an TI-Process that exports the data to a flatfile? Then i run a vb-script that converts the flatfile to excel, formats it ... . How would the user get the file?

Kindly regards

[declanr]

You use vb script to open the websheet in excel passing in whatever parameters are necessary to the subnms and save the file in a shared folder.

The TI can contain options for whether they want the tm1 formulas intact, a hardcoded version or one printed to pdf first. Its a bit messy but could get you where you need to go.

[ThePencil]

Hello declanr,

thanks so far. Do you have an example for a vb script for opening a sheet and passing parameters. Is this using the tm1 vb api. Sorry for the questions but i have noc experience in TM1/Vb script combining.

Kindly regards