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

Grouping based on Conditional Formatting

Started by DAkridge, 01 Dec 2009 10:30:24 AM

Previous topic - Next topic

DAkridge

I am trying to create a report that groups based off of a prompt.  I have set 6 static choices for the prompt and based on which choice the user chooses is what I want to group the report on, but I am not having any luck - any help would be appreciated!!

CognosPaul

The way I'm visualizing your request is:

The user is prompted to select 6 different fields, Years, Product Type, Region, etc.
The report is a list with 2 columns.
Column A is the field the user selects, while Column B is the measure.

This is easy to do. Make a query item called "SelectedField". The expression should be
#prompt('ParameterName','token','[PresentationLayer].
.[DefaultField]')#

The use values of the prompts should be the full field pointer.
UseDisplay
[Data].[Time].[Year]Year
[Data].[Products].[ProductType]Product Type

The same will also work for a dimensional source.

UseDisplay
[Cube].[TimeDim].[Year]Year
lastchild([Cube].[TimeDim].[Year].[All])This Year
filter([Cube].[Products].[ProductType],[Cube].[Measures].[Sales]<100)Products with less than 100 sales