Crystal Vision Server - Productivity - Software - Reviews - ZDNet Australia
Breaking News: Interpol defends voluntary filter

ZDNet / Review / Review

Crystal Vision Server

By David McAmis, ZDNet Australia on June 20th, 2006 
Submit

Overview

The new Crystal Vision product line combines technology from Crystal Reports, Crystal Xcelsius and Business Objects' Live Office -- aimed at the mid-market segment in Australia.

 

Introduction | Features | How we tested | Verdict

As the amount of data that businesses collect increases, it becomes more difficult to turn that data into decision-making information. And this is no truer that in the mid-market space, which most business intelligence vendors have ignored over the years, preferring to focus their energies (and products) on larger enterprise deployments.

But that is slowly changing as BI vendors recognise the value of the mid-market. Business Objects is one of the vendors trying to capitalise on that market segment with the release of Crystal Vision Server, a new product combining reporting with data visualisation.

Most IT professionals would have heard of Crystal Reports, but Business Objects has recently expanded the Crystal Product line, incorporating technology the company acquired from Infomersion. The original Infomersion product has been rebranded Crystal Xcelsius and integrated into the product family.

The new Crystal Vision product line combines technology from Crystal Reports, Crystal Xcelsius and Business Object's Live Office product to provide reports, dashboards and interactive analytics across a variety of data sources. This 360 degree, consolidated approach ensures that even smaller organisations can access the information they need to make better decisions. They also get facts "at-a-glance" with interactive dashboards that allow them to do what-if analysis and present information in an easy-to-ready visual format.

Introduction | Features | How we tested | Verdict
Introduction | Features | How we tested | Verdict

When you look at Crystal Vision Server, you need to understand what exactly it is you're getting. To start, there is the reporting technology from Crystal Reports, which can be used to provide presentation-quality reports from virtually any data source, including SQL Server, Oracle, DB2, etc.; or any database that has an ODBC or native driver available.

And the reports created with the product can take just about any shape or form, leveraging all of the power that Crystal Reports has to offer. And this is nothing new -- Crystal Reports has long been regarded as the market leader in the reporting space.

Crystal Vision Server
[Click to enlarge] Crystal Reports can be
used to create presentation-quality reports.

What really makes Crystal Vision Server exciting is the "sex appeal" added through the interactive dashboards and analytics. This appeal comes from the technology leveraged from Crystal Xcelsius 4.5, an updated version of the product released in conjunction with Crystal Vision Server.

Using Crystal Xcelsius, you can build an interactive dashboard from an Excel spreadsheet, to be delivered using Adobe Flash. This dashboard can then be exported to the Web, or embedded in a PowerPoint or PDF, and still retain its interactivity ... which is what makes it an amazing tool -- imagine sending a profit and loss dashboard to someone outside your organisation in a PowerPoint presentation and having a slider control on it to allow them to change values interactively based on an increase or decrease in sales.

You have probably been to websites that provide home loan, interest or payment calculators. This is the same concept, only it is your own live data that it is connected to. In addition to having a number of visually appealing controls, (charts, maps, tables, and sliders) the interactivity is the real selling point.

Crystal Vision Server
[Click to enlarge] Crystal Xcelsius
provides the ability to visualise data
using interactive, Flash-based dashboards.

And that is just the tip of the iceberg. Using Crystal Vision Server, you also have a secure web framework that you can use to publish and share your reports and dashboards with other users. And the "Live Office" technology included can be used to ensure that your dashboards always have the most current data. In addition, the security from Crystal Vision Server flows through all of the deliverables, so you can create one report or dashboard that contains data for different users.

For example, if you only want the sales team to see New South Wales data, you can secure the data source so when they look at a dashboard or report, they only see that one state. The Web framework and portal leverages technology from the Business Objects -high end" offering, BusinessObjects Enterprise, which can scale to thousands of users. Crystal Vision Server on the other hand, has been designed for smaller implementations of up to 20 users and has been priced accordingly.

There is also a desktop version of the product, called Crystal Vision which includes the same design tools and capabilities, without the web-based framework or portal for distribution. The desktop version is mainly designed for users who want to start creating reports and dashboards but may not have the number of users or infrastructure to support a full implementation of Crystal Reports Server.

To create a report and dashboard from your data, there is a three-step process, involving Crystal Reports, Microsoft Excel and finally Crystal Xcelsius. And the reason for this is that Xcelsius was originally designed as a tool to quickly create dashboards from Excel spreadsheets or with data from Web services.

Adding the technology from Crystal Reports and Live Office means that dashboards can be refreshed from the back-end data source as often as required. Not to mention when a user wants more details on a particular dashboard component, they can drill into the corresponding Crystal Report.

To get started, you will first need to create a report using the Crystal Reports designer. Crystal Reports can report from most data sources, including direct and OBDC access to various data sources. To create a new report, you can use the Standard Report Wizard to walk through the steps of selecting a database or choosing fields.

Crystal Vision Server
[Click to enlarge] Crystal Reports features
a number of wizards you can use to
jump-start your report development.

Once you have a report created, you can save it to the server by selecting Save|As. The default end-user interface for Crystal Vision Server is InfoView, a web application that closely resembles an e-mail client, with folders to help organise report content. From InfoView, users can view a report, schedule it to run, distribute via e-mail.

With the report created, you can then pop in Microsoft Excel and create a spreadsheet using Live Office. When this component is installed, it adds an additional menu to Excel called "BusinessObjects". From this menu, you can create a new "Report View" that will allow you to select the report you just created and select which fields you want to see in your Excel spreadsheet. Once you have created the spreadsheet content, you can use the BusinessObjects menu again to save the Excel spreadsheet to the server.

And finally, you can open Crystal Xcelsius and get started creating your dashboard. The first step is to select the Excel spreadsheet that contains the data for your dashboard by selecting Data > Import Model. You can then open your spreadsheet from the server and start creating your dashboard.

The easiest way to create a dashboard in Xcelsius is to drag and drop the visual components on to your page first. Then, you will need to set the properties for each component, specifying the Excel range where the data resides. This works in the same manner as picking a range within Excel.

Crystal Vision Server
[Click to enlarge] Tight integration with
Excel means you can create spreadsheets
from live data and refresh the data as
required.

You can click on the "ellipse" button (...) and a copy of the spreadsheet will open within Xcelsius. You can then use your mouse to highlight the data you want to select. Alternately, you could always type in the cell reference (A1:B25 for example).

You can add interactivity to your dashboard by using the Excel lookup functions in your spreadsheet. For example, you could nominate one cell to hold an interest rate. Then create an Xcelsius control, say a slider control, to change this interest rate. As the rate changes, each of the charts on the page could change in response to the rate you have selected. There are a number of good sample dashboards and templates and a little bit of Excel skill will go a long way here.

As the final step, you may want to drag on a Live Office refresh button to allow the users to refresh the dashboard when new data becomes available. And once you have finished designing your dashboard, you can then use Save|As to save a copy of the dashboard to the server, where it is now available in InfoView. Other users can log on to InfoView and view the original report, Excel spreadsheet and dashboard you have created.

Crystal Vision Server
[Click to enlarge] Crystal Xcelsius
dashboards can be created by dragging
and dropping components on to the page,
then associating an Excel range as the
data source.

During our review, there was only one major area that we found the product could improve. The major reason for this is that the product is a combination of proven technologies that have been on the market for a number of years. The one issue we did come across is in the way the product itself is installed -- multiple components have to be installed to get the web framework and design tools installed.

It would have been much easier if the product had a single setup where you could select the tools and options you wanted to install. With that said, the installation was quick and painless with each of the components providing a straight-forward installation that took around 30 minutes in total.

On the training side of things, there will need to be some provided for developers who want to create their own Crystal Reports. On the dashboard side of things, end-users who are familiar with Excel should be able to create their own dashboards and analytics without formal training. There are a number of templates that end-users can use to get started and a good knowledge of Excel formulas and lookup functions will go a long way.

Introduction | Features | How we tested | Verdict
Introduction | Features | How we tested | Verdict

Business Objects provided a full copy of Crystal Vision Server which we installed and configured on our own Windows Server 2003 test server (Intel Pentium 1.6GHz with 2 GB of RAM.) We then created a number of reports off of the sample databases that ship with the product and used the same data set to create interactive dashboards.

For our review, we looked first at how information from a database or other data source can be represented, as well as the design tools and skills required to deliver reports or dashboards. We also looked at how easy it was to use the design tools and what training would be required to bring an end-user or IT professional up to speed.

And finally, we looked at how easy it is to install, configure and administer the software, including but not limited to setting up the server components, publishing reports and dashboards to the Web-based portal that it is included, organising portal content, adding users and security.

Introduction | Features | How we tested | Verdict
Introduction | Features | How we tested | Verdict

In a recent survey of IT managers, Business Intelligence rated as either their first or second priority, only following behind security as a priority. And in the mid-market space, Crystal Vision Server does much to deliver the framework to deliver BI throughout the organisation in a secure, consistent manner.

End-users and IT professionals should both be impressed with the ability to create pixel-perfect, presentation quality reports along with rich data visualisations and interactive dashboards. In the mid-market long ignored by BI vendors, Crystal Vision Server definitely hits the sweet spot.

Product Crystal Vision Server
Price Around AU$17,000 for five users including support and maintenance, upgrades available from Crystal Reports Server or Crystal Xcelsius Workgroup. Note: A desktop version of the product, Crystal Vision, is available for AU$1,130 for the full product or AU$710 for the upgrade from Crystal Reports or Crystal Xcelsius
Vendor Business Objects Australia
Contact 1 800 647 006
URL www.businessobjects.com.au
Interoperability 5 out of 5
Web-based portal for report and dashboard delivery, SOA architecture
Futureproofing 4.5 out of 5
Web-based framework for delivering reports and dashboards, .NET, JSP, DHTML and Flash are core technologies used and should be around awhile
ROI 5 out of 5
Both end-users and IT professionals can start delivering content within a few hours of installing the product
Service 4.5 out of 5
E-mail, Web and telephone
Rating 4.5 out of 5

Introduction | Features | How we tested | Verdict

(Back to top)

Talkback

Add your opinion

In order to post a comment, you need to be registered. (Sign In or register below)

Post your comment

Terms of Service - As a ZDNet registrant, and by using this service, you indicate that you agree to our Terms and Conditions and have read and understand our Privacy Policy.

Resource Centre Useful content from our premier sponsors

ZDNet Australia Live

Why a $25 computer means revolution: And just as the electronics have shrunk, so has the price — opening up the ... http://t.co/kdvMBPEm

buy convert dvd to asf to your friends

3 minutes ago by chatheli on 700MHz auction: The death knell for Aussie 4G?

Good article and some good comments guys. The lazy, monopolistic bullies that are bleating about this (TA, AFL, NRL, CA etc) need a reali...

11 minutes ago by Progressive on More TV Now may mean less TV later

Lax data privacy laws hurt Australia: Australia may be setting a bad example and limiting its ... http://t.co/0OTpy0W7 #Data #Protection

The Raseberry has a great role in automating heating and cooling systems, and in process control. Just get a few termisters along with an...

15 minutes ago by lsatenstein on Why a $25 computer means revolution

Ethical iPhone protests hit Apple stores http://t.co/Tg87lxA1

Why a $25 computer means revolution http://t.co/KoA6Mfnu

HRM/HCM is heating up with Oracle buying Teleo. Where's MSFT in all this?http://t.co/urUaTHc5

Lax data #privacy laws hurt Australia: Australia may be setting a bad example and limiting its options when it c... http://t.co/18CvSbms

Lax data #privacy laws hurt Australia: Australia may be setting a bad example and limiting its options when it c... http://t.co/35xWEgB2

News: Malware's the next nuclear bomb: Kaspersky - Security - News - ZDNet Australia http://t.co/MqfyXzJS

Lax data privacy laws hurt Australia - Australia may be setting a bad example and limiting its options when it comes... http://t.co/F7HQTvVy

Google readying #cloud storage service: Google is reportedly getting ready to take on Dropbox with its own cloud... http://t.co/GTFIbQC7

Lax data #privacy laws hurt Australia: Australia may be setting a bad example and limiting its options when it c... http://t.co/6q6L9DOG

Ethical iPhone protests hit Apple stores. Love your iPhone? Love it more if it is made ethically? http://t.co/LkKm9StB via @zdnetaustralia

Lax data privacy laws hurt Australia: Australia may be setting a bad example and limiting its options when it co... http://t.co/sGjo2Y6w

Ethical iPhone protests hit Apple stores http://t.co/LkKm9StB via @zdnetaustralia

RT @SecMash: Lax data privacy laws hurt Australia - ZDNet Australia http://t.co/NaFCw4Xr #InfoSec

Lax data privacy laws hurt Australia - ZDNet Australia http://t.co/NaFCw4Xr #InfoSec

Apple app developers may have copied your address book, despite it being against the rules which Apple has ignored http://t.co/C6PgoMQd

Lax data privacy laws hurt Australia: Australia may be setting a bad example and limiting its options when it co... http://t.co/f9CnwmTy

by http://t.co/vmlQ0Ecb: Lax data privacy laws hurt Australia: Australia may be setting a bad example and limitin... http://t.co/G0fEMhs7

LinkedIn posts strong Q4 earnings, up in after hours trading http://t.co/TJSBmtlT

Twitter now available in emergencies with satellite providers: Twitter is being pumped up to save the day with t... http://t.co/Oz2xsX0K

Microsoft plans to release a flavour of Windows 8 on ARM chips http://t.co/10rKSoAs

RT @zdnetaustralia: Why a $25 computer means revolution http://t.co/ufWQdLzT

Senator Conroy imposes limits on amount of spectrum telcos can buy at Digital Dividend auction: http://t.co/PD7DNr4r

http://t.co/JaYhkJjV

Armageddon of War 1.5 (Mobile): Top Hit Game for everybodyIdea is simple,Collect red items, Avoid green objects,... http://t.co/BqJhQRiO

Court agrees to speed up case over #Google's privacy policies http://t.co/hCf5CbQT | RT @ZDNet | #privacy

RT @ZDNet: Facebook admits it needs to fight scams more efficiently http://t.co/O7DvYt87

Twitter now available in emergencies with satellite providers http://t.co/dZUPbpj1

RT @zdnetaustralia: Why a $25 computer means revolution http://t.co/ufWQdLzT

RT @ZDNet: Twitter now available in emergencies with satellite providers http://t.co/ZKibHIsQ

Facebook: 60 million users access apps via mobile: By Emil Protalinski | February 9, 2012, 10:01am PST Summary: ... http://t.co/Nq0TvzJY

New website hopes to improve the Federal datacenter consolidation process: New website hopes to bring together I... http://t.co/5yeK9VMO

iPhone commands better resale value than Android or Blackberry: @danjames2012 I find it hard to believe that som... http://t.co/GryjHpQZ

RT @ZDNet: Twitter now available in emergencies with satellite providers http://t.co/ZKibHIsQ

invention these appreciate Every using after Numerous Not well ordering customer any custom route do make these current can consider of N...

1 hour ago by gurbapagnonna on Abetz shifted in reshuffle

I'd say a reasonable amount of it would be. In the Queensland Department of Education's case, it said it was trying to make as much of it...

2 hours ago by suzanne.tindal on The application nation

Great article, Suzanne—couldn’t agree more. It is only logical for organisations – private or public-- to take a long, hard look â€...

3 hours ago by kashe on The application nation

Every example of action against child molesters in this story related to internet protocols other than the www. This filter then achieves...

3 hours ago by Bob.H on Interpol defends voluntary filter

Soooo... it's okay for Apple to demand use of technologies and designs falling under competitors patents (considered "standards"), but on...

11 hours ago by MoWeb on Apple wants new rules for mobile patents

But I am having an intelligent conversation young fibes, my point is the lofty goal that all are equal is unfortunately not so. That is w...

13 hours ago by Doubt on NBN Co inks $620m satellite deal

May be so, but we do need to lighten up some of these people who are so serious. poor old fibretech nearly brings tears to the eyes and j...

13 hours ago by Doubt on Turnbull decries 'Rolls-Royce' satellites

The latest MS Windows update for XP tries hard to persuade you to update. For those machines that already have IE8 loaded it tries to re-...

14 hours ago by brak on Windows XP clings on as dominant OS

Will be interesting to see if he drives the qld gov political IT agenda or looks to address the IT challenges being faced by qld gov agen...

14 hours ago by Flly on Queensland's CIO returns to the post

So angry! NOKIA has forgotten the main purpose and the user function, and instead prioritised their industry level concerns. I bought my...

15 hours ago by spaceagesoup on Nokia skips Australia in Symbian Belle roll-out

I get what you mean in your context, meski. If the filter is like speed cameras, then people can alternately take side streets and back r...

17 hours ago by techkid on Interpol defends voluntary filter

Remind me again how people can get to a leadership position with absolutely no practical knowledge? I would ask Alexander how he intends...

17 hours ago by cleversoap on Internet won't always be anonymous: ITU

I was reading about DMARC at http://www.unlocktheinbox.com/resources/dmarc.aspx, perhaps they should try to implement something like this...

18 hours ago by wpfn on Phishing scam causes Telstra email woe

As you can tell, I'm a big follower. For AFL read NRL.

18 hours ago by phildobbie on The TV Now aftermath

Im not sure if David Gallop realises he now works for the AFL.

18 hours ago by katerich on The TV Now aftermath

That assumes that people see the stop sign. If you're using proxies, or whatever *all* the time, then these stop signs will never be obs...

19 hours ago by meski on Interpol defends voluntary filter

The advanced remote controlled machines reduce the human working rate from hazardous environment.

19 hours ago by Manasy on Robotic mining worth its high cost: Rio

This story has been voted 20 times in the last 24 hours!

2 days ago, Symantec confirms hacker extortion

This story has been voted 10 times in the last 24 hours!

2 days ago, Symantec confirms hacker extortion

Facebook Activity

Keep up with ZDNet Australia

LinkedinLinkedin Join our network

RSS FeedsRSS Feeds Subscribe now

NewslettersNewsletters Subscribe today

AlertAlertsSubscribe now

ZDNet Events Calendar

ZDNet Events Calendar

Plan Comparison

Prev Next
Loading...
Deals powered by WhistleOut

Sponsored resources