Export csv file dynamically with title = text + {currentdate}

[BennyD]

Hi everyone,

I've looked around and can't find another post on this subject.

I am using IBM Cognos 10 > Cognos Planning - Analyst.

I have created a macro which takes a snapshot of a DCube and exports the snapshot to csv file in a certain location.

My requirement is to save this csv file with a generic title like TestFile1, and add the current date on the end, like TestFile1(03122014).csv.

With my limited experience I can't work out how to do this. Does anyone have any ideas or know of a different way to achieve what I want? Which is essentially to have an archive library with lots of historic snapshots of my DCube.

If the file was named the same everytime then it would overwrite everytime, correct?

many thanks in advance for your help,
Ben

[StuartS]

Hi

I have never done this, so not sure if you can.

You could try to look at the use of variables in a macro.

If you cant do in analyst then perhaps consider using a bat file called from windows scheduler?

Stuart

[BennyD]

Thanks for the reply Stuart, i'll have a go at the variables