can someone please give an example on how to use ti to have a spreadsheet as a datasource which will be password protected to open and sheet protected. I've only ever used csv files.
And is it possible to load data from different sheets?
ti to load data from spreadsheets
- Martin Ryan
- Site Admin
- Posts: 1988
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: ti to load data from spreadsheets
It's not possible to use spreadsheets as a source to TI. The best you can do is save the file as csv then load from there. Or use DBS formulae.
Martin
Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer
-
- Site Admin
- Posts: 1457
- Joined: Wed May 28, 2008 9:09 am
Re: ti to load data from spreadsheets
Yonks ago I tried using Excel as an ODBC source and it worked. This wasn't with TM1 though.
- Alan Kirk
- Site Admin
- Posts: 6610
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: ti to load data from spreadsheets
I played around with that idea yesterday myself just out of curiosity; couldn't get it it to work with a TI. Named ranges, dollar signs after the sheet names, all the usual bumpf; none of the syntaxes flew because the TI "couldn't connect to the database". Also I did notice one MSDN article (didn't keep a reference to it as it seems to be academic now) which stated that it won't ever work with a passworded workbook, even if you supply the password which pretty much negated the OP's plans.David Usherwood wrote:Yonks ago I tried using Excel as an ODBC source and it worked. This wasn't with TM1 though.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Posts: 6
- Joined: Mon May 19, 2008 8:57 pm
- OLAP Product: TM1
- Version: 9.4 FP2
- Excel Version: 2003
- Location: France, Paris
- Contact:
Re: ti to load data from spreadsheets
Hi there,
Yes TI works well with ODBC on Excel files.
Don't forget to name the table range and provide a header row.
Viet
Yes TI works well with ODBC on Excel files.
Don't forget to name the table range and provide a header row.
Viet
- Alan Kirk
- Site Admin
- Posts: 6610
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: ti to load data from spreadsheets
Which version(s) have you done this on? Because that was exactly the configuration that I had when I tested it in 9.0 SP3 and it refused to read the data.Viet wrote: Yes TI works well with ODBC on Excel files.
Don't forget to name the table range and provide a header row.
Also, have you tried it with a passworded workbook as per the original question, or only with unpassworded ones?
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- MVP
- Posts: 3128
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: ti to load data from spreadsheets
I tested it on TM1 9.4 MR1, and Excel 2007.
Passworded files cannot be used, it seems.
Passworded files cannot be used, it seems.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly