String operations to get it right
We have seen one example of doing string manipulation in a macro to swap the columns of slicer in Working with Dimensional Model chapter. In this recipe, I will show you more macro functions to manipulate the values and achieve the required functionality using them.
A report is required to show sales by date and product lines. This report should show data only for current month (full month).
Getting ready
Create a simple list report with Date, Product line, and sales Quantity as columns.
How to do it...
- Open Query Explorer. Go to the query used by the list object.
- Add a new detail filter and define it as:
[Date] between ...
Get IBM Cognos 8 Report Studio Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.