IBIS 2011 kicked off last night with its welcome reception and solutions showcase demonstrating some of the latest business intelligence solutions and one solution in particular created quite a buzz – MyBI Mobile. As I walked around the showcase showing Xcelsius dashboards running on an iPad, people stopped with looks ...
Read More »To Cache or not to Cache – Boosting performance in Xcelsius Tech Tip
I was recently asked this question on 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 ...
Read More »Rod Stewart and Business Intelligence in Concert
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 ...
Read More »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 ...
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 ...
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 ...
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 ...
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 ...
Read More »