none
Difference between these two in deny permission RRS feed

  • Question

  • When you do some deny permission to get access to the data, why does SSAS has one cube and the rest is dimensional table before processing to make deny access. What is the different?

    Friday, December 13, 2013 7:25 AM

Answers

  • Hi Sakura,

    As you can see on the project, the Adventure Works is a cube on AdventureWorksDW2012Multidimensional-SE database. When selecting Customer dimesion on the cube level, the dimension name dispaly on the textbox is:AdventureWorksDW2012Multidimensional-SE.Adventure Works.Customer. It's a cube level dimension. When selecting Customer dimension on dimensional table level, the dimension name dispaly on the textbox is:AdventureWorksDW2012Multidimensional-SE.Customer. It's a database level dimension.

    Regards,


    Charlie Liao
    TechNet Community Support

    Tuesday, December 17, 2013 7:40 AM
    Moderator

All replies

  • Hi Sakura,

    As you can see on the project, the Adventure Works is a cube on AdventureWorksDW2012Multidimensional-SE database. When selecting Customer dimesion on the cube level, the dimension name dispaly on the textbox is:AdventureWorksDW2012Multidimensional-SE.Adventure Works.Customer. It's a cube level dimension. When selecting Customer dimension on dimensional table level, the dimension name dispaly on the textbox is:AdventureWorksDW2012Multidimensional-SE.Customer. It's a database level dimension.

    Regards,


    Charlie Liao
    TechNet Community Support

    Tuesday, December 17, 2013 7:40 AM
    Moderator
  • When you are denying permissions to users in a role in SSAS, you have the option of denying permission to the cube dimension or the database dimension. What is the difference between these two?

    Tuesday, December 17, 2013 9:11 AM