Skip to Content
Technical Articles

Sizing information for “SAP BPC Optimized for SAP S/4HANA” with FAQs

(Created as of release SAP S/4HANA 1809)

In this blog, the sizing information of “SAP BPC (Business Planning & Consolidation) Optimized for SAP S/4HANA” is presented with FAQs. Here is a summary of “SAP BPC Optimized for SAP S/4HANA” sizing with the Quick Sizer tool.

Some “SAP BPC Optimized for SAP S/4HANA” projects used “SAP Business Warehouse powered by SAP HANA” node in the Quick Sizer tool for initial sizing so far. For the delivered BPC contents (for example, such as InfoCube), the Quick Sizer for “SAP Business Warehouse powered by SAP HANA” node is more appropriate by comparing “SAP BW/4HANA” node. We have guided that customer can use the Quick Sizer for “SAP BW/4HANA” node, especially if ADSO (Advanced DataStore Object) is used instead of InfoCube. However “SAP Business Warehouse powered by SAP HANA” node was removed from HANA Quick Sizer with HANA Quick Sizer version 252 (golive: September 2018). Because SAP does not promote “SAP Business Warehouse powered by SAP HANA (as known as SAP BW on SAP HANA)” anymore. The product to go is “SAP BW/4HANA”.

Question is how customer can conduct “SAP BPC Optimized for SAP S/4HANA” sizing estimations without using the QuickSizer for “SAP Business Warehouse powered by SAP HANA” node.

The current available workaround for “SAP BPC Optimized for SAP S/4HANA” sizing is to use the Quick Sizer for “SAP BW/4HANA” node and “SAP S/4HANA Embedded Analytics” node. The Quick Sizer “SAP BPC BW/4HANA Standard / Planning” node is designed for SAP BPC Standard model and is not recommended for use with “SAP BPC Optimized for SAP S/4HANA” sizing estimations.

We can think of below 2 Cases.

Case 1: Customer uses the delivered BPC contents (with small extension):

In order to get an estimate for your “SAP BPC Optimized for SAP S/4HANA” system, we can use the Quick Sizer for “SAP BW/4HANA” node (only Table 1) and “SAP S/4HANA Embedded Analytics” node (Table 1) as a workaround. The resource requirements (Memory & CPU(SAPS)) for Planning functions of “SAP BPC Optimized for SAP S/4HANA” is very close to the ones of an equivalent system running on SAP BW/4HANA. The resource requirements (Memory & CPU(SAPS)) for Reporting of “SAP BPC Optimized for SAP S/4HANA” would be estimated by “SAP S/4HANA Embedded Analytics” node. By using both nodes, we can estimate the effects of planning functions and reporting with the BPC contents. There is no need for any additional estimation for the data volume. Because usually plan data volume is not that huge compared to the actual data. (See below FAQs <Q1> and <Q2>)

Case 2: Customer extends the delivered BPC contents and/or even more InfoCubes (more data volume is expected):

In this case, it may happen that the planning data may be significant compared to the actual data. It does not apply for the above Case 1 approach (usage of the QuickSizer for “SAP BW/4HANA” node (only Table 1) and “SAPS/4HANA Embedded Analytics” node (Table 1)), then additional sizing for the data volume is appropriate in this case. However, you can not estimate for this exceptional case by using Table 5 in the Quick Sizer for “SAP BW/4HANA” node. Because the Quick Sizer does not offer InfoCube in Table 5 anymore (only ADSO (Advanced DataStore Object) is available) and we would not recommend to use it at all. It is the current limitation with the Quick Sizer. If customer expects it to fall under this case, they need to order a Premium Engagement service or a consultant. (See below FAQs <Q2> and <Q3>)

Most customers expect it to fall under Case 1, so we expect Case 2 to be rare.

You need to know “SAP BPC Optimized for SAP S/4HANA” a bit more.

  • SAP BPC Optimized for SAP S/4HANA is SAP BPC 10.1 NW Embedded with the delivered BPC contents in SAP S/4HANA
  • SAP BPC Optimized for SAP S/4HANA is running on Embedded SAP BW in SAP S/4HANA
  • Embedded SAP BW is available for SAP S/4HANA but it is not intended to be an Enterprise Data Warehouse (See Embedded SAP BW -Definition and Positioning: Link)

SAP BPC Optimized for SAP S/4HANA provides the delivered BPC contents that includes Planning functions (see SAP Help Link). BPC users can input/report planning data with these contents.

 

FAQs—————————————————–

<Q1> Why we can ignore the data volume sizing if customer uses the delivered BPC contents (with small extension)? – Related to Case 1

We only need to consider SAP S/4HANA sizing which already included usage of SAP BPC as planning tool for SAP S/4HANA finance planning. Form the data volume perspective, SAP BPC generates plan data but it should be similar with old transaction code based planning. It means “SAP BPC Optimized for SAP S/4HANA” is only used as the tool in this case, it doesn’t generate ‘new’ data on the system level. As we don’t have additional sizing for financial planning in R/3, we don’t need additional sizing of the data volume for SAP S/4HANA. The expected plan data volume is small compared to the actual data that would be sourced from ACDOCA. So the data volume sizing should be covered by the actual SAP S/4HANA sizing. In general, no need to input for BPC data volume in the Quick Sizer.

<Q2> Do we need consider Memory and CPU sizing? – Related to Case 1 and 2

Yes. “SAP BPC Optimized for SAP S/4HANA” delivers the BPC contents that includes Planning functions and Workbooks (see SAP Help Link). BPC users can input/report planning data with these contents. To address planning specific activities (for example, such as planning functions and reporting) which may have an impact on overall sizing requirements, it is recommended to consider HANA runtime Memory and CPU(SAPS) by inputting the Quick Sizer for “SAP BW/4HANA” node (only Table 1) and “SAPS/4HANA Embedded Analytics” node (Table 1) as the workaround (see “How to fill in the questionnaire” in the Quick Sizer). We can estimate / measure the amount of temporary memory that is required for executing the planning functions and for reporting, and add this amount to the overall memory result. CPU requirements are implicitly derived from the overall amount of memory, so the BPC memory is included in this result.

At this moment, SAP developments (BPC, BW and Sizing experts) are discussing to create “SAP BPC Optimized for SAP S/4HANA” node under “SAP S/4HANA” sizing to overcome this workaround. We are planning to release it with HANA Quick Sizer (Q3 of 2019).

<Q3> Do we need to consider the data volume if customer extends the delivered BPC contents and/or even more InfoCubes (more data volume is expected)? – Related to Case 2

Yes. In this case, it may happen that the planning data may be significant compared to the actual data. Then separate sizing for the data volume is appropriate. However, you can not estimate for this exceptional case by using Table 5 in the Quick Sizer for “SAP BW/4HANA” node. Because the Quick Sizer does not offer data volume estimation of InfoCube in Table 5 anymore (only ADSO is available) and we would not recommend to use Table 5 at all. It is the current limitation with the Quick Sizer. But we expect this exceptional case to be rare. If customer expects it to fall under this case, they need to order a Premium Engagement service or a consultant.

At this moment, SAP developments (BPC, BW and Sizing experts) are discussing to create “SAP BPC Optimized for SAP S/4HANA” node under “SAP S/4HANA” sizing to overcome this limitation. We are planning to release it with HANA Quick Sizer (Q3 of 2019).

<Q4> Do we need to consider 20% rule of Embedded SAP BW document if we use “SAP BPC Optimized for SAP S/4HANA”? (Link)

Above figure is saying “The amount of data persisted in the Embedded SAP BW should not exceed 20 % of the overall data volume of the system”. It means Embedded SAP BW should not extensively be used as Enterprise Data Warehouse. If you have more than 20% of the data volume sitting in the Embedded SAP BW, the workload associated with this system is assumed to be mainly of analytical nature. Based on this guidance from SAP, customer thinks it is a hard limit and try to check the 20% rule somehow. However customer can not specify in the Quick Sizer which share of the data is query relevant on a per table basis. By only using the Quick Sizer, they can not compare between the amount of data in Embedded SAP BW and the overall data volume of SAP S/4HANA system. In addition, we would consider this rule as being rather “soft” (not a hard limit) and the pure DB size is not so important if nobody is performing OLAP activities on it. From our point of view, it is at the customer’s discretion to decide if they anticipated substantial load from Analytics or not. In the end it’s all about making the customer aware that the more analytical workload they expect, the more CPU resources are required. A good rule of thumb is that at ~20% of the data volume that is relevant for Analytical queries we see a break-even point. If customer uses “SAP BPC Optimized for SAP S/4HANA” with the delivered contents (with small extension), we assume that the data volume in the Embedded SAP BW is expected much less than 20% that is relevant for Analytics. Customer does not need to worry about this rule.

<Q5> How customer can conduct the data volume sizing if customer uses Table ACDOCP?

Customer can store the planning data either in InfoCube (/ERP/SFIN_R01) or in ACDOCP table. As of now, most of customers chooses in InfoCube (/ERP/SFIN_R01) but a few customers start using ACDOCP table. No matter planning data is stored in ACDOCP or InfoCube, it should be very similar in terms of data volume sizing. Either ACDOCP or InfoCube is just a table in HANA data base. If Customers use table ACDOCP with the BPC contents as the replacement of traditional CO planning functionalities, they do not need to consider data volume sizing.

<Q6> What will be coming for “SAP BPC Optimized for SAP S/4HANA” in the Quick Sizer?

At this moment, SAP developments (BPC, BW and Sizing experts) are discussing to create “SAP BPC Optimized for SAP S/4HANA” node under SAP S/4HANA sizing. As of now, some appropriate algorithms are planned to be developed and transported from the established sizing algorithms. Once new version of Quick Sizer is released, you will see “SAP BPC S/4HANA Embedded / Planning” node under “S/4HANA” in the Quick Sizer. If you use “SAP BPC S/4HANA Embedded / Planning”, the required Memory and CPU (SAPS) will be considered. Regarding data volume, you do not input data volume related values if you use “SAP BPC Optimized for SAP S/4HANA” with the delivered content (with small extension). However, If customer extended the delivered BPC content and/or even more InfoCubes (more data volume is expected), then they can not ignore the data volume. So in this exceptional case, you should input data volume values into a Table (for data volume sizing) in the Quick Sizer.

The following 2 sizing approaches are considered

1 – Sizing with the delivered BPC contents (with small extension) – In this case, input for data volume is not needed but Memory & CPU calculation is needed.

2 – Sizing with the extended content and large data volume – In this case (so-called exceptional case), input for data volume is needed and Memory & CPU calculation is needed.

New “SAP BPC Optimized for SAP S/4HANA” node will be very good news for our customers. We are planning to release it with HANA Quick Sizer (Q3 of 2019). Please note that this is still a plan and our plan may be changed without a notice. If it is released, I will inform the release by updating this blog. More information will be included in “How to fill in the questionnaire” in “SAP BPC S/4HANA Embedded / Planning” node.

Labs view

Please insert your comments if you have any.

Finally, I would like to thank experts at SAP for their tireless support, especially:

  • William Yu (BPC sizing owner)
  • Thomas Becker (BW development)
  • Nikolai Sauerwald (Sizing development)
  • Lars Rosenberger (DBS EMEA)
Be the first to leave a comment
You must be Logged on to comment or reply to a post.