Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Experts,
I have 3 environments like EBA, QBA and PBA.
i have composite providers in my BW system from there i want to fetch the data from, BW to qliksense but iam facting some issues.
After creating the data connection in qlik i was able to see all the providers in EBA and PBA to select composite provider but not able to see the compositive provider in QBA.
for ref please find the attachemt.
Please help me on the same
If you cant see then you may not have read rights in that data base.
Qlik would show you the schema's, tables or views you have read rights.
Others will not show.
Ask your DBA or make sure your UserID in Qlik have read access to QBA
I have checked the access for the userid in qba eba and pba there having the same access for all
Are you using same id to create your DB connection?
Take a look at this; https://community.qlik.com/message/1562801#1562801
I seem to remember you need to create at least one query on an InfoProvider (and release it for OLE DB) before it is displayed in the BW Connector.
Edit: Yes, I think I'm correct; https://help.sap.com/doc/saphelp_nw73ehp1/7.31.19/en-US/d4/eae3d74ddf774f8ba2671d1dffbd24/content.ht...
"Result
The QUERY_CUBE you have created now appears in the list of Cubes offered by your client application. You can base your front end display on this."