In this blog, I’ll talk about several technical perspectives of aDSO.
First of all, you don’t have a BMT(BW Modeling Tool) and still want to quickly find out the technical detail of your aDSO, you can refer to table RSOADSO. Here you can find all basic information including settings and types of a certain aDSO.
There are 7 types of aDSOs in total. The classic ones can be mapped to the 7 types so we don’t count them separately. They are:
Enterprise data warehouse architecture
Planning
The type is defined by 6 different attributes. You can find the 6 attributes in table RSOADSO as 6 corresponding fields.
Attributes
Field Name Description
ACTIVATE_DATA Active Data
WRITE_CHANGELOG Write Chang Log
CUBEDELTAONLY All Chars are key
NO_AQ_DELETION Keep Inbound Data, Reporting on Union of Inbound and Active Table
PLANNING_MODE Planning Mode
DIRECT_UPDATE Direct Update
aDSO Types
In BMT, you can find out the aDSO types easily like below
How can you determine it in SAPGUI? You can use one of the below method:
1 via the XML
For example, below is a delta calculation type aDSO. Because the activateData and writeChangelog are marked as true.
2 via the table entry in RSOADSO. See below:
You can refer to below table for the mapping of table fields and the type of aDSO.
Tables
When you create an aDSO, there will be 5 DDIC tables generated by the system. This is regardless of the aDSO type. Their naming conversion is /BIC/A<tech_name>*
Not all tables are being used by the aDSO, this is determined by the type.
Below table is a mapping between aDSO type and the tables being used.
Hope you find this blog useful. I’ll keep updating it.
Okumaya devam et...
First of all, you don’t have a BMT(BW Modeling Tool) and still want to quickly find out the technical detail of your aDSO, you can refer to table RSOADSO. Here you can find all basic information including settings and types of a certain aDSO.
There are 7 types of aDSOs in total. The classic ones can be mapped to the 7 types so we don’t count them separately. They are:
Enterprise data warehouse architecture
- Data acquisition layer(Including corporate memory)
- Corporate memory – compression capabilities
- Corporate memory – reporting capabilities
Data warehouse layer – delta calculation - Data warehouse layer – data mart
Planning
- Planning on Cube-like
- Planning on Direct Update
The type is defined by 6 different attributes. You can find the 6 attributes in table RSOADSO as 6 corresponding fields.
Attributes
Field Name Description
ACTIVATE_DATA Active Data
WRITE_CHANGELOG Write Chang Log
CUBEDELTAONLY All Chars are key
NO_AQ_DELETION Keep Inbound Data, Reporting on Union of Inbound and Active Table
PLANNING_MODE Planning Mode
DIRECT_UPDATE Direct Update
aDSO Types
In BMT, you can find out the aDSO types easily like below
How can you determine it in SAPGUI? You can use one of the below method:
1 via the XML
For example, below is a delta calculation type aDSO. Because the activateData and writeChangelog are marked as true.
2 via the table entry in RSOADSO. See below:
You can refer to below table for the mapping of table fields and the type of aDSO.
Tables
When you create an aDSO, there will be 5 DDIC tables generated by the system. This is regardless of the aDSO type. Their naming conversion is /BIC/A<tech_name>*
Not all tables are being used by the aDSO, this is determined by the type.
Below table is a mapping between aDSO type and the tables being used.
Hope you find this blog useful. I’ll keep updating it.
Okumaya devam et...