I just saw Rod Stewart in concert last week and he was truly awesome. The musicians and singers supporting him were just fantastic and the whole set was so tight and so professional. It felt as though they had been playing together for years but they actually had only started rehearsing a couple of months ago. Of course, Rod Stewart …
Read More »Tech Tips
Leading Zeros in Xcelsius – Tech Tip
What can I do if Xcelsius is chopping off the leading zero’s in my order numbers? This question comes up often when I’m teaching an Xcelsius training class. Often enough that I’ve decided to discuss the solution here in a tech tip on our blog. This scenario can happen with different data sources (XML, Live Office, Qaaws) when a number string is …
Read More »Two Advantages of a Manual Maximum Calculation in Xcelsius
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 the values to integers without losing the divisors for the …
Read More »Passing Flash Variables
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 dashboard b) Child dashboard – this will consume the …
Read More »How to Implement “BOUSER” Row-Level Security in Xcelsius QAAWS and Live Office Connections
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 used when Xcelsius is aware of the user …
Read More »Text Formatting Your Way in Crystal Reports
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 format a text object is to right-click on it and …
Read More »