If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Formatting exl report created by Analysis Studio

Started by techieaman, 02 Mar 2007 04:42:07 PM

Previous topic - Next topic

techieaman

Hello All,

I have a few Analysis Studio reports coming of from a Transformer build cube. End User requirements
of suppressing zeros and negative numbers to be converted into parenthesis are not being met in Analysis Studio.

For this I am planning to create a macro to call the exs saved and modify them.

need some inputs to such a macro. Or if someone has written something similar it will be of great help. I did write a macro in excel to format negative numbers, but unable to replicate the same in Cognos Script!.

Can anyone provide some help?

Thanks in advance.

Regards,

Aman