Problem after connection override works

security CMC
1

Hi,

The connection override works as expected ,I noticed one problematic behavior :

After i override for example BD to BP in production ,BD is also visible in the list of connections

I don’t want users to see or use BD in BP,but when trying to change the rights to BD (nobody can view it ) – when the reports are opened in Webi there is an error massage : you don’t have right for BD connection ,seems like even after the override was done it uses the BD connection and searches for security rights; ….

Did anyone ever came across this issue ?

The reports are based on Bex Queries ,BW 7.5

Thanks

Yoav

yohab (BOB member since 2003-12-24)

2

If you’ve set up the override correctly, then your “BD” connection in production will have the production credentials. That is, you should only have one connection in production, named “BD”, which will be pointed at your production database.

joepeters :us: (BOB member since 2002-08-29)

3

Thanks joepeters for your reply

can you explain how define it correctly ?

i basically only did connection override,I didn’t define BD connection in Prod but i the override settings ,this is why i wonder from start why users can see it from first place

Thanks

Yoav

yohab (BOB member since 2003-12-24)

4

All an override does is change the credentials of a connection when it’s moved from one environment to another. So, when your “BD” connection is migrated from development to production (using Promotion Manager), it will be modified to use the credentials specified in the override. The connection will still have the same name as in the source.

joepeters :us: (BOB member since 2002-08-29)

5

thanks again

Are you saying there is a way to modify the BD connection name in the override settings before you import it to BP ?

yohab (BOB member since 2003-12-24)

6

No, just the credentials (database name, id, password, etc.)

joepeters :us: (BOB member since 2002-08-29)

7

that’s the stage i am trying to understand why is going that why,I only did the override settings but eventually I do see the BD connection new object in Prod system,I guess i’ll have to check the settings again

yohab (BOB member since 2003-12-24)

8

If you only created the override and did not migrate the connection, then the connection must be there from a prior migration.

The override doesn’t do anything itself - it just defines the credentials to be applied during a migration.

joepeters :us: (BOB member since 2002-08-29)

9

i’ll check if it’s because the dependency i marked in Dev as according to SAP note only if you mark the dependency ,the override will work

yohab (BOB member since 2003-12-24)