ACE Analytics CDML Examples

Here are some examples of CDML in action in applications:

Creating a 2-Line Axis Title

As shown above, a simple <*br*> tag is used in the Label Title attribute to produce a 2-line title.

Using Subscripts in an Axis Title

1. As shown above, the <*block*> and <*/block*> tags are used in the Data Title attribute to delimit the new font style.
2. The <*sub*> tag specifies the new style, i.e. subscript.
3. The <*/font*> tag ends the new style and returns to the original style.

Setting Font Size and Adding Superscript in an Axis Title

1. As shown above, the <*block*> and <*/block*> tags are used in the Label Title attribute to delimit the new font style.
2. The <*size*> and <*super*> tags are used to define the new font styles.
3. The <*/font*> tag ends the new style and returns to the original style.

Creating a 2-Line Data Label

To format data using CDML, it's necessary to first add a column to the datalayer to contain the formatted data.

1. As shown above, a Calculated Column is used to combine the data from two columns and add a <*br*> tag in between them to put the data on two lines.

2. The chart's Label Column X-axis attribute value is then set to the name of the calculated column, as shown above.

Alternately, instead of using a Calculated Column element, the results shown in the example above could also be achieved by including CDML right in the SQL query. For example:

SELECT FQuarter + '<*br*>' + RIGHT(FYear,2) AS calcQuarterYear FROM SomeSQLTable

would return a column that concatenated the values from two others with the CDML tag needed to insert the new line.