TextOutput and ASCIIOutput Capabilities

Post Reply
bsl
Posts: 2
Joined: Fri Oct 29, 2021 8:00 pm
OLAP Product: TM1, PA
Version: 2.08x64
Excel Version: 2008

TextOutput and ASCIIOutput Capabilities

Post by bsl » Mon Nov 01, 2021 1:12 pm

Hi all,

I had a brief question regarding the write out capabilities that are available within a TI Process. I've looked at some of the documentation for TextOutput (/https://www.ibm.com/docs/en/cognos-tm1/ ... textoutput)and ASCIIOutput (/https://www.ibm.com/docs/en/cognos-tm1/ ... sciioutput). It does mention in the documentation the following :

"if the server is running on the C: drive and TextOutput is writing to the F: drive, and the F: drive runs out of space, the error will be trapped and the server remains alive. If the server is running on the C: drive while TextOutput is also writing to the C: drive, and that drive runs out of space, the server will terminate (as expected)."

Does this mean that writing out data from a TI process is limited to just the file location on my machine where I have the application downloaded on? My main question is ultimately wondering if it was possible to have a TI Process write to a SharePoint location, as I am unable to get this to work despite the TM1 System Account having access to the specific SharePoint site that I am desiring to write to.

A follow on question for this would be if it is possible to parameterize the file name to the folder destination in the process. I believe this is possible as long as the file extension was specified but given some of my permissions on my machine, I have been unable to test.

Many thanks!

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

Re: TextOutput and ASCIIOutput Capabilities

Post by Steve Rowe » Mon Nov 01, 2021 3:28 pm

TI text output is done from the perspective of where the TM1 database is running and what the account that the TM1 database is using has rights to.

The bit in the help about the C and F drives, is a long way of saying that the if the disc that the TM1 DB is using for data and logging runs out of space then the database will fail. So if you think may be generating a huge file then don't do it on this drive.
Technical Director
www.infocat.co.uk

bsl
Posts: 2
Joined: Fri Oct 29, 2021 8:00 pm
OLAP Product: TM1, PA
Version: 2.08x64
Excel Version: 2008

Re: TextOutput and ASCIIOutput Capabilities

Post by bsl » Tue Nov 02, 2021 12:27 pm

Gotcha - so even if the TM1 database would have access to the SharePoint location, it may not be able to write to it because it is not actually running in the same location as to where the SharePoint site is hosted?

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

Re: TextOutput and ASCIIOutput Capabilities

Post by Steve Rowe » Tue Nov 02, 2021 3:31 pm

Maybe....
If the TM1 DB account has sufficent access so the file location is visible with write access over the network then TM1 should be able to write to the location.
You would need to be writing to afully qualified location i.e. \\computername\folders\etc and to a shared drive (T:\MyFolder\).

Often you would plan to export to a folder on the TM1 DB server for performance reasons but it is not required.
Technical Director
www.infocat.co.uk

Post Reply