|Available in: Logi Info|| Source code name: XolapQueryDrilldown||Introduced in: v10.0.31|
A XolapQuery drilldown indicates a level of a XolapQuery dimension that will be expanded to show its child values. Each dimension shows the "All" level by default. A drilldown element causes a level of child values to be added to the report. The parent level of a drilldown can be included if desired but is not necessary.
For example, a drilldown with a value of [Customers].[All Customers].[USA].[California] would cause the report to show all cities in California, whether there is a drilldown for states in USA or not.
To define a drilldown on a second or lower dimension, separate each position with an asterisk, for example:
[Product].[All Products]*[Customers].[All Customers].[USA]