Saving in Excel
-
domduduman
- Posts: 1
- Joined: Sun Nov 25, 2012 6:14 pm
- OLAP Product: TM1 Perspectives
- Version: 10.0.1
- Excel Version: 2010
Saving in Excel
I am using TM1 Perspectives (Cognos 10.1) trying to create reports that my team can use and modify. One way to do that is to save my view in a public folder. That is not a possibility for us. We've tried active sheets and slices, but modifying is very limited with these options (adding rows and columns and moving around titles for example). We've also looked at using in-spreadsheet browser. This is exactly what we need because it works just like Perspectives. However, if I save the excel file and try to open it up again, my report disappears. Once i try to rebuild it, it doesn't rebuild my report, but rather, it rebuilds the "default" report (which is not useful in any way). Does anyone know of a way to save in-spreadsheet browser reports that can be easily modified and shared?
-
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: Saving in Excel
You need to decide whether you are talking about building interfaces for reports, guided analysis or ad hoc analysis. These are three distinct classes and it seems you are getting the concepts confused.
In terms of the ISB as a choice for ad hoc analysis it's not a bad one. The ISB is just an alternate UI for browsing cube views (alternatives being Perspectives/Architect cube viewer or TM1Web cube viewer). The main thing that you need to consider with cube views (in any interface) is that the view is just a query and "saving the view" is just saving the query parameters, any time the view is refreshed the data is always live from the cube and will never be a reflection of as things were when the view was "saved". That being the case when you open a ISB cube view the title elements and row and column headers (that is all "query parameters") will be reset to the view that has been named in cell A1 of the spreadsheet containing the ISB ActiveX control. This will be in the form <cube name> - <view name> - ViewN. If you have re-arranged the layout of the ISB view different from the starting view and want to preserve the new layout then you need to either 1/ save this as a new (public so it can be accessed by others) view or 2/ update the view named in the ISB to reflect the new layout of query parameters.
In terms of the ISB as a choice for ad hoc analysis it's not a bad one. The ISB is just an alternate UI for browsing cube views (alternatives being Perspectives/Architect cube viewer or TM1Web cube viewer). The main thing that you need to consider with cube views (in any interface) is that the view is just a query and "saving the view" is just saving the query parameters, any time the view is refreshed the data is always live from the cube and will never be a reflection of as things were when the view was "saved". That being the case when you open a ISB cube view the title elements and row and column headers (that is all "query parameters") will be reset to the view that has been named in cell A1 of the spreadsheet containing the ISB ActiveX control. This will be in the form <cube name> - <view name> - ViewN. If you have re-arranged the layout of the ISB view different from the starting view and want to preserve the new layout then you need to either 1/ save this as a new (public so it can be accessed by others) view or 2/ update the view named in the ISB to reflect the new layout of query parameters.