Xcelsius data sources

other Xcelsius - Crystal Dashboard Design
1

I want to build xcelsius dashboards, which would take the data from reports available in our reporting environment. The goal is that dashboard
is manually refreshed every month and uploaded on the Intranet.

Data source for the dashboards is available in two concurrent sources:

  1. latest instance of webi reports
  2. html versions (.html stored on web server) of latest instance of Webi reports

We are wondering how to bring this data into dashboard

For option 1) I think we could use Live-Office or Antivia XWIS
Is there any way to use option 2) ? Can Xcelsius use HTML files as a data source ?

Which method would be the best from performance point of view (ability to handle up to 10000 rows) ?

mzamojsk (BOB member since 2010-09-17)

2

it will take connections as data source… you will get this document in sap site…

surya.g :india: (BOB member since 2009-11-24)

3
  1. Use liveoffice for a Webi data connection. One never knows when 3rd party extensions are going to get annihilated by a new service pack/fix pack.
  2. I dont think HTML, all by itself, can be used as a datasource, but XML can; its super fast and very reliable. There are a few other Web services like SOAP, and WSDL that can connect to a webserver, and use HTML, kinda. Saving a Webi in HTML and trying to connect that is not necessary.

Also, A dashboard is not a microcube, nor is it a table. Its a SWF file in the end. If you put 1000’s of rows into it and treat it like a table, query, or view, your model will probably not work.

Make new Webi reports, designed to support a dashboard. These new Webi documents should have less rows. (e.g. < 20). You could make many multiple connections to many multiple Webi docs that were created specifically to support a dashboard.

Cairmor :us: (BOB member since 2008-06-05)

4

Hi

Thanks Cairmor for your hints. I was also wondering about continuous support for XWIS…

One question still: I want these swf dashboards to be generated manually by ‘admin’ and updated on Intranet once a month and want them to be available for everyone without any BOXI account of logging in. Is it still possible with LiveOffice ?

mzamojsk (BOB member since 2010-09-17)

5

cant use liveoffice outside Infoview…it needs authentication.

The other Web services do not (XML), QaaWS-if hardcoded, etc.

I think LiveOffice and QaaWS both require user viewing licenses for each viewer, as well, but using the generic web services…again XML or the others, Do not.

Cairmor :us: (BOB member since 2008-06-05)

6

You can have a LO connection in the Xcelsius model. Have the admin refresh the data, then publish the swf.

That way it is static data that used the data from Webi. That sounds like what you want, am I correct?

Bolandb (BOB member since 2010-06-08)

7

Yes, this is what I’m looking for. Admin refresh once a month and swf published on the Intranet.

Anyway, it seems that we should check LiveOffice for this purpose.

mzamojsk (BOB member since 2010-09-17)