BPC Plan ADSO Option: DataMart ADSO vs Standard ADO in BW/4HANA2.0

[arun_varghese]

System: BPC 11.1 Embedded on BW/4HANA 2.0

Like to understand more on the below 2 options

1)

Found in couple of blogs that the 'DataMart ADSO' with 'Planning-Enabled' option is equivalent to 'Planning On InfoCube-like'
Reference Blog: https://visualbi.com/blogs/sap/sap-bw-hana/sap-bw4hana/b4hana-1-0-vs-b4hana-2-0-adso-modelling-prope...
Also from the same blog, it says about the option "Standard ADSO with Write Change Log" option enabled which act as a Classic ADSO with Delta mechanism

Now, What would happen if for the same "Standard ADSO with Write Change Log" option, we enable 'Planning-Enabled' option too?
What would be the purpose of this option being available in the HANA system? In what scenarios, can we use it?

2)

Based on the current understanding, Delta planning like we have in BPC10.1 Embedded can't be achieved with "DataMart ADSO with Planning Enabled", as there is no delta mechanism here

So, if we need to have a PLAN ADSO with Delta mechanism, what would be the right combination?

[gregor_dieckmann]

Hi Arun,

the questions are not clear to me, what should 'delta planning' be?

In BW/4 2.0 the aDSO types were renamed. The following aDSO types support planning (i.e. the 'Planning Enabled' flag):

1. Data Mart DataStore Object (formerly called 'cube-like')
2. Direct Update DataStore Object
3. Standard DataStore Object with option Write Change Log (supported since BW/4 2.0)

The aDSO in 1 is 'insert only', i.e. any changed key figure value leads to new records with the 'delta' of the key figure value. The aDSO types in 2, 3 are not insert-only but have an insert, update, delete logic, in other words after-images of key figure values are saved in the aDSO tables. 3 in addition to 2 has a change log.

One should use aDSOs of type 1 usually for key figures with aggregation SUM, aDSOs of type 2 for key figures with 'no aggregation', e.g. prices or kinds of characteristics as key figures. Whether aDSO type 3 is useful depends on how the planning data are processed later, maybe there are some data transfer processes that can make use of the features that come with the change log.

Regards,

Gregor