To display data on a time axis, you pass appropriate time data to the graph, in one of the following ways:
Specify an OLAP time dimension on the group edge of the graph.
Pass java.sql.Date
objects as column labels to the setTabularData
method of the graph.
Specify date information as the column label elements in XML that you pass
in the setXML
method of the graph.
If you set a BI Beans Query object in the DataSource
property
of the graph, then you can use properly defined OLAP time dimensions for the
time axis of the graph. Properly defined time dimensions have the end date specified,
as well as a defined span of time. The graph uses the end date property of the
dimension.
In the Graph Layout panel, move the time dimension to the group edge of the
graph. The time dimension should be the only dimension that appears on the group
edge in the Graph Layout panel. In the DataAccess
, the time dimension
should be on the column edge, if rows are mapped as series.
If rows are mapped as groups, then the time dimension should be on the row edge.
For bar, line, area, and combination graphs, the time dimension should occupy
the only layer of the edge. For stock
graphs, the time dimension should occupy layer 0.
When you use the setTabularData
method to pass data to a graph,
simply pass dates as java.sql.Date
objects as the column labels
(or the row labels, if rows are mapped as groups).
When you use XML to set date information on a graph, you set the timeAxis
attribute of the data element to true, and pass the dates as the column labels
(or row labels, if rows are mapped as groups) in the data. You must also set
the dateFormat
attribute of the data element, to specify the form
of the date data.
Specifying
Graph Data Through the setTabularData Method
Specifying XML Data in Grid
Form
Specifying XML Data in Relational
Form
Time Axis Intervals