Search found 3 matches
- 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...
- 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...
- 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...