?
Solved

Xcelsius- opinions and basic info needed

Posted on 2009-05-05
6
Medium Priority
?
521 Views
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!!!
0
Comment
Question by:snyperj
[X]
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
  • 3
  • 3
6 Comments
 
LVL 1

Expert Comment

by:by6738
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?
0
 

Author Comment

by:snyperj
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..  :)
0
 
LVL 1

Expert Comment

by:by6738
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.  
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 

Author Comment

by:snyperj
ID: 24315664
how does the "Query as a Web Service"  authenticate with SQL Server?
0
 
LVL 1

Accepted Solution

by:
by6738 earned 2000 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).
0
 

Author Comment

by:snyperj
ID: 24315979
Thanks for the info!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
How to increase the row limit in Jasper Server.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

719 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