how you create security to cubes ?????

Answer Posted / joydeep

you can have user class views and dimension views.
dimension views help you to hide or remove certain data
from the cube depending on what view you are using. then
you can use the user class views to the cubes for making
that data available for a certain role or group. you can
also use both views in conjunction as a way to provide
security.

password protection is another way of providing security to
the cubes.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by junk dimension?

799


Can you define fan trap?

1006


What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.

2333


---------------Tell me about DWH Concepts?

1835


What are the ways to import data into catalog?

832


Name the types of report?

726


What is difference between content store and content manager?

735


What is meant by Reportstudio shortcut?

1915


What is main advantage datawarehousing over oracle?

756


Define query items?

778


How can I test reports in cagonos?

749


What is Additive function?

1742


What is metric store database?

742


Cleared COG-112 with 100% score today. What next certification should i go for?

1601


Define report item?

862