TM1 Forum

Hello all-

Is there any approach to source file from microsoft sharepoint.

For example, the product and location details are updated in sharepoint by customers. This file needs to be automatically read from processing from TI process.
A simple file with two columns Products and Locations and have around 10,000 rows. The TI process needs to automatically pull/read from sharepoint every day and process it to feed the cube.

Can this be done.

--Rgds, S

TM1 won't connect directly to a sharepoint file, they are saved on the server as a binary formatted image file, TM1 can't read those.

There are however quite a few tools out there to schedule the download of files from sharepoint to a specific location (your business may already have one), point one of these to that file and then at the TM1 server schedule it daily and bob's your uncle.

One for the new embedded Java feature in 10.2.2 I'd say. Google 'Java Sharepoint library' and lots of entries pop up.