Query Catalog

[Former Member]

Hello,

I'm looking for an easy way of creating a catalog of all queries in a BW system in such a way users can search through this catalog in search of queries to use. I've looked at the metadata repository and the BW metadata cube but these do not provide enough detailed information.

Our BW system is used in many countries with several local query developers per country so the amount of queries in the system is growing fast and an easy way of browsing and searching through them is required.

I would like the possibility to search such a catalog on characteristics used, key figures used, filters and variables used and detailed information about restricted and calculated key figures.

Is there such an application available anywere or does anybody know how to acchieve this in an easy way ?

Thanks in advance for any ideas.

[Former Member]

Hi Mark,

As per I know there is no such application which will solve your purpose other than "Metadata Repository".

If I understand your problem correctly I mean " I have a BW system used in different countries and different developers developing there report for respective country and now it is difficult for the user to get the correct report".

The only solution I think is you need a proper "Naming Convention doc" which will help to differentiate the report for different countries.

E.G. I am developing report say report1 (technical name of query) for 3 countries say India, US, UK so I will make my query technical name as follows.

India :--> Report1_IN

US :--> Report1_US

UK :--> REport1_UK

If it is work book then work book. And then you may restrict these reports by authorization in the user profile.

Hope this will help you.

Suneel