universes to query from multiprovider

[Former Member]

Hi,

I am trying to create an universe from a query that was created from a multiprovider. But I can't see the query under the folder of the multiprovider.

The query is marked with "allow external access to this query".

I can see the queries from infocubes.

what may be happening

thanks

[Former Member · Accepted solution]

Hi,

You might check the query properties in the query monitor in SAP BW (transaction: rstt).

Select you query and click on the properties tab.

Check if the 'Req. Status' is equal to '7'. If so then the query won't show in the list for the universe connection.

I had the same problem and changed the 'Req. Status' to 0. The query then showed up to be used as a universe connection.

See also SAP Note: 1408037

Cheers,

Harry

[Former Member · Accepted solution]

Transaction is ofcourse RSRT.

[Former Member]

Hi,

You can create Universe on InfoCube, InfoCube Query and ODS/DSO Query.

You can access MultiProvider Query/InfoSet Query to your Universe.

When you dd not find your Query then please check Authorization.

Log out of BO and Log in again.

Regards,

Rafi

Edited by: Mohd Rafi on Jun 24, 2010 9:46 AM

[IngoH]

Hi,

make sure that the user has the authorizations to see the cube and the query

ingo