SAP MII Visualization object to build operational user interfaces and java applet based graphs, but to develop a rich graphical reports and graphic, we have Xcelsius Dashboard. Lets take Xcelsius 2008 , which have rich graphical components like multiple charts , gauge,maps dial and sliders. Xcelsius Data Manager provide XML Data/Web Service and other connectivity option to connect with enternal database other then spread sheet. Leavrage the advantage of XML (Or Web service ) connecter in Xcelsisus we can feed the data to graphical objects, like charts and others
Lets see step by step procedure, in first place , In SAP MII, we need to create a query template which is required to pull the data from a data source, lets take a Tag Simulation data server
Once , Tag query template is ready, we need to develop a transaction for generating xml output to feed the data in to Xcelsius data manager.
The important, point to here is that Xcelsius can load the data in to excel spread sheet when the xml data should be in below format
In SAP MII Illuminator XML out format is simple, but there ,lets say “data1” is the data of column1 and row1, Variable meaning here is Column name of spread sheet, Since we need to format the output xml data .
Design a simple transaction that should read the Tag value from a Tag Query template. And define a output attribute of the transaction as xml data type
Read each row of the data and format in to the format which we need (as define in the above) and assign to output xml
http://server:
This xml feed will be act as data source for the graph which we designed in the xcelisus
Excel spread sheet data will be loaded from the data manager configuration .set the refresh reequency in the usage tab
e
