cancel
Showing results for 
Search instead for 
Did you mean: 

How to add dynamic columns

Former Member
0 Kudos

Please can anybody help me that how to add dynamic columns using xmii document

Accepted Solutions (1)

Accepted Solutions (1)

agentry_src
Active Contributor
0 Kudos

This is the simple way and I suggest that once you have this in place, you play around with other options.

Create a new Transaction and add 6 sequences.

In the first sequence. Add an MII Document action block, but do not define any columns yet.

In the next sequence add an MII Rowset and link it to the MII document and configure it to link to your MII Document Output.

In the next sequence add an MII Column. Configure it linked to your MII Document Output with name of TestString (or whatever) and define a type as String.

In the next sequence add an MII Row and configure it to link to your MII Document Output.

In the next sequence add an MII Data Item. In the link editor (can also use the Configure editor), there are three fields under Data Item (on the right side window). Write in "Document_0.Output" as the expression for IlluminatorDocument. "TestString" for the Name (the column name created when you added the MII Column), and datenow (or "testing" or 1234) as the expression for the property Value.

Add a sequence with a tracer and link the Document Output to the Tracer Message property. Alternatively assign the Document Output to a Transaction property named OutputXML of type xml and with Output checked.

Execute the transaction and you should see the Output document with Rowset, Row, one field node with the Name TestString and value of datenow (or whatever) under the Row.

Once that works add some more columns of different types, put a repeater in to handle data from a data source, add more data items, etc. In other words, play around with it.

If you use a DateTime column name, Applets with recognize it as such and make formating your y-axis a bit easier.

Good luck!

Mike

Answers (1)

Answers (1)

sidnooradarsh
Contributor
0 Kudos

Hello,

Refer this Blog [Dynamically Create a Document|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21456] [original link is broken] [original link is broken] [original link is broken];

Hope this helps!!

Regards,

Adarsh