There has been a lot of talk and hype about PowerBI in the last couple of years. Some of that has been fueled by the infamous Gartner BI Magic Quadrants which, once again, seem to be out of touch with the reality on the ground. With more than 40% of ...
Read More »
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 ...
Read More »
I have always been fascinated by butterflies. I used to catch them as a kid with my little butterfly net and put them in jars where I could watch them. I quickly noticed they would not open their wings very much and could not fly so I would let them ...
Read More »
Tip: How to stop Windows 10 Update from breaking Xcelsius (SAP Dashboards) Trick: Easy install of a patch or Service Pack Has a recent windows update caused your SAP Dashboards to stop working? It may well be a recent Windows update for Windows 10 which includes some security updates for ...
Read More »
As I look back on 2018 and all the amazing BI solutions I saw created, there was one that really stood out in terms of its impact on the world that left me both awestruck and humbled. It was a solution created for the International Humanitarian City (IHC) based in ...
Read More »
One of the often overlooked additions given to us in the 4.2 SP3 release was the ability to merge data on variables, not just dimensions. For many years we have lived with these restrictions in Web Intelligence: 1.) You could only merge on dimensions, not on variables. 2.) The data ...
Read More »
Tip: How to pick up User Token or ID from HTTP Headers for use in a Dashboard. Trick: Use InfoBurst to inject the value into the dashboard. Figuring out security in your dashboards can often be one of the more difficult pieces to solve. Often times, we’re able to make ...
Read More »
The Let’s Speak BO Webinar series that began in the winter of 2015 just recently concluded its third straight year of bi-weekly Business Intelligence Webinars with a fantastic close. Adam Lange, with A. Lange Consulting, lead a jam packed session dedicated to all of the new things our BusinessObjects community ...
Read More »
Tip: How to Skip Dataflows for Testing or Restarting a Job for Recovery Trick: Use Bypass One of the greatest features of SAP Data Services is the ability to divert dataflows/workflows in a large workflow or job with multiple steps. This becomes very important when performing system testing or an ...
Read More »
On a recent vacation in Mexico, I attended a class to learn how to dance salsa. Now, I have two left feet when it comes to learning any structured dances. I can do the count in my head and I can do the steps with my feet, but I can ...
Read More »