Universe Designer vs BEx query - Can't see the query in the OLAP Cubes list

[Former Member]

Hello Experts,

We are facing a rather strange issue:

While creating a connection to an existing BEx query - which wasn't being used by BO before - we aren't able to see that one query in a long list of available multiproviders/queries on the universe side.

We already checked the option on BEx analyser to authorize external access to the query, with ODBO.

The connection type we're using is the same for all the other universes built on top of BEx queries: SAP BW Client. Again, we already have a bunch of universes built using this method, but we can't seem to find the BEx query in the OLAP Cubes list.

Does anyone have a lead on what may be causing this issue?

Our environment is:

- SAP BOE XI R3.1 SP2

- SAP BW 3.5

- BEx Analyser

- Integration Kit

Best Regards,

Francisco

[Henry_Banks]

It could be the SAP GUI bug where the 'OLE DB for OLAP' BEx property isn't effective

or you don't have enough SAP authorizations to be able to use it

regards,

H

[Former Member]

Hello Henry,

The SAP user we are using to access BW has SAP_ALL permissions. So I think that's out of the way.

Can you tell me more about that bug? Are there any notes on it?

Thanks,

Francisco

[Henry_Banks]

Hi,

i don't know, you'd have to search the BW-BEX component for notes.

I noticed it with a revision of SAP GUI Front End tools 720 SP7 i think

I applied the latest corrections (SP08 or 09) and that tickbox worked ok again.

You might notice - as i did - that when you go back to check the bex query - that property becomes 'magically' unselected/

Regards.

H