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_validation_list_category_id A procedure to select category_id parameter values
xl_validation_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 way (you can use the browser developer tools to analyze requests).

The form above is built with the following objects:

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 may choose the best way to fit your requirements.

Code Browser

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