necto 16 training 19 - data security
TRANSCRIPT
Necto 16 Training Necto Data Security
Objectives• By the end of this lesson you will be able to perform Necto
Data Security setups• Necto security• Windows security• Mixed security• No Security
Agenda•Necto Data Security Administration
• Administrator• Application• Data Security
Necto Data Security Administration
Necto Data Security Hierarchy
Level 1
Level 2
Level 3
Necto Data Security Hierarchy Example
For User - John:Data Security was defined – You may not see the member “2015”.Application- OLAP security for which the user John can see the year “2015”.Administration- The security mode is “No Security”.Question - When John opens a WB with a time dimension, will he be able to see the member “2015”?
Necto Data Security Hierarchy Example Answer
John will not be able to see the member “2015” because data security is the highest level in the hierarchy and overrides all others!
Necto Data Security Administration level 1
• No Security• Necto• OLAP (Roles)• OLAP (User)
Necto Data Security Administration level 2
• Inherit• No Security• Necto• OLAP (Roles)• OLAP (User)
Necto Data Security level 3
• Necto Models• OLAP Models
Necto Data Security level 3
Within Data Access rights there are 3 levels of security precedence
Level 1 (lowest level) Dimension restriction mode
Level 2 (Mid level) Custom restriction mode
Level 3 (High level) Web service restriction mode
If NECTO Security Mode is chosen then Data Access rights become available
Necto Data Security level 3 (Sub Level 1)
Show a view just as a visual cue for creating the security
Select a Dimension, select members and choose the restriction type, then apply.
Necto Data Security level 3 (Sub Level 1)
Show MDX can help you create MDX for Slicer security if using component mode
Necto Data Security level 3 (Sub level 2)
Show MDX can from the sub level Dimension security can help you create Custom restrictions
Necto Data Security level 3 (Sub level 2)
Show MDX can from the sub level Dimension security can help you create Custom restrictions
Summary• In this lesson you have learned how to Setup the Data
security types:• OLAP• Necto• Mixed
• Necto Sub level security
Thank you, any questions?