- Shuffle
Toggle OnToggle Off
- Alphabetize
Toggle OnToggle Off
- Front First
Toggle OnToggle Off
- Both Sides
Toggle OnToggle Off
Front
How to study your flashcards.
Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key
Up/Down arrow keys: Flip the card between the front and back.down keyup key
H key: Show hint (3rd side).h key
PLAY BUTTON
PLAY BUTTON
895 Cards in this Set
- Front
- Back
|
Syntax: -
|
- value
|
|
Syntax: aggregate
|
aggregate ( < currentMeasure|numeric_expression > within set set_expression ) aggregate ( < currentMeasure|numeric_expression > within < detail|aggregate > expression )
|
|
Syntax: (
|
( expression )
|
|
Syntax: )
|
( expression )
|
|
Syntax: *
|
value1 * value2
|
|
Syntax: ,
|
expression ( parameter1, parameter2 )
|
|
Syntax: /
|
value1 / value2
|
|
Syntax: _add_days
|
_add_days ( date_expression, integer_expression )
|
|
Syntax: _add_days
|
_add_days ( string_expression , integer_expression )
|
|
Syntax: _add_days
|
_add_days ( timestamp_expression , integer_expression )
|
|
Syntax: _add_months
|
_add_months ( date_expression, integer_expression )
|
|
Syntax: _add_months
|
_add_months ( string_expression , integer_expression )
|
|
Syntax: _add_months
|
_add_months ( timestamp_expression , integer_expression )
|
|
Syntax: _add_years
|
_add_years ( date_expression, integer_expression )
|
|
Syntax: _add_years
|
_add_years ( string_expression , integer_expression )
|
|
Syntax: _add_years
|
_add_years ( timestamp_expression , integer_expression )
|
|
Syntax: _age
|
_age ( date_expression )
|
|
Syntax: _age
|
_age ( timestamp_expression )
|
|
Syntax: _day_of_week
|
_day_of_week ( date_expression, integer )
|
|
Syntax: _day_of_week
|
_day_of_week ( timestamp_expression , integer_expression )
|
|
Syntax: _day_of_year
|
_day_of_year ( date_expression )
|
|
Syntax: _day_of_year
|
_day_of_year ( timestamp_expression )
|
|
Syntax: _days_between
|
_days_between ( date_expression1 , date_expression2 )
|
|
Syntax: _days_between
|
_days_between ( timestamp_expression1 , timestamp_expression2 )
|
|
Syntax: _days_to_end_of_month
|
_days_to_end_of_month ( date_expression )
|
|
Syntax: _days_to_end_of_month
|
_days_to_end_of_month ( timestamp_expression )
|
|
Syntax: _first_of_month
|
_first_of_month ( date_expression )
|
|
Syntax: _first_of_month
|
_first_of_month ( string_expression )
|
|
Syntax: _first_of_month
|
_first_of_month ( timestamp_expression )
|
|
Syntax: _firstFromSet
|
_firstFromSet ( set_expression , numeric_expression_maximum , numeric_expression_ overflow )
|
|
Syntax: _format
|
_format ( expression , format_keyword ) Example _format ( [Unit Sale Price] / [Unit Price] , PERCENTAGE_2 ) Result: 75.12%
|
|
Syntax: _last_of_month
|
_last_of_month ( date_expression )
|
|
Syntax: _last_of_month
|
_last_of_month ( string_expression )
|
|
Syntax: _last_of_month
|
_last_of_month ( timestamp_expression )
|
|
Syntax: _make_timestamp
|
_make_timestamp ( integer_expression1, integer_expression2, integer_ expression3 )
|
|
Syntax: _make_timestamp
|
_make_timestamp ( integer_expression1 , integer_expression2 , integer_ expression3 )
|
|
Syntax: _months_between
|
_months_between ( date_expression1, date_expression2 )
|
|
Syntax: _months_between
|
_months_between ( timestamp_expression1 , timestamp_expression2 )
|
|
Syntax: _remainderSet
|
_remainderSet ( member_expression, set_expression , numeric_expression )
|
|
Syntax: _round
|
_round ( numeric_expression , integer_expression )
|
|
Syntax: _week_of_year
|
_week_of_year ( date_expression )
|
|
Syntax: _week_of_year
|
_week_of_year ( timestamp_expression )
|
|
Syntax: _years_between
|
_years_between ( date_expression1, date_expression2 )
|
|
Syntax: _years_between
|
_years_between ( timestamp_expression1 , timestamp_expression2 )
|
|
Syntax: _ymdint_between
|
_ymdint_between ( date_expression1 , date_expression2 )
|
|
Syntax: _ymdint_between
|
_ymdint_between ( timestamp_expression1 , timestamp_expression2 )
|
|
Syntax: {current_catalog}
|
{current_catalog}
|
|
Syntax: {current_db}
|
{current_db}
|
|
Syntax: {current_db}
|
{current_db}
|
|
Syntax: {current_schema}
|
{current_schema}
|
|
Syntax: {current_user}
|
{current_user}
|
|
Syntax: {current_user}
|
{ current_user }
|
|
Syntax: {current_user}
|
{ current_user }
|
|
Syntax: {current_user}
|
{current_user}
|
|
Syntax: {current_user}
|
{current_user}
|
|
Syntax: {current_user}
|
{current_user}
|
|
Syntax: {current_user}
|
{current_user}
|
|
Syntax: {session_user}
|
{session_user}
|
|
Syntax: {session_user}
|
{session_user}
|
|
Syntax: {session_user}
|
{session_user}
|
|
Syntax: {session_user}
|
{session_user}
|
|
Syntax: {session_user}
|
{session_user}
|
|
Syntax: {sysdate}
|
{ sysdate }
|
|
Syntax: {user}
|
{ user }
|
|
Syntax: ||
|
string1 || string2
|
|
Syntax: +
|
value1 + value2
|
|
Syntax: +
|
value1 + value2
|
|
Syntax: <
|
value1 < value2
|
|
Syntax: <=
|
value1 <= value2
|
|
Syntax: <>
|
value1 <> value2
|
|
Syntax: =
|
value1 = value2
|
|
Syntax: ->
|
[namespace].[dimension].[hierarchy].[level]->[L1]
|
|
Syntax: >
|
value1 > value2
|
|
Syntax: >=
|
value1 >= value2
|
|
Syntax: abs
|
abs ( numeric_expression )
|
|
Syntax: abs
|
abs ( numeric_expression )
|
|
Syntax: account
|
{account}
|
|
Syntax: acos
|
acos ( numeric_expression )
|
|
Syntax: acos
|
acos ( numeric_expression )
|
|
Syntax: acos
|
acos ( numeric_expression )
|
|
Syntax: acos
|
acos ( numeric_expression )
|
|
Syntax: acos
|
acos ( numeric_expression )
|
|
Syntax: acos
|
acos ( numeric_expression )
|
|
Syntax: acos
|
acos ( numeric_expression )
|
|
Syntax: acos
|
acos ( numeric_expression )
|
|
Syntax: acos
|
acos ( numeric_expression )
|
|
Syntax: acos
|
acos ( numeric_expression )
|
|
Syntax: acosh
|
acosh ( numeric_expression )
|
|
Syntax: add_months
|
add_months ( date_expression , integer_expression )
|
|
Syntax: add_months
|
add_months ( date_expression|datetime_expression , integer_expression )
|
|
Syntax: aggregate
|
aggregate ( expression [ auto ] ) aggregate ( expression for [ all|any ] expression { , expression } ) aggregate ( expression for report )
|
|
Syntax: ancestor
|
ancestor ( member, level|integer ) Example 1 ancestor ( [TrailChef Water Bag] , 1 ) Result: Cooking Gear Example 2 ancestor ( [TrailChef Water Bag] , 2 ) Result: Camping Equipment Example 3 ancestor ( [TrailChef Water Bag] , [great_outdoors_company].[Products]. [Products].[Product type] ) Result: Cooking Gear
|
|
Syntax: ancestors
|
ancestors ( member , level|index ) Example 1 ancestors ( [TrailChef Water Bag] , 1 ) Result: Cooking Gear Example 2 ancestors ( [TrailChef Water Bag] , 2 ) Result: Camping Equipment Example 3 ancestors ( [TrailChef Water Bag] , [great_outdoors_company].[Products]. [Products].[Product type] ) Result: Cooking Gear
|
|
Syntax: and
|
argument1 and argument2
|
|
Syntax: arccos
|
arccos ( numeric_expression )
|
|
Syntax: arcsin
|
arcsin ( numeric_expression )
|
|
Syntax: arctan
|
arctan ( numeric_expression )
|
|
Syntax: array
|
array ( string_expression|array_expression { , string_expression|array_ expression } )
|
|
Syntax: ascii
|
ascii ( string_expression ) Example ascii ( a ) Result: Returns 65, the ASCII code value of "a".
|
|
Syntax: ascii
|
ascii ( string_expression )
|
|
Syntax: ascii
|
ascii ( string_expression )
|
|
Syntax: ascii
|
ascii ( string_expression )
|
|
Syntax: ascii
|
ascii ( string_expression )
|
|
Syntax: ascii
|
ascii ( string_expression )
|
|
Syntax: ascii
|
ascii ( string_expression )
|
|
Syntax: ascii
|
ascii ( string_expression )
|
|
Syntax: ascii
|
ascii ( string_expression )
|
|
Syntax: ascii
|
ascii ( string_expression )
|
|
Syntax: asin
|
asin ( numeric_expression )
|
|
Syntax: asin
|
asin ( numeric_expression )
|
|
Syntax: asin
|
asin ( numeric_expression )
|
|
Syntax: asin
|
asin ( numeric_expression )
|
|
Syntax: asin
|
asin ( numeric_expression )
|
|
Syntax: asin
|
asin ( numeric_expression )
|
|
Syntax: asin
|
asin ( numeric_expression )
|
|
Syntax: asin
|
asin ( numeric_expression )
|
|
Syntax: asin
|
asin ( numeric_expression )
|
|
Syntax: asin
|
asin ( numeric_expression )
|
|
Syntax: asinh
|
asinh ( numeric_expression )
|
|
Syntax: AsOfDate
|
AsOfDate ()
|
|
Syntax: AsOfTime
|
AsOfTime ()
|
|
Syntax: atan
|
atan ( numeric_expression )
|
|
Syntax: atan
|
atan ( numeric_expression )
|
|
Syntax: atan
|
atan ( numeric_expression )
|
|
Syntax: atan
|
atan ( numeric_expression )
|
|
Syntax: atan
|
atan ( numeric_expression )
|
|
Syntax: atan
|
atan ( numeric_expression )
|
|
Syntax: atan
|
atan ( numeric_expression )
|
|
Syntax: atan
|
atan ( numeric_expression )
|
|
Syntax: atan
|
atan ( numeric_expression )
|
|
Syntax: atan
|
atan ( numeric_expression )
|
|
Syntax: atan2
|
atan2 ( numeric_expression1 , numeric_expression2 )
|
|
Syntax: atan2
|
atan2 ( numeric_expression1 , numeric_expression2 )
|
|
Syntax: atan2
|
atan2 ( numeric_expression1, numeric_expression2 )
|
|
Syntax: atan2
|
atan2 ( numeric_expression1 , numeric_expression2 )
|
|
Syntax: atan2
|
atan2 ( numeric_expression1 , numeric_expression2 )
|
|
Syntax: atan2
|
atan2 ( numeric_expression1 ,numeric_expression2 )
|
|
Syntax: atan2
|
atan2 ( numeric_expression1 ,numeric_expression2 )
|
|
Syntax: atan2
|
atan2 ( numeric_expression1 ,numeric_expression2 )
|
|
Syntax: atanh
|
atanh ( numeric_expression )
|
|
Syntax: atn2
|
atn2 ( numeric_expression1, numeric_expression2 )
|
|
Syntax: atn2
|
atn2 ( numeric_expression1, numeric_expression2 )
|
|
Syntax: auto
|
aggregate_function ( expression AUTO )
|
|
Syntax: average
|
average ( < currentMeasure|numeric_expression > within set set_expression ) average ( < currentMeasure|numeric_expression > within < detail|aggregate > expression )
|
|
Syntax: average
|
average ( [ distinct ] expression [ auto ] ) average ( [ distinct ] expression for [ all|any ] expression { , expression } ) average ( [ distinct ] expression for report )
|
|
Syntax: between
|
expression between value1 and value2
|
|
Syntax: bottomCount
|
bottomCount ( set_expression , index_expression , numeric_expression ) Example bottomCount ( [great_outdoors_company].[Products].[Products].[Product line] , 2 , [Revenue] ) Result: Returns the bottom two members of the set sorted by revenue. Product line Revenue ------- ------- Outdoor Protection $3,171,114.92 Mountaineering Equipment $20,891,350.60
|
|
Syntax: bottomPercent
|
bottomPercent ( set_expression , numeric_expression1 , numeric_expression2 ) Example bottomPercent ( set ( [Camping Equipment] , [Golf Equipment] , [Mountaineering Equipment] ) , 40 , [2006] ) Result: For the set of Camping Equipment, Golf Equipment, and Mountaineering Equipment, returns the members whose percentage total are less than or equal to 40% for 2006.
|
|
Syntax: bottomSum
|
bottomSum ( set_expression , numeric_expression1 , numeric_expression2 ) Example bottomSum ( members ( [great_outdoors_company].[Products].[Products].[Product line] ) , 6000000 , tuple ( [2006] , [great_outdoors_company].[Measures].[Gross profit] ) )
|
|
Syntax: btrim
|
btrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: btrim
|
btrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: btrim
|
btrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: BurstKey
|
BurstKey ()
|
|
Syntax: BurstRecipients
|
BurstRecipients ()
|
|
Syntax: bytes
|
bytes ( byte_expression )
|
|
Syntax: CAMIDList
|
CAMIDList ( [ separator_string ] )
|
|
Syntax: CAMIDListForType
|
CAMIDListForType ( identity type )
|
|
Syntax: CAMPassport
|
CAMPassport ( )
|
|
Syntax: caption
|
caption ( level|member|set_expression ) Example 1 caption ( [TrailChef Water Bag] ) Result: TrailChef Water Bag Example 2 caption ( [great_outdoors_company].[Products].[Products].[Product line] ) Result: Returns the caption values of the Product line set. Camping Equipment Mountaineering Equipment Personal Accessories Outdoor Protection Golf Equipment
|
|
Syntax: cardinality
|
cardinality ( string_expression )
|
|
Syntax: case
|
case expression { when expression then expression } [ else expression ] end
|
|
Syntax: case_n
|
case_n ( condition_expression_list [ , NO CASE|UNKNOWN|NO CASE OR UNKNOWN [ , UNKNOWN ] ] )
|
|
Syntax: cast
|
cast ( expression , datatype_specification )
|
|
Syntax: cbrt
|
cbrt ( numeric_expression )
|
|
Syntax: cbrt
|
cbrt ( numeric_expression )
|
|
Syntax: cbrt
|
cbrt ( numeric_expression )
|
|
Syntax: cbrt
|
cbrt ( numeric_expression )
|
|
Syntax: ceil
|
ceil ( numeric_expression )
|
|
Syntax: ceil
|
ceil ( numeric_expression )
|
|
Syntax: ceil
|
ceil ( numeric_expression|string_expression )
|
|
Syntax: ceiling
|
ceiling ( numeric_expression )
|
|
Syntax: ceiling
|
ceiling ( numeric_expression ) Example ceiling ( 0.75 ) Result: Returns 0.8.
|
|
Syntax: ceiling
|
ceiling ( numeric_expression )
|
|
Syntax: ceiling
|
ceiling ( numeric_expression )
|
|
Syntax: CellValue
|
CellValue ()
|
|
Syntax: char
|
char ( expression )
|
|
Syntax: char
|
char ( integer_expression )
|
|
Syntax: char
|
char ( integer_expression )
|
|
Syntax: char_length
|
char_length ( string_expression )
|
|
Syntax: char_length
|
char_length ( string_expression )
|
|
Syntax: char_length
|
char_length ( string_expression )
|
|
Syntax: char2hexint
|
char2hexint ( string_expression )
|
|
Syntax: character_length
|
character_length ( string_expression )
|
|
Syntax: character_length
|
character_length ( string_expression )
|
|
Syntax: characters
|
characters ( string_expression )
|
|
Syntax: charindex
|
charindex ( string_expression1 , string_expression2 [ , start_location ] )
|
|
Syntax: charindex
|
charindex ( string_expression1 , string_expression2 )
|
|
Syntax: children
|
children ( member ) Example children ( [Camping Equipment] ) Result: Returns the set of children for Camping Equipment. Cooking Gear Tents Sleeping Bags Packs Lanterns
|
|
Syntax: chr
|
chr ( integer_expression )
|
|
Syntax: chr
|
chr ( integer_expression )
|
|
Syntax: chr
|
chr ( integer_expression )
|
|
Syntax: chr
|
chr ( integer_expression )
|
|
Syntax: chr
|
chr ( integer_expression )
|
|
Syntax: chr
|
chr ( integer_expression )
|
|
Syntax: chr
|
chr ( integer_expression )
|
|
Syntax: closingPeriod
|
closingPeriod ( level [ , member ] ) Example 1 closingPeriod ( [great_outdoors_company].[Years].[Years].[Month] ) Result: 2006/Dec Example 2 closingPeriod ( [great_outdoors_company].[Years].[Years].[Year] ) Result: 2006 Example 3 closingPeriod ( [great_outdoors_company].[Years].[Years].[Month] , [2006 Q 4] ) Result: 2006/Dec
|
|
Syntax: coalesce
|
coalesce ( expression_list )
|
|
Syntax: ColumnNumber
|
ColumnNumber ()
|
|
Syntax: completeTuple
|
completeTuple ( member { , member } ) Example 1 completeTuple ( [Mountaineering Equipment] , [Fax] ) Result: The completeTuple does not pick up the currentMember by default as the tuple function does. The values in the first column are identical across each year because the default member of the Years dimension, the root member, is used rather than the current member. Likewise, the first column displays Revenue rather than Quantity Sold because the Revenue measure is the default from the Measures dimension. CompleteTuple will use the default measure rather than the current- Measure in the query if the measure is not defined in the completetuple function. Quantity Sold Mountaineering Sales by Fax --------------- -------------- 2004 $1,220,329.38 2005 $1,220,329.38 2006 $1,220,329.38 Example 2 completeTuple ( [Mountaineering Equipment] , [Fax] , [Quantity sold] , currentMember ( [great_outdoors_company].[Years].[Years] ) ) Result: The completeTuple function uses the currentMember of the Years dimension and the Quantity sold measure. Quantity Sold Mountaineering Sales by Fax --------------- -------------- 2004 0 2005 8,746 2006 7,860
|
|
Syntax: concat
|
concat ( string_expression1, string_expression2 )
|
|
Syntax: concat
|
concat ( string_expression1 , string_expression2 )
|
|
Syntax: concat
|
concat ( string_expression1 , string_expression2 )
|
|
Syntax: concat
|
concat ( string_expression1 , string_expression2 )
|
|
Syntax: concat
|
concat ( string_expression1 , string_expression2 )
|
|
Syntax: contains
|
string1 contains string2
|
|
Syntax: cos
|
cos ( numeric_expression ) cosh Returns the hyperbolic cosine of "numeric_expression" where "numeric_expression" is an angle expressed in radians. Syntax cosh ( numeric_expression ) cot Returns the cotangent of "numeric_expression" where "numeric_expression" is an angle expressed in radians. Syntax cot ( numeric_expression ) degrees Returns "numeric_expression" radians converted to degrees. Syntax degrees ( numeric_expression ) sin Returns the sine of "numeric_expression" where "numeric_expression" is an angle expressed in radians. Syntax sin ( numeric_expression ) sinh Returns the hyperbolic sine of "numeric_expression" where "numeric_expression" is an angle expressed in radians. Syntax sinh ( numeric_expression ) tan Returns the tangent of "numeric_expression" where "numeric_expression" is an angle expressed in radians. Syntax tan ( numeric_expression ) tanh Returns the hyperbolic tangent of "numeric_expression" where "numeric_expression" is an angle expressed in radians. Syntax tanh ( numeric_expression )
|
|
Syntax: cos
|
cos ( numeric_expression )
|
|
Syntax: cos
|
cos ( numeric_expression ) sin Returns the sine of "numeric_expression" where "numeric_expression" is an angle expressed in radians. Syntax sin ( numeric_expression ) tan Returns the tangent of "numeric_expression" where "numeric_expression" is an angle expressed in radians. Syntax tan ( numeric_expression )
|
|
Syntax: cos
|
cos ( numeric_expression )
|
|
Syntax: cos
|
cos ( numeric_expression )
|
|
Syntax: cos
|
cos ( numeric_expression )
|
|
Syntax: cos
|
cos ( numeric_expression )
|
|
Syntax: cos
|
cos ( numeric_expression )
|
|
Syntax: cos
|
cos ( numeric_expression )
|
|
Syntax: cos
|
cos ( numeric_expression )
|
|
Syntax: cos
|
cos ( numeric_expression )
|
|
Syntax: cos
|
cos ( numeric_expression )
|
|
Syntax: cos
|
cos ( numeric_expression )
|
|
Syntax: cosh
|
cosh ( numeric_expression )
|
|
Syntax: cosh
|
cosh ( numeric_expression )
|
|
Syntax: coshyp
|
coshyp ( numeric_expression )
|
|
Syntax: cot
|
cot ( numeric_expression )
|
|
Syntax: cot
|
cot ( numeric_expression )
|
|
Syntax: cot
|
cot ( numeric_expression )
|
|
Syntax: cot
|
cot ( numeric_expression )
|
|
Syntax: cot
|
cot ( numeric_expression )
|
|
Syntax: cot
|
cot ( numeric_expression )
|
|
Syntax: count
|
count ( < currentMeasure|numeric_expression > within set set_expression ) count ( < currentMeasure|numeric_expression > within < detail|aggregate > expression )
|
|
Syntax: count
|
count ( [ distinct ] expression [ auto ] ) count ( [ distinct ] expression for [ all|any ] expression { , expression } ) count ( [ distinct ] expression for report )
|
|
Syntax: cousin
|
cousin ( member1 , member2 ) Example 1 cousin ( [Irons] , [Camping Equipment] ) Result: Cooking Gear Example 2 cousin ( [Putters] , [Camping Equipment] ) Result: Sleeping Bags
|
|
Syntax: csv
|
csv ( array_expression [ , separator_string [ , quote_string ] ] )
|
|
Syntax: CSVIdentityName
|
CSVIdentityName ( %parameter_map_name [ , separator_string ] )
|
|
Syntax: CSVIdentityNameList
|
CSVIdentityNameList ( [ separator_string ] )
|
|
Syntax: CubeCreatedOn
|
CubeCreatedOn ( dimension )
|
|
Syntax: CubeCurrentPeriod
|
CubeCurrentPeriod ( dimension )
|
|
Syntax: CubeDataUpdatedOn
|
CubeDataUpdatedOn ( dimension )
|
|
Syntax: CubeDefaultMeasure
|
CubeDefaultMeasure ( dimension )
|
|
Syntax: CubeDescription
|
CubeDescription ( dimension )
|
|
Syntax: CubeIsOptimized
|
CubeIsOptimized ( dimension )
|
|
Syntax: CubeName
|
CubeName ( dimension )
|
|
Syntax: CubeSchemaUpdatedOn
|
CubeSchemaUpdatedOn ( dimension )
|
|
Syntax: curdate
|
curdate ()
|
|
Syntax: current_database
|
current_database ()
|
|
Syntax: current_database
|
current_database ()
|
|
Syntax: current_database
|
current_database ()
|
|
Syntax: current_date
|
current_date
|
|
Syntax: current_schema
|
current_schema ()
|
|
Syntax: current_schema
|
current_schema ()
|
|
Syntax: current_schema
|
current_schema ()
|
|
Syntax: current_time
|
current_time
|
|
Syntax: current_timestamp
|
current_timestamp
|
|
Syntax: currentMeasure
|
aggregate_function ( currentMeasure within set expression )
|
|
Syntax: currentMember
|
currentMember ( hierarchy )
|
|
Syntax: curtime
|
curtime ()
|
|
Syntax: Data Type Casting Functions
|
date2string ( date_expression )
|
|
Syntax: database
|
{database}
|
|
Syntax: database
|
database ()
|
|
Syntax: datalength
|
datalength ( string_expression )
|
|
Syntax: datalength
|
datalength ( string_expression )
|
|
Syntax: date
|
date ( expression )
|
|
Syntax: date
|
date ( string_expression|date_expression|integer_expression )
|
|
Syntax: date
|
date ( expression )
|
|
Syntax: date
|
{date}
|
|
Syntax: date_trunc
|
date_trunc ( string_expression1 , date_expression1 )
|
|
Syntax: date_trunc
|
date_trunc ( string_expression , timestamp_expression )
|
|
Syntax: date_trunc
|
date_trunc ( string_expression , timestamp_expression)
|
|
Syntax: date_trunc
|
date_trunc ( string_expression , timestamp_expression)
|
|
Syntax: date2timestamp
|
date2timestamp ( date_expression )
|
|
Syntax: date2timestampTZ
|
date2timestampTZ ( date_expression )
|
|
Syntax: dateadd
|
dateadd ( { datepart } , interval, datetime_expression )
|
|
Syntax: dateadd
|
dateadd ( { datepart } , integer_expression , date_expression )
|
|
Syntax: dateadd
|
dateadd ( ' { ' datepart ' } ' , integer_expression , date_expression )
|
|
Syntax: datediff
|
datediff ( { datepart } , datetime_expression1, datetime_expression2 )
|
|
Syntax: datediff
|
datediff ( {datepart} , date_expression1 , date_expression2 )
|
|
Syntax: datediff
|
datediff ( ' { ' datepart ' } ' , date_expression1 , date_expression2 )
|
|
Syntax: datename
|
datename ( { datepart } , datetime_expression )
|
|
Syntax: datename
|
datename ( ' { ' datepart ' } ' , date_expression )
|
|
Syntax: datename
|
datename ( ' { ' datepart ' } ' , date_expression )
|
|
Syntax: datepart
|
datepart ( ' { ' datepart ' } ' , date_expression )
|
|
Syntax: datepart
|
datepart ( ' { ' datepart ' } ' , date_expression )
|
|
Syntax: day
|
day ( date_expression )
|
|
Syntax: day
|
day ( date_expression )
|
|
Syntax: day
|
day ( date_expression )
|
|
Syntax: day
|
day ( date_expression )
|
|
Syntax: dayname
|
dayname ( date_expression )
|
|
Syntax: dayname
|
dayname ( date_expression )
|
|
Syntax: dayofmonth
|
dayofmonth ( date_expression|interval_expression )
|
|
Syntax: dayofweek
|
dayofweek ( date_expression )
|
|
Syntax: dayofweek
|
dayofweek ( date_expression )
|
|
Syntax: dayofweek_iso
|
dayofweek_iso ( date_expression )
|
|
Syntax: dayofyear
|
dayofyear ( date_expression )
|
|
Syntax: dayofyear
|
dayofyear ( date_expression )
|
|
Syntax: days
|
days ( expression )
|
|
Syntax: DB2 Math
|
log ( numeric_expression ) log10 Returns the base ten logarithm of "numeric_expression". Syntax log10 ( numeric_expression ) rand Generates a random number using "integer_expression" as a seed value. Syntax rand ( integer_expression )
|
|
Syntax: DB2 Trigonometry
|
acos ( numeric_expression ) asin Returns the arcsine of "numeric_expression" in radians. The arcsine is the angle whose sine is "numeric_expression". Syntax asin ( numeric_expression ) atan Returns the arctangent of "numeric_expression" in radians. The arctangent is the angle whose tangent is "numeric_expression". Syntax atan ( numeric_expression ) atanh Returns the hyperbolic arctangent of "numeric_expression" where "numeric_expression" is an angle expressed in radians. Syntax atanh ( numeric_expression ) atan2 Returns the arctangent of the x and y coordinates specified by "numeric_expression1" and "numeric_ expression2", respectively, in radians. The arctangent is the angle whose tangent is "numeric_ expression2" / "numeric_expression1". Syntax atan2 ( numeric_expression1 , numeric_expression2 )
|
|
Syntax: dbl_mp
|
dbl_mp ( string_expression )
|
|
Syntax: dec
|
dec ( string_expression1 [ , numeric_expression1 [ , numeric_expression2 [ , string_expression2 ] ] ] )
|
|
Syntax: dec
|
dec ( expression , [ precision , scale ] )
|
|
Syntax: decimal
|
decimal ( string_expression1 [ , numeric_expression1 [ , numeric_expression2 [ , string_expression2 ] ] ] )
|
|
Syntax: decimal
|
decimal ( expression , [ precision , scale ] )
|
|
Syntax: decode
|
decode ( expr , search , result [ , search , result]... [ , default] )
|
|
Syntax: decode
|
decode ( expression , search , result [ , search , result ]... [ , default ] )
|
|
Syntax: decode
|
decode ( expression , target , replacement [ ,default ] )
|
|
Syntax: default
|
lookup (....) in (....) default (....)
|
|
Syntax: defaultMember
|
defaultMember ( hierarchy ) Example 1 defaultMember ( [great_outdoors_company].[Products].[Products] ) Result: Products Example 2 defaultMember ( [great_outdoors_company].[Years].[Years] ) Result: Year Example 3 defaultMember ( hierarchy ( [great_outdoors_company].[Measures].[Quantity sold] ) ) Result: Revenue
|
|
Syntax: degrees
|
degrees ( numeric_expression )
|
|
Syntax: degrees
|
degrees ( numeric_expression )
|
|
Syntax: degrees
|
degrees ( numeric_expression )
|
|
Syntax: degrees
|
degrees ( numeric_expression )
|
|
Syntax: degrees
|
degrees ( numeric_expression )
|
|
Syntax: degrees
|
degrees ( numeric_expression )
|
|
Syntax: degrees
|
degrees ( numeric_expression )
|
|
Syntax: descendants
|
descendants ( member|set_expression , level|distance [ , { self|before| beforewithmember|after } ] ) Example 1 descendants ( [great_outdoors_company].[Products].[Products].[Products] , [great_ outdoors_company].[Products].[Products].[Product type] ) Result: Returns the set of descendants of the Products set at the Product type level. Note: [great_ outdoors_company].[Products].[Products].[Products] is the root member of the Products hierarchy. Cooking Gear Sleeping Bags Packs Tents ... Eyewear Knives Watches Example 2 descendants ( [great_outdoors_company].[Products].[Products].[Products] , 1 ) Result: Returns the set of descendants of the Products set at the first level. Camping Equipment Golf Equipment Mountaineering Equipment Outdoor Protection Personal Accessories Example 3 descendants ( [great_outdoors_company].[Products].[Products]. [Products] , 3 , before ) Result: Returns the descendants of the Products set before the third level. Camping Equipment Cooking Gear Sleeping Bags Packs Tents ... Eyewear Knives Watches Example 4 descendants ( [great_outdoors_company].[Products].[Products]. [Products] , 2 , self before ) Result: Returns the set of descendants of the Products set before and including the second level. Camping Equipment Cooking Gear Sleeping Bags Packs Tents ... Eyewear Knives Watches
|
|
Syntax: difference
|
difference ( string_expression1 , string_expression2 )
|
|
Syntax: difference
|
difference ( string_expression1 , string_expression2 )
|
|
Syntax: difference
|
difference ( string_expression1 , string_expression2 )
|
|
Syntax: digits
|
digits ( numeric_expression )
|
|
Syntax: distinct
|
end
|
|
Syntax: div
|
div ( numeric_expression1 , numeric_expression2 )
|
|
Syntax: dle_dst
|
dle_dst ( string_expression1 , string_expression2 )
|
|
Syntax: double
|
double ( expression )
|
|
Syntax: dq
|
dq ( string_expression )
|
|
Syntax: DTinterval2string
|
DTinterval2string ( date_time_interval_expression )
|
|
Syntax: DTinterval2stringAsTime
|
DTinterval2stringAsTime ( date_time_interval_expression )
|
|
Syntax: dump
|
dump ( expression [ , numeric_expression1 [ , numeric_expression2 [ , numeric_ expression3 ] ] ] )
|
|
Syntax: emptySet
|
emptySet ( hierarchy ) Example except ( [great_outdoors_company].[Products].[Products].[Product line] , emptyset ( [great_outdoors_company].[Products].[Products] ) ) Result: Returns the Product line set and an empty set for the Products set. Camping Equipment Golf Equipment Mountaineering Equipment Outdoor Protection Personal Accessories
|
|
Syntax: end
|
case .... end
|
|
Syntax: ends with
|
string1 ends with string2
|
|
Syntax: event_mon_state
|
event_mon_state ( string_expression )
|
|
Syntax: except
|
except ( set_expression1 , set_expression2 [ , all ] ) Example except ( set ( [Camping Equipment] , [Mountaineering Equipment] ) , set ( [Camping Equipment] , [Golf Equipment] ) ) Result: Mountaineering Equipment
|
|
Syntax: exp
|
exp ( numeric_expression )
|
|
Syntax: exp
|
exp ( numeric_expression )
|
|
Syntax: extend
|
extend ( date_expression , ' { ' year to second ' } ' )
|
|
Syntax: extract
|
extract ( datepart , datetime_expression )
|
|
Syntax: extract
|
extract ( date_part_expression , datetime_expression )
|
|
Syntax: filter
|
filter ( set_expression , Boolean_expression ) Example filter ( [Product line] , [Gross margin] > .30 ) Result: Mountaineering Equipment
|
|
Syntax: firstChild
|
firstChild ( member ) Example 1 firstChild ( [By Product Lines] ) Result: Camping Equipment Example 2 firstChild ( [Camping Equipment] ) Result: Cooking Gear
|
|
Syntax: firstSibling
|
firstSibling ( member ) Example 1 firstSibling ( [Outdoor Protection] ) Result: Camping Equipment Example 2 firstSibling ( [Camping Equipment] ) Result: Camping Equipment
|
|
Syntax: float
|
float ( numeric_expression )
|
|
Syntax: float
|
float ( numeric_expression )
|
|
Syntax: floor
|
floor ( numeric_expression )
|
|
Syntax: floor
|
floor ( numeric_expression )
|
|
Syntax: for
|
aggregate_function ( expression for expression { , expression } )
|
|
Syntax: for all
|
aggregate_function ( expression for ALL expression { , expression } )
|
|
Syntax: for any
|
aggregate_function ( expression for ANY expression { , expression } )
|
|
Syntax: for report
|
aggregate_function ( expression for report )
|
|
Syntax: format
|
format ( expression )
|
|
Syntax: generate
|
generate ( set_expression1 , set_expression2 [ , all ] ) Example generate ( [Product line] , topCount ( descendants ( currentMember ( [great_ outdoors_company].[Products].[Products] ) , [great_outdoors_company].[Products]. [Products].[Product name] ) , 2 , [Revenue] ) ) Result: Returns the top two products by revenue for each product line.
|
|
Syntax: getConfigurationEntry
|
getConfigurationEntry ( entry_string , force_decode_flag )
|
|
Syntax: getdate
|
getdate ()
|
|
Syntax: getdate
|
getdate ()
|
|
Syntax: GetLocale
|
GetLocale ()
|
|
Syntax: greatest
|
greatest ( expression_list )
|
|
Syntax: grep
|
grep ( pattern_string , array_expression )
|
|
Syntax: head
|
head ( set_expression [ , index_expression ] ) Example 1 head ( members ( [great_outdoors_company].[Products].[Products].[Product line] ) ) Result: Camping Equipment Example 2 head ( members ( [great_outdoors_company].[Products].[Products].[Product line] ) , 2 ) Result: Returns the top two members of the Product line set. Camping Equipment Mountaineering Equipment
|
|
Syntax: hex
|
hex ( expression )
|
|
Syntax: hex
|
hex ( integer_expression )
|
|
Syntax: hex
|
hex ( numeric_expression1 )
|
|
Syntax: hierarchize
|
hierarchize ( set_expression ) Example hierarchize ( set ( [Golf Equipment] , [Mountaineering Equipment] , [Camping Equipment] ) ) Result: Returns Camping Equipment, Golf Equipment, Mountaineering Equipment.
|
|
Syntax: hierarchy
|
hierarchy ( level|member|set_expression ) Example 1 hierarchy ( [Cooking Gear] ) Result: Returns every member in the hierarchy that contains Cooking Gear. Products Camping Equipment Cooking Gear TrailChef Water Bag TrailChef Canteen ... Mountain Man Extreme Mountain Man Deluxe Example 2 hierarchy ( [great_outdoors_company].[Products].[Products].[Product line] ) Result: Returns every member in the hierarchy that contains the Product line. Products Camping Equipment Cooking Gear TrailChef Water Bag TrailChef Canteen ... Mountain Man Extreme Mountain Man Deluxe
|
|
Syntax: HorizontalPageCount
|
HorizontalPageCount ()
|
|
Syntax: HorizontalPageNumber
|
HorizontalPageNumber ()
|
|
Syntax: hour
|
hour ( time_expression )
|
|
Syntax: hour
|
hour ( time_expression )
|
|
Syntax: if
|
if ( condition ) then ( expression ) else ( expression )
|
|
Syntax: if then else
|
IF ([Country] = 'Canada') THEN ([List Price] * 0.60) ELSE ([List Price])
|
|
Syntax: ifnull
|
ifnull ( expression, substitute )
|
|
Syntax: in
|
expression1 in ( expression_list )
|
|
Syntax: in_range
|
[code] in_range { 5 }
|
|
Syntax: in_range
|
[code] IN_RANGE { :30 , 40, 50, 999: }
|
|
Syntax: index
|
index ( string_expression1 , string_expression2 )
|
|
Syntax: initcap
|
initcap ( string_expression )
|
|
Syntax: initcap
|
initcap ( string_expression )
|
|
Syntax: initcap
|
initcap ( string_expression )
|
|
Syntax: initcap
|
initcap ( string_expression )
|
|
Syntax: initcap
|
initcap ( string_expression )
|
|
Syntax: initcap
|
initcap ( string_expression )
|
|
Syntax: InScope
|
InScope ( dataItem , MUN, ... )
|
|
Syntax: insert
|
insert ( string_expression1, integer_expression1, integer_expression2, string_ expression2 )
|
|
Syntax: instr
|
instr ( [ integer_expression1 , ] string_expression1 , string_expression2 [ , integer_expression2 ] )
|
|
Syntax: instr
|
instr ( string_expression1 , string_expression2 [ , integer_expression1 [ , integer_expression2 ] ] )
|
|
Syntax: instr
|
instr ( string_expression1, string_expression2 [ , integer_expression1 [ , integer_expression2 ] ] )
|
|
Syntax: instrb
|
instrb ( string_expression1, string_expression2 [ , integer_expression1 [ , integer_expression2 ] ] )
|
|
Syntax: int
|
int ( expression )
|
|
Syntax: int
|
int ( numeric_expression )
|
|
Syntax: int2DTinterval
|
int2DTinterval ( integer_expression , string_expression )
|
|
Syntax: int2YMinterval
|
int2YMinterval ( integer_expression , string_expression )
|
|
Syntax: integer
|
integer ( expression )
|
|
Syntax: integer
|
integer ( numeric_expression )
|
|
Syntax: intersect
|
intersect ( set_expression1 , set_expression2 [ , all ] ) Example intersect ( set ( [Camping Equipment] , [Mountaineering Equipment] ) , set ( [Camping Equipment] , [Outdoor Protection] , ) , all ) Result: Camping Equipment
|
|
Syntax: is missing
|
value is missing
|
|
Syntax: is not missing
|
value is not missing
|
|
Syntax: is not null
|
value is not null
|
|
Syntax: is null
|
value is null
|
|
Syntax: IsAccessible
|
IsAccessible()
|
|
Syntax: IsBursting
|
IsBursting ('recipientName')
|
|
Syntax: IsCrosstabColumnNodeMember
|
IsCrosstabColumnNodeMember ()
|
|
Syntax: IsCrosstabRowNodeMember
|
IsCrosstabRowNodeMember ()
|
|
Syntax: IsFirstColumn
|
IsFirstColumn ()
|
|
Syntax: IsInnerMostCrosstabColumnNodeMember
|
IsInnerMostCrosstabColumnNodeMember ()
|
|
Syntax: IsInnerMostCrosstabRowNodeMember
|
IsInnerMostCrosstabRowNodeMember ()
|
|
Syntax: IsLastColumn
|
IsLastColumn ()
|
|
Syntax: IsLastInnerMostCrosstabColumnNodeMember
|
IsLastInnerMostCrosstabColumnNodeMember ()
|
|
Syntax: IsLastInnerMostCrosstabRowNodeMember
|
IsLastInnerMostCrosstabRowNodeMember ()
|
|
Syntax: IsOuterMostCrosstabColumnNodeMember
|
IsOuterMostCrosstabColumnNodeMember ()
|
|
Syntax: IsOuterMostCrosstabRowNodeMember
|
IsOuterMostCrosstabRowNodeMember ()
|
|
Syntax: IsPageCountAvailable
|
IsPageCountAvailable ()
|
|
Syntax: item
|
item ( set_expression , index ) Example item ( children ( [Camping Equipment] ) , 2 ) Result: Sleeping Bags
|
|
Syntax: join
|
join ( separator_string , array_expression )
|
|
Syntax: julian_day
|
julian_day ( expression )
|
|
Syntax: lag
|
lag ( member , index_expression ) Example 1 lag ( [Tents] , 1 ) Result: Cooking Gear Example 2 lag ( [Tents] , -2 ) Result: Packs
|
|
Syntax: lastChild
|
lastChild ( member ) Example 1 lastChild ( Cooking Gear ) Result: TrailChef Utensils Example 2 lastChild ( [By Product Line] ) Result: Golf Equipment
|
|
Syntax: lastPeriods
|
lastPeriods ( integer_expression , member ) Example 1 lastPeriods ( 2 , [2006 Q 4] ) Result: Returns the last two members from the level that ends with 2006 Q 4. 2006 Q 3 2006 Q 4 Example 2 lastPeriods ( -3 , [2006 Q 4] ) Result: Returns the last three members from the level that starts with 2006 Q 4. 2006 Q 4 2007 Q 1 2007 Q 2
|
|
Syntax: lastSibling
|
lastSibling ( member ) Example lastSibling ( [Camping Equipment] ) Result: Golf Equipment
|
|
Syntax: lcase
|
lcase ( string_expression )
|
|
Syntax: lcase
|
lcase ( string_expression )
|
|
Syntax: le_dst
|
le_dst ( string_expression1 , string_expression2 )
|
|
Syntax: lead
|
lead ( member , index_expression ) Example 1 lead ( [Outdoor Protection] , 1 ) Result: Personal Accessories Example 2 lead ( [Outdoor Protection] , -2 ) Result: Golf Equipment
|
|
Syntax: least
|
least ( expression_list )
|
|
Syntax: left
|
left ( string_expression, integer_expression )
|
|
Syntax: left
|
left ( string_expression , integer_expression )
|
|
Syntax: left
|
left ( string_expression , integer_expression )
|
|
Syntax: left
|
left ( string_expression , integer_expression )
|
|
Syntax: length
|
length ( expression )
|
|
Syntax: length
|
length ( string_expression )
|
|
Syntax: length
|
length ( string_expression )
|
|
Syntax: length
|
length ( string_expression )
|
|
Syntax: length
|
length ( string_expression )
|
|
Syntax: lengthb
|
lengthb ( string_expression )
|
|
Syntax: lengthb
|
lengthb ( string_expression )
|
|
Syntax: level
|
level ( member ) Example level ( [Golf Equipment] ) Result: Returns the members on the Golf Equipment level. Camping Equipment Mountaineering Equipment Personal Accessories Outdoor Protection Golf Equipment
|
|
Syntax: levels
|
levels ( hierarchy , index ) Example 1 levels ( [great_outdoors_company].[Products].[Products] , 2 ) Result: Returns the members two levels from the root Products hierarchy. Cooking Gear Sleeping Bags Packs Tents ... Irons Putters Woods Golf Accessories Example 2 levels ( [great_outdoors_company].[Products].[Products] , 1 ) Result: Returns the members one level from the root Products hierarchy. Camping Equipment Mountaineering Equipment Personal Accessories Outdoor Protection Golf Equipment
|
|
Syntax: like
|
string1 LIKE string2
|
|
Syntax: linkMember
|
linkMember ( member , level|hierarchy )
|
|
Syntax: ln
|
ln ( numeric_expression )
|
|
Syntax: ln
|
ln ( numeric_expression )
|
|
Syntax: ln
|
ln ( numeric_expression )
|
|
Syntax: ln
|
ln ( numeric_expression )
|
|
Syntax: ln
|
ln ( numeric_expression )
|
|
Syntax: ln
|
ln ( numeric_expression )
|
|
Syntax: Locale
|
Locale ()
|
|
Syntax: localtime
|
localtime
|
|
Syntax: localtimestamp
|
localtimestamp
|
|
Syntax: locate
|
locate ( string_expression1, string_expression2 [ , integer_expression ] )
|
|
Syntax: locate
|
locate ( string_expression1 , string_expression2 [ , integer_expression ] )
|
|
Syntax: log
|
log ( numeric_expression1 , numeric_expression2 )
|
|
Syntax: log
|
log ( numeric_expression )
|
|
Syntax: log
|
log ( numeric_expression )
|
|
Syntax: log
|
log ( numeric_expression )
|
|
Syntax: log
|
log ( numeric_expression1 [ , numeric_expression2 ] )
|
|
Syntax: log
|
log ( numeric_expression1 [ , numeric_expression2 ] )
|
|
Syntax: log
|
log ( numeric_expression )
|
|
Syntax: log
|
log ( numeric_expression1 [ , numeric_expression2 ] )
|
|
Syntax: log
|
log ( numeric_expression1 , numeric_expression2 )
|
|
Syntax: log10
|
log10 ( numeric_expression )
|
|
Syntax: log10
|
log10 ( numeric_expression )
|
|
Syntax: log10
|
log10 ( numeric_expression )
|
|
Syntax: log10
|
log10 ( numeric_expression )
|
|
Syntax: logn
|
logn ( numeric_expression )
|
|
Syntax: long_varchar
|
long_varchar ( string_expression )
|
|
Syntax: lookup
|
lookup ( name ) in ( value1 --> value2 ) default ( expression )
|
|
Syntax: lower
|
lower ( string_expression )
|
|
Syntax: lower
|
lower ( string_expression )
|
|
Syntax: lpad
|
lpad ( string_expression1 , integer_expression , string_expression2 )
|
|
Syntax: lpad
|
lpad ( string_expression1 , integer_expression [ , string_expression2 ] )
|
|
Syntax: lpad
|
lpad ( string_expression1, integer_expression [ , string_expression2 ] )
|
|
Syntax: lpad
|
lpad ( string_expression1 , integer_expression [ , string_expression2 ] )
|
|
Syntax: lpad
|
lpad ( string_expression1 , integer_expression [ , string_expression2 ] )
|
|
Syntax: lpad
|
lpad ( string_expression1 , integer_expression [ , string_expression2 ] )
|
|
Syntax: lpad
|
lpad ( string_expression1 , integer_expression [ , string_expression2 ] )
|
|
Syntax: ltrim
|
ltrim ( string_expression )
|
|
Syntax: ltrim
|
ltrim ( string_expression )
|
|
Syntax: ltrim
|
ltrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: ltrim
|
ltrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: ltrim
|
ltrim ( string_expression )
|
|
Syntax: ltrim
|
ltrim ( string_expression )
|
|
Syntax: ltrim
|
ltrim ( string_expression )
|
|
Syntax: ltrim
|
ltrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: ltrim
|
ltrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: ltrim
|
ltrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: ltrim
|
ltrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: ltrim
|
ltrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: mapNumberToLetter
|
mapNumberToLetter ( string_expression , integer_expression )
|
|
Syntax: maximum
|
maximum ( < currentMeasure|numeric_expression > within set set_expression ) maximum ( < currentMeasure|numeric_expression > within < detail|aggregate > expression )
|
|
Syntax: maximum
|
maximum ( [ distinct ] expression [ auto ] ) maximum ( [ distinct ] expression for [ all|any ] expression { , expression } ) maximum ( [ distinct ] expression for report )
|
|
Syntax: md5
|
md5 ( string_expression1 )
|
|
Syntax: md5
|
md5 ( string_expression1 )
|
|
Syntax: mdy
|
mdy ( integer_expression1 , integer_expression2 , integer_expression3 )
|
|
Syntax: median
|
median ( < currentMeasure|numeric_expression > within set set_expression ) median ( < currentMeasure|numeric_expression > within < detail|aggregate > expression )
|
|
Syntax: median
|
median ( expression [ auto ] ) median ( expression for [ all|any ] expression { , expression } ) median ( expression for report )
|
|
Syntax: member
|
member ( value_expression [ , string1 [ , string2 [ , hierarchy ] ] ] ) Example member ( total ( currentMeasure within set filter ( [great_outdoors_company]. [Products].[Products].[Product name] , caption ( [great_outdoors_company]. [Products].[Products].[Product name] ) starts with 'B' ) ) , 'BProducts' , 'B Products' , [great_outdoors_company].[Products].[Products] ) Result: Returns the quantity sold and revenue for all products that start with the letter B.
|
|
Syntax: members
|
members ( hierarchy|level ) Example 1
|
|
Syntax: microsecond
|
microsecond ( expression )
|
|
Syntax: midnight_seconds
|
midnight_seconds ( expression )
|
|
Syntax: minimum
|
minimum ( < currentMeasure|numeric_expression > within set set_expression ) minimum ( < currentMeasure|numeric_expression > within < detail|aggregate > expression )
|
|
Syntax: minimum
|
minimum ( [ distinct ] expression [ auto ] ) minimum ( [ distinct ] expression for [ all|any ] expression { , expression } ) minimum ( [ distinct ] expression for report )
|
|
Syntax: minute
|
minute ( time_expression )
|
|
Syntax: minute
|
minute ( time_expression )
|
|
Syntax: mod
|
mod ( integer_expression1, integer_expression2 )
|
|
Syntax: mod
|
mod ( integer_expression1 , integer_expression2 )
|
|
Syntax: ModelPath
|
ModelPath ()
|
|
Syntax: month
|
month ( date_expression )
|
|
Syntax: month
|
month ( date_expression )
|
|
Syntax: month
|
month ( date_expression )
|
|
Syntax: month
|
month ( date_expression )
|
|
Syntax: month
|
month ( date_expression )
|
|
Syntax: monthname
|
monthname ( date_expression )
|
|
Syntax: monthname
|
monthname ( date_expression )
|
|
Syntax: months_between
|
months_between ( date_expression1 , date_expression2 )
|
|
Syntax: months_between
|
months_between ( date_expression1 , date_expression2 )
|
|
Syntax: moving-average
|
moving-average ( numeric_expression , numeric_expression [ at expression { , expression } ] [ <for-option> ] [ prefilter ] ) moving-average ( numeric_expression , numeric_expression [ <for-option> ] [ prefilter ] ) <for-option> ::= for expression { , expression }|for report|auto
|
|
Syntax: moving-total
|
moving-total ( numeric_expression , numeric_expression [ at expression { , expression } ] [ <for-option> ] [ prefilter ] )
|
|
Syntax: MS Access Cast
|
cast_decimal ( expression ) cast_float Returns the value of "expression" cast as a float. Syntax cast_float ( expression ) cast_integer Returns the value of "expression" cast as an integer. Syntax cast_integer ( expression )
|
|
Syntax: MS Access Math
|
log ( numeric_expression ) rand Generates a random number using "integer_expression" as a seed value. Syntax rand ( integer_expression )
|
|
Syntax: MS Access Trigonometry
|
atan ( numeric_expression )
|
|
Syntax: nestedSet
|
nestedSet ( set_expression1 , set_expression2 ) Example nestedSet ( members ( [Product line] ) , topCount ( descendants ( currentMember ( [great_outdoors_company].[Products].[Products] ) , [great_outdoors_company]. [Products].[Products].[Product name] ) , 2 , [Revenue] ) ) Result: Returns the top two products by revenue for each product line.
|
|
Syntax: new_time
|
new_time ( datetime_expression , old_timezone , new_timezone )
|
|
Syntax: next_day
|
next_day ( datetime_expression , string_expression )
|
|
Syntax: next_day
|
next_day ( datetime_expression , string_expression )
|
|
Syntax: nextMember
|
nextMember ( member )
|
|
Syntax: nls_initcap
|
nls_initcap ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: nls_lower
|
nls_lower ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: nls_upper
|
nls_upper ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: not
|
NOT argument
|
|
Syntax: now
|
now ()
|
|
Syntax: Now
|
Now ()
|
|
Syntax: nullif
|
nullif ( expression1, expression2 )
|
|
Syntax: nullif
|
nullif ( expression1 , expression2 )
|
|
Syntax: nullif
|
nullif ( scalar_expression1 , scalar_expression2 )
|
|
Syntax: nullif
|
nullif ( string_expression1 , string_expression2 )
|
|
Syntax: nullifzero
|
nullifzero ( numeric_expression )
|
|
Syntax: number2string
|
number2string ( numeric_expression )
|
|
Syntax: nvl
|
nvl ( expression1 , expression2 )
|
|
Syntax: nvl
|
nvl ( expression , constant )
|
|
Syntax: nvl
|
nvl ( expression , constant )
|
|
Syntax: nysiis
|
nysiis ( string_expression )
|
|
Syntax: octet_length
|
octet_length ( string_expression )
|
|
Syntax: octet_length
|
octet_length ( string_expression )
|
|
Syntax: octet_length
|
octet_length ( string_expression )
|
|
Syntax: openingPeriod
|
openingPeriod ( level [ , member ] )
|
|
Syntax: or
|
argument1 or argument2
|
|
Syntax: order
|
order ( set_expression , value_expression [ , ASC|DESC|BASC|BDESC ] ) Example 1 order ( members ( [Great Outdoors Company].[Product].[Product].[Product type] ) , [Quantity sold] , BASC ) Result: Returns the quantity sold for each product type in no particular order. Product Line Quantity ------------- ------------- Woods 13,924 Irons 14,244 Safety 22,332 ... ... Sunscreen 215,432 Insect Repellents 270,074 Lanterns 345,096 Example 2 order ( members ( [Great Outdoors Company].[Product].[Product].[Product type] ) , [Quantity sold] , ASC ) Result: Returns the quantity sold for each product type in ascending order. Product Line Quantity ------------- ------------- Woods 13,924 Irons 14,244 Putters 23,244 ... ... Tents 130,664 Cooking Gear 198,676 Lanterns 345,096
|
|
Syntax: ordinal
|
ordinal ( level ) Example 1 ordinal ( [great_outdoors_company].[Products].[Products].[Product line] ) Result: 1 Example 2 ordinal ( [great_outdoors_company].[Products].[Products].[Product type] ) Result: 2
|
|
Syntax: overlay
|
overlay ( string_expression1 , string_expression2 , numeric_expression1 [ , numeric_expression2 ] )
|
|
Syntax: overlay
|
overlay ( string_expression1 , string_expression2 , numeric_expression1 [ , numeric_expression2 ] )
|
|
Syntax: overlay
|
overlay ( string_expression1 , string_expression2 , numeric_expression1 [ , numeric_expression2 ] )
|
|
Syntax: overlay
|
overlay ( string_expression1 , string_expression2 , numeric_expression1 [ , numeric_expression2 ] )
|
|
Syntax: PageCount
|
PageCount ()
|
|
Syntax: PageName
|
PageName ()
|
|
Syntax: PageNumber
|
PageNumber ()
|
|
Syntax: parallelPeriod
|
parallelPeriod ( level [ , integer_expression [ , member ] ] ) Example 1 parallelPeriod ( [great_outdoors_company].[Years].[Years].[Quarter] , -1 , [2006/Aug] ) Result: 2006/Nov Example 2 parallelPeriod ( [great_outdoors_company].[Years].[Years].[Quarter] , 1 , [2006/ Aug] ) Result: 2006/May Example 3 parallelPeriod ( [great_outdoors_company].[Years].[Years].[Year] , 2 , [2006/ Aug] ) Result: 2004/Aug
|
|
Syntax: ParamCount
|
ParamCount ('parameterName')
|
|
Syntax: ParamDisplayValue
|
ParamDisplayValue ('parameterName')
|
|
Syntax: ParamName
|
ParamName ('parameterName')
|
|
Syntax: ParamNames
|
ParamNames ()
|
|
Syntax: ParamValue
|
ParamValue ('parameterName')
|
|
Syntax: parent
|
parent ( member|measure ) Example parent ( [Cooking Gear] ) Result: Camping Equipment
|
|
Syntax: patindex
|
patindex ( string_expression1 , string_expression2 )
|
|
Syntax: patindex
|
patindex ( string_expression1 , string_expression2 [ using {bytes|chars| characters} ] )
|
|
Syntax: percentage
|
percentage ( numeric_expression [ tuple member_expression { , member_ expression } ] within set set_expression )
|
|
Syntax: percentage
|
percentage ( numeric_expression [ at expression { , expression } ] [ <for-option> ] [ prefilter ] ) percentage ( numeric_expression [ <for-option> ] [ prefilter ] ) <for-option> ::= for expression { , expression }|for report|auto
|
|
Syntax: percentile
|
percentile ( numeric_expression [ tuple member_expression { , member_ expression } ] within set set_expression )
|
|
Syntax: percentile
|
percentile ( numeric_expression [ at expression { , expression } ] [ <for-option> ] [ prefilter ] ) percentile ( numeric_expression [ <for-option> ] [ prefilter ] ) <for-option> ::= for expression { , expression }|for report|auto
|
|
Syntax: periodsToDate
|
periodsToDate ( level , member ) Example periodsToDate ( [great_outdoors_company].[Years].[Years].[Year] , [2004/Mar] ) Result: Returns values for [2004/Jan], [2004/Feb], [2004/Mar]
|
|
Syntax: pi
|
pi ()
|
|
Syntax: pi
|
pi ()
|
|
Syntax: pi
|
pi ()
|
|
Syntax: pi
|
pi ()
|
|
Syntax: pi
|
pi ()
|
|
Syntax: pi
|
pi ()
|
|
Syntax: pi
|
pi ()
|
|
Syntax: position
|
position ( string_expression1 , string_expression2 )
|
|
Syntax: position
|
position ( string_expression1 , string_expression2 )
|
|
Syntax: position
|
position ( string_expression1 , string_expression2 )
|
|
Syntax: positionb
|
positionb ( string_expression1, string_expression2 )
|
|
Syntax: power
|
power ( numeric_expression1 , numeric_expression2 )
|
|
Syntax: power
|
power ( numeric_expression1 , numeric_expression2 )
|
|
Syntax: prefilter
|
summary ([expression] prefilter)
|
|
Syntax: prevMember
|
prevMember ( member ) Example 1 prevMember ( [Outdoor Protection] ) Result: Personal Accessories Example 2 prevMember ( [2005] ) Result: 2004
|
|
Syntax: pri_mp
|
pri_mp ( numeric_expression )
|
|
Syntax: profile
|
{profile}
|
|
Syntax: prompt
|
prompt ( prompt_name , datatype , defaultText , text , queryItem , trailing_ text )
|
|
Syntax: promptmany
|
promptmany ( prompt_name , datatype , defaultText , text , queryItem , trailing_ text )
|
|
Syntax: quantile
|
"quantile ( numeric_expression , numeric_expression [ at expression
{ , expression } ] [ <for-option> ] [ prefilter ] ) quantile ( numeric_expression , numeric_expression [ <for-option> ] [ prefilter ] ) <for-option> ::= for expression { , expression }|for report|auto" |
|
Syntax: quantile
|
quantile ( numeric_expression , numeric_expression [ tuple member_expression { , member_expression } ] within set set_expression )
|
|
Syntax: quarter
|
quarter ( date_expression )
|
|
Syntax: quartile
|
quartile ( numeric_expression [ at expression { , expression } ] [ <for-option> ] [ prefilter ] ) quartile ( numeric_expression [ <for-option> ] [ prefilter ] ) <for-option> ::= for expression { , expression }|for report|auto
|
|
Syntax: quartile
|
quartile ( numeric_expression [ tuple member_expression { , member_expression } ] within set set_expression )
|
|
Syntax: radians
|
radians ( numeric_expression )
|
|
Syntax: radians
|
radians ( numeric_expression )
|
|
Syntax: radians
|
radians ( numeric_expression )
|
|
Syntax: radians
|
radians ( numeric_expression )
|
|
Syntax: radians
|
radians ( numeric_expression )
|
|
Syntax: radians
|
radians ( numeric_expression )
|
|
Syntax: radians
|
radians ( numeric_expression )
|
|
Syntax: radians
|
radians ( numeric_expression )
|
|
Syntax: rand
|
rand ( integer_expression )
|
|
Syntax: rand
|
rand ( integer_expression )
|
|
Syntax: random
|
random ( lower_bound , upper_bound )
|
|
Syntax: rank
|
rank ( expression [ ASC|DESC ] { , expression [ ASC|DESC ] } [ at expression { , expression } ] [ <for-option> ] [ prefilter ] ) rank ( [ distinct ] expression [ ASC|DESC ] { , expression [ ASC|DESC ] } [ <for-option>] [ prefilter ] ) <for-option> ::= for expression { , expression }|for report|auto
|
|
Syntax: rank
|
rank ( numeric_expression [ ASC|DESC ] [ tuple member_expression { , member_ expression } ] within set set_expression )
|
|
Syntax: real
|
real ( numeric_expression )
|
|
Syntax: repeat
|
repeat ( string_expression, integer_expression )
|
|
Syntax: repeat
|
repeat ( string_expression , numeric_expression1 )
|
|
Syntax: repeat
|
repeat ( string_expression , numeric_expression1 )
|
|
Syntax: repeat
|
repeat ( string_expression , numeric_expression1 )
|
|
Syntax: repeat
|
repeat ( string_expression , numeric_expression1 )
|
|
Syntax: replace
|
replace ( string_expression1, string_expression2, string_expression3 )
|
|
Syntax: replace
|
replace ( string_expression1 , string_expression2 [ , string_expression3 ] )
|
|
Syntax: replace
|
replace ( string_expression1 , string_expression2 [ , string_expression3 ] )
|
|
Syntax: replace
|
replace ( string_expression1 , string_expression2 , string_expression3 )
|
|
Syntax: replace
|
replace ( string_expression , string_expression2 , string_expression3)
|
|
Syntax: replace
|
replace ( string_expression , string_expression2 , string_expression3 )
|
|
Syntax: replace
|
replace ( string_expression , string_expression2 , string_expression3 )
|
|
Syntax: replace
|
replace ( string_expression , string_expression2 , string_expression3 )
|
|
Syntax: replace
|
replace ( string_expression , string_expression2 , string_expression3)
|
|
Syntax: replicate
|
replicate ( string_expression , integer_expression )
|
|
Syntax: replicate
|
replicate ( string_expression , integer_expression )
|
|
Syntax: ReportAuthorLocale
|
ReportAuthorLocale ()
|
|
Syntax: ReportCreateDate
|
ReportCreateDate ()
|
|
Syntax: ReportDate
|
ReportDate ()
|
|
Syntax: ReportDescription
|
ReportDescription ()
|
|
Syntax: ReportID
|
ReportID ()
|
|
Syntax: ReportLocale
|
ReportLocale ()
|
|
Syntax: ReportName
|
ReportName ()
|
|
Syntax: ReportOption
|
ReportOption ('optionName')
|
|
Syntax: ReportOutput
|
ReportOutput ()
|
|
Syntax: ReportPath
|
ReportPath ()
|
|
Syntax: ReportProductLocale
|
ReportProductLocale ()
|
|
Syntax: ReportSaveDate
|
ReportSaveDate ()
|
|
Syntax: reverse
|
reverse ( string_expression )
|
|
Syntax: reverse
|
reverse ( string_expression )
|
|
Syntax: reverse
|
reverse ( string_expression )
|
|
Syntax: right
|
right ( string_expression, integer_expression )
|
|
Syntax: right
|
right ( string_expression , integer_expression )
|
|
Syntax: right
|
right ( string_expression , integer_expression )
|
|
Syntax: right
|
right ( string_expression , integer_expression )
|
|
Syntax: right
|
right ( string_expression1 , numeric_expression )
|
|
Syntax: role
|
{role}
|
|
Syntax: roleValue
|
roleValue ( string [ , member|set_expression ] ) Example 1 roleValue ( '_memberCaption' , [Sales].[Product].[Product].[Product line] -> [all].[1] ) Result: Camping Equipment Example 2 roleValue ( '_businessKey' , [great_outdoors_company].[Years].[Years].[Year] ) Result: Returns the value of the attribute that is associated with the business key role. ("2004-01-01","2004-12-31") ("2005-01-01","2005-12-31") ("2006-01-01","2006-12-31") Example 3 roleValue ( '_memberUniqueName' , [great_outdoors_company].[Years].[Years]. [Year] ) Result: Returns the value of the attribute that is associated with the MUN role. [great_outdoors_company].[Years].[Years].[Year] ->:[PC].[Years (Root)].[20040101- 20041231] [great_outdoors_company].[Years].[Years].[Year] ->:[PC].[Years (Root)].[20050101- 20051231] [great_outdoors_company].[Years].[Years].[Year] ->:[PC].[Years (Root)].[20060101- 20061231]
|
|
Syntax: root
|
root ( numeric_expression1 [ , numeric_expression2 ] )
|
|
Syntax: rootMember
|
rootMember ( hierarchy )
|
|
Syntax: rootMembers
|
rootMembers ( hierarchy ) Example rootMembers ( [great_outdoors_company].[Years].[Years] ) Result: By Time
|
|
Syntax: round
|
round ( numeric_expression, integer_expression )
|
|
Syntax: round
|
round ( numeric_expression [ , integer_expression ] )
|
|
Syntax: round
|
round ( numeric_expression , integer_expression )
|
|
Syntax: round
|
round ( numeric_expression [ , integer_expression ] )
|
|
Syntax: round
|
round ( numeric_expression [ , integer_expression ] )
|
|
Syntax: round
|
round ( numeric_expression , integer_expression )
|
|
Syntax: round
|
round ( numeric_expression , integer_expression )
|
|
Syntax: round
|
round ( numeric_expression, integer_expression )
|
|
Syntax: round
|
round ( numeric_expression , integer_expression )
|
|
Syntax: RowNumber
|
RowNumber ()
|
|
Syntax: rows
|
count ( ROWS )
|
|
Syntax: rpad
|
rpad ( string_expression1 , integer_expression , string_expression2 )
|
|
Syntax: rpad
|
rpad ( string_expression1 , integer_expression [ , string_expression2 ] )
|
|
Syntax: rpad
|
rpad ( string_expression1 , integer_expression [ , string_expression2 ] )
|
|
Syntax: rpad
|
rpad ( string_expression1 , integer_expression [ , string_expression2 ] )
|
|
Syntax: rpad
|
rpad ( string_expression1 , integer_expression [ , string_expression2 ] )
|
|
Syntax: rpad
|
rpad ( string_expression1 , integer_expression [ , string_expression2 ] )
|
|
Syntax: rpad
|
rpad ( string_expression1 , integer_expression [ , string_expression2 ] )
|
|
Syntax: rtrim
|
rtrim ( string_expression )
|
|
Syntax: rtrim
|
rtrim ( string_expression )
|
|
Syntax: rtrim
|
rtrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: rtrim
|
rtrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: rtrim
|
rtrim ( string_expression )
|
|
Syntax: rtrim
|
rtrim ( string_expression )
|
|
Syntax: rtrim
|
rtrim ( string_expression )
|
|
Syntax: rtrim
|
rtrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: rtrim
|
rtrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: rtrim
|
rtrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: rtrim
|
rtrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: rtrim
|
rtrim ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: running-average
|
running-average ( numeric_expression [ at expression { , expression } ] [ <for-option> ] [ prefilter ] ) running-average ( numeric_expression [ <for-option> ] [ prefilter ] ) <for-option> ::= for expression { , expression }|for report|auto
|
|
Syntax: running-count
|
running-count ( numeric_expression [ at expression { , expression } ] [ <for-option> ] [ prefilter ] ) running-count ( numeric_expression [ <for-option> ] [ prefilter ] ) <for-option> ::= for expression { , expression }|for report|auto
|
|
Syntax: running-difference
|
running-difference ( numeric_expression [ at expression { , expression } ] [ <for-option> ] [ prefilter ] ) running-difference ( numeric_expression [ <for-option> ] [ prefilter ] ) <for-option> ::= for expression { , expression }|for report|auto
|
|
Syntax: running-maximum
|
running-maximum ( numeric_expression [ at expression { , expression } ] [ <for-option> ] [ prefilter ] ) running-maximum ( numeric_expression [ <for-option> ] [ prefilter ] ) <for-option> ::= for expression { , expression }|for report|auto
|
|
Syntax: running-minimum
|
running-minimum ( numeric_expression [ at expression { , expression } ] [ <for-option> ] [ prefilter ] ) running-minimum ( numeric_expression [ <for-option> ] [ prefilter ] ) <for-option> ::= for expression { , expression }|for report|auto
|
|
Syntax: running-total
|
running-total ( numeric_expression [ at expression { , expression } ] [ <for-option> ] [ prefilter ] ) running-total ( numeric_expression [ <for-option> ] [ prefilter ] ) <for-option> ::= for expression { , expression }|for report|auto
|
|
Syntax: sb
|
sb ( string_expression )
|
|
Syntax: schema
|
schema ()
|
|
Syntax: score_mp
|
score_mp ( numeric_expression , numeric_expression2 , numeric_expression3 , numeric_expression4 , numeric_expression5 , numeric_expression6 )
|
|
Syntax: search case
|
CASE WHEN [Country] = 'Canada' THEN ([List Price] * 0.60) WHEN [CountryCode] > 100 THEN [List Price] * 0.80 ELSE [List Price] END
|
|
Syntax: sec_mp
|
sec_mp ( numeric_expression )
|
|
Syntax: second
|
second ( time_expression )
|
|
Syntax: ServerLocale
|
ServerLocale ()
|
|
Syntax: ServerName
|
ServerName ()
|
|
Syntax: session
|
{session}
|
|
Syntax: session_user
|
session_user ()
|
|
Syntax: set
|
set ( member { , member } ) Example set ( [Golf Equipment] , [Irons] , [TrailChef Cup] ) Result: Returns Golf Equipment, Irons, and TrailChef Cup.
|
|
Syntax: siblings
|
siblings ( member ) Example siblings ( [Golf Equipment] ) Result: Returns the siblings of Golf Equipment. Camping Equipment Golf Equipment Mountaineering Equipment Outdoor Protection Personal Accessories
|
|
Syntax: sign
|
sign ( numeric_expression )
|
|
Syntax: sign
|
sign ( numeric_expression )
|
|
Syntax: sign
|
sign ( numeric_expression )
|
|
Syntax: sign
|
sign ( numeric_expression )
|
|
Syntax: sign
|
sign ( numeric_expression )
|
|
Syntax: sign
|
sign ( numeric_expression )
|
|
Syntax: simple case
|
CASE [Country] WHEN 'Canada' THEN ([List Price] * 0.60) WHEN 'Australia' THEN [List Price] * 0.80 ELSE [List Price] END
|
|
Syntax: sin
|
sin ( numeric_expression )
|
|
Syntax: sin
|
sin ( numeric_expression )
|
|
Syntax: sin
|
sin ( numeric_expression )
|
|
Syntax: sin
|
sin ( numeric_expression )
|
|
Syntax: sin
|
sin ( numeric_expression )
|
|
Syntax: sin
|
sin ( numeric_expression )
|
|
Syntax: sin
|
sin ( numeric_expression )
|
|
Syntax: sin
|
sin ( numeric_expression )
|
|
Syntax: sin
|
sin ( numeric_expression )
|
|
Syntax: sin
|
sin ( numeric_expression )
|
|
Syntax: sin
|
sin ( numeric_expression )
|
|
Syntax: sinh
|
sinh ( numeric_expression )
|
|
Syntax: sinh
|
sinh ( numeric_expression )
|
|
Syntax: sinhyp
|
sinhyp ( numeric_expression )
|
|
Syntax: smallint
|
smallint ( expression )
|
|
Syntax: sort
|
sort ( array_expression )
|
|
Syntax: soundex
|
soundex ( string_expression )
|
|
Syntax: soundex
|
soundex ( string_expression )
|
|
Syntax: soundex
|
soundex ( string_expression )
|
|
Syntax: soundex
|
soundex ( string_expression )
|
|
Syntax: soundex
|
soundex ( string_expression )
|
|
Syntax: soundex
|
soundex ( string_expression1 )
|
|
Syntax: space
|
space ( integer_expression )
|
|
Syntax: space
|
space ( integer_expression )
|
|
Syntax: space
|
space ( integer_expression )
|
|
Syntax: space
|
space ( integer_expression )
|
|
Syntax: split
|
split ( pattern_string, string_expression|array_expression )
|
|
Syntax: split_part
|
split_part ( string_expression1 , string_expression2 , numeric_expression )
|
|
Syntax: split_part
|
split_part ( string_expression1 , string_expression2 , numeric_expression )
|
|
Syntax: sq
|
sq ( string_expression )
|
|
Syntax: sqrt
|
sqrt ( numeric_expression )
|
|
Syntax: sqrt
|
sqrt ( numeric_expression )
|
|
Syntax: standard-deviation
|
standard-deviation ( expression [ auto ] ) standard-deviation ( expression for [ all|any ] expression { , expression } ) standard-deviation ( expression for report )
|
|
Syntax: standard-deviation
|
standard-deviation ( < currentMeasure|numeric_expression > within set set_expression ) standard-deviation ( < currentMeasure|numeric_expression > within < detail|aggregate > expression )
|
|
Syntax: standard-deviation-pop
|
standard-deviation-pop ( expression [ auto ] ) standard-deviation-pop ( expression for [ all|any ] expression { , expression } ) standard-deviation-pop ( expression for report )
|
|
Syntax: standard-deviation-pop
|
standard-deviation-pop ( < currentMeasure|numeric_expression > within set set_expression ) standard-deviation-pop ( < currentMeasure|numeric_expression > within < detail|aggregate > expression )
|
|
Syntax: starts with
|
string1 starts with string2
|
|
Syntax: str
|
str ( numeric_expression [ , integer_expression1 [ , integer_expression2 ] ] )
|
|
Syntax: str
|
str ( numeric_expression [ , integer_expression1 [ , integer_expression2 ] ] )
|
|
Syntax: string
|
string ( expression [ , length [ , scale ] ] )
|
|
Syntax: string2date
|
string2date ( string_expression )
|
|
Syntax: string2double
|
string2double ( string_expression )
|
|
Syntax: string2DTinterval
|
string2DTinterval ( string_expression )
|
|
Syntax: string2int32
|
string2int32 ( string_expression )
|
|
Syntax: string2int64
|
string2int64 ( string_expression )
|
|
Syntax: string2time
|
string2time ( string_expression )
|
|
Syntax: string2timestamp
|
string2timestamp ( string_expression )
|
|
Syntax: string2timestampTZ
|
string2timestampTZ ( string_expression )
|
|
Syntax: string2YMinterval
|
string2YMinterval ( string_expression )
|
|
Syntax: stuff
|
stuff ( string_expression1 , integer_expression1 , integer_expression2 , string_ expression2 )
|
|
Syntax: stuff
|
stuff ( string_expression1 , integer_expression1 , integer_expression2 , string_ expression2 )
|
|
Syntax: subset
|
subset ( set_expression, index_expression1 [ , index_expression2 ] ) Example 1 subset ( members ( [great_outdoors_company].[Products].[Products].[Product line] ) , 2 ) Result: Returns the members of the Product line set starting at the second member. Mountaineering Equipment Outdoor Protection Personal Accessories Example 2 subset ( members ( [great_outdoors_company].[Products].[Products].[Product line] ) , 2 , 2 ) Result: Returns two members of the Product line set starting at the second member. Mountaineering Equipment Outdoor Protection
|
|
Syntax: substitute
|
substitute ( pattern_string, replacement_string, string_expression|array_ expression )
|
|
Syntax: substr
|
substr ( string_expression , integer_expression1 [ , integer_expression2 ] )
|
|
Syntax: substr
|
substr ( string_expression , integer_expression1 [ , integer_expression2 ] )
|
|
Syntax: substr
|
substr ( string_expression , integer_expression1 , integer_expression2 )
|
|
Syntax: substr
|
substr ( string_expression , integer_expression1 [ , integer_expression2 ] )
|
|
Syntax: substr
|
substr ( string_expression , integer_expression1 [ , integer_expression2 ] )
|
|
Syntax: substr
|
substr ( string_expression , start_integer , length_integer )
|
|
Syntax: substr
|
substr ( string_expression , integer_expression1 [ , integer_expression2 ] )
|
|
Syntax: substrb
|
substrb ( string_expression , numeric_expression1 [ , numeric_expression2 ] )
|
|
Syntax: substrb
|
substrb ( string_expression , start_integer , length_integer )
|
|
Syntax: substring
|
substring ( string_expression , integer_expression1 [ , integer_expression2 ] )
|
|
Syntax: substring
|
substring ( string_expression , integer_expression1 , integer_expression2 )
|
|
Syntax: substring
|
substring ( string_expression , integer_expression1 , integer_expression2 )
|
|
Syntax: substring
|
substring ( string_expression , integer_expression1 , integer_expression2 )
|
|
Syntax: system_user
|
system_user ()
|
|
Syntax: table_name
|
table_name ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: table_schema
|
table_schema ( string_expression1 [ , string_expression2 ] )
|
|
Syntax: tail
|
tail ( set_expression [ , index_expression ] ) Example 1 tail (members ( [great_outdoors_company].[Products].[Products].[Product line] ) ) Result: Returns the last member of the Product line set. Personal Accessories Example 2 tail ( members ( [great_outdoors_company].[Products].[Products].[Product line] ) , 2 ) Result: Returns the last two members of the Product line set. Outdoor Protection Personal Accessories
|
|
Syntax: tan
|
tan ( numeric_expression )
|
|
Syntax: tan
|
tan ( numeric_expression )
|
|
Syntax: tan
|
tan ( numeric_expression )
|
|
Syntax: tan
|
tan ( numeric_expression )
|
|
Syntax: tan
|
tan ( numeric_expression )
|
|
Syntax: tan
|
tan ( numeric_expression )
|
|
Syntax: tan
|
tan ( numeric_expression )
|
|
Syntax: tan
|
tan ( numeric_expression )
|
|
Syntax: tan
|
tan ( numeric_expression )
|
|
Syntax: tan
|
tan ( numeric_expression )
|
|
Syntax: tan
|
tan ( numeric_expression )
|
|
Syntax: tanh
|
tanh ( numeric_expression )
|
|
Syntax: tanh
|
tanh ( numeric_expression )
|
|
Syntax: tanhyp
|
tanhyp ( numeric_expression )
|
|
Syntax: then
|
if ( condition ) then ..., or case expression when expression then .... end
|
|
Syntax: time
|
time ( expression )
|
|
Syntax: time
|
time ( expression )
|
|
Syntax: time
|
{time}
|
|
Syntax: time2string
|
time2string ( time_expression )
|
|
Syntax: timestamp
|
timestamp ( expression1 [ , expression2 ] )
|
|
Syntax: timestamp
|
timestamp ( timestamp_expression )
|
|
Syntax: timestamp
|
timestamp ( date_expression , time_expression )
|
|
Syntax: timestamp_iso
|
timestamp_iso ( expression )
|
|
Syntax: timestamp2date
|
timestamp2date ( timestamp_expression )
|
|
Syntax: timestamp2string
|
timestamp2string ( timestamp_expression )
|
|
Syntax: timestamp2timestampTZ
|
timestamp2timestampTZ ( timestamp_expression )
|
|
Syntax: timestampdiff
|
timestampdiff ( expression1, expression2 )
|
|
Syntax: timestampMask
|
timestampMask ( string_expression1 , string_expression2 )
|
|
Syntax: timestampTZ2date
|
timestampTZ2date ( timestamp_time_zone_expression )
|
|
Syntax: timestampTZ2string
|
timestampTZ2string ( timestamp_time_zone_expression )
|
|
Syntax: timestampTZ2timestamp
|
timestampTZ2timestamp ( timestamp_time_zone_expression )
|
|
Syntax: timeTZ2string
|
timeTZ2string ( timeTZ_expression )
|
|
Syntax: to_char
|
to_char ( timestamp_expression , string_expression )
|
|
Syntax: to_char
|
to_char ( date_expression , string_expression )
|
|
Syntax: to_char
|
to_char ( expression [ , string_expression ] )
|
|
Syntax: to_char
|
to_char ( expression [ , string_expression ] )
|
|
Syntax: to_char
|
to_char ( source_date, format_string )
|
|
Syntax: to_char
|
to_char ( expression , string_expression )
|
|
Syntax: to_char
|
to_char ( expression , string_expression )
|
|
Syntax: to_char
|
to_char ( expression , string_expression )
|
|
Syntax: to_char
|
to_char ( expression , string_expression )
|
|
Syntax: to_date
|
to_date ( string_expression1 , string_expression2 )
|
|
Syntax: to_date
|
to_date ( string_expression1 , string_expression2 )
|
|
Syntax: to_date
|
to_date ( string_expression1 [ , string_expression2 [ , string_expression3 ] ] )
|
|
Syntax: to_date
|
to_date ( string_expression1 , string_expression2 )
|
|
Syntax: to_date
|
to_date ( string_expression1 , string_expression2 )
|
|
Syntax: to_date
|
to_date ( string_expression1 , string_expression2 )
|
|
Syntax: to_date
|
to_date ( string_expression1 , string_expression2 )
|
|
Syntax: to_hex
|
to_hex ( numeric_expression1 )
|
|
Syntax: to_hex
|
to_hex ( numeric_expression1 )
|
|
Syntax: to_hex
|
to_hex ( numeric_expression1 )
|
|
Syntax: to_number
|
to_number ( string_expression1 , string_expression2 )
|
|
Syntax: to_number
|
to_number ( string_expression1 , string_expression2 , string_expression3 )
|
|
Syntax: to_number
|
to_number ( string_expression1 , string_expression2 )
|
|
Syntax: to_number
|
to_number ( string_expression1, string_expression2 )
|
|
Syntax: to_number
|
to_number ( string_expression1 , string_expression2 )
|
|
Syntax: to_number
|
to_number ( string_expression1 , string_expression2 )
|
|
Syntax: to_timestamp
|
to_timestamp ( string_expression1 , string_expression2 )
|
|
Syntax: to_timestamp
|
to_timestamp ( string_expression1, string_expression2 )
|
|
Syntax: to_timestamp
|
to_timestamp ( string_expression1 , string_expression2 )
|
|
Syntax: to_unichar
|
to_unichar ( integer_expression )
|
|
Syntax: TOCHeadingCount
|
TOCHeadingCount ( headingLevel )
|
|
Syntax: Today
|
Today ()
|
|
Syntax: toLocal
|
toLocal ( string_expression )
|
|
Syntax: topCount
|
topCount ( set_expression , index_expression , numeric_expression ) Example topCount ( [great_outdoors_company].[Products].[Products].[Product line] , 2 , [Revenue] ) Result: Returns the top two revenues for the Product line set. Product line Revenue ------- ------- Camping Equipment $89,713,990.92 Personal Accessories $31,894,465.86
|
|
Syntax: topPercent
|
topPercent ( set_expression , numeric_expression1 , numeric_expression2 ) Example topPercent ( set ( [Camping Equipment] , [Golf Equipment] , [Mountaineering Equipment] ) , 40 , [2006] ) Result: For the set of Camping Equipment, Golf Equipment, and Mountaineering Equipment, returns the members whose percentage totals are greater than or equal to 40% for 2006.
|
|
Syntax: topSum
|
topSum ( set_expression , numeric_expression1 , numeric_expression2 ) Example topSum ( children ( [Products] ) , 16000000 , tuple ( [2006] , [great_outdoors_ company].[Measures].[Gross profit] ) )
|
|
Syntax: total
|
total ( [ distinct ] expression [ auto ] ) total ( [ distinct ] expression for [ all|any ] expression { , expression } ) total ( [ distinct ] expression for report )
|
|
Syntax: total
|
total ( < currentMeasure|numeric_expression > within set set_expression ) total ( < currentMeasure|numeric_expression > within < detail|aggregate > expression )
|
|
Syntax: toUTC
|
toUTC ( string_expression )
|
|
Syntax: translate
|
translate ( string_expression1 [ , string_expression2, string_expression3 [ , string_expression4 ] ] )
|
|
Syntax: translate
|
translate ( string_expression1 , string_expression2 , string_expression3 )
|
|
Syntax: translate
|
translate ( string_expression1 , string_expression2 , string_expression3 )
|
|
Syntax: translate
|
translate ( string_expression1 , string_expression2 , string_expression3 )
|
|
Syntax: translate
|
translate ( string_expression1 , string_expression2 , string_expression3 )
|
|
Syntax: translate
|
translate ( string_expression1 , string_expression2 , string_expression3 )
|
|
Syntax: translate
|
translate ( string_expression1 , string_expression2 , string_expression3 )
|
|
Syntax: trim
|
trim ( [ [ trailing|leading|both ] [ match_character_expression ] , ] string_ expression )
|
|
Syntax: trim
|
trim ( trim_what_expression , match_character_expression , string_expression )
|
|
Syntax: trunc
|
trunc ( numeric_expression1, numeric_expression2 )
|
|
Syntax: trunc
|
trunc ( numeric_expression [ , integer_expression ] )
|
|
Syntax: trunc
|
trunc ( numeric_expression1 [ , numeric_expression2 ] )
|
|
Syntax: trunc
|
trunc ( date_expression , string_expression )
|
|
Syntax: trunc
|
trunc ( numeric_expression1 , numeric_expression2 )
|
|
Syntax: truncate
|
truncate ( numeric_expression1, numeric_expression2 )
|
|
Syntax: truncate
|
truncate ( string_expression )
|
|
Syntax: tuple
|
tuple ( member { , member } ) Example tuple ( [Mountaineering Equipment] , [Fax] ) Result: Returns the Mountaineering Equipment sales by fax.
|
|
Syntax: type
|
type ( expression )
|
|
Syntax: ucase
|
ucase ( string_expression )
|
|
Syntax: ucase
|
ucase ( string_expression )
|
|
Syntax: uhighsurr
|
uhighsurr ( string_expression , integer_expression )
|
|
Syntax: ulowsurr
|
ulowsurr ( string_expression , integer_expression )
|
|
Syntax: union
|
union ( set_expression1 , set_expression2 [ , all ] ) Example 1 union ( set ( [Camping Equipment] , [Golf Equipment] ) , set ( [Golf Equipment] , [Mountaineering Equipment] ) ) Result: Returns data for both sets as one new set, showing the Golf Equipment column only once. Example 2 union ( set ( [Camping Equipment] , [Golf Equipment] ) , set ( [Golf Equipment] , [Mountaineering Equipment] ) , all ) Result: Returns data for both sets as one new set, showing the Golf Equipment column twice.
|
|
Syntax: unique
|
unique ( array_expression )
|
|
Syntax: unique
|
unique ( set_expression )
|
|
Syntax: upper
|
upper ( string_expression ) Example upper ( 'abcdef' ) Result: ABCDEF Dimensional Functions
|
|
Syntax: upper
|
upper ( string_expression )
|
|
Syntax: urlencode
|
urlencode ( prompt ( 'userValue' ) )
|
|
Syntax: URLEncode
|
URLEncode ('text')
|
|
Syntax: uscalar
|
uscalar ( string_expression )
|
|
Syntax: user
|
{user}
|
|
Syntax: value
|
value ( tuple ) Example 1 value ( tuple ( [great_outdoors_company].[Years].[Years].[Year] ->:[PC].[Years (Root)].[20040101-20041231] , [great_outdoors_company].[Measures].[Revenue] ) ) Result: $34,750,563.50 Example 2 value ( tuple ( [2004] , [Camping Equipment] , [Revenue] ) ) Result: $20,471,328.88 DB2
|
|
Syntax: value
|
value ( expression_list )
|
|
Syntax: varchar
|
varchar ( expression [ , numeric_expression ] )
|
|
Syntax: vargraphic
|
vargraphic ( string_expression )
|
|
Syntax: variance
|
variance ( expression [ auto ] ) variance ( expression for [ all|any ] expression { , expression } ) variance ( expression for report )
|
|
Syntax: variance
|
variance ( < currentMeasure|numeric_expression > within set set_expression ) variance ( < currentMeasure|numeric_expression > within < detail|aggregate > expression )
|
|
Syntax: variance-pop
|
variance-pop ( expression [ auto ] ) variance-pop ( expression for [ all|any ] expression { , expression } ) variance-pop ( expression for report )
|
|
Syntax: variance-pop
|
variance-pop ( < currentMeasure|numeric_expression > within set set_expression ) variance-pop ( < currentMeasure|numeric_expression > within < detail|aggregate > expression )
|
|
Syntax: version
|
version ()
|
|
Syntax: version
|
version ()
|
|
Syntax: version
|
version ()
|
|
Syntax: version
|
version ()
|
|
Syntax: version
|
version ()
|
|
Syntax: version
|
version ()
|
|
Syntax: vsize
|
vsize ( expression )
|
|
Syntax: week
|
week ( date_expression )
|
|
Syntax: week
|
week ( date_expression )
|
|
Syntax: weekday
|
weekday ( date_expression )
|
|
Syntax: when
|
case [expression] when ... end
|
|
Syntax: year
|
year ( date_expression )
|
|
Syntax: year
|
year ( date_expression )
|
|
Syntax: year
|
year ( date_expression )
|
|
Syntax: year
|
year ( date_expression )
|
|
Syntax: year
|
year ( date_expression )
|
|
Syntax: YMinterval2string
|
YMinterval2string ( year_month_interval_expression )
|
|
Syntax: zeroifnull
|
zeroifnull ( numeric_expression )
|
