COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: jimicron on 23 May 2007 12:29:28 PM

Title: Is there a "skip" step or a way to "skip" in a macro?
Post by: jimicron on 23 May 2007 12:29:28 PM
Hi all,

Is there a way to skip steps within a macro?

For example, let's say my macro is set up to export data to 6 different .csv files.  I run this on a weekly basis.  However, let's say some weeks I don't want to update the 5th (for example) .csv file but I do want to update 1-4 and the 6th.  Is there a capability or a way within a macro to provide this sort of "out" or way to run the macro, but be able to exclude certain steps?

Thanks a lot!

JIM
Title: Re: Is there a "skip" step or a way to "skip" in a macro?
Post by: ovo on 30 May 2007 06:10:47 PM
Macros are just sequential with no branching or logic functionality.  You would need to build 6 seperate macros and use a process control tool to call them with the logic you require.
Title: Re: Is there a "skip" step or a way to "skip" in a macro?
Post by: jimicron on 01 Jun 2007 10:30:58 AM
What do you mean by process control?  Can you give an example?  Thanks!
Title: Re: Is there a "skip" step or a way to "skip" in a macro?
Post by: ovo on 05 Jun 2007 10:42:49 AM
I am thinking of a 3rd party application such as UC4, etc.

In a primative sense you could look at simple batch files, if the command line executor returns an ERRORLEVEL value?

http://en.wikipedia.org/wiki/Errorlevel

Not totally sure it does, just ideas to investigate.
Title: Re: Is there a "skip" step or a way to "skip" in a macro?
Post by: ykud on 09 Jun 2007 03:51:19 AM
Quote from: ovo on 05 Jun 2007 10:42:49 AM
I am thinking of a 3rd party application such as UC4, etc.

In a primative sense you could look at simple batch files, if the command line executor returns an ERRORLEVEL value?

http://en.wikipedia.org/wiki/Errorlevel

Not totally sure it does, just ideas to investigate.

It can be done via siimple batch files. IFs work there.