Print Page - multi select tree prompt

Title: multi select tree prompt
Post by: dfreed on 30 Oct 2007 02:42:31 PM

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?

Title: Re: multi select tree prompt
Post by: rockytopmark on 30 Oct 2007 03:17:50 PM

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

Title: Re: multi select tree prompt
Post by: dfreed on 30 Oct 2007 03:38:52 PM

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?

Title: Re: multi select tree prompt
Post by: rockytopmark on 30 Oct 2007 03:59:59 PM

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.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Analysis Studio => Topic started by: dfreed on 30 Oct 2007 02:42:31 PM