RE: sap xmii rowset

[Former Member]

Hi all,

can any one say what is the use of sap xmii rowset transaction, when we should go for it and if possible any example of it.

Thanks & Regards,

u.kchaitanya

[erik_schrampf]

Krishna,

One of the main reasons you would want to format data into xMII Rowset format, is if you want to display your data using xmii. Such as grids, charts, spc charts, etc. These visualization templates can only display the data if it is in this xMII format. There is an example if the help for 11.5 which explains how to use those action blocks.

Here is a simple example of the format

- <Rowsets DateCreated="2007-08-13T08:53:49" EndDate="2007-08-13T08:53:49" StartDate="2007-08-13T07:53:49" Version="11.5.3">

- <Rowset>

- <Columns>

<Column Description="DateTime" MaxRange="1" MinRange="0" Name="DateTime" SQLDataType="93" SourceColumn="DateTime" />

<Column Description="AssetUtil1" MaxRange="95" MinRange="88" Name="AssetUtil1" SQLDataType="8" SourceColumn="AssetUtil1" />

<Column Description="AssetUtil2" MaxRange="95" MinRange="85" Name="AssetUtil2" SQLDataType="8" SourceColumn="AssetUtil2" />

</Columns>

- <Row>

<DateTime>2007-08-13T07:53:49</DateTime>

<AssetUtil1>95</AssetUtil1>

<AssetUtil2>92.6029162727</AssetUtil2>

</Row>

- <Row>

<DateTime>2007-08-13T08:23:49</DateTime>

<AssetUtil1>91.818667599233</AssetUtil1>

<AssetUtil2>88.718256407329</AssetUtil2>

</Row>

</Rowset>

</Rowsets>

Regards,

Erik

[Former Member]

Thanks all for ur replies

[Former Member]

Hi Krishna,

The Illuminator Rowsets/Rowset/Row format allows the data to be queried via an XacuteQuery. If you haven't been, I strongly recommend partcipation in xMII training classes, where you will learn how to build and query an Illuminator document.

Kind Regards,

Diana Hoppe

[Former Member]

hi,

xMII XML document is used to create new XML document in xMII XML format. rowset is used for creation of rowset in xMII XML format. xMII XML format should be as rowset-> column-> row -> data item. for xMII XML format refer http://<server name> /LighthammerCMS/Help/Business_Logic_Services/illuminator_xml_format.htm.

- senthil

p.s: please award points..