InfoSol Blog We're Passionate About Business Intelligence

Business(s) and their units send hundreds to thousands of emails out via report scheduling. Delivering the correct reports to the right person is mission critical for efficient business process. Currently, a recall email feature exists for incorrect emails sent within network, but the recipients are notified of the email recall. ...

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

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

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

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

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

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

Business Intelligence is more than just reporting. It can be the lifeline of a business helping shape decisions, inspiring actions, and providing the right insights to the right people at the right time. To simplify it, Business Intelligence is: • What happened? (reporting, analytics, insights) • What is happening? (real ...

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

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

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

Millions of people around the world are affected by humanitarian crises, but luckily there are people all around the world that are willing to lend a helping hand. At IBIS 2018, we heard an inspiring story from our Most Valuable Dashboard Award Winner– the International Humanitarian City. The International Humanitarian ...

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

Tip: How to Document IDT Universe information Trick: Use Save as One of the features of IDT is to document all available setups that were performed on the business layer and data foundation of a .unx universe. In our example, we are going to document E-fashion Universe’s Business Layer. Prerequisites: ...

Buying a car has always been a challenging experience for me. I never know what to buy, when to buy, what features to include, and I definitely don’t enjoy the inevitable frustrating bartering with the sales and finance people. I also still haven’t figured out why I always end up ...