Print Page - Default Selection for Tree Prompt

Title: Default Selection for Tree Prompt
Post by: billylodz on 09 Jun 2009 03:32:12 AM

Hi

I have cube with Product Dimension and security on this Dimension.
I need to set Default selection for the highest member/level of this dimension - all products the person has access to.

the report works fine if someone has access to "All Products" member, but if someone has access to one of member from lower level I get this error:
"PCA-ERR-0067 The Dimension Line must be set with only one member from any dimension"

any ideas haw to point default selection for Dimensiof if this is different for different users depeding of access?

Title: Re: Default Selection for Tree Prompt
Post by: billylodz on 09 Jun 2009 04:47:45 AM

Or maybe just option to not display prompt if the filter on query is Optional.

Title: Re: Default Selection for Tree Prompt
Post by: rellaize on 04 Nov 2011 04:27:04 AM

Did you ever find an answer to your problem? I have the same requirement. Any suggestions much appreciated.

Title: Re: Default Selection for Tree Prompt
Post by: sheridan06 on 25 Oct 2012 10:34:36 AM

we use JavaScript to handle these types of prompt issues when trying to prompt on a secured dimension in the cube

Title: Re: Default Selection for Tree Prompt
Post by: atamkaan on 21 Nov 2012 10:58:02 AM

Quote from: sheridan06 on 25 Oct 2012 10:34:36 AM
we use JavaScript to handle these types of prompt issues when trying to prompt on a secured dimension in the cube

Can you share an example with us?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: billylodz on 09 Jun 2009 03:32:12 AM