InfoSol Blog We're Passionate About Business Intelligence

Tip: How to use Chart Ranking with Dynamic Visualization in Xcelsius (SAP Dashboards) Trick: Creating Dynamic Visualization that works with Chart Ranking Are you wanting the dynamic visibility to work with the values corresponding rank on a chart? This can actually be achieved in a couple simple steps and excel ...

While the built in alternate row shading is nice to shade every other row or a set a pattern of rows, what if you wanted to shade rows based on a variable number of rows in a break?  We can accomplish this by using a variable and a conditional formatting ...

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

The BusinessObjects community gathering at IBIS 2019 was totally amazing and, once again, walked away with the “Best IBIS Ever” accolade. Over 50 attendees pre-registered for IBIS 2020 during the conference itself! I experienced so many eye-opening presentations, inspiring sessions and great conversations that I was not sure where to ...

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

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