Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying SAP BusinessObjects Dashboards 4.1 Cookbook
  • Table Of Contents Toc
  • Feedback & Rating feedback
SAP BusinessObjects Dashboards 4.1 Cookbook

SAP BusinessObjects Dashboards 4.1 Cookbook

By : David Lai
4.9 (8)
Buy this Book
close
close
SAP BusinessObjects Dashboards 4.1 Cookbook

SAP BusinessObjects Dashboards 4.1 Cookbook

4.9 (8)
By: David Lai
Buy this Book

Overview of this book

If you are a developer with a good command and knowledge of creating dashboards, but are not yet an advanced user of SAP BusinessObjects Dashboards, then this is the perfect book for you. Prerequisites include a good working knowledge of Microsoft Excel as well as knowledge of basic dashboard practices.
Table of Contents (17 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Staying in Control
chevron up
Icon
1. Staying in Control
Icon
Introduction
Icon
Using the Object Browser
Icon
Searching for components
Icon
Grouping the canvas components
Icon
Making the spreadsheet more readable with colors
Icon
Making the spreadsheet more readable with comments
Icon
Making the spreadsheet more readable with borders
Icon
Using named ranges
Icon
Copying the format of one cell to another cell or range
Icon
Debugging the spreadsheets
Icon
Navigating between worksheets
2
2. Data Visualization
Icon
2. Data Visualization
Icon
Introduction
Icon
Adding a line chart to your dashboard
Icon
Using a bullet chart
Icon
Using sparklines
Icon
Using a combination chart
Icon
Using a waterfall chart
Icon
Using a pie chart
Icon
Using a scatter plot chart
Icon
Using a bubble plot chart
Icon
Using a radar chart
Icon
Using an OHLC chart and a candlestick chart
Icon
Sorting series
Icon
Zooming in on charts
Icon
Scaling the y-axis
Icon
Using a tree map
Icon
Showing a trend without a chart
Icon
Displaying raw data
Icon
Illustrating single values
3
3. From a Static to an Interactive Dashboard
Icon
3. From a Static to an Interactive Dashboard
Icon
Introduction
Icon
Selecting your data from a list
Icon
Drilling down from a chart
Icon
Using the Filter selector component for hierarchies
Icon
An alternative hierarchy selection method
Icon
Using the Hierarchical Table
Icon
Using Filtered Rows
Icon
Using maps to select data of an area or country
Icon
Adding a Mac OS X-looking dock to your dashboard
Icon
Resetting your data (the reset button)
Icon
Making selections from a custom image (the push button and image component)
Icon
Inputting data values
Icon
Using the Play Selector / Play Control component
Icon
Opening up a Web Intelligence report using dashboard parameters
Icon
Selecting calendar dates
Icon
Using sliders to create a what-if scenario
4
4. Dynamic Visibility
Icon
4. Dynamic Visibility
Icon
Introduction
Icon
Switching between different charts
Icon
Building a pop-up screen
Icon
Creating a mouseover help text popup
Icon
Password protecting your dashboard
5
5. Using Alerts
Icon
5. Using Alerts
Icon
Introduction
Icon
Adding alerts to a column chart
Icon
Making alert ranges dynamic
Icon
Displaying alerts on a map
Icon
Displaying alerts of different thresholds on a map
Icon
Using bindable colors to control alert coloring from a central location
Icon
Using alerts in a Scorecard
6
6. Advanced Components
Icon
6. Advanced Components
Icon
Introduction
Icon
Printing your dashboard
Icon
Grouping and organizing components with the Canvas Container
Icon
Using dashboard scenarios
Icon
Using the Grid component
Icon
Creating a slideshow
Icon
Using the Panel Set component
Icon
Using the History component
Icon
Inserting data with the Source Data component
Icon
Analyzing trends
7
7. Dashboard Look and Feel
Icon
7. Dashboard Look and Feel
Icon
Introduction
Icon
Changing the look of a chart
Icon
Adding a background to your dashboard
Icon
Using color schemes
Icon
Sharing a color scheme
Icon
Working with themes
Icon
Making component colors dynamic
Icon
Dynamic XY positioning and sizing of components
Icon
Using the Panel Container
Icon
Using the Tab Set container
Icon
Making tables look pretty
Icon
Using quadrants smartly
Icon
Creating/using a dashboard template
8
8. Dashboard Data Connectivity
Icon
8. Dashboard Data Connectivity
Icon
Introduction
Icon
Creating a news ticker with Excel XML Maps
Icon
Using Query as a Web Service (QaaWS)
Icon
Using Live Office Connection
Icon
Using BI Web Services to consume a Webi report
Icon
Using the SAP NetWeaver BW Connection
Icon
Using the Query Browser
Icon
Passing values from dashboard to dashboard with Flash Variables
9
9. Exporting and Publishing
Icon
9. Exporting and Publishing
Icon
Introduction
Icon
Exporting to SWF, PPT, PDF, and other file types
Icon
Publishing to SAP BusinessObjects BI Platform
Icon
Housing your dashboard in a BI Workspace
Icon
Publishing to SAP BW
Icon
Going mobile
10
10. Top Third-party Add-ons
Icon
10. Top Third-party Add-ons
Icon
Introduction
Icon
Managing add-ons in SAP BusinessObjects Dashboards
Icon
Connecting to CSV files with the CSV Connector
Icon
Integrating Google Maps with the CMaps plugin
Icon
Connecting to Salesforce.com with DashConn
Icon
Presenting micro charts in a Tree Grid
Icon
Integrating Web Intelligence with Antivia XWIS Advantage Express
Icon
Advanced printing with Xcelsius Dashboard Printer
Icon
SUCCESS with graphomate charts
11
11. Performance Tuning
Icon
11. Performance Tuning
Icon
Introduction
Icon
Improving Excel spreadsheet performance
Icon
Using scheduled Webis to save on querying time
Icon
Running connections after loading the dashboard
Icon
Checking master data loading performance of connections
Icon
Optimizing BEx Query performance
Icon
Using Fiddler to identify the cause of performance issues
12
12. Increasing Productivity
Icon
12. Increasing Productivity
Icon
Introduction
Icon
Using the Spreadsheet Table component to debug
Icon
Time-saving tips during dashboard development
Icon
Fixing corrupt XLF files
13
A. Real-world Dashboard Case Studies
Icon
A. Real-world Dashboard Case Studies
Icon
What-if scenario – Mortgage Calculator
Icon
Sales/Profit dashboard example
14
B. Additional Resources – Supported Excel Functions and System/Software Requirements
Icon
B. Additional Resources – Supported Excel Functions and System/Software Requirements
Icon
Online resources
Icon
Supported Excel functions
Icon
System and software requirements
15
C. The Future of Dashboarding with SAP Design Studio
Icon
C. The Future of Dashboarding with SAP Design Studio
Icon
What is SAP BusinessObjects Design Studio?
Icon
SAP BusinessObjects Dashboards versus SAP BusinessObjects Design Studio
Icon
What is the SAP roadmap for dashboarding?
16
Index
Icon
Index

Using the Object Browser

The Object Browser has a number of features which come in very handy during the development of a complex dashboard. In this section, we will discuss hiding, locking, and ordering of components.

Getting ready

Drag several components to the canvas.

How to do it...

  1. Go to the Object Browser.
  2. Click on the dot in the first of the two columns on the right side of the Object Browser for the component that you want to hide. The dot turns into a checkmark. As you can see, the component now disappears from the canvas.
    How to do it...
  3. Now click on the dot on the right for any of the components.
  4. Try to move the component or make any other change to it.
  5. As you'll see, the component is completely locked and doesn't change.
  6. Make sure some of your components are on top of each other in the canvas. We now want to use the Object Browser to rearrange these overlapping components.
  7. Select the component in the Object Browser that is on top of the list.
  8. Click the arrow down button in the Object Browser multiple times until the component is on top of all the other components.
  9. As you can see, the component shifts all the way to the top.

How it works...

As we have seen in this recipe, we can hide components and/or groups of components, which will make your life easier if you are using a lot of overlapping components. By checking Hide for some components, you won't be bothered by these and you can work with the others that are unhidden.

Note

There is one thing you should keep in mind. If you hide a component that is part of a group but the group itself is unhidden, the complete group will still be movable and its properties will be changeable.

Also, we saw that we can lock one or more components or groups of components. Doing this makes it impossible to select these components, so it won't be possible to move, change, or do anything else with them. In this way you can be sure you won't accidentally alter these components.

Note

Hiding and/or locking a component from the Object Browser only hides and/or locks that component during the development of a dashboard. When you preview or execute the dashboard, the component will appear again and function normally.

Finally, we changed the order of components on the canvas. This is an important feature when we are using overlaying components in our dashboard.

To move a component on top of all other components, you can also right-click on it and select the Bring To Front option. Send To Back will move the component all the way down. The options Bring Forward and Send Back do the same as the arrows in the Object Browser: they move the component one step up or down at a time.

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
SAP BusinessObjects Dashboards 4.1 Cookbook
End of Section 1
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon