TI to Open View

Post Reply
Darkhorse
Posts: 141
Joined: Wed Mar 09, 2011 1:25 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2003 2007 2010 2013

TI to Open View

Post by Darkhorse »

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
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: TI to Open View

Post by Duncan P »

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.
Darkhorse
Posts: 141
Joined: Wed Mar 09, 2011 1:25 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2003 2007 2010 2013

Re: TI to Open View

Post by Darkhorse »

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?
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: TI to Open View

Post by lotsaram »

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.
Post Reply