From OpenI Wiki

Table of contents

1 Overview 2 Problems 3 Relevant Components 4 Time Series

Overview

currently data is handled completely categorical. Even if the data is better suited as time. Creates problems with the types of visualization options.

Problems

• Testablity - Code is inherently not testable - development cycle will be X3 if this was not addressed.
• refactoring - goes hand in hand with testability issues. Components and functionality need to be extracted, just to make things testable.

Relevant Components

• DatasetAdapter (new) - converts a jpivot OlapModel, to a JFreeChart dataset
• ChartCustomizer (new) - customizes chart based on analysis properties
• AxisLabelGenerator (new) - parses OlapModel, extracts proper axis labels
• EnhancedChartComponent (modified) - to handle and call the new help classes, added new chart type (19 - Time Series)
• XmlaTester (new) - makes an xmla query, allows command line xmla query and result, creates chart images as png and jpg. Very rough, but helpful
• ChartCreator (new) - creates charts in an application frame (not interactive, similar in style to jfree chart samples). Also very rough, but helpful.
• minichartpropertiesform.xml, chartpropertiesform.xml - added chart type 19, Time Series

Time Series

• Cube configuration
  • configure a time dimension with no levels
  • data must include the full date type (to be parsed by openi)
  • Date must be in this format: yyyy-MM-dd HH:mm:ss
• analysis
  • time dimension must be on rows
  • only the time dimension can be on rows
  • can have several dimensions on columns, each will have it's own series