Default Selection for Tree Prompt

[billylodz]

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?

[billylodz]

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

[rellaize]

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

[sheridan06]

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

[atamkaan]

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?