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
Step 2 :
Seach for the DSO tables in HANA STUDIO as below screenshot
Search for the table:
Load data in DSO and activate dso
step 3 display the dso from SAP HANA side
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.
give ur DSO Name ex :U05dso
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.
execute
Step 6 :you can find the changelog on hana side is a “column view”
Hope its useful and you guyz will like it.
Hi Sandeep,
Good Document 🙂 🙂 , Thanks For sharing 😉 😉 .
Regards,
Giri
Thanks giri for your cheerful comments.
regards
Sandeep
Hi Sandeep,
Please note that you these conversion is became obsolete:
http://scn.sap.com/docs/DOC-41327
Regards,
Gabor
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
Hi Sandeep,
Helpful Document to convert DSO into HANA optimized DSO..Good Posting for new learners about HANA.
Regards,
Karthick
Hi karthick ,
thanks for the valuable comments
regrds
sandeep
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.
Hi Antony,
Please see the response to your question:
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
Hi Sandeep,
Very helpful to convet DSO to HANA Optimized DSO for beginners.
Thanks,
phani.
short and descriptive, thanks for sharing
Nicely explained 🙂