Chart into Application Dictionary
From ADempiere
Revision as of 20:21, 22 June 2013 by Mar cal westf (Talk) (→Result of review by Mario Calderon, June 21st, 2013)
This Wiki is read-only for reference purposes to avoid broken links.
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:
- Result of analysis: