I am in the process of creating a custom component for OA Framework called Pivot Table which has similar features of Microsoft Excel Pivot Table, but UI more inline with OA Framework. I am releasing the first (beta) version. It is meant to be used with table region, preferably a read only table. But it can be used independently. Currently it supports only single level of summary and needs to be added to your page from JDeveloper. Future vesions will have multiple levels of summary and ability to add it through personalization. Following are the steps to use it in your page.
1. Download the beta version.
2. Follow the installation steps in ReadMe. It is simple.
3. Add a stackLayoutRegion below the table region region of your page.
4. For the above stackLayoutRegion, set the extends property as
/ramble/oracle/apps/qa/component/pivot/ui/webui/PivotSharedRN
5. Set User Defined: Attribute1 in Property Inspector as the View Object Instance name of the table region.
Pivot Table has two regions
Pivot Parameter Region:
It will have four picklist.
- Row - Pivot row which will show all attributes of Source VO set in step 5. Can be null.
- Column - Pivot column which will show all attributes of Source VO set in step 5. Can be null
- Data - Pivot data which will show all attributes of Source VO set in step 5. Has to be Number attribute if you want some statistical function from pivot table.
- Function - Pivot data function. Currently supports COUNT, SUM, AVERAGE, MIN and MAX.
Result Region
Based on the parameter region and if the pivot source specified in step 5 is executed, user can press "REFRESH" to see the pivot summary.
I am working on final version of release 1.0 and will come up with better documentation soon.
No comments:
Post a Comment