SAS OLAP Cube

Reply
Contributor
Posts: 44

SAS OLAP Cube

Hi All,

I am working to identify how can I achive below points using SAS OLAP cube studio for one of my project:-

  1. Restrict user to view detail and summary report. like some user should only be able to see summany report and some should only see detail report.
  2. How to do security subset.
  3. How to data Masking.

Can anyone please guide me on this.

Regards,

Swapna

Super User
Posts: 5,386

Re: SAS OLAP Cube

What you ask for is more a less a complete knowledge transfer and some design decisions - not well suited for community question.

Try to dig into the documentation and papers on the subjects, then try to post some more narrow/specific questions.

1. Restrict on report level - use metadata authorization together with report objects.

2, By MDX, metadata, Information Maps...

3. By MDX, Information Maps... What is your masking requirements?

Data never sleeps
New Contributor
Posts: 3

Re: SAS OLAP Cube

Swapna,

I agree with Linus, in addition http://support.sas.com/documentation/cdl/en/olapug/59574/PDF/default/olapug.pdf might help you understand user restrictions better.

Sri.

Ask a Question
Discussion stats
  • 2 replies
  • 160 views
  • 0 likes
  • 3 in conversation