Page 1 of 1
calling the web page
Posted: Sat Feb 09, 2013 5:31 pm
by charan
Hi,
When I am trying to call the log page for open type= "path of the sheet", the part in the path .}External is converting to %7d after pasting it on url. The result is BAD REQUEST.
This link i tried on client network and I got bad request.
But when I tried on another server for full path from tm1web to sheet name the result is credentials window is poping up.
This link I tried on local machine and it is asking credentials.
I am clue less for this, please help me.
Thanking you
Re: calling the web page
Posted: Sat Feb 09, 2013 8:01 pm
by lotsaram
Likewise I am quite clueless what you are asking. Can you try expressing a question?
Re: calling the web page
Posted: Sun Feb 10, 2013 2:55 am
by charan
Hi,
What I am trying is Using TM1object path to open a websheet object.
http://wbsvr/TM1Web/TM1WebMain.aspx?act ... ube$$Price
action=OpenObject&type=Cubeviewer&value=SalesCube$$Price, here in place of cube name I tried to give my sliced exceel sheet name.
TM1://ServerName/blob/PUBLIC/.\}Externals\TM1_Filename when I enterd this syntax with my file name I am getting an error as BAD REQUEST.
on the url addrees in place of .\}Externals, it is coming as %7DExternals. This is my issue.
thank you.
Re: calling the web page
Posted: Sun Feb 10, 2013 6:34 am
by charan
any suggestions
Re: calling the web page
Posted: Sun Feb 10, 2013 8:43 am
by lotsaram
charan wrote:any suggestions
I'm not sure what time zone or indeed what plannet you operate from but bumping a thread in a 3 hour window on a Sunday is not going to get you any results or endear you to anyone who might be able to provide an answer.
For starters I would suggest not mixing up forward- and backslash within the URL! You could be getting escape character issues with the curly brace or backslash.
You haven't said whether the worksheet in question is loaded to the TM1 server or is an external link to the file system somewhere which could be relevant. As it seems that the file is loaded to the application folder tree as opposed to being an external file why not use the application path URL syntax? This is much easier to deduce even though it may be longer.
Re: calling the web page
Posted: Mon Feb 11, 2013 1:04 am
by charan
Hi Lotsaram,
Thank you, the worksheet is loaded to TM1 web.
Re: calling the web page
Posted: Mon Feb 11, 2013 6:55 am
by charan
Hi Lotsaram,
I opening the link now, In sending the parameters for web sheet, the syntax is like title=S1-R2-B2=Actual&title=S1-R3-B3=Jan-2013.
When I enter this titles to the link i mentioned in my previous post it is still going to tm1 web login window, it is not directly opening web sheet.
In adding titles thers is any other special character to be entered other than "&", if yes suggest me.
Thanking you.
Re: calling the web page
Posted: Mon Feb 11, 2013 3:46 pm
by tomok
charan wrote:When I enter this titles to the link i mentioned in my previous post it is still going to tm1 web login window, it is not directly opening web sheet.
Well, let's see....you are not authenticated and you are expecting to go directly to a report without providing any authentication? Think about it.
Re: calling the web page
Posted: Tue Feb 12, 2013 4:47 am
by charan
Ho Tomok,
Thank you. Yes, first I must go to authentication page, Once I enter into the TM1 web. I should directly see the report, which is not happening here.
http://localhost/tm1web/TM1WebLogin.asp ... chiseStore.
PLease suggest me after giving the credentials how to enter into the Franchise store directly.
Thanking you.
Re: calling the web page
Posted: Tue Feb 12, 2013 7:13 am
by charan
Any suggestons please for directly opening the web sheet after login into the TM1 web. After login I need to select Applications-->Folders--> Report--->Report.xls.
It should go directly to Report.xls after login into the TM1 web.
Thanking you
Re: calling the web page
Posted: Tue Feb 12, 2013 7:45 am
by Michel Zijlema
charan wrote:Any suggestons please for directly opening the web sheet after login into the TM1 web. After login I need to select Applications-->Folders--> Report--->Report.xls.
It should go directly to Report.xls after login into the TM1 web.
Thanking you
You can set a hompage for a user (group): in Server Explorer open the Clients/Groups dialog and click the Settings button on the right. This will open up a dialog in which you can specify a homepage - this is the report that will automatically open after login in TM1Web for the selected user(s).
Michel
Re: calling the web page
Posted: Tue Feb 12, 2013 8:52 am
by buncikp
Hi,
refer to TM1Web URL API documentation. You can use redirect in login page, so setting redirect address to address of you report might work.
It might be even your own custom login page that will supply all possible credentials data to TM1. Consider this javascript piece of code that might be used to submit the form with your TM1 credentials. The below example of HTML page shows how to integrate parameter passing to your websheet - in this example how to open report directly with preselected client. You would obviously put the HTML page implementing this "login" and redirect to you TM1Web folder under IIS (default loc: c:\Inetpub\wwwroot\TM1Web\).
Regards
Peter
Code: Select all
<html>
<head>
<title>TM1 WebSheet Test</title>
<script type="text/javascript">
function submitform() {
baseURL = "http://localhost/TM1Web/TM1WebMain.aspx?action=OpenObject&AdminHost=localhost&TM1Server=YOURSERVER&type=Websheet&HideToolbar=1&AutoRecalc=1&HideTabs=1&title_S1-R7-C3="+document.forms["loginform"].client.value+"&value=Applications/YOURAPPLICATION.xls";
document.forms["loginform"].action = "TM1WebLoginHandler.aspx?redirect="+escape(baseURL);
document.forms["loginform"].submit();
}
</script>
</head>
<body>
<table>
<tr><td colspan="2"><h2>Parametrised TM1WebSheet - Preview (login)</h2></td></tr>
<form name="loginform" method="post" action="TM1WebLoginHandler.aspx">
<tr><td>Admin Host URL:</td><td><input name="AdminHost" id="AdminHost" type="text" value="localhost"></td></tr>
<tr><td>TM1 Server Name:</td><td><input name="TM1Server" id="TM1Server" type="text" value="YOURSERVER"></td></tr>
<tr><td>User Name:</td><td><input name="UserName" id="UserName" type="text" value="admin"></td></tr>
<tr><td>Password:</td><td><input name="Password" id="Password" type="password" value=""></td></tr>
<tr><td>Client to Open:</td><td>
<select name="client">
<option value="Client 1">Client 1</option>
<option value="Client 2">Client 2</option>
<option value="Client 3">Client 3</option>
<option value="Client 4">Client 4</option>
<option value="Client 5">Client 5</option>
<option value="Client 6">Client 6</option>
<option value="Client 7">Client 7</option>
<option value="Client 8">Client 8</option>
<option value="Client 9">Client 9</option>
<option value="Client 10">Client 10</option>
</select>
</td></tr>
<tr><td colspan="2" align="right"><input name="SubmitBtn" id="SubmitBtn" type="button" onclick="submitform()" value="Login"/></td></tr>
</table>
</form>
</body>
</html>