Skip to Content

I was going through the SDN forums and Blogs and saw many people posting on how to find the queries in a workbook or in how many workbooks a query is being used.  Immediate answer that would strike your mind is finding them using Tables? Function modules?

Well, it’s easy as long as you remember either the table names or Function modules. If not? It’s still easy.

My simple solution, where you need not remember all these tables to find the workbooks/queries, is using Metadata Repository.

Let’s discuss this using below two scenarios

1. Finding the Queries involved in a Workbook

In the Data Warehousing Workbench select Metadata Repository tab

image

I know what your eyes noticed, workbook on the right side of the screen, exactly.

Click on the workbook which displays the list of workbooks in the system.

image

Select the workbook for which you want to know the queries behind. It displays all the queries used in the workbook.

image

2. Workbooks out of a Query

This time select query instead of workbook, which displays list of queries in the system.

image

Selecting the query displays all the objects in the query and workbooks this particular query is being involved.

image

 

image

Now, want to show you another magic!!

Click on the Network display of the data flow option under Graphical display, just below the query.

image

 

image

 

You might have noticed, it also lists the roles of a query or workbook. Roles are displayed in normal display as well at the end of the screen.

Now do you still think finding queries/workbooks is a difficult task?? I hope not…

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply