Hello, during implementation of clickable cells functionality there is a need to get a value of field property(type=’property’). But under drill-through view, it seems unreachable. The main goal is that in generated URL as value should be placed some property(e.g. userId) instead of member caption(e.g. userName), but at the same time a hyperlink caption should be user friendly(e.g. userName). At the pivot table, it works perfectly and was achieved through ‘customizeCell()’ function. How to do the same under drill-through view? In other words, how to derive property of field under drill-through view. Thank you in advance.
Thank you for reaching out to us.
Our team would like to kindly explain that the field marked as a
property is associated with an exact member of the hierarchy. Being opened in the drill-through, cells are not considered members; therefore, their
Cell Data object does not contain information about properties.
Our recommendation is to pass URL separately from the main data set and apply formatting using custom logic. The name of the member can be used as an identifier. Please see an example demonstrating such an approach.
urlList is used as a storage for links. The
customizeCell function uses the name of the scanned member in order to retrieve the matching URL from the object.
We sure hope it works for your case.
Do not hesitate to contact us in case additional questions occur.