User`s guide

working with Multiple Structures, it is recommended that you show only the descriptions. The Global
Unique Identifiers (GUID) that SAP assigns to Multiple Structures are reflected in Crystal Reports and
can be difficult to work with.
To adjust the field name and description settings
1.
On the File menu, click Options.
The "Options" dialog box appears, with the Layout tab active.
2.
Click the Database tab.
3.
In the “Tables and Fields” area, select Show Name, Show Description, or Show Both.
4.
Click OK.
Tip:
For more information about formatted reporting, see the SAP Library > Business Information Warehouse
> Business Explorer > Formatted Reporting: Crystal Reports Integration.
Tips regarding field names in Crystal Reports
When you are viewing attribute names in Crystal Reports, the number that the attribute name is preceded
by gives you information about what kind of information the field contains.
• 2 means that the attribute is the member key
• 1, 4, or 5 means that the attribute is a member description
When you are viewing characteristic names in Crystal Reports, if the characteristic name is followed
by many spaces and then the name of a hierarchy, the characteristic contains that hierarchy.
For example, if the Material characteristic contains the HIGHTECH hierarchy, it appears as [0Material
HIGHTECH].
The following fields are used for hierarchical grouping and parameter binding when there is a hierarchy
node variable on a characteristic. These fields should not be used for reporting.
• NodeId
• Parent NodeId
• MemberUniqueName
Note:
Putting the MemberUniqueName on a report will cause performance issues.
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.
The Hierarchies field has the following attributes:
• Hierarchy names
• Hierarchy descriptions
2012-03-14572
Integrating Business Applications with Crystal Reports