Inserting data with the Source Data component
by David Lai, Xavier Hacking
SAP BusinessObjects Dashboards 4.1 Cookbook
- SAP BusinessObjects Dashboards 4.1 Cookbook
- Table of Contents
- SAP BusinessObjects Dashboards 4.1 Cookbook
- Credits
- Foreword
- About the Author
- Acknowledgments
- About the Author
- Acknowledgments
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Staying in Control
- Introduction
- Using the Object Browser
- Searching for components
- Grouping the canvas components
- Making the spreadsheet more readable with colors
- Making the spreadsheet more readable with comments
- Making the spreadsheet more readable with borders
- Using named ranges
- Copying the format of one cell to another cell or range
- Debugging the spreadsheets
- Navigating between worksheets
- 2. Data Visualization
- Introduction
- Adding a line chart to your dashboard
- Using a bullet chart
- Using sparklines
- Using a combination chart
- Using a waterfall chart
- Using a pie chart
- Using a scatter plot chart
- Using a bubble plot chart
- Using a radar chart
- Using an OHLC chart and a candlestick chart
- Sorting series
- Zooming in on charts
- Scaling the y-axis
- Using a tree map
- Showing a trend without a chart
- Displaying raw data
- Illustrating single values
- 3. From a Static to an Interactive Dashboard
- Introduction
- Selecting your data from a list
- Drilling down from a chart
- Using the Filter selector component for hierarchies
- An alternative hierarchy selection method
- Using the Hierarchical Table
- Using Filtered Rows
- Using maps to select data of an area or country
- Adding a Mac OS X-looking dock to your dashboard
- Resetting your data (the reset button)
- Making selections from a custom image (the push button and image component)
- Inputting data values
- Using the Play Selector / Play Control component
- Opening up a Web Intelligence report using dashboard parameters
- Selecting calendar dates
- Using sliders to create a what-if scenario
- 4. Dynamic Visibility
- 5. Using Alerts
- 6. Advanced Components
- 7. Dashboard Look and Feel
- Introduction
- Changing the look of a chart
- Adding a background to your dashboard
- Using color schemes
- Sharing a color scheme
- Working with themes
- Making component colors dynamic
- Dynamic XY positioning and sizing of components
- Using the Panel Container
- Using the Tab Set container
- Making tables look pretty
- Using quadrants smartly
- Creating/using a dashboard template
- 8. Dashboard Data Connectivity
- 9. Exporting and Publishing
- 10. Top Third-party Add-ons
- Introduction
- Managing add-ons in SAP BusinessObjects Dashboards
- Connecting to CSV files with the CSV Connector
- Integrating Google Maps with the CMaps plugin
- Connecting to Salesforce.com with DashConn
- Presenting micro charts in a Tree Grid
- Integrating Web Intelligence with Antivia XWIS Advantage Express
- Advanced printing with Xcelsius Dashboard Printer
- SUCCESS with graphomate charts
- 11. Performance Tuning
- 12. Increasing Productivity
- Introduction
- Using the Spreadsheet Table component to debug
- Time-saving tips during dashboard development
- How to do it…
- Global Fonts
- Grouping from the Object Browser versus grouping with a Canvas Container
- Editing multiple components at once
- Using the alignment, sizing, and spacing buttons
- Using the arrow keys for precise placement of components
- Using the Grid to help with relative positioning
- Copying objects from another dashboard
- How to do it…
- Fixing corrupt XLF files
- A. Real-world Dashboard Case Studies
- B. Additional Resources – Supported Excel Functions and System/Software Requirements
- C. The Future of Dashboarding with SAP Design Studio
- Index
The Source Data component enables us to insert data into spreadsheet cells by changing the selected index value of the component. This is a different approach to inserting data than the one we saw in Chapter 3, From a Static to an Interactive Dashboard, when we were discussing selectors and drilldowns.
Open a new SAP BusinessObjects Dashboard file and enter the following data into the spreadsheet:
- Drag a Pie Chart component into the canvas.
- Bind the Chart field to cell B3 and leave the Subtitle field empty.
- Bind the Data | Values field to the spreadsheet range from C3 to E3. Select the Data in Rows option.
- Bind the Labels field to cells C5 to E5.
- Drag a Horizontal Slider component to the canvas.
- Bind the Data field to cell B1.
- Set Minimum Limit to
0and Maximum Limit to3. - Now drag the Source Data component into the canvas:
- Set Insertion Type as Row.
- Bind the Source Data field to cell range B6:E9.
- Bind the Destination field to cells B3:E3:
- Go to the Behavior tab. Bind the Selected Item Index field to cell B1:
- Preview the dashboard:
As mentioned in the introduction of this recipe, the Source Data component has the same data insertion functionality as selector components and drilldowns from charts. But, the data insertion of the Source Data component is triggered by a changing value in a spreadsheet cell and not directly by a user interacting with a component.
In this recipe, we used the Horizontal Slider component to change a cell value (cell B1) to trigger the data insertion. But you can, of course, also use this component in combination with Excel formulas, Dynamic Visibility, or the data inserted by other components.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.