Drilling error with database delegated dimensions

Issue: 

　　If I enable the drill option in WEBI reports, and click on drillable dimension, getting the error below (Invalid GROUP BY constant for teradata : WIS 10901).

Root cause:

　　We used some measures which are defined as database delegated type in universe, when clicking on a field to drill down to a lower granularity which is not included in the query or SQL, the generated sql with new dimension wouldn't be able to aggregate by a fixed filtered value.

 

Resolution:

　　Basically, there are 2 options to get this issue resolved.

　　1) drag all the dimensions you may drill to potentially to the query, then the webi wouldn't generate new query when drilling down.

　　2) remove all the database delegated metrics from the query, the report will work fine if the new query is generated when drilling.

 

Conclusion: 

　　try to avoid using database delegated measures in report from performance perspective. the database delegated measures need the "second" query along with the granularities changing at report level. the database delegated measures may cause some unexpected exceptions or errors as well.