I have a created a very simple SSAS tabular model following Kimbal's Fact/Dimension philosophy (e.g. one fact table and 2 dimension tables (date. employee). When I use the DRILLTHROUGH statement (MDX) it returns the measure granular data (as expected), however there is no dimension key data (i.e. DateID, EmployeeID etc.) that are dimensions of the underlying fact table.
Given the DRILLTHROUGH statement says:
"Unless otherwise specified, the columns returned include all granularity attributes for all dimensions related to the measure group of the specified measure, other than many-to-many dimensions"
I was expecting the Dimension keys to be displayed.
Any thoughts?
If using SSAS 2012 then the results can be modified through an VS2015 helper (note:Warning: While actions work in Tabular models, they are not officially supported by Microsoft. If you encounter a bug in how Tabular handles actions and open a support case, Microsoft may not provide support.)
If using SSAS 2017 then the results can be modified though a new feature.
Other articles on this topic: Is there a way to change the default drill through behavior?