DBGate Sample 20 - Cube App

This sample shows two ways to create forms to view and edit cube data.

Usually, such forms have dimension members in three axes: page, columns, and rows. Below is a sample.

The "traditional" way, described in previous samples, requires the following objects:

• usp_form_01 A procedure to select data
• usp_form_01_change A procedure to update data
• xl_list_category_id A procedure to select category_id parameter values
• xl_list_entity_id A procedure to select entity_id parameter values
• Parameter values A configuration of the parameter value lists

Here is a form sample for this (you can use the browser developer tools to analyze requests).

The form above is built with the following objects:

• usp_web_form_01 A procedure to select data
• usp_web_form_01_change A procedure to update data

The s20.usp_web_form_01 procedure returns the JSON object with arrays of parameters, columns, rows, and cells.

Both ways have pros and contra. You can choose the best way to fit your requirements.

Home | Sample 01 | Sample 02 | Sample 04 | Sample 13 | Sample 16 | Sample 17 | API Samples | Tab Framework | Budgeting | Planning

Code Browser

You can download samples for any supported database platform with the SaveToDB SDK.

© 2020-2024 Gartle LLC | www.savetodb.com | DBGate Guide | Developer Guide | Privacy Policy | Cookie Policy