ODataDB Sample 20 - Cube App

This sample demonstrates two methods for creating forms to view and edit cube data.

Typically, these forms display dimension members across three axes: page, columns, and rows. Below is an example.

The "traditional" method, 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 your browser's developer tools to analyze requests).

The form above is built using 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 a JSON object containing arrays of parameters, columns, rows, and cells.

Both methods have their pros and cons. Choose the one that best fits 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 using the SaveToDB SDK.

© 2025 Gartle LLC | www.odatadb.com | ODataDB Guide | Developer Guide | Privacy Policy | Cookie Policy