Bi-kipedia

element61 proactively invests in extending and sharing knowledge and understanding of Business Analytics related topics and concepts.

As part of this effort, we have decided to start a humble "Wikipedia” of Business Analytics, baptized "BI-kipedia”.

Clicking on any of the below listed concepts or terms will lead you to a more elaborated definition and explanation. On the right, you can also filter to see terminology by Topic or Technology or by it starting letter in the alphabet.

Term without link

Off

Bi-kipedia

KXEN Technology

Leading provider of Predictive Analytics solutions that SAP acquired in September 2013. KXEN technology extends predictive analytics tools beyond data scientists to line-of-business users and analysts in the workplace by automating key modeling and analytical tasks and enabling faster deployment and adoption.

Thursday, 7 August 2014

Bi-kipedia

SAP BPC Property

Dimensions have properties. They describe the characteristics of the dimension members. Some properties are mandatory, others can be defined by the user

Thursday, 7 August 2014

Bi-kipedia

SAP BPC Transformation file

Transformation files allow administrators to set up the rules for reading data from an external source and putting it in the proper form for your BPC database. Transformation files are Microsoft Excel files that contain one worksheet, named Instructions. The Instructions worksheet has three sections named options, mapping and conversion.

Thursday, 7 August 2014

Bi-kipedia

SAP BPC Versions

Version or Category is a mandatory dimension in every application or model. This dimension is used to make a distinction between actual, budget and forecasted data.

Thursday, 7 August 2014

Bi-kipedia

SAP BPC Rate Type

Used by the currency conversion business rules. Balance sheet accounts are typically flagged as END, as they are converted at END rate, Pal accounts are typically flagged as AVG.

Thursday, 7 August 2014

Bi-kipedia

Opex - Operational Expenses

An operating expense, operating expenditure, operational expense, operational expenditure or OPEX is an ongoing cost for running a product, business, or system. Its counterpart, a capital expenditure (CAPEX), is the cost of developing or providing non-consumable parts for the product or system.

Thursday, 7 August 2014

Bi-kipedia

SAP BPC Park N Go

You can use the Park N Go function to lock the current view in a report / input schedule, or both current view and data, or to take the workbook offline.

Thursday, 7 August 2014

Bi-kipedia

Ebitda (Earnings before interest, taxes, depreciation, and amortization)

EBITDA is an acronym for earnings before interest, taxes, depreciation, and amortization. It is a non-GAAP metric that is measured exactly as stated. All interest payments, tax, depreciation and amortization entries in the income statement are reversed out from the bottom-line net income. The EBITDA of a company gives an indication on the operational profitability of the business, i.e.

Thursday, 7 August 2014

Bi-kipedia

SAP BPC Getonly range

This range is one of the EVDRE ranges. It makes it possible to define which cells a user only wants to retrieve values. The cells are designated as read-only.

Thursday, 7 August 2014

Bi-kipedia

SAP BPC Script Logic

This function allows users to define formulas that perform calculations with special requirements on Planning and Consolidation dimension members and data.

Thursday, 7 August 2014