TM1 Forum

Hi all

Is there a way for a TI to open a cube and a view at the end of a process,

What i would ideally like is that the TI open the view and show the data had moved is this possible?

i have been shown drill and there is a command called "returnview handle" yet when i use it not in generated statements it does not work,

thanks for reading

Are you proposing that the view be opened in a client UI? The TI runs on the server and has no control over, or even knowledge of, any client UI.

Perhaps if you are in Web-Sheets you might be able to do this with an action button to run the TI and then to move to a separate sheet. I defer to the Web-Sheet gurus on this one.

Hi Duncon

When you create a Drill through a Ti runs and opens a Cube view (not in a spreadsheet) in a cube, this code is called Returnview handle.

however when i try this manually it crashes my whole server!!!

is there another way to copy this?

Darkhorse wrote:When you create a Drill through a Ti runs and opens a Cube view (not in a spreadsheet) in a cube

It depends on the interface. If you drill from a cube view (or websheet) it drills to a cube view. If you drill from a spreadsheet it drills to a fresh active form.

Darkhorse wrote:... this code is called Returnview handle. however when i try this manually it crashes my whole server!!!

You mean you are trying to insert ReturnViewhandle(sCub, sVue) into a TI process that is NOT a }Drill_.. process?? I wouldn't have thought this would CRASH your server but rather to do nothing at all as this is definitely not supported. Anybody's guess what is different in the backend handling but Drill processes are a special type of process that are only ever executed by users in the context of a GUI and in the context of navigational element parameters in the cube view or DBRW being drilled from. As Duncan said a TI process runs on the server and has no context or awareness of any client. Drill processes are a special exception to this.