Skip to Content
Author's profile photo Sandeep a

HANA OPTIMIZED DSO

Business ex:

Company has build a large enterprise data ware house system base on the sap bw  with the invention of sap hana

you to migrate some of the your existing dso in your dataflow to SAP HANA optimized one as well as using the SAP HANA Optimized dso in newly created dataflows.

So now i will going to sharing the same approach with step by step method:

Step 1 : select your infoarea, from the context menu create a DSO

1.JPG

Step 2 :

Seach for the DSO tables in HANA STUDIO as below screenshot 

2.JPG

Search for the table:

3.JPG

Load data in DSO and activate dso

step 3 display the dso from SAP HANA side

4.JPG

5.JPG

step 4: run T-Code SE38 to migrate the DSO to a HANA Optimised DSO object.

Give the Program name:RDSRI_CONVERT_CUBE_TO_INMEMORY and click on execute.

6.JPG

give ur DSO Name ex :U05dso

7.JPG

step 5 pen dso maintenance. check setting be “in- memory otimized” and SID enabled =”SID genetretion during activation “

if not SID -enabled ;

check the setting and reactivate DSO.

8.JPG

execute

9.JPG

Step 6 :you can find the changelog on hana side is a “column view”

10.JPG

Hope its useful and you guyz will like it.

Regards
Sandeep

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Sandeep,

      Good Document 🙂 🙂 , Thanks For sharing 😉 😉 .

      Regards,
      Giri

      Author's profile photo Sandeep a
      Sandeep a
      Blog Post Author

      Thanks giri for your cheerful comments.

      regards

      Sandeep

      Author's profile photo Gabor Kovacs
      Gabor Kovacs

      Hi Sandeep,

      Please note that you these conversion is became obsolete:

      http://scn.sap.com/docs/DOC-41327

      Regards,

      Gabor

      Author's profile photo Sandeep a
      Sandeep a
      Blog Post Author

      Hi Gabor,

      Thanks for sharing updated information.

      Standard data store object (DSO) in BW 7.30 on HANA has been optimized for HANA. It has now all the performance advantages of the HANA-optimized DSO required an explicit conversion during the migration to BW-on-HANA.

      regards

      sandeep

      Author's profile photo karthick Ravichandran
      karthick Ravichandran

      Hi Sandeep,

      Helpful Document to convert  DSO into HANA optimized DSO..Good Posting for new learners about HANA.

      Regards,

      Karthick

      Author's profile photo Sandeep a
      Sandeep a
      Blog Post Author

      Hi karthick ,

      thanks for the valuable comments

      regrds

      sandeep

      Author's profile photo Antony Jerald J
      Antony Jerald J

      Hi,

      Thanks for your document shared with us 🙂  Found really useful.

      What is the Service pack required for this conversion? This conversion program is for converting standard optimized DSO's to Hana optimized DSO's right?  I'll be happy if I get some knowledge sharing from you on what's it's impact after such conversion 😉

      But I had read in many places that use of hana optimized DSO's are obsolete and standard optimized DSO's itself a hana optimized DSO's as suggested by Gabor Kovac from the document he had shared.

      Could you please clarify the same?

      Regards,

      Antony Jerald.

      Author's profile photo Gabor Kovacs
      Gabor Kovacs

      Hi Antony,

      Please see the response to your question: what is the significant and technical difference for DSO in Hana and non hana RDBMS

      Simply said: do not worry about conversion or the term 'HANA optimized'. According to SAP note 1849497 this distinction is not relevant. You simply use the DSO types (e.g. standard, write-optimized, ...) as before, with improvements relevant to SAP HANA.

      I'd recommend to upgrade to the latest SP level, or at least implement the SAP note.

      Regards,

      Gabor

      Author's profile photo Kodanda Pani KV
      Kodanda Pani KV

      Hi Sandeep,

      Very helpful to convet DSO to HANA Optimized DSO for beginners.

      Thanks,

      phani.

      Author's profile photo Manna Das
      Manna Das

      short and descriptive, thanks for sharing

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nicely explained 🙂