Searching for a Query

[Former Member]

Hi People,

How do we search for a specific query in Bex.

The search button is not fine. Even though a query ZQuery exists, its denying that fact.

When you manually add that name and say Open, it works fine.

-TC

[Former Member · Accepted solution]

You can see all the queries in Meta data repository.

If you know the cube name (infoprovider name) you can find out by going to the Transport connection option too

[Former Member · Accepted solution]

I have the query name and nothing else. If I had known the cube name, I could have searched for infoarea and then search by specific IA on BEX whoch would have given me the result.

Thanks for your reply though.

-TC

[Former Member · Accepted solution]

did u click the search in description and search in technical name option?

[Former Member · Accepted solution]

Both options are checked and I can see the query and open it , if I paste or type the name in text box below.

-TC

[Former Member · Accepted solution]

try and put parts of the name:

for eg if it is Zquery try and search for query instead.

[Former Member · Accepted solution]

Not working, I had tried a sub string as well.

-TC

[Former Member · Accepted solution]

Did u tried searching in RSRT?

[Former Member · Accepted solution]

It does show up in RSRT but where do I see the IA and IP under there.

-TC

[Former Member · Accepted solution]

The best practice to name a query is to include the IP name at the start.

Ok, when you open the query in query designer -->go to query prperties,there u can see the infoprovider name.