Index
A
- ABS function / Supported Excel functions
- ACOS function / Supported Excel functions
- ACOSH function / Supported Excel functions
- add-ons, Dashboard Design
- Adobe Air Applets
- creating, from Xcelsius Dashboards / Creating Adobe Air Applets from Dashboard Design dashboard, Getting ready, How to do it...
- Adobe Flash
- downloading / How it works...
- Adobe Flex SDK / How it works...
- advanced components
- grid component / Using the grid component
- Panel Set component / Using the panel set component
- history component / Using the history component
- Source data component / Data insertion with the Source data component
- trend analyzer component / Analyzing trends
- AIR / How it works...
- airwidget.air icon / How to do it...
- alerts
- adding, to column chart / Adding alerts to a column chart, Getting ready, How to do it..., How it works...
- using, in gauge / Using alerts in a gauge, How to do it..., How it works...
- dynamic ranges, creating / Making alert ranges dynamic, Getting ready, How to do it..., How it works..., There's more...
- displaying, on map / See Also, Displaying alerts on a map, Getting ready, How to do it..., How it works..., Displaying alerts ofmapalerts, displayingalertsdisplaying, on map different thresholds on a map
- threshold values, displaying on map / Displaying alerts ofmapalerts, displayingalertsdisplaying, on map different thresholds on a map, Getting ready, How to do it..., How it works..., See also
- bindable colors, using / Using bindable colors to control alert coloring from a central location, How to do it..., See also
- using, in scorecard / Using alerts in a scorecard, How to do it...
- Alignment options, Format menu / How to do it...
- Allow Zoom Out Only option / Allow Zoom Out Only
- Answer prompts window / Using prompts
- Antivia
- website / Getting ready
- Antivia XWIS
- integrating, with Web Intelligence / Integrating Web Intelligence with Antivia XWIS, How to do it...
- working / How it works...
- Antivia Slice and Dice component / Antivia Slice and Dice component
- Antivia Export component / Antivia Export component
- Appearance icon / How to do it...
- Appearance properties / How to do it...
- Appearance tab / How to do it...
- area chart
- configuring / Other charts: area chart
- Art and Backgrounds tab / How to do it...
- ASIN function / Supported Excel functions
- ASINH function / Supported Excel functions
- ASSIGN function / Supported Excel functions
- ATAN2 function / Supported Excel functions
- ATANH function / Supported Excel functions
- AutoWire feature / How it works...
- AVEDEV function / Supported Excel functions
- AVERAGEA function / Supported Excel functions
B
- background, adding to dashboard
- about / Adding a background to your dashboard
- starting with / Getting ready
- steps / How to do it...
- working / How it works...
- reference / There's more...
- bar chart
- configuring / Other charts: bar chart and column chart
- Sorting settings, using / Sorting series
- Behavior tab / How to do it..., How to do it..., How to do it...
- Best Fit option
- More Options section / How it works...
- BETADIST function / Supported Excel functions
- BEx Query / How it works...
- BICS
- about / Connecting to SAP BW
- BI launch pad / Exporting to SAP Business Objects Enterprise
- borders, using in spreadsheet
- steps / How to do it..., There'borders, using in spreadsheetstepss more...
- toolbar border button / Toolbar border button
- Toolbar border button / Toolbar border button
- multiple worksheets, using / Use multiple worksheets
- logic cells, placing / Place your logic wisely
- bubble chart
- about / Getting ready
- using / Getting ready
- working / Using the radar chart
- bullet chart
- about / Using the bullet chart
- target, displaying / Using the bullet chart
- ranges, displaying / Using the bullet chart
- configuring / Getting rebullet chartconfiguringady, How to do it...
- working / How it works...
- separate x-axes, configuring / There is more...
- Business Objects XI R2 OpenDoc
- manual / See also
C
- calendar
- about / Selecting calendar dates
- dates, selecting / Getting ready, How to do it..., How it works...
- working / How it works...
- candlestick chart
- about / Using the OHLC chart and candlestick chart
- using / Getting ready, How to do it...
- working / How it works...
- canvas components
- grouping / Getting ready
- grouping, steps / How to do it..., How it works...
- working / How it works...
- hiding / Hiding components
- locking / Locking components
- canvas container
- components, organizing / Grouping and organizing components with the canvas container, How to do it...
- components, grouping / Grouping and organizing components with the canvas container
- components, working / How it works...
- CEILING function / Supported Excel functions
- cell customization, spreadsheet
- starting with / Getting ready
- steps / How to do it...
- insertion role / How it works...
- working / Tcell customization, spreadsheetworkinghere's more...
- legend, creating / Tcell customization, spreadsheetworkinghere's more...
- cell format, copying
- CELogonToken
- dashboard accessing, with live data outside Infoview / Accessing dashboards with live data outside of Infoview using CELogonToken, Getting ready
- working / How it works...
- at runtime / CELogonToken at runtime
- code, explaining / Step-by-step code explanation
- Centigon Solutions
- chart drilldown
- starting with / Getting ready
- steps / How to do it...
- Regional Sales chart / How to do it...
- workring / How it works...
- chart look
- modifying / Getting ready, How to do it...
- working / How it works...
- charts
- line chart, adding to dashboard / Adding a line chart to your dashboard
- bullet chart, using / Using the bullet chart
- combination chart, using / Getting ready
- pie chart, using / Using the pie chart
- XY chart, using / Getting ready
- bubble chart, using / Getting ready
- radar chart, using / Getting ready
- OHLC chart , using / Using the OHLC chart and candlestick chart
- candlestick chart, using / Using the OHLC chart and candlestick chart
- zooming in / Zooming in on charts, How to do it...
- switching between / Switching between different charts
- charts, switching between
- starting with / Getting ready
- steps / How to do it...
- working / How it works..., There'scharts, switching betweenworking more...
- Dynamic Visibility settings / Status charts, switching betweenDynamic Visibility settingsvalues
- status value / Status charts, switching betweenDynamic Visibility settingsvalues
- child.swf file / Passing multiple values
- color schemes
- about / Using color schemes
- using / Getting ready, How to do it...
- working / How it works...
- best practices / There's more...
- sharing / Sharing a color scheme, How to do it...
- Color Scheme Toolbar, working / How it works...
- column chart
- configuring / Other charts: bar chart and column chart
- alerts, adding / Adding alerts to a column chart, Getting ready, How to do it..., How it works...
- combination chart
- using / Getting ready, How to do it...
- working / How it works...
- Appearance tab / There is more...
- COMBIN function / Supported Excel functions
- Combo Box selector / How to do it...
- comments, inserting in spreadsheet
- steps / Gespreadsheetcomments, insertingtting ready, How to do it...
- working / How it works...
- component color
- about / Making component colors dynamic
- controlling / Making component colors dynamic, How to do it...
- Excel formulas, using / How it works..., There's more...
- Concatenate function / Using variables and filters
- CONCATENATE function / Supported Excel functions
- connectivity applications
- LiveCycle Data Services / System and software requirements
- reporting services / System and software requirements
- SharePoint / System and software requirements
- WebSphere / System and software requirements
- Adobe Acrobat / System and software requirements
- Adobe Reader / System and software requirements
- Adobe AIR / System and software requirements
- Adobe Flex SDK / System and software requirements
- Crystal Reports / System and software requirements
- Corporate Dashboard
- setting up / Housing your dashboard in Dashboard Builder
- homepage, customizing / There's more...
- COS function / Supported Excel functions
- COUNTA function / Supported Excel functions
- COUNT function / Supported Excel functions
- COUNTIF function / Supported Excel functions
- COUNTIF statement / How it works...
- CSV-connector
- using, for CSV-files connection / Cadd-ons, Dashboard Designmanagingonnecting to CSV-files with the CSV-connector, How to do it...
- working / How it works...
- calculations, doing / Calculations
- data, exporting to CSV file / Exporting data to a CSV file
- CSV-files
- connecting to, CSV-connector used / Cadd-ons, Dashboard Designmanagingonnecting to CSV-files with the CSV-connector, How to do it...
- custom image
D
- dashboard
- line chart, adding / Adding a line chart to your dashboard, How to do it...
- data, filtering / Selecting your data from a list
- MacOSX program loading dock, adding / Adding a MacOSX loading dock to your dashboard, How to do it...
- report, differentiating / Opening up a Web Intelligence report using dashboard parameters
- calendar / Selecting calendar dates
- printing / Printing your dashboard
- printing, steps / How to do it...
- Print button, working / How it works...
- scenarios, using / Using dashboard scenarios
- news ticker, integrating with / Creating a news ticker with Excel XML Maps, Getting ready, How to do it...
- values passing, Flash Variables used / Passing values from dashboard to dashboard with Flash Variables, How to do it...
- working / How it works...
- multiple variables, using / Using multiple variables
- multiple variables, passing / Passing multiple values
- accessing, CELogonToken used / Accessing dashboards with live data outside of Infoview using CELogonToken, How to do it...
- CELogonToken, working / How it works...
- embedding, in file types / Exporting to a standard SWF, PPT, PDF, and so on
- organizing, Dashboard Builder used / Housing your dashboard in Dashboard Builder, How to do it...
- dashboard, customizing
- chart look, changing / Changing the look of a chart
- background, adding / Adding a background to your dashboard
- color schemes, using / Using color schemes
- color scheme, sharing / Sharing a color scheme
- themes, working with / Working with themes
- component color, controlling / Making component colors dynamic
- panel container, using / Using the panel container
- tab set container, using / Using the tab set container
- tables, customizing / Making tables look pretty
- quadrants, using / Smart use of quadrants
- Dashboard Builder
- using / There's more...
- using, for dashboard organization / Housing your dashboard in Dashboard Builder, How to do it...
- working / There's more...
- Dashboard Design
- CELogonToken, consuming / How does Dashboard Design consume CELogonToken?
- code, explaining / Step-by-step code explanation
- top third-party add-ons / Introduction
- add-ons, managing / Managing add-ons in Dashboard Design
- Dashboard Design-SAP BW connection setting
- setting up / Getting ready, How to do it..., How it works...
- dashboards
- about / Introduction
- DashConn
- about / Connecting to Salesforce.com with DashConn
- Salesforce.com, connecting to / Getting ready, How to do it...
- data
- resetting, reset button used / Resetting your data (reset button)
- data, filtering
- regions, selecting / Selecting your data from a list, Getting ready, How to do it...
- region selection, working / How it works...
- Data Preview tab / How to do it..., How it works..., How to do it...
- data selection
- Data Sharer
- about / Transferring data between dashboards with Data Sharer
- data between dashboards, transferring / Getting ready, How to do it...
- working / How it works...
- data values
- about / Inputting data values
- input text box, creating / Inputting data values, How to do it...
- input value text box, working / How it works...
- data visualization
- about / Introduction
- Dashboard Design / Introduction
- DATEVALUE function / Supported Excel functions
- DAVERAGE function / Supported Excel functions
- DAY function / Supported Excel functions
- DB function / Supported Excel functions
- DCOUNTA function / Supported Excel functions
- DCOUNT function / Supported Excel functions
- Definition tab
- DEGREES function / Supported Excel functions
- Delete button / How it works...
- Developer tab / Getting ready
- adding / Adding the Developer tab
- DEVSQ function / Supported Excel functions
- DGET function / Supported Excel functions
- Disable Mouse Input on Load option / Usage tab
- DMAX function / Supported Excel functions
- DMIN function / Supported Excel functions
- DOLLAR function / Supported Excel functions
- Drill Down icon / How to do it...
- DSSTDEVP function / Supported Excel functions
- DSTDEV function / Supported Excel functions
- DSUM function / Supported Excel functions
- DVARP function / Supported Excel functions
- dynamic visibility
- about / Introduction
E
- Edit Prompt screen / How to do it...
- Enable Interaction option / How to do it...
- examples, real world dashboard
- what-if scenario dashboard / What-if scenario: mortgage calculator
- sales/profit dashboard / Sales/profit dashboard example
- Excel XML Maps
- news ticker, creating / Creating a news ticker with Excel XML Maps, Getting ready, How to do it...
- working / How it works...
- Developer tab, adding / Adding the Developer tab
- Usage tab / Usage tab
- Connection Refresh Button / Connection Refresh button
- EXPONDIST function / Supported Excel functions
- Export to swf / How to do it...
F
- Filtered Rows
- about / Using Filtered Rows
- VLOOKUPs, performing / Using Filtered Rows
- using / How to do it...
- working / How it works...
- filter selector component
- about / Using the Filter Selector component for hierarchies
- using, for hierarchies / Getting ready, How to do it...
- working / How it works...
- Fisheye selector menu
- using / Adding a MacOSX loading dock to your dashboard, How to do it...
- working / How it works...
- Fit Canvas To Components option / How to do it...
- Fit the Canvas to Components / How to do it...
- Fixed Label Size option / How it works...
- Flash Variables
- using, to pass values / Passing values from dashboard to dashboard with Flash Variables, How to do it...
- FORECAST function / Supported Excel functions
- Format Cells option / Toolbar border button
G
- gauge
- alerts, using / Using alerts in a gauge, How to do it..., How it works...
- about / Using alerts in a gauge
- General tab / How it works
- GMaps plugin
- integrating, with Google Maps / How to do it..., How it works...
- website / More fGMaps plugin-Google Maps integrationworkingeatures
- GMaps plugin-Google Maps integration
- prerequisites / Getting ready
- steps / How to do it...
- working / How it works..., More fGMaps plugin-Google Maps integrationworkingeatures
- XGlobe add-on / XGlobe and XYahooMap
- XYahooMap add-on / XGlobe and XYahooMap
- Google Maps
- integrating, with GMaps plugin / IntegratCentigon Solutionswebsiteing Google Maps with the GMaps plugin, How to do it..., How it works...
- Google Maps API key / Getting ready
- grid component
- about / Using the grid component
- list view components, differentiating / Using the grid component
- using / Getting ready
- using, steps / How to do it...
- working / How it works...
- value, changing / There is more...
H
- hardware requirements , SAP Business Objects Dashboards
- minimum screen resolution / System and software requirements
- SAP Business Objects Dashboards / System and software requirements
- Dashboard SWF / System and software requirements
- history component
- about / Using the history component
- using, steps / How to do it...
- working / How it works...
- HR Health Assessment Dashboard / How to do it...
I
- Images button / How to do it...
- Import Named Ranges button / How to do it...
- Information Design Tool
- using / Getting ready
- Inovista
- website / More information
K
- keys
- Ctrl-F3 / Name Manager
- Ctrl+` / How it works..spreadsheetdebugging, steps.
- Ctrl + PageUp / How to do it...
- Ctrl + PageDown / How it works...
L
- Launch option / How to do it...
- line chart
- adding, to dashboard / Adding a line chart to your dashboard, How to do it...
- working / How it works...
- data, binding manually / Manually binding data
- series, showing / Hide/show series
- series, hidding / Hide/show series
- listbox breadcrumb type approach
- using / Alternative hierarchy selection method, Getting ready, How to do it...
- working / How it works...
- Live Office connection
- about / Using Live Office connection
- using / Getting ready, How to do it...
- working / How it works...
- prompts, using / Using prompts
- login functionality, password used
- getting started / Getting ready
- steps / How to do it...
- working / How it works...
- LOOKUP function / Supported Excel functions
M
- MacOSX program loading dock
- adding, to dashboard / Adding a MacOSX loading dock to your dashboard, How to do it...
- Fisheye Picture Menu, working / How it works...
- Sliding Picture menu / There's more...
- map
- about / Using maps to select data of an area or country
- using, for country data selection / How to do it...
- using, for area data selection / How to do it...
- regions, locationg / How to do it...
- working / How it works...
- alerts, displaying / See Also, Displaying alerts on a map, Getting ready, How to do it..., How it works..., Displaying alerts ofmapalerts, displayingalertsdisplaying, on map different thresholds on a map
- different thresholds, displaying alerts on / Displaying alerts ofmapalerts, displayingalertsdisplaying, on map different thresholds on a map, Getting ready, How to do it..., How it works..., See also
- MAX function / Supported Excel functions
- Micro Chart Suite
- about / Presenting micro charts in a tree grid
- presenting, in tree grid / Presenting micro charts in a tree grid, How to do it...
- working / How it works..., There is more...Micro Chart Suiteworking
- MicroChart Table component / Data grid
- Microsoft Excel functions
- ABS / Supported Excel functions
- ACOS / Supported Excel functions
- ACOSH / Supported Excel functions
- AND / Supported Excel functions
- ASIN / Supported Excel functions
- ASINH / Supported Excel functions
- ASSIGN / Supported Excel functions
- ATAN / Supported Excel functions
- ATAN2 / Supported Excel functions
- ATANH / Supported Excel functions
- AVEDEV / Supported Excel functions
- AVERAGE / Supported Excel functions
- AVERAGEA / Supported Excel functions
- BETADIST / Supported Excel functions
- CEILING / Supported Excel functions
- CHOOSE / Supported Excel functions
- COMBIN / Supported Excel functions
- CONCATENATE / Supported Excel functions
- COS / Supported Excel functions
- COSH / Supported Excel functions
- COUNT / Supported Excel functions
- COUNTA / Supported Excel functions
- COUNTIF / Supported Excel functions
- DATE / Supported Excel functions
- DATEVALUE / Supported Excel functions
- DAVERAGE / Supported Excel functions
- DAY / Supported Excel functions
- DAYS360 / Supported Excel functions
- DB / Supported Excel functions
- DCOUNT / Supported Excel functions
- DCOUNTA / Supported Excel functions
- DDB / Supported Excel functions
- DEGREES / Supported Excel functions
- DEVSQ / Supported Excel functions
- DGET / Supported Excel functions
- DIVIDE / Supported Excel functions
- DMAX / Supported Excel functions
- DMIN / Supported Excel functions
- DOLLAR / Supported Excel functions
- DPRODUCT / Supported Excel functions
- DSTDEV / Supported Excel functions
- DSSTDEVP / Supported Excel functions
- DSUM / Supported Excel functions
- DVAR / Supported Excel functions
- DVARP / Supported Excel functions
- EDATE / Supported Excel functions
- EOMONTH / Supported Excel functions
- EVEN / Supported Excel functions
- EXACT / Supported Excel functions
- EXP / Supported Excel functions
- EXPONDIST / Supported Excel functions
- FACT / Supported Excel functions
- FALSE / Supported Excel functions
- FIND / Supported Excel functions
- FISHER / Supported Excel functions
- FISHERINV / Supported Excel functions
- FIXED / Supported Excel functions
- FLOOR / Supported Excel functions
- FORECAST / Supported Excel functions
- FV / Supported Excel functions
- GE / Supported Excel functions
- GEOMEAN / Supported Excel functions
- GT / Supported Excel functions
- HARMEAN / Supported Excel functions
- HLOOKUP / Supported Excel functions
- HOUR / Supported Excel functions
- IF / Supported Excel functions
- INDEX / Supported Excel functions
- INT / Supported Excel functions
- INTERCEPT / Supported Excel functions
- IPMT / Supported Excel functions
- IRR / Supported Excel functions
- ISBLANK / Supported Excel functions
- ISNA / Supported Excel functions
- ISNUMBER / Supported Excel functions
- KURT / Supported Excel functions
- LARGE / Supported Excel functions
- LE / Supported Excel functions
- LEFT / Supported Excel functions
- LEN / Supported Excel functions
- LN / Supported Excel functions
- LOG / Supported Excel functions
- LOG10 / Supported Excel functions
- LOOKUP / Supported Excel functions
- LOWER / Supported Excel functions
- MATCH / Supported Excel functions
- MAX / Supported Excel functions
- MEDIAN / Supported Excel functions
- MID / Supported Excel functions
- MIN / Supported Excel functions
- MINUS / Supported Excel functions
- MINUTE / Supported Excel functions
- MIRR / Supported Excel functions
- MOD / Supported Excel functions
- MODE / Supported Excel functions
- MONTH / Supported Excel functions
- N / Supported Excel functions
- NE / Supported Excel functions
- NETWORKDAYS / Supported Excel functions
- NORMDIST / Supported Excel functions
- NORMINV / Supported Excel functions
- NORMSINV / Supported Excel functions
- NOT / Supported Excel functions
- NOW / Supported Excel functions
- NPER / Supported Excel functions
- NPV / Supported Excel functions
- OFFSET / Supported Excel functions
- OR / Supported Excel functions
- PI / Supported Excel functions
- PMT / Supported Excel functions
- POWER / Supported Excel functions
- PPMT / Supported Excel functions
- PRODUCT / Supported Excel functions
- PV / Supported Excel functions
- QUOTIENT / Supported Excel functions
- RADIANS / Supported Excel functions
- RAND / Supported Excel functions
- RANGE_COLON / Supported Excel functions
- RANK / Supported Excel functions
- RATE / Supported Excel functions
- REPLACE / Supported Excel functions
- REPT / Supported Excel functions
- RIGHT / Supported Excel functions
- ROUND / Supported Excel functions
- ROUNDDOWN / Supported Excel functions
- ROUNDUP / Supported Excel functions
- SECOND / Supported Excel functions
- SIGN / Supported Excel functions
- SIN / Supported Excel functions
- SINH / Supported Excel functions
- SLN / Supported Excel functions
- SMALL / Supported Excel functions
- SQRT / Supported Excel functions
- STANDARDIZE / Supported Excel functions
- STDEV / Supported Excel functions
- SUM / Supported Excel functions
- SUMIF / Supported Excel functions
- SUMPRODUCT / Supported Excel functions
- SUMSQ / Supported Excel functions
- SUMX2MY2 / Supported Excel functions
- SUMX2PY2 / Supported Excel functions
- SUMXMY2 / Supported Excel functions
- SYD / Supported Excel functions
- TAN / Supported Excel functions
- TANH / Supported Excel functions
- TEXT / Supported Excel functions
- TIME / Supported Excel functions
- TIMEVALUE / Supported Excel functions
- TODAY / Supported Excel functions
- TRUE / Supported Excel functions
- TRUNC / Supported Excel functions
- UPPER / Supported Excel functions
- VALUE / Supported Excel functions
- VAR / Supported Excel functions
- VDB / Supported Excel functions
- VLOOKUP / Supported Excel functions
- WEEKDAY / Supported Excel functions
- WEEKNUM / Supported Excel functions
- WORKDAY / Supported Excel functions
- YEAR / Supported Excel functions
- YEARFRAC / Supported Excel functions
- MINUS function / Supported Excel functions
- Month to Month Change checkbox / How to do it...
N
- named ranges
- using / How to do it...
- working / How it works...
- defined list / Defined named ranges
- Name Manager / Name Manager
- NETWORKDAYS function / Supported Excel functions
- news ticker
- integrating, with dashboard / Creating a news ticker with Excel XML Maps, Getting ready, How to do it...
- NORMDIST function / Supported Excel functions
O
- OHLC chart
- about / Using the OHLC chart and candlestick chart
- using / Getting ready, How to do it...
- working / How it works...
- online resources
- SAP Community Network / Online resources
- Business Objects Board / Online resources
- EverythingXcelsius.com / Online resources
- MyXcelsius.com / Online resources
- HackingSAP.com / Online resources
- Business Intelligence Blog / Online resources
- Output Values, SAP BW
- Cross-Tab Data / Other Output Values
- characteristics / Other Output Values
- Variables / Other Output Values
- Static Filter / Other Output Values
- Information / Other Output Values
- Messages / Other Output Values
P
- panel container
- about / Using the panel container
- using / How to do it...
- working / How it works...
- Panel Set component
- about / Using the panel set component
- pre-requisites / Getting ready
- using / Getting ready, How to do it...
- working / How it works...
- files, linking to / Linking to files instead of embedding
- Zoom Speed setting / Panel behavior
- parent.swf file / Passing multiple values
- Percent Style option / Getting ready
- pie chart
- about / Using the pie chart
- using / How to do it...
- working / How it works...
- Pie Chart component / How to do it...
- Play Selector component
- using / Using Play Selector/Play Control, How to do it...
- dashboard images, using / Getting ready
- working / How it works...
- PMT function / Supported Excel functions
- pop-up screen
- starting with / Getting ready
- building, steps / How to do it...
- working / How it works...
- Info push button / There's more...
- activating, with mouse click / Creating a mouse-over help text pop-up
- pop-up screen activation, with mouse click
- starting with / Getting ready
- steps / How to do it...
- working / How it works
- source data table / How it works
- POWER function / Supported Excel functions
- PPMT function / Supported Excel functions
- PPT
- exporting to / How it works..., There's more...
- Preview button / How to do it...
- PreviewQuery Results screen / How to do it...
- Print button / Printing your dashboard
- Publish As... option / How to do it...
- push button-image component combination
- clickable image, creating / Making selections from a custom image (push button and image component), How to do it..., How it works...
- working / How it works...
- Push Button properties / How to do it...
- PV function / Supported Excel functions
Q
- QaaWS
- about / Using Query as a WebService (QaaWS)
- using / Getting ready
- creating / How to do it...
- working / How it works...
- prompts, using / Using prompts
- methods, using / Methods
- quadrants
- about / Smart use of quadrants
- using / Getting ready, How to do it...
- working / How it works...
- QUOTIENT function / Supported Excel functions
R
- radar chart
- about / Using the radar chart, How to do it...
- using / Getting ready
- working / radar chartworkingThere is more...
- difference / radar chartworkingThere is more...
- RADIANS function / Supported Excel functions
- Radio Button selector / How to do it...
- range slider
- about / Zooming in on charts
- working / Scaling the y-range sliderworkingaxis
- RANGE_COLON function / Supported Excel functions
- RANK function / Supported Excel functions
- RATE function / Supported Excel functions
- raw data
- displaying / Getting ready, How to do it...
- working / How it works...
- real world dashboard
- Refresh Data button / How to do it...
- Refresh Data Preview button / How to do it...
- report
- dashboard, differentiating / Opening up a Web Intelligence report using dashboard parameters
- REPT function / Supported Excel functions
- Reset button / There is more...
- reset button
- about / How to do it...
- data, resetting / How to do it...
- working / How it works...
- RIGHT function / Supported Excel functions
- ROUND function / Supported Excel functions
- ROUNDUP function / Supported Excel functions
- runQueryAsAServiceEx method / Methods
- runQueryAsAService method / Methods
S
- .swf files / Passing values from dashboard to dashboard with Flash Variables
- sales/profit dashboard example
- about / Sales/profit dashboard example
- creating / Getting ready, How to do it...
- working / How it works...
- Salesforce.com
- connecting to, DashConn used / Getting ready, How to do it...
- working / How it works...
- Data Manager Connection / Salesforce.com Data Manager Connection
- Working Mode setting / Working Mode settings
- SAP Business Objects Enterprise
- exporting to / Exporting to SAP Business Objects Enterprise, Getting ready, How to do it...
- working / How it works...
- SAP BW
- about / Connecting to SAP BW
- and Dashboard Design connection, setting up / Getting ready, How to do it..., How it works...
- connecting to / How to do it...
- working / How it works..., How it works...
- variables, using / Using variables and filters
- filters, using / Using variables and filters
- Output Values / Other Output Values
- returned data format / Returned data format
- publishing to / Publishing to SAP BW, How to do it...
- SAP EcoHub
- URL / How to do it...
- scenarios, dashboard
- about / Using dashboard scenarios
- using, steps / How to do it...
- working / How it works...
- scorecard
- alerts, using / Using alerts in a scorecard, How to do it...
- working / How it works...
- SECOND function / Supported Excel functions
- shapefile / Getting ready
- SIGN function / Supported Excel functions
- SIN function / Supported Excel functions
- single values, Dashboard Design
- displaying, component type used / Illustrating single values, How it works...
- Gauge component, adding / How to do it...
- working / How it works...
- auto-scaling / Scaling
- Single Value | Gauge section / How to do it...
- SINH function / Supported Excel functions
- slide show
- about / Creating a slide show
- starting with / Getting ready
- creating / How to do it...
- working / How it works...
- Sizing Method / There is more...
- Transparency option / There is more...
- Sliding Picture menu / There's more...
- SLN function / Supported Excel functions
- SMALL function / Supported Excel functions
- software requirements , SAP Business Objects Dashboards
- supported operating systems / System and software requirements
- supported browsers / System and software requirements
- supported Flash players / System and software requirements
- supported Microsoft Office / System and software requirements
- SAP BusinessObjects Enterprise connectivity / System and software requirements
- SAP BusinessObjects Enterprise / System and software requirements
- SAP BusinessObjects Live Office / System and software requirements
- QaaWS / System and software requirements
- SAP NetWeaver BW / System and software requirements
- SAP Application Servers / System and software requirements
- Sort & Filter function / How to do it...
- Sorting settings
- Source Data component
- about / Data insertion with the Source data component
- starting with / Getting ready, How to do it...
- data, inserting / Getting ready, How to do it...
- working / How it works..., There is more...
- Source Data field / How to do it...
- sparklines
- about / Using sparklines
- configuring / Getting ready, How to do it...
- working / How it works...
- header labels / Header labels
- highest value, showing / Show low and high values
- lowest value, showing / Show low and high values
- spreadsheet
- cell, customizing / Making the spreadsheet more readable with colors
- comments, inserting / Gespreadsheetcomments, insertingtting ready
- borders, using / Making the spreadsheet more readable using borders
- named ranges, using / Using named ranges
- debugging / Debugging yourcell format, copyingFormat Painter, working spreadsheets
- debugging, steps / How it works..spreadsheetdebugging, steps.
- hotkey Ctrl+`, working / How it works..spreadsheetdebugging, steps.
- Formulas tab / There's more...
- SQRT function / Supported Excel functions
- stacked charts
- about / Other charts: stacked charts
- STANDARDIZE function / Supported Excel functions
- STDEV function / Supported Excel functions
- SUM function / Supported Excel functions
- SUMIF function / Supported Excel functions
- SUMPRODUCT function / Supported Excel functions
- SUMSQ function / Supported Excel functions
- SUMX2MY2 function / Supported Excel functions
- SUMX2PY2 function / Supported Excel functions
- SUMXMY2 function / Supported Excel functions
- SWF
- exporting to / How it works..., There's more...
- SYD function / Supported Excel functions
T
- tables
- customizing / Making tables look pretty, How to do it...
- working / How it works...
- tab set container
- about / Using the tab set container
- using / How to do it...
- working / How it works...
- best practices / There's more...
- TAN function / Supported Excel functions
- TANH function / Supported Excel functions
- TEXT function / Supported Excel functions
- themes
- about / Working with themes
- working with / How to do it..., How it works...
- TIME function / Supported Excel functions
- TIMEVALUE function / Supported Excel functions
- TODAY function / Supported Excel functions
- tree grid
- Micro Chart Suite, presenting / Presenting micro charts in a tree grid, How to do it...
- tree map
- about / Using the tree map
- using / How to do it...
- working / How it works...
- Trend Analysis tab / How to do it...
- trend analyzer component
- about / Analyzing trends
- starting with / Getting ready
- using / How to do it...
- working / How it works...
- More Options section / There is more...
- trend icon
- about / Showing a trend without a chart
- starting with / Getting ready
- working / How to do it..., How it works
- TRUE function / Supported Excel functions
- TRUNC function / Supported Excel functions
U
- .unv Universes -.unx conversion
- Information Design Tool, using / Getting ready
- UAC
- about / Getting ready
- Universe query
- about / Using Universe queries
- using / How to do it...
- working / How it works...
- Query Prompt Selector / Query Prompt Selector
- Query Refresh button / Query Refresh button
- UPPER function / Supported Excel functions
- URL Button component / How it works...
V
- VALUE function / Supported Excel functions
- valuesOf_parameter method / Methods
- VAR function / Supported Excel functions
- VDB function / Supported Excel functions
- VLOOKUP function / Supported Excel functions
- VLOOKUPs / Using Filtered Rows
W
- Web Intelligence
- integrating, with Antivia XWIS / Integrating Web Intelligence with Antivia XWIS, How to do it...
- Web Intelligence-Antivia XWIS integration
- starting with / Getting ready
- steps / How to do it...
- working / How it works...
- Antivia Slice and Dice component / Antivia Slice and Dice component
- Antivia Export component / Antivia Export component
- alerts / Alerts
- Antivia Timer component / Antivia Timer component
- dashboard offline, taking / Taking the dashboard offline
- WEBI report
- about / Getting ready
- opening up, dashboard parameters used / How to do it...
- working / How it works...
- OpenDoc URL / How it works...
- WEEKDAY function / Supported Excel functions
- WEEKNUM function / Supported Excel functions
- What-If scenario
- about / Using sliders to create a what-if scenario
- creating, slider used / Getting ready, How to do it..., How it works...
- Horizontal Slider component / How to do it...
- what-if scenario dashboard
- creating / What-if scenario: mortgage calculator, Getting ready, How to do it...
- Mortgage amount / How to do it...
- Mortgage term in years / How to do it...
- Yearly interest rate / How to do it...
- working / How it works...
- widgets / Creating Adobe Air Applets from Dashboard Design dashboard
- WORKDAY function / Supported Excel functions
- worsheet navigation
- steps / Navigation between worksheets, How to do it...
- working / How it works...
- worsheets
- selecting, with one click / Selecting all worksheet cells with one click, How to do it...
- one-click select, working / How it works..., There's more.worsheetsone-click select, working..
- nagivating through / Navigation between worksheets
X
- Xcelsius / Introduction
- feature / Introduction, Exporting to a standard SWF, PPT, PDF, and so on
- chart drilldown / Drilling down from a chart
- filter selector component / Using the Filter Selector component for hierarchies
- login functionality, password used / Getting ready
- user, alerting / Introduction
- dashboard, customizing / Introduction
- about / Introduction
- Microsoft Excel functions / Supported Excel functions
- Xcelsius Dashboards
- Adobe Air Applets, creating / Creating Adobe Air Applets from Dashboard Design dashboard, Getting ready, How to do it...
- Xcelsius Dashboards
- working / How it works...
- XML Maps... button / How to do it...
- XYahooMap / XGlobe and XYahooMap
- XY chart
- about / Getting ready
- using / Getting ready, HowXY chartusing to do it...
- working / How it works...
Y
- y-axis
- scaling / Scaling the y-range sliderworkingaxis, How to do it...
- working / How it works..., There is more...y-axisworking
- variable maximum limit, using / Variable maximum limits
- Zoom Out Only option, allowing / Allow Zoom Out Only
- YEARFRAC function / Supported Excel functions
- YEAR function / Supported Excel functions