Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAP BW

Go to solution
Former Member

‎03-12-2007 1:48 AM

0 Kudos

Hi,

I would like to know the Step by step instruction on Creating a new query .

Thanks

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎03-12-2007 2:15 AM

0 Kudos

Hi,

Check the following steps...

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.

Bye

1 REPLY 1

Go to solution
Former Member

‎03-12-2007 2:15 AM

0 Kudos

Hi,

Check the following steps...

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.

Bye