Page History
...
When cross-referencing values, BellaDati does not take in consideration applied drill-downs. It is possible that it . 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. Therefore, .
Code Block |
---|
withoutDrillDown() {
crossValue('CROSSVALUETEST2.CROSSVALUETEST2', 'M_GDP')}
|
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 member is currently being processedattribute from the referenced data set should be used.
You can achieve this by inserting specifying memberIdentifier as second parameter of crossValue functions. You need to construct you own string with memberValue.
Code Block |
---|
crossValue('CUBE_CRAFT_COUNT_HOURS.CRAFT_COUNT_HOURS_', memberIdentifier(), 'M_HOURS'); CROSSVALUETEST2.CROSSVALUETEST2', '[L_COUNTRY_REF="'+memberValue()+'"]','M_GDP') |
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).
Observe bellow the differences between indicators without and with memberIdentifier inserted. Notice also return value of the function in third column.
Info |
---|
This will also automatically handle drill-down paths. |
...
Cross Reference with Filter
...