Solved

Xcelsius- opinions and basic info needed

Posted on 2009-05-05
6
519 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 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).
0
 

Author Comment

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

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

710 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