Difference between revisions of "Chart into Application Dictionary"
From ADempiere
This Wiki is read-only for reference purposes to avoid broken links.
(→Overview) |
(→Technical team) |
||
(20 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 change is to allow one of more graphs/charts to be displayed in any ADempiere window. | ||
Line 10: | Line 12: | ||
== Purpose == | == Purpose == | ||
== References == | == References == | ||
+ | |||
+ | [[File:Window_chart_setup.pdf]] | ||
+ | |||
== Design Considerations == | == Design Considerations == | ||
===Assumptions=== | ===Assumptions=== | ||
Line 16: | 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 21: | 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
Contents
- 1 Status
- 2 Contributors
- 3 Overview
- 4 Purpose
- 5 References
- 6 Design Considerations
- 7 Glossary
- 8 Functional Requirements
- 9 Functional team
- 10 Acceptance criteria
- 11 QA and test cases
- 12 Development infrastructure
- 13 Technical Requirements
- 14 Technical team
- 15 Data Requirements
- 16 Non-Functional Requirements
- 17 Open Discussion Items
- 18 Closed Discussion Items
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
Design Considerations
Assumptions
Dependencies
Constraints
Glossary
Functional Requirements
Functional team
- Volunteers for analyzing:
- 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
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
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