InfoSol Blog We're Passionate About Business Intelligence

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

One truly inspiring moment of IBIS 2019 was the Annual InfoSol Dashboard Awards. The InfoSol Dashboard Awards is an international competition showcasing dashboard developers and organizations innovation in business intelligence. The categories are as follows: Best Business Dashboard Award Limitless Business Intelligence Dashboard Award Most Valuable Dashboard Award Dashboards continue ...

Onsite at a client location, I asked “What is the main function of I.T.?” A client responded, “It’s keeping up with technology!”  In our world, we are constantly bombarded with upgrades and future migrations. Today, I am sharing my knowledge as an expert in BusinessObjects landscape assessments, migrations and upgrades. ...

First: To capture the value selected in Input Control/ Element Link in a cell Goal: Input Control and Element Linking are very frequently used WebI features to create highly interactive WebI reports or dashboards. The goal is to display the user selected option from the radio button/drop down/list box or ...

This year’s SAP Sapphire conference started somberly with SAP CEO Bill McDermott attempting to paint a rosy picture of the world of SAP. The conference concluded with the high energy and excitement of a fabulous Lady Gaga concert where she confessed that after much research she didn’t have a clue ...

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

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

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