cancel
Showing results for 
Search instead for 
Did you mean: 

Xcelsius Integration Assistance

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Amrik,

You must have sample data in your Xcelsius spread sheet for the 'Preview XML' to work correctly. So first setup the sample data, then map your XML source to the range. You'll notice that clicking the 'Preview XML' button will return your sample data and not the data actually pulled from your data source.

Rod

Former Member
0 Kudos

Hi Rod,

I mapped a range as you and a walkthrough I found suggested.

When I preview, I see the data I manually added. I then exported the files (.html and .swf) However, when i imported these to MII, and test, I still see the data i manually set and not the data I expected from my query.

regards

Amrik