How to drill down on date while working on Live Modelling?

[Kunal_Ingale_In]

I’m currently working on a live modeling exercise where I'm exposing a calculation view that is created in the CAPM application using Business Application Studio. Afterward, I fetched those views in SAP Analytics Cloud where several fields of type Date/DateTime/Timestamp in these views. However, I'm encountering an issue where I cannot utilize the drill-down option of granularity of Year-Quarter-Month in reporting.

Could you please assist me with this? I’d appreciate any guidance on how to enable drill-down functionality for these fields.

Thank you for your help!

[HakanHaslaman]

To enable drill-down for date fields in SAP Analytics Cloud, ensure the fields are recognized as "Date" data type. If not, open your model, go to "Data View", find the date field, click on "Data Type" column, change it to "Date" and save. If the fields are already "Date" but drill-down doesn't work, they may lack sufficient information.