Solved

Xcelsius Dashboard Data Source

Posted on 2013-05-22
5
584 Views
Last Modified: 2013-05-28
Hi,

I am very new to this tool, but it was provided with Crystal Reports so I assume its part of the same package.

When working with Crystal, we create tables or stored procedures in our SQL MS, and bolt Crystal onto these. That way of course, Crystal is always fed the latest data.

For this dashboard tool, it looks like it wants to run from a spreadsheet. Of course, we could extract data from our warehouse into a spreadsheet, and import this into the dashboard tool, but that becomes a task each time reports need updating.

Is it possible to bolt the dashboard tool onto our warehouse via an ODBC connection like we do with Crystal?

Thanks
0
Comment
Question by:BananaFury
  • 3
  • 2
5 Comments
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 39189658
1)  The types of data sources available to you depend on the version you have.

2) Xcelsius (now called Dashboard Designer) ALWAYS uses an Excel spreadsheet as the underlying source of data, however, that spreadsheet can be populated with data from another source (see #1).  "Live" data sources can be XML web services, QAAWS (Query as a Web Service) or SAP BusinessObjects Live Office.  QAAWS and Live Office depend on you having an SAP BusinessObjects Enterprise or Business Intelligence platform.
0
 

Author Comment

by:BananaFury
ID: 39190066
I am using SAP Crystal Reports 2011, SAP Business Objects Xcelsius (which yes, now looking at the Business Objects site we bought it from is indeed now called Crystal Reports Dashboard design) and Microsoft SQL Sequel Server 2008. I do not know if I have access to a Business Objects Enterprise or Business Objects platform. Do I need them, how can I find out if I already have them? To be honest, and I am sure this is apparent, I am not the most technically minded person, but am the only person for the job in our small organisation, the plea from the online community.

I have spent some searching these forums and experimenting with the tools I have, and have managed to place some data in the spreadsheet in the dashboard tool, create a simple report, inbed that dashboard report into a Crystal report, and map the data from Crystal Report, which is drawn from our warehouse, direct to the dashboard data. This is essentially the result I am looking for, but with the added inconvenience of needing Crystal to initially receive the data from the warehouse, and pass it to the dashboard tool. I therefore suspect I am tackling this task incorrectly.

Thoughts?
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 39192479
Do you have the personal edition or the departmental edition?  This will determine how you can connect to live data.

In regards to integrating Xcelsius into Crystal Reports - that's one way of doing it.  I don't do a lot of Xcelsius, but I personally like to use Live Office or XML Web Services to access live data.  Do you need an enterprise platform?  For Live Office, yes.  For XML Web Services not necessarily.
0
 

Author Comment

by:BananaFury
ID: 39194402
Hi,

Thanks for your help here.
Couldn't tell you whether I have the department or Personal Edition. I would guess at the personal edition, but how can I check?

How would I tackle feeding Xcelsius live data via the XML route? I have another tool I am trying to feed live data now, and wonder if this approach could be used for a number of tools.

Thanks so much for your help!
0
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 500 total points
ID: 39194458
I would highly recommend taking a course in Xcelsius.  I'm not an expert in it myself, because I rarely have an opportunity to use it.  Unfortunately, I haven't yet reinstalled it on my new machine, so I can't walk you through it.  Here are some resources, however:

http://scn.sap.com/docs/DOC-7946
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
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…

856 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