Knowledge base

Aggregates are ‘mini-cubes’ created on top of an existing InfoCube, to pre-aggregate data for faster reporting. Typically they are created after a SAP BW go-live as part of the support when performance problems arise.

An Open Hub Destination is created in order to transfer BW data to a flat file, database table or directly to a third-party tool. It is mapped to an InfoProvider by means of a transformation.

The SAP BW InfoSource is a concept which used to be mandatory in a 3.x dataflow.It is a view that had to be created between the DataSource and InfoProvider, to map the SAP fields to InfoObjects.In the newer versions it is not a mandatory object anymore. However the object is still available to use and will be found in different Business Content data flows.

The query monitor in BW can be accessed via transaction RSRT and is there to test and monitor queries in the SAP GUI. Queries can be debugged, cache settings can be changed, SQL trace can be displayed, etc…

A variable is a parameter that is used in various prompts (BEx selection screen, DTP selection screen, InfoPackage selection screen) to filter data; which can be filled by means of user entry or user exit. Common usage is in the BEx Query.

Capital expenditures (CAPEX or capex) are expenditures creating future benefits. A capital expenditure is incurred when a business spends money either to buy fixed assets or to add to the value of an existing fixed asset with a useful life extending beyond the taxable year.

The IBM Cognos TM1 Application Gateway component is installed together with the TM1 Application Server. It is a java-based web application tier component. This gateway ensures that end users can work with Cognos TM1 Performance Modeler and Cognos Insight.

A mandatory property for the account dimension. There are 4 different account types: -AST: used for assets (BS) -LEQ: used for liabilities and equity (BS) -INC: used for income (P&L) -EXP: used for expenses (P&L)

A mandatory property for the account dimension. There are 4 different account types: -AST: used for assets (BS) -LEQ: used for liabilities and equity (BS) -INC: used for income (P&L) -EXP: used for expenses (P&L)

A mandatory property for the account dimension. There are 4 different account types: -AST: used for assets (BS) -LEQ: used for liabilities and equity (BS) -INC: used for income (P&L) -EXP: used for expenses (P&L)