@variable('BOUSER')

building semantic layer
1

We have a connection set up which uses @variable(‘BOUSER’) to access our oracle warehouse. It works in the old UNV universe. But if I open the exact same connection in the IDT interface, it won’t connect and gives me an “invalid username/password” error.

Debbie

Debbie :uk: (BOB member since 2005-03-01)

2

I don’t know if this will resolve it but try with a username with a simple password like “123456”.

NycPriya (BOB member since 2010-11-04)

3

Try with the user name as the end users will use so they have put BOUSER. you can your client and he will provide you. We got the same situation in freehand sql in 3.1

surya_sudheer :india: (BOB member since 2006-11-01)

4

Update from our SAP support guys: @VARIABLE is no longer supported in the credentials for a connection in IDT.

Screws up our security completely.

Debbie

Debbie :uk: (BOB member since 2005-03-01)

5

Blimey :blue:

Mak 1 :uk: (BOB member since 2005-01-06)

6

Did they give you a reason for that? Was that by design, or a stupid oversight?

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

7

No explanation. Something to do with being able to use “Business Objects Credential Mapping” instead, which doesn’t really help in our case. Need to get our DBA onto it as we’re currently using oracle to handle the security side and I don’t know what I’m talking about!

Debbie

Debbie :uk: (BOB member since 2005-03-01)

8

More here:-

http://scn.sap.com/thread/3494032

https://na5.brightidea.com/ct/ct_a_view_idea.bix?c=E445BDF0-DEF5-4D6A-8A1D-519A4D301682&idea_id=A5BAF51D-0C9E-49AE-B0FE-2B1E819C2A72&tag_filter=connection&current_tab=Status&status_tab=Submitted&row_num=3&getparameters=1

Mak 1 :uk: (BOB member since 2005-01-06)