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

Swapping dimensions using MUN manipulation

When a prompt is based on a dimension, the selected value is passed as a full qualifier (MUN), not just the key. This results in a limitation of the prompt's use. We cannot use the prompt to filter any other dimension. In this recipe, we will see how to override this limitation by performing the string manipulation of MUN.

Consider a business case where a cube has two time dimensions (say Billing date and Transaction date). Users want a choice on the prompt page to select which time dimension to filter on. Also, they will select a Date (Year or Month) on the prompt page, so we need to filter the appropriate time dimension.

Getting ready

Here we will use the GO Data Warehouse (analysis) package where we have ...

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