Difference between revisions of "Chart into Application Dictionary"

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.
(→‎Status)
(→‎Technical team)
 
(21 intermediate revisions by 3 users not shown)
Line 3: Line 3:
  
 
== Contributors  ==
 
== Contributors  ==
 +
Adaxa Pty Ltd  (Paul Bowden)
 +
 
== Overview  ==
 
== Overview  ==
 +
The change is to allow one of more graphs/charts to be displayed in any ADempiere window.
 +
 +
The records which are included in the displayed data are able to be returned in the window by double-clicking on the relevant data element in the chart.  (functionality provided by the library(.  For example if you were looking at a chart of sales order information then clicking on an element called "Quotes" can open the sales order window and select the records making up the displayed value.
 +
 
== Purpose  ==
 
== Purpose  ==
 
== References  ==
 
== References  ==
 +
 +
[[File:Window_chart_setup.pdf]]
 +
 
== Design Considerations  ==
 
== Design Considerations  ==
 
===Assumptions===
 
===Assumptions===
Line 12: Line 21:
 
== Glossary ==  
 
== Glossary ==  
 
==Functional Requirements==
 
==Functional Requirements==
 +
== Functional team  ==
 +
*Volunteers for analyzing:
 +
** [[User:mar_cal_westf|Mario Calderon]] 20:00, 21 June 2013 (UTC) - Functional Review
 +
===Result of review by Mario Calderon, June 21st, 2013===
 +
*Configuration done completely as SystemAdministrator (Application dictionary)
 +
*First, the Chart hast to be defined
 +
**Name
 +
**Chart type (bar,line, pie, ring, area, 3D, etc.)
 +
**Orientation (horizontal, vertical)
 +
**Label for Domain and Range (X and Y if orientation is vertical)
 +
**Height
 +
*Then, the data of the chart has to be defined
 +
**Table
 +
**SQL (select part)
 +
**SQL where
 +
**Key column
 +
**Value column
 +
*Configuring chart in window
 +
**Select table where you want to insert the chart
 +
**Create a new column
 +
**Reference: ''Chart''
 +
**Field ''Chart'': select the chart you defined before
 +
**Synchronize column
 +
**go to window tab, create Fields from table
 +
*Log in as GardenAdmin
 +
**Open window: chart is displayed, even with "normal" flieds
 +
*Example: Sales Rep Dashboard in CRM (http://www.adempiere.com/Sales_Management_%28CRM%29)
 +
*Summary
 +
**A very easy way of including data in any window
 +
**Any data which can be conveyed via SQL and enviroment variables can be displayed
 +
**Results are calculated on the fly
 +
**You have to play areound with chart types, orientation, SQLs, names of X and Y axis, values
 +
*'''Conclusion: a very helpful tool'''
 +
 
===User roles & profiles===
 
===User roles & profiles===
 
===Business process definition===
 
===Business process definition===
Line 17: Line 60:
 
===Functional requirements based on business processes===
 
===Functional requirements based on business processes===
 
====User Interface Mockups====
 
====User Interface Mockups====
 +
 +
Please see attached pdf for screenshots and guide.
 +
 +
.... struggling to get a pdf to upload into here .. if someone can assist please let me know.  thanks ssackett  @  adaxa.com
 +
 +
 +
[[File:xx.pdf]]
 +
 
== Acceptance criteria  ==
 
== Acceptance criteria  ==
 
== QA and test cases ==
 
== QA and test cases ==
 
== Development infrastructure  ==
 
== Development infrastructure  ==
 
== Technical Requirements ==
 
== Technical Requirements ==
 +
== Technical team  ==
 +
*Volunteers for analyzing:[[User:Redchris|Cristina Ghita]]
 +
*Result of analysis:
 +
** Missing license text from classes MChart , MChartDatasource, VChart
 +
** Missing java docs from class MChart , MChartDatasource
 +
** code readable and well-formatted
 +
** covers swing and zk
 +
 
== Data Requirements ==
 
== Data Requirements ==
 
==Non-Functional Requirements==
 
==Non-Functional Requirements==
 
==Open Discussion Items==
 
==Open Discussion Items==
 
==Closed Discussion Items==
 
==Closed Discussion Items==

Latest revision as of 05:59, 2 September 2013

Status

in production use.

Contributors

Adaxa Pty Ltd (Paul Bowden)

Overview

The change is to allow one of more graphs/charts to be displayed in any ADempiere window.

The records which are included in the displayed data are able to be returned in the window by double-clicking on the relevant data element in the chart. (functionality provided by the library(. For example if you were looking at a chart of sales order information then clicking on an element called "Quotes" can open the sales order window and select the records making up the displayed value.

Purpose

References

File:Window chart setup.pdf

Design Considerations

Assumptions

Dependencies

Constraints

Glossary

Functional Requirements

Functional team

  • Volunteers for analyzing:

Result of review by Mario Calderon, June 21st, 2013

  • Configuration done completely as SystemAdministrator (Application dictionary)
  • First, the Chart hast to be defined
    • Name
    • Chart type (bar,line, pie, ring, area, 3D, etc.)
    • Orientation (horizontal, vertical)
    • Label for Domain and Range (X and Y if orientation is vertical)
    • Height
  • Then, the data of the chart has to be defined
    • Table
    • SQL (select part)
    • SQL where
    • Key column
    • Value column
  • Configuring chart in window
    • Select table where you want to insert the chart
    • Create a new column
    • Reference: Chart
    • Field Chart: select the chart you defined before
    • Synchronize column
    • go to window tab, create Fields from table
  • Log in as GardenAdmin
    • Open window: chart is displayed, even with "normal" flieds
  • Example: Sales Rep Dashboard in CRM (http://www.adempiere.com/Sales_Management_%28CRM%29)
  • Summary
    • A very easy way of including data in any window
    • Any data which can be conveyed via SQL and enviroment variables can be displayed
    • Results are calculated on the fly
    • You have to play areound with chart types, orientation, SQLs, names of X and Y axis, values
  • Conclusion: a very helpful tool

User roles & profiles

Business process definition

User stories

Functional requirements based on business processes

User Interface Mockups

Please see attached pdf for screenshots and guide.

.... struggling to get a pdf to upload into here .. if someone can assist please let me know. thanks ssackett @ adaxa.com


File:Xx.pdf

Acceptance criteria

QA and test cases

Development infrastructure

Technical Requirements

Technical team

  • Volunteers for analyzing:Cristina Ghita
  • Result of analysis:
    • Missing license text from classes MChart , MChartDatasource, VChart
    • Missing java docs from class MChart , MChartDatasource
    • code readable and well-formatted
    • covers swing and zk

Data Requirements

Non-Functional Requirements

Open Discussion Items

Closed Discussion Items

Retrieved from "http://www.adempiere.com/index.php5?title=Chart_into_Application_Dictionary&oldid=8226"