[SAP 4.2 SP3]LMCBIAR connection right problem

[Former Member]

Dear community,

I actually have a problem when I made a LMCBIAR with only the Universe.

For information, I can access only into the CMC for the destination environment.

When I promote this job :

Without the connection :

With the user security, I promote the job :

But when I want to create a WebI report, I have this error "You do not have th right to access data returned by this universe"

:

As I cannot access directly to the destination server, do you know how can I manage this problem ?

Thank you !

--------------------

EDIT:

-All action are made with Administrator or a user from the group "Administrator"

-"Connection" / "Application" / "Unvierse" have the hightest privilege level (Full control)

-I cannot take the connection as the SQL password on the destination environment is not the same as the source one

-After the promotion job, the connection information into destination environment is wrong as he tooks the connection information from the source environment, when we change the connection into the unvierse into destination environment and publish the universe, the error message disapear

[Former Member · Accepted solution]

Hello,

I made a new test on my workflow and the problem is now solved.

The problem was, the connection was created before to import the Universe, so the ID was different.

1- Create a LMCBIAR Universe + Connection

2- On the destination environnment I deleted the connection

3- Promote the LMCBIAR with the connection

4- Change the connection information into the Universe (as the connection was crushed) and publish the universe

From now, I can export / import the universe and the connection is not crushed