SAP BusinessObjects Dashboards

(1)

SAP BusinessObjects Dashboards

(2)

Disclaimer

This presentation outlines our general product direction and should

not be relied on in making a purchase decision. This presentation is

not subject to your license agreement or any other agreement with

SAP. SAP has no obligation to pursue any course of business outlined

in this presentation or to develop or release any functionality

mentioned in this presentation. This presentation and SAP's strategy

and possible future developments are subject to change and may be

changed by SAP at any time for any reason without notice. This

document is provided without a warranty of any kind, either express

or implied, including but not limited to, the implied warranties of

merchantability, fitness for a particular purpose, or non-infringement.

SAP assumes no responsibility for errors or omissions in this

document, except if such damages were caused by SAP intentionally

or grossly negligent.

(3)

© 2011 SAP AG. All rights reserved. 3 This presentation and SAP’s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. This document is provided without a warranty of any kind either express or implied, including but not limited to the implied warranties of merchantability, fitness for a particular purpose, or non-infringement.

Agenda

SAP BusinessObjects Dashboards 4.0

 Introduction

 Capabilities

(4)

SAP BusinessObjects Dashboards 4.0

Introduction

(5)

SAP BusinessObjects Dashboards

What is a dashboard ?

Interactive analytics is an analytic capability and

“Dashboard” is an information delivery capability.

– Gartner

Visual display of the most important information needed

to achieve one or more objectives; consolidated and

arranged on a single screen so the information can be

monitored at a glance.

– Stephen Few, visualization guru

(6)

(7)

(8)

(9)

(10)

(11)

(12)

Percentage of users using BI tools at least once a week

Pervasive Business Intelligence – Wayne Eckerson TDWI Oct. 2008 Report

Casual Users

SAP BusinessObjects Dashboards

Business Value

BI for casual users

 Engage users with through guided

navigation

 Tailored solutions

 Easy to understand visualization

Not a comprehensive BI solution

 Not an enterprise reporting tool: no paging, no export to Excel or PDF

 Not an ad hoc analysis tool: analysis paths are predefined by dashboard author.

 Interoperates with Web Intelligence, Crystal Reports or Analysis Web Ed. for reporting or

analysis needs.

(13)

SAP BusinessObjects Dashboards

BI Dashboards An Evolutionary Process

Today’s dashboard characteristics

 VISUAL and FUNCTIONAL

 Highly INTERACTIVE

 FLEXIBILE in deployment

 INSPIRATIONAL in design

 EASE of design

 PERSONALIZABLE for ANY user

 SCALABLE to MANY users

(14)

SAP BusinessObjects Dashboards

BI Dashboards An Evolutionary Process

To remain competitive

 retaining and growing the customer base

 Time-to-market is valuable

 Gain instant insight into company performance

Ability to keep costs under control

 Know you are on track at all times

 Dashboards provide insight to those key cost metrics

Accelerating business process improvements

 Dashboards and scorecards offer fast time-to-value

and a low entry price

 Quickest way to improve the bottom line

Regulations and compliance

 Maintain transparency to business

(15)

SAP BusinessObjects Dashboards

Who needs dashboards ?

Business needs

 High-impact interactive visualization of key metrics

 Intuitive user interface and navigation

 Ability to manage and monitor metrics effortlessly

 Drill down or through for root-cause analysis

 Personalized content and display

Technology needs

 Easy dashboard building capabilities

 Flexibility as the needs of an organization change

 Security to ensure proper user access

 Scalable for a growing organization

 Integration to leverage existing BI investments

(16)

SAP BusinessObjects Dashboards

User Alignment

Executive Management

Strategic Dashboards

Financial and Operational

Management

Operational Dashboards

“Information Consumer”

Tactical Dashboards

(17)

SAP BusinessObjects Dashboards

Experience Unparalleled Interactivity

Track with ready

dashboards for

successful

with

interactive insights across

your

(18)

SAP BusinessObjects Dashboards

Gain Unrivaled Flexibility

BW

Visualize and

information

Embed and interact with dashboards

within

and

Extend dashboards to include

visualization

components

(19)

SAP BusinessObjects Dashboards

Design Inspirational Dashboards

Visualizations that can use

Design or

dashboards

decision making with dashboard

(20)

SAP BusinessObjects Dashboards 4.0

Capabilities

(21)

SAP BusinessObjects Dashboards

BI Platform Integration

BI Platform back-end optimized for dashboard flash front-end

Dashboards Processing server

 Provides a thin processing layer between data source and dashboard front-end

Dashboards Cache Server

 Caches query result set per security profile

 Query caching policy define in management console (CMC)

Web

Application

Server

Dashboard

Web

Services

Flash

Dashboard

CSL

Connector

^HTTP

Business Objects Enterprise

Dashboards

Processing

Server

Dashboards

Cache

Server

CSL Connection Server

WebI

Processing

Server

CMS Security and SQL

generation

SQL execution

and cache results

CORBA

New

(22)

SAP BusinessObjects Dashboards 4.0

User Auditing and System Monitoring

Audit events

 Dashboard User: View, refresh, prompt, logon, logout

 Dashboards Designer: create, delete, modify

Server monitoring metrics include

 Processing time, cache size & hits, requests (served,

queued, failed), connections, threads, data transfers,...

(23)

SAP BusinessObjects Dashboards 4.0

Multi-lingual dashboards

Publish a dashboard to the BI platform to allow Translation expert(s) to create

localized text for the dashboard

 The Translation expert(s) use the Translation Manager to localize:

– Component Text Properties: Titles, subtitles, series names, category names

– Ranges in Excel marked as translatable by the dashboard designer

– Note: Text in Excel formulas is not translatable

 They publish the text translations to the BI platform

 The platform combines these translations with the dashboard to create a localized

dashboard

 At runtime the platform displays the

localized dashboard that matches the

user Preferred Viewing Locale (PVL)

(24)

SAP BusinessObjects Dashboards 4.0

Multi-lingual dashboards

(25)

SAP BusinessObjects Dashboards 4.0

Direct Semantic Layer Connection – Query Panel

 Improved authoring via query integration and direct access to semantic layer

 Define a query by dragging and dropping relational universe objects, dimensions and

measures

 Query sorting

 Create filters or single or multi selection query prompts with or without List of Values than

can be used with a Prompt Selector

 Query data preview

Query data

preview

Drag and

drop to

create a

query

(26)

SAP BusinessObjects Dashboards 4.0

Direct Semantic Layer Connection – Query Browser

 Quick access to Query Panel to add and edit queries

 Query summary view to see result objects, filters and prompts

 Delete and refresh queries

 Drag and drop prompts to the canvas to create a Prompt Selector

Query

summary

Pin to auto-hide

drag prompt to canvas

Region Prompt

Selector

Optionally insert into

the spreadsheet

(27)

SAP BusinessObjects Dashboards 4.0

Direct Semantic Layer Connection – Direct Data Binding

 Bind directly from chart and selectors to query result objects

– The component will show more or less values depending on the number of rows returned by the query

(no need for Ignore End Blanks)

– Optionally bind query results to the spreadsheet

 Live data preview at design time when using query data

 Multi column components allow you to bind directly to multiple result objects

(28)

SAP BusinessObjects Dashboards 4.0

Direct Semantic Layer Connection – Prompts

 Auto prompt based on the prompt data type and whether is single or multi value prompt or

cascading list of values

 Directly uses the available List of Values

 Search or page through list of values as well as show or hide selected values

Single value showing list of

values

Single value

Multiple select (in

list) from list of

values

Search or

page through

list of values

(29)

SAP BusinessObjects Dashboards 4.0

Design Enhancements

Labels on charts

 Variety of different positions options, including

best fit

Dynamically set colors

 By series

 Can use hex, rgb, vga or decimal Scorecard

 Enhanced grid with icon alerting and sorting

Canvas Container

 Canvas with no background

Bullet Chart

Spark lines

Forecasting

(30)

SAP BusinessObjects Dashboards 4.0

Supporting Global Requirements

Regional Formatting

 Display data using region specific settings that

match your Preferred Viewing Locale (PVL)

 All Dashboards 4.0 have support

for regional formatting built in

 To enable change from General number format

to one of the following number formats and select

default format in the appearance tab:

Supported

data types

Examples

English (US) German (Germany)

Date Monday, March 1,

2010

Montag, 1. März 2010

Time 10:20:00 PM 22:20:00

Numeric 1,000.00 1.000,00

Currency

^(*)

$1,000.00 $1.000,00

Dashboard

Designer

Dashboard

with Regional

Data Formatting

support enabled

(see below)

Publish to

Platform

Dashboard

automatically

uses data

format that

matches the

current viewing

locale in

InfoView

Enable regional

data formatting

(31)

SAP BusinessObjects Dashboards 4.0

Dashboards on EPM applications data

New data connector based on EPM 7.5 Extended Analytics Analyzer

 Analyzer is an Excel Add-in allowing slicing and dicing of EPM data within Excel

 Dashboards EPM connector is delivered as an add-on (EPMConnector.xlx) with Analyzer

SP05

– Uses EPM ODBO provider for design time and XMLA web services connectivity for runtime

 Currently available for SAP Business Objects Financial Consolidation 7.5, Planning and