How to Login and then view the Cube via URL link ?

Post Reply
sirsa
Posts: 5
Joined: Tue Apr 10, 2012 2:31 pm
OLAP Product: cognos 10.1
Version: 10.1
Excel Version: 2003

How to Login and then view the Cube via URL link ?

Post by sirsa »

Good Morninig to all,

Problem:

I need to write URL link which will log user to tm1 environmet and then view the cube. I have tried many ways but I can't solve it. There are shown several ways that I tried:

1. http://MyTM1Server/tm1web/TM1WebLoginHa ... ]TM1Server[/b]=Mytm1server&AdminHost=MyAdminHost&UserName=Anonymous&redirect=http://10.11.7.99/TM1Web/TM1WebCubeView ... d=24418296
2. http://MyTM1Server/tm1web/TM1WebLoginHa ... ]TM1Server[/b]=Mytm1server&AdminHost=MyAdminHost&UserName=Anonymous&action=OpenObject&type=Cubeviewer&value=MyCube

But it did not work. I tried to compose this from the manual page: http://publib.boulder.ibm.com/infocente ... 90213.html but I can't solve it.

Thanks a lot for any advice.
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: How to Login and then view the Cube via URL link ?

Post by lotsaram »

sirsa
Posts: 5
Joined: Tue Apr 10, 2012 2:31 pm
OLAP Product: cognos 10.1
Version: 10.1
Excel Version: 2003

Re: How to Login and then view the Cube via URL link ?

Post by sirsa »

lotsaram :

Hellou,

Yes, I have used the search, but there is option how to log in and I need log and open cube in one link.

I have tried it many ways...but I have no other ideas.
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: How to Login and then view the Cube via URL link ?

Post by rmackenzie »

Per the link you posted, to the documentation:
Include in URL - Specify login information in the URL when accessing TM1 Web objects. The URL must include values for AdminHost, TM1Server, UserName, and Password.
You haven't included the password, which you have to pass in the 'clear'. Integrated login is advised when you need the login to not be part of the user experience because obviously having the password as part of the URL is a problem.
Robin Mackenzie
sirsa
Posts: 5
Joined: Tue Apr 10, 2012 2:31 pm
OLAP Product: cognos 10.1
Version: 10.1
Excel Version: 2003

Re: How to Login and then view the Cube via URL link ?

Post by sirsa »

rmackenzie

thank you for help, but for my case there is no problem having password as a part of URL link. There is no security needed. I just need to create URL link which will be written in internet browser and login and then opening cube will shown.

But thank for any advice:)
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: How to Login and then view the Cube via URL link ?

Post by rmackenzie »

Yes, you may not need security, but you still have to use the 'Password' parameter in the query string even though you may not have set a password against the 'anonymous' user. Did you actually try that out yet?
Robin Mackenzie
sirsa
Posts: 5
Joined: Tue Apr 10, 2012 2:31 pm
OLAP Product: cognos 10.1
Version: 10.1
Excel Version: 2003

Re: How to Login and then view the Cube via URL link ?

Post by sirsa »

rmackenzie

I tried to put there password parameter, but I am not sure with syntax of blank password (because Anonymous account in my case has blank password). How can I write there that password is blank ?

Thanks
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: How to Login and then view the Cube via URL link ?

Post by rmackenzie »

Just don't put anything there...

Code: Select all

http://MyTM1Server/tm1web/TM1WebLoginHandler.aspx&TM1Server=Mytm1server&AdminHost=MyAdminHost&UserName=Anonymous&
Password=&action=OpenObject&type=Cubeviewer&value=MyCube
Robin Mackenzie
sirsa
Posts: 5
Joined: Tue Apr 10, 2012 2:31 pm
OLAP Product: cognos 10.1
Version: 10.1
Excel Version: 2003

Re: How to Login and then view the Cube via URL link ?

Post by sirsa »

rmackenzie

thanks for idea but it still not working. I will try turn off Single Sing On.
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: How to Login and then view the Cube via URL link ?

Post by lotsaram »

sirsa wrote:thanks for idea but it still not working. I will try turn off Single Sing On.
That is new information that you might have thought of mentioning earlier!

If you have SSO (I take it you mean integrated login in traditional TM1 speak?) all working then you don't need the login handler part of the URL at all. You can just use the URL API to direct the user straight to the cube view or websheet and the login will be handled automatically.
Post Reply