Solved

Xcelsius- opinions and basic info needed

Posted on 2009-05-05
6
502 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
  • 3
  • 3
6 Comments
 
LVL 1

Expert Comment

by:by6738
Comment Utility
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
Comment Utility
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
Comment Utility
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

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

Accepted Solution

by:
by6738 earned 500 total points
Comment Utility
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
Comment Utility
Thanks for the info!
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
How to increase the row limit in Jasper Server.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

743 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now