Tree Structure Display in MII

[Former Member]

Hi,

I am current using SAP MII12.1 SP10.

I have a requirement to display the data in the tree structure in the way as discribed below.

Parent--

               Child

                         Sub-Child

                         Sub-Child

                         Sub-Child

                         Sub-Child

Parent --

               Child

                         Sub-Child

                         Sub-Child

                         Sub-Child

I tried using the ibrowser to achieve this where in i created a static xml file and loaded that as the input for the XML Query Template. Used the output of this XML Query template as the input for the ibrowser. It is giving me the structure as expected.

But my actual requirement that the structure is not a static i.e. the Sub-child may be of any number of counts and  there will be morethan one set of parent-->child--> Sub-Child groups.

I need to fetch the data from the database and populate this structure.

Kindly suggest how to implement the same.

All your support is highly appriciated.

regards,

Senthilmanivenkatesh.B

[Former Member · Accepted solution]

Hi Senthilmanivenkatesh ,

  To load the XML dynamically to the iBrowser, you could use a transaction to pass the output to the query template.

1. Create a transaction-> get the required data from database using sql query.

2. Create an transaction property of type XML and mark it as Output.

3. Loop through the output of the SQL query and form the desired XML structure.

4. Attach the final XML to the Output parameter.

Now instead you XML Query, you could use Xacute Query. Pass the transaction name as the parameter to Xacute Query. This query would now execute your transaction and give you the desired output.

Refer SAP Manufacturing Integration and Intelligence for details on Xacute query parameters.

Regards,

Tufale Ashai

[Former Member · Accepted solution]

Hi Senthilmanivenkatesh,

You can write an XSLT to get the output in the desired format based on the sub nodes each parent node contains. This will optimize the performance of your transation/query as well.

Thanks & Regards,

Anuj