crosstab report context filter

[avuong6]

in report studio, is it possible to set context filters by passing a parameter to it from a parameter page? if possible, how is this done? (i know that you can prompt directly from the context filter, but that generates 2 separate prompt pages.)

[BigChris]

Not entirely sure what you're driving at, but you can certainly build a prompt page with all of your parameters on it...

[avuong6]

i currently have a context filter set for product. instead of having it static, i would like to create a prompt on my prompt page to have the user select the product from the hierarchy. how do i do this correctly? i currently have 2 value prompts. 1 for product hierarchy and 1 for product. the first one lets the user choose the specific product hierarchy and then passes the result to the second prompt. the second prompt should filter on that specific hierarchy and allow the user to choose children of that hierarchy. since my report is a crosstab, is my issue because i have using a value prompt? should it be a different prompt type? how do i define a slicer to return only the members of that hierarchy to the prompt for selection by the user? i ve done this in a list report, but cube reporting obviously functions a little differently.

[BigChris]

Ahhh...here's the crucial bit of information that was missing in your original question:

but cube reporting obviously functions a little differently

The methods Cognos uses for dimensional reporting is quite different to relational reporting. I'm not the expert on that, but I know that you need to look at Filter expression in your data and Slicers rather than detail filters etc.

[bdbits]

So you have a prompt macro in the context filter? And this is causing an extra prompt page? To avoid the generated prompt page, you need to put a prompt control on your prompt page that is linked to whatever name you gave the parameter. (That is the first argument in the prompt macro.)

You may want to look at a tree control if these prompts are all from the same dim. It will simplify the prompting quite a bit.