Kamen Ignatov, SAP BPC Application Architect, Performance Analytics Corporation

Evaluation and Analysis of SAP BPC Logic

• Types of SAP BPC Logic

• Definitions, functions and analyses of:

– Worksheet Logic

– Dimension logic

– Logic Scripts

– Stored Procedures & BAdI’s

– Business Rules

• Summary of SAP BPC Logic

• Questions

Agenda:

SAP BPC Logic

• Worksheet Logic

• Dimension Logic

• Logic Scripts

• Stored Procedures / Business Add-Ins (BAdI’s)

• Business Rules

The following SAP BPC Logics are available:

SAP BPC Logic

Definition: Calculations defined with Excel or EPM functions within Reports or

Input forms. Data is displayed or stored in the database.

Features: Excel formulas, Macros, and EPM functions.

Worksheet Logic

SAP BPC Logic

Pros: Cons:

- Leverage Excel features and

functions

- Flexible to maintain

- Quick to build initially

- Visibility to logic and calculations

- Can be used to prototype

requirements

- Less efficient with large data as

Refresh and Save could take time

- Need to replicate among different

forms or input schedules

- Cannot be included in Default

Logic

- Security implications

When to use: Reports, input forms, variance analysis calculations, master data

selection, retrieve specific data such as user ID, last refresh, etc.

Definition: Formulas defined in dimension members and calculated on the fly in

reports or input schedules using MDX expressions.

Features: Member specific (calculations are the same across all models) and

calculates at all levels of hierarchy (base and parents).

Dimension Logic

SAP BPC Logic

Pros: Cons:

- Consistent formula across multiple

models

- Real time computations

- Creates “one version of the truth”

- Available for use in any standard

or ad hoc reports

- May impact performance

- Requires MDX (Multi-Dimensional

Expressions) language knowledge

- Slower to build initially than

worksheet logic

- Fewer MDX keywords available in

NW version

When to use: Ratios such as Debt/Equity, ROI, etc.

Definition: Model specific calculations which can run real time (default logic),

scheduled process, or on demand (DM Package).

Features: Only base level members are calculated, parent members are

aggregated using hierarchy.

Logic Scripts

SAP BPC Logic

Pros: Cons:

- Model specific calculation

- Flexibility when to run (real time,

scheduled, or on demand)

- Results are stored in the system

- Efficient with large volumes of data

- Less prone to errors (automated

calculations)

- Requires Logic Scripts knowledge

to make changes

- Adds system process time

- Slower to build initially than

worksheet logic

When to use: Global or targeted inflation increase/decrease, KPI based

calculations (rate * hours), etc.

Definition: Stored procedures are set of SQL statements that perform particular

task. BAdIs are used to adapt SAP codes to specific requirements.

Features: Only base level members are calculated, parent members are

aggregated using hierarchy.

Stored Procedures (MS) & BAdIs (NW)

SAP BPC Logic

Pros: Cons:

- Achieve better performance

compared to Logic Scripts

- Can handle complex computations

that cannot be handled by Logic

Scripts

- Less prone to errors

- Real time, scheduled, or on

demand

- Require technical expertise (can

be mitigated by use of dimension

properties)

- No visibility from front-end

- Adds system processing time

- Slower to build initially than Excel

calculations

When to use: Benefit expense calculations, calendarization, etc.

Definition: Parameter driven functions which perform financial calculations.

Features: Account based calculations, consolidation eliminations, currency

conversion.

Business Rules

SAP BPC Logic

Pros: Cons:

- Good for Consolidation

- Maintenance requires less

technical knowledge

- Property driven makes it easy to

maintain

- Less prone to errors

- Real time, scheduled, or on

demand

- Longer run time than logic scripts

- Lack of flexibility compared to logic

scripts, stored procedures, or

BAdIs

When to use: Currency conversions, intercompany eliminations, cash flow data.

SAP BPC Logic - Summary

Thank you!

Open Q&A