I am quite confused regarding the descendants and Tuple. Do both functions aggregate issues by some issue property which is not available as dimension or measure or to apply complex filtering criteria?
Hi @Wenhao_Zhang!
Descendants is a set function that returns all children of the current specified level down to a specified level. As a result, you can filter this set and perform other aggregate operations over the set of members.
The Descendants can be used with any dimension, not only Issues, though in Jira issues cube, this is the most popular usage.
A tuple, from another point, is an address of value in the multidimensional cube. Similarly, as in excel, you would say you need the value from, e.g., column B, row 5, you use tuples to say which measure and with what other dimension context you wish to see.
There are two presentations you might find useful about these topics:
- Understanding tuples - https://docs.eazybi.com/eazybijira/learn-more/training-videos#Trainingvideos-9.MDX:Understandingtuples(30min)
- Handling sets in calculations - https://docs.eazybi.com/eazybijira/learn-more/training-videos#Trainingvideos-10.MDX:Handlingsetsincalculatedmeasures(30min)
Lauma / support@eazybi.com
1 Like