Step by step instruction on Creating folders and saving workbook

1. Open the Favorites folder in the tree structure of the BEx Browser. Place the cursor on the right side of the screen and create a new folder (New → Folder). Give it an appropriate name and specify how you want it presented by choosing Select Color and Symbol.
2. Open the BEx Analyzer and execute the selected query. Save the workbook by choosing Save→ Save as new workbook. Enter a name for the query and select the sub-folder you created in your Favorites folder. Confirm with OK.
3. When you call the BEx Browser, you see the name of the query in your new folder, shown as a sub-folder within your Favorites folder. Double-click on the workbook name to retrieve the saved query results.
   
   The following procedure explains how to create a simple query using the
   BEx Query Designer. The results of the query can be displayed either in
   Microsoft Excel using the BEx Analyzer or on the web.

Step by step instruction on Creating a new query

1. In the BEx Analyzer, choose Open → Queries from the BEx toolbar.
2. On the next screen, choose New. This brings you to a selection screen containing all of the InfoCubes for which you can define a new query.
3. Select the InfoCube on which you want the query to be based by selecting it with the mouse. You can see the technical name of the InfoCube by choosing Technical Name (wrench icon).
4. After selecting an InfoCube, choose New to create the query.
5. The objects available for the InfoCube you have selected are shown as a tree structure in the left-hand part of the BEx Query Designer. These objects include the key figures of the fact table and the characteristics of the dimensions.
6. The right-hand part of the screen contains empty windows for filter selections, rows, columns, and the free characteristics of the query. The bottom right-hand part of the screen shows a preview of the query result area. This area is empty at first.
7. By choosing the plus or minus symbols for the directories, you can expand or compress the directory structure. By expanding the key figure node in the InfoCube tree, for example, you can display a list of all the key figures for the InfoCube.
8. You can drag the characteristics and key figures for the InfoCube into the windows for the query definition (filter, rows, columns, and free characteristics).
9. When you have finished defining your query, choose Save Query. Choose Quit and Use Query (check mark icon) to execute and start working with the query.