WRITTEN BY: supportmymoto.com STAFF
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. Discipline primarily based construction of PSA ( filed primarily based modeling)
- 2. No activation required for like WDSO (replace property)
- 3. 3 desk have (lively, new, change log desk ) like normal DSO (over write property)
- 4. Information dice mannequin – choose setting – all char are keys ( addition property)
Superior DSO 2nd 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 2nd 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.