Hiding TM1 toolbar

[telula]

Hello,
We have a user interface in excel which enables users to log into TM1.What I want to do right now is to hide the TM1 toolbar so that users cannot go into the cubes.I want everyone to get data through the spreadsheet interface and not access the cubes directly. Does anyone know how this can be done ?

[Malcolm MacDonnell]

Hi telula,

In the registry under

HKCU\Software\Applix\TM1 Perspectives

is a list of toolbars with true or false against them. Set them to false and the toolbars will go away. The problem is that Server Explorer will still be available in the TM1 menu.

Mal

[telula]

Hey Malcom,
Sorry, thats what I meant. I dont want the TM1 Menu to be seen.Is this possible?

[Steve Vincent]

don't think so, its controlled by the tm1p.xla which must be loaded to Excel for anything to work, and that's password protected by Applix/Cognos.

[lotsaram]

The TM1 menu and toolbars are created by tm1p.xla but that doesn't mean you can't manipulate them with VBA.

If you want to nuke the whole TM1 menu:
Application.CommandBars(1).Controls("TM1").Delete

If you want to disable or destroy particular menu items then this can be done in much the same way. Note: this would be for Excel that has commandbars, I haven't done much poking around with the 2007 Ribbon so not sure what you would need to do to disable the TM1 ribbon.

You would of course need to write your own custom xla and make sure it was loaded to all your users Excel sessions in order to disable the TM1 menu. Although I'm not sure what events in addition to loading tm1p might also trigger the TM1 menu being rebuilt so it might be trickier than it seems ...

[Steve Vincent]

to be honest i can't see what the issue with having the toolbar visible is anyway. you miss most of the functionality and user effectiveness of TM1 when you don't use server explorer, but even if they are just inputting data to a template if you don't tell them its there and what its for they won't notice 99% of the time anyway

Now the "server status" toolbar on the other hand, that's an utter waste of space and was the first thing i got rid of

[rkaif]

In Excel, you have to exclude TM1 Perspectives from the list of Add-ons which are executed at the startup of Excel. You can remove TM1 Perspectives Add-on by doing the following:

In Excel click on Office Button -> Excel Options -> Add-Ins -> Manage Excel Add-ins -> Uncheck IBM Cognos TM1 Perspectives

[Alan Kirk]

In Excel, you have to exclude TM1 Perspectives from the list of Add-ons which are executed at the startup of Excel. You can remove TM1 Perspectives Add-on by doing the following:

In Excel click on Office Button -> Excel Options -> Add-Ins -> Manage Excel Add-ins -> Uncheck IBM Cognos TM1 Perspectives

The question (that was asked well over a year ago now) was how to hide the toolbar/menu, not "how do I have the TM1 client not loaded at all and therefore have none of its functionality". The two are... rather different.