Data Functions

You can use the following data functions when defining a formula or a calculated key figure as an operator.

• CMR(<Expression>): CURRENT MEMBER result

  The CMR operator does not calculate aggregates based on the data in the InfoProvider. Instead it calculates the aggregates based on the values moved by the CURRENT MEMBER variable. Therefore this operator only has a function if it is used with key figures, which have been restricted by CURRENT MEMBER variables.

  For more information, see CURRENT MEMBER Variables

• COUNT(<Expression>): Value = 1 if operand <> 0, otherwise 0 (numerator)

  Returns value 1 if the expression <> identified by <Expression> results in 0, otherwise 0.

• DATE: Processing a value as a date

  The value is given as the number of days starting from 01.01.0000 and then displayed as a date.

  The value can be between 0 and a million. This which allows for a date range between 01.01.0000 and 27.11.2738.

• DELTA(<Expression>): Value = 1 if operand = 0, otherwise 0

  Returns value 1 if the expression identified by <Expression> results in 0, otherwise 0.

  Caution

  This function is identical to the NOT operator and should not be used anymore.

• FIX(x): FIX (x): Fixed the context of the aggregation.

  Fixed the context of the aggregation. The operator prevents the exception aggregation from passing on its reference characteristics to the GROUP BY clause of the preceding aggregation and calculation steps. This allows execution of the constant selection before calculation of the formula, as expected.

  Note For more information, see FIX Operator
• NDIV(<Expression>): NDIV0 (x): Equals 0 when divided by 0, otherwise x

  Results in 0 if the expression identified by <Expression> is caused by a division by 0 during calculation. Otherwise, the result is the value of the expression. This is used in order to avoid error messages or so that you can continue calculating with a defined result.

• NODIM(<Expression>): Values Without Dimensions (Without Units)

  Returns purely numerical values of <expression> and suppresses units and currencies.

  Tip

  You can use this function to prevent the system from displaying the "mixed currency" character. See  SAP Reference IMG  SAP Customizing Implementation Guide  SAP NetWeaver  Business Warehouse  Settings for Reporting and Analysis  General Settings for Reporting and Analysis  Display of Numeric Values in Business Explorer .

• NOERR(<Expression>): NOERR (x): Equal to 0 for undefined calculations, otherwise x

  Results in 0 if the calculation of <expression> causes an arithmetical error. Otherwise, the result is the value of the expression. This is used in order to avoid error messages or so that you can continue calculating with a defined result.

  Tip

  NOERR(SQRT(-1)) = 0

• SUMCT <Operand>: Result

  Returns the result of the operand to all rows or columns (more information: Percentage Functions% CT).

  Table 1: Example Table for Operator SUMCT <Operand>

  Year	Region	Sales	SUMCT "Sales"
  1999	North	30	60
  	South	30	60
  	Result 1999	60	180
  2000	North	60	120
  	South	60	120
  	Result 2000	120	180
  Overall result		180	180

• SUMGT <Operand>: Overall result

  Returns the overall result of the operand (more information: Percentage Functions%GT).

  Table 2: Example Table for Operator SUMGT <Operand>

  Year	Region	Revenue	SUMGT "Sales"
  1999	North	30	180
  	South	30	180
  	Result 1999	60	180
  2000	North	60	180
  	South	60	180
  	Result 2000	120	180
  Overall result		180	180

• SUMRT <Operand>: Query Result

  Returns the query result of the operand (more information: Percentage Functions %RT).

  Unlike the process for calculating the overall result, dynamic filters are not used in the calculation of the query result. This means that the calculation always normalizes to the same value, irrespective of the filter status and the navigational state.

  Table 3: Example Table for Operator SUMRT <Operand>

  Year	Region	Revenue	SUMRT "Sales"
  1999	North	30	180
  	South	30	180
  	Result 1999	60	180
  Overall result		60	180

  The year 1999 is in the dynamic filter. The missing sales (120) come from the year 2000 (see SUMGT).

• TIME: Processing a Value as a Time

  The TIME operator takes any key figure or (partial) formula and makes a key figure of type TIME. Go to the formula editor. For the operator, double-click the Process Value as Time data function. For the operand, double-click the key figure you want. The formula could then be TIME(Sales).

  The system removes the decimal places, interprets the value as seconds, and returns the value in the form +-hh:mm:ss. -4812 is displayed as -1:20:12 for example.

  Any number is seen as the number of seconds from 00:00:00 and is displayed in hours, minutes, and seconds. A key figure of type TIME with value 0 is displayed as 00:00:00.

  Negative times are allowed: For a negative number the system calculates backwards from 00:00:00.

  You can enter any number of hours. After 24 hours, the system does not restart again at 0.

  Tip

  This function is mainly intended for offset calculations. If you want to calculate 4 hours for time key figures for example, you can use the TIME operator.