In order to install and use the APEX SmartPivot Plugin, you need to have Oracle APEX version 5.1 or higher installed.
(APEX 5.0 is supported up to version 1.2.11 of the SmartPivot Plugin. If you want to use the APEX SmartPivot Plugin with APEX 4.2, you will need to install version 1.0. This version is still supported but new features will not be available)
APEX 5 needs to be configured with Static File Support in order to be able to use the SmartPivot Plugin in an application. Refer to the Oracle Application Express Installation Guide on how to install and configure Static File Support:
Configuring Static File Support
Alternatively you can install the APEX SmartPivot Plugin static files on your web server. Refer to the section Server Files Support in this document.
Connect to the database schema that is the parsing schema for your application, usually the same schema your workspace is associated with. Execute the sql-script smart_pivot_db_install.sql in this schema. This script will create one table (SMART_PIVOT_LAYOUTS) and one package (SMART_PIVOT). These objects are mandatory for the plug-in to function.
With this installation package there is a plug-in installation file named:
Navigate to “Shared Components > Plug-ins” and click Import >. From there you can follow the menu to upload and install the plug-in using the file above.
In order to be able to use the plug-in functionality, you need to enter a valid (demo-) license key and the related User Information provided. If you do not have a license key yet, please contact firstname.lastname@example.org.
The APEX SmartPivot plug-in has a number of settings that have to be configured for each application using Component Setting (Application nnn > Shared Components > Component Settings > Edit):
Enter the license-key string and company name in the first two fields, exactly as you received in your email.
The APEX SmartPivot plug-in support two options for accessing the necessary asset and library files that will be loaded when using the plug-in in a page:
To upgrade to a newer version of the APEX SmartPivot Plugin, just follow the installation steps. You always have to install both, Database Objects and Plugin Import, of the new version.
Because all the data to calculate the aggregated pivot result has to be downloaded to the user's browser to enable filtering and sorting features of the SmartPivot plug-in, datasets could be very large. To limit the amount of data, you as developer can apply different measures:
To enable linking to a specific saved layout (other than the default layout) of a page, you can fetch the layout name from an APEX Page Item. The item must contain the name prefixed by the user sharing the layout. The sharing user can be found in the load/save dialog or by querying the SmartPivot layout table. Here an example query to generate possible link URLs for existing saved and shared layouts for page 1 in application 100, passed to item P1_INITIAL_LAYOUT as parameter:
select l.application_id ,l.page_id ,l.apex_user ,l.layout_name ,l.apex_user || '.' || l.layout_name item_ ,apex_util.prepare_url (p_url => 'f?p=' || :app_id || ':1:' || :app_session || ':1:NO::P1_INITIAL_LAYOUT:' || l.apex_user || '.' || l.layout_name) url from smart_pivot_layouts l where application_id = 100 and page_id = 1 and is_shared = 'Y' order by apex_user, layout_name, page_id;
The layout name has to be specified as "sharing user"."layout name". The "layout name" part of the value is case-sensitive.
If the specified laout name is not found, the default layout will be shown.
Parameter: pageItems, optional. Identifies the page or column items that will be included in the request.