Drill down to detail to obtain the desired information.

Drilling to details of a multi-dimensional dataset is an attractive feature. At first, I felt very strange when I learned that the detailed information obtained by drilling can only be dimension-related fields, but fields not associated with dimensions in fact tables cannot be drilled. Later, I was instructed by the experts to treat the details in the fact table as a dimension attribute. In fact, I am still confused about this sentence. However, in an experiment, we found that if the fact table itself is processed as a dimension table, when drilling is established, the fields in these fact tables can be drilled out as attributes in a dimension and as an available column for drill details.

This may require the aggregation of complex data, but it can still be retrieved.