Supported meta-data & functionality
Variable Presentation
Analysis, edition for
Microsoft Office
Analysis, edition for
OLAP
Crystal Reports for
Enterprise
Design Studio
Single Value Yes Yes Yes Yes Yes Yes No Yes (6)
Multiple Single Value Yes Yes Yes Yes Yes Yes No Yes (6)
Interval / Range Value Yes Yes Yes Yes No Yes No Yes (6)
Selection Option Yes Yes Limited
Support (2)
Limited Support (2)
Limited
Support (2) Yes No Yes (6)
Selection Option Operator Functionality (except Contains Pattern)
Selection Option Operator
Functionality - Contains Pattern No No Limited Support (2)
Limited Support (2)
Limited
Support (2) Yes No No
Selection Option Include /
Exclude Functionality Yes Yes Limited
Support (2)
(2) Crystal Reports for Enterprise, Web Intelligence, and SAP BusinessObjects Dashboards are creating range variables for a selection option variable from a BEx Query. In addition the option to include or exclude values and to select an operator is not supported.
(6) Design Studio 1.0 does not support the prompting.. Nevertheless designer can set the variable value per scripting.
Supported meta-data & functionality
Variable Functionality
Analysis, edition for
Microsoft Office
Analysis, edition for
OLAP
Crystal Reports for
Enterprise
Design Studio
Support for manual entry of
values Yes Yes No No No Yes - NA - Yes
Support for Variables in Defaults
Area of BEx Query Yes Yes No No No No No Yes
Support for single Key Date
Variable Yes Yes Yes Yes Yes Yes No Yes
Support for multiple Key Date
Variables in single BEx Query Yes Yes Yes No Yes Yes No Yes
Support for Hierarchy / Hierarchy Node Variable dependency
Yes Yes Yes Yes No No No Yes
Support for cascading variables
for Compounded Characteristics Yes Yes Yes Yes Yes No - NA - Yes
Support for Variable Default
Values Yes Yes Yes Yes Yes Yes No Yes
Supported meta-data & functionality
Variable Functionality
Analysis, edition for
Microsoft Office
Analysis, edition for
OLAP
Crystal Reports for
Enterprise
Design Studio
Copy / Paste variable values
from clipboard Yes No No No No No - NA - Planned for
release 1.1 Filling variable values from
Microsoft Excel File
Planned for
release 1.4 No No No No No - NA - No
Merge / Unmerge Variables Yes Planned for
release 4.1 No Yes No No - NA - Planned for
release 1.1 Defining Variable Sequence in
the report No No Yes Planned for
release 4.1 No No - NA - No
Variable Sequence based on
BEx Query Designer Yes Yes Yes Yes No No - NA - Planned for
release 1.1 Support for validating values
before executing the report Yes Yes No No No No - NA - Planned for
release 1.1 Read Mode for list of values
(master data, InfoCube) Yes Yes Yes Yes Yes No - NA - Planned for
release 1.1
Supported meta-data & functionality
BEx Query Elements
Analysis, edition for
Microsoft Office
Analysis, edition for
OLAP
Crystal Reports for
Enterprise Currency / Unit Conversion
defined in BEx Query Yes Yes Yes Yes Yes Yes No Yes
Currency / Unit Conversion
(Runtime) Yes No No No No No Possible with
manual modeling No Condition in Rows
(from BEx Query) Yes Yes
No Not planned for
future release
No Not planned for
future release
No Not planned for
future release
Yes
No Not planned for
future release
Yes
Condition in Columns
(from BEx Query) Yes Yes
No Not planned for
future release
No Not planned for
future release
No Not planned for
future release
Yes
No Not planned for
future release
Yes
Conditions for fixed set of
characteristics (from BEx Query) Yes Yes
No Not planned for
future release
No Not planned for
future release
No Not planned for
future release
Yes
No Not planned for
future release
Yes
Condition for independent
characteristics (from BEx Query) Yes Yes
No Not planned for
future release
No Not planned for
future release
No Not planned for
future release
Yes
No Not planned for
future release
Yes
Defining Conditions in the report Yes Yes Yes (5) Yes (5) Yes (5) No - NA - No
Exceptions (from BEx Query) Yes Planned for release 4.1
No Not planned for
future release
No Not planned for
future release
No Not planned for
future release
- NA -
No Not planned for
future release
Planned for release1.1
Defining Exceptions in the report Yes Yes Yes Yes Yes - NA - - NA - No
Constant Selection Yes Yes Yes Yes Yes Yes - NA - Yes
(5) the BI clients are able to create condition type of filters (for example, Top N) in the report but these filters are applied after the data has been retrieved from SAP NetWeaver BW
Supported meta-data & functionality
Variable Type
Analysis, edition for
Microsoft Office
Analysis, edition for
OLAP
Crystal Reports for
Enterprise
Design Studio
Cell Editor Calculation Yes Yes Limited
Support (6)
Limited Support (6)
Limited
Support (6) No No Yes
Local calculations (defined in
BEx Query) Yes Yes No No No Yes No Yes
Defining Calculations in the
report (at run time) Yes Yes No Yes No Yes - NA - No
Exception Aggregation Yes Yes Yes Yes Yes Yes No Yes
Zero Suppression Yes Yes No No No Yes No Yes
Read Mode for characteristics
(master data, InfoCube) Yes Yes Yes Yes Yes Yes Yes Yes
(6) Crystal Reports for Enterprise, Web Intelligence, and SAP BusinessObjects Dashboards to support BEx queries with two structures and cell definitions created with the cell editor but in cases where the cell definition combines different data types, the resulting output in these BI clients will be a string value instead of a numeric value.
Supported meta-data & functionality
BEx Query Elements
Analysis, edition for
Microsoft Office
Analysis, edition for
OLAP
Crystal Reports for
Enterprise
Design Studio
Scaling Factor Yes Yes Yes Yes Yes Yes - NA - Yes (7)
Reverse Sign (+/-) Yes Yes Yes Yes Yes Yes - NA - Yes (7)
Number of Decimals Yes Yes
No Not planned for
future release
No Not planned for
future release
No Not planned for
future release
No Not planned for
future release
- NA - Yes (7)
Hide / Show the Element Yes Yes Yes Yes Yes Yes - NA - Yes (7)
Sort Characteristics Yes Yes No No No Yes - NA - Yes (7)
Display Options for
characteristics (Key, Key & Text, Text)
Yes Yes
Elements can be included as
part of the report design
Elements can be included as
part of the report design
Elements can be included as part of the report design
Yes - NA - Yes (7)
Result Rows (Show, Suppress) Yes Yes No No No No - NA - Yes (7)
Placement of subtotal (above /
below nodes) Yes Yes No No No No - NA - Yes (7)
(7) Design Studio: possible to define it in design time. But it‘s not possible to define/change it in ad-hoc manner in run time with Design Studio 1.0
Supported meta-data & functionality
BEx Query Elements
Analysis, edition for
Microsoft Office
Analysis, edition for
OLAP
Crystal Reports for
Enterprise
Design Studio
Schedule a document Planned for 1.4
(BI 4.1) No Yes Yes No - NA - - NA - No
Create a Publication (=
Broadcasting)
Planned for 1.4
(BI 4.1) No Yes Yes No - NA - - NA - No
Support for Variable Variants Yes Planned for
release 4.1 No No No No - NA - Planned for
future release Support for Variable
Personalization
Planned for
version 1.4 No No No No No - NA - Planned for
future release
Support for Report Report
Interface as Sender Yes Planned for
release 4.1 Yes No Yes No - NA - Planned for
future release Support for Report Report
Interface as Receiver
Planned for
version 1.4 No No No No No - NA - Planned for
future release