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

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?

[Former Member]

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.