Creating Query Using BEx Analyzer

Former Member — Wed, 31 Jan 2007 11:58:11 GMT

Hi,

Can any one tell me what are the steps in creating query using Bex Analyzer?

Thanks

Re: Creating Query Using BEx Analyzer

Former Member — Wed, 31 Jan 2007 12:01:34 GMT

Hi,

Please follow the below steps in detail to create query using Bex.

1.Open SAP Business Explorer Analyzer using Start-Programs

2.Click Enable Macros if Macros not yet enabled

3.Click on Open (first icon)

4.Select the BW system from the SAP Logon window which appears.

5.Logon to BW System Client, User, Password and Language

6.Click on the “Queries” in the SAP Bex

7.Click “New” to create a new Query.

8.Select the “info cube” and click “Ok” to open query design window

9.You can drag and drop the item in the left hand side of the window into the right side windows.

10.Select for the left window and click and drop key figures to “Columns” window

11.Select for the left window and click and drop Characteristics

to “Characteristics” window

12.Select for the left window and click and drop to “Rows” window

13.Go to the properties of the value under the Rows Window

14.Click on the List icon under the Presentation Hierarchy to display the list of

hierarchies associated with the characteristic

15.Select the hierarchy which you have created and click “ok” button

16.Click “Ok” to continue

17.Click “Tick icon: to Save and Execute the Query.

18.While saving enter the Technical Name sand Description of the Query.

Try the above steps and check it.

*pls don't forget to avoid points if you find it usefull

Bye