InfoSol Blog We're Passionate About Business Intelligence

This blog is aimed at Xcelsius users who want to migrate their .xlfs into Squirrel. To everyone else — don’t let this put you off, it’s still an interesting read and you might pick up a few hints and tips along the way. The first thing to know is Our ...

In just the last three days I received three fascinating dashboards. The first was from Microsoft, called MyAnalytics, showing my work habits for the last week based on my Microsoft Outlook usage. It showed I had spent almost 80% of my time in email activities and 20% in meetings (not ...

I have been designing dashboards with Xcelsius and Custom Code (HTML5) the past couple of years and I wanted to share how you can design dashboards like a pro. Personally, I am an advocate for designing dashboards with Adobe Illustrator. I found it the easiest to learn.  You can choose ...

Have you been forced to buy a new cell phone because there are no new app updates available? And whenever you see someone else’s phones, they operate faster than yours does and have all the latest features? The average life of a handset in the U.S. is about 21 months, ...

Twenty-five years ago on July 13, 1994 I went to see the legendary band, The Eagles, play at the old Tiger Stadium in Detroit. The Tour was called the Hell Freezes Over Tour, since the band had broken up many years before they said they would only ever play together ...

In Design mode of Web Intelligence, you can change the sort order of columns in a block.  However, this option is not available in Reading mode.  We can accomplish some basic sorting tasks using an input control and the steps below will detail how this is done. We’ll start off ...

In this tech tip, you will learn how to dynamically switch a break dimension using an input control.  We will start with a cross table that was created in the Alternate Break Value Highlighting tech tip, but you can substitute any 2 dimensions you would like to work with.  This ...

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