Uploading data with PAW/PAX

Post Reply
20 Ton Squirrel
Posts: 8
Joined: Tue Jul 14, 2020 9:53 pm
OLAP Product: TM1
Version: 11.7.00002.1
Excel Version: Office 365

Uploading data with PAW/PAX

Post by 20 Ton Squirrel » Wed Sep 09, 2020 9:40 pm

I have a script that generates a CSV file on a quarterly basis. This file needs to be uploaded and digested by TM1... hopefully by the end-user, not me. I want to develop the system and leave the analysts to do their work.

I devised a TI process in PAW that uploaded the file to the server and digested it properly. This was exciting but there are two issues:
  • I want to prompt the user for the file to upload (not a deal breaker if I just need to output the file to a static location/name)
  • My company is only licensing PAW for developers... meaning, no analysts could use this process
Can PAX execute the same sort of procedure to upload data?

Everything I've searched out thus far says nope, but I'm a newb-nugget on TM1. Any ideas?

User avatar
Steve Rowe
Site Admin
Posts: 2083
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Uploading data with PAW/PAX

Post by Steve Rowe » Thu Sep 10, 2020 12:48 pm

On the license side, you can point an action button at the TI process and the user can access this from within Excel or TM1 Web. No PAW license required for this.

You could put your TI process in a chore with some added code that checks for the existence of the file and then runs the load at the end of the load the TI can move the file to another location (and so the chore stops loading the file on the next pass). No need to involve the users at all then.

Cheers,

20 Ton Squirrel
Posts: 8
Joined: Tue Jul 14, 2020 9:53 pm
OLAP Product: TM1
Version: 11.7.00002.1
Excel Version: Office 365

Re: Uploading data with PAW/PAX

Post by 20 Ton Squirrel » Fri Sep 11, 2020 4:25 pm

Thanks for the response, Steve! It is good to know that a process CAN do this sort of thing from Excel.

I should've mentioned the other complication: the TM1 server is isolated from the company network. The folk in networking are stingy about security so only another developer and I have a login to access it. It's like flying to the moon to develop on this thing. :T

I was told I might be able to get a login just for transferring files up to the server. Seems like that would be the way to go:
  1. The user executes a process that transfers the file from local to server (using special login credentials)
  2. Have either:
    • A chore monitors the directory and consume file
    • The same process used to transfer proceeds to consume file
Seems like the latter option would be best.

I just gotta convince the dark & hungry network gawds to afford me a special login. Too bad all this working from home prevents strolling into the server room with bribery-flavored donuts. ;D

Post Reply