Home > SQL Analysis Services > SSAS 2008 Dimension Security Issue

SSAS 2008 Dimension Security Issue

Today, I’m modifying the cube dimension security. After processing the cube successfully, everytime I try to connect to the cube, i get the following error message: The XXX attribute in the YYY dimension has generated dimension security expression that is not valid, shown as below.
After searching the Internet, I found Chris Webb wrote the following statement in his blog (http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!1563.entry):
"Another thing to note is that if you are using role-playing dimensions in your cube, you will need to set dimension security on the cube dimensions rather than the underlying database dimension. For example, in Adventure Works, if you go to the Date dimension in the list of database dimensions (in the dimensions drop down on the Dimension Data tab of the Roles editor, database dimensions are listed first, then cube dimensions second) and set dimension security say to allow access to one year in the Calendar Year attribute, you’ll get an error like "The ‘Calendar Year’ attribute on the ‘Ship Date’ dimension has a generated dimension security expression that is not valid". Setting the same permissions on each of the role-playing dimensions in the cube based on Date, ie Ship Date, Delivery Date and Date does not cause a problem. "
This is exactly the causse of my problem. I have to set the dimension security on cube dimension instead of database dimension to make it work.
Categories: SQL Analysis Services
  1. Qais Al-Shalabi
    August 15, 2011 at 9:31 pm

    thanks for this usefull info!!!

    Qais Al-Shalabi

  2. Goose
    June 14, 2013 at 12:37 am

    thanks thanks thanks!!!

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: