VB Function Support in Function Selector
The Oracle Hyperion Calculation Manager Function Selector supports these VB functions.
Note:
You can also use other VB functions in the script component, even though they are not available in the UI for selection.
Array Functions
| Function | Description |
|---|---|
|
Array |
Returns a variant containing an array |
|
Filter |
Returns a zero-based array that contains a subset of a string array based on a filter criteria |
|
Join |
Returns a string that consists of a number of substrings in an array |
|
LBound |
Returns the smallest subscript for the indicated dimension of an array |
|
Split |
Returns a zero-based, one-dimensional array that contains a specified number of substrings |
|
UBound |
Returns the largest subscript for the indicated dimension of an array |
Date Time Functions
| Function | Description |
|---|---|
|
Date |
Returns the current system date |
|
DateAdd |
Returns a date to which a specified time interval has been added |
|
DateDiff |
Returns the number of intervals between two dates |
|
DatePart |
Returns the specified part of a specified date |
|
DateSerial |
Returns the date for a specified year, month, and day |
|
Day |
Returns a number that represents the day of the month (between 1 and 31, inclusive) |
|
Month |
Returns a number that represents the month of the year (between 1 and 12, inclusive) |
|
MonthName |
Returns the name of a specified month |
Mathematical
| Function | Description |
|---|---|
|
Abs |
Returns the absolute value of a specified number |
|
Fix |
Returns the integer part of a specified number |
|
Int |
Returns the integer part of a specified number |
String
| Function | Description |
|---|---|
|
InStr |
Returns the position of the first occurrence of one string within another. The search begins at the first character of the string. |
|
InStrRev |
Returns the position of the first occurrence of one string within another. The search begins at the last character of the string. |
|
LCase |
Converts a specified string to lowercase |
|
Left |
Returns a specified number of characters from the left side of a string |
|
Len |
Returns the number of characters in a string |
|
Mid |
Returns a specified number of characters from a string |
|
Right |
Returns a specified number of characters from the right side of a string |
|
StrComp |
Compares two strings and returns a value that represents the result of the comparison |
|
Trim |
Removes spaces on both the left and right side of a string |
|
UCase |
Converts a specified string to uppercase |