Thursday, May 3, 2018

IBP- CPI Integration - Best Practices for Extracting Data out of IBP

Source: SAP note - 2493042

You are using SAP Cloud Platform Integration for data services to export key figure data from an IBP application. 
Please note that SAP HANA Cloud Integration(HCI) has been renamed to SAP Cloud Platform Integration(CPI)
Environment
  • Supply Chain Management (SAP SCM)
  • Integrated Business Planning (SAP IBP)
Cause
You are using SAP Cloud Platform Integration for data services to export key figure data from an IBP application.
For extracting the key figure data, a calculation scenario is used to extract the data out of IBP. A calculation scenario is a special construct in the SAP HANA database that the integration service can use to read data from an IBP application and to write to a file, or to write the data directly to the target on premise system using a web service call. Calculation scenarios are generated in the planning area of the IBP application.
While defining the Data Export Task, it becomes essential to put necessary filters and optimize the filter conditions to ensure that filter conditions are pushed down to IBP.
  • It decreases the run time of Data Export Task and optimal usage the resource/CPU/Memory consumption.
  • Minimize the impact of this task on the normal business activities of the users. 
  • It also reduces the chances of exceptions like connection reset which might lead to an open cursor IBP and in turn impact the performance of IBP.
Resolution
Kindly follow the below guidelines while designing the Data Export Task in CPI-DS.
  1. You should split the data extraction needs into multiple tasks based on different filter conditions wherever possible. You need to ensure that smaller data set is extracted from IBP for the optimal usage of resources in HANA.
  2. You should avoid the concurrent execution of the Data Export Task. Instead, you schedule the Data export task sequentially 
  3. You should always specify the exact PERIODIDn attribute based on the time level you want to extract the data, instead of selecting the generic PERIODID attribute in your data flow. Please note PERIODIDn do not refer directly to the time profile level. For your planning area PERIODIDn are mapped as follows to the time profile level.  
    • PERIODID0 Day (Lowest Time Profile Level)
    • PERIODID4 Week
    • PERIODID3 Month
    • PERIODID2 Quarter
    • PERIODID1 Year (Highest Time Profile Level)
  4. You should not use the IN/NOT IN operator, instead you can use the OR operator for filter conditions.
    • For e.g. instead of PRDID IN('X','Y') use (PRDID='X' OR PRDID='Y')
  5. You should put the filter on PERIODIDn attribute instead of TSTFR for time period filter conditions. You can give the relative filter conditions for the PERIODIDn.
    • For e.g. If you want to extract the data for the current period+12 periods in future, you can define the filter as (PERIODIDn>=0 AND PERIODIDn<=12).
    • If you only use the equal to filter, then you need to provide the absolute technical PERIODID which can be retrieved from the excel UI. The filter condition will be like PERIODIDn=1067
    • You may also use CPI DateTime functions like WEEK_IN_YEAR, MONTH to meet the different extraction requirement from the Business Perspective. You can refer to the following help document for the full list of CPI DS functions: https://hcids.hana.ondemand.com/DSoD/help/index.html#5cc2bab3d53e43c1bfdeda50c6674625.html
Product
Product or Product Version
SAP Integrated Business Planning 1702
SAP Integrated Business Planning 1705
SAP Integrated Business Planning 1708
This document is referenced by
Number
Title
2571962
2565151
2516625

Monday, April 2, 2018

First SAP IBP Certification published.

C_IBP_1711

SAP Certified Application Associate - SAP Integrated Business Planning (1711)

Delivery Methods:
Certification
Level:
Associate
Exam:
80 questions
Sample Questions:
View more
Cut Score:
64%
Duration:
180 mins
Languages:
English


Description

  • The "SAP Certified Application Associate - SAP Integrated Business Planning (1711)" certification exam verifies that the candidate possesses the basic knowledge in the area of the SAP Integrated Business Planning. This certificate proves that the candidate has a basic overall understanding within this consultant profile of the industry solutions, and can implement this knowledge practically in projects under guidance of an experienced consultant. It is recommended as an entry-level qualification to allow consultants to get acquainted with the fundamentals of SAP Integrated Business Planning.

Notes

  • To ensure success, SAP recommends combining education courses and hands-on experience to prepare for your certification exam as questions will test your ability to apply the knowledge you have gained in training.
  • You are not allowed to use any reference materials during the certification test (no access to online documentation or to any SAP system).

Topic Areas

Please see below the list of topics that may be covered within this certification and the courses that cover them. Its accuracy does not constitute a legitimate claim; SAP reserves the right to update the exam content (topics, items, weighting) at any time.

Solution Architecture > 12%

Describe the benefits of implementing SAP's Integrated Business Planning solution.



General Configuration of a Planning Area > 12%


User Interface > 12%

Use SAP Fiori to personalize the user experience.

Advanced Analytics & Reporting > 12%

Perform analytics and create reports.


Key Figures & Attributes > 12%

Create and use key figures.


Planning Operators  8% - 12%

Use Planning Operators.


Statistical Forecasting < 8%

Manage a statistical forecast.

Thursday, March 1, 2018

Skip to end of metadata
Go to start of metadata
This post is used for ongoing SAP customer communications related to SAP Integrated Business Planning major release upgrades.
For the upgrade process and communication Information, please see this link.

Upcoming Planned Upgrades

  • SAP IBP 1802: Applied to Customer Systems February through March 2018  (Planned Release to Hosting February 6, 2018)
  • SAP IBP 1805: Applied to Customer Systems May 11 through June 8, 2018  (Planned Release to Hosting May 8, 2018)
  • SAP IBP 1808: Applied to Customer Systems August 10 to August 31, 2018 (Planned Release to Hosting August 7, 2018)
  • SAP IBP 1811: Applied to Customer Systems November 9 to November 30, 2018 (Planned Release to Hosting November 6, 2018)
Future timings of upgrades are subject to change.
Published SAP Integrated Business Planning Roadmap: LINK
Upgrade Notification Guidelines
  • Upgrade notifications are sent to system administrator contacts.
  • Emails are sent from: sapcloudsupport@alerts.ondemand.com
    Tip: make sure your email software doesn’t block this email address to avoid it going to your SPAM/Junk Mail email.
  • Specific schedule of customer system updates will be communicated via email.
  • SAP provides code fix support only for "n-1" versions. ie. when a new version (version "n") is "Released to Hosting," support is dropped for the "n-2" version.
  • Upgrade notifications are only provided for major release upgrades.
  • Hot Fix Collections (HFC) and Emergency Patches (EP) are applied during the regular Contract Maintenance Period. Customer communications are not provided for HFC or EPs.

Upgrade NOTIFICATION for SAP Integrated Business Planning

Notification Purpose
As part of SAP’s continued commitment to provide you with high value applications, we will be upgrading SAP Integrated Business Planning 1711 systems to SAP Integrated Business Planning 1802.
When
  • Upgrade window: Friday 10 PM Local Data Center Time to Monday 3 AM Local Data Center Time
  • Expect your systems to be unavailable during this period. This is consistent with the contracted maintenance windows.
  • SAP will apply this upgrade from February through March 2018 (see above).
Important Information
Visibility Filters → Permission Filters
To reflect the fact that visibility filters can now also be used to control write access, the term permission filter replaces visibility filter in the IBP applications and in the documentation as of 1802.  Particularly, the Visibility Filters app has been renamed to Manage Permission Filters. Also see the  "Permission Filters" section in the What’s New in 1802.
Activation of Planning Area
  • Generally, you do not need to reactivate your planning areas when you upgrade. However, you may have to reactivate to take advantage of certain capabilities. Please review What’s New in 1802 for more information (available as of RTH, planned for Feb 6).
  • For additional activation guidance, please review the model configuration guide (available as of RTH, planned for Feb 6). If activation ends with an error you cannot solve, please create a customer incident.
Excel add-in
  • The upgrade generally does not require that you install the new version of the IBP Excel add-in. You can decide to install the new version at any time, for example, when you wish to use the new features that are available with the new add-in version. For more information, see What’s New in 1802 (available as of RTH, planned for Feb 6).
  • Customers can download and install the latest Excel add-in version on the SAP Support Portal. For more information about restrictions related to the IBP Excel add-in, please check SAP Note 2519069
  • To apply the latest version of the Excel add-in, please uninstall your current Excel add-in and re-install the new Integrated Business Planning Excel add-in. For more information on how to install the Excel add-in see Setting Up the IBP Excel Add-In (Administrators) and Setting Up the IBP Excel Add-In (Business Users).
  • For guidance on packaging and deploying the Excel add-in to end users, please see SAP Note 2114654.
  • For supported configurations and prerequisites, please see SAP Note 2135948.
  • For the IBP 1711 version of the IBP Excel add-in, you download a zip-archive from the SAP Support Portal , in which you find:
    • IBP_Add-in_NET45_x64.exe: This file installs the IBP add-in as a single ribbon for 64-bit Excel installations
    • IBP_Add-in_NET45_x86.exe: This file installs the IBP add-in as a single ribbon for 32-bit Excel installations
    • IBP_Add-In_SbS_x86: This file installs the IBP ribbon as an additional ribbon next to the EPM ribbon (side-by-side installer) for 32-bit Excel installations
    • IBP_Add-In_SbS_x64: This file installs the IBP ribbon as an additional ribbon next to the EPM ribbon (side-by-side installer) for 64-bit Excel installations
  • For the IBP 1802 version of the IBP Excel add-in, you download a zip-archive from the SAP Support Portal , in which you find:
    • IBP_Add-in_NET45_x64.exe: This file installs the IBP add-in as a single ribbon for 64-bit Excel installations
    • IBP_Add-in_NET45_x86.exe: This file installs the IBP add-in as a single ribbon for 32-bit Excel installations
    • IBP_Add-In_SbS_x86: This file installs the IBP ribbon as an additional ribbon next to the EPM ribbon (side-by-side installer) for 32-bit Excel installations
    • IBP_Add-In_SbS_x64: This file installs the IBP ribbon as an additional ribbon next to the EPM ribbon (side-by-side installer) for 64-bit Excel installations
  • For a list of available IBP Excel add-in versions and the features they contain, please see SAP Note 2394311.
Activities by end-user after the upgrade
  • End-users need to clear their browser cache.
  • SAP recommends that customers delete old transports after every upgrade.
  • Note: Transports must be transported between systems at the same version level.
Questions? Who you should contact.
  • For scheduling changes, please contact engage-ibp@sap.com or submit a customer incident.
  • For application and technical support, please use standard SAP support (support.sap.com).