01-31-2007 11:58 AM
Hi,
Can any one tell me what are the steps in creating query using Bex Analyzer?
Thanks
01-31-2007 12:01 PM
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
01-31-2007 12:01 PM
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