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
TI to Open View
-
- 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
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.
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.
-
- 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
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?
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?
-
- 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
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:When you create a Drill through a Ti runs and opens a Cube view (not in a spreadsheet) in a cube
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.Darkhorse wrote:... this code is called Returnview handle. however when i try this manually it crashes my whole server!!!