Key Differences & Similarities between SAP BPC Natweaver 7.5 and SAP BPC Microsoft 7.5

Follow RSS feed Like

5 Likes 11,514 Views 4 Comments

Key Differences & Similarities between SAP BPC Natweaver 7.5 and SAP BPC Microsoft 7.5:

When I started BPC after few days one question came into my mind that what are the main differences between two versions of SAP BPC. I get my answer by lot of research and study. So now I decided to put all these points into blog to facilitate new comers and those who want to migrate from one version to other.

The two versions SAP BusinessObject Planning and Consolidation NetWeaver 7.5 and SAP BusinessObjects Planning and Consolidation Version for Microsoft 7.5 share a number of features and capabilities.

Similarities:

Both versions uses familiar Microsoft office client to deliver ease of use for business user and both versions delivers automatic business process flow to provide structure to collaborative task.

BPC NetWeaver and BPC Microsoft both allow concurrency lockup, monitoring of user activity, application optimization, and a number of other common task. But there are key differences that you must me aware of.

Two versions at a glance in below figure.

Differences:

BPC Microsoft is dependant on SQL Server database and can only use sql based script logic.

BPC NetWeaver is database independent and leverages number of powerful SAP features to provide life cycle management, real time debugging and other key capabilities.

It is important to note that two versions are not interchangeable and migration from BPC Microsoft to BPC Netweaver is notautomated. To transition form one version to other require manual intervention and should be consider an implementation project depanding upan complaxity.

The below table is pointing towards key differences between two versions of SAP BusinessObject Planning and Consolidation.

Features	BPC NetWeaver 7.5	BPC Microsoft 7.5
Case sensitivity	Full case sensitivity for all objects. Full compatible with case sensitivity in NetWeaver.	Case sensitivity only to the extent applicable to Microsoft office products.
Multidimensional Expression (MDX)	Limited support to MDX syntax in dimension number formulas and script logic.	Full multidimensional expression (MDX) support.
Business Process Flow (BPF)	Enhanced Functionality in BPF in 7.5 NetWeaver compared to 7.5 Microsoft.	BPF functionality is improved in 7.5 Microsoft compared to 7.0 Microsoft but a bit lower than that in 7.5 NW.
Script logic	Limited support for script logic keywords – this point is especially important for customers migrating from Microsoft to NetWeaver Version.	Full Script logic support.
Dimensions	Dimension member can’t be renamed	Dimension member can be renamed
Books	NetWeaver does Not have books functionality.	Microsoft version provides full Book publishing functionality.
Formatting	EVDRE is NetWeaver version does not support some formatting options (e.g. styles) available in Microsoft version. All delivered templates are based on EVDRE.	Microsoft version support some extra formatting options which are not available in NetWeaver version. Not all delivered templates are based on EVDRE.
Journals	Back end validations available through SAP GUI.	Only front end validations are available. Multi header journals can be maintained.
Input schedule and reports	Data entry in all currencies is allowed. Microsoft reporting services are not available- BSPs and Webdynpro can be used to create web reports.	Data entry only in currency not calculated. Microsoft reporting services can create custom web reports.
Database & operating system	Full case sensitivity for all objects. Supports any RDBMS and operating system supported by NetWeaver. Preconfigured reports.	Case sensitivity only to the extent applicable to office Products. Can work with only Microsoft SQL Server.
Transports	Transports framework of NetWeaver can be used for moving configuration across landscape. Only complete appsets can be transported. Backup and restore functionality available.	Only backup and restore functionality is available.

Alert Moderator

4 Comments

You must be Logged on to comment or reply to a post.

Former Member

July 31, 2012 at 6:57 am

Hi, Expert.

I have a basic question.

In BPC MS, is Script Logic the only way to implement business calculation?

As I know that we can implement BADIs in BPC NW, is there any thing like BADIs can be implemented in BPC MS to perform complex business calculations?

Thanks,

Eddy
- Like(0)
- Muhammad Qayyum Ahsan Post author
  
  August 1, 2012 at 6:38 am
  
  Hi eddy,
  
  In BPC MS for complex business calculations if Script Logic (the standard syntax) did not meet your needs you could write your own stored procedure in T-SQL to achive your desired result and call that to execute whatever you needed.
  
  Thanks,
  
  Qayyum
  - Like(0)
  - Former Member
    
    August 1, 2012 at 8:38 am
    
    Thanks so much.
    Like(0)
Former Member

October 10, 2014 at 6:13 pm

Do you happen to have a similar comparison between MS and NW for BPC 10?

Please add it here if possible. Thanks.
- Like(0)

Key Differences & Similarities between SAP BPC Natweaver 7.5 and SAP BPC Microsoft 7.5

Assigned tags

Related Blog Posts

Related Questions