on 06-14-2010 5:44 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
make sure that the user has the authorizations to see the cube and the query
ingo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.