Upload Excel-Sheets to TM1 Web
-
MG03
- Posts: 2
- Joined: Wed Apr 06, 2016 2:41 pm
- OLAP Product: IBM Cognos TM 1
- Version: 10.2.2
- Excel Version: 2010
Upload Excel-Sheets to TM1 Web
Hello everybody, we are working on a reporting platform based on TM1 Web. Currently we are looking for an opportunity to upload several Excel-Sheets to the Server simultaneously. The upload of single Sheets is no problem, but due to the large amount of Sheets, it would be helpful to find another way. I am thankful für any help. With regards
-
tomok
- MVP
- Posts: 2836
- 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: Upload Excel-Sheets to TM1 Web
I assume you are talking about publishing Excel workbooks to the Applications folder? The answer is no. However, you may be able to write a VBA macro to assist with this. The reason I say "may" is because the Perspectives add-in does not expose the publish function as something that can be called. You would have to do some digging inside the add-in menu to see if you could copy what the menu does. I'm not sure you can do this. Never tried it.