|
11 months ago ::
Jul 25, 2012 - 12:51PM
#21
|
|
|
We are currently operating on BW 7.3. If we would like to have BW on top of HANA and at the same time we would like to continue to use the existing BW environment (rather than starting from scratch), what is involved in this (i.e. is there a migration tool-kit available)?
|
|
|
|
11 months ago ::
Jul 25, 2012 - 12:51PM
#22
|
|
|
Is HANA to be used as a database only or can it be used as a modelling tool (getting data from BW and reporting via Business Objects)? How do we decide it's usage?
HANA is a database - but if you use the standalone version of HANA (the non-BW one) you can use the modeling tools within it to create your datamodel and then attach your BI tools on top. The decision point is really if you are looking to accelarate your BW system or start with something fresh.
With HANA as Sidecar (non BW) option - would we still be able to access BW Data (for example DSO tables) ?
In that scenario you would be able to bring BW data in via the HANA data capabilities - most likely via Data Services
|
|
|
|
11 months ago ::
Jul 25, 2012 - 12:51PM
#23
|
|
|
Hi Thomas, Yes, DSOs are also improved in HANA. When converting exiting DSOs, you can either convert these automatically using the transaction RSMIGRHANADB or you can do this manually in the Data Warehousing Workbench. This migration does not require any changes to process chains, MultiProviders, queries, or data transformations. The new HANA optimized DSOs execute all data activations at the database layer, instead of the application layer. Thereby saves significant time in data loads and process chains, making data available to users much faster. Behind the scenes, HANA maintains a future image of the recently uploaded data stored is stored in a columnar table called the 'activation queue'. The current image of the current data is stored in a temporal table that contains the history, main and delta index. Finally, to avoid data replication, the change log is now kept in the calculation view instead of a physical table. Since log data does not have to be written to disk at this stage (in a traditional BW this data is written to a log table in a relational database), this new HANA approach is much faster and also consumes less storage space. So, while logically the activation process is very similar to the current relational tables in SAP BW, the technical approach is quite different. The data loads are also positively impacted. By not being constrained by I/O writes and reads to/from disks (data is loaded in-memory instead) and new optimized approach to internally generated keys (SIDs) to take advantage of the storage methods in HANA, the migrated BW system on HANA typically sees 2-3 times faster data loads overall. For many companies, this will be reason enough to make the transition to HANA. For more information on new DSO activations on HANA see Note 1646723: “BW on SAP HANA DB: SAP HANA-opt. DSO Activation Parameters”. Thanks, Berg
|
|
|
|
11 months ago ::
Jul 25, 2012 - 12:52PM
#24
|
|
|
We are currently operating on BW 7.3. If we would like to have BW on top of HANA and at the same time we would like to continue to use the existing BW environment (rather than starting from scratch), what is involved in this (i.e. is there a migration tool-kit available)?
In that scenario you would "simply" do a database migration from your existing BW database over to a HANA database. You would also need to check your hardware to make sur it is HANA-compatible.
|
|
|
|
11 months ago ::
Jul 25, 2012 - 12:53PM
#25
|
|
|
We are currently operating on BW 7.3. If we would like to have BW on top of HANA and at the same time we would like to continue to use the existing BW environment (rather than starting from scratch), what is involved in this (i.e. is there a migration tool-kit available)?
Hi Nancy, Are you moving to HANA, or do you want to keep two BW systems (one on HANA and one 'legacy')? Thanks, Berg
|
|
|
|
11 months ago ::
Jul 25, 2012 - 12:53PM
#26
|
|
|
Do you have already experience how HANA could interact with other InMemory Solutions for example APO and TM1?
|
|
|
|
11 months ago ::
Jul 25, 2012 - 12:54PM
#27
|
|
|
Thanks for joining us today. Please don't forget to refresh your browser to see the latest posts.
|
|
|
|
11 months ago ::
Jul 25, 2012 - 12:55PM
#28
|
|
|
Hi, What is the "common practice" when we use the SAP LT Replication server (the only way that can provide us real-time data on HANA): do we install this on the ECC system or do we need to install it on a separate Netweaver server? Are there other approaches for real time data loading in HANA? SBO are scheduled loads that can deliver (near) real time data. Thanks, Koen
|
|
|
|
11 months ago ::
Jul 25, 2012 - 12:55PM
#29
|
|
|
Why we need BI over HANA when we are able to do modeling in HANA?
|
|
|
|
11 months ago ::
Jul 25, 2012 - 12:55PM
#30
|
|
|
Is it possible to install Hana for personal learning? Is there a test drive? Is it better on a home server or on AWS? Thank you
|
|
|
