Abstract
It is a common requirement to want to extract a subset of the data in a cube depending on whether it meets certain criteria. For instance, you may want to identify any periods in which the sales of many products fell, compared with the sales for the previous period. What we want here is a ratio: we want to take a count of products whose sales fell (when compared to the last period) and divide that by the count of all products. The count of all products with falling sales is a subset of the count of all products and in order to resolve this, MDX has a Filter function which is used to identify subsets of data.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2002 Mark Whitehorn
About this chapter
Cite this chapter
Whitehorn, M., Zare, R., Pasumansky, M. (2002). Filters. In: Fast Track to MDX. Springer, London. https://doi.org/10.1007/1-84628-182-2_9
Download citation
DOI: https://doi.org/10.1007/1-84628-182-2_9
Publisher Name: Springer, London
Print ISBN: 978-1-84628-174-7
Online ISBN: 978-1-84628-182-2
eBook Packages: Computer ScienceComputer Science (R0)