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

Cascading filter

Started by cielo, 02 Jul 2021 09:17:33 AM

Previous topic - Next topic

cielo

Hi everyone, I would like to cascade source 2 drop-down filters, When I select a value from the first drop-down the greater values should show in the second drop-down filter, How can we achieve this in Cube reports?

Thank You

MFGF

Quote from: cielo on 02 Jul 2021 09:17:33 AM
Hi everyone, I would like to cascade source 2 drop-down filters, When I select a value from the first drop-down the greater values should show in the second drop-down filter, How can we achieve this in Cube reports?

Thank You

Hi,

As this looks like a reporting question, I have moved the post to the Reporting board.

The first point I'll make is to recommend you avoid using detail filters in any report based off a cube. At best they can be hugely inefficient, and at worst they can return incorrect results. Instead, use dimensional expressions within your report. For example, if you wanted your crosstab rows to be the result of a prompt for Product Type members, instead of dragging in the Product Type level then adding a prompt with a detail filter, instead drag in a query calculation as your rows, and use the expression

[your Product Type level] -> ?Your Product Type parameter?

Then add a value prompt for ?Your Product Type parameter? - this prompt has its own separate query to populate the list of Product Type members in the prompt.

If you need this list of Product Type members to be the result of another prompt, go to the query for the Product Type prompt and change the expression of the item to be another dimensional expression that (for example) prompts for a Product Line and returns its children, which are Product Type members eg children([your Product Line level] -> ?Your Product Line parameter?)

Finally, add a value prompt for ?Your Product Line parameter? - this prompt has its own separate query to populate the list of Product Line members in the prompt.

Cheers!

MF.
Meep!