Did you know that you can create a URL that will open directly into a specific websheet? The concept is to simply use your existing TM1 Web address and then enter some parameters. The parameters are where the fun begins since you can include parameters for actions to take, adminhost and server names, and websheet names. You can also include your username and password within the URL to automatically connect into your Planning Analytics environment.
The base URL and the parameters are separated by the number symbol (#):
| BaseUrl#Parameter=value |
Multiple parameters can be included and are separated via the ampersand symbol (&):
| BaseUrl#Parameter1=value¶meter2=value¶meter3=value |
If you had the following setup in your environment …
- TM1 Web is running on your local machine via https://localhost:9510/tm1web
- Your environment contains a websheet called ExpenseEntry within the Application called Planning
- Your admin host is localhost and your server name is called FinanceProd
- Your user name is admin and your password is apple
… then here is the URL that would link to the websheet:
| https://localhost:9510/tm1web/UrlApi.jsp#Action=Open&Type=WebSheet&Workbook=Applications/Planning/ExpenseEntry&AdminHost=localhost&TM1Server=FinanceProd&Username=admin&Password=apple |
Note that the base URL uses the following format:
| https://WebServerName:PortNumber/tm1web/UrlApi.jsp |
IBM Planning Analytics is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!
Read more IBM Planning Analytics Tips & Tricks:
IBM Planning Analytics: Using the Full Power of MDX
How to use IBM Planning Analytics Workspace
How to Create IBM Planning Analytic Workspace Content (Part 1)
