Solved

Xcelsius Dashboard Data Source

Posted on 2013-05-22
5
560 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

747 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

13 Experts available now in Live!

Get 1:1 Help Now