Home / Tech Tips (page 4)

Tech Tips

Error – New 4.2 BI Commentary Service is Unavailable

I recently attempted to use the new Commentary Service available in Business Objects 4.2 to enter a comment in a Web Intelligence report. I received an error stating the “Commentary Service is unavailable”, and directing me to see my platform Administrator.  I saved the document, and tried the different ways to enter a comment, but to no avail.  The comment …

Read More »

Design and Development Best Practices for Mobile Dashboards

Design and Development Best Practices for Mobile Dashboards

The relevance of BI on mobile devices is not under question any more – we all have figured out the answer. The important question is now: how do we create our BI solutions to be as useful as possible on a mobile device? There are several facets to consider – the end user experience, the tool or the software, and ultimately …

Read More »

UI/UX Series – Empty States

<Part of the UI / UX series The focus of our first blog post in the UI / UX series is something called “Empty States”.  This is  considered very important in website and application development, but is not something you see a lot of in dashboard and BI content development.  We are usually more focused on how to display and …

Read More »

A structured approach to dashboard development

During our sessions at IBIS and on the Lets Speak BO webinar series Mel Sheppard and I talk about learning from other industries and not re-inventing the wheel when designing your BI content.  Specifically we suggest you to look at what web design and mobile application developers do to improve the usability of their products. There is a great deal …

Read More »

What to do when report design requirements call for customization beyond the default aggregation in Webi

So what do you do when the report design requirements for a webi report call for customizations beyond the default aggregation? Modifying Context to Customize Web Intelligence Calculations The default aggregation in Web Intelligence provides a dynamic way to transform data on the fly.  With simple drag, drop, and mouse click actions, numbers are automatically recalculated to reflect a user’s …

Read More »

Crystal Reports Export to Excel – Part 2

InfoSol Blog Tech Tip

It’s been a while since I published part 1 but hey, better late than never.  So here’s Part 2 of my previous blog “Crystal Reports Export to Excel – Part 1”. I have used the same report from Part 1. The following tips & tricks will help you in providing a perfect/clean export to Excel from Crystal Reports (Refer to the …

Read More »

Three Key Tips for Building Mobile Dashboards

InfoSol Blog Tech Tip

You walk into your office in the morning. You’ve double-checked your inbox and meeting schedule on your phone on your way in. You whip out your tablet and quickly go through the morning reports. Your everyday necessities are quickly becoming all available at the touch of your mobile devices. But what about your dashboards? Are they being deployed on mobile …

Read More »

Excel in “Crystal Reports Export to Excel” – Part 1

InfoSol Blog Tech Tip

In one of my recent client engagements, there was a requirement to replace Microstrategy reports to Crystal Reports. The business users were not ready to compromise on the format of Excel. I created a crystal report with Microstrategy SQL and used InfoBurst – Infosol’s flagship bursting product to deliver these excel files. I created this simple, straight forward crystal report …

Read More »

Crystal Reports with Top N Based on a Date Dimension

InfoSol Blog Tech Tip

We have seen various ways to create reports like Top 10 Customers by Sales, Top 10 Cities by population, Top 5 countries by profit Margin etc. It’s usually Top N by a <Measure>. What if there’s a requirement Top N by a <Date> or Most Recent N by a <Date>? Consider the scenario where a store manager likes to see …

Read More »