finding Query and Workbook technical names

[Former Member]

Hi gurus

Is there any way where i can know the technical name of the workbook associated with the query in a simple way.

thanks in advance

A Rao

[Former Member]

Hello anand

The simplest and easiest way i can tell you is, go to BEx - open query and in the queries listed chose the particular query you wish to see the workbook's technical name and other details, just copy the query name there and paste it in the notepad.

Now you will able to see the workbook technical name, infocube technical name and the query technical name associated with that query.

(Note you will not find the Copy-Paste option there, but still it works..How even i dont know)

hope this works.

(dont forget to put points)

regards

vijaykumar

[Former Member]

Hi,

go to BEx and click on 'Spanner' icon on the top right hand side of the window. It will list all the technical names of the queries.

Hope this helps.

Praveen.

[former_member188325]

Hi,

Open and Execute a Work book...

rght click in result area->properties->Information Tab.

Here You will find Query and Workbook Ids.

Hope this helps.

[Former Member]

Table RSRWBINDEXT

regards,

Wil Heijmans

[Former Member]

would like to try also.. the follwing 2 tables comination..

RSRREPDIR , RSRWORKBOOK

regards,

Hari