Datawarehouse Architect

  Bit_Length Returns the length, in bits, of a specified string. Each Unicode character is 2 bytes in length, which is equal to 16 bits.   Syntax Bit_Length(strExpr) Where: strExpr Any expression that evaluates to a character string.   Practical Usage in Answers Using the Paint Business Area SELECT Markets.Region saw_0, bit_length(Markets.Region) saw_1, bit_length('C') saw_2, bit_length('a') saw_3 FROM Paint ORDER BY saw_0, saw_1, saw_2, saw_3  

Percentile Calculates a percentile rank for each value satisfying the numeric expression argument. The percentile rank ranges are between 0 (0th percentile) to 1 (100th percentile). The percentile is calculated based on the values in the result set.   Syntax Percentile(Expr) Where: Expr Any expression that evaluates to a numerical value.

Upper Converts a character string to uppercase.   Syntax Upper(strExpr) Where: strExpr Any expression that evaluates to a character string.

Rank Calculates the rank for each value satisfying the numeric expression argument. The highest number is assigned a rank of 1, and each successive rank is assigned the next consecutive integer (2, 3, 4,...). If certain values are equal, they are assigned the same rank (for example, 1, 1, 1, 4, 5, 5, 7...). The rank is calculated based on the values in the result set.   Syntax Rank(Expr) Where: Expr Any expression that evaluates to a numerical value.

Count Calculates the number of rows having a nonnull value for the expression. The expression is typically a column name, in which case the number of rows with nonnull values for that column is returned. Syntax Count(numExpr) Where: numExpr Any expression that evaluates to a numerical value.

Current_Time Returns the current time. The time is determined by the system in which the Oracle BI Server is running.   Note:  The Analytics Server does not cache queries that contain this function. Syntax Current_Time(integer) Where: integer Any integer that represents the number of digits of precision with which to display the fractional second.