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

multi select tree prompt

Started by dfreed, 30 Oct 2007 02:42:31 PM

Previous topic - Next topic

dfreed

I have a dimension set up as a Go To Parameter, and when I run the report I get a tree prompt as expected.  However, I'd like to be able to select multiple values within the tree (e.g.  select some customers for a particular sales rep).  Any idea how this is done?

rockytopmark

1).  Remove the Go To from your Query item. (Go To designates a single member only, not a set.)  Leave only the path to the Hierarchy. For example:

[great_outdoors_company].[Products].[Products]
...which is in the form...
Namespace.RegularDimension.Hierarchy

2).  Add a filter:
[great_outdoors_company].[Products].[Products] IN ?prod?

You will get a multiselect Tree Prompt

dfreed

thanks for the quick response, rockytopmark.  I didn't know we could add parameters to an Analysis Studio report (all my training has been in Report Studio).  How can I create a filter like you suggested on a context item?

rockytopmark

Sorry.... I didn't notice the Forum when I replied... and that this is Analysis Studio.

I do not have any experience in that application with this type of situation.