SSM and BPC - Implementation Options and Concerns
I am hoping that someone can assist with some BPC/SSM implementation queries.
Until recently, our client was intending to implement SEM-CPM and SEM-BPS. Now, our client is considering the implementation of SSM and BPC. This raises a number of questions with regards to these products and their integration with Netweaver 7.0. Kindly see my questions/comments below:
<b>1.</b> Our client intends to implement BPC 5.1 immediately and then migrate to BPC 7.0 once the integration with BW is provided for. Until BPC 7.0 becomes available, it was assumed that BPC could exchange data with SAP BW by means of a flat file export/import process. From a technical perspective, is this assumption correct? Would you recommend this approach? Are there other ways to enable this data exchange?
<b>2.</b> In order to allow for effective data exchange between BW and BPC, we will need to replicate the BW cubes in BPC and update these cubes with the required BW master and meta data. In this case, I understand that data integrity and synchronization between BW and BPC is very difficult to maintain. What are your views in this regard? What steps can be taken to improve this sychronisation process?
<b>3.</b> SAP has committed to provide BPC/BW integration next year. Considering this, do you recommend that we begin with a BPC 5.1 implementation now or do you recommend that we wait until the integration is provided in version BPC 7.0.?
<b>1.</b> Does PilotWorks exist in Unix and what data base must it use?
<b>2.</b> What is the maturity of the mapping tool used to map SAP to Pilot Works?
<b>3.</b> Is there any data that must reside in Pilot Works or can all data be centralised in BW?
<b>4.</b> Is there any workstation setup necessary to run Pilot Works off a desktop?
<b>1.</b> Even though we are still deciding which planning/balanced scorecard tool is ideal, we intend to begin immediately with the BW data modeling process. Is it reasonable to assume that the eventual decision to implement BPC or SSM will NOT have a significant impact on the data model from a functional or technical perspective? Obviously, we do not wish to build a data model that will be incompatible with BPC/SSM or that will place limitations on BPC/SSM functionality. If BPC/SSM will impact data modelling, what points should we take into consideration when preparing our data model in BW? For example, what data locking issues exist in BPC and how will this impact our BW data modelling?
I would greatly appreciate any assistance/views.