Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 629
  • Last Modified:

Xcelsius Dashboard Data Source

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
BananaFury
Asked:
BananaFury
  • 3
  • 2
1 Solution
 
Kurt ReinhardtCommented:
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
 
BananaFuryAuthor Commented:
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
 
Kurt ReinhardtCommented:
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
 
BananaFuryAuthor Commented:
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
 
Kurt ReinhardtCommented:
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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now