Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

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
Current Member Is
/Logical | Returns True if the current member in context matches the Member field.
26
Current Members
/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.
27
Current Month
/Time/Current Period | Returns the current month from the provided hierarchy.
28
Current Quarter
/Time/Current Period | Returns the current quarter from the provided hierarchy.
29
Current Week
/Time/Current Period | Returns the current week from the provided hierarchy.
30
Current Year
/Time/Current Period | Returns the current year from the provided hierarchy.
31
Custom Formula
/ | Create a custom formula
32
Custom Set
/ | Returns True if the provided member can be found in the set.
33
Date Difference
/Time | Returns the number of days, weeks or months between two dates.
34
Dates to Current
/Time/Current Period | Returns all members up to and including the current date.
35
Days in Period
/Time | Returns the number days in the current time member.
36
DegreesToRadians
/Value/Math/Geospatial | Converts the specified angle in degrees to radians.
37
Delta
/Value | Returns the difference between adjacent values of the specified formula for the set on the opposite axis.
38
Descendants
/Set | Returns the descendants of the specified member.
39
Descendants [Member]
/Selection Types | Returns the specified member's descendants.
40
Distinct
/Set | Returns only the distinct members of a set.
41
Distinct Count
/Value | Returns the distinct count of the number of members in the specified set.
42
Empty
/Set | Returns a set composed of the empty members from the specified set.
43
Except
/Set | Returns the difference between two specified sets.
44
Except Unknown
/Selection Types | Returns the specified set with any Unknown members removed.
45
Exists
/ | Returns items from a set, for which data exists in specified measure group.
46
Exponent
/Value/Math | Returns e raised to the specified power.
47
Exponential Moving Average
/Time/Moving Averages | Returns an exponential moving average for the specified formula.
48
Filter
/Set | Returns the set resulting from filtering a set based on a condition.
49
First
/Member | Returns the first member of set.
50
Floor
/Value/Rounding | Returns the largest integer less than or equal to the specified double-precision floating-point number.
51
For Each
/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.
52
Full Month (FM)
/Time/Full Period | Returns a member representing the full month.
53
Full Quarter (FQ)
/Time/Full Period | Returns a member representing the full quarter.
54
Full Week (FW)
/Time/Full Period | Returns a member representing the full week.
55
Full Year (FY)
/Time/Full Period | Returns a member representing the full year.
56
Geometric Mean
/Value/Statistics/Descriptive | Returns the geometric mean for the specified set.
57
Grandchildren
/Selection Types | Returns the specified member's grandchildren.
58
Head
/Set | Return a number of items from the start of a list.
59
Include Cube Calculated Members
/Set/Advanced | Adds cube calculated members into the current set. These are not included by default.
60
Intersect
/Set/Advanced Returns the intersection of two sets. For example- the intersection of January to July and June to December is June- July.
61
Is Empty
/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.
62
Is Member Of
/Logical | Returns True if the currently logged-on user is a member of the specified Active Directory or local group.
63
Is User
/Logical | Returns True if the currently logged-on user matches the user name field.
64
Item
/Set | Returns a specific item from a list.
65
Lag/Advance
/Member | Returns the member that is the specified number of positions prior to the specified member.
66
Last
/Member | Returns the last member of set.
67
Last Complete Month
/Time/Current Period/Last Complete | Returns the last complete month from the provided hierarchy.
68
Last Complete Period
/Time | Returns the last complete period for the provided time periods set.
69
Last Complete Periods
/Time | Returns the last complete periods of data for the provided time period's set.
70
Last Complete Quarter
/Time/Current Period/Last Complete | Returns the last complete quarter from the provided hierarchy.
71
Last Complete Week
/Time/Current Period/Last Complete | Returns the last complete week from the provided hierarchy.
72
Last Complete Year
/Time/Current Period/Last Complete | Returns the last complete year from the provided hierarchy.
73
Last Year, Month to Date Total (LY MTD)
/Time/Period to Date Totals/Last Year | Returns the month-to-date total for the previous year's current time member.
74
Last Year, Quarter to Date Total (LY QTD)
/Time/Period to Date Totals/Last Year | Returns the quarter-to-date total for the previous year's current time member.
75
Last Year, Week to Date Total (LY WTD)
/Time/Period to Date Totals/Last Year | Returns the week-to-date total for the previous year's current time member.
76
Last Year, Year to Date Total (LY YTD)
/Time/Period to Date Totals/Last Year | Returns the year-to-date total for the previous year's current time member.
77
Leaves
/Selection Types | Returns the specified member's leaves (lowest level members).
78
Level Number
/Value | Returns the level number for the specified member. The All level is 0.
79
Level by Index
/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
Linear Regression
/Value/Statistics | Returns the regression value, allowing you to show trend lines in charts.
81
Link Member
/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
Ln
/Value/Math | Returns the natural logarithm (base e) of a number.
83
Log10
/Value/Math | Returns the base 10 logarithm of a specified number.
84
Maximum
/Value/Statistics/Descriptive | Returns the highest value from the specified set.
85
Median
/Value/Statistics/Descriptive | Returns the median value (the middle value) in the specified set of ordered numbers.
86
Member and Children
/Selection Types | Returns the specified member and its children.
87
Member and Descendants
/Selection Types | Returns the specified member and its descendants.
88
Member and Siblings
/Selection Types | Returns the specified member and its siblings.
89
Member Name
/Value | Returns the name of a specified member. This function caters to conditional text.
90
Minimum
/Value/Statistics/Descriptive | Returns the smallest value in a specified set.
91
Month to Date Members
/Selection Types/Time | Returns the month to date members for the specified period.
92
Month to Date Total (MTD)
/Time/Period to Date Totals | Returns the month to date total for the current time member.
93
Months to Current
/Time/Current Period | Returns all members up to and including the current month.
94
Most Recent Period
/Time | Returns the most recent data member for the provided time periods set.
95
Most Recent Periods
/Time | Returns the most recent periods of data for the provided time period's set.
96
Names to Set
/ Set / Advanced / | Returns the members from a given hierarchy that match on a comma separated list of names specified as text.
97
Next
/Time | Returns the next member in the level that contains the specified member.
98
Non-Empty
/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
Number Input
/Parameterization | A parameterized numeric entry that prompts the user with a text box when the resource is opened.
100
Opening Balance
/Time Returns the sum of the specified formula for all members up to the end of the member preceding the specified time member.
101
Order
/Set | Sorts the members of a specified set- optionally breaking the hierarchy.
102
Parallel Member
/Member | Returns a member from another period in the same relative position as the specified member.
103
Parallel Period
/Time/Prior Period | Returns a member from another period in the same relative position as the specified member.
104
Parent
/Member | Returns the parent of the specified member.
105
Pareto (80-20)
/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
Percent of Parent
/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
Period on Period Growth
/Time | Returns the growth from the previous period to the current in context.
108
Period to Date Members
/Time | Returns the members to date for the specified period and level.
109
Periods Between
/Time | Returns a set of all dates between the specified members including the members themselves.
110
Periods From
/Time | Returns all members from and including the specified period.
111
Periods To
/Time | Returns all members up to and including the specified period.
112
Periods To Date Total (PTD)
/Time/Period to Date Totals | Returns the period to date total for a specified level.
113
Power
/Value/Math | Returns a specified number raised to the specified power.
114
Previous
/Time | Returns the previous member in the level that contains the specified member.
115
Previous Weekday
/Time | Returns the previous weekday for the specified date member.
116
Prior Month
/Time/Prior Period | Returns a member from the prior month- in the same relative position as the current time member.
117
Prior Month to Date Total
/Time/Period to Date Totals | Returns the month to date total for a member from the prior month.
118
Prior Quarter
/Time/Prior Period | Returns a member from the prior quarter- in the same relative position as the current time member.
119
Prior Quarter to Date Total
/Time/Period to Date Totals | Returns the quarter to date total for a member from the prior quarter.
120
Prior Week
/Time/Prior Period | Returns a member from the prior week- in the same relative position as the current time member.
121
Prior Week to Date Total
/Time/Period to Date Totals | Returns the week to date total for a member from the prior week.
122
Prior Year
/Time/Prior Period | Returns a member from the prior year- in the same relative position as the current time member.
123
Prior Year to Date Total
/Time/Period to Date Totals | Returns the year to date total for a member from the prior year.
124
Quarter to Date Members
/Selection Types/Time | Returns the quarter to date members for the specified period.
125
Quarter to Date Total (QTD)
/Time/Period to Date Totals | Returns the quarter to date total for the current time member.
126
Quarters to Current
/Time/Current Period | Returns all members up to and including the current quarter.
127
RadiansToDegrees
/Value/Math/Geospatial | Converts the specified angle in radians to degrees.
128
Range
/Set/Dynamic Sets Returns a set of members between the specified ToMember and FromMember values - optionally including the members themselves.
129
Rank
/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
Rank Set
/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
Reference Member
/ | Reference another formula or member function.
132
Reference Set
/ | Reference another set of members or a template set.
133
Reverse
/Set | Reverses the order of members in a set.
134
Round
/Value/Rounding | Rounds a double-precision floating-point value to a specified number of decimal digits.
135
Simple Moving Average
/Time/Moving Averages | Returns a simple moving average for the specified formula.
136
Sin
/Value/Math/Geospatial | Returns the sine of the specified angle.
137
Sparkline
/Visualization | Creates small trend line charts (sparklines) within analyses based on a numeric formula and a specified time period.
138
Standard Deviation
/Value/Statistics/Descriptive | Returns the standard deviation of a numeric expression evaluated over a set.
139
Starts With
/Set/Dynamic Sets | Returns a set of members- from the specified set- that begin with the specified text.
140
Static Set
/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
Status
/Visualization | Generates KPI status icons depending on the specified boundaries.
142
Sub Set
/Set | Returns a sub-range of members from a set.
143
Sum
/Value | Returns the sum of the specified set.
144
Tail
/Set | Return a number of items from the end of a list.
145
Tan
/Value/Math/Geospatial | Returns the tangent of the specified angle.
146
Text
/Text | Enables the entry of text into a formula.
147
Top Count
/Set/Top and Bottom | Returns a specified number of items from the top of a set.
148
Top Percent
/Set/Top and Bottom | Returns a set with the highest values- whose cumulative total is equal to or greater than a specified percentage.
149
Top Sum
/Set/Top and Bottom | Returns a set with the highest values- whose sum is equal to or greater than a specified value.
150
Total to Date (TTD)
/Time/Period to Date Totals | Returns the total-to-date amount for the current time member.
151
Total to Date Members
/Selection Types/Time | Returns the total to date members for the specified period.
152
Truncate
/Value/Rounding | Calculates the integer part of a specified double-precision floating-point number.
153
Value Range
/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
Variance
/Value/Statistics/Descriptive | Returns the variance of a specified numeric expression- evaluated over a specified set.
155
Visual Totals
/ Limit calculated totals to those child members present in the set. Optionally provide a naming pattern for those calculated totals.
156
Week to Date Members
/Selection Types/Time | Returns the week to date members for the specified period.
157
Week to Date Total (WTD)
/Time/Period to Date Totals | Returns the week-to-date total for the current time member.
158
Weeks to Current
/Time/Current Period | Returns all members up to and including the current week.
159
Weighted Moving Average
/Time/Moving Averages | Returns a weighted moving average for the specified formula.
160
Year to Date Members
/Selection Types/Time | Returns the year to date members for the specified period.
161
Year to Date Total (YTD)
/Time/Period to Date Totals | Returns the year-to-date total for the current time member.
162
Years to Current
/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.
© 2025 Bold Learning Solutions. Terms and Conditions