O'Reilly logo

IBM Cognos 10 Report Studio Cookbook - Second Edition by Abhishek Sanghani, Ahmed Lashin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

String operations to get it right

We have seen one example of performing string manipulation in a macro to swap the columns of a slicer in Chapter 7, Working with Dimensional Models. In this recipe, I will show you more macro functions to manipulate the values and how to achieve the required functionality using them.

Let's say that a report is required to show sales by Date and Product line. This report should show data only for the current month (full month).

Getting ready

Create a simple list report with Date, Product line, and Quantity as columns:

Getting ready

How to do it...

In this recipe, we will see how to use some useful macro functions like current_timestamp ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required