Unable to create Bex query on Transient provider
I have created one transient provider in BW client in ECC system.
Now, I tried to create Bex query on this provider, when I am trying to open Bex query designer it is asking for system login, I have selected ECC then I have entered the credentials, but designer not allowing these ECC credentials.
When I tried with BW credentials it is working finr, but my provider is available in BW client in ECC system.
Could some one let me know how to create Bex query on Transient provider.
Thanks in advance.