SAP MII Connect with Xcelsius Dashboard

SAP MII Connect with Xcelsius Dashboard –Subramaniyan Thangavel

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:/MII/Runner?OutputParameter=<>&Transaction=<>

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

Integrate Barcode Printer Server with SAP ERP ECC system in SAP MII

We know, SAP MII can make use of building manufacturing excellence applications and provide seamless integration with heterogenous systems. Here, the solution is, the leverage the advantage of SAP MII build-in integration adaptors, to get connected SAP with Barcode Printer Server, based on the plant operations, like Production Confirmation or SAP QM Lot creation

The challenge here is to give a comprehensive solution to barcode printer integration for multi-site and make sure that the barcode data should reach the printer server queue and simple graphical user interface to configure the printer

Advantage of SAP MII Messaging systems, MII with SAP ECC can do with asynchronies communications, on the other hand, the communication with Printer server can do either FTP or Share folder connectivity

Let’s take Loftware Label Printer server, one of the leading LPS vendor and how we can connect with SAP ECC through SAP MII.


Production confirmation and raw material consumption. Basically need to track the WIP and finished products in the plant





After Product Order downloaded from SAP, the production confirmation needs to send back to SAP for Inventory maintenance purpose, meanwhile, the barcode will be printed in the operator terminal for tracing the semi-product in every work-center.

SAP MII have messaging system to buffer the IDoc interface xml data in the MII server and can communicate to Barcode Label Printer servers Like Loftware.

Lets take production confirmation in each workcenter of a production line, When the Operator confirm the product, the martial and relevant information send to SAP MII server and then , push the data from SAP through IDoc messenger, After SAP MII get confirmation from SAP , the SAP MII transaction get fired to generate label data file and copy the file to Loftware Printer server’s scanning folder. This transaction can be done by FTP or file copy at share folder.

The rest of the part will take care by loftware server. In loftware Printer Server
, we should need to have a printer device and related printer queue, including the folder for a barcode printer, which basically should located in the plant floor.

Sample label printer data in the printer file.

*FORMAT,PROD_Label.LWL
Barc0002, MW0002345
*PRINTERNUMBER,3
*PRINTLABEL

Tools are used:

Barcode server : Loftware V9.8
Integrator : SAP MII 12.x
Client : SAP MII Web Client

Business Benefits:
1. Reduced investment for SAP-Barcode Server integration
2. Multi plant configuration in one system
3. Reduced in Maintenance cost