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

how to take data from different columns and use them for prompt

Started by alex_, 23 Nov 2012 03:25:44 AM

Previous topic - Next topic

alex_

Hi All,
I use dimensional model.
In the table has several columns which are indicators, they contain three types of values.
The table and the columns looks like this:



|Dispute Cycle Time IND|OTD xSeries in Time IND|BA Project Based Services IND|BA Annuity Services IND
|A|G|A|R
|G|A|G|G
|R|A|A|A

Should make a prompt, which displays (('А', 'R' или 'G') i.e. the contents of columns) the selected symbol to refer to all columns in this way makes filtration.
In another way stated.
How to merge different columns in a prompt, which not to display the column names and their content.

In this photo is the result that should be filtered. Should show only ('A'.'R')

Thanks.

bdbits

You could build an expression as part of your report query that concatenates the columns together. Use this same expression in a query for the prompt, then when filtering check if the query item is equal to the selected prompt value. If I understand your requirements correctly, that should do the trick.