Strategies for budgeting, planning, and sizing your SAP NetWeaver BW on SAP HANA project

1. Strategies for budgeting, planning, and sizing your SAP NetWeaver BW on SAP HANA project Dr. Bjarne Berg COMERIT

2. InThis Session … • Strategies for budgeting, planning, and sizing your SAP NetWeaver BW on SAP HANA project • In this timely session, attendees will get expert recommendations for properly sizing SAP NetWeaver BW on an SAP HANA system along with advice for staffing and budgeting this complex project. Through real-life examples from five companies, come away with a framework for:Sizing an SAP HANA system using top-down techniques such as rule-of-thumb ratios and the t-shirt sizing model, as well bottom-up sizing using Quick Sizer Budgeting for the hardware (based on five different technologies), software, staff, and support resources necessary for implementation and ongoing management • The prerequisites for items such as Unicode, security, BW versions, and transport requirements associated with moving an existing SAP NetWeaver BW system to SAP HANA • Take home a task-by-task milestone plan for SAP HANA implementation.

3. What We’ll Cover … • Introduction • Sizing Your HANA System • HANA Hardware Options • Pre-Steps for BW to HANA Migration • Four BW to HANA Migration Options • Staffing a HANA Migration Project • Creating a Budget for your HANA Migration Project • On-Going Support Tasks and Staff Required • Wrap-Up

4. Introduction • HANA is an in memory solution that can take large volumes of data, compress it, and store it for extremely fast access by thousands of users. • It is the ‘engine’ of the next generation of computer systems for analytics and transaction processing SAP HANA, as of 2013, can be used as the in-memory database for BusinessSuite, BW and SAP’s BusinessOne Solution

5. What We’ll Cover … • Introduction • Sizing Your HANA System • HANA Hardware Options • Pre-Steps for BW to HANA Migration • Four BW to HANA Migration Options • Staffing a HANA Migration Project • Creating a Budget for your HANA Migration Project • On-Going Support Tasks and Staff Required • Wrap-Up

6. SAP QuickSizer for HANA There are three versions of the tool for each versions of SAP HANA. The Quick Sizer for the Rapid Deployment Solutions (RDS) allows you to size for specific tools. The second Quick Sizer version is for SAP HANA on SAP NetWeaver BW The last is for those who want to use SAP HANA as a standalone platform for in-memory data (i.e., using SAP Data Services to load data to). SAP’s Quick Sizer for SAP HANA, is available at http://service.sap.com/quicksizer.

7. An Alternative SAP BW on HANA Sizing Tool SAP has released a new ABAP based tool that generates a report significantly better sizing fro SAP BW than using just the QuickSizer above. This program takes into consideration existing database compression, different table types and also include the effects of non-active data on the HANA system. The higher precision you run the estimate at the longer the program is going to run. To increase speed, you can also suppress analysis tables with less than 1 MB size. With 14 parallel processors and 8Tb data warehouse, it is not unusual to see 45-75 minutes run time.

8. SAP BW on HANA Sizing Tool Since timeouts are common when running the sizing program, you can temporarily change the parameter in rdisp/max_wprun_time to 0 in BW transaction RZ11. Finally, you estimate the growth for the system as a percentage, or as absolute growth. After you have downloaded and installed the program, and-selected the parameters above, you can go to SE38 and run SDF/HANA_BW_SIZING as a background job. The output is stored in the file you specified and the file can now be email emailed to hardware vendors for sizing input and hardware selection. This program is attached to SAP Note: 1736976 on SAP Marketplace

9. Rule-Of-Thumb Approach to Sizing HANA - Memory Memory can be estimated by taking the current system size, and running the programs in ”get_size.zip” in SAP Note 1637145 to get row and column store sizes for your system. The 50 GB is for HANA services and caches. The 1.5 is the compression expected for rowstore tables and the 4 is the compression expected for column store tables. The 2-factor refers to the space needed for run-time objects and temporary result sets in HANA. Finally the term ‘existing DB compression’ is to account for any compression already done in your system (if any). Memory = 50 GB + [ (rowstore tables footprint / 1.5) + (colstore tables footprint * 2 / 4) ] * Existing DB Compression Remember, these are quick rules-of-thumb, so don’t rely on it for finalized budgeting and hardware purchases.

10. Rule-Of-Thumb Approach to Sizing HANA - Disk The next item you need is disk space, which can be estimated by the following In this example, you need 4 x 710 GB disk for the persistence layer and about 710 GB for the logs. This equals around 3.5TB (don’t worry, disk space of this size is now almost “cheap”). The persistence layer is the disk that keeps the system secure and provides for redundancy if there are any memory failures, so it’s important not to underestimate this. Disk for persistence layer = 4 Memory Disk for the log = 1 Memory Remember, these are quick rules-of-thumb, so don’t rely on it for finalized budgeting and hardware purchases.

11. Rule-Of-Thumb Approach to Sizing HANA - CPU The CPUs are based on the number of cores that you include. For example 10 core CPUs now exist (depending on when you bought your system). If you have a single node with 4 x 10 cores, you will have 40 cores and can handle 200 active users on that hardware node, and quite a larger number of named users. CPU = 0.2 CPU cores per active user Remember, these are quick rules-of-thumb, so don’t rely on it for finalized budgeting and hardware purchases.

12. A T-Shirt Model for Sizing HANA on BW A T-shirt model is a quick way to get some basic ideas on what a system may look like. While very inaccurate for sizing, it provides basic information for those just staring considering SAP HANA The number of processors are largely driven by the number of users and usage patterns. Serious consideration should be made before buying hardware.

13. Summary of HANA Sizing Approaches Approach Quality of Estimate Effort Required T-Shirt Sizing  Sort of ‘OK” Very Low Rule-of-Thumb  Better accuracy Low SAP QuickSizer  Much better High Sizing for BW program  Excellent Moderate • Work with your preferred vendor before ordering your hardware or finalizing your budgets. SAP Note: 1514966 (SAP HANA: Sizing SAP HANA Database), SAP Note 1637145 (SAP BW on HANA: Sizing SAP HANA Database), SAP Note 1736976 (ABAP report to help with BW on HANA Sizing) .

14. What We’ll Cover … • Introduction • Sizing Your HANA System • HANA Hardware Options • Pre-Steps for BW to HANA Migration • Four BW to HANA Migration Options • Staffing a HANA Migration Project • Creating a Budget for your HANA Migration Project • On-Going Support Tasks and Staff Required • Wrap-Up

15. Hardware Options for HANA There are currently 7 different certified HANA hardware vendors with 13 different products. Some boxes can be used as single nodes with others are intended for scale-out solutions for large multi-node systems

16. A HANA Hardware Example In this box, we are see the inside of an IBM x3950 HANA system. The system basically consists of memory, disk, processors and network cards The hardware vendor will install, connect and to a health check on your system before handing it over to you. A 3-year service plan is also normally required.

17. What We’ll Cover … • Introduction • Sizing Your HANA System • HANA Hardware Options • Pre-Steps for BW to HANA Migration • Four BW to HANA Migration Options • Staffing a HANA Migration Project • Creating a Budget for your HANA Migration Project • On-Going Support Tasks and Staff Required • Wrap-Up

18. Pre-Steps – Analyze BW Readiness SAP has a checklist tool for SAP NetWeaver BW powered by HANA (thanks Marc Bernard). In this tool, SAP provided automatic check programs for both the 3.5 version and the 7.x version of BW. These are found in SAP Note: 1729988. In version 2.x of this tool, hundreds of checks are done automatically in the BW system. This includes platform checks on database and application and system information. There are even basis checks for support packs, ABAP/JAVA stacks, Unicode, BW releases, and add-ons to your system.

19. Pre-Steps – Analyze BW Readiness The idea of the checklist tool from SAP is that you run it several times throughout the project. Once before you start, then periodically as you resolve issues and upgrade requirements, and then finally when the system has been migrated to HANA. The checklist tool also has specific checks for the HANA system that can help you identify any issues before turning over the system to end users..

20. New ABAP Check Program

21. New ABAP Check Program

22. New ABAP Check Program

23. New ABAP Check Program

24. New ABAP Check Program

25. New ABAP Check Program

26. Pre-Steps – Cleaning up your BW System You can save significant amounts of work by doing a cleanup effort before you start your HANA migration or a BW upgrade project. For example, a international company had a BW system with over 108 TB, with only 36TB in the production box and the remaining data on their Near-Line Storage (NLS) solution. This cleaned BW system saved them potentially millions of dollars in hardware and HANA licensing costs. It is not unusual to reduce a BW system size by 20-30% during a clean up effort.

27. 12 Pre-Steps – Cleaning up your BW System • Clean the Persistent Staging Area (PSA) for data already loaded to DSOs • Delete the Aggregates (summary tables). They will not be needed again. • Compress the E and F tables in all InfoCubes. This will make InfoCubes much smaller. • Remove data from the statistical cubes (they starts with the technical name of0CTC_xxx). These contain performance information for the BW system running on the relational database. You can do this using the transaction RSDDSTATor the program RSDDSTAT_DATA_DELETE to help you. • Look at log files, bookmarks and unused BEx queries and templates (transaction RSZDELETE). • Remove as much as possible of the DTP temporary storage, DTP error logs, and temporary database objects. Help and programs to do this is found in SAP Notes 1139396 and 1106393.

28. 12 Pre-Steps – Cleaning up your BW System • For write-optimized DSOs that push data to reportable DSOs (LSA approach), remove data in the write- optimized DSOs. It is already available in higher level objects. • Migrate old data to Near-Line Storage (NLS) on a small server. This will still provide access to the data for the few users who infrequently need to see this old data. You will also be able to query it when BW is on HANA, but it does not need to be in-memory. • Remove data in unused DSOs, InfoCubes and files used for staging in the BW system. This include possible reorganization of masterdata text and attributes using process type in RSPC

29. 12 Pre-Steps – Cleaning up your BW System • You may also want to clean up background information stored in the table RSBATCHDATA. This table can get very big if not managed. You should also consider archiving any IDocs and clean the tRFC queues. All of this will reduce size of the HANA system and help you fit the system tables on the master node. • In SAP Note 706478, SAP provides some ideas on how to keep the basis tables from growing too fast too fast in the future, and if you are on Service Pack 23 on BW 7.0, or higher, you can also delete unwanted masterdata directly (see SAP Note: 1370848). • Finally, you can use the program RSDDCVER_DIM_UNUSED to delete any unused dimension entries in your InfoCubes to reduce the overall system size.

30. What We’ll Cover … • Introduction • Sizing Your HANA System • HANA Hardware Options • Pre-Steps for BW to HANA Migration • Four BW to HANA Migration Options • Staffing a HANA Migration Project • Creating a Budget for your HANA Migration Project • On-Going Support Tasks and Staff Required • Wrap-Up

31. Four Options for Migrating BW to HANA • Standard BW to HANA migration without Optimization • BW to HANA migration with Optimization • BW to HANA migration as a Re-implementation • Migrate a Copy of BW to HANA • There are basically 4 different approaches to migrating your BW system to SAP HANA. Each are slightly different. They may be summarized as: A major decision before you start is to determine which of these options your want to pursue. We will now take a quick look at each of them

32. 1. Standard BW to HANA migration without Optimization • In this approach you treat your BW move to HANA as a database migration project. • This means that you start with the BW system, complete the cleanup and preparations outlined above and migrate the database over to SAP HANA, but leave the application logic and data models the same. • After the migration you will have your database system as HANA, but there are no model changes to your system and there will be no impact to your queries, link to NLS, interfaces or data loads, except for substantially faster performance and some internal changes how HANA processes at the database level (i.e. data activation and compression). Functionally, you have the same system and this approach is therefore the fastest and most common.

33. 2. BW to HANA migration with Optimization • In this approach the migration also involve the optimization of data structures to take advantage of the new capabilities in HANA. This may include HANA optimized Infocubes and DSOs, and ‘HANA hints’ on data transformations to make lookups go faster. • This migration approach is a technical and functional upgrade at the same time. While the impact is minimal, significant additional performance in data loads, and query performance can be achieved. • For very large BW systems, this approach can be very time consuming and require more testing. To reduce this, you can limit the optimization to slow performing areas that need this extra boost, or do the standard upgrade first and then optimize as part of future development efforts, or when enhancing InfoCubes and DSOs. How much additional optimization effort you are willing to undertake depends on the resources available and how fast you have to complete the migration.

34. 3. BW to HANA migration as a Re-implementation • Some organizations have decided to take the BW to HANA migration as a re-implementation approachto also clean up old designs and retire lo longer used InfoCubes, InfoObjects, DTPs, reports, queries and other elements. • The steps involve setting up a new BW system on HANA parallel to the current BW system running on a relational database. Then, for key areas, the InfoCubes and DSOs are transported to the HANA box and the data loads are switched over to the new system as part of smaller projects. • Meanwhile, other InfoCubes and DSOs are running on the old BW relational database based system. Basically you are running two BW systems at the same time, without duplicating the loads to InfoProviders in both systems. While more costly, this approach allows you to keep the old system around and minimize risks of the HANA migration. The outage required is also minimal and can be done over a weekend functional area by functional area.

35. 4. Migrate a Copy of BW to HANA • This alternative approach can be used by organizations with very low risk tolerance and those who have lots of time to migrate BW to HANA. • It involves copying the production BW system, applying notes or upgrades required. Then reconciling the BW and the new BW on HANA system from a functional standpoint. (interfaces, openhubs, reports, analytics, security, and data) • When the tests are done, the process chains are run and the data is reconciled again. • To do this you need to plan carefully and run duplicated process chains to avoid impacts to the ERP system. It requires load programs to load the data to both the BW and the HANA system without impacting delta loads. But, it can be done. After testing, you can switch the users over to the new BW HANA box and de-commission the old BW.

36. Summary of BW to HANA Migration Options For many organization a migration of their BW systems to HANA (technical migration), followed by a later functional optimization is the most common approach (so far).

37. What We’ll Cover … • Introduction • Sizing Your HANA System • HANA Hardware Options • Pre-Steps for BW to HANA Migration • Four BW to HANA Migration Options • Staffing a HANA Migration Project • Creating a Budget for your HANA Migration Project • On-Going Support Tasks and Staff Required • Wrap-Up

38. Staffing a HANA Migration Project – Small Team Example System Profile Raw data size: 2.7 TB Complexity: Medium DataStores: 87 InfoCubes: 63 Queries: 409 Duration: 14 weeks Environments: 4+1 Risk aversion: Medium Other usage: IP • This assumes that the test team is dedicated for 3 weeks during the migration of QA and Prod environments • The test team from the business is already experienced users of the BW system and need minimal training • HANA Optimization of InfoCubes and DSOs are currently for SD only for this organization. This organization is using BWA and will be retiring it as part of the HANA migration

39. Staffing a HANA Migration Project – Medium Team Example System Profile Raw data size: 5.6 TB Complexity: Medium DataStores: 439 InfoCubes: 603 Queries: 1,300+ (incl. BOBJ) Duration: 18 weeks Environments: 4 Risk aversion: HIGH Other usage: None • This assumes testing of core queries in BEx and WebIntelligence is done by the business • The data reconciliation and process chain testing is done by dedicated resources in each team. • This team must be staffed with experienced resources. HANA training for team members and hardware installs must be in place prior to project start.

40. Staffing a HANA Migration Project – Very Large Team Example System Profile Raw data size: 38TB Complexity: High DataStores: 1,300+ InfoCubes: 1,720+ Queries: 2,200+ Duration: 5 mos Environments: 4 Risk aversion: HIGH Other usage: APO, IP, BPC This assumes minimal additional functional optimization

41. What We’ll Cover … • Introduction • Sizing Your HANA System • HANA Hardware Options • Pre-Steps for BW to HANA Migration Four BW to HANA Migration Options • Staffing a HANA Migration Project • Creating a Budget for your HANA Migration Project • On-Going Support Tasks and Staff Required • Wrap-Up

42. Budgeting a HANA Migration Project - Systems There are a set of items you need to budget for. From a system perspective you will need to consider: • Hardware quotes Give at least two vendors your sizing estimate and ask for quotes. • Vendor Support Make sure your hardware vendor include 3-years support in your purchase • Upgrades Plan and budget for any BW upgrades required before going to HANA (7.3) Do the pre-steps BW cleanup we outlined earlier as soon as possible and then the formal sizing effort, before requesting a hardware quote.

43. Small Example HW Quotes - Dell This is example is a quote for a smaller 128 GB Memory Box with 2 x 10 cores is based on Dell’s R910 platform for a HANA sidecar usage for less then $40,000 (including tax!) Most of the smaller HANA systems from the other vendors are similarly prices and depends on the number of boxes you buy, existing discount agreements and the size of the deals you are requesting. Expect competitive bids for larger systems and similar vendor pricing for similar capabilities

44. Mid-Size Budgeting Example HW Quotes - HP This example quote is for a mid-sized 512 GB memory box with 4 x 10 cores CPUs and 7 TB disks based on Hewlett-Packard's high-end DL-980 Box. Including all services and support agreements, this quote is only $150,000 Certified HANA vendors such as HP, IBM, Dell, Cisco, NEC, Hitachi and Fujitsu has dedicated staff to help you get a detailed quote in matter of days.

45. Large Example HW Quotes - Fujitsu This is example is a quote for a Large 1 TB Memory Box for only $105,000

46. Budgeting a HANA Migration Project - People Remember to budget for HANA training for your employees before the project starts Class schedules are found at: training.sap.com On average plan for $3,000 to $6,000 to train each team member on average plus travelling costs.

47. Budgeting a HANA Migration Project - People • Experienced HANA consultants are in very high demand, so budget $1,600 to $2,300 per day for these resources (US) • Testers with BW experience and some HANA training can be found for more normal consulting rates. • Solid hands-on migration experience with SP4 and SP5 is key for SAP BW to HANA migrations. Don’t confuse this with HANA ‘sidecar’ experience. It is very different. When staffing your HANA project, don’t schedule the start date before you get your staff. You want the best resources, not whoever is available.

48. What We’ll Cover … • Introduction • Sizing Your HANA System • HANA Hardware Options • Pre-Steps for BW to HANA Migration • Four BW to HANA Migration Options • Staffing a HANA Migration Project • Creating a Budget for your HANA Migration Project • On-Going Support Tasks and Staff Required • Wrap-Up

49. On-Going Support Tasks and Staff Required Major on-going support tasks consists of: • User and role maintenance • Security maintenance • Backup and disaster recovery • Load balancing, monitoring and hardware maintenance • Software patches and notes for HANA, BW and Components • Cleanup, NLS, Archiving, log deletions • Transports, table copies, system copies and data copies • Periodic system upgrades While most tasks are similar to the old relational database systems, the way we do this is quite different. Make sure your HANA support staff is onboarded early and trained before cut-over to production of your migration project.

50. On-Going Support Tasks and Staff Required The staffing roles required is normally: - One basis resource for system admin and monitoring for every 4-5 environments (do you need 24-hours support?) - One resource, part-time, for security, roles and access maintenance (depends on number of users) - One BW resource for monitoring loads, issues and fixes (could be part-time role in small and mid-sized organizations) The support of HANA is actually easier than the traditional basis support. Most functions are done in a single interface and many of the tasks are significantly simplified due to the inherent performance of HANA.