Skip to Content
0
Former Member
Jun 23, 2009 at 06:10 PM

Problem with Xcelsius Integration & MII

27 Views

Hi Rod

I created a transaction that calls a simple sql.

The output of this is mapped to the IllumDoc input of the MapIllumDoc2XcelsiusXML transaction.

when I point to the trx from IE7 i get (pasted from IE7)

<?xml version="1.0" encoding="UTF-8" ?>

- <data>

- <variable name="SAPMII_1">

- <row>

<column>743</column>

<column>667_SL-CT00205_WorkCenterBO:SISL,52BS002</column>

<column>SL-CT00205</column>

<column>WorkCenterBO:SISL,52BS002</column>

<column>SL-CT00205-0010-52BS002-S</column>

<column>A0</column>

<column>SL-CT00205-0000-52BS002-V</column>

<column>A3</column>

<column>2009-06-23T16:40:37</column>

<column>AA01267</column>

<column>2009-06-23T16:40:37</column>

<column>AA01267</column>

<column>TEMPLATE_PIS_CURE</column>

<column>ALL_PARAMETER</column>

</row>

- <row>

<column>742</column>

<column>666_SL-CA00001_01KM</column>

<column>SL-CA00001</column>

<column>WorkCenterBO:SISL,01KM</column>

<column>SL-CA00001-01KM-01KM-S</column>

<column>A0</column>

<column>SL-CA00001-01KM-01KM-V</column>

<column>A1</column>

<column>2009-06-23T16:00:08</column>

<column>NEI2664</column>

<column>TimeUnavailable</column>

<column>---</column>

<column>TEMPLATE_PIS_BUILD</column>

<column>ALL_PARAMETER</column>

</row>

- <row>

<column>741</column>

<column>665_SL-CA00001_02KM</column>

<column>SL-CA00001</column>

<column>WorkCenterBO:SISL,02KM</column>

<column>SL-CA00001-02KM-02KM-S</column>

<column>A0</column>

<column>SL-CA00001-02KM-02KM-V</column>

<column>A0</column>

<column>2009-06-23T14:27:22</column>

<column>NEI2664</column>

<column>2009-06-23T14:28:00</column>

<column>NEI2664</column>

<column>TEMPLATE_PIS_BUILD</column>

<column>ALL_PARAMETER</column>

</row>

</variable>

</data>

So it looks good on MII.

I then set up the url to the trx and mapped a range in xcelsius but still don't get any data back, just empty tags when I preview.

<data>

<variable name="SAPMII_1">

<row>

<column/>

<column/>

</row>

<row>

<column/>

<column/>

</row>

</variable>

</data>

Can somwone advise on the next step?

have I missed something?

regards

Amrik