Question Re: Query Catalog in Technology Q&A

Query Catalog

Former Member — Wed, 29 Jun 2005 08:04:31 GMT

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.

Re: Query Catalog

Former Member — Wed, 29 Jun 2005 08:49:57 GMT

Hi,

You can use metadata tables like:

RSZCOMPDIR

RSZELTDIR

RSZREPDIR

for query elements

RSRWORKBOOK

RSRWBINDEX

RSRWBINDEXT

for workbooks

RSZWOBJXREF

RSZWOBJTXT

for web templates.

Regards,

LauQ

Re: Query Catalog

Former Member — Wed, 29 Jun 2005 09:04:32 GMT

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

Re: Query Catalog

Former Member — Thu, 30 Jun 2005 06:47:35 GMT

Hi Laurent,

I can use these metadata tables like you've said, I've found several of them myself, but I'm looking for an application that already gathers information from these tables and presents them or make this data available for easy searching.

There is also a Function Module (RSZ_DB_QUERY_GET)

which read these tables and delivers the data in internal tables.

Using this is a possibility but before spending much time developing such an application myself I was wondering if there perhaps already is something like this available anywhere.

Regards,

Mark.

Re: Query Catalog

Former Member — Thu, 30 Jun 2005 08:09:25 GMT

Hi Mark,

I am not aware of any such application. But I agree saying that this would be nice to have!

In my case, I did SQL statements on the metadata tables to retrieve useful information.

Best regards,

Lauq

Re: Query Catalog

Former Member — Wed, 03 Jan 2007 19:24:02 GMT

Hi Mark

We have exactly the same need as you. We need to create a Catalogue to all users with exactly this same features

"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"

A web application with a search possibility, but also with a friendly way to build each query data information, maybe with windows and drop and down objects based on the characteristics and key figures in the cubes/multicubes.

Have you found any solution. Has anyone found a solution?

Re: Query Catalog

Former Member — Wed, 03 Jan 2007 20:21:23 GMT

I think this would be a very manually compiled way to get this information, but you could definitely use the BW Technical Content / Statistics Cubes to spit out information about which users in which countries are using which queries. You could combine that information with some where-used table joins to get the specific characteristics, key figures, etc.