Excel file in TM1Web
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Excel file in TM1Web
Hello,
for the Application in question we use TM1 10.2.2 on a windows-Server with TM1Web as the frontend. The whole app uses a couple of different Excel-Sheets with a Main-Menu from where the other Sheets are called. The user want to replace the current sheet with the called sheet.
So a couple of years ago an Excel-workbook with all the Sheets in questions are devloped and the Sheets where hidden and called with Actionbuttons.
That was a bit slow and I changed it to a Excel-Sheet standalone as a Application in TM1 in a different Folder and the Sheets are still called by the action-Buttons and replaces the current sheet.
Now the users don't want to see the extra Folder because they are getting cinfused what to call.
Now I had the idea to Change the Action Buttons so that they invoke Excel-files instead of TM1-Applications. Does this has any Impact on the Performance? Does this mean that the file is intereted every time? As far as I know TM1 uses a builtin Cache for the Applications?
Thx in adnace,
Willi
for the Application in question we use TM1 10.2.2 on a windows-Server with TM1Web as the frontend. The whole app uses a couple of different Excel-Sheets with a Main-Menu from where the other Sheets are called. The user want to replace the current sheet with the called sheet.
So a couple of years ago an Excel-workbook with all the Sheets in questions are devloped and the Sheets where hidden and called with Actionbuttons.
That was a bit slow and I changed it to a Excel-Sheet standalone as a Application in TM1 in a different Folder and the Sheets are still called by the action-Buttons and replaces the current sheet.
Now the users don't want to see the extra Folder because they are getting cinfused what to call.
Now I had the idea to Change the Action Buttons so that they invoke Excel-files instead of TM1-Applications. Does this has any Impact on the Performance? Does this mean that the file is intereted every time? As far as I know TM1 uses a builtin Cache for the Applications?
Thx in adnace,
Willi
- tiagoblauth
- Posts: 20
- Joined: Wed Jul 08, 2015 11:50 am
- OLAP Product: TM1, Cognos BI
- Version: 10.2.1
- Excel Version: 2010
Re: Excel file in TM1Web
Hi, do you have Cognos BI? If yes you can use "Pages" to organize the objects. It does look very well.
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Excel file in TM1Web
Why would you do this? What are you trying to accomplish? If you don't want clicking on the Action Button to open the new sheet in a new tab in TM1Web you simply tell the Action Button to replace the current sheet, not open a new tab.Willi wrote:Now I had the idea to Change the Action Buttons so that they invoke Excel-files instead of TM1-Applications. Does this has any Impact on the Performance? Does this mean that the file is intereted every time? As far as I know TM1 uses a builtin Cache for the Applications?
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Excel file in TM1Web
@tiagoblauth:
No, not for this customer
@tomok
sorry, I may explained it not very well. The user has to click the button. That is not the issue. And the replacement of the current sheet is also no Problem.
The issue is that they don't want to see the Applications/Sheets in the Navigation-Tree. And to hide them in the Excel-Workbook as hidden Sheets has to much influence on the performance. So the only Thing wich came into my mind is to call them as plain Excel-Files.
No, not for this customer
@tomok
sorry, I may explained it not very well. The user has to click the button. That is not the issue. And the replacement of the current sheet is also no Problem.
The issue is that they don't want to see the Applications/Sheets in the Navigation-Tree. And to hide them in the Excel-Workbook as hidden Sheets has to much influence on the performance. So the only Thing wich came into my mind is to call them as plain Excel-Files.
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Excel file in TM1Web
I'm pretty sure this will not work. The web sheet will not be interpreted by TM1Web as a web sheet unless you publish it to an Applications folder. If you just call an Excel file from a hyperlink then it will be recognized as Excel by your browser and it will be opened in Excel. FWIW, that's a really stupid request by your client. Sometimes you just have to tell people that this is the way TM1 works. Get over it.Willi wrote:So the only Thing wich came into my mind is to call them as plain Excel-Files.
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Excel file in TM1Web
We tried it and it worked. It was interpreted as a TM1Web-Sheet. It was not a Hyperlink. The Actionbutton was configured to open a file instead of a TM1-Application.
-
- MVP
- Posts: 3666
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Excel file in TM1Web
If they don't wan't to see the navigation tree then surely the logical and sensible solution is to HIDE THE NAVIGATION TREE FORM THE USERS? This is very simple to do in the }ClientSettings cube. Then all you do is build a menu using either action buttons or hyperlinks with URL API so that the users can navigate to just the objects that they need and want without any confusion. (And the application also looks much more professional)Willi wrote:The issue is that they don't want to see the Applications/Sheets in the Navigation-Tree. And to hide them in the Excel-Workbook as hidden Sheets has to much influence on the performance. So the only Thing wich came into my mind is to call them as plain Excel-Files.
It is quite easy to achieve opening Excel as Excel not Websheet you just need to provide a hyperlink to a location OUTSIDE of the TM1Web virtual directory.Willi wrote:We tried it and it worked. It was interpreted as a TM1Web-Sheet. It was not a Hyperlink. The Actionbutton was configured to open a file instead of a TM1-Application.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Excel file in TM1Web
Thanks, but I cannot hide the Navigarion tre completly.lotsaram wrote:If they don't wan't to see the navigation tree then surely the logical and sensible solution is to HIDE THE NAVIGATION TREE FORM THE USERS? This is very simple to do in the }ClientSettings cube. Then all you do is build a menu using either action buttons or hyperlinks with URL API so that the users can navigate to just the objects that they need and want without any confusion. (And the application also looks much more professional)
I don't want to open an Excel-File as Excel. I want to open an Excel-File as Websheet. I want to configure the Actionbutton to open a file C:\directory\file.xlsx wich resides on the Server as a TM1Web-Sheet. I know how to do it but I want to know if this has any Impact on preformance or so.lotsaram wrote:It is quite easy to achieve opening Excel as Excel not Websheet you just need to provide a hyperlink to a location OUTSIDE of the TM1Web virtual directory.
- paulsimon
- MVP
- Posts: 808
- Joined: Sat Sep 03, 2011 11:10 pm
- OLAP Product: TM1
- Version: PA 2.0.5
- Excel Version: 2016
- Contact:
Re: Excel file in TM1Web
Will
You are taking an approach that a lot of people are advising you against taking. Therefore it is not that surprising that no one has answered the question as to whether it impacts performance because they have never used that approach so they don't know. I am not sure what approach you are trying. Are you using relative references or Object Ids. You can probably just run tests yourself to find out the affect on performance. There are a lot of things that can affect the performance of a web sheet.
There are options to hide the navigation tree completely or to hide parts of it, or to open a specific sheet when they go to the web site which can act as a menu so that they don't need to see the navigation tree. That is an approach that I have taken in the past - just a sheet with 4 big buttons for the common actions.
Another option, often the best, is a little user training so that they don't get confused. I have built various systems supporting several hundred users using TM1 Web and they seem to manage OK.
Regards
Paul Simon
You are taking an approach that a lot of people are advising you against taking. Therefore it is not that surprising that no one has answered the question as to whether it impacts performance because they have never used that approach so they don't know. I am not sure what approach you are trying. Are you using relative references or Object Ids. You can probably just run tests yourself to find out the affect on performance. There are a lot of things that can affect the performance of a web sheet.
There are options to hide the navigation tree completely or to hide parts of it, or to open a specific sheet when they go to the web site which can act as a menu so that they don't need to see the navigation tree. That is an approach that I have taken in the past - just a sheet with 4 big buttons for the common actions.
Another option, often the best, is a little user training so that they don't get confused. I have built various systems supporting several hundred users using TM1 Web and they seem to manage OK.
Regards
Paul Simon
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Excel file in TM1Web
Sorry to come back a Little late.
So the tM1Web-Server doesn't read the file from its internal Application Folder instead reading it from the filesystem of the Server.
Best regards,
Willi
Hm, I didn't got the Feeling that a lot of People advised me against it. I got the Feeling that I wasn't understodd what I want to do. I don't blame anybody about this. Could be completly my fault. All I want to do is to define an Action button like this:paulsimon wrote:You are taking an approach that a lot of people are advising you against taking. Therefore it is not that surprising that no one has answered the question as to whether it impacts performance because they have never used that approach so they don't know. I am not sure what approach you are trying. Are you using relative references or Object Ids. You can probably just run tests yourself to find out the affect on performance. There are a lot of things that can affect the performance of a web sheet.
So the tM1Web-Server doesn't read the file from its internal Application Folder instead reading it from the filesystem of the Server.
Oh, that I can hide the Navigation-tree partly is a new Information foe me. Can you Point me to the correct part in the docs? But please remember that the Excel-Files I hide should be callable for the users.paulsimon wrote:There are options to hide the navigation tree completely or to hide parts of it, or to open a specific sheet when they go to the web site which can act as a menu so that they don't need to see the navigation tree. That is an approach that I have taken in the past - just a sheet with 4 big buttons for the common actions.
Believe me: I tried.paulsimon wrote:Another option, often the best, is a little user training so that they don't get confused. I have built various systems supporting several hundred users using TM1 Web and they seem to manage OK.
Best regards,
Willi