Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Xcelsius- opinions and basic info needed

Posted on 2009-05-05
Last Modified: 2013-11-15
I am interested in hearing what others think of Xcelsius 2008 .  Ijust dl the trial copy.
I would like to see how difficult it is too build a 'dashboard' that will show our sales person bookings,invoiced amounts and backlog in a graphical manner, month-to-month.

I am hoping that every user would not need this program in order to view the end result?  I am thinking that the program builds an interface, that anyone an run, and the data is pulled from a worksheet or something.

I hope it is easy- some of the demo screenshots I have seen looked really cool!   Thanks for any info!!!
Question by:snyperj
  • 3
  • 3

Expert Comment

ID: 24315311
Your end users will not need the Xcelsius Designer application in order to view the dashboard.  Once you've built the content, you can distribute it to your users via SWF, embedded in an MS Office document, or share via BusinessObjects Enterprise.  

I don't think it's overly complex to create a basic dashboard and incorporate a few analytics.  The help docs included with the product include a tutorial that's actually helpful and should show you the basics.  

What type of datasource are you planning on connecting to?

Author Comment

ID: 24315421
I was assuming it would have to be an excel worksheet?  I don't know why...maybe because of the name.
The excel worksheet would be an extract from our business system which is in SQL Server 2005 .  I was planning to create (try to create!) the dashboard, point it to a workbook of data, then distribute the front end (.swf).  I was thinking I would then just periodically update the worksheet (overwrite) on a weekly basis or similar.

Ideally a connection to the backend would be better (odbc?)...I assume that is possible right?  But that would require having the ODBC driver on every user machine I'm assuming?

ahhh...so many questions, so little know-how..  :)

Expert Comment

ID: 24315536
Better yet - you can connect directly to your SQL Server DB without the need to first take an extract and feed into Excel.  You should also be able to use a native driver, so you won't have the concerns around ODBC.  At a high level, you'd create a query in Xcelsius through something called Query as a Web Service which pulls your data into the workbook that is stored internally within Xcelsius designer, then reference this workbook (which is visible in the Designer) when building your dashboard.  
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.


Author Comment

ID: 24315664
how does the "Query as a Web Service"  authenticate with SQL Server?

Accepted Solution

by6738 earned 500 total points
ID: 24315892
You should have the option to connect through native SQL Server driver or ODBC connection, very similiar to connection options in Crystal Reports / WebI / etc...  Also - just to be clear, this connection and the query against your DB is all setup within Xcelsius (it used to be that QaaWS was a separate add-on).

Author Comment

ID: 24315979
Thanks for the info!

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question