Page 1 of 1
'Get data' function in TM1.
Posted: Wed Dec 08, 2010 1:54 am
by jbcraigs
Cognos Enterprise Planning had the 'Get Data' function with quickload which the user could use to upload the excel sheet directly into Contributor, provided the excel sheet looked similar to the cube.
In TM1 Contributor 9.5.1 how can you achieve similar functionality?
Thanks.
Re: 'Get data' function in TM1.
Posted: Wed Dec 08, 2010 2:01 am
by Martin Ryan
There's copy and paste. Or DBS directly from the Excel spreadsheet into TM1. Or Alan's paste-over-dbrw tool in the
TM1 tools add-in.
There's no special way to get data from Excel to TM1 Contributor because it would be much easier to use the Excel add-in to go directly from Excel to TM1.
Martin
Re: 'Get data' function in TM1.
Posted: Wed Dec 08, 2010 3:13 am
by lotsaram
By far the easiest is simply copy the range in Excel and then paste to the cube view in TM1 Contributor (or TM1web).
Re: 'Get data' function in TM1.
Posted: Wed Dec 08, 2010 9:47 pm
by jbcraigs
Thanks for the response. I will look into the Tools you mentioned.
Re: 'Get data' function in TM1.
Posted: Thu Dec 09, 2010 1:30 pm
by stephen waters
lotsaram wrote:By far the easiest is simply copy the range in Excel and then paste to the cube view in TM1 Contributor (or TM1web).
I think this is OK for occasional ad-hoc stuff but, if I were an end-user, I would not do this on a regular basis without complaining.
As other posters have pointed out, for this sort of functionality probably best to consider the more traditional TM1 approach using Excel with DBS\DBSW's
How will you be using this functionality and is there a particular reason you want to use the Contributor front-end?