Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Zap Business Intelligence > Functions > Flashcards

Functions Flashcards

1
Q

Absolute Value

A

/Value/Math

Returns the value of a number without its sign.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Accumulate

A

/Value

Returns a running total for the specified formula for the set on the opposite axis.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Aggregate

A

/Value

Aggregate using the default operation defined for the hierarchy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Ancestor

A

/Member

Returns the ancestor of a member at a specified level.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Asin

A

/Value/Math/

Returns the angle whose sine is the specified number.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Atan

A

/Value/Math/

Returns the angle whose tangent is the specified number.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Average

A

/Value

Returns the arithmetic mean of the specified set.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Bottom Count

A

/Set/Top and Bottom

Returns a specified number of items from the bottom of a set.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Bottom Percent

A

/Set/Top and Bottom

Returns a set with the lowest values- whose cumulative total is equal to or greater than a specified percentage.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Bottom Sum

A

/Set/Top and Bottom

Returns a set with the lowest values whose sum is equal to or greater than a specified value.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Ceiling

A

/Value/Rounding
Returns the smallest integer value that is greater than or equal to the specified double-precision floating-point number.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Checkbox

A

/Parameterization

A parameterized checkbox entry that prompts the user when the resource is opened.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Children

A

/Selection Types

Returns the specified member’s children.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Closing Balance

A

/Time

Returns the sum of the specified formula for all members up to the end of the specified time member.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Conditional Set

A

/Set/Dynamic Sets

Returns one of two specified sets- depending on whether the specified condition is True or False.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Contains

A

/Set/Dynamic Sets

Returns a set of members- from the specified set- that contain the specified text.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Contains Member

A

/Logical

Returns True if the provided member can be found in the set.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Context Period

A

/Time/Current Period

Returns the period in context- either provided by the opposite axis or the filter context.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Cos

A

/Value/Math/Geospatial

Returns the cosine of the specified angle.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Count

A

/Value

Returns the count of the number of members in the specified set.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Count Existing

A

/Value
Returns the count of items that have non-empty entries (exist) for the second set. For example- where Count returns the number of days in a month- CountExisting could return the number of days on which a sale occurred.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Cross-Hierarchy Union

A

/Set/Advanced
Occasionally it is necessary to union two sets from different hierarchies. This is best demonstrated with two time hierarchies; e.g. Created On and Re-opened On. A cross-hierarchy union of a set from each of these dimensions would result in all Created On or Re-opened On dates.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Current Date

A

/Time/Current Period

Returns the current date. The date hierarchy is defaulted if only a single one exists.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Current Member

A

/Member

Returns the current member from a hierarchy.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Current Member Is

A

/Logical

Returns True if the current member in context matches the Member field.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

Current Members

A

/Text
Returns the names of current members for the specified hierarchies; or- if no hierarchy is specified- the names of the current members for all non-default hierarchies.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

Current Month

A

/Time/Current Period

Returns the current month from the provided hierarchy.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

Current Quarter

A

/Time/Current Period

Returns the current quarter from the provided hierarchy.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

Current Week

A

/Time/Current Period

Returns the current week from the provided hierarchy.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

Current Year

A

/Time/Current Period

Returns the current year from the provided hierarchy.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

Custom Formula

A

/

Create a custom formula

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

Custom Set

A

/

Returns True if the provided member can be found in the set.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

Date Difference

A

/Time

Returns the number of days, weeks or months between two dates.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

Dates to Current

A

/Time/Current Period

Returns all members up to and including the current date.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

Days in Period

A

/Time

Returns the number days in the current time member.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

DegreesToRadians

A

/Value/Math/Geospatial

Converts the specified angle in degrees to radians.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

Delta

A

/Value

Returns the difference between adjacent values of the specified formula for the set on the opposite axis.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

Descendants

A

/Set

Returns the descendants of the specified member.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

Descendants [Member]

A

/Selection Types

Returns the specified member’s descendants.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

Distinct

A

/Set

Returns only the distinct members of a set.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

Distinct Count

A

/Value

Returns the distinct count of the number of members in the specified set.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

Empty

A

/Set

Returns a set composed of the empty members from the specified set.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

Except

A

/Set

Returns the difference between two specified sets.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

Except Unknown

A

/Selection Types

Returns the specified set with any Unknown members removed.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

Exists

A

/

Returns items from a set, for which data exists in specified measure group.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

Exponent

A

/Value/Math

Returns e raised to the specified power.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

Exponential Moving Average

A

/Time/Moving Averages

Returns an exponential moving average for the specified formula.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q

Filter

A

/Set

Returns the set resulting from filtering a set based on a condition.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
49
Q

First

A

/Member

Returns the first member of set.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
50
Q

Floor

A

/Value/Rounding

Returns the largest integer less than or equal to the specified double-precision floating-point number.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
51
Q

For Each

A

/Set/Advanced
For each member of the first set- an instance of the second set is generated. For example- for each of the top 5 sales regions- return the top 5 sales persons.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
52
Q

Full Month (FM)

A

/Time/Full Period

Returns a member representing the full month.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
53
Q

Full Quarter (FQ)

A

/Time/Full Period

Returns a member representing the full quarter.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
54
Q

Full Week (FW)

A

/Time/Full Period

Returns a member representing the full week.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
55
Q

Full Year (FY)

A

/Time/Full Period

Returns a member representing the full year.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
56
Q

Geometric Mean

A

/Value/Statistics/Descriptive

Returns the geometric mean for the specified set.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
57
Q

Grandchildren

A

/Selection Types

Returns the specified member’s grandchildren.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
58
Q

Head

A

/Set

Return a number of items from the start of a list.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
59
Q

Include Cube Calculated Members

A

/Set/Advanced

Adds cube calculated members into the current set. These are not included by default.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
60
Q

Intersect

A

/Set/Advanced
Returns the intersection of two sets. For example- the intersection of January to July and June to December is June- July.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
61
Q

Is Empty

A

/Logical
Returns true for formulas that evaluate to empty (null) data. However, this is not equivalent to comparing the value with null, because nulls are implicitly converted to zeros.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
62
Q

Is Member Of

A

/Logical

Returns True if the currently logged-on user is a member of the specified Active Directory or local group.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
63
Q

Is User

A

/Logical

Returns True if the currently logged-on user matches the user name field.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
64
Q

Item

A

/Set

Returns a specific item from a list.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
65
Q

Lag/Advance

A

/Member

Returns the member that is the specified number of positions prior to the specified member.

66
Q

Last

A

/Member

Returns the last member of set.

67
Q

Last Complete Month

A

/Time/Current Period/Last Complete

Returns the last complete month from the provided hierarchy.

68
Q

Last Complete Period

A

/Time

Returns the last complete period for the provided time periods set.

69
Q

Last Complete Periods

A

/Time

Returns the last complete periods of data for the provided time period’s set.

70
Q

Last Complete Quarter

A

/Time/Current Period/Last Complete

Returns the last complete quarter from the provided hierarchy.

71
Q

Last Complete Week

A

/Time/Current Period/Last Complete

Returns the last complete week from the provided hierarchy.

72
Q

Last Complete Year

A

/Time/Current Period/Last Complete

Returns the last complete year from the provided hierarchy.

73
Q

Last Year, Month to Date Total (LY MTD)

A

/Time/Period to Date Totals/Last Year

Returns the month-to-date total for the previous year’s current time member.

74
Q

Last Year, Quarter to Date Total (LY QTD)

A

/Time/Period to Date Totals/Last Year

Returns the quarter-to-date total for the previous year’s current time member.

75
Q

Last Year, Week to Date Total (LY WTD)

A

/Time/Period to Date Totals/Last Year

Returns the week-to-date total for the previous year’s current time member.

76
Q

Last Year, Year to Date Total (LY YTD)

A

/Time/Period to Date Totals/Last Year

Returns the year-to-date total for the previous year’s current time member.

77
Q

Leaves

A

/Selection Types

Returns the specified member’s leaves (lowest level members).

78
Q

Level Number

A

/Value

Returns the level number for the specified member. The All level is 0.

79
Q

Level by Index

A

/Set
Returns a level specified by index from a specified hierarchy. The All level is 0. The Level Number function can be a useful complement to this function.

80
Q

Linear Regression

A

/Value/Statistics

Returns the regression value, allowing you to show trend lines in charts.

81
Q

Link Member

A

/Member
Returns a member parallel to the reference member- in the specified hierarchy. For example- returns the January Ship Date member for the the January Order Date member.

82
Q

Ln

A

/Value/Math

Returns the natural logarithm (base e) of a number.

83
Q

Log10

A

/Value/Math

Returns the base 10 logarithm of a specified number.

84
Q

Maximum

A

/Value/Statistics/Descriptive

Returns the highest value from the specified set.

85
Q

Median

A

/Value/Statistics/Descriptive

Returns the median value (the middle value) in the specified set of ordered numbers.

86
Q

Member and Children

A

/Selection Types

Returns the specified member and its children.

87
Q

Member and Descendants

A

/Selection Types

Returns the specified member and its descendants.

88
Q

Member and Siblings

A

/Selection Types

Returns the specified member and its siblings.

89
Q

Member Name

A

/Value

Returns the name of a specified member. This function caters to conditional text.

90
Q

Minimum

A

/Value/Statistics/Descriptive

Returns the smallest value in a specified set.

91
Q

Month to Date Members

A

/Selection Types/Time

Returns the month to date members for the specified period.

92
Q

Month to Date Total (MTD)

A

/Time/Period to Date Totals

Returns the month to date total for the current time member.

93
Q

Months to Current

A

/Time/Current Period

Returns all members up to and including the current month.

94
Q

Most Recent Period

A

/Time

Returns the most recent data member for the provided time periods set.

95
Q

Most Recent Periods

A

/Time

Returns the most recent periods of data for the provided time period’s set.

96
Q

Names to Set

A

/ Set / Advanced /

Returns the members from a given hierarchy that match on a comma separated list of names specified as text.

97
Q

Next

A

/Time

Returns the next member in the level that contains the specified member.

98
Q

Non-Empty

A

/Set
Returns a set of members from a set- which exist in a second set- where the members have non-null values. For example- returns the set of Products that have sales in New York.

99
Q

Number Input

A

/Parameterization

A parameterized numeric entry that prompts the user with a text box when the resource is opened.

100
Q

Opening Balance

A

/Time
Returns the sum of the specified formula for all members up to the end of the member preceding the specified time member.

101
Q

Order

A

/Set

Sorts the members of a specified set- optionally breaking the hierarchy.

102
Q

Parallel Member

A

/Member

Returns a member from another period in the same relative position as the specified member.

103
Q

Parallel Period

A

/Time/Prior Period

Returns a member from another period in the same relative position as the specified member.

104
Q

Parent

A

/Member

Returns the parent of the specified member.

105
Q

Pareto (80-20)

A

/Set/Top and Bottom

Returns a set with the items composing the top 80 percent and the sum of the items composing the bottom 20 percent.

106
Q

Percent of Parent

A

/Value
Returns the percentage of parent that the current member of a hierarchy forms- calculated for a specified formula. Optionally, restricts the calculation to only those parents on the opposite axis.

107
Q

Period on Period Growth

A

/Time

Returns the growth from the previous period to the current in context.

108
Q

Period to Date Members

A

/Time

Returns the members to date for the specified period and level.

109
Q

Periods Between

A

/Time

Returns a set of all dates between the specified members including the members themselves.

110
Q

Periods From

A

/Time

Returns all members from and including the specified period.

111
Q

Periods To

A

/Time

Returns all members up to and including the specified period.

112
Q

Periods To Date Total (PTD)

A

/Time/Period to Date Totals

Returns the period to date total for a specified level.

113
Q

Power

A

/Value/Math

Returns a specified number raised to the specified power.

114
Q

Previous

A

/Time

Returns the previous member in the level that contains the specified member.

115
Q

Previous Weekday

A

/Time

Returns the previous weekday for the specified date member.

116
Q

Prior Month

A

/Time/Prior Period

Returns a member from the prior month- in the same relative position as the current time member.

117
Q

Prior Month to Date Total

A

/Time/Period to Date Totals

Returns the month to date total for a member from the prior month.

118
Q

Prior Quarter

A

/Time/Prior Period

Returns a member from the prior quarter- in the same relative position as the current time member.

119
Q

Prior Quarter to Date Total

A

/Time/Period to Date Totals

Returns the quarter to date total for a member from the prior quarter.

120
Q

Prior Week

A

/Time/Prior Period

Returns a member from the prior week- in the same relative position as the current time member.

121
Q

Prior Week to Date Total

A

/Time/Period to Date Totals

Returns the week to date total for a member from the prior week.

122
Q

Prior Year

A

/Time/Prior Period

Returns a member from the prior year- in the same relative position as the current time member.

123
Q

Prior Year to Date Total

A

/Time/Period to Date Totals

Returns the year to date total for a member from the prior year.

124
Q

Quarter to Date Members

A

/Selection Types/Time

Returns the quarter to date members for the specified period.

125
Q

Quarter to Date Total (QTD)

A

/Time/Period to Date Totals

Returns the quarter to date total for the current time member.

126
Q

Quarters to Current

A

/Time/Current Period

Returns all members up to and including the current quarter.

127
Q

RadiansToDegrees

A

/Value/Math/Geospatial

Converts the specified angle in radians to degrees.

128
Q

Range

A

/Set/Dynamic Sets
Returns a set of members between the specified ToMember and FromMember values - optionally including the members themselves.

129
Q

Rank

A

/Value
Returns the rank of the specified formula for each item in the set on the opposite axis. NB ranking is expensive. It is therefore recommended that a Top or Bottom function be applied to the opposite axis to avoid ranking directly on large (thousands) sets.

130
Q

Rank Set

A

/Value
Returns the rank of the specified formula for each item in the specified set. NB ranking is expensive. It is therefore recommended that a Top or Bottom function first be applied to the rank set to avoid ranking directly on large (thousands) sets.

131
Q

Reference Member

A

/

Reference another formula or member function.

132
Q

Reference Set

A

/

Reference another set of members or a template set.

133
Q

Reverse

A

/Set

Reverses the order of members in a set.

134
Q

Round

A

/Value/Rounding

Rounds a double-precision floating-point value to a specified number of decimal digits.

135
Q

Simple Moving Average

A

/Time/Moving Averages

Returns a simple moving average for the specified formula.

136
Q

Sin

A

/Value/Math/Geospatial

Returns the sine of the specified angle.

137
Q

Sparkline

A

/Visualization

Creates small trend line charts (sparklines) within analyses based on a numeric formula and a specified time period.

138
Q

Standard Deviation

A

/Value/Statistics/Descriptive

Returns the standard deviation of a numeric expression evaluated over a set.

139
Q

Starts With

A

/Set/Dynamic Sets

Returns a set of members- from the specified set- that begin with the specified text.

140
Q

Static Set

A

/Set
By default- sets are evaluated for each pivot table cell. Specifying a set as static evaluates it once- stores the result- and subsequently reuses the stored set. This may improve performance.

141
Q

Status

A

/Visualization

Generates KPI status icons depending on the specified boundaries.

142
Q

Sub Set

A

/Set

Returns a sub-range of members from a set.

143
Q

Sum

A

/Value

Returns the sum of the specified set.

144
Q

Tail

A

/Set

Return a number of items from the end of a list.

145
Q

Tan

A

/Value/Math/Geospatial

Returns the tangent of the specified angle.

146
Q

Text

A

/Text

Enables the entry of text into a formula.

147
Q

Top Count

A

/Set/Top and Bottom

Returns a specified number of items from the top of a set.

148
Q

Top Percent

A

/Set/Top and Bottom

Returns a set with the highest values- whose cumulative total is equal to or greater than a specified percentage.

149
Q

Top Sum

A

/Set/Top and Bottom

Returns a set with the highest values- whose sum is equal to or greater than a specified value.

150
Q

Total to Date (TTD)

A

/Time/Period to Date Totals

Returns the total-to-date amount for the current time member.

151
Q

Total to Date Members

A

/Selection Types/Time

Returns the total to date members for the specified period.

152
Q

Truncate

A

/Value/Rounding

Calculates the integer part of a specified double-precision floating-point number.

153
Q

Value Range

A

/Value/Statistics/Descriptive
Value Range is the length of the smallest interval which contains all the data. It is calculated by subtracting the smallest observation (sample minimum) from the greatest (sample maximum) and provides an indication of statistical dispersion.

154
Q

Variance

A

/Value/Statistics/Descriptive

Returns the variance of a specified numeric expression- evaluated over a specified set.

155
Q

Visual Totals

A

/
Limit calculated totals to those child members present in the set. Optionally provide a naming pattern for those calculated totals.

156
Q

Week to Date Members

A

/Selection Types/Time

Returns the week to date members for the specified period.

157
Q

Week to Date Total (WTD)

A

/Time/Period to Date Totals

Returns the week-to-date total for the current time member.

158
Q

Weeks to Current

A

/Time/Current Period

Returns all members up to and including the current week.

159
Q

Weighted Moving Average

A

/Time/Moving Averages

Returns a weighted moving average for the specified formula.

160
Q

Year to Date Members

A

/Selection Types/Time

Returns the year to date members for the specified period.

161
Q

Year to Date Total (YTD)

A

/Time/Period to Date Totals

Returns the year-to-date total for the current time member.

162
Q

Years to Current

A

/Time/Current Period

Returns all members up to and including the current year.

Zap Business Intelligence (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions