cancel
Showing results for 
Search instead for 
Did you mean: 

Xcelsius integration in MII

Former Member
0 Kudos

Hi, I have created the html and .swf from Excelsius and sucessfully imported in MII (under Web). I would like to integrated this swf with new value from MII transaction. Threfore I have created an xml output of my transaction which holds exact format of the swf. However when I run the html file (code as below) , I do not get the new value from the transaction. Infact the transaction is not executed at all (I checked thin in transaction manager)

uFEFF<HTML>
<HEAD>
<TITLE>Excelsius.swf</TITLE>
</HEAD>
<BODY>
<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="http://fpdownload.adobe.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0" 
WIDTH="601" HEIGHT="310" id="myMovieName">
<PARAM NAME=FlashVars VALUE="MIIServer=http://<serverName>:50000/XMII/Runner?OutputParameter=Output&Transaction=Excelsius_play/Untitled" 
">
<PARAM NAME="movie" VALUE="Excelsius.swf"> 
<PARAM NAME="quality" VALUE="high">
<PARAM NAME="bgcolor" VALUE="#FFFFFF">
<PARAM NAME="play" VALUE="true">
<PARAM NAME="loop" VALUE="true">
<PARAM NAME=bgcolor VALUE="#FFFFFF">
<EMBED src="Excelsius.swf" quality=high bgcolor=#FFFFFF WIDTH="601" HEIGHT="310" 
NAME="myMovieName" ALIGN="" TYPE="application/x-shockwave-flash" 
play="true" loop="true" 
FlashVars="MIIServer=MIIServer=http://<serverName>:50000/XMII/Runner?OutputParameter=Output&Transaction=Excelsius_play/Untitled" 
 
PLUGINSPAGE="http://www.adobe.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash">
</EMBED>
</OBJECT>
</BODY>
</HTML>
 

any Idea?

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi, You should connect the SAP MII server through DataManager (using either XML Data or webservices ) of Xcelsius,if you connect via XMLData connector -From SAP MII transcation URL ,the xml should be in the below format

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

<data>

<variable name="Range_3">

<row>

<column />

</row>

</variable>

</data>

Here Range_3 is the variable(Column of a excel sheet), Format the data and load it on excel of Xcelsius

I hope this would be helpful to you

-Subramaniyan Thangavel

http://sapmiiapps.blogspot.com/

Former Member
0 Kudos

Hi Subramaniyan

thank you for answering but this is not what I am looking for. I do not want to connect to Xcelsius application. What I would like to do is running the .swf in MII application itself. I have created/exported the .html & .swf from Xcelsius and imported in MII.

After that I would like to feed new data from transaction to this .swf . I have created the transaction and the output of the transaction has exact XML structure that Xcelsius need. But when i run the .html , the transaction was not invoked

jcgood25
Active Contributor
0 Kudos

MIIServer=http://<serverName>:50000/XMII/Runner?OutputParameter=Output&Transaction=Excelsius_play/Untitled

A parsing issue? Do you need to encode the "=" symbols on the right side of the MIIServer property?

I would discourage the use of fully qualified URL's and keep a relative path as much as possible. If someone logged in using the IP address (or the app was running on a different landscape or port) then their session would prevent the URL from hitting MII for the transaction - the response to the URL would likely be the NetWeaver Login page html (not the anticipated XML).

Former Member
0 Kudos

Hi Jeremy

What do you mean by encoding "="? I got this code from document "Using SAP MII as Data Source and Environment for Business Objects Xcelsius" by An Navaneeth and Stephan Boecker.

The use of fully qualify URL is just a quick and dirty example for testing purposes. Thank you for the suggestion.

Edited by: Seng Kiang Hoe on Jun 22, 2011 2:04 PM

I encoded the "=" to %3d but still not working

Edited by: Seng Kiang Hoe on Jun 22, 2011 2:04 PM

agentry_src
Active Contributor
0 Kudos

Hi Seng,

Please export the .xlf as html (which will generate the swf), but with a new name. I found problems (possibly the OBJECT classid exporting to the same name so I simply added an index to the name and incremented every time I exported my page.

You can also simply export the swf file with the name index incremented, but then you have to copy and paste the names and classid into the html and I found that took longer with more opportunity for fat fingering the links.

Regards,

Mike

Edited by: Michael Appleby on Jun 24, 2011 5:35 PM

Former Member
0 Kudos

Hi Michael

I noticed this problem also, but it is not my original Problem that I posted in this thread.

The problem that I am facing is the that the when the HTML is executed (running), it does not tirgger my MII transaction.

agentry_src
Active Contributor
0 Kudos

What is the name of your transaction? It looks like it is named Untitled which sounds a bit odd.

Also why did you include the FlashVars in the html. I usually don't do that and let the swf handle it directly.

And I noticed that you have in the second FlashVars "MIIServer=MIIServer=http...". This may be your issue.

And where did you store your swf file in MII? It should be under the Web tab.

How do you have your Data Connection set up?

Do you have placeholder sample data in the Excel section?

Is the data mapping location correct?

Did you use Stephan's trx to change the xml format from standard MII to Xcelsius standard?

If you need that trx, let me know. I will deliver it to you.

Regards,

Mike

Edited by: Michael Appleby on Jun 29, 2011 6:57 PM

Former Member
0 Kudos
What is the name of your transaction? It looks like it is named Untitled which sounds a bit odd. 

Yes it is named Untitled.

Also why did you include the FlashVars in the html. I usually don't do that and let the swf handle it directly.
And I noticed that you have in the second FlashVars "MIIServer=MIIServer=http...". This may be your issue.

It was a typo and corrected it, however the problem persist

And where did you store your swf file in MII? It should be under the Web tab.

Yes they are under Web tab

How do you have your Data Connection set up?

In Excelsius under Data Manager - Flash Variable

Do you have placeholder sample data in the Excel section?

I removed the data sample in Excel section before export HTML

Is the data mapping location correct?

I have double check, the mapping location is correct

Did you use Stephan's trx to change the xml format from standard MII to Xcelsius standard? 
If you need that trx, let me know. I will deliver it to you.

No I dont have his trx but I created my own trx which having the exact same structure as written in his document

I dont mind if you send me the trx

Regards,
Mike

thanks sengkiang

Edited by: Seng Kiang Hoe on Jun 30, 2011 10:03 AM

agentry_src
Active Contributor
0 Kudos

Hi again,

Please hard code your data manager link in the Excel portion and execute that from Xcelsius. If that works in Xcelsius, export the HTML as a new name, copy into MII and execute. If that works then try to use the FlashVars and see if you can make them work properly. I am not sure, but I get the feeling that there is a syntax issue somewhere in the data sourcing area.

Good luck,

Mike

I will forward the trx to you on Friday.

Edited by: Michael Appleby on Jun 30, 2011 1:18 PM