Row level Security in CMC level

[Former Member]

Hi,

Is it possible to apply row level security in CMC level.. Please help me

Regards,

G

[Former Member]

Hi Bhargav G,

Its strange to know that u got requirement to apply Row level restriction from CMC. Can u plz share your business requirements.??

Thanks & Regards,

Mahesh Bondula.

[Former Member]

Hi Bhargav,

I think you are referring to Profiles and Publications. Please check this post.

http://scn.sap.com/community/bi-platform/blog/2012/06/21/profiles-and-publication

Srini

[former_member190767]

Hi Bhargav,

Depending on your exact requirement there are two ways of enabling a kind of row restrictions...

1. on Universe Level

2. on Publication Level

if you require row level security for every user regardless if they refresh reports on demand or not, you need to apply row level security within the Universe. One main consideration to make is if you really want to apply this in the semantic layer, basically the best and most logical location to apply data security is on the DB level as this will be regardless the way you access your data as well you only have to apply it once.

Never the less, the Universe (both UNV & UNX) provides options to apply data security from the Semantic Layer. Although the principal is the same, the way how you configure the row level security settings are different between UNV and UNX (different design tools), for the exact process I'll recommend you to read the manuals for Universe Design Tool (English) AND/OR  Information Design Tool (English). once you have defined your universe, you can add restrictions to users/usergroups to prevent them in viewing specific data. For each universe you generate you have to re-apply this manually. You can leverage the SDK's to enable the copy of security settings to additional universes if you like to. However every change has to be executed in each universe against that data. Therefor the previously made recommendation is to have this in your DB level.

If your users are only receiving information via schedules, you could leverage the Publication model in combination with profiles OR dynamic recipients (as mentiond already by Srini).

Having the logic stored individually within the CMC is not possible!

Regards

Merlijn

[Former Member]

Thank you very much for ur reply

[Former Member]

Why you want universe row level security from CMC ? As based on BO  architecture anything related to data should controlled by CMC and anything related to admin should be controlled by CMC ?

Can you update your exact requirement that you want to fulfill using row level security from CMC?

[Former Member]

Elaborate the requirement ..

Are you asking the Universe Row level secuirty to be applied in some ways throgh CMC ??

[Former Member]

Thanks for ur reply Pathania

Yes how to apply row level security  in CMC ways

Regards,

G

[Former Member]

I dont think so there Is such a direct tfunctinality by which you can achive the row level secuirty  throgh CMC .

However you can utlize the feature  Profiles and Publications for Same .

Again you will have to analyze on aspects and findings whether it is appropiate approach for your scenario.