User`s guide
When a query contains a hierarchy variable, the MDX Query driver creates an extra field called
Hierarchies in Crystal Reports that allows you to create a list of values for the variable.
1.
In the Field Explorer, expand Parameter Fields, and right-click [HV01].
The parameter, [HV01], in CR represents the hierarchy variable you created for this query.
2.
Click Edit.
The Edit Parameter dialog box opens.
3.
Ensure that the List of Values field is set to Static.
4.
From the Value list, select Hierarchies-[0MATERIAL].
5.
From the Description list, select Hierarchies-[0MATERIAL]-Description.
6.
Click Actions and then click Append all database values.
The Value and Description lists are populated with values from the BW system.
7.
In the Values Options area, set the Prompt Text to the message you would like users to receive in
the parameter prompt.
8.
Ensure that Allow customer values and Allow multiple values set to False.
9.
Click OK.
To create a list of default values for the hierarchy node variable
• Repeat the steps outlined in the task To create a list of default values for the hierarchy node variable
.
Now when you refresh the report, you are presented with two prompts, each with a list of default
values.
24.1.3.1.2 Reporting off Operational Data Stores
This section introduces the Operational Data Store Driver and how to report off it.
Operational Data Store driver overview
The Operational Data Store (ODS) driver allows you to use existing ODS objects from your BW Data
Warehouse as a data source in Crystal Reports. ODS objects are collections of info objects that act as
smaller organizational units for the data in your BW Data Warehouse. Through this driver, the user can
design multiple reports by quickly referencing the same ODS objects.
Reports that are based on ODS objects behave similarly to reports that are based on stored procedures
in mainstream databases. Because the data stored in the ODS objects is not multidimensional and
contains no parameters, it can be accessed and reported from quickly. This driver also pushes record
selection to the server, which further speeds up report processing.
Selecting an ODS object
1.
Start Crystal Reports.
2012-03-14588
Integrating Business Applications with Crystal Reports