Tech Tip

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 format …

Lately we have noticed issues with a lot of customers regarding their BO auditor not working due to lot of Audit files being present in the Auditing folder. So, here is tip for administrators to include as a part of their Application Maintenance list, which helps make sure the auditor …

This Web Intelligence Dashboards course is designed to help you deliver dynamic and interactive data using all the newest features of Web Intelligence. We dive into three use cases with Alerting, Strategic, and Analytical dashboards while along the way providing in-depth formatting and formula skills. Although we allow beginners, this …

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 …

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 …

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

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 …

What if you took the world’s most used Business Intelligence suite, BusinessObjects, and the world’s leading Business Intelligence self-service data discovery and visualization tool, Tableau, and found a way to bring them together to make the world’s most awesome Business Intelligence offering? You can learn how McKesson did just that, in …

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 formulas. When …

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 …