User`s guide
This field has no purpose other than to create lists of values for hierarchy variables. This field should
not be used for reporting.
Selecting cubes for reports
If you or someone else in your organization has defined one or more cubes for reporting purposes
within BW, you can select them as data sources for new Crystal Reports.
To select an existing query for a report
1.
On the File menu in Crystal Reports, click New and then click Blank Report.
The "Database Expert" appears.
2.
Under “Available Data Sources”, expand Create New Connection and then expand SAP BW MDX
Query.
The "SAP System Logon" dialog box appears.
3.
Select the appropriate BW system and click Next.
The next "SAP logon" dialog box prompts you for user credentials
4.
Type your usual SAP user credentials in the Client, Username, and Password, fields, then click
Next.
Tip:
To set the logon language, you must specify your Preferred Viewing Local in Crystal Reports under
View > Preferred Viewing Local.
The next "SAP logon "dialog box asks you whether you would like to generate RFC trace files.
5.
If you want the SAP Communication Library to create trace files for all client/server communication
(for troubleshooting purposes), select the Generate RFC trace files check box.
6.
Click Finish.
You are returned to the "Database Expert". There are now two entries under your SAP BW MDX
Query connection. One is labeled CU (Cubes) and the other is labeled (QC) Queries.
7.
Expand CU (Cubes) to see the defined BW cubes that are available.
Tip:
If no items are found, check the Options setting of the Data Explorer.
a. Right-click CU (Cubes) and click Options.
b. This opens the "Options" dialog box with only the Database tab visible.
c. In the “Data Explorer” area, ensure that Stored Procedures is selected and then click OK.
d. You are returned to the "Database Expert".
e. Select SAP BW MDX Query and press the F5 key to refresh the Database Expert.
f. Expand Current Connections and then expand CU (Cubes).
g. Now there are lists of available cubes.
8.
Select the cube that you want to report off and click the right-arrow button.
2012-03-14573
Integrating Business Applications with Crystal Reports