SAS OLAP Cube

[SwapnaKumari]

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

[LinusH]

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?

[skturaga]

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.