Advanced DSO Models – Part 2

Hello All,

Earlier Weblog mentioned about ADSO methods to act as Commonplace DSO

SAP BW on HANA Superior DSO – Half 1

now will disucss ADSO methods to act as INFO CUBE.

Superior DSO have persistent object is mixture of under objects

1. 1. Discipline primarily based construction of  PSA ( filed primarily based modeling)
2. 2. No activation required for like WDSO (replace property)
3. 3. 3 desk have (lively, new, change log desk ) like normal DSO (over write property)
4. 4. Information dice mannequin – choose setting – all char are keys ( addition property)

Superior DSO 2^nd Mannequin

Earlier weblog mentioned about ADSO first mannequin like normal DSO

Now will focus on about ADSO like act has Information dice

Go to the BW Modelling instruments in HANA Studio -> choose data space -> click on on the Superior DSO

Choose the choice All traits are key, reporting on union of inbound and lively desk

If you choose above possibility ADSO like act as Information dice

After insert the information objects into ADSO like under

Right here one necessary factor Keys possibility disable means all of the objet like act as Keys we can not outline specific object as keys

Below setting choices under choices is obtainable

We will do partitions and indexes on ADSO

Transformation mapping type information supply to ADSO with just one possibility SUMMATION

Means it would like act as Information dice

Below Rule kind we will do learn data type the ADSO Mannequin – Lively information desk

Whereas designing the ADSO all of the tables will generate however change log desk not in used

Pattern PSA information  with 3 prospects

After loading Lively information desk data

After 2^nd loading values is addition for ZIA_AMT quantity key determine.

Subsequent Weblog will focus on about ADSO methods to act as Write optimize DSO.

Thanks,

Phani.