Questions regarding Xcelsius Dashboard reports in SAP Soucing

[isaac_ariza_cruz]

Hello experts,

For one of our clients we would need to create a dashboard report. However, during the analysis of the technology used to create this kind of reports (Xcelsius 2008), we have the following questions. Let me explain them:

In the following post it is explained the 4 steps to be done to create this kind of reports. Post: http://scn.sap.com/people/sumita.jayaraman/blog/2010/11/22/analytics-part-2-creating-custom-xcelsius...

In a separated document there is a comment regarding the integration to be done by the XML data connection. However, inside this post it is said that it is not needed because it is done by the real-time query framework existin in SAP Sourcing:

So my first question: could you please confirm no additional customization is required regarding integrating XML data connection?

In addition, regarding the queries created in SAP Sourcing that will be used in the dashboard reports, we have the following questions:

• Once they are created in SAP Sourcing and configured in the Xcelsius file, are they executed automatically and results are listed in the corresponding QueryXX tab on the xcelsius file?
• If so, when are they executed? When the report is displayed to be used by the user? Or are they executed when the report is executed (i.e.: if user selects some parameters and press a button to display data)?

Thanks in advance for your time and support.

Best regards,

Isaac

[vikram_shanmugasundaram · Accepted solution]

Hi Isaac,

XML data connections are required for the Dashboard reports to work in
SAP Sourcing. Your Dashboard report should have at least one XML Data Connection. Depending on the complexity of the report, you may have multiple XML Data Connections. Each XML Data Connection can be associated with one or more queries. During runtime XML Data Connection will send the query names,filter parameters to SAP Sourcing  to request specific information back from the server. The data retrieved and displayed on the Dashboard report will be the most current data persisted in the DB.

I would suggest taking a look at the links below…

http://scn.sap.com/docs/DOC-29251

http://scn.sap.com/docs/DOC-29442

Hope this helps.

Regards,

Vikram

[isaac_ariza_cruz · Accepted solution]

Hi Vikram,

Thanks a lot for your support. In addition, we are also following this document: https://websmp102.sap-ag.de/~sapidb/011000358700000245372012E/XcelsiusReportsGuide_w9.pdf because we have already read the 2 links you posted above but we needed deeper knowledge regarding this topic and that SAP document is adding that.

Thanks again and best regards,

Isaac

[Former Member · Accepted solution]

Hi Vikram,

Can you please let me know if there are webcasts on the Dashboard sessions 1 and 2 for which you have sent the links, so that i can view the demos. If so please provide me the links it would be very helpful for me.

Thanks in advance!!

Vennela.