TM1 Forum

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?

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

Yonks ago I tried using Excel as an ODBC source and it worked. This wasn't with TM1 though.

David Usherwood wrote:Yonks ago I tried using Excel as an ODBC source and it worked. This wasn't with TM1 though.

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.

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

Viet wrote: Yes TI works well with ODBC on Excel files.

Don't forget to name the table range and provide a header row.

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.

Also, have you tried it with a passworded workbook as per the original question, or only with unpassworded ones?

I tested it on TM1 9.4 MR1, and Excel 2007.

Passworded files cannot be used, it seems.