SAP BusinessObjects Dashboards 4.0 - Spreadsheets


How to prepare Excel spreadsheets

Before you import an Excel spreadsheet, make sure the spreadsheet provides a good structure for
achieving the best performance for models.
Consider the following guidelines:
- Use only supported Excel functions
For a list of supported Excel functions, see Supported Excel functions.
- Use these Excel functions with small data sets only
The following Excel functions are supported in Dashboard Design and Presentation Design, but can
affect the model's performance if used with larger data sets (over 100 rows):
• SUMIF
• COUNTIF
• HLOOKUP
• VLOOKUP
Note:
If you must access larger data sets, have the server or database perform the aggregation on the
server side.
- Organize your data in a logical fashion
To make your spreadsheet easier to understand, lay out your data in a logical fashion. Group related
items together and use colors, labels, and borders to describe the structure and function of cells.
- Use colors, labels, and borders to identify data types (input and output)
To make it easier to maintain your visual models, use colors, labels and borders to identify cells or
ranges of cells in the spreadsheet and to describe their use. Adding a legend that describes what
the colors represent helps maintain consistency and usability of the model.
- Place frequently used data and logic at the top of the spreadsheet
To make it easier to select the data you want to bind to components and minimize the amount of
scrolling required, place frequently used or common logic or data at the top-left of the tab in your
spreadsheet.
- Use multiple tabs
If your spreadsheet becomes large and requires a lot of scrolling to see your logic or data, consider
separating data into multiple tabs (or worksheets).

See Also:
Sap BO Dashboards 4.0 - Xcelsius 2008

Sap BO dashboards 4.0 New features

Sap BO 4 Live office

Sap BO 4 OpenDocument

Using Microsoft Excel in BO Dashboards 4.0

BO dashboards performance

Comments

Post a Comment

Popular posts from this blog

SAP Dashboard Error - Cannot find the BusinessObjects Enterprise report source. (LO 26608)

<!-- Google tag (gtag.js) --> <script async src="https://www.googletagmanager.com/gtag/js?id=G-NL0CYP13VZ"></script> <script>   window.dataLayer = window.dataLayer || [];   function gtag(){dataLayer.push(arguments);}   gtag('js', new Date());   gtag('config', 'G-NL0CYP13VZ'); </script> Cannot find the BusinessObjects Enterprise report source. (LO 26608) Environment SAP BO XI 4.1 SP 5 two nodes Cluster Windows Server 2012 While refreshing dashboard (based on Live Office connection) from BI Launchpad with a no administrator user the above exception was erased. SAP says: Cause The document is not available; for example it does not exist, or it has been removed. Action Check the report path from CMS and use SetLocation in Live Office to re-define the report source. Otherwise, check if the user has sufficient rights to view the object. Solution In our case  we fixed this problem was to remo
Read more

SAP HANA Introduction

Image
SAP HANA:The future of database technology The capacity of main memory in servers has continuously increased over the years, whereas prices have dramatically dropped. Today, a single enterprise class server can hold several  terabytes of main memory. At the same time, prices for server main memory dramatically  dropped over the last few decades. This increase in capacity and reduction in cost makes it a  viable approach to keep huge amounts of business data in memory. This section discusses  the benefits and challenges. In few words you can understand SAP HANA plus  analyzing this evaluation: Typical access speeds Disk     4,000,000 ns Memory         0.4 ns Speed   10,000,000 Falling prices move processing from Disk/SSD to In-Memory In-Memory Computing The elements of In-Memory computing are not new. However, dramatically improved hardware economics and  technology innovations in software has now made it possible for SAP to deliver on its vision of the
Read more

SAP BusinessObjects 4.0 - Suite Presentation

Image
The latest Business Objects Suite, B.O. 4.0,  is suitable for every kind of user from top managers to simple clerk. It has a new  styling and unified look and feel in every tool of the suite. It garantees common query design experience across all data sources. It allows interactivity with shared charting, alerting, and search options. B.O. 4.0  has a new information design tool for heterogeneous access over all sources that represents  abstraction layer for multi-dimensional data sources. Beside it allows: A simplified, Right-Scale Deployment Enhanced scalability with virtualization and native 64-bit support Comprehensive system diagnosis and monitoring New auditing for compliance and usage analysis. New User Experience SAP BusinessObjects Mobile BI  Interactive Reports & Dashboards Allows to: Make informed decisions with instant access to personalized information Leverage existing BI investments & skills to quickly reach mobile users E
Read more