Goals

  • Integration in OLAP-based management consolidation using the SEM-BCS component.

Audience

  • Consultants
  • Customer project team members

Prerequisites

Essential

  • Knowledge of the underlying busines terms from consolidation
  • BW305 BI – Enterprise Reporting, Query & Analysis (Part I) and
  • BW310 BI – Enterprise Data Warehousing

Recommended

Course based on software release

  • BW 7.0
  • SEM 6.0 EhP 7

Content

  • Perform a consolidation process in the monitor
  • Data model of BW-based consolidation
  • Master data (such as versions, item plan)
  • Data transfer methods for movement as well as for master data(flexible upload, manual entry, read from BW)
  • Validations
  • Manual standardizing entries
  • Currency conversion and rounding
  • Reclassification and allocation
  • Interunit elimination
  • Elimination of interunit Profit/Loss in transferred Inventory
  • Consolidation of investments
  • BEX reporting