cancel
Showing results for 
Search instead for 
Did you mean: 

xMII_Display templates

Former Member
0 Kudos

Dear Sir,

i am newly working in xMii, i have doubt in Display templates, that is "How to use the value columns,label,description columns,data link columns,and axial labelcolumns?

please explain me with example.

Thanks And Regards,

Murali.A

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

Check the forum before asking these questions. It has been asked by some one and answer is also given.

The answer is Value Columns : Used to map the values for which you want to plot the chart (like temperature, pressure..)

Label Columns : This type of requirement you will be having for the Bar charts where for each data you may need to give description like

Example : For Batch B001 -> production cost 20,000.

For Batch B002 -> production cost 25,000.

In this case B001 and B002 are your Label columns and 20,000 and 25,000 are value columns.

Description columns : This type of requirement you will be having for the Bar charts where for each data you may need to give description like

Example : For Batch B001 -> production cost 20,000.

For Batch B002 -> production cost 25,000.

This is your data. If you want to give description like started production on 15/05/2006 and 21/08/2006 on selection of the bar. Then it will be displayed.

DatalinkColumns : This is mainly is required when you need more info from the same bar at that time you may add the plant name column as the datalink item. Then on the selection of the batch data you can get the datalink item i.e name of the plant on which it is produced can get from the datalink item. Methods for this is getChartObject().getDataLinkItem().

AxisValueColumn : This is X-axis column for your plot. Suppose you want to draw a plot for (x1,y1), (x2,y2).. in this case, x1,x2 are your label columns under column named X and y1,y1 are under column named y which is value column. In the case of tag query it will be Date time as default. These values also displayed on the X-Axis also.

And for the remaining tabs help is enough to understand...

By

Rajesh

The thread is :

Hope this helps for you...

Regards,

Kishore kumar P.S.

Message was edited by:

kishore

Former Member
0 Kudos

Murali,

The first thing you have to do with a display template is choosing the form of diaplay

whether you want a line or bar,etc. in the general tab

Then link your query template that can return a result set in the data mapping tab

In case you choose a xbar chart, you have to add the columns that you wish to diaplay in the chart in value column

For example you want to show Planned and actual yield, link planned and actual yield columns in your query result set to value columns

Regarding the datalink column it is used for linking to other applets.I dont have much idea on this

Axis value column is where you can declare what your x-axis is going to be.

In case you want to plot planned actual yield against each order number then order number becomes your axis value column.

thanks,

Ajitha

Former Member
0 Kudos

Hi Murli,

It depends on type of display template ,here you can see for iChart.

ValueColumns:- This controls which data columns in a query will be used as the values to plot on the chart.

label:-

This controls which data columns in a query will be used to create "virtual tag names" when the chart is drawn. This set of parameters is typically not needed when the query source is a Tag connector, but is required when the source is a SQL or Alarm connector

data link columns:-

This controls which data columns in a query will be used to create "datalink" items associated with each item in the legend. This is convenient means of associating special column values such as a part code, downtime ID, or other internal key field that has no meaning to the end user but is valuable when cross-correlating or linking with other applets. The first mapped Datalink column is also used by the MouseTracking feature.

axial labelcolumns:-

This is used to create explicit X-Axis values from a returning column in the query

For more details you can look here.

http://help.sap.com/saphelp_xmii115/helpdata/en/index.htm

Regards

Ramshanker