Search found 3 matches

by bhinbest
Thu Aug 21, 2008 8:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upload data from multiple files, Data Source set to None
Replies: 2
Views: 3217

Upload data from multiple files, Data Source set to None

Hello All, I've been using TM1 for approx. 3-4 years and am quite capable in most regards. However, I have only 1 years experience accessing data from any source other than an ASCII file. As such I've stumbled accross an issue I'm at a complete loss as to how to resolve. I'm trying to create a proce...
by bhinbest
Wed Aug 20, 2008 8:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI procedure to upload data from flat files.
Replies: 11
Views: 9811

TI procedure to upload data from flat files.

Hello All, I need to create a process that can retrieve data from .txt files in a specific folder. I believe their is a way to get TM1 to automatically retreive the data from the latest file(s) in the folder on a nightly basis. For example, every night a program is going to create a new .txt file wi...
by bhinbest
Thu Jun 26, 2008 8:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX Count rows in Excel Containing Data
Replies: 3
Views: 5968

TM1 MDX Count rows in Excel Containing Data

I'm trying to create a turbo integrator process in TM1 that will count the number of active rows in a selected Excel sheet, then add that number of elements into a dimension. These will be my transaction id's. For example the first time I run it, if the Excel sheet contains 1254 rows of data, the Tr...