SAP BOBI 4.0: Data Security Profile Issue

[Former Member]

Consider the below scenario :

We have two environments(SAP BOBI 4.0): Dev and Prod

Schemas used are test and testABC in DEV and Prod respectively. And structure (table
names and column names) inside both the schemas is same.

We have created several data security profiles in Dev
environment. So now when we migrate via Promotion Management, the universe from Dev to Prod, “data
security profiles” also gets migrated.

So once migrated we change schema name from test to testABC
in data foundation layer which makes our dfx to point to testABC schema in
Prod.

Once above process is done when we go to data security
profiles, table names gets changed from test to testABC But inside WHERE
Clause, schema name is still test it doesn’t gets changed to testABC.

Now question is  :

1. Is there any way so that schema name inside
   WHERE Clause should get changed automatically from test to testABC?
2. Is there any way we can restrict Data Security
   profiles to get migrated when we are migrating the universe?

[Former Member]

Hi Atul,

Universe CAN be migrated from Dev. env. to QA/Prod environment without Data security profiles. Its a choice whether you want it to be migrated along with the universe.

Please consult your Admin team.

[Former Member]

Hey SAP BO experts, Can I have any inputs for the resolution of this case.

[Former Member]

What is your data source? Did you try to edit the security profile in where clause?

Is there any way we can restrict Data Security

profiles to get migrated when we are migrating the universe? - You can only exclude to promote User/Folder/Object security, not inside the Universe.

[Former Member]

Data Source is SAP HANA. Yes, We can edit the security profile in Where clause But again If we have restricted multiple tables for multiple roles then editing roles everytime when migration is happening would be a huge task.