Possibilities of BPC package prompt's UI

There are a few options how to setup an input given by a user by a popup windows of DataMart script (DS).

First point of view whether the input fields in prompts should support browsing a BPC dimension hierarchies.

If the hierarchy browsing is not required then the prompt can be setup as s simple text field. Means PROMPT commands is a type of TEXT.

DS:

PROMPT(TEXT,%SRC_TIM%,"Enter Source TIME","%TIME%")

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,SRC_TIM%EQU%%SRC_TIM%)

 

In case the hierarchy browsing is needed the PROMPT command is a type of COPYMOVEINPUT:

DS:

PROMPT(COPYMOVEINPUT,%SRC_TIM%,%TGT_TIM%,"Select the TIME members from to","TIME")

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,SRC_TIM%EQU%%SRC_TIM%%TAB%TGT_TIM%EQU%%TGT_TIM%)

 

Disadvantage of above option that support the hierarchy browsing is that in case there are several dimension values to be entered they are placed on a new pop-up window.

In case use just prefers to have a one pop-up window with all the values following option can be used. It is again the PROMPT command type of SELECT:

DS:

PROMPT(SELECT,%SELECTION_IN%,,"Select data to copy","TIME,VERSION")

TASK(/CPMB/FX_RESTATMENT_LOGIC,REPLACEPARAM,SELECTION_IN%EQU%%SELECTION_IN%)

 

More information:

TEXT Prompt() Command

COPYMOVEINPUT Prompt() Command

SELECT Prompt() Command

How to switch BPC environment state (on/off line)?

In one of my older posts, I explained few ways how to check BPC environment state. Either it is online or offline. This time I focus on how to change the state of the BPC environment.

1. in BPC web client: In main screen of web client choose Settings button on top right corner. From there click on Environment button in a drop down Settings menu.

There is a new popup shown as next with a listing all available environments in the system. In a bottom part of the window there is a “Manage All Environments” button. Click on that one. 

There is a new screen called Manage All Environments shown as a next. Form here choose the environment which status do you want to change and clink on “Change Status” bottom on the screen toolbar. 

As a last step there is a new popup window where the environment status can be changed via radio button. 

2. in SAP BPC backend: Use t-code SE16 to browse table UJ0_PARAM_APP. Put following selection into the selection screen.

APPSET_ID = <your BPC environment tech name>

FIELD = AVAILABLEFLAG

In a VALUE column of the table there is either 0 or 1. Zero means the environment is to offline and one means it is set to online.

3. in SAP BPC backend – custom program: There can be a small ABAP program created. That changes the content of VALUE column in table UJ0_PARAM_APP. That can be done via a call of method SET_APPSET_STATUS  of class CL_UJA_APPSET.

 

More information:

How to check BPC environment state (on/off line)?

BPC clear cache in case BPC Web Client issues

BPC Web Client is a software module used by both BPC Standard and BPC Embedded. It may happen that after an upgrade of the BPC Web Client that was done standalone (not as part of BW/BPC component) the BPC client is not being displayed in web browser.

In this case a cache of the BPC application server needs to be reset. There are following two URLs that are supposed to be executed in a web browser:

 

http(s)://<server>:<port>/sap/epm/bpc/web/clearcache

http(s)://<server>:<port>/sap/epm/bpc/web/resetcachebuster

 

From BPC NW 10.0 a SICF service /default_host/sap/EPM_BPC/web is referring to link /sap/bpc/web. Thus, the URLs like below are supposed to be functioning:

http(s)://<hostname>:<port>/sap/EPM_BPC/web

http(s)://<hostname>:<port>/sap/bpc/web

 

From BPC NW 10.1 where the UI is moved to UI5 the sICF service was changed to /default_host/sap/bc/ui5_ui5/sap/bpcwebclient and is referring to link /sap/epm/bpc/web. Thus the two URLs look like:

http(s)://<server>:<port>/sap/bc/ui5_ui5/sap/bpc4webclient/resetcachebuster

How to find out BPC version via URL

Today just a quick tip on BPC version. In case you have only access to web part of BPC – web access to BPC web client there is a way to find out what version the BPC server is running on. The way I am talking about is purely via running dedicated URL. In case the particular BPC system runs on UI5 see below URLs for the BPC version 10 and 11.

 

For BPC 11.x:

http(s)://<server>:<port>/sap/bc/ui5_ui5/sap/bpc4webclient/internal_version.html

For BPC 10.x:

http(s)://<server>:<port>/sap/bc/ui5_ui5/sap/bpcwebclient/internal_version.html

Just a side note as Adobe Flash is not deprecated it is no very likely that there are still no UI5 based (but flash) BPC system still ruining. However, in case you are still on older version e.g. BPC 8 the URL should look like below. Although I can’t test it as not having an access to such a system.

http(s)://<hostname>:<port>/sap/epm/bpc/web/internal_version.html

Logging to SAP BPC Add-in with different (no SSO) user

Sometimes there is a need to logon to SAP’s BPC Add-in with different user too. Similarly like to Analysis for Office or like to other SAP applications. Briefly, what needs to be done is to bypass SSO authentication scheme. Below is quick info on how to do it.

 

Logon to SAP BPC web administration page (sometimes called BPC Web Client). The URL of this page may differ based on particular version of the BPC it can look like:

https://hostname:port/sap/bc/ui5_ui5/sap/bpc4webclient/index.html

Once you logged with your default user (in case of SSO – e.g. your WINDOWS domain user) you need to log out via menu Preferences-> Log Off:

Afterwards login with different user:

Now other user is logged in into BPC Web Client. However, our ultimate goal is to login to MS Excel’s Add-in called “SAP BusinessObjects EPM solutions, add-in for Microsoft Office”. That is a place where the BPC users are working for most of the time. To get the MS Excel opened with the different user you need to proceed in BPC Web Client’s menu called Settings->EPM Plug-in for Microsoft Office Excel.

This will open the new session in the MS Excel. You are now logged with the different user the one that was used to login to BPC Web Client. You can prove it by typing in EPM function EPMUser() in the MS Excel. That will show what user is currently logged in.

 

More information:

Logging to Analysis for Office with different (no SSO) user

Disabling SSO in SAP app

How to check BPC environment state (on/off line)?

BPC Environment is an umbrella term that groups shared metadata, such as dimensions, common configurations, and security, which becomes the basis of one or more BPC models. Normally when the users are working with the BPC the environment must be - available (it is in online state). In case there are, some changes done within its configuration the environment can be taken offline.

There are a few ways how to spot if the environment is in on/off line state.

1. in BPC web client: In Administration under Manage section there is a part related to managing of environments. Here the state of the environments is visible.

2. In EPM Add-in in MS Excel: On log-on attempt into the BPC there is an pop-up announcing that the environment is in offline state.

3. In SAP BPC backend: Via SAP GUI in table UJ0_PARAM_APP and FIELD = AVAILABLEFIELD the environment is in offline state of the value of the field is zero. It is in online state if the value is 1.

BPC Master Data tables

BPC dimensions are normally maintained via BPC web client (cockpit). There none of its technical information (e.g. tech name of objects) is shown. Because of that, it is a bit tricky to find out what database tables are storing data for the BPC dimensions. There is a small ABAP program that can serve a purpose of revealing of these database tables. It is called UJ0_GET_GEN_TABNAME and it displays following database tables for given BPC Environment and Model ID:

COMMENT

COMMENT_ARCHIVE

AUDDATA

AUDDATA_A

JOURNAL_DETAIL

JOURNAL_TRANSLATION

MEMBER_ACS

MEMBER_INF

CONTROL_SET

CONTROL

CONTROL_BD

Work Status Lock

In addition to that ABAP program, one can use table UJA_DIMENSION which holds data about BPC’s dimension data table, text table (ending with T) and corresponding BW infoobject.

EPM add-in not activated at MS Excel startup

In case EPM add-in crashes, the MS Excel automatically disables the add-in. That means it is not started automatically when the MS Excel starts, as it was normally the case before the crash. User needs to manually set it up in the MS Excel’s Options menu. Later when it is set - even the EPM add-in itself is set to be loaded it doesn’t load at the MS Excel start up.

This can be irritating as someone needs to load the add-in overtime the excel starts. It can be fixed by changing the Load Behavior (FPMXLClient.Connect LoadBehavior) in Window’s registry. The registry can be accessible via command regedit.exe – Registry Editor. The Load Behavior need to be set to value “Load at Startup”. A path in the Window’s registry is follows:

HKEY_CURRENT_USER > Software > Microsoft > Office > Excel > Addins > FPMXLClient.Connect

While you are in that particular, settings in the Window’s registry set the value to 3 – which corresponds to the Load Behavior equal to “Load at Startup”. This guarantees that the load of the EPM Add-in happens automatically at the MS Excel startup. If for some reason the settings is changed frequently, one can create simple cmd (command) or bat (batch) file on OS Windows. By this the settings in the registry can be updated e.g. at Window’s startup on ad hoc basis whenever it happens that the add-in is not set to “Load at Startup” value.

More information:

2136065 - EPM Disable Option Not Working on Excel

2415648 - Office Add-In is deactivated or unavailable

1681042 - EPM Add-In Not Getting Loaded / Installed Correctly

BPC error: system tried to insert a data record, even though a data record with the same primary key already exists

While maintaining dimension data in BPC via web BPC Administration Client there can be following message popping up:

The system tried to insert a data record, even though a data record with the same primary key already exists.

There can be many different reasons for this issue. Most likely, there is already a record with same name. E.g., one record is put in lower case whereas second one is in capitals. It is tricky to reveal what is an issue as from the BPC Administration Client the problematic record is normally not shown.

Issue can be solved using ABAP program UJA_REFRESH_DIM_CACHE. To use it just specify environment ID and dimension in which problem occurred.

More information:

2523994 - BPC NW 10.1:Error when processing dimension

2867588 - Error "The system tried to insert a data record, even though a data record with the same primary key already exists" when processing dimension in BPC Web Admin

EPM add-in error: 500 Internal server error

While using EPM add-in in MS Excel there is, a quite common error called 500 Internal server error that may distract a users. It is appearing right away when the user just choose connection. Thus, the user even is not connected to BPC server.

As per error log (which looks like this - see below) there is no obvious reason for that error.

2020-03-12 10:47:46,829|ERROR|BPCProxy|FPMXLClient.BPCProxy.Common.Wcf.InterceptorChannelFactory`1+InterceptorRequestChannel.Request||||||19|The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Negotiate'.#


2020-03-12 10:47:51,252|ERROR|BPC10Connection|FPMXLClient.Connection.RESTConnection.LoadDimensions||||||VSTA_Main|An error has occured on the server#


2020-03-12 10:47:51,342|ERROR|BPC10Connection|FPMXLClient.Connection.RESTConnection.LoadMetaData||||||VSTA_Main|An error has occured on the server#
2020-03-12 10:47:51,362|ERROR|Connection|FPMXLClient.Connection.ConnectionManager.LoadMetaData||||||VSTA_Main|An error has occured on the server#


2020-03-12 10:47:51,631|ERROR|BPCProxy|FPMXLClient.BPCProxy.Session.SessionServiceHelper.Logoff||||||VSTA_Main|<!DOCTYPE html PUBLIC"-//W3C//DTD HTML 4.01Transitional//EN"><html><head><title> Logoff Message </title><META http-equiv="Content-Type" content="text/html;charset=UTF-8"><style type="text/css"> body { font-family:tahoma,helvetica,sans-serif;color:#333333;background-color:#FFFFFF; }td { font-family:tahoma,helvetica,sans-serif;font-size:70%;color:#333333; }h1 { font-family:tahoma,helvetica,sans-serif;font-size:160%;font-weight:bold;margin-top:15px;margin-bottom:3px;color:#003366; }h2 { font-family:verdana,helvetica,sans-serif;font-size:120%;font-style:italic;font-weight:bold;margin-top:6px;margin-bottom:6px;color:#999900; }p { font-family:tahoma,helvetica,sans-serif;color:#333333;margin-top:4px;margin-bottom:4px; }ul { font-family:tahoma,helvetica,sans-serif;color:#333333;list-style-type:square;margin-top:8px;margin-bottom:8px; }li { font-family:tahoma,helvetica,sans-serif;color:#33333;margin-top:4px; }.emphasize { color:#333333;background-color:#C8E3FF;padding:5px;}.note { color:#CC6600; }a { font-family:tahoma,helvetica,sans-serif;text-decoration:underline;color:#336699; }a:visited { color:#001166; }a:hover { text-decoration:none; } </style></head><body><table cellpadding="0" cellspacing="0" border="0" width="100%"><tr><td><h1> Logoff </h1><br><h2> What has happened? </h2><p> You logged off from the system. </p></td></tr><tr><td> </td></tr><tr><td class="emphasize"><strong> Note </strong><br><ul><li> The logoff took place 20200312 at 094751 system time. </li><li> Close all the windows in your browser and delete the "temporary Internet files" (Internet Explorer) and "private data" (Firefox). <BR> Depending on your browser setting, this deletion of data can take place automatically when you close the browser. </td></tr><tr></tr><tr><td><p></ul><br/><p class="note"></p><p> HTTP 200 - OK <br><p> Your SAP Internet Communication Framework Team#


2020-03-12 10:47:51,646|ERROR|Connection|FPMXLClient.Connection.ConnectionManager.CreateConnection||||||VSTA_Main|An error has occured on the server#


2020-03-12 10:48:49,726|ERROR|BPCProxy|FPMXLClient.BPCProxy.Common.Wcf.InterceptorChannelFactory`1+InterceptorRequestChannel.Request||||||19|The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Negotiate'.#




It is worth to check if there is a dump related to this error – in backend in t-code ST22. Normally there is the ABAP dump which may indicate what is root cause of the error. In this case, there is related to error in the hierarchy. In the details of the dump there is even BPC dimension tech name and hierarchy ID listed. The details like this lead to the error. In my case, I just needed to delete broken hierarchy.

Runtime Errors         ASSERTION_FAILED

ABAP Program           CL_UJAM_HIERARCHY_STORE=======CP

Application Component  EPM-BPC-NW-ADM

Date and Time          12.03.2020 10:00:25

Short Text

    The ASSERT condition was violated.

BPC in Standard Mode or Embedded Mode - difference

There are many information on the web about different flavors of SAP BPC - Business Planning and Consolidation solution. I wanted to summarize the main differences between the two main favors plus a bit of information about the newest favors. By no means is this blog post intended to provide a comprehensive insight just basic overview and difference between the two. For much more detailed information refer to blogs listed under More information part. This blog is mostly abstract of the two mentioned blogs in there.

1. BPC Standard Model (or Classic): is a planning solution, which has its own functionality that creates and manages cubes in BW. The BPC standard is a planning (means also reporting and consolidation) solution based on BW technology mainly designed to be used by LoB.  The technical BW objects needed (like InfoObjects, InfoCubes, etc.) are generated and controlled by BPC and not directly exposed in BPC. BPC introduces BPC specific concepts different from BW concepts. Thus in the BPC standard model one has to copy over all master data, hierarchies and transaction data from BW to BPC and to align the copied data with the BPC concepts. In this sense thee BPC standard is a data mart solution. To support this the BPC standard’ implemented again a lot of existing functionality in BW although in the BPC way. The BPC Standard is sometimes called as Business Planning and Consolidation, version for SAP NetWeaver (BPC NW).

2. BPC Embedded Model: is a planning solution based around BW’s IP (Integrated Planning) functionality. The guiding principle of this approach is do not copy the data but use the BW objects and features instead. Therefore, instead of brining data over to BPC (as in the BPC standard model) it is leveraging existing data in BW. By nature, the BW is more IT driven whereas LoB drives in case of the BPC standard model.

The BPC Embedded is sometimes called as BW-IP/PAK (Planning Applications Kit).

Both of these flavors of BPC run on BW – they just use different features of the platform and have different design approaches.

With S/4HANA system there are even more options on how to run Business Planning and Consolidation solution. In S/4HANA “Simple Finance” there is Integrated Business Planning for Finance (IBPF) available. The purpose of IBPF is to leverage ERP objects for consociation. Later the IBPF was renamed to “BPC optimized for HANA” or “SAP BPC optimized for S/4HANA”.

3. BPC Optimized: It is the BPC Embedded version 10.1 installed on the BW engine present in S/4HANA Finance system. BPC Optimized is only available with S/4HANA. Its first purpose is to replace planning functions from FI/CO, which are not there anymore in S/4HANA Finance.

This favor of the BPC is also called, as Real-Time Consolidation (RTC) is a consolidation solution based on the deep integration between SAP S/4HANA and SAP Business Planning and Consolidation (SAP BPC). RTC takes both data quality and flexibility into account. It has the privileged direct access to universal journal entries, while leveraging the consolidation capabilities from SAP BPC. Unified staging and storage of finance data achieves high data quality and eliminates redundancy.

4. SAP BCS FOR SAP BW/4HANA (BCS/4HANA or BCS4HANA): although this is not directly related to BPC, the BCS (Business Consolidation) is solution to replace SEM-BCS. It is to support an automation of financial group close (consolidation). The BCS4HANA is a subset of the functionality of software components SEM-BW and FINBASIS related to consolidation.

5. SAP Business Planning and Consolidation, version for SAP BW/4HANA (SAP BPC 11.1 version for SAP BW/4HANA, BPC4HANA): both models (Standard or Embedded) can run in one system. If organization wants, the planning tool to be managed it in the centralized way -> Embedded; if the same shall be running by LoB (users) -> Standard one. That means planning and consolidation functionalities are now together (BI-IP or (BW-IP) and PAK are included in Embedded model now) so SAP calls it “Simplicity” – Simplified BPC.

More information:

Concepts compared: BPC standard and BPC embedded
Practical differences – BPC standard vs Embedded BPC (BW-IP/PAK)

How to find out backend job name for BPC Package execution

All BPC Packages during they run time they are executed by SAP Job in SAP BW backend system. Sometime it is useful to have a look at these jobs in case some issue occurred and one needs to analyze it.

In case of BPC Package investigation starts in EPM add-in in menu Data Manager -> View Status -> View Package Status. Here in column called SEQ is a generated string that uniquely identifies run time of the BPC Package.

With that, SEQ ID we go to SAP BW backend into table called UJD_STATUS (BPC: Package Status). The value of SEQ ID column we put to LOG_ID (Log-ID of a Process Chain Run) field and as a result, in JOB_NAME field we get the real SAP job name that can be further investigated in e.g. t-code SM37.

BPC add-in error: "wrong CSV Format"

Below error is pretty appearing quiet often while working with EPM add-in in MS Office. It is actually also tricky error as there may be a many things to consider that may cause this error.

Below I introduce few things that needs to be checked as they may have a root cause on this error.

1. Enhancing BPC master data info objects with new dimensions, new data in hierarchies etc. This is especially the case when errors like following can be found in BPC log:

2019-03-26 11:42:33,813|ERROR|Metadata|?.?||||||VSTA_Main| Member [ACCOUNT].[PARENTH13].[ALL ACCOUNTS] is attached to member [ACCOUNT].[PARENTH13].[1,,,,,,,,,,,] on hierarchy PARENTH13, but [ACCOUNT].[PARENTH13].[1,,,,,,,,,,,] doesn't exist# 2019-03-26

Solution: as per SAP Note 1709380, hierarchy first needs to be deleted, dimension processed, data added back to hierarchy and finally dimension to be processed again. 

If this does not help proceed with running of ABAP reports UJXO_CLEAN_DIM_CACHE and UJXO_CLEAN_TDH_DIM_CACHE according notes 2229878 and 2201768. 

Also, report UJA_REFRESH_DIM_CACHE needs to run for involved dimension as per Note 2269291. 

If this is specific to TDH dimension see Notes 2767117 and 2303454.

2. Transport related issues. In this case, there is entry in the BPC log corresponding to:

FPMXLClient.Connection.RESTConnection+HierarchyNode doesn't exist

It is caused by transport and according SAP Note 2085650 BPC dimension needs to be retransported.

3. Loading of data from flat files. See SAP Note 2411607 - "Wrong CSV Format" error or missing members in EPM client.

4. Inconsistency caused by /CPMB/A9* objects under 'unassigned nodes'. Proceed accordign Note 1927742.

5. Restore environment related issues. See Note 2162971 how to use report UJXO_CLEAN_DIM_CACHE to fix it.

How to find out who uploaded file to BPC server

EPM add-in of MS Excel offers functionality of uploading files to BPC server. These are so called Data Files of Data Manager functions. It enables to upload files from local user machine to BPC server. Uploaded files can be later used within BPC packages, transformations and so on. 

I was wondering whether there is no information about who uploaded particular file. Within e.g. Data Preview, function there is only information about when was the file modified for last time but no information who modified/uploaded it.

Luckily, there is a table available in BW backend, which holds this information. It is table UJF_DOC. While browsing for table in t-code like SE11 you need to provide environment ID first into APPSET field at selection screen; afterwards put a full path of file in Data Manager into field DOCNAME.

This will return you the user name in field LSTMOD USER that is not available on BPC’s popups in EPM add-in.

EPM-BPC error: Not possible to open report

Normally an EPM add in of MS Excel used as interface to BPC server needs to have a temporary folder with read/write access rights to properly work with the BPC reports. At first place this can be set in settings of the Excel under Save where is a property called “Default personal templates location”. However, in some organization users may not be allowed to change this setting.

In case the setting “Default personal templates location” that points to folder into which user has no write access then any attempt to open report/template/layout from BPC server does not succeed and BPC log (under EPM add-in menu More->Log) raises following message:

ERROR|FilesManagement|FPMXL.Client.OpenSaveServerManager.DownloadedFileFromServer|||||VSTA_Main|Access to path “...” is denied.#

Luckily, there is another option. The Location of default folder for save/open of local data can be changed via User Option in EPM add-in under Server Configuration there is a setting called “Default Folder for Local Open/Save”. Once this local settings point to any folder where write access is granted user it is possible to open report/template/layout from BPC server w/o any issues.

More info:

How to change the default location for opening or saving reports

Process chains having BPC processes executed only synchronously

In case of Process Chain that contains BPC related processes by default it doesn’t run a synchronously. Means if there are any parallel flows in the PC they just run one by one. Next one just starts when previous one is finished. This may look strange on first time as one would expect that parallel flow simply runs in parallel (asynchronously). But it has an explanation. As per below SAP Notes if PC triggered by BPC process chain '/CPMB/TRIGGER_BW_CHAIN' then no message is not sent out and whole PC is executed in synchronous mode.

The BPC processes that can be involved in such a PC can be anything that is dealing with objects using namespace '/CPMB/’.

To fix this and be able to run also the PCs with the BPC processes asynchronously below 1^st Note must be implemented and parameter called 'TRIGGER_BW_CHAIN_ASYNC' must be set to X in BPC customizing.

More information:

2151670 - Process chain does not send out a message if it is triggered by '/CPMB/TRIGGER_BW_CHAIN'

1938961 - Consulting: Process chain does not send out a message if executed synchronously

BPC related customizing in SPRO

Some BPC related parameters are being set up in t-code SPRO. BPC folks are very much aware of this but some BW folks do not know where to find it. So path in SPRO is SAP Customizing Implementation Guide -> Planning and Consolidation -> then e.g. Configuration Parameters -> Set Global Parameters

What is SAP planning and consolidation portfolio?

In this post, I’d like to briefly describe current SAP portfolio of planning/consolidation portfolio. Kindly notice that in this area there are multiple offerings involved. The portfolio is really evolving very fast!

With advert of SAP HANA there are significant changes into planning and consolidation applications. SAP is (was) offering different solutions for planning/consolidation apps.

In case of planning part it all started with BPS (Business Planning and Simulation) which is add-on to BW enabling BW to provide planning functions. Technically speaking this means that BW is capable to write data (so-called planning data) entered by user into its InfoProviders (e.g. cubes). This functionality is embraced so called planning layouts where user has the interface via which user can enter the data. Just a side note BPS was formerly called SEM-BPS. In version 7.0 of BW a BW-IP (formerly called BI-IP) arrived. IP stands for Integrated Planning and from technological point of view, it is based on JAVA stack of NetWeaver. Finally, when HANA took a stage some of BW-IP functionalities started to leverage HANA.

That would be all for planning part. In case of consolidation part situation is trickier as per historic background. In this space SAP has a pile of its own or acquired apps. It all started with R/3 module FI-LC called Legal Consolidation. Later LC module was renamed to EC-CS (not sure what does it stand for, maybe Enterprise Component – Consolidation System?). Usually we call it ECC based consolidation. From BW standpoint there was SEM component called BCS (Business Consolidation). This is what we called BW based consolidation. Due to SAP’s acquisition of BusinessObjects and of Outlooksoft there were more products coming into play. BOBJ had product called SAP BusinessObjects Cartesis Finance which became SAP Financial Consolidations Finance (SAP BFC) sometimes called SAP FC only. On Outlooksoft front SAP got two products which are part of Business Planning and Consolidation (EPM-BPC): BPC-MS - Microsoft Version and BPC-NW - NetWeaver Version. To sum up consolidation part there are 3 solutions: BFC and 2 flavors of BPC. HANA has changes consolidation solutions as well. In BW version 7.3 SP5 (which is version required for BW on HANA scenario) Planning Applications Kit (PAK) was introduced. The PAK enables an execution of BW-IP functionalities on HANA. After that the BPC was left as unsupported by HANA. This got changed within SAP BW 7.40 SP05. Here the BPC "unified" model was introduced. By unified it is meant there two models are integrated as enabled on HANA:

1. Business Planning and Consolidation (BPC)

2. Planning Application Kit (PAK)

For information on how to activate PAK see SAP Notes below.

Useful notes:

1637199 - Using the planning applications KIT

1637148 - BW on HANA: Activation of Planning Application Kit

1919631 - Activating the BPC-PAK unified model