Detailed instructions for use are in the User's Guide.
[. . . ] Dashboard Manager User's Guide
Dashboard Manager 6. 5. 1
2
Dashboard Manager User's Guide
Copyright
No part of the computer software or this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage and retrieval system, without permission in writing from Business Objects S. A. If you find any problems with this documentation, please report them to Business Objects S. A. Printed in United States of America.
Trademarks
The Business Objects logo, WebIntelligence, BusinessQuery, the Business Objects tagline, BusinessObjects, BusinessObjects Broadcast Agent, Rapid Mart, Set Analyzer, Personal Trainer, and Rapid Deployment Template are trademarks or registered trademarks of Business Objects S. A. All other company, product, or brand names mentioned herein, may be the trademarks of their respective owners.
Use restrictions
This software and documentation is commercial computer software under Federal Acquisition regulations, and is provided only under the Restricted Rights of the Federal Acquisition Regulations applicable to commercial computer software provided at private expense. [. . . ] Input parameters Output parameters Cube that has one or more rows of dimension data and one measure. One row or Line of the cube with the minimum measure value for each dimension value. The information in the report.
reportdata(docid- Returns the data in docnamethe report. above for details ReportView(doci d-docname, reportname, domainname, refresh flag *see section above for details
Docid-docname, for example, '12Sales Report. Domain name is where the doc is published
Returns the date in Docid-Docname, for example, "12the report Sales Report" Works for WebI reports only Report name is report or tab from which you want data Domain is the document domain where report is published Refresh specifies if report should be published
Information in the report
144
Dashboard Manager User's Guide
Function measurevalue(cu be, measure_name, aggregation_func tion, filter_list)
Description Returns a single measure value or a cube with several values for the measure; based on the filters applied and aggregation performed. All dimension information will be removed through projection and filtering.
Input parameters Output parameters Cube that contains One or more the dimensions values for the and measures; same measure measure name for which the measure value(s) is computed; aggregation function for projection of measures and filter list that assists in filtering cube rows. Cube for which projection is desired; index of the column that needs to be removed starting with 0. A reduced cube with the column specified by the index removed.
projectcube(cube Returns the cube , column_index) with one dimension removed.
Rules
Dashboard Manager User's Guide
145
Function filtercube(cube, c olumn_index)
Description Returns a filtered cube for the column specified.
Input parameters Output parameters Cube for which the A reduced cube filtering is required; filtered by the column index that column specified. Cube for which the filtering is required; column index that specifies the column for the sort. An ascending sort of the cube based on the column of the sort.
sortcube(cube, column_index)
Returns a cube sorted by the column specified in ascending order.
mergecube(cube Returns a cube 1, cube2) that is a merge of two cubes. Can be a merge of all lines from both cubes.
A merged cube that is a result of the merge of all lines from cube1 and cube2.
Goal variables
· Target value function Set of functions for a specific goal: "goal1" TargetValue(goal1. GOALID) = #f TargetValue(goal1. GOALID) % This function returns the target or goal value for the current period, if no period is specified. For example if the selected goal variable is a Revenue plan (on a quarterly
146
Dashboard Manager User's Guide
calendar) and its values are as follows: Period 7/1/2002 10/1/2002 1/1/2003 4/1/2003 Revenue Plan (in, 000) 2, 500 3, 200 3, 000 3, 250
·
·
Then the call - TargetValue(goal1. goalid) will return 3, 250 - TargetValue(goal1. goalid, -1) will return 3, 000 - TargetValue(goal1. goalid, Date(2002, 7, 1)) will return 2, 500 as July 1, 2002 will fall in Q3'02 If the end user specifies a wrong date, such as TargetValue(goal1. goalid, -10) for which no value exists, then an error should be returned for "no value found". Set of functions for a specific metric: "metric1" with all its goals TargetValue(metric1. goal(*). goalid) = #f TargetValue(metric1. goal(*). goalid) % Set of functions for a specific metric: "metric1" with the goal of the type "type1" metric1. goal('type1'). (GOALID) = #f metric1. goal('type1'). goalid % Metric Polarity Metric polarity function returns the polarity for the metric. This polarity signifies if an upward trend is good or bad for the specific metric. For example an upward trend is good for a Revenue metric but bad for an Expenses metric. MetricPolarity(metricid) The Metric polarity function will return: 1 if Metric has an upward trend is good perspective like Enterprise Revenue, profits -1 if Metric has an upward trend is bad perspective like Expenses, Churn Goal status function The Goal Status function compares the metric value to its goal and determines performance against that goal. Please refer to the scenarios specified in the scope section for the individual treatment below. Scenario 1: Compare one metric against one goal In this scenario we are only comparing one metric against one goal. The call
·
·
Rules
Dashboard Manager User's Guide
147
for this function would be GoalStatus(goalid[, -nbPeriod|date]) The function above should return for a goalid: -1 when the associated metric under-performs the target 0 when the associated metric value is equal to the target value 1 when the associated metric over-performs the target value With the input parameter of goalid, we can associate a metric and find the metric id for this goal. In addition with the metric we can determine the polarity to ascertain what under-perform and over-perform mean for that metric. An example call for this function could be - GoalStatus(goal1. goalid) where goal1 is the Revenue Plan goal and it compares the current period Revenue with the Revenue plan for this period and returns a value based on performance, taking a polarity of 1 into account for Revenue where an upward trend is good. - GoalStatus(goal1. goalid, -1) will compare the same Revenue metric against the Revenue Plan for the last period, i. e. [. . . ] - Drag and drop the analytic you would like to view in a navigation list. In the navigation list it would look something like this with analytics and documents.
5. The dashboard now has the viewer that displays selected analytics or documents when you click on them, in the navigation list.
Other Analytics
Dashboard Manager User's Guide
287
Group analytic
Group analytic allows you to group different analytics together for your dashboard. From the list of New Analytics select Group analytic and drag & drop in the viewer side.
As you drop the group analytic on the viewer you have an area where you can move analytics you want grouped together.
Group analytic
288
Dashboard Manager User's Guide
4. [. . . ]