BEx Query Element |
SAP BusinessObjects Analysis, edition for OLAP
|
InfoProvider Dimension | Not supported |
Characteristics | All characteristics from the BEx query are available and the user can decide between the different display options (key, text, key & text, text & key) |
Key Figures | All key figures are available in SAP BusinessObjects Analysis edition for OLAP and the user is able to display settings such as the scaling factor and the currency / unit. |
Free Characteristics | All characteristics placed in the Free Characteristics area of the BEx Query are available in SAP BusinessObjects Analysis, edition for OLAP and are treated like any other characteristic. |
Restricted Key Figures | Restricted Key figures are fully supported and are treated like any other key figure in SAP BusinessObjects Analysis, edition for OLAP. The details of the Restricted Key Figure are not available in SAP BusinessObjects Analysis, edition for OLAP and can only be viewed in the BEx Query Designer. |
Calculated Key Figures | Calculated Key figures are fully supported and are treated like any other key figure in SAP BusinessObjects Analysis, edition for OLAP. details of the Calculated Key Figure are not available in SAP BusinessObjects Analysis, edition for OLAP and can only be viewed in the BEx Query Designer. |
Display Attributes | Starting with SAP BusinessObjects Analysis, edition for OLAP release 4 with Service Pack 04, the product does support the Display Attributes from SAP NetWeaver BW and the user is able to include those into the workbooks. |
Navigational Attributes | All Navigational Attributes are available in SAP BusinessObjects Analysis, edition for OLAP and are treated like any other characteristic |
BEx Query Filter | Fixed filters defined in the BEx Query layer are fully supported by SAP BusinessObjects Analysis, edition for OLAP but the information about the configured filter values is not available in SAP BusinessObjects Analysis, edition for OLAP. |
Defaults | Values or variables placed in the Defaults area of the BEx query are being used by SAP BusinessObjects Analysis, edition for OLAP for the initial view in the workspace and the consumer of the workspace can then use standard navigation steps to change the values. |
Custom Key Figure Structure | Custom structures defined in the BEx Query with key figures integrated as part of those custom structures are fully supported by SAP BusinessObjects Analysis, edition for OLAP and the consumer is able to select specific elements of the structure for the workspace. |
Custom Characteristic Structure | Custom structures defined in the BEx Query with characteristics integrated as part of those custom structures are fully supported by SAP BusinessObjects Analysis, edition for OLAP and the consumer is able to select specific elements of the structure for the workspace. |
Hierarchical Custom KeyFigure Structure | Custom structures defined in the BEx Query with key figures integrated as part of those custom structures and defined as a hierarchical structure are fully supported by SAP BusinessObjects Analysis, edition for OLAP and the consumer is able to select specific elements and also leverage the hierarchical definition of the structure for the workspace. |
Hierarchical CustomCharacteristic Structure | Custom structures defined in the BEx Query with characteristics integrated as part of those custom structures and defined as a hierarchical structure are fully supported by SAP BusinessObjects Analysis, edition for OLAP and the consumer is able to select specific elements and also leverage the hierarchical definition of the structure for the workspace. |
Selection of elements ofa custom structure in thereport | In SAP BusinessObjects Analysis, edition for OLAP the user is able to select from the list of structure elements and decide which structure elements will be part of the workspace. |
Support for 2 structuresfrom BEx Query | BEx Queries with two structures are fully supported. |
Compounded Characteristics | Starting with release 4 Service Pack 04, compounded characteristics are fully supported, including BEx variables with cascading list of values. |
Characteristic Data Type NUMC | Fully supported |
Characteristic Data Type CHAR
|
Fully supported |
Characteristic Data Type DATS |
Fully supported
|
Characteristic Data Type TIMS |
Fully supported
|
Key Figures Data Type Amount / Quantity |
Fully supported
|
Key Figures Data Type DATS | Fully supported |
Key Figures Data Type TIMS | Fully supported |
Information about configuredFilters in the BEx Query | Fixed filters defined in the BEx Query layer are fully supported by SAP BusinessObjects Analysis, edition for OLAP but the information about the configured filter values is not available in SAP BusinessObjects Analysis, edition for OLAP |
BEx Text Elements | SAP BusinessObjects Analysis, edition for OLAP is not supporting information that is known as BEx Text Elements, such as the date from the last data update. |
Table: Support for BEx Query Elements
Variables in BEx Query |
SAP BusinessObjects Analysis, edition for OLAP
|
Optional Variables | Fully supported |
Characteristic Value Variables |
Fully supported
|
Formula Variables |
Fully supported
|
Hierarchy Variables |
Fully supported
|
Hierarchy Node Variables | Fully supported |
Hierarchy Version Variable | Fully supported |
Key Date Variable | Fully supported |
Text Variables | Fully supported |
Table: Support for BEx Variables
Variable Processing Type in BEx Query | SAP BusinessObjects Analysis, edition for OLAP |
User Entry / Default Value | Fully supported |
Replacement Path | Fully supported |
Customer / SAP Exits | Fully supported |
Authorization | Fully supported |
Table: Support for Variable Processing Type
Variable Presentation Options |
SAP BusinessObjects Analysis, edition for OLAP
|
Sinle Value |
Fully Supported
|
Multiple Single Value |
Fully supported
|
Interval / Range Value |
Fully supported
|
Selection Option |
Fully supported
|
Selection Option Operator |
Fully supported
|
Functionality (except Contains Pattern)Selection Option Operator |
Not supported
|
Functionality – Contains PatternSelection Option Include / Exclude | Fully supported |
FunctionalityPreCalculated Value Set | Fully supported |
Table: Variable Representation
BEx Query Functionality |
SAP BusinessObjects Analysis, edition for OLAP
|
Support for manual entryof values | Starting with SAP BusinessObjects Analysis, edition for OLAP release 4 with Server Pack 04, the product does support the option to manually enter values for BEx variables. |
Support for Variables inDefaults Area of BEx Query | Fully supported |
Support for single Key DateVariable |
Fully supported
|
Support for multiple Key DateVariables in single BEx Query |
Fully supported
|
Support for Hierarchy / HierarchyNode Variable dependency | SAP BusinessObjects Analysis, edition for OLAP fully recognizes and supports the dependency between a hierarchy and a hierarchy node variable. |
Support for cascading variablesfor Compounded Characteristics | Starting with SAP BusinessObjects Analysis, edition for OLAP release 4 with Pack 04, the product fully supports compounded characteristics including the cascading nature of BEx variables based on compounded characteristics. |
Support for Variable Default Values | Fully supported |
Support for Variable Variants | The support for variable variants in SAP BusinessObjects Analysis, edition for OLAP is planned for the release 4.1, which is planned to go into RampUp in Q2 2013. |
Support for Variable Personalization | Not supported |
Merge / Unmerge Variables | The support for merging variables in SAP BusinessObjects Analysis, edition for OLAP is planned for the release 4.1, which is planned to go into RampUp in Q2 2013. |
Table: Support for BEx Query Functionality
BEx Query Functionality | SAP BusinessObjects Analysis, edition for OLAP |
Defining Variable Sequencein the report | In SAP BusinessObjects Analysis, edition for OLAP the user cannot change the sequence of the BEx variables (see next line item). |
Variable Sequence basedon BEx Query Designer | SAP BusinessObjects Analysis, edition for OLAP is leveraging the defined sequence of variables from the BEx query designer. |
Support for validating valuesbefore executing the report | Fully supported |
Read Mode for list of values(master data, InfoCube) | SAP BusinessObjects Analysis, edition for OLAP is leveraging the configuration in SAP NetWeaver BW where the user can configure on the InfoObject level, if the characteristic should display the data from the master data or from the InfoProvider. |
List of Values :Search in Key values | Fully supported |
List of Values : Search in DescriptionValues
|
Fully supported |
List of Values : Sort values based onKey Values
|
Not supported |
List of Values : Sort values basedon Description Values
|
Not supported |
Currency / Unit Conversion definedin BEx Query
|
Fully supported |
Currency / Unit Conversion(Runtime) | SAP BusinessObjects Analysis,edition for OLAP does not provide the functionality to execute a currency or unit conversation without the usage of BEx query variables. |
Condition in Rows (from BEx Query) | Fully supported |
Condition in Columns (from BEx Query)
|
Fully supported |
Conditions for fixed set of characteristics(from BEx Query)
|
Fully supported |
Condition for independent characteristics(from BEx Query)
|
Fully supported |
Defining Conditions in theworkspace | In addition to supporting the conditions defined in the underlying BEx query, SAP BusinessObjects Analysis, edition for OLAP also allows the user to created conditions –now being called Filter by Measure – in the workspace without having to change the underlying BEx query. |
Exceptions (from BEx Query) | SAP BusinessObjects Analysis, edition for OLAP is offering the functionality Conditional Formatting, which allows the user to create highlighting in the workspace without having to change the underlying BEx query. The re-use of already definedExceptions in the BEx Query is planned for the 4.1 release which is planned to go into RampUp in Q2 2013. |
Defining Exceptions in the workspace | Fully supported |
Table: Support for BEx Query Functionality
BEx Query Functionality | SAP BusinessObjects Analysis, edition for OLAP |
Constant Selection | Fully supported |
Cell Editor Calculation Local calculations (defined in BEx Query) |
Fully supported
|
Defining Calculations in thereport (at run time)
|
Fully supporte |
Exception Aggregation
|
Fully supported |
Zero Suppression
|
Fully supported |
Read Mode for characteristics(master data, InfoCube) | SAP BusinessObjects Analysis, edition for OLAP is leveraging the configuration in SAP NetWeaver BW where the user can configure on the InfoObject level if the characteristic should display the data from the master data or from the InfoProvider. |
Scaling Factor | Fully supported |
Reverse Sign (+/-)
|
Fully supported |
Number of Decimals
|
Fully supported |
Hide / Show the Element | Fully supported |
Sort Characteristics | Fully supported |
Display Options for characteristics(Key, Key & Text, Text) | SAP BusinessObjects Analysis, edition for OLAP is honoring the configuration of the characteristic done in the BEx Query Designer. In addition SAP BusinessObjects Analysis, edition for OLAP is also offering the option to configure the different display options, such as key, text, key & text, in the workspace itself without having to change the underlying BEx query. |
Result Rows (Show, Suppress) | In addition to supporting the configuration from the underlying BEx query the user is able to switch between the hiding or showing of subtotals and grand totals in the workspace itself without having to change the underlying BEx query. |
Placement of subtotal(above / below nodes) | Fully supported |
Table: Support for BEx Query Functionality
Hierarchical Functionality | SAP BusinessObjects Analysis, edition for OLAP |
Hierarchies with Linked Nodes | Fully supported |
Time-dependent Hierarchies | Fully supported |
Time-dependent Hierarchy Structures | Fully supported |
Hierarchies with Temp Join
|
Fully supported |
Hierarchy Versions (without usage of Variables) | Fully supported |
Hierarchical Member selection (nodes and leafs) | Fully supported |
Member Selection based on hierarchy levels
|
Fully supported |
Show specific Hierarchy Levels
|
Fully supported |
Skip levels of a hierarchy | Fully supported |
Show Leaf Members only | Fully supported |
Ranking Data along a hierarchy | Fully supported |
Exchange of hierarchies in the BI client tool | Fully supported |
Expand to Level Functionality BEx Query Designer) | Fully supported |
Expand to Level Functionality (Run Time) | SAP BusinessObjects Analysis, edition for OLAP is able to leverage the configuration “Expand to level” from the underlying BEx query but does not have such functionality in the product itself yet. The functionality in the product is planned for the release 4.1 (RampUp Q2 2013). |
Compact Axis in the Rows (Display as hierarchy) | Fully supported |
Compact Axis in the Columns (Display as hierarchy)
|
Fully supported |
Hierarchical Report Design
|
Fully supported |
Hierarchical charting
|
Fully supported |
Table: Support for Hierarchy Functionality
BI Platform Capabilities | SAP BusinessObjects Analysis, edition for OLAP |
Scheduling a document | Not supported |
Create a Publication ( = Broadcasting) | Not supported |
Support for Variable Variants | The support for Variable Variants is planned as part of the 4.1 release, which is planned to go into RampUp in Q2 2013. |
Support for Variable Personalization | Not supported |
Support for Report Report Interface as Sender | The support for the Report Report Interface as a valid sender is planned as part of the 4.1 release, which is planned to go into RampUp in Q2 2013. |
Support for Report Report Interface as Receiver | Not supported |
Table: BI Platform Capabilities
Frequently asked SAP BO Interview Questions
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
I am Ruchitha, working as a content writer for MindMajix technologies. My writings focus on the latest technical software, tutorials, and innovations. I am also into research about AI and Neuromarketing. I am a media post-graduate from BCU – Birmingham, UK. Before, my writings focused on business articles on digital marketing and social media. You can connect with me on LinkedIn.
1 /15
Copyright © 2013 - 2023 MindMajix Technologies