SAP BPC 10: Reporting Training Course

This SAP BPC 10: Reporting Training Course will teach you how to build reports in the EPM Add-in for Excel for BPC.

SAP BPC 10: Reporting

This course will teach you how to build reports in the EPM Add-in for Excel for BPC.

This course is relevant to both the Microsoft and Netweaver BPC platforms.

  • Duration: 2 Days
  • Dates: Please select

Goals

This course will teach you how to build reports in the EPM Add-in for Excel for BPC.

This course is relevant to both the Microsoft and Netweaver BPC platforms.

Audience

The target audience for this course is BPC report writers.

Prerequisites

A basic knowledge of Excel is assumed.
A basic understanding of concepts around database structure and dimensionality is desirable

Locations

  • London
  • Warwick
  • Glasgow
  • Onsite at Your Office
  • Virtual

Content

Introduction to the EPM Add-in
 Logging in and creating connections
 The layout of the Add-in
 Context Options

Creating Reports
 Report Editor
 EPM Pane
 Member Recognition

Report Editor
 Structure and Settings
 No Data and Zeroes
 Filtering, Sorting, Ranking

More Complex Reports
 Multidimensional Reports
 Local Members
 Multiple reports in a sheet
 Dynamic Formatting
 Input Forms

Tools
 Offline mode
 Expand and Collapse
 Automatic Worksheet Generation

Functions
 Information Functions
 EPMMemberProperty
 EPMSelectMember
 EPMMemberOffset
 EPMRetriveData, EPMScaleData
 EPMCopyRange
 EPMInsertCellsBeforeAfterBlock
 EPMDimensionOverride
 EPMAxisOverride

Related Courses


Contact
Contact

For any questions please feel free to contact us.