Start of Content Area

Background documentation Set Local Calculations  Locate the document in its SAP Library structure

Use

Using the Set Local Calculations command (SET_LIST_CALCULATION), you can set the local calculations for a value cell. This enables you to recalculate the results rows and single values displayed in the query according to particular criteria.

Command Parameters

The following information lists the command parameters in the same sequence that they appear in the command wizard when you insert the command:

Parameter

Description

Target Data Providers (TARGET_DATA_PROVIDER_REF_LIST)

 

 

You enter a list of all data providers on which the command is based.

You specify the individual data providers in the Data Provided Affected parameter (TARGET_DATA_PROVIDER_REF).

Data Cell (DATA_CELL)

 

 

 

 

A data cell is determined by the combination of the structure elements. If you use two structures, you must specify the structure and structure element for each structure:

      Characteristic (CHARACTERISTIC)

You use the input help dialog to select the structure for which you want to set the data cell properties.

      Member Name (MEMBER_NAME) 

You specify the structure element for which you want to set the data cell properties.

Cumulate (CUMULATION)

You use this function to specify whether the individual cells of an area are to be cumulated. This means the first value is added to the second value, the result is added to the third value, and so on. In the columns, the cells are cumulated from top to bottom, and in the rows, the cells are cumulated from left to right. With blocks of single values, that is, a drilldown in both the rows and the columns, the values are cumulated from top to bottom and from left to right.

Calculate Single Values As (DETAIL_CALCULATION)

You use this parameter to specify various types of local calculations for single values.

(Nothing Defined) (NONE)

If you choose this option, there is no local calculation and the data from the OLAP processor is displayed.

Hide (HIDE)

If you choose this option, single values are not displayed. Only the results are displayed.

Normalize According to Overall Result (NORMALIZE_OVERALL_RESULT)

If you choose this option, all values are normalized to the overall result. If there are multiple characteristics in the drilldown, there are different results, which are combined to form an overall result.

Normalize According to Next Group Level Result (NORMALIZE_GROUP_RESULT)

If you choose this option, all values are normalized to the result. If there is only one characteristic in the drilldown, the result is the same as the overall result.

Normalize According to Unrestricted Overall Result (NORMALIZE_UNRESTRICTED_OVERALL_RESULT)

The data is displayed as a percentage of the unrestricted result (query result). The values of the results row and the overall results row are not displayed as percentages but as absolute values.

Each key figure for a query has a query result. This is the result of the key figure that results from the aggregation of all characteristics for the query. The overall result and the query result are identical to one another, provided that none of the characteristics are filtered at runtime.

Rank Number (RANK)

If you choose this option, the characteristic values are sorted according to the selected structure element and then assigned a rank. The order of the ranked list is based on the size of the value for the structure element, where the largest value has rank 1 and the smallest value has the last rank.

If a value occurs more than once, the corresponding characteristic values are assigned the same rank. In a basic ranked list, the next smallest value is assigned this rank incremented by one.

Olympic Rank Number (RANK_OLYMPIC)

If you choose this option, the characteristic values are sorted according to the selected structure element and assigned an Olympic rank. The Olympic ranked list differs from the basic ranked list as follows: In the Olympic ranked list, when a value occurs more than once, the next smallest value is not assigned the rank incremented by one, but the rank that corresponds to the number of previous characteristic values (including the current value).

Sum (SUM)

Summation of Rounded Values (SUM_ROUNDED)

If you have set a scaling factor, it is useful to calculate the total sum of rounded values locally since the total sums can differ considerably (in particular with high scaling factors).

Minimum (MIN)

If you choose this option, you can calculate the minimum key figure values for a characteristic locally.

Minimum of Values That Are Not Zero, Null, or Error (MIN_ONLY_NORMAL)

Excluding the values that are equal to zero, the system displays the minimum key figure value for a characteristic.

Maximum (MAX)

If you choose this option, you can calculate the maximum key figure values for a characteristic locally.

Maximum of Values That Are Not Zero, Null, or Error (MAX_ONLY_NORMAL)

Excluding the values that are equal to zero, the system displays the maximum key figure value for a characteristic.

Counter for All Values (COUNTER)

If you choose this option, you can count all values.

Counter for All Values That Are Not Zero, Null, or Error (COUNTER_ONLY_NORMAL)

If you choose this option, you can count all values excluding zero values.

Moving Average (MOVING_AVERAGE)

You can calculate the average of all values locally.

Moving Average Not Zero, Null, or Error (MOVING_AVERAGE_ONLY_NORMAL)

You can calculate the average of all values, excluding zero values, locally.

Moving Minimum Value (MOVING_MIN)

The system displayed the smallest value available up to this point.

Moving Maximum Value (MOVING_MAX)

The system displayed the largest value available up to this point.

Calculation Direction (DETAIL_CALCULATION_DIRECTION)

You use this parameter to specify the calculation direction for Calculate Single Values As. The following options are available:

Calculate Along Columns (COLUMNS_AXIS)

Calculate Along Rows

 (ROWS_AXIS)

Apply Detail Calculation to Results (APPLY_DETAIL_CALC_TO_RESULTS)

You use this parameter to specify whether detail calculation is to be applied to the results.

Calculate Results As (RESULT_CALCULATION)

(Nothing Defined) (NONE)

Hide (HIDE)

Sum (SUM)

The sum total of the values for the corresponding area is displayed as the result.

Maximum (MAX)

The maximum (largest) value of the corresponding area is displayed as the result.

Minimum (MIN)

The minimum (smallest) value of the corresponding area is displayed as the result.

First Value (FIRST)

The highest value or the value furthest to the left of the corresponding area is displayed as the result.

First Value That Is Not Zero, Null, or Error (FIRST_ONLY_NORMAL)

Last Value (LAST) 

The lowest value or the value furthest to the right of the corresponding area is displayed as the result.

Last Value That Is Not Zero, Null, or Error (LAST_ONLY_NORMAL)

Counter for All Detailed Values (COUNT)

The number of values for the corresponding area is displayed as the result.

Counter for All Detailed Values That Are Not Zero, Null, or Error (COUNT_ONLY_NORMAL)

The number of values for the corresponding area, excluding zeros, is displayed as the result; values equal to zero are not included.

Average (AVERAGE)

The average (total divided by total number of values) of all values for the corresponding area is displayed as the result.

Average of Detailed Values That Are Not Zero, Null, or Error (AVERAGE_ONLY_NORMAL)

The average (total divided by number) of all values for the corresponding area, excluding zeros, is displayed as the result; values equal to zero are not included.

Median (MEDIAN)

Median of Detailed Values That Are Not Zero, Null, or Error (MEDIAN_ONLY_NORMAL)

Variance (VARIANCE)

(∑x² -(∑x)² / N) / (N-1) for N>1 and notexist for N=1

Standard Deviation (DEVIATION)

The standard deviation is a measure of the distribution of the values with respect to the mean value (average). Standard deviation = root from the variance: SQRT (variance)

Summation of Rounded Values (SUM_ROUNDED)

If you have set a scaling factor, it is useful to calculate the total sum of rounded values locally since the total sums can differ considerably (in particular with high scaling factors).

Result Calculation Based on Results of Former Detailed Calculation (RESULT_CALC_BASED_CALC_VALUES)

You use this parameter to specify whether the local calculation for the results row is to be executed with the results of the local calculation of the single values.

More information: Local Calculations.

 

End of Content Area