Xcelsius integration

[Former Member]

I'm working on visualizing some MII queries in Xcelsius 2008.

I have two questions.

1 - There is a great document detailing pulling data from MII into Xcelsius as an XML data source.

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b0373859-2c61-2b10-f4a3-de9585f6.... The doc references an MII transaction that is 'Attached' called SAPMIIBOBJIntegration which does some XML structure manipulation so as to play nice with Xcelsius. I can't find this project anywhere, can anyone direct me? (as far as I can see, it is not attached)

2 - Is the same issue encountered when connecting Xcelsius as a web service (incompatible xml structure)? I've populated the WSDL url, and it seems to pull back the definition appropriately, but I haven't had it successfully retrieve data yet.

Regards,

Rod

[agentry_src · Accepted solution]

Hi Rod,

I suspect that the attachment got dropped. I am trying dig up a copy for you (and others).

Regards,

Mike

[Former Member · Accepted solution]

Thanks Mike,

Of course in the interim I have built my own version of the transaction, but I still think having it available to others would add value.

Still trying to figure out why my Web Service data connection is not providing the expected results in Xcelsius.

Rod

[agentry_src · Accepted solution]

Rod,

Since it appears to be a mapping transaction, I suspect it wouldn't take much effort to duplicate it. However, it would be a good idea to have a standard version of it which has been tested and wrung out. Will let you know when I have heard something about this.

Thanks,

Mike

[agentry_src · Accepted solution]

Rod,

I am still working on getting the project added as a download, but for those interested, the xsl at the heart of the conversion transaction is:

<?xml version='1.0'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">
 <data>
	 <xsl:apply-templates select="Rowsets/Rowset"></xsl:apply-templates>
 </data>
</xsl:template>

<xsl:template match="Rowset">
 <variable>
  <xsl:attribute name="name">
   <xsl:value-of select="concat('SAPMII_',position())" />
  </xsl:attribute>
   <xsl:apply-templates select="Row"></xsl:apply-templates>
 </variable>
</xsl:template>


<xsl:template match="Row">
 <row>
  <xsl:for-each select="*">
    <column>
	 <xsl:value-of select="."/>
	</column>
  </xsl:for-each>
 </row>
</xsl:template>
</xsl:stylesheet>

My thanks to Stephan Boecker for providing the MII transactions and xsl code.

Hope this helps,

Mike

Edited by: Michael Appleby on Mar 17, 2009 6:01 PM

[Former Member · Accepted solution]

Hello Micheal,

sorry for that, but i can't find any MII-transactions for downloading here (or somewhere else in SDN).

Please, can you send me the trx-file directly.

Thank's in advanced,

Roland Feichtenschlager

[agentry_src · Accepted solution]

Roland,

Check out my business card info and I will be happy to provide the trx to you.

Regards,

Mike

I tried yours and it bounced.

Edited by: Michael Appleby on May 18, 2009 8:15 PM

[sidnooradarsh · Accepted solution]

Hi Michael,

I am integrating MII 11.5 with Xcelsius 2008.

I went through the pdf document to perform integration and tried to create a similar application but instead of using MII Transaction call, I am using Direct Connection to MII Query whose output is transformed to xml format required for Xcelsius using the xsl file given by you. The transform and Query is working fine when I run it through browser url.

But when i configure the same in XML Data Connection in Xcelsius and when clicked on Preview XML I don't see any data. I just see the standard xml structure like this

- <data>

- <variable name="SAPMII_1">

- <row>

<column />

<column />

</row>

</variable>

</data>

I would like to see data on line chart coming from MII 11.5

I guess I am missing out something here....

Please help me....

Regards,

Adarash

[agentry_src · Accepted solution]

Hi Adarash,

Please create a new message as we are now on a new topic.

Thanks,

Mike

[sidnooradarsh · Accepted solution]

Sorry...... I will start new thread..

Thanks,

Adarsh

[Former Member · Accepted solution]

Hi Michael,

Is there a place i can download the transaction? Or can i send you an e-mail to get the transaction?

Thanks and Regards,

Ram

[agentry_src · Accepted solution]

Ram,

Send a message.

Thanks,

Mike

[Former Member · Accepted solution]

Hi Michael,

     I am beginner here, and can not send message to you directly.

     I want to get the doc references an MII transaction that is 'Attached' called SAPMIIBOBJIntegration,can you send a e-mail or message to me ?

Thanks

Lin