Sunday, February 7, 2016

1994718 - PCM Export to SAP HANA

Symptom
Export to Hana is a new feature as of SP8 for PCM 10. PCM documentation has been updated.


Environment
PCM10 SP8+
To enable the Export toHANA feature on the SAPHANA database, a sample SQL script called "PCM10HANA.sql" is provided in a directory called“HANA” within the“PCM_100_SQL” folder provided in the support package ZIP file. This sample script must be executed on theHANA instance you wish to export model data to. The script creates a schema/catalog called“EPM_PCM” and creates suitable column tables within this schema to hold exported results from SAPBusinessObjects Profitability and Cost Management, as well as views that make viewing the results more meaningful. These tables and views are documented in section "Export to HANA: Tables and Views" of the "SAP BusinessObjects Profitability and Cost Management Modeling User Guide".


Cause
Model Builder users can now export model parent/child structure, export IDs, and results to an SAP HANA database for Profitability and Bill of Materials model types. 


Resolution
Once Enabled on Hana, the user selects the Hana export from within the standard PCM model builder Export interface. The user interaction is similar to other PCM exports, including the ability to save setting to an .ESP file. The user will have to input
i)       Host name
ii)      HANA instance
iii)     HANA username and password
iv)     HANA catalog to export to
A thorough read of the documentation listed in the "See Also" is suggested.


See Also
For more information on the "Export to HANA" feature, see the new "Export to HANA" section in the "SAP BusinessObjects Profitability and Cost Management Modeling User Guide".
The following documentation have updates regarding Export to Hana for PCM:
SAP BusinessObjects Profitability and Cost Management 10.0 Support Package 08 pcm10_sp08_fixedissues.pdf Page 6
SAP BusinessObjects Profitability and Cost Management Installation Guide pcm_10_installation_en.pdf Section 5.2.3
SAP BusinessObjects Profitability and Cost Management Modeling User Guide pcm_10_modelbuilder_en.pdf Section 10.5
Download all PCM Documentation here: http://help.sap.com/bopcm
1994700 - PCM Export to HANA locks up PCM


Keywords
jmhiv, epm-pcm, PCM, profit, profitability and cost management



Header Data

Released On 20.03.2014 18:22:41
Release Status Released to Customer
Component EPM-PCM Profitability and Cost Management, EPO, PP, AA, Metify
Priority Normal
Category How To

No comments:

Post a Comment