8.1 Explaining security part 2

Question 1

what is a workspace

Answer 1

• virtual workspaces, partition of SAC file repository
• users in workspace can share content
• content developers can collab
• content is only seen by the team
• any content ready for PROD is moved to public folder

Question 2

how to create, manage, delete workspaces

Answer 2

• workspace admin can do this through workspace mgmt tool

Question 3

SAC license types (3)

Answer 3

• BI named user
• Planning standard named user
• Planning Professional named user

Question 4

a single role can only consume 1 of these license types

Answer 4

• BI
• Planning standard
• Planning Professional

Question 5

a Planning profession license includes

Answer 5

Planning standard license

Question 6

a planning standard license includes

Answer 6

BI license

Question 7

how to define data access in a model

Answer 7

1. go to ‘Dimension Settings’ property of model
2. enable ‘Data Access Control’ for ‘Rights/Access’
3. Select the dimt
4. go to ‘Member details’, choose ‘Read/Write’ access for users

Question 8

if model has a privacy set so only certain roles can view, what do you do for data level security?

Answer 8

you need to have the role include the data access levels

Question 9

Model owners always have full read/write access in the model t/f

Answer 9

true

Question 10

what happens if data access is defined on a higher node

Answer 10

• it’s passed to the lower nodes

- if another access is defined on a lower node, that access would be used

Question 11

can a model have more than 1 data access control enabled dim?

Answer 11

yes

Question 12

features of a data access filter in a role (3)

Answer 12

• can only apply for models that have Privacy On
• can create multiple filters for one model
• if a dim has a data access enabled, the access filter will be based on top of this filter

Question 13

Filters can be defined on any property of the dim of the model t/f

Answer 13

true

Question 14

steps to apply model-based privacy settings (11)

Answer 14

1. Open a model
2. go to Model Preferences
3. Access and Privacy tab
4. in Data Access, enable Model Data Privacy
5. Save model
6. go to Navigation Bar > Security > Roles
7. select Assign Users user Planner Reportr found in Planning Standard
8. Select Model > Select New Model
9. Add Read Access/ Define Write Access
10. Add attributes
11. Ok and Save