Problem with ASCIIOUTPUT

Post Reply
lynnsong986
Posts: 75
Joined: Wed Feb 28, 2018 2:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Problem with ASCIIOUTPUT

Post by lynnsong986 » Tue Nov 05, 2019 3:15 pm

Hello,

I keep getting process aborted error message (file A:\filename.csv not found)...sorry somehow I couldn't attach more screenshots...
Can someone please help?

DataSource is Cube View
Data Source Name: I chose a cube view named "Alectra-ES:SM_Depreciation->Download"

in Variables I have:
vTime
vProject
vtype
vMea
Value

in Parameters I set up pExportName as string with question "Enter File Name"

in prolog I have:
vCount = 1;
FilePath = 'A:\';

in Data I have:
If(vCount =1);
ASCIIOUTPUT(FilePath | pExportName | '.CSV', 'Period', 'Project', 'Type', 'Measure', 'Value');
vCount = 2;
EndIf;
ASCIIOUTPUT(FilePath | pExportName | '.CSV', vTime, vProject, vType, vMea, NumberToString(Value));


thanks so much!
Attachments
DataSource.PNG
DataSource.PNG (21.76 KiB) Viewed 368 times

tomok
MVP
Posts: 2638
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Problem with ASCIIOUTPUT

Post by tomok » Tue Nov 05, 2019 3:35 pm

lynnsong986 wrote:
Tue Nov 05, 2019 3:15 pm
I keep getting process aborted error message (file A:\filename.csv not found)...sorry somehow I couldn't attach more screenshots...
Can someone please help?
You're trying to write to a floppy disk on the server?????? A: is usually reserved for a floppy disk drive.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

lynnsong986
Posts: 75
Joined: Wed Feb 28, 2018 2:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Re: Problem with ASCIIOUTPUT

Post by lynnsong986 » Tue Nov 05, 2019 3:40 pm

I'm not sure how IT set it up but I had to put all of my CSV files on A: for TI to see them. This is the server drive. I actually tried to use a different path i.e. desk but the same error happened. Not sure how to fix this...

lynnsong986
Posts: 75
Joined: Wed Feb 28, 2018 2:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Re: Problem with ASCIIOUTPUT

Post by lynnsong986 » Tue Nov 05, 2019 3:41 pm

sorry I meant that I used filepath like 'C:\Users\lynn.song\Desktop\' but got the same error.

tomok
MVP
Posts: 2638
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Problem with ASCIIOUTPUT

Post by tomok » Tue Nov 05, 2019 3:45 pm

The user ID that your TM1 Server service runs under has to have the necessary security privileges on the server to be able to create and edit files in order to use ASCIIOUTPUT. I'm not talking about TM1 security, I mean the Windows security for the actual server machine.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

lynnsong986
Posts: 75
Joined: Wed Feb 28, 2018 2:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Re: Problem with ASCIIOUTPUT

Post by lynnsong986 » Tue Nov 05, 2019 3:50 pm

Thanks tomok for your help, I may not have the privilege on the server machine but why I can't export to my own desktop either?

lynnsong986
Posts: 75
Joined: Wed Feb 28, 2018 2:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Re: Problem with ASCIIOUTPUT

Post by lynnsong986 » Tue Nov 05, 2019 3:52 pm

would that be the same windows security reason? that means I need to go talk to IT department? thanks!

tomok
MVP
Posts: 2638
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Problem with ASCIIOUTPUT

Post by tomok » Tue Nov 05, 2019 3:53 pm

lynnsong986 wrote:
Tue Nov 05, 2019 3:50 pm
Thanks tomok for your help, I may not have the privilege on the server machine but why I can't export to my own desktop either?
You can't output to your own desktop because TI processes run on the server, not your local machine. Think about it......
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

lynnsong986
Posts: 75
Joined: Wed Feb 28, 2018 2:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Re: Problem with ASCIIOUTPUT

Post by lynnsong986 » Tue Nov 05, 2019 3:57 pm

ok thanks so much!! I guess I need to talk to the TM1 guy who set up all securities instead, really appreciated it!!

User avatar
gtonkin
MVP
Posts: 740
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: Problem with ASCIIOUTPUT

Post by gtonkin » Tue Nov 05, 2019 4:14 pm

If A: is a server folder/share, make sure that the account that is linked to the TM1 Service has access to it. TM1 will try and write with that account, not yours, unless you are linked on the service.

p.s. Tomok has mentioned this but just saying it a different way.

lynnsong986
Posts: 75
Joined: Wed Feb 28, 2018 2:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Re: Problem with ASCIIOUTPUT

Post by lynnsong986 » Tue Nov 05, 2019 7:17 pm

Thanks for the clarification! I found it a bit confusing as I do have access to the drive, but sounds like it requires more than that. I reached out to the TM1 mastermind in my company.

Post Reply