Child pages
  • Finding hierarchy where used list in Bex Queries
Skip to end of metadata
Go to start of metadata

Applies to:

 This article applies to all SAP BI 7.0 consultants.

Summary

This article gives where used list of all queries for a particular hierarchy.

Table of Contents

Objects related to Business Explorer like query, query element, workbooks, variable etc. are really hard to find out just by looking at the transport request. The reason is they have technical UIDs which make them difficult to understand.
Where-used list button on Query Designer gives details for query, variables etc. But it does not give where used list for a particular hierarchy.
Sometimes, there comes a requirement of determining whether a particular hierarchy should be discontinued. In that case we require where used list for that hierarchy. Below are the steps to find out where used list for a particular hierarchy.

Table: RSZELTPROP (Element properties (settings))

This table stores query element properties.
Restrict with the HIENM equals to technical name of hierarchy.
Get the list of ELTUID

Table: RSZSELECT (Selection properties of an element)

This table stores selection properties of query element. If you have hierarchy node display for a particular element then the entry will always be present in this table.
Restrict with ELTUID and IOBJNM and OBJVERS as A
Get the list of ELTUID.

Table: RSZELTXREF (Directory of query element references)

This is a reference table which stores the mapping of various query elements.
Restrict with TELTUID equals to above list and get SELTUID.
Again take these SELTUID in TELTUID and get SELTUID.

Table: RSRREPDIR (Directory of all reports)

This table stores list of all reports, if you copy object list in your transport request you will get list of queries that are captured in the transport request.

Restrict with COMPUID equal to above list. COMPID will be the list of queries.

Related Content

http://forums.sdn.sap.com/thread.jspa?messageID=8270549#8270549

http://forums.sdn.sap.com/thread.jspa?messageID=4952877#4952877]

http://help.sap.com/saphelp_nw2004s/helpdata/en/83/096d399bd2046fe10000000a114084/frameset.htm

Useful Information

Short quick summary to catch the reader's attention and of course the search engine