Page History
Sv translation | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||
CrossValue function is used to access Indicators from other Data Sets. Since BellaDati 2.9.2, it is also possible to access Attributes by using function such as lastValue() of firstValue(). It receives two parameters:
Following example returns Students count from Results data set.
Cross Reference with and without Drill-downWhen cross-referencing values, BellaDati does take in consideration applied drill-downs. That means both data sets need to have the same attribute (same code) and same members. To display value without drill-down, use the cross value in combination with the function withoutDrillDown. That will display same value for each member.
In some cases the members might be the same but the attribute code might be different. In that case you need to explicitelly tell BellaDati, which attribute from the referenced data set should be used. You can achieve this by specifying memberIdentifier as second parameter of crossValue functions. You need to construct you own string with memberValue.
In this example L_COUNTRY_REF is the code of attribute in referenced data set and memberValue is value of current member (name of country).
Cross Reference with FilterBellaDati also does not take in consideration filters applied throught view settings. Therefore, you need to explicitelly tell BellaDati in formula definition which filters and how do you want to use them.
Filter can be defined also directly inside the crossValue function:
Multiple conditions can be combined by using the plus sign:
Cross Reference with DateWhen filtering date, date attribute must be in format 'yyyy-MM-dd'.
filtered date can also defined inside the crossValue function:
You can find more about filters and their combinations in Filtering in Formulas. Cross-Referencing attributesSince BellaDati 2.9.2, it is also possible to access Attributes by using function operators such as lastValue() of firstValue()LASTVALUE or FIRSTVALUE.
Next Steps |
...