Creating a grid for tag queryies

[Former Member]

Hi,

I want to create a grid having three column speed, Yield and KPI. For this I am getting data from 2 tag query . First tag query will return

First Query returns L1, L2, L3, L4 Speeds. Mode - Current

Second Query returns L1, L2, L3, L4 Yields Mode u2013 Current.

Use BLS to calculate

u2022 (L1Speed*L1Yield)/200

u2022 (L2Speed*L2Yield)/200

u2022 (L3Speed*L3Yield)/200

u2022 (L4Speed*L4Yield)/200

Now i want to create grid like this

Show a grid on the page in the following format:

S.No Speed Yield KPI

1 L1Speed value L1Yield value The above calculated value

2 L2Speed value L2Yield value The above calculated value

3 L3Speed value L3Yield value The above calculated value

4 L4Speed value L4Yield value The above calculated value

Please tell me how to do it?

[Former Member]

Hi,

you can use the [SAP Help Link: SAP MII XML Output actions|http://help.sap.com/saphelp_mii121/helpdata/en/43/e80b59ad40719ae10000000a1553f6/frameset.htm].

- create a xml document with your 3 columns

- then build the rows and data items from your queries and calculations

Hope this helps.

Michael

[Former Member]

Hi Michael,

I tried doing that. but problem is tag parameter used as column. and i want them to come as a row in grid?

[Former Member]

If you want to transform rows to columns in your tag queries, you can use the predefined XSLT "RowToColumnTransform.xsl". You can find in MII in folder "/XMII/Stylesheets/". After flipping rows and columns, you can use a repeater to go through the rows. Use the [SAP Help link: XSL Transformation action|http://help.sap.com/saphelp_mii121/helpdata/en/43/e80b59ad40719ae10000000a1553f6/frameset.htm] to process the XSLT.

Use XPath to pick the query values and link them to your Data Item values. Also see the [XPath help|http://www.w3schools.com/xpath/default.asp].

Michael