Hi,
I have a report in which for some dimensions crossdrill is enabled. But, when the user drills, we want to display only the leave elements for some specific dimensions. Is it possible?
Hi Ali,
It might be possible but I’m not sure that this makes any sense! When you do a cross-drill the purpose is to decompose the starting number along another dimension or hierarchy that is currently in the filter (or not used). Therefore the first point should always be a value that is the same as the starting value and then you can drill down further.
The cross-drill always starts from the selected C element if the drilling hierarchy is on filter or else Apliqo will take the collection of root elements for the hierarchy if no setting service value is available.
If you want to go directly to the collection of all leaf elements behind the starting value then I think a standard TM1 drill-through to a cube view is the better solution.