ASCIIOUTPUT does not create output file

Post Reply
Rtel
Posts: 59
Joined: Tue Nov 13, 2018 10:15 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

ASCIIOUTPUT does not create output file

Post by Rtel » Fri Nov 20, 2020 6:17 pm

Hello, its strange that the ASCIIOUTPUT does not create the output .cma file at all

The code is very simple ....
ASCIIOUTPUT('/folder1/folder2/test1.cma', '1', '2', '3');

Its a linux server and running TM1 10.2.2

(I want to extract a view and that's not working either ...so I tried a simple code as above and even that's not working)

Any idea what's going on here ?

Thanks

Rtel

tomok
MVP
Posts: 2783
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: ASCIIOUTPUT does not create output file

Post by tomok » Fri Nov 20, 2020 6:45 pm

Rtel wrote:
Fri Nov 20, 2020 6:17 pm
Hello, its strange that the ASCIIOUTPUT does not create the output .cma file at all

The code is very simple ....
ASCIIOUTPUT('/folder1/folder2/test1.cma', '1', '2', '3');

Its a linux server and running TM1 10.2.2

(I want to extract a view and that's not working either ...so I tried a simple code as above and even that's not working)

Any idea what's going on here ?

Thanks

Rtel
Two things:

1) /folder1/folder2/ has to be a valid path and
2) The service account that the TM1 service runs under has to have security rights to create files in folder 1) above.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Wim Gielis
MVP
Posts: 2613
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.8
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: ASCIIOUTPUT does not create output file

Post by Wim Gielis » Fri Nov 20, 2020 6:59 pm

Try that code in the Prolog tab of the process.
If it's in the Metadata tab or Data tab and your views settings are not matching the view contents, it might be that no output is produced.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 117 TM1 articles and a lot of custom code
Newest blog article: Friday the 13th

Rtel
Posts: 59
Joined: Tue Nov 13, 2018 10:15 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Re: ASCIIOUTPUT does not create output file

Post by Rtel » Fri Nov 20, 2020 7:36 pm

Thanks Tomok,

1) the folder1 and folder 2 are valid path
2) I will check the service account access the folder on linux server

Thanks Gim

I ran the code in prolog and still the same issue

Thanks

Rtel

Rtel
Posts: 59
Joined: Tue Nov 13, 2018 10:15 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Re: ASCIIOUTPUT does not create output file

Post by Rtel » Fri Nov 20, 2020 7:37 pm

Sorry misspelled your name Wim

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

Re: ASCIIOUTPUT does not create output file

Post by Steve Rowe » Mon Nov 23, 2020 10:48 am

Try it with just the following on the prolog

ASCIIOUTPUT('test1.cma', '1', '2', '3');

This will write a file to the data directory, this will should work as the service account of TM1 will have rights to it's own directory.

If it doesn't then there maybe a problem arising from your Linux build of TM1.

If it works then the problem will be rights or the naming of the path as others have said.
Technical Director
www.infocat.co.uk

Rtel
Posts: 59
Joined: Tue Nov 13, 2018 10:15 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Re: ASCIIOUTPUT does not create output file

Post by Rtel » Wed Dec 23, 2020 6:06 pm

Hello, thank you for your feedback. sorry for the delayed response.

The code runs fine in prolog and it created an output (test.CSV) file.
Prolog
ASCIIOUTPUT('/folder1/folder2/TestOutput1.csv', 'a', 'b', 'c');

But when I run the asciioutput in data section on the same path it does not create file at all.

Data section
ASCIIOUTPUT('/folder1/folder2/TestOutput4.csv', Dim1, Dim2, Dim3, NumberToString(value));

Data source is a cube view.

Please let me know if its right issue where and how can I confirm. Or what else can be going on here ?

Wim Gielis
MVP
Posts: 2613
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.8
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: ASCIIOUTPUT does not create output file

Post by Wim Gielis » Wed Dec 23, 2020 6:17 pm

Are you really sure that your process enters the Metadata and Data tabs ? Did you check the view settings ?
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 117 TM1 articles and a lot of custom code
Newest blog article: Friday the 13th

Emixam
Posts: 95
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: PA 2.0.x
Excel Version: 2016
Location: The Internet

Re: ASCIIOUTPUT does not create output file

Post by Emixam » Wed Dec 23, 2020 6:25 pm

Rtel wrote:
Wed Dec 23, 2020 6:06 pm
But when I run the asciioutput in data section on the same path it does not create file at all.
It's most likely the metadata/data tabs that are not getting processed. If you put a random ProcessQuit() in the data tab, did your TI gets terminated with a ProcessQuit error ? If it doesn't, there is multiple threads on this forum explaining why you metadata/data tab are not getting processed.

If you are using a cube view as a source, then it means your view is empty. If you are creating the source view directly in your TI, make sure you have the right value for these 3 functions:

Code: Select all

ViewExtractSkipCalcsSet( sCubeName, sViewSource, 1);
ViewExtractSkipRuleValuesSet( sCubeName, sViewSource, 0);
ViewExtractSkipZeroesSet( sCubeName, sViewSource, 1);
**Edit: sorry, didn't saw Wim's answer
Sorry for my English :)

User avatar
gtonkin
MVP
Posts: 866
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.9.4; PAoC 2.0.9.3
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: ASCIIOUTPUT does not create output file

Post by gtonkin » Wed Dec 23, 2020 7:01 pm

Wim Gielis wrote:
Wed Dec 23, 2020 6:17 pm
Are you really sure that your process enters the Metadata and Data tabs ? Did you check the view settings ?
I often put a ProcessQuit at the end of Prolog then right-click the View that was created and Extract as text Data to check what has actually been assigned to each dimension in terms of subsets/elements. Won;t work with temp views/subsets.

I you have checked and the dimensions look correctly configured, you could try open the view but remember that it will not be zero suppressed for viewing unless you add have added ViewSuppressZeroesSet for testing.

Do you have a combination of N: and C: levels and/or rule based values? Per Emixam, you may need to check your ViewExtractSkipCalcsSet and ViewExtractSkipRuleValuesSet

Rtel
Posts: 59
Joined: Tue Nov 13, 2018 10:15 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Re: ASCIIOUTPUT does not create output file

Post by Rtel » Mon Jan 04, 2021 3:18 am

Thank you for all the responses,

I will check if Meta and data sections are processed at all or not.

Also the view is already manually created and is used as a data source. The data in the view is rule derived.

Thanks

Rtel

Post Reply