Xcelsius Tech Tip

From InfoSolBlog: how best to handle a 13 month dataset when in the dashboard the goal is to only display monthly detail and summary data. This is a good question and in my opinion worth sharing here because it is dealing with boosting Xcelsius backend performance

In addition to the Xcelsius Best Practices Tech Tips found on this site, you can also find helpful information on the InfoSolBlog site.  View all posts tagged Xcelsius Best Practices or select from those listed below:   To Cache or not to Cache – Boosting performance in Xcelsius Tech Tip …

Problem A: I have data that could be in the 1000s but sometimes could be 1 or 2.  Users do not want to see a division of 1.5 (or any part of a whole) since the data is tracking incidents and there are never “half incidents.”  How do I force …

Question: What is a Flash Variable connection and what is it used for?     Answer: Flash Variable connection is used to pass a variable from one dashboard or interface to the second dashboard.     Let us consider two dashboards here: a) Parent dashboard  – from which you will be passing a variable to the Child …

Question: How can I get user-specific data results for Xcelsius dashboards viewed through BusinessObjects InfoView? Answer: There are a few application variables that BusinessObjects provides for use when a user logs into InfoView, one of which is BOUSER.  BOUser is the variable for the userId that is logged in and can be …

Update: Xcelsius was phased out by SAP and our UK team built a no-code, dashboard building tool to help fill the void – Squirrel365. You can learn more about Squirrel365 right here. In this post I will share with you a sample of what I consider to be one of …

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: 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 …