Query not Visible in Universe

[Former Member]

Hi Experts,

I want to create a universe based on query.

When I try to create the connection I am able to see all queries except for the ones I have created.

I have checked the query for external use as well at BEx level.

There are no roles maintained in this sandbox server.So no question about inserting my queries into specific roles as it is currently in my favourites.

Am I missing some setting part somewhere?

Please assist.

[Former Member · Accepted solution]

Hi Neeraj,

Have you created an ODBC DSN connection to your query as a System data source? You should be able to see it if you have done that.

Thanks!

[Former Member · Accepted solution]

Hi Wavery,

You mean to say try to connect to SAP OLE server through my query using pivot table and connecting to external datasource?

Or do you mean something else?

If you could provide the steps to the solution you intend to provide will be very much appreciated.

Thanks.

[Former Member · Accepted solution]

Hi Neeraj,

Check and correct (if required) this below setting as well:

- start transaction RSRT

- enter the technical name of the BW query in the syntax CUBE/QUERY

- click Properties

- set the second item called Req.Status to 0

- Uncheck the check box infoprovider setting.

Regards,

Rohit

[Former Member · Accepted solution]

That was awesome!!!

Thanks Rohit.