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

I recently heard a story on the radio about a farmer in England who had secretly built a castle behind a wall of haystacks so the local planning authority would not find out. He had been denied permission to build the castle but he did some research and discovered what …

Question: Have you ever created a formula, to build a string of text, and wanted to format parts of it separately? Answer: Use HTML codes to format your string.     Explanation This Tech Tip uses the Customer Table from the Sample Database that comes with Crystal Reports. The easiest way to …

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 …