Wednesday, November 11, 2009

Listing all queries within a workbook

I have been working on an unusual and complex planning workbook that has 32 separate queries embedded in it and was recently shown a quick and easy way to list all of them. We have a naming convention to identify all the queries that should be in the workbook but this technique can be used to validate it because we all know that assumptions can be wrong!
The required steps are listed below:
1. Execute transaction SE37 to enter the Function Builder
2. Enter the function module: RRMX_WORKBOOK_QUERIES_GET
3. Click the Test/Execute button as highlighted in red below:

4. Enter in the workbook unique id and click the Execute button

You can source the workbook id by clicking open workbook within BEx Analyzer, selecting the workbook and then viewing its properties.

5. Click the View All Entries button as highlighted in red below:

6. All the queries are listed!

0 comments: