Data wrangling, Dynamic drilldown option in S/4 Hana live data connection with CDS

Hello,

We have created a live data connection with a CDS view at backend. We are seeing a significant difference between the modeler when importing data vs live data connection.

When we are importing an excel data, below modeler screen comes. which has multiple options for data wrangling.

I have below questions related to this:

• When we are getting data through live data connection with CDS at backend, we are not getting above screen as modeler. In live data connection modeler has very few option for data wrangling. Is this possible to get same option as data import in live data connection?
• When we are trying to create a drill down report through live data connection with CDS at backend, we are not seeing any dynamic hierarchy creation option as it is available in above screenshot. Creating a hierarchy at CDS level and then using those in SAC model does not give enough flexibility to generate a story immediately. So we are trying to check the possibility to have above data wrangling option in live data connection with CDS.
• Also is there a way to trigger an email notification depending on some condition from SAC.

It will be very helpful if we get some help on above points.

Thanks,

Kuntal