Question Re: BPC 10.1 Embedded (1511 S4/HANA) BPF - Cannot Find EPM Workbook In Workspace in Financial Management Q&A

BPC 10.1 Embedded (1511 S4/HANA) BPF - Cannot Find EPM Workbook In Workspace

Former Member — Thu, 01 Sep 2016 21:20:06 GMT

Hello all,

I am working with BPC For S/4HANA Finance (1511 On Premise FPS V1 install).

I am attempting to create a BPF for activities and link my EPM workbooks to particular steps of the activities via hyperlinks.

Create BPF Process Instance

Create Workspace

Add Hyperlink

Target Action->Microsoft Excel->Browse

Once I go to browse and I see folders for (Public, Private and Team) there are NO files available to select.

However when I go to Excel and via the EPM Add-In, within that model I have my EPM saved files in the public folder.

Is there some setting I have to change or have I incorrectly set something up? I haven't paid too much attention to the performer/reviewer, driving dimension and other parts of the BPF as I assume (as with Standard BPC) this shouldn't affect me seeing workbooks in the model.

Please see the comparison between what I see on my EPM Add-In vs. the BPF screen in the workspace area.

Please advise, thanks.

Re: BPC 10.1 Embedded (1511 S4/HANA) BPF - Cannot Find EPM Workbook In Workspace

lucas_costa3 — Fri, 02 Sep 2016 02:04:15 GMT

Go to SPRO --> Planning & Consolidation --> Configuration Parameters --> Set Environment Parameters

You should have the following parameter:

DEFAULT_EXTENSIONS

Check if is set with the value:

XLS,XLT,DOC,DOT,PPT,POT,XML,MHT,MHTML,XLSX,XLSM,XLSB,ZIP,PDF,PPTX,PPTM,POTX,POTM,DOCX,DOCM,DOTX,DOTM,CDM,TDM,PNG,GIF,JPG,CSS,MRC

Re: BPC 10.1 Embedded (1511 S4/HANA) BPF - Cannot Find EPM Workbook In Workspace

Former Member — Fri, 02 Sep 2016 03:10:55 GMT

Hi Lucas,

I cannot find my environment here in SPRO.

This is a 1511 S/4HANA On Prem system as an aside, but what I see is the below:

Re: BPC 10.1 Embedded (1511 S4/HANA) BPF - Cannot Find EPM Workbook In Workspace

Former Member — Fri, 02 Sep 2016 06:38:07 GMT

Hi Jay,

Are you using Analysis for Office(with EPM Addin+ Analysis) or EPM Add-In excel only?? Have tried using Analysis for Office ----> Open Workbook in BPF hyperlink???

Regards,

Re: BPC 10.1 Embedded (1511 S4/HANA) BPF - Cannot Find EPM Workbook In Workspace

Former Member — Fri, 02 Sep 2016 06:46:13 GMT

Hi JP,

I am using the Analysis For Office 2.3 Installer.

These are EPM workbooks I am attempting to open, I don't follow your suggestion, how do I open workbook in BPF hyperlink?

Re: BPC 10.1 Embedded (1511 S4/HANA) BPF - Cannot Find EPM Workbook In Workspace

Former Member — Fri, 02 Sep 2016 06:57:02 GMT

Re: BPC 10.1 Embedded (1511 S4/HANA) BPF - Cannot Find EPM Workbook In Workspace

Former Member — Fri, 02 Sep 2016 07:11:14 GMT

Hi JP,

Apologies I misunderstood.

I cannot open via "Microsoft Excel" (original issue) and I cannot open via the "Open Workbook" (I do have some Analysis For Office workbooks, however when I select 'Get Variable' nothing happens).

"Open Query" DOES work and I can open the queries via this method (as shown below):