About this course

Course code TPEPM030
Duration 2 Days

This training 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. A copy of the comprehensive slide deck is supplied to enable on-the-job support.

Prerequisites

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

Delegates will learn how to

  • Build Reports and Input Forms in the EPM Add-in for Excel
  • Use the settings available in the Report Editor
  • Use dynamic formatting
  • Actively use the features and functions available in a variety of reporting Scenarios

Outline

Introduction

  • Introduction to BPC Structures
  • Notes on Security

The EPM Add-in for Excel

  • EPM Add-in for Excel
  • Creating Reports
  • Member Selector


Reporting

  • Context
  • Functions/Formula
  • Managing Reports
  • Input Forms
  • Report Editor Settings
  • Sheet Options
  • Other Report Formats
  • Local Members
  • Formatting
  • Further Functionality

2 Days

Duration

This is a QA approved partner course

Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.