EPM Add-In for Excel

BPC NW 10: VBA function to get dimension members list by Property value

Decided to share simple code to get list of dimension members having some property value. The standard EPM API function is missing for this task. The code can be easily changed to support multiple properties for selection. Parameters and references are described in the code: Option Explicit 'References to FPMXLClient and Microsoft Scripting Runtime required Dim epm As New FPMXLClient.EPMAddInAutomation Public Function GetMembersByProperty(strConn As String, _ strDim As String, strProperty …

Read More »

Simple VBA procedure to pass parameters to DM packages

In this article I will provide universal VBA code to run DM package passing parameters. All parameters are passed as array of strings using some simple format. Actual values for strings can be copied from DM package log (looking also on advanced DM script). The following references are required in Tools -> References: ExecuteDM code: ' Execute DM package using array of strings strAnswer Public Sub ExeceuteDM(ByRef strAnswerArr() As String, …

Read More »

Report or Input Form with Many-to-many Relationship between 2 Dimensions (BPC Standard)

It’s a common question in EPM and BPC NW tags: How to create a report with many-to-many relationship between members of 2 dimensions? For example there are 2 dimensions: ENTITY and ACCOUNT For each ENTITY base member there is a list of valid ACCOUNT base members to be used in reports and data entry. ENTITY ACCOUNT BE1000 2020202020701,2020202020608,2020202020604,2020202020602,2020202020601, 2020202020501,2020202020405,2020202020303,2020202020301,2020202020106, 2020202020101 BE1100 2020202020701,2020202020608,2020202020606,2020202020605,2020202020602, 2020202020405,2020202020404,2020202020403,2020202020402,2020202020303, 2020202020201,2020202020106,2020202020103,2020202020102,2020202020101 … … Any ACCOUNT member can …

Read More »

How to Get EPM Protection Password

In some cases it’s required to find the password used to protect sheets in EPM workbook. Not to remove, but to find the password string. This can be done with a simple VBA code. Create a new workbook, open VBA editor and insert a new module (Module1). Open Menu: Tools -> References and add the reference: Code to Get Sheet Protection Password In the code window paste the following code: …

Read More »

Practical differences – BPC standard vs Embedded BPC (BW-IP/PAK)

I have seen a few posts contrasting the technical differences between “BPC standard model” and “Embedded BPC model” . Intent of my blog is to call out the practical differences I have noticed from a business/ Practical standpoint during the implementation that I have worked on. This is by no means a comprehensive list. Issue   BPC standard BPC embedded (BW-IP/PAK) Master data & other  business consideration Special characters in …

Read More »

The EPM Add-in SP27 release now only has .NET 4.5 version for both 32-bit and 64-bit installations

Starting with the EPM Add-in SP27 version there is only the .NET 4.5 version available which can be installed for use with either 32-bit or 64-bit installations of Microsoft Office. BPC 10.0 or 10.1 for NetWeaver: For the SAP BPC FOR NETWEAVER product the EPM Add-in SP27 version will be available under the EPM Add-in .NET 4.0 for SAP BPC for NetWeaver which will then show the ‘SBOP EPM ADDIN10.0 NET4&ABOVE’  reference. BPC …

Read More »

EPM 10.1 OpenSpecificDocument

We have a “Custom Menu” which is an Excel spreadsheet that our users first see.  On this sheet are links to the various reports and input schedules that they use.  The links look like this: =EPMExecuteAPI(“OpenSpecificDocument”,”5 Year Comparison”,”/REPORTS/Current/5 Year Comparison.xltm”) If I open the report via the link above, a local copy it ends up here: C:REPORTSCurrent5 Year Comparison.xltm If I open the report via EPM>Open Server Report Folder> the …

Read More »

DM PROMPT(COMBOBOX behavior in BPC NW 10 and 7.5)

PROMPT(COMBOBOX… is a useful statement in DM advanced script to provide user selection of some text values that can be later used in script logic. With the help of this statement it’s possible to limit user choice to only values hardcoded in this statement. One example can be restricted list of members to perform some calculations. The syntax is: PROMPT(COMBOBOX,%VARIABLE%,"Prompt text for user",(type of combobox),TEXT1,{TEXT1,TEXT2,TEXT3,TEXT4,TEXT5}) Where: %VARIABLE% – to store …

Read More »

BPC NW 10: VBA to get dimension members list and properties

EPM Excel Add-In provides number of methods to get members and properties. I decided to write some procedure to get all members of the specified dimension with all properties including hierarchies parents. The result is written to the selected Excel sheet the same way as in Administration client of BPC NW 7.5. Methods of FPMXLClient.EPMAddInAutomation used: GetPropertyList(strConn, strDim) to get all properties of the dimension strDim GetHierarchyMembers(strConn, "", strDim) to …

Read More »

EPM Sheet Protection and Offline Mode

**** Correction 18.07.2014 – Default password for Offline protection is “PASSWORD” The document below is based on EPM SP16 Patch 1. The documentation is sometimes confusing and I want to show some step by step examples of protecting sheet. Simple scenario: We create some simple EPM report on the worksheet without changing “Locked” property of cells (all cells are Locked by default for new Excel sheet) and without protection. This …

Read More »

Do you want to Get SAP Courses?

Get SAP Courses and Training, Videos, Other Useful Resources
Join Now
Written by SAP Expert TEAM.
close-link
New Registration