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 ...

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 ...