User`s guide
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 QC (Queries) to reveal the defined MDX BW Queries that are available as report data
sources.
Tip:
If no items are found, check the Options setting of the Data Explorer.
a. Right-click QC (Queries) and click Options.
This opens the "Options" dialog box with only the Database tab visible.
b. In the Data Explorer area, ensure that Stored Procedures is selected and then click OK.
You are returned to the Database Expert.
c. Select SAP BW MDX Query and press the F5 key to refresh the Database Expert.
d. Expand Current Connections and then expand QC (Queries).
Now there are lists of available queries.
8.
Select the query that you want to report off and click the right-arrow button.
9.
Click OK.
"Crystal Reports" generates a blank report that uses your query as its data source. You can now
add objects to the report.
Showing field descriptions and technical field names
In Crystal Reports you can choose to identify fields by their description, name, or both. In some cases
you may prefer to show both and in other cases you may prefer to use just one. For example, when
2012-03-14571
Integrating Business Applications with Crystal Reports