Exporting random values in range 1-6 to txt

Post Reply
vasek1192
Posts: 47
Joined: Sun Jan 24, 2021 5:55 pm
OLAP Product: IBM Planning analytics
Version: 2.0.9.3
Excel Version: 2019

Exporting random values in range 1-6 to txt

Post by vasek1192 »

Hi,

I am attempting to export random value in range 1-6 into txt file on desktop. I am getting File not found error message. Any idea what might be wrong here? Thanks.

Code: Select all

LoopCounter = 1;
Result = 1;
OutputFile = 'C:\Users\Vaclav.Novacek\Desktop\test.txt';


WHILE(LoopCounter <= 5);
            Result = Result + rand();
    LoopCounter = LoopCounter + 1;
END;

Output = NumberToString(Result);
AsciiOutput(OutputFile, Output);
Attachments
Location.PNG
Location.PNG (73.81 KiB) Viewed 2215 times
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Exporting random values in range 1-6 to txt

Post by Wim Gielis »

TI executes the process on the server, while you might be referring to the desktop on your PC. Is that the case ?
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
vasek1192
Posts: 47
Joined: Sun Jan 24, 2021 5:55 pm
OLAP Product: IBM Planning analytics
Version: 2.0.9.3
Excel Version: 2019

Re: Exporting random values in range 1-6 to txt

Post by vasek1192 »

Hi, thanks for the reply. I beleave so.
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Exporting random values in range 1-6 to txt

Post by Wim Gielis »

Then you know the answer, the remote server does not know your own PC.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
vasek1192
Posts: 47
Joined: Sun Jan 24, 2021 5:55 pm
OLAP Product: IBM Planning analytics
Version: 2.0.9.3
Excel Version: 2019

Re: Exporting random values in range 1-6 to txt

Post by vasek1192 »

Damn. Thanks for the answer.
Post Reply