Many business users require similar report content with minor formatting differences. Rather than create individual, customized reports for each business user the report writer can leverage input controls and conditional formatting to put the power of customization back into the hands of the business users. Below is a sample of ...
Read More »Migration — What to expect
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 ...
Read More »Tech Tip: How to use System Configurations
Tip : How to use System Configurations A system configuration defines a set of datastore configurations that can be used at job runtime. System configurations are used to execute the same logic against different datastore environments. Migration is faster between environments. Steps: Right click an existing data store and click ...
Read More »Tech Tip: Sometimes just because you can…The IDT Lemming Rule
Sometimes just because you can, doesn’t mean you should. Although sometimes it pays to break that rule, in many cases it is the one rule that we pass on to our kids that we most hope they follow. And so, it follows that maybe it was the one rule our ...
Read More »Tech Tip: Dashboard Design Like a Pro Using Design Software
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 ...
Read More »Using an Input Control to Sort in Web Intelligence
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 ...
Read More »Tech Tip: Controlling Break Dimension Using Input Control
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 ...
Read More »Tech Tip: How to Use Chart Ranking with Dynamic Visualization in Xcelsius (SAP Dashboards)
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 ...
Read More »Tech Tip: Alternate Break Value Highlighting
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 ...
Read More »Migrating to 4.2 SP7: Use patch 400 for SAP Dashboards/Xcelsius
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 ...
Read More »