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,

You can use metadata tables like:

RSZCOMPDIR

RSZELTDIR

RSZREPDIR

for query elements

or

RSRWORKBOOK

RSRWBINDEX

RSRWBINDEXT

for workbooks

or

RSZWOBJXREF

RSZWOBJTXT

for web templates.

Regards,

LauQ

[Former Member]

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.

[Former Member]

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