Solved

Xcelsius Dashboard Data Source

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
A short film showing how OnPage and Connectwise integration works.

914 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

16 Experts available now in Live!

Get 1:1 Help Now