SQL Server Performance

Dynamic security for dimension

Discussion in 'Analysis Services/Data Warehousing' started by Mahesh B. Paranjpe, Jul 25, 2005.

  1. Mahesh B. Paranjpe New Member

    I would like to know about security if any body is having idea about it.

    I am having dimension in which there are four levels. The data must be seen to a user which is pertaining to his or her level. There are n number of users who is going to access this application

    My dimension is as follows.

    DU (Delivery Unit)
    Account
    Project
    Subproject.

    If I am users and working on subproject then I should be able to see data up to subproject.In another case if I would be having access up to project level then I should able to see subprojects which are in my projects only. The same will be treated for above levels (Account, DU).

    Your help is appreciated!
  2. Raulie New Member

    You can enforce this type of security using the Cube Role Manager in analysis services even at the member level. Look up "Custom Rules in Dimension Security" in BOL.




    Raulie
    hp

  3. Mahesh B. Paranjpe New Member

    Thnaks for your reply.

    Can you give me an example or site reference which will guide me about problem?

  4. Raulie New Member

    Actually when I had to implement dimenion level security I used BOOKS ONLINE (BOL) as a reference and it provided me with everything I needed.

    Raulie
    hp

Share This Page