Help with Dimension Security

Hi, I am trying to enable dimension security on my date dimension. I have created an attribute called [inc date] which has a value of Y or N as applicable. If I use the following syntax in a mdx query then all is fine:

filter([dates].[dates period].members,[dates].[date period].currentmember.properties("Inc Date",TYPED)) = "Y"

However if I use the same syntax in the Allowed Set MDX, it validates fine, but when I try and browse the cube with the role with the security defined I get an error telling me that the generated dimension security expression is not valid.

Please advise on what I'm doing wrong.

Thanks

[675 byte] By [GarethBowen] at [2008-1-4]

«« changing the report to view in reportViewer during runtime
»» Extended Stored Procedure Error

# 1

Try setting the Allowed Set definition on the [Inc Date] attribute. It should look something like this:

[Dates].[Inc Date].[Inc Date].& Yes

I'm assuming the values "Y" and "N" are your keys.

By defining the allowed set on the [Inc Date], you will affect which values in the rest of the Date dimension are available. This is through the internal auto-exists functionality.

Hope that helps,
Bryan

BryanC.Smith at 2007-9-26 >