The Public Sector dashboard provides an overview of sources of income, distribution by department and special projects in the fictional City of Freemont. The dashboard landing page shows a summary of different income sources such as Sales Taxes, Property Tax, Permits, etc., along with a brief description. The pie chart …

The Retail Sales, Spend Performance and Analysis dashboard is used to look at Revenue by Month, Region and Product Category. It also shows Spend Performance by Region, Supplier and Sub-categories. The dashboard quickly and efficiently analyzes large volumes of data. The summarized information and trends make it simple and straightforward …

The setting for the Professional Services Dashboard is the consulting division of the company. This interactive dashboard is useful for an account manager overseeing several consultants and clients. The home page of the dashboard provides a current overview of the company’s metrics. The Partner Receivables and WIP (Work In Progress) …

  The Life Sciences dashboard was designed for a hypothetical Pharmaceutical company.  This company has U.S. sales in four distinct regions: North, East, South, and West.  Each region sells into four channels or sales lines: Pain Management, Endocrinology, Oncology, and Cardiology.  Each channel, in turn includes four pharmaceuticals.  There is …

Question: I often need to display Boolean data on my reports, but am looking at other ways to represent this other than just “True” or “False.” Is it possible to do this – for example, could it be set up to display check boxes instead?   Answer: Yes, it is …

Question: How can I dynamically change the colors on my charts or backgrounds based on user selection?   Answer: Kudos to the Xcelsius development team SAP Business Objects for giving us so much in SP3! One of the great new features is the option to bind the color to a …

Question: Wouldn’t you like a way to visually show/compare your data right at the detail-level? Answer: With a little preparation and some simple formulas, it can be yours. Explanation This Tech Tip uses the Customer Table from the Sample Database that comes with Crystal Reports. Also, I am working with …

Question: In Xcelsius, can I use the “Filtered Rows” functionality to move and filter data from one place to another? Answer: Yes, however, if you use that functionality directly from an interactive selector, then only one set of data will be able to be moved. In this example, we have …

Question:  Have you noticed that sometimes when using a progress bar you are unable to change the settings on the “Progress Movement?”  That it will appear grayed out? Answer: This is due to selecting a cell for the Data in the “General” tab where no values are currently populated. To …

Question: Multiple-tabbed Dashboards, with many formulas and components, take a long time to load into a web browser. To lessen the initial load time, we elected to create separate html/swfs for each tab and link them by URL. Some users want an easy way to open all the html/swfs at …