When a DSO or infocube migrated to HANA db via bw on hana

[Former Member]

When a DSO or infocube migrated to HANA db via bw on hana, how does the DSO's Active data and change log table data - are exported to hana db, what i heard is, it just creates one flat table in hana db, is it true?

Never got a chance to look at the exported data on hana side, please if someone already has expertise. Can you provide details.

Thanks a lot for the helpful info.

[Former Member]

Hi,

In case of DSO, here are the technical changes :

Active table
Column table which consists of three parts for actual, history and delta data

Activation Queue 
Column based table

Change Log 
Calculation view (Result derived during run time)

In case of Info Cubes, there will be only one table created known as Fact table, no dimention table would be there.

Hope this helps.

Regards,

Vanshaj

[Former Member]

Hi ,

Please go through the following documents.

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

http://help.sap.com/saphelp_nw73/helpdata/en/32/5e81c7f25e44abb6053251c0c763f7/frameset.htm

Hope this may be useful to you.

Regards,

Swarupa.

[Former Member]

All 3 tables exist, I think of the 3 tables, the change log is a calculated view.

http://www.findsap.com/blog/2012/how-to-upgrade-standard-bw-objects-to-hana-optimized-bw-objects

[a_ahmad]

Hi,

after migration to HANA database, with just one tcode RSMIGRHANADB, all DSOs, ICs. are converted to in-memory.

e.g. if you display an IC and under settings you see 'Standard IC' and after migration then appears Subtype: SAP HANA optimized IC

from structure point of view there are no more E tables, SID tables anymore. The structure is flat; fact table directly connected to your dimensions.

- faster DSO activation , no indexes....etc.

hope this helps

Ahmad

[Former Member]

Hi Guy,

Havent done this before myself but you can find information on this concept in the following links:

SAP HANA-Optimized DataStore Object - http://help.sap.com/saphelp_nw73/helpdata/en/32/5e81c7f25e44abb6053251c0c763f7/content.htm

HANA-Optimized InfoCube - SDN - SAP

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/50066704-4173-2f10-4cb4-af3462161...

How To Delta Merge for SAP HANA and SAP NetWeaver BW ...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10681c09-6276-2f10-78b8-986c68efb...

Hope these are of some use.

Kind regards,

Danielle