Showing results for 
Search instead for 
Did you mean: 

Why we need to activate the data in Advance DSO for both InfoCube Type template in SAP Bw on HANA

Active Participant
0 Kudos

Dear Friends,

Good morning, I am confused with the statement that I had read on Some of the documents saying in BW on HANA data activation for aDSO is not required. now when I worked on BW on HANA

with following scenario

Flate File based data source ( 144.343 ) Records to my Advance DSO type as Classical DSO from Template. then Advance DSO ( Classical DSO type ) to Advance DSO ( info Cube type ) now records are agregated to 10,832 records.

but both the times I had to activate the data.

Now I dont understand that why in first case I have to activate the data when document says you dont need to activate the data. and secondly why I have to activate the data which is in type of infocube in classical BW case we were never activated the infocube data.

Please help me to understand the activation concept respect to ADSO.

your any help will be greatly appreciated.

Note: here Flate file based Data source is directly to SAP BW on HANA , I am not loading records to HANA DB structure first and then pushing them to SAP BW on HANA.

Best Regards


Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos

Hi Naim,

using the templates - like "InfoCube type" - just sets certain properties but you are still creating an ADSO and activation is required in certain cases as is indicated by the corresponding "activate data" flag of the ADSO.

If you don't need activation, then simply turn off the flag for the ADSO.



Product Management SAP HANA DW

Answers (2)

Answers (2)

0 Kudos


When all fields are key (InfoCube like aDSO), activation of data means "compression" of requests. Data is still available for reporting on new data table. Activation is not mandatory.

0 Kudos

Hi Marc,

I am very interested in how to turn off the activation flag for an aDSO cube like.

I can see in Manage - Show Settings: Activate/Compress Data = 'X'

How to update this Settings for DataStore?

Thanks and best regards.