To create a BW query directly from the BEx Query Designer
Go to Start > Programs > Business Explorer > Query Designer.
When prompted, log on to your SAP BW system.
On the Query Designer's toolbar, click New Query.
The New Query: Select InfoProvider dialog box displays the InfoAreas and InfoProviders that are available on your system.
Select the InfoProvider on which you want to base your query, then click OK.
Define your query by selecting measures and characteristics from the Key Figure and Dimensions lists and dragging them to the Columns area.
Click Query Properties.
Click the Extended tab and ensure that Allow External Access to this Query is selected.
This option allows other programs, like Crystal Reports, to access this query.
Click Save Query.
In the Save Query dialog box, click Roles and select the role where you want to save the query.
Type a Description and a Technical Name for the query, then click Save.
The Technical Name must uniquely identify the query—that is, the name can appear only once across all InfoProviders in BW. The Technical Name can be up to 30 characters long and must begin with a letter.