Index
A
- ABC analysis
- Account.Accounts hierarchy / How it works...
- Account dimension / Displaying members without children (leaves), Getting ready
- AddCalculatedMembers() function / There's more…
- Ad hoc distributed queries
- URL / Additional information
- Adventure Works database / Getting ready
- Aggregate() function / There's more..., How it works...
- AggregateFunction property / How it works...
- ALTER CUBE command / How to do it…
- Analysis Services 2000
- accessing, from 64-bit environment / Accessing Analysis Services 2000 from a 64-bit environment
- Analysis Services cache
- Analysis Services Stored Procedure Project (ASSP)
- URL / Alternative solution
- about / Introduction
- Analysis Services Stored Procedure Project assembly
- URL, for downloading / Getting ready
- Analysis Services stored procedures
- arbitrary
- URL / There's more...
- Ascendants() function / Children() will return empty sets when out of boundaries
- ASSP.InverseHierarchility() stored procedure / There's more...
- AsymmetricSet() function
- URL / A very complex scenario
- attribute
- new attribute, used to separate members on level / Using a new attribute to separate members on a level, Getting ready, How to do it..., How it works..., So, where's the MDX?
- attribute hierarchy
- used, for todays date calculation / Calculating today's date using an attribute hierarchy, How to do it..., How it works...
- AttributeHierarchyEnabled property / There's more…
- attribute relationships
- data retrieval, PROPERTIES() function used / Using the PROPERTIES() function to retrieve data from attribute relationships, Getting ready, How to do it…, How it works…, There's more…
- average
- calculating / Calculating various averages, How to do it..., How it works..., There's more...
- AVG() function / How to do it…, How it works...
- Avg() function / Other specifics of average calculations
- axis
- skipping / Skipping axes, How it works…, The idea behind it
- Axis() function / A simplified version of the solution
B
- BACK_COLOR property / How to do it..., How it works..., How it works...
- best members
- identifying, for each member of another hierarchy / Identifying the best/worst members for each member of another hierarchy, How to do it..., How it works..., There's more...
- best N members
- isolating, in set / Isolating the best N members in a set, Getting ready, How to do it..., How it works..., The top N member is evaluated in All Periods, not in the context of the opposite query axis, Use a tuple in the third argument of the TopCount() function to overwrite the member on the slicer, Testing the correctness of the result, TopPercent() and TopSum() functions
- best value
- child name, finding with / Finding the name of a child with the best/worst value, Getting ready, How to do it..., How it works..., There's more...
- siblings, highlighting with / Highlighting siblings with the best/worst values, Getting ready, How to do it..., How it works..., There's more...
- BIDS
- about / Introduction
- BIDS Helper / Getting ready
- BottomCount() function / How to do it..., How it works...
- BottomPercent() function / There's more...
- BottomSum() function / There's more...
- bubble-up exceptions
- implementing / Implementing bubble-up exceptions, How to do it..., How it works..., There's more...
C
- .CurrentOrdinal function / There's more…
- CALCULATE command / Getting ready
- call method / How it works...
- Cartesian product / Finding related members in another dimension
- child name
- finding, with best value / Finding the name of a child with the best/worst value, Getting ready, How to do it..., How it works..., There's more...
- finding, with worst value / Finding the name of a child with the best/worst value, Getting ready, How to do it..., How it works..., There's more...
- ClearAllCaches function / There's more..., How to do it...
- ClearCache command / How it works...
- CoalesceEmpty() function / Other specifics of average calculations
- CodePlex
- about / Introduction
- complex sorts
- Const Value / How it works...
- Corporate datamember / How to do it...
- Corporate datamember / How it works...
- Count() function / Other specifics of average calculations
- COUNT() function / How to do it…, How it works…
- count of siblings / There's more...
- cross join
- hierarchies, inserting on x axis / Putting more hierarchies on x and y axes with cross join
- hierarchies, inserting on y axis / Putting more hierarchies on x and y axes with cross join
- CROSSJOIN function / Putting data on x and y axes
- Cube
- about / Objects whose cache can be cleared
- fast-document, SSAS Dynamic Management Views (DMV) used / Using SSAS Dynamic Management Views (DMV) to fast-document a cube, Getting ready, How to do it..., There's more..., Tips and tricks, Warning!
- cumulative calculations
- and recursive, selecting between / Choosing between recursive and cumulative calculations
- cumulative value calculation, recursion used
- solution, version / A simplified version of the solution
- cumulative values
- calculating, recursion used / Using recursion to calculate cumulative values, How to do it..., How it works..., There's more...
- CURRENT function / There's more…
- CurrentMember function / There's more..., How it works...
- CURRENTORDINAL function / There's more…
- Customer Count / How it works...
- customers
- fluctuation, analyzing / Analyzing fluctuation of customers, How to do it..., How it works...
- loyal customers in particular period, identifying / Identifying loyal customers in a particular period, The alternative approach
D
- .DataMember function / How it works...
- data
- inserting, on x axis / Putting data on x and y axes, Getting ready, How to do it…, How it works…
- inserting, on y axis / Putting data on x and y axes, Getting ready, How to do it…, How it works…
- filtering, WHERE clause used / Using a WHERE clause to filter the data returned, How to do it…, There's more…
- Data Mining / Other approaches
- data retrieval
- from attribute relationships, PROPERTIES() function used / Using the PROPERTIES() function to retrieve data from attribute relationships, Getting ready, How to do it…, How it works…, There's more…
- Data Source View (DSV) / How it works...
- Data Warehouse (DW) / Allocating the nonallocated company expenses to departments, How it works...
- DateDiff() function / Dates in other scenarios
- Date dimension / Implementing the logical AND on members from the same hierarchy
- Deep Autoexists
- default member
- setting, in MDX script / Setting a default member of a hierarchy in the MDX script, How to do it…, There's more…, Helpful tips
- DefaultMember property
- Department.Departments hierarchy / How it works...
- Descendant() function
- second argument / Second and third argument in Descendant() are optional
- third argument / Second and third argument in Descendant() are optional
- DESCENDANTS() function / How it works…
- Descendants() function / How it works…, How to do it..., There's more..., How it works...
- dimension
- related members, finding / Finding related members in another dimension, Getting ready, How to do it..., How it works..., There's more...
- using, to calculate frequent price / Using a new dimension to calculate the most frequent price, How to do it..., How it works..., There's more...
- Dimension(N) / How it works...
- DIMENSION PROPERTIES keyword / Getting ready
- direct expense / Allocating the nonallocated company expenses to departments
- Discount Percent attribute / There's more…
- DISCOVER_OBJECT_ACTIVITY DMV / How it works...
- DisplayFolder property / How to do it...
- distinct count measure
- using, to implement histograms over existing hierarchies / Using a distinct count measure to implement histograms over existing hierarchies, Getting ready, How to do it..., There's more...
- division
- handling, by zero errors / Handling division by zero errors, Getting ready, How to do it…, How it works…
- drill-through
- custom drill-through, performing / Performing a custom drillthrough, Getting ready, How it works..., There's more...
- drillthrough command / Other examples
- DRILLTHROUGH mechanism
- about / Introduction
- dummy dimension
- using, to implenent histograms over non-existing hierarchies / Using a dummy dimension to implement histograms over nonexisting hierarchies, How to do it..., How it works..., There's more...
- DW / Introduction
- Dynamic Management Views (DMVs)
- about / Introduction
E
- Employee.Employees hierarchy / There's more...
- Employee attribute / There's more…
- Employee dimension / Displaying members without children (leaves)
- empty rows
- preserving / Preserving empty rows
- Enterprise Edition (EE) / How it works...
- ETL (Extract, Transform, Load) phase / Allocating the nonallocated company expenses to departments
- EXCEPT() function / Hints for query improvements
- Except() function / How it works…, The query-based alternative
- EXISTING / There's more..., Filter() versus Exists(), Existing(), and EXISTING
- tips and tricks / Tips and trick related to the EXISTING keyword
- Existing() function / Filter() versus Exists(), Existing(), and EXISTING
- EXISTING function / Common mistakes and useful tips
- EXISTING keyword / Common mistakes and useful tips, There's more...
- EXISTS() function / Hints for query improvements
- Exists() function / How to do it…, There's more..., Filter() versus Exists(), Existing(), and EXISTING
- expenses
- non-allocated company expenses, allocating to departments / Allocating the nonallocated company expenses to departments, Getting ready, How to do it..., How it works..., There's more...
- indirect expense / Allocating the nonallocated company expenses to departments
- allocation scheme, selecting / Choosing a proper allocation scheme
- External Data
- URL / Additional information
F
- False parameter / How it works…
- Filter() function / There's more…, NonEmpty() versus NON EMPTY, There's more…, There's more…, There's more..., There's more..., Filter() versus Exists(), Existing(), and EXISTING
- FILTER() function / How to do it…, How it works…
- Filter() operation / How it works…
- flexible display units
- implementing, utility dimension used / Using a utility dimension to implement flexible display units, How to do it..., There's more..., Set-based approach
- forecasting
- linear regression using / Forecasting using the linear regression, How to do it..., How it works..., There's more..., Where to find more information?
- periodic cycles using / Forecasting using the periodic cycles, Getting ready, How to do it..., How it works..., There's more...
- FORE_COLOR property / There's more..., How to do it..., How it works...
- Format_String() function / Format string on a filtered set approach
- Freeze() statement / There's more...
- Frequency dimension / There's more...
- frequent price
- calculating, new dimension used / Using a new dimension to calculate the most frequent price, How to do it..., How it works...
- FROM clause / How to do it…
G
- GENERATE() function / Iterating on a set in order to create a new one, Iterating on a set using recursion
- Generate() function / How to do it…, How it works…, There's more…, There's more..., How to do it..., How it works..., There's more..., Displaying more than one member's caption, There's more...
- about / How it works…
- URL / How it works…
H
- hierarchies
- inserting, on x axis with cross join / Putting more hierarchies on x and y axes with cross join
- inserting, on y axis with cross join / Putting more hierarchies on x and y axes with cross join
- Hierarchize() function / There's more...
- hierarchy members
- sample, displaying / Displaying a random sample of hierarchy members, How to do it..., How it works...
- histograms
- over existing hierarchies implementing, distinct count measure used / Using a distinct count measure to implement histograms over existing hierarchies, How to do it..., There's more...
- over non-existing hierarchies implementing, dummy dimension used / Using a dummy dimension to implement histograms over nonexisting hierarchies, How to do it..., How it works..., There's more...
I
- ID property / How to do it...
- iif() clause / Preserving empty rows
- IIF() expression / How it works...
- iif() function / There's more..., How it works..., How it works..., How it works..., Important remarks, Preserving empty rows
- IIF() function
- URL / There's more…
- Inception-To-Date calculation / Inception-To-Date calculation
- indirect expense / Allocating the nonallocated company expenses to departments
- InStr() function / There's more…
- Intersect() function / Detecting complex combination of members, How it works...
- IsAggregatable property / There's more…, A special case of a non-aggregatable dimension, Detecting the root member
- IsAncestor() function / The query-based alternative
- IsEmpty() function / How it works…, There's more..., There's more...
- IsLeaf() function / There's more...
- ISLEAF() function / How to do it…
- IS operator / How it works...
- Item() function / There's more…, How it works...
- iteration
- about / Iterating on a set in order to reduce it
- used, on set for filtering / Iterating on a set in order to reduce it, Getting ready, How it works…, There's more…, Hints for query improvements
- used, on set for creating new one / Iterating on a set in order to create a new one, How to do it…, How it works…, There's more…
L
- .Level(0) function / How it works...
- Lag() function / There's more...
- last date, with data
- finding / Finding the last date with data, Getting ready, How to do it..., How it works..., There's more...
- values, obtaining / Getting values on the last date with data, How to do it..., How it works..., There's more...
- LastPeriods() function / There's more..., Moving averages and the future dates
- leaf calculation / Leaf and non-leaf calculations
- leaf member values
- percentage / The percentage of leaf member values
- LEAVES flag / How it works...
- Level Rank / How it works...
- linear regression
- used, for forecasting / Forecasting using the linear regression, How to do it..., How it works..., There's more..., Where to find more information?
- linked server
- URL / Additional information
- troubleshooting / Troubleshooting the linked server
- Linked Server properties
- URL / Additional information
- LinRegPoint() function / How to do it..., How it works..., There's more...
- logical AND
- implementing, on members from same hierarchy / Implementing the logical AND on members from the same hierarchy, Getting ready, How to do it…, How it works…, See also
- logical OR
- implementing, on members from different hierarchies / Implementing the logical OR on members from different hierarchies, Getting ready, How to do it…, How it works…, A very complex scenario
- Lost Customers measure / How it works...
M
- .MemberValue function / How to do it…
- Max() function / There's more..., How it works...
- MDX
- about / Introduction
- MDX assignments
- physical measure, creating as placeholder / Creating a physical measure as a placeholder for MDX assignments, How to do it..., How it works..., Associated measure group
- MDX functions
- URL / Useful string functions
- MDX queries
- optimizing, NonEmpty() function used / Optimizing MDX queries using the NonEmpty() function, Getting ready, How it works…, There's more…, Common mistakes and useful tips
- dissecting / Dissecting and debugging MDX queries, How to do it…, How it works…, There's more…
- executing, in T-SQL environments / Executing MDX queries in T-SQL environments, Getting ready, How to do it..., How it works..., There's more...
- generated by SSAS frontends, capturing / Capturing MDX queries generated by SSAS frontends, Getting ready, How to do it..., How it works..., Alternative solution
- MDX script
- default member, setting / Setting a default member of a hierarchy in the MDX script, How to do it…, There's more…, Helpful tips
- MDX topics
- about / Introduction
- members
- logical OR, implementing from different hierarchies / Implementing the logical OR on members from different hierarchies, Getting ready, How to do it…, How it works…, A very complex scenario
- logical AND, implementing from same hierarchy / Implementing the logical AND on members from the same hierarchy, Getting ready, How to do it…, How it works…, See also
- displaying / Displaying few important members, others as a single row, and the total at the end, Getting ready, How to do it..., How it works..., Making the query even more generic
- in hierarchy, detecting / Detecting a particular member in a hierarchy, How to do it..., How it works..., There's more...
- versus comparing values, comparing / Comparing members versus comparing values
- complex combination, detecting / Detecting complex combination of members, See also
- root member, detecting / Detecting the root member, How to do it..., How it works..., There's more...
- scope-based solution / The scope-based solution
- on same brach, detecting / Detecting members on the same branch, How to do it..., How it works..., There's more...
- query-based alternative / The query-based alternative
- related members in same dimension, finding / Finding related members in the same dimension, Getting ready, How to do it..., How it works..., There's more...
- on level, separating / Using a new attribute to separate members on a level, Getting ready, How to do it..., How it works...
- displaying, without children / Displaying members without children (leaves), How to do it..., How it works...
- displaying, with data in parent-children hierarchies / Displaying members with data in parent-child hierarchies, Getting ready, How to do it..., There's more...
- Members function / Displaying members without children (leaves)
- MembersWithDataCaption properties / Displaying members with data in parent-child hierarchies
- MembersWithDataCaption property / Alternative solution
- MembersWithData function / Displaying members with data in parent-child hierarchies
- MembertToStr function / There's more…
- MemberValue() function / How it works..., There's more...
- MemberValue function
- used, for todays date calculation / Calculating today's date using the MemberValue function, How to do it..., How it works...
- MemberValue property / There's more…, How it works...
- MemberWithData property / Alternative solution
- Microsoft Visual Basic for Applications (VBA) COM / Existing assemblies
- Min() function / How it works...
- MIN() function / How it works...
- moving averages
- about / Calculating moving averages
- calculating / How to do it..., How it works..., There's more...
- calculating, alternate ways / Other ways to calculate the moving averages, Moving averages and the future dates
- MSDN links
- muliple date difference
- calculating / Calculating the difference between two dates, How to do it..., How it works..., Dates in other scenarios
- non-consecutive dates, issue / The problem of non-consecutive dates, See also
- muliple time difference
- calculating / Calculating the difference between two times, How it works...
- duration, formatting / Formatting the duration
- web duration, formatting time / Examples of formatting the duration on the web
- multidimensional cubes
- about / Introduction
- multidimensional cubes
- about / Introduction
- multidimensional sets
- about / Multidimensional sets
- multiple hierarchies
- combining, into one / Combining two hierarchies into one, How to do it..., How it works..., There's more...
- disadvantages / Limitations
N
- .name function / How it works...
- NA / Using a new attribute to separate members on a level
- named sets
- New Query button / How to do it…, How to do it…, Getting ready, Getting ready, Getting ready, Getting ready, Getting ready, Getting ready, Getting ready
- New XMLA Query button / Getting ready
- N members
- best N members, isolating in set / Isolating the best N members in a set, Getting ready, How to do it..., How it works...
- top N member / The top N member is evaluated in All Periods, not in the context of the opposite query axis
- worst N members, isolating in set / Isolating the worst N members in a set, How to do it..., How it works...
- non-allocated company expenses
- allocating, to departments / Allocating the nonallocated company expenses to departments, Getting ready, How to do it..., How it works..., There's more...
- non-existing [All] level
- non-leaf calculation / Leaf and non-leaf calculations
- NonEmpty() function
- used, for optimizing MDX queries / Optimizing MDX queries using the NonEmpty() function, Getting ready, How it works…, There's more…, Common mistakes and useful tips
- about / Optimizing MDX queries using the NonEmpty() function, There's more…
- versus NON EMPTY keyword / NonEmpty() versus NON EMPTY
- NONEMPTY() function / Hints for query improvements
- NONEMPTY keyword / There's more...
- NON EMPTY keyword
- about / NonEmpty() versus NON EMPTY
- versus NonEmpty() function / NonEmpty() versus NON EMPTY
- NON EMPTY operator / Preserving empty rows
- NONEMPTY operator / How it works...
- NON EMPTY switch / There's more...
- NOT IN set logic
- implementing / Implementing the NOT IN set logic, Getting ready, How to do it…, How it works…, There's more…
- NullProcessing property / Hints for query improvements, How it works...
O
- OpenQuery
- URL / Additional information
- OpenQuery command / How it works...
- OpenRowset
- URL / Additional information
- Operating Expenses
- about / Introduction
- optimization
- URL / There's more…
- Order() function / Getting ready, How to do it…, How it works…, Testing the correctness of the result, Performing complex sorts
- Organization dimension / Displaying members without children (leaves)
P
- .PrevMember function / A simplified version of the solution
- ParallelPeriod() function
- about / Calculating the YoY (Year-over-Year) growth (parallel periods), ParallelPeriod is not a time-aware function
- used, for YoY growth calculation / Calculating parallel periods for multiple dates in a set, Getting ready, How to do it..., How it works...
- calculating, in slicer / Calculating parallel periods for multiple dates in a slicer, Getting ready, How to do it..., How it works..., There's more...
- Parent-Child group / Getting ready
- parent-child hierarchies
- members, displaying / Displaying members with data in parent-child hierarchies, Getting ready, How to do it...
- Pareto principle / Implementing the ABC analysis
- percentages
- calculating / Calculating various percentages, Getting ready, How it works..., Use cases
- periodic cycles
- used, for forecasting / Forecasting using the periodic cycles, Getting ready, How to do it..., How it works..., There's more...
- physical measure
- creating, as placeholder for MDX assignments / Creating a physical measure as a placeholder for MDX assignments, How to do it..., How it works..., Associated measure group
- PROPERTIES() function
- used, for retrieving data from attribute relationships / Using the PROPERTIES() function to retrieve data from attribute relationships, Getting ready, How to do it…, How it works…, There's more…
Q
- query-based calculations / The query-based alternative
R
- ragged hierarchies
- random hierarchy
- sample, displaying from / Displaying a sample from a random hierarchy, How to do it..., How it works...
- random values
- displaying / Displaying random values, Getting ready, How to do it..., How it works..., There's more...
- Rank() / How it works...
- Rank() function / Getting ready, How to do it…, How it works..., There's more..., The pluses and minuses of named sets, How it works...
- ranking
- rank in siblings / There's more...
- ranks
- calculating / Calculating various ranks, How to do it..., How it works...
- empty rows, preserving / Preserving empty rows
- in multidimensional sets / Ranks in multidimensional sets
- Ratio measure / How it works...
- recursion
- used, for iterating on set / Iterating on a set using recursion, Getting ready, How it works…, Earlier versions of SSAS
- using, to calculate cumulative values / Using recursion to calculate cumulative values, How to do it..., How it works..., There's more...
- recursive
- and cumulative calculations, selecting between / Choosing between recursive and cumulative calculations
- Reseller Order Frequency dimension / How it works..., How to do it...
- Reseller Orders Count measure / Associated measure group
- Reseller Sales Amount / How to do it...
- result correctness
- testing / Testing the correctness of the result
- RETURN keyword / There's more...
- Rnd() function / How it works..., How it works...
- root member
- alternative syntax / The alternative syntax for the root member
S
- $System schema / Using SSAS Dynamic Management Views (DMV) to fast-document a cube
- $system schema / How it works...
- @span parameter / There's more...
- Sales Territory dimension / Calculating various averages
- sample
- displaying, from random hierarchy / Displaying a sample from a random hierarchy, How to do it..., How it works..., There's more...
- Scope() statement / There's more..., There's more...
- scope-based solution / The scope-based solution
- SELECT statement / Using SSAS Dynamic Management Views (DMV) to fast-document a cube
- SELF flag / Second and third argument in Descendant() are optional
- SELF_AND_BEFORE flag / How it works...
- set
- best N members, isolating / Isolating the best N members in a set, Getting ready, How to do it..., How it works..., The top N member is evaluated in All Periods, not in the context of the opposite query axis, The top N member will be evaluated in the context of the slicer, Use a tuple in the third argument of the TopCount() function to overwrite the member on the slicer, Testing the correctness of the result, TopPercent() and TopSum() functions
- worst N members, isolating / Isolating the worst N members in a set, How to do it..., There's more...
- set of dates
- parameterizing / Parameters
- SetToStr function / There's more…
- siblings
- highlighting, with best value / Highlighting siblings with the best/worst values, Getting ready, How to do it..., How it works..., There's more...
- highlighting, with worst value / Highlighting siblings with the best/worst values, Getting ready, How to do it..., How it works..., There's more...
- Siblings Rank / How it works...
- similar / Using a new attribute to separate members on a level
- sorting
- SQL Server Data Tools (SSDT) / Getting ready, Getting ready
- SQL Server Profiler / Capturing MDX queries generated by SSAS frontends
- SSAS
- about / How to do it…
- history / Earlier versions of SSAS
- SSAS Dynamic Management Views
- using, to fast-document cube / Using SSAS Dynamic Management Views (DMV) to fast-document a cube, Getting ready, How to do it..., How it works..., There's more...
- using, to monitor activity / Using SSAS Dynamic Management View (DMVs) to monitor activity and usage, Getting ready, How to do it..., There's more...
- using, to monitor usage / Using SSAS Dynamic Management View (DMVs) to monitor activity and usage, Getting ready, How to do it..., There's more...
- SSAS frontends
- generated MDX queries, capturing / Capturing MDX queries generated by SSAS frontends, Getting ready, How to do it..., Alternative solution
- SSDT
- about / Introduction, There's more…
- SSMS
- about / Introduction, How to do it…
- SSRS
- about / Introduction
- string
- on filtered set approach, formatting / Format string on a filtered set approach
- string functions
- used, for todays date calculation / Calculating today's date using the string functions, Getting ready, How to do it..., How it works..., There's more...
- relative periods / Relative periods
- StrToMember() function / There's more...
- SUM() function / There's more...
- Sum() function / There's more…, There's more…, Dates in other scenarios
- Sum-Count approach
- preserving / Other specifics of average calculations
- sum-iif combination / There's more...
T
- T-SQL environments
- MDX queries, executing / Executing MDX queries in T-SQL environments, Getting ready, How to do it...
- Tail() function / How to do it...
- Time
- about / Introduction
- time-based calculations
- implementing, utility dimension used / Using a utility dimension to implement time-based calculations, Getting ready, How to do it..., How it works..., Interesting details, Other approaches
- Time Intelligence implementation / Using the ValueColumn property in the Date dimension
- Time Series algorithm / Other approaches
- todays date
- calculating, string function used / Calculating today's date using the string functions, How to do it..., How it works..., There's more...
- calculating, MemberValue function used / Calculating today's date using the MemberValue function
- calculating, attribute hierarachy used / Calculating today's date using an attribute hierarchy, How to do it..., How it works...
- TopCount() function / How to do it…, Getting ready, How to do it…, How to do it…, How it works…, Isolating the best N members in a set, How to do it..., How it works..., The top N member will be evaluated in the context of the slicer, Use a tuple in the third argument of the TopCount() function to overwrite the member on the slicer, Testing the correctness of the result, Multidimensional sets, How it works..., How to do it..., How it works..., There's more..., How to do it..., How it works..., How it works..., How it works..., How it works...
- top N member
- evaluating / The top N member is evaluated in All Periods, not in the context of the opposite query axis
- evaluating, in context of slicer / The top N member will be evaluated in the context of the slicer
- TopPercent() function / Isolating the best N members in a set, TopPercent() and TopSum() functions, How it works...
- TopSum() function / Isolating the best N members in a set, TopPercent() and TopSum() functions
- TYPED flag / There's more…
U
- UnaryOperator() function / There's more...
- UNION() function / There's more…
- Unknown / Using a new attribute to separate members on a level
- utility dimension
- using, to implement flexible display units / Using a utility dimension to implement flexible display units, Getting ready, How to do it..., Set-based approach
- using, to implement time-based calculations / Using a utility dimension to implement time-based calculations, How to do it..., How it works..., Interesting details, Other approaches
V
- ValueColumn property
- using, in Date dimension / Using the ValueColumn property in the Date dimension, See also
- Value measure / How it works...
- VBA function / Getting ready
- URL / Useful string functions
- VBA functions
- URL / Existing assemblies
- Vincent Rainardi
- URL / More information
- VISIBLE property / There's more...
W
- WHERE clause
- about / Using a WHERE clause to filter the data returned, How to do it…
- used, for filtering returned data / Using a WHERE clause to filter the data returned, How to do it…, There's more…
- Wikipedia
- URL / How it works...
- WITH clause / How to do it…, There's more…
- worst members
- identifying, for each member of another hierarchy / Identifying the best/worst members for each member of another hierarchy, How to do it..., How it works..., There's more...
- worst N members
- isolating, in set / Isolating the worst N members in a set, How to do it..., There's more...
- worst value
- child name, finding with / Finding the name of a child with the best/worst value, Getting ready, How to do it..., How it works..., There's more...
- siblings, highlighting with / Highlighting siblings with the best/worst values, Getting ready, How to do it..., How it works..., There's more...
X
- x axis
- data, inserting on / Putting data on x and y axes, Getting ready, How to do it…, How it works…
- hierarchies, inserting with cross join / Putting more hierarchies on x and y axes with cross join
Y
- y axis
- data, inserting on / Putting data on x and y axes, Getting ready, How to do it…, There's more…
- hierarchies, inserting with cross join / Putting more hierarchies on x and y axes with cross join
- Yes member / Member Yes as a default member?
- YoY
- YoY growth
- YTD
- calculating / Calculating the YTD (Year-To-Date) value, Getting ready, How to do it..., How it works..., There's more...
- Inception-To-Date calculation / Inception-To-Date calculation
- common issues, avoiding / Common problems and how to avoid them
- issues / Common problems and how to avoid them
- YTD() function
- argument, using / Using the argument in the YTD() function
- future dates / YTD() and future dates