Book Image

SAP BusinessObjects Dashboards 4.0 Cookbook

Book Image

SAP BusinessObjects Dashboards 4.0 Cookbook

Overview of this book

Xcelsius 2008 was recently included in SAP’s BusinessObjects 4.0 family, rebranding “Xcelsius Enterprise” as “SAP BusinessObjects Dashboards 4.0”. With features like flexible design and what-if scenarios, the powerful dashboarding software allows enterprises to make business decisions at a glance, and this book allows you to go far beyond the basics of these techniques. This cookbook full of practical and applicable recipes will enable you to use the full latest capabilities of Dashboard Design to visually transform your business data. A wide range of recipes will equip you with the knowledge and confidence to perform tasks like configuring charts, creating drill- downs, making component colors dynamic, using alerts in maps, building pop-up screens, setting up What-If scenarios, and many more.The recipes begin by covering best practices for using the Dashboard Design spreadsheet, the data-model, and the connection with the components on the canvas, later moving on to some from-the-trenches tricks for using Excel within Dashboard Design. The book then guides you through the exploration of various data visualization components and dashboard interactivity, as well as offering recipes on using alerts, dashboard connectivity, and making the most of the aesthetics of the dashboard. Finally, the recipes conclude by considering the most important add-ons available for Dashboard Design and enabling you to perform relevant and useful tasks straight away.
Table of Contents (22 chapters)
SAP BusinessObjects Dashboards 4.0 Cookbook
Credits
Foreword
About the Authors
Acknowledgement
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Index

Supported Excel functions


The following is a table of supported Microsoft Excel functions taken from the latest Dashboard Design User Guide, at the time of writing:

ABS

ACOS

ACOSH

AND

ASIN

ASINH

ASSIGN

ATAN

ATAN2

ATANH

AVEDEV

AVERAGE

AVERAGEA

BETADIST

CEILING

CHOOSE

COMBIN

CONCATENATE

COS

COSH

COUNT

COUNTA

COUNTIF

DATE

DATEVALUE

DAVERAGE

DAY

DAYS360

DB

DCOUNT

DCOUNTA

DDB

DEGREES

DEVSQ

DGET

DIVIDE

DMAX

DMIN

DOLLAR

DPRODUCT

DSTDEV

DSSTDEVP

DSUM

DVAR

DVARP

EDATE

EOMONTH

EVEN

EXACT

EXP

EXPONDIST

FACT

FALSE

FIND

FISHER

FISHERINV

FIXED

FLOOR

FORECAST

FV

GE

GEOMEAN

GT

HARMEAN

HLOOKUP

HOUR

IF

INDEX

INT

INTERCEPT

IPMT

IRR

ISBLANK

ISNA

ISNUMBER

KURT

LARGE

LE

LEFT

LEN

LN

LOG

LOG10

LOOKUP

LOWER

MATCH

MAX

MEDIAN

MID

MIN

MINUS

MINUTE

MIRR

MOD

MODE

MONTH

N

NE

NETWORKDAYS

NORMDIST

NORMINV

NORMSINV

NOT

NOW

NPER

NPV

OFFSET

OR

PI

PMT

POWER

PPMT

PRODUCT

PV

QUOTIENT

RADIANS

RAND

RANGE_COLON

RANK

RATE

REPLACE

REPT

RIGHT

ROUND

ROUNDDOWN

ROUNDUP

SECOND

SIGN

SIN

SINH

SLN

SMALL

SQRT

STANDARDIZE

STDEV

SUM

SUMIF

SUMPRODUCT

SUMSQ

SUMX2MY2

SUMX2PY2

SUMXMY2

SYD

TAN

TANH

TEXT

TIME

TIMEVALUE

TODAY

TRUE

TRUNC

UPPER

VALUE

VAR

VDB

VLOOKUP

WEEKDAY

WEEKNUM

WORKDAY

YEAR

YEARFRAC