Features

Create Expression

SSAS support MDX type expressions and script type expressions.

Essbase and SAP BW only support script type expressions.

Filter

support

Filter

support

Column Filter

support

Format

support

Alias

support

Create Advanced Algorithm

support

Features

The state of the Multi Dimension Connection

Dimension and Measure

The Measure defaults to the aggregate state, Total is empty, and cannot be selected.

Create Expression

SSAS, Essbase, and SAP BW support granularity enhancement.

Dimensions: Expressions that support the Script type.

Create Aggregate Measure Expression

SSAS, Essbase, and SAP BW support granularity enhancement

Measure: Support for expressions of type MDX and Script.

Create Parameter Column

support

Create Advanced Algorithm

support

Sort

Support, including manual Sort, customized Sort, TopN and Advanced Sort.

Note: The Measure in advanced Sort also cannot select Total.

Dimensions and Measure switching

not support

Add a Dynamic Dalculator

support

Predefined Calculation

support

Alias

support

Discrete and Continuous switching

support

Year on year、Month on month

support

To Detail Table

Not supported, not displayed

To Meta

support

Drill

support

Aggregate

Not supported because the data source for the cube has been pre-aggregated.

Show Details

SSAS support. 

ESSBASE and SAP BW not supported

Group Together

not support

Filter 

support

Grand Total

support

Value alias

The text and key values of SAP BW.

Text：Name, Middle Name, Long Name.

Combination of text and key values: Keywords, Keyword-Name, Keyword-Middle Name, Keyword-Long Name.

Text Variable

SAP BW allows field names to contain placeholders for variables such as "$Date$ Testing", which are then replaced with the selected values. For example, if you select 2016 for this variable, the field appears as "2016 Testing" in the BEx tool.

The column names in Yonghong do not change with the value of the variable, so they will be displayed as "$Date$ Testing". However, you can change the column name in the Yonghong product later.

Customer Exit Variable

The public API does not expose the customer exit variable, so such variables are not supported in Yonghong products.