Find query with Workbook ID

[Former Member]

Hello,

How to find query with workbook ID?

Regards,

Siva

[Former Member · Accepted solution]

Hi Siva,

Find the workbook in the metadata repository. It will give you the names and technical names of queries used in the workbook.

Hope it helps.

BR

Stefan

[Former Member]

IMportant table

rsrwbindext has description and workbookID

rsrworkbook has workbookID and genuniid

rsrrepdir has genuniid and COMPID

COMPID is the technical name of a query

[former_member205352]

You can implement this program if you know the cube:

[Check this paper|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20f1668e-e26f-2910-819d-c24c9e643ea0]

[Former Member]

Hi,

In BI 7.0 Information tab will give the query technical name and description.

Thank,

Ashok

[Former Member]

Hi Siva,

You can also jump to query from workbook by click icon "sheet with pencil" and choose "change query (global definition)... "

after you open your workbook using BEx Analyzer in Microsoft Excel.

Regards,

Steph