Skip to Content
1

How to upgrade EPM SP's with Analysis for Office Plug-In

Nov 08, 2016 at 09:45 PM

802

avatar image
Former Member

We currently use EPM SP21 to connect to our NetWeaver installation of BPC. The EPM is remotely deployed to the users’ PC’s that have Office 2013. I understand that for Office 2016, the EPM and Data-Manager tabs are available with Analysis for Office 2.2 or 2.3.

Can someone help me understand:

1) If the EPM Add-in no longer needs to be deployed separately to the user PC’s, since it will be part of Analysis for Office, and

2) If the EPM does not need to be deployed separately, what’s the process to apply different EPM service packs with AO e.g. if we need to upgrade from , say, SP25 to SP26.

Regards,

Oma C

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vadim Kalinin Nov 09, 2016 at 10:19 PM
1

If you are using BPC NW standard (not embedded) you have to use EPM Add-In, not Analysis for Office!

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 09, 2016 at 06:59 AM
0

Hi Oma,

I understand that for Office 2016, the EPM and Data-Manager tabs are available with Analysis for Office 2.2 or 2.3. - Where is this mentioned??

You can install separately EPM ADD-In on office 2016! Analysis for Office with EPM is used mostly in the cases of BW IP Planning or BPC Embedded!

Check this....https://archive.sap.com/discussions/thread/3850361

Regards,

JP

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi JP,

- Where is this mentioned?? My colleague in our BW team uses the Analysis for Office plug-in installed, and it displays the Analysis, EPM and Data Manager tabs. The BW team only uses the Analysis tab, so I'm doing a discovery of any restrictions/limitaions of AO before initiating an EPM upgrade project.


I do know that the Add-in can be installed separately. See this blog.
https://www.column5.com/blog/epm-vs-analysis-office It states that "the EPM tab and the Data Manager tab in SAP convergence client 2.2 are exactly the same as the stand-alone EPM Add-In except that they cannot be used in MS Word."

The discussion thread you provided doesn't answer my questions. You mentioned that AO with EPM is used "mostly" for BW IP Planning or BPC Embedded. This is not clear to me. Are you saying that the EPM and Data Manager tabs in the Analysis for Office plug-in are only compatible with BPC Embedded? Pls clarify. The blog link above says differently, and the information in the SAP PAM is very sparse.


Thank you,

Oma C

0
Former Member
Former Member

Oma,

You are highly confused right now......or not completely understanding the blogs! One question are you using BPC Standard or Embedded version?? Then as Vadim also suggested... For Standard use only EPM and for Embedded you use Analysis. Its not a question of compatibility but the usages of these Add-ins with different versions.....Read on this blog

https://blogs.sap.com/2016/08/10/bpc-embedded-model-important-information-for-the-excel-frontend/

In my previous answer I had provided the link....just to answer that EPM add-in can be installed on Office 2016, which was your first concern.

Hope your clear with this...

Regards,

JP

0
Former Member
Former Member

Thanks for your feedback JP and Vadim.

Indeed I’m confused that’s why I’m asking for help, which I appreciate.Yes we use EPM Standard on Netweaver on Hana db, and currently use the stand-alone EPM. I was aware that the Analysis Plug-In cannot be used for BPC standard.

My confusion started when I began investigating the new convergence client that has both Analysis and EPM combined.The following explanation was provided in the blog I provided:

“the EPM Add-In is being replaced by the EPM Plug-In which is a part of the new Analysis Office Add-In which also contains a Plug-In called Analysis. I hope that is clear.”

In any event, after browsing through the link you provided and a few other bogs, I think I’m a little clearer now. I plan to do some testing on the EPM plug-in in the convergence client….which I’m hoping will behave the same the stand-alone EPM that I’m used to. If not, I'll revert to the stand-alone.

Thanks again.

Oma C

1
Vadim Kalinin Nov 11, 2016 at 07:26 AM
0

I am using EPM SP26 patch 3 with MS Office 2016 without issues!

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Good to know Vadim - thanks.

0
avatar image
Former Member Nov 24, 2016 at 06:29 PM
0


I've tested the EPM Plug-in that comes with the Analysis for Office 2.3 Add-In on our Standard BPC models. I've not encountered any issues to date. (I did find a few bugs in the A.O. 2.2 Add-In)

So the installer for Analysis for Office can be used to install the EPM for Standard Models!

See this consuting note https://launchpad.support.sap.com/#/notes/2312162

I hope this clarifies for anyone interested.

Cheers.


Oma C

Show 12 Share
10 |10000 characters needed characters left characters exceeded

As far as I remember VBA code developed for EPM will not work with AO! Different initialization...

I see no reasons to use AO with standard models!

0
Former Member
Vadim Kalinin

Vadim, the VB scripts were failing in 2.2 but they executed successfully in 2.3 I'll share my findings if I encounter any future issues with 2.3. Granted, our VB scripts are not complex.

0
Former Member
Vadim Kalinin

Vadim, When connected to a BPC Standard model, the EPM behaves as the normal standard EPM Add-in and so the VBA works with AO having EPM Plug in but if connected to a BPC Embedded model or BW INA Connection then the VBA code required is different. Just tested!

0
Former Member

Its the note provided in my previous reply link! Some correction.....so the AO installer can be used to install EPM for standard models! - NO! By default with AO, EPM Plug in is provided! and this EPM Plug in behaves differently when linked to a Standard model and when Linked to a Embedded model! Since you are using the Standard model..it will behave as a normal EPM Add-In! But if in future you have to upgrade the EPM only then you will be unable to do so...as it is combined with AO. You will have to upgrade your AO completely!

Since SAP also recommends to use only EPM addin for Standard....I would stand by that! Better than complicating things!

0
Former Member
Former Member

1)

Since you're questioning an insignificant point, the AO plug-in and EPM Plug-In CAN be installed separately (or together) as there's a selection available in the AO Add-In install package:

2)

"Since SAP also recommends to use only EPM add-in for Standard....I would stand by that! Better than complicating things!"

The following is a direct quote from the note on the AO EPM Plug-in:

"For any BPC standard model, SAP recommends to use EPM plug-in."

So both the stand-alone EPM Add-in, and the AO EPM plug-in can be used with standard models.

I suggest you differentiate between the AO EPM Plug-In that's part of the AO Add-In, and the stand-alone EPM Add-In to keep you from confusing yourself and everyone else.

This discussion is closed as I find it unprofessional that you don’t publish your name.

auxwo.png (202.8 kB)
0

I am slightly lost...

If I read the Administrator Guide for AO2.3: http://service.sap.com/~sapidb/012002523100014783042016E/23SP2_aaoffice_admin_en.pdf

I can see (page 7):

...

1.4 Introduction to the BusinessObjects Planning and Consolidation Plug-in (BPC plug-in)

...

The plug-in supports only SAP BusinessObjects Planning and Consolidation 10.1 Support Package 10, version for SAP NetWeaver or higher.

To my mind it's too restrictive compared to standalone EPM AddIn

0
Former Member
Vadim Kalinin

Vadim,

I found that AO 2.3 is close to stand-alone EPM SP26. (see note 1518359 for details)
EPM SP26 requires BPC SP10 (note 2103585)

So it appears that the minimum system requirements for AO 2.3 is similar to it's stand-alone EPM equivalent.

I use Netweaver so I cannot comment on other restrictions.

0

Sorry, but incorrect!

Not:

EPM SP26 requires BPC SP10 (note 2103585)

But:

BPC SP10 requires EPM SP26 (note 2103585)

Do you see the difference?

Also "I found that AO 2.3 is close to stand-alone EPM SP26. (see note 1518359 for details)"

In the note only corrections are mentioned, not the compatibility with core BPC SP's

0
Former Member
Vadim Kalinin
  1. Thanks for clarifying on how to interpret and express the EPM/BPC SP pairing - appreciated.

2. If you're still interested in the stand-alone vs EPM comparisons, I contacted SAP and this is their guidance regarding note 1518359:

"a) Reference in the note to see the EPM Add-in version included.

- Example:
Analysis Office 2.3 SP1 contains the EPM Add-in SP26 code.



b) If no reference is made for the EPM Add-in version then it will contain the same code as the previous update.


- Example:
Analysis Office 2.2 SP2 contains the EPM Add-in SP26 code therefore any release between that version and the AO 2.3 SP1 will include the EPM Add-in SP25 code for the EPM plugin."

Personally, I only use it as a guide since they're separate install packages.

Cheers.

0
Former Member
Former Member

Looks like you are not getting to the points explained and taking it to another level by taking it to a personal level!

Publishing or not publishing my name is entirely my decision and not yours! If I was so unprofessional as you say....I wouldn't have been so patient with you and answered back!

0
Former Member
Former Member

Priyanka or Vadim,

We're currently running AO2.3 on MS365 (BPC Standard) and encountering some inconsistences which were not issues with the EPM Add-in. Just looking for your guidance or recommendation; if we're staying on BPC standard for the near future should we continue with the AO (EPM plugin)? Or revert back to the separate packaging of Analysis and EPM?

0
Show more comments