SAP Profitability and Performance Management Cloud Subscription with BYOD plan

[Angelou]

Hello Everyone,

To give you the most out of SAP Profitability and Performance Management Cloud (SAP PAPM Cloud), we have increased the versatility of our application by allowing you to use your own database as the foundation for your SAP PaPM Cloud subscription.

Yes, you read it right. you can now Bring Your Own Database(BYOD) to be the underlying database of your SAP PAPM Cloud subscription.

But what are the databases that we can use for the SAP PAPM Cloud subscription? To use this BYOD approach, you should have an existing:

1. Standalone SAP HANA Cloud Database (Standalone HCDB)
2. SAP Datasphere HANA Cloud Runtime Database (DSP HCDB)

Before I discuss the procedure on how you can make use of the BYOD, allow me to address some possible questions that might be helpful for you to understand more what is BYOD.

• Should my Standalone HANA Cloud Database or DSP Runtime database be of the same datacenter as with SAP PAPM Cloud?
  
  Yes, ensure that your own database is in the same datacenter.
  
  For more information, see all available datacenters on Create a Subscription.
  
  
• Can i connect multiple instance in one own Database?
  
  Yes, multiple SAP PAPM Cloud being pointed or sharing the same database is possible and even suggested specially to those customers who separated their use cases per tenant.
  
  
• I already subscribed to SAP PAPM Cloud a long time ago and has a runtime database. Is it recommended for me to migrate to own database approach?
  
  No, it depends on preferences based on use case. Some customers prefer standalone SAP PAPM Cloud, some prefer SAP PAPM Cloud BYOD.
  
  
• Can I access all data / metadata in BYOD? What can I do in the database? In BYOD, you can access and perform whatever the database initially allows.
  
  For example:
  
  In a standalone SAP HANA Cloud database you can do and access almost everything with proper authorization and role grants. I suggest that you check this carefully with your database administrator.
  
  In DSP SAP HANA Cloud database, it depends what DSP can expose on database level. Afterall this is a runtime database. 
  
  Now that I was able to provide some answers to possible question, I know you are also excited to know the procedure on how to subscribe successfully on SAP PAPM Cloud BYOD.
  
  

Note: Below is just a guide and must not be treated as a substitute of SAP PAPM Cloud Administration Guide. To ensure up-to-date information of the steps, always refer to Administration Guide for SAP Profitability and Performance Management Cloud.

Prerequisite:

• Make sure you have a Customer Account or Join the Partner Program.
• You have a created sub-account to be used to subscribe to SAP Profitability and Performance Management Cloud. See, Create a Subaccount.
• You have SAP instance managed and available in the same data center as your SAP Business Technology Platform (SAP BTP) Account where you want to subscribe to SAP PaPM Cloud. For example, it can be a DataSphere or Standalone HANA Cloud.

Procedure

Prepare Entitlements

As supplement of the blogpost for Entitlements and Default Plan Subscription. You may find the new option in Entitlement for: Plan byod, see example below .

Add the service Plan then Save Changes.

Subscription

Once the entitlement is added, you may now proceed on the Database mapping of your SAP PaPM Cloud BYOD subscription. I have separated the two(2) procedures for Standalone HCDB and DSP HCDB.

1.)  SAP PAPM Cloud subscription with Standalone HCDB

Standalone HCDB needs to map the CF organization GUID and CF space GUID. To achieve the mapping and subscription you may follow the steps below:

1a.) In the subaccount’s navigation menu, choose Instance and Subscriptions.

1b.) Choose Create.

1c.) Provide the information below in the displayed popup window:

Attribute	Value
Service	Choose “SAP Profitability and Performance Management Cloud”.
Plan	Choose “byod (Subscription)”.

1d.) Choose Next.

1e.)  You are directed to the next page. In the Choose your PLAN once again field, select the “byod” option from the dropdown list.

 1f.) The SAP HANA Cloud Database ID field is displayed. Choose I (SAP HANA Cloud Database ID: More Info) to see the CF organization GUID and the CF space GUID for both the Standard Model and the Universal Model.
Remember
As these GUIDs are required for the subsequent instance mapping steps in SAP HANA Cloud, we recommend to copy them.

1g.) Perform the steps below to map the instance in SAP HANA Cloud:

1. In the SAP HANA Cloud Instance section, choose (More)
2. Select Manage Configuration.
3. Go to Instance Mapping
4. Choose Add Mapping and provide the following:
   • Environment Instance ID: Enter the CF organization GUID you have copied in the previous step.
   • Environment Group: Enter the CF space GUID you have copied in the previous step.
5. Choose Review and Save.
   

   In the popup window that appears, mark the Apply changes without a restart option, then choose Save Changes. 
   
   

   For more information, you may see Map an SAP HANA Database to Another Environment Context.

1h.) Once mapping is done, you may now get the SAP HANA Cloud Database ID to finalize the subscription on the next step.

Note: For Standalone HANA Cloud, get instance ID from SAP HANA Cloud Central, see image below for reference:
1i.) Enter the Instance ID you just have copied in the SAP HANA Cloud Database ID field and choose Next then Create. 

After this step, subscription screen will pop up and you can close it then wait for the Processing Status to finish. Then you will be all set with SAP PaPM Cloud using your own Standalone HCDB!

2.)  SAP PAPM Cloud subscription with DSP HCDB

Subscription of SAP PAPM Cloud with DSP HCDB has a similar step from Standalone HCDB. Even so, I will still be putting here the steps in case you will be using Datasphere as your BYOD.

2a.) In the subaccount’s navigation menu, choose Instance and Subscriptions.

2b.) Choose Create.

2c.) Provide the information below in the displayed popup window:

Attribute	Value
Service	Choose “SAP Profitability and Performance Management Cloud”.
Plan	Choose “byod (Subscription)”.

2d.) Choose Next.

2e.)  You are directed to the next page. In the Choose your PLAN once again field, select the “byod” option from the dropdown list.

 2f.) The SAP HANA Cloud Database ID field is displayed. Choose I (SAP HANA Cloud Database ID: More Info) to see the CF organization GUID and the CF space GUID for both the Standard Model and the Universal Model.

Note: By design, only SAP_PAPM_UM HDI can be used here in HDI Container mapping to SAP Datasphere.

Standard Model artifacts reside in a schema(not in a container) which can be leveraged by SAP Datasphere like any other Open SQL schema.

The SAP_PAPM_SM_HDI_* container, on the other hand, is mainly for SAP Analytics Cloud (SAC) and is not intended for SAP datasphere use. DWC roles are not set up on this container. Hence, an error will arise during deployment if you attempt to deploy the space using the SAP_PAPM_SM_HDI_*container.

2g.) Customer would need also to request the mapping of HDI Container to SAP Datasphere. Information can be found via 3057059 - Mapping HDI Container to SAP Datasphere. 

2g.) Customer would need to perform the mapping of HDI Container on SAP Datasphere by following the steps below:

For more information, see Enable SAP HANA for SQL data warehousing on Your SAP Datasphere Tenant

2h.) Get the database ID of your SAP Datasphere by following the steps below:

2i.) You may now proceed on adding the SAP HANA Database Instance ID and finalize the subscription of your SAP PaPM Cloud BYOD plan with DSP HCDB.

Similar from the steps of Standalone HCDB, a subscription screen will pop up and you just need to wait for the Processing Status to finish and now you will have your SAP PaPM Cloud BYOD with DSP HCDB.

Easy right? I hope this blogpost helped you get enough information to prepare you for BYOD. Happy Modeling your use cases in SAP PAPM Cloud – whether with runtime database or on your own database. Both will still be fun!

See you in our next blogpost!

[ShubhranshuP]

Great Blog !!!

Just few Questions:

1. What are the additional Benefits of BYOD over the current 'PaPM Run-Time DB' ?

2. Under a same tenant, can i have both 'PaPM Runtime DB' and 'BYOD' subscriptions?

3. Is there is any migration path available, to move existing developments from  'PaPM Run-Time DB' to BYOD ?

[Angelou]

Hello ShubhranshuP,

Please see answers for your questions below:

1. What are the additional Benefits of BYOD over the current 'PaPM Run-Time DB' ?

BYOD and PaPM Run-time DB still works in one code-line. Meaning, absolutely no difference when we are talking about its functionalities(Join, Calculation and so on...). But if the customer is using SAP HANA Cloud or SAP Datasphere as their strategic data platform then BYOD approach will provide additional benefits in terms of seamless integration as the data is already sitting with SAP PaPM Cloud.

The only thing need to perform is to provide the proper grants / authorization to use the data for complex calculation / data process in SAP PaPM Cloud.  For more information see: Administration Guide for SAP Profitability and Performance Management Cloud.

Under Additional Configuration > Database Administration, you will be seeing the scenarios that might be useful for grants.

2. Under a same tenant, can i have both 'PaPM Runtime DB' and 'BYOD' subscriptions?

No, this is not possible.

3. Is there is any migration path available, to move existing developments from  'PaPM Run-Time DB' to BYOD ?

As of this time of my comment, there is no lean migration paths yet from HANA Cloud​
Runtime Database (Default Plan) to Standalone Database (BYOD)​

[edwiromero_s]

Hi @Angelou ,

One question, 

Would exporting an environment from a PaPM Runtime and importing it into a BYOD setup work as an accelerator?
I assume that some tasks, like recreating connections or HANA models, would still be necessary — but would this approach be feasible overall?
Or would this type of change require a complete reimplementation from scratch?

Regards

[Angelou]

Hello @edwiromero_s ,

For SAP PaPM Cloud Default Plan Standard and Universal Model, if you allow your connection to be transported to another tenant(could be your SAP PaPM Cloud BYOD plan), then the configuration of your Connections will be also carried over from the Export and Import activity.

But you have to take note that if in any case you are using Destinations, Cloud Connectors, Local SAP HANA Tables and other configuration and any other connectivity in your Connection which are outside the SAP PaPM Cloud application, it needs to be reimplemented the way you have created the above mentioned from your SAP PaPM Cloud default plan.

Best Regards,
Angelou

[LOUISLIU]

Hi @Angelou   

for steps byod as below, 

 1f.) The SAP HANA Cloud Database ID field is displayed. Choose I (SAP HANA Cloud Database ID: More Info) to see the CF organization GUID and the CF space GUID for both the Standard Model and the Universal Model.

I can click on information button, and display "SAP HANA Cloud Database must have added instance mapping ", I confuse all display CF org guid and cf space guid is not in our subaccount.  We have default have and subscription from subaccount, and automatic Instance mapping.  Do we need to take instance mapping from button information? like below.   If yes, we only have added the standard model GUID from button,  do we need add univer model from below to our instance.  I also confuse, we didn't find any GUID form button under subaccount.

• Standard Model:
• CF organization GUID: 4c47e6xxxxxxxxxxxxxxxxxxxxxxxd2cc93a4
• CF space GUID: e56baexxxxxxxxxxxxxxxxxxfcaae613
• Universal Model:
• CF organization GUID: 8d9d18e8xxxxxxxxxxxxxxxxx56e846ad
• CF space GUID: 334ab4xxxxxxxxxxxxxxxxd0c2c34dad

Thanks