How to Create Planning functions , filters etc on CDS views

[rmuhuri]

In RSPLAN , we have Aggregation levels and filters and Planning functions . We can build our own Planning functions using SQLScripts based AMDPs instead of FOX or ABAP . This makes the business logic handling remain in the HANA DB and is thus much faster. But it still writes in INFOCUBE or ADSO.

I was seeing CDS annotations #AGGREGATIONLEVEL. SAP help has

This value indicates a projection. For this kind of view, the analytic manager offers write-back functionality (planning functionality).

CDS views are built on other views or directly on the database tables . and also can be defined as type #CUBE

I dont see any example or any documentation on how to write planning functions on CDS views . Can someone point me to those resources .

[gregor_dieckmann · Accepted solution]

Hi Rajarshi,

a planning function on a CDS view is not supported.

CDS is a way to model 'analytic meta data' on top of the DB layer, in BW you have the BW objects as an analytical model. A standalone planning function on a CDS view might invalidate planning consistency logic since BW has a consistency model (planning constraints, planning buffer, LUW, ...), i.e. planning functions and data changes in general are controlled by the BW planning framework. BW would never allow changes directly on the DB layer, but only via the planning infrastructure (i.e. using the planning buffers).

You can use HANA views and aggregation level on top, but write-back then is via ABAP. BW would need a well-defined write-back interface to the basic storage below a write-enabled CDS view since BW still has to control data consistency. With BW storages (InfoCubes, advanced DSOs, etc.) BW call fully control the write-back. As you can see from BW storages may have 'delta' or 'after-image' logic, may have similar features as the BW request handling, etc. If you just need a flat table you can use a planning-enabled direct-update DSO.

Regards,

Gregor

[galeksan · Accepted solution]

Hello Gregor,

How are CDS views with Analytics.dataCategory = #AGGREGATIONLEVEL going to be positioned in the planning solutions map of SAP?

If there is no BW in the picture and we are purely talking about S/4HANA Embedded Analytics (and VDM), will it be possible to use ABAP CDS views for manual planning, for example from a BI frond-end such as Analysis for Office? This will then imply direct database write operations.

Regards,

Georgi