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:

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.