How to create a specific file ?

Post Reply
beber005
Posts: 57
Joined: Mon Mar 03, 2014 2:18 pm
OLAP Product: Cognos
Version: 9.5.1
Excel Version: 2010

How to create a specific file ?

Post by beber005 »

Hello everyone, :)

I have a very difficult problem. I have already write a process which works but I want to optimize it. To sum up, I have one parameter cube which contains some information. These information are status.
A customer has many different statut, it depend on one specific date (year and month). My process creates an output file, associating status with a customer at a given date.
My problem is the following :
- I have two parameters in my process
- My process only creates a file for one year / month data
- I want to my process creates every month < or = to my parameter month and for each month create it can assign a status to a client
- Each month must be separated by a header that is of the following form:
"Aircraft_Prod_12_2013
Aircraft_Prod_12_2013 NA_PRD_12_2013
Aircraft_Prod_12_2013 NA_ANT_12_2013"
- These are the headers that need to change month by month

I don't know if my problem is well described beacause it is not easy to explain.

Thank's a lot to the community for helping me :))
lotsaram
MVP
Posts: 3702
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: How to create a specific file ?

Post by lotsaram »

Is this not the same question you asked here? http://www.tm1forum.com/viewtopic.php?f ... 707#p48707
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
beber005
Posts: 57
Joined: Mon Mar 03, 2014 2:18 pm
OLAP Product: Cognos
Version: 9.5.1
Excel Version: 2010

Re: How to create a specific file ?

Post by beber005 »

Yes, but I I wanted to write a new post to explain better the problem because I had ignored this development for some weeks and I are just recovering. But the problem is the same and I didn't success to do that
TrevorGoss
Community Contributor
Posts: 217
Joined: Thu Aug 15, 2013 9:05 am
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 14.0.6129.5000

Re: How to create a specific file ?

Post by TrevorGoss »

Hello beber005.

Any luck with your issue yet? has it been resolved by information in this forum?

If you want to create headers in your ASCIIOUTPUT and put data under each header, you can create the ASCII and the open it again by re creating it and placing your data under the headers.

My code below demonstrates what I mean:

Code: Select all

vHeader1 = 'Header1';     vHeader2 = 'Header2';                vHeader3 = 'Header3';

ASCIIOUTPUT('Z:\Headers.txt',vHeader1,vHeader2,vHeader3);

ASCIIOUTPUT('Z:\Headers.txt','Test1','Test2','Test3');
The 'Test' data goes under each header.

Does this help at all?
Post Reply