Thursday, December 9, 2010

Beauty is in the Eye of the Beholder

Several years ago, I saw an exhibition of surrealist paintings in Paris including works by Salvador Dali and Joan Miro. I found the Dali paintings visually stunning as well as fascinatingly compelling whereas I had a hard time understanding the Miro ones. Others, who were with me, expressed the complete opposite opinion and loved the Miro work but had little time for the Dali pieces.

We all have different likes and dislikes to visual images whether they are paintings, cars or even business intelligence dashboards. I can personally testify to the dashboards since our company has developed over 400 of them in the last four years and they come in all shapes, sizes and visual tastes. I remember one particular dashboard that we developed for a transportation company that I thought was very visually stunning and provided multiple levels of drill down and some very powerful “What if?” scenarios. While the manager at the company also liked it a lot, his director felt it was not stunning enough and wanted different colors and more 3-D components. They both felt the dashboard met their functional needs but for the look it really just boiled down to a matter of personal taste.

The beauty of a dashboard tool like Xcelsius is that it allows you to design and cater to all these different tastes. You have a wealth of components, colors, themes and templates available and, if this is still not enough, you can develop your own.

While some people prefer simple dashboards with clear sharp components, others may prefer a more complex and richer look. If you do not like pie charts and certain colors, you do not have to use them.

Dashboard design is an art but the key to designing an effective, as well as a visually pleasing, dashboard is not to read books about the subject and it is also not to hire a graphic artist. The key is to sit down with the people who are going to be using the dashboard and to understand what they want to see and how they want to view and interact with it. While this may sound too simplistic, it is not. Of course, there can be room for visual enhancement and “cool” features but only if they serve a purpose.

There are many dashboard products on the market today that provide limited views and components so that you often have to force fit your requirements into what is available within the product. Xcelsius, on the other hand, allows you to design and create dashboards in an almost infinite number of ways and you are only limited by your imagination (or your user’s requirements).  As to how they look, it is doubtful you will ever please everyone but remember that beauty is in the eye of the beholder.

For a gallery of Xcelsius dashboards designed by INFOSOL and defined by customers, visit INFOSOL’s Dashboard Gallery

Paul Grill started his career in Information Technology in the U.K. in 1978, as an Executive Data Processing Trainee for Honeywell. More than thirty years later, he still has a voracious appetite for learning as Information Technology continues to advance at an ever accelerating pace. He was first introduced to the world of Business Intelligence in 1991, in France, when he saw a demonstration of an early version of BusinessObjects on Windows 2.1. He returned to the U.S. to rave about this phenomenal product, but it was many years before BusinessObjects made it into the mainstream. Paul founded InfoSol in 1997, and made Business Intelligence one of the key solutions offered by the company. Today, InfoSol is a leading SAP BusinessObjects solutions partner, known for its expert consulting, education and innovative add-on solutions. Paul is well known within the SAP BusinessObjects community for his extensive knowledge of Business Intelligence, and he has lectured and written many articles on the subject. Paul enjoys writing, running and coaching kids soccer, and is passionate about Ancient Egyptology.

View the original article here

Open document statement opens only in html viewer Crystal Reports

Posted on 14 April 2010 8:54 am.Femke

In BOXI 3.1 the opendocument statement for Crystal Reports opens the reports only in the html-viewer.

The commands are thus:
&sType=rpt&sOutputFormat=H

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.


View the original article here

Monday, December 6, 2010

2008 Electoral College Calculator based on WSJ design.

Here is an interactive calculator to predict the future President of the USA. Design concept from the Wall Street Journal Electoral College calculator. I tried my best to replicate the functionality. Hope you’ll alll like it. Please leave a comment as a feedback.

Click Here for the calculator.


View the original article here

Request post

Post Removed

3 Steps in Creating Your First Report

So, you’ve been told you need to start using Crystal Reports. It’s installed on your machine and you’ve opened it.  Now how do you get started?

The good news is that you don’t need to be a programmer or a database expert. However, you will need to be aware of the business requirements
for the report, how the report will be distributed, and be familiar with the data in the database.  Assuming you have this knowledge, you can jump right in:

To begin, within Crystal Reports, indicate to Crystal what kind of a database it is and where it is stored.  You will likely need to get this information from someone else in your organization.The second step is to choose the tables that store the required data and be sure the tables are joined correctly to provide the correct records that will meet the requirements for the report.Once that is accomplished, place the necessary fields on the report and manipulate those fields to design a professional,attractive and understandable report.

When you select Print Preview, Crystal Reports  will generate the report by retrieving the records from the  database and display the requested data on the report.  It then is the time to be sure that the newly designed report meets all the business requirements per the request.  Changes to the report, additions and deletions are simple to employ. If all is good, you can then export the report to several different Windows applications or to HTML.  There is even a free Crystal Reports Viewer for those who don’t have a copy of Crystal Reports.

We provide plenty of practice creating basic reports in our Introduction to Crystal Reports 2008 class.


View the original article here

Christmas Lights with Xcelsius

This post shows how to create Christmas lights in Xcelsius by using just a couple components. The two components used in this example are the Push Button and Play Control component. Just five formulas were written in the spreadsheet to alternate the colors and create “blinking lights”. These formulas are all based on the Data cell in the Play Control component.

Adding Hex Codes

In this example, I used five colors for the alternating lights and listed the hex codes in the spreadsheet. These codes were entered and labeled in the spreadsheet. Be sure to add quotes around the hex codes when entering them.  See the screenshot below.

Using Custom Hex Color Codes

Setup the Play Control Component

The next step is to add and setup the Play Control component. Drag and drop the Play Control component onto the canvas then map the Data and Scale property values to values in the spreadsheet.

Adding the Play Control Component

Setting up Properties

Set the Minimum Limit to 1 and since we’re using five colors, set the Maximum Limit to 5. I included both 1 and 5 in the spreadsheet then mapped to them. Next, set the Data property by selecting a cell in the spreadsheet.

Mapping Play Control Properties

Color Coding

A best-practice is to color-code input cells in the spreadsheet and also include a temporary value. The screenshot below shows the cells that the Play Control component are mapped to (from the General tab of the component).

Minimum, Maximum, and Data Values

Play Control Behavior

An important step in the Play Control component is to click the Behavior tab and set the Play Time to 1 second. Also be sure to check the following Play Options:

Auto PlayAuto RewindAuto Reply

Setting Play Control Options

These three settings work together to force the Play Control to continually run. The purpose of the Play Control component is to increase the value in the Data cell. The value placed in the cell will be between the minimum and maximum value previously set. The value will increment by 1 and will Auto Rewind and Auto Reply (because of the previous settings).

Changing Hex Codes with Formulas

With the settings we’ve setup so far, cell J1 will continually count from 1 to 5, restart after hitting 5. In the next step we’ll write a formula that changes the Hex color code when the value in J1 changes.

Here’s the syntax for the first formula: =IF(J1=1,A4,IF(J1=2,B4,IF(J1=3,C4,IF(J1=4,D4,IF(J1=5,E4)))))

This code says, if J1 equals 1, then return the first Hex color code. If J1 equals 2, then return the second Hex code. The formula continues on through J1 = 5. By writing this formula, the Hex code in the formula cell will continually change as J1 changes (thanks to the looping action in the Play Control component).

The next thing I did was create four new formulas with slightly different conditions to show five different hex codes at all times. Observe the pattern and differences in the five formulas listed below.

=IF(J1=1,A4,IF(J1=2,B4,IF(J1=3,C4,IF(J1=4,D4,IF(J1=5,E4)))))=IF(J1=1,B4,IF(J1=2,C4,IF(J1=3,D4,IF(J1=4,E4,IF(J1=5,A4)))))=IF(J1=1,C4,IF(J1=2,D4,IF(J1=3,E4,IF(J1=4,A4,IF(J1=5,B4)))))=IF(J1=1,D4,IF(J1=2,E4,IF(J1=3,A4,IF(J1=4,B4,IF(J1=5,C4)))))=IF(J1=1,E4,IF(J1=2,A4,IF(J1=3,B4,IF(J1=4,C4,IF(J1=5,D4)))))

The screenshot below shows how the five formula fields used to change the hex codes appear in the spreadsheet.

Formulas that Iterate Through Hex Values

Note

After setting up the Play Control component, move it to the back layer behind all components so it will not be seen. An easy way of doing this is to select the component and hold down the minus symbol until it’s at the very bottom layer.

Adding Blinking Lights

The final step is to add the blinking lights. Each light is actually and individual Push Button component - mapped to one of the five formulas previously described.

Begin by adding a Push Button component to the canvasAdjust it to the shape you preferSelect the component then remove the word Push from the component’s Label valueNext, click the component’s Appearance tab followed by the Color tabChange the Default color and Pressed color (pictured below)

Modify Push Button Colors

Select ‘Bind to a Color’ and select your first formula with a hex value (pictured below)

Binding to a Custom Hex Color

Copy and paste the component four timesBind each of the new components to the four remaining hex code formulas

All that’s left now is to copy and paste the 5 existing Push Button components many times and place them appropriately on the canvas. That’s it! Blinking Christimas lights with Xcelsius!

Please let me know if you have any questions.

Thank you!

Jim.Brogden@daugherty.com

If you enjoyed this post, make sure you subscribe to my RSS feed!

SAP Crystal Dashboard Design

Following SAP’s free download offer for SAP Crystal Presentation Design, there’s now an excellent offer on the grown up product: SAP Crystal Dashboard Design. This extends functionality to make all the widgets available, plus live data, web services, all singing and dancing! If you have Crystal Reports Server with Named User Licenses, you can even publish dashboards for all your users to play with.

Headline offer is 45% off, I’m hoping to make that half price once I can get a confirmed cost price.

For those who’ve been struggling to keep up with the name changes, this used to be called Xcelsius.

Prices through, managed to trim to half price:
Single license £395 + VAT
Discounts available on 3+. Extra discounts for Government, Non-profit, Education
Order on 01759 369827 or via Pursuit Technology


View the original article here