Have you been forced to buy a new cell phone because there are no new app updates available? And whenever you see someone else’s phones, they operate faster than yours does and have all the latest features? The average life of a handset in the U.S. is about 21 months, …

SAP Dashboards/Xcelsius has long been favored as a tool that creates interactive applications without the need for coding knowledge.  Although sold under “dashboarding”, its use of Excel as a development mechanism made it an instant hit for non-coders who already knew how to use Excel to manipulate data arrays and …

Tip: Error found at 00 Trick: Truncating datetime to seconds We recently worked with a customer to provide a solution to a datetime field in their PI SQL database (OSI) that was returning a SQL parsing error when using it in a query filter.  Specifically, the error stated “Error found at 00”. …

The Filtered Rows option for selectors has provided a very valuable tool for XCelsius designers and is probably used in 99% of dashboards created with this tool.  It essentially allows us to select unknown multiple of out of order rows based upon a value in the rows.  There are times, …

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 …