Problem with Xcelsius Integration & MII

[Former Member]

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

[Former Member]

Just to verify:

- you mapped the return of the XML in the connection details to an area in your excel sheet.

- your excel area is large enough to handle the whole return document.

- you triggered the MII call in Xcelisu as either "on load" or triggered by a cell change on the next tab in the connection settings?

thanks

stephan

[Former Member]

Thanks Stephan,

I did not do the on Load step.

Amrik

[agentry_src]

Amrik,

Please start a new message.

Thanks,

Mike

Looks like one of the moderators already converted it to a new message.

Edited by: Michael Appleby on Jun 29, 2009 12:48 PM

[Former Member]

Hi Adarsh,

Did you pass the UserName and Password in your transaction url ?I had the same issue and after passing these params,i was able to preview it inside xCelsius.

Regards,

ram