Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
KodandaPani_KV
Active Contributor

Hi All,


Previous Blog discussed about ADSO how to act as Standard DSO

SAP BW on HANA Advanced DSO - Part 1


now will disucss ADSO how to act as INFO CUBE.

Advanced DSO have persistent object is combination of below objects

  1. 1. Field based structure of  PSA ( filed based modeling)
  2. 2. No activation required for like WDSO (update property)
  3. 3. 3 table have (active, new, change log table ) like standard DSO (over write property)
  4. 4. Info cube model – select setting – all char are keys ( addition property)

Advanced DSO 2nd Model

Previous blog discussed about ADSO first model like standard DSO

Now will discuss about ADSO like act has Info cube

Go to the BW Modelling tools in HANA Studio -> select info area -> click on the Advanced DSO

Select the option All characteristics are key, reporting on union of inbound and active table

If you select above option ADSO like act as Info cube

After insert the info objects into ADSO like below

Here one important thing Keys option disable means all the objet like act as Keys we cannot define particular object as keys

Under setting options below options is available

We can do partitions and indexes on ADSO

Transformation mapping form data source to ADSO with only one option SUMMATION

Means it will like act as Info cube

Under Rule type we can do read records form the ADSO Model – Active data table

While designing the ADSO all the tables will generate but change log table not in used

Sample PSA data  with 3 customers

After loading Active data table records

After 2nd loading values is addition for ZIA_AMT amount key figure.


Next Blog will discuss about ADSO how to act as Write optimize DSO.


Thanks,

Phani.

7 Comments
Labels in this area