Gartle Planning
Version 5.0, July 5, 2022
Contents
Introduction
Introduction to Gartle Planning
Gartle Planning is a ready-to-use planning application.
It uses Microsoft SQL Server as a back-end and allows using Microsoft Excel with the SaveToDB add-in, DBEdit desktop application, and DBGate and ODataDB web applications as clients.
Key features:
- Multiple companies or separate departments in a single database.
- Customizable dimensions and dimension members;
- Customizable calculation rules with multiple hierarchies;
- Customizable input forms and reports;
- Built-in permission management;
- Built-in change tracking.
Here is an example of a customizable form:

You may download sample workbooks at [www.savetodb.com](https://www.savetodb.com/download.htm) and try the application hosted online.
Also, you may try Gartle Planning with the DBGate and ODataDB web applications:
- https://dbgate.savetodb.com/en-us/planning-app.htm
- https://odatadb.savetodb.com/en-us/planning-app.htm
Feel free to contact us.
We can deploy a copy for you in the cloud to test and configure the app.
Later we can export your data to deploy it in your environment.
Change History
Version 5.0, July 5, 2022
Impovements:
- The application supports SaveToDB 10.0, DBEdit 2.0, DBGate 2.0, ODataDB 4.0.
- The application supports Chinese Simplified and Chinese Traditional.
- The application has updated procedures of validation lists and parameter values.
- The documentation integrated with new SaveToDB help and Developer Guide.
- The sample application changed to 2022.
Version 4.0, July 20, 2020
The application has a new name, Gartle Planning.
The application becomes entirely commercial. We do not deliver free source code.
New Features:
- The application allows using four clients:
- the SaveToDB add-in for Microsoft Excel,
- the DBEdit desktop application,
- and the DBGate and ODataDB web applications. - The application allows having multiple companies in a single database.
The direct access to the dbo25 schema is prohibited. - The application supports multiple languages in UI and user data.
It includes English, German, French, Italian, Spanish, and Russian translations by default. - All the tables have the created_by, created_on, modified_by, and modified_on columns and INSERT and UPDATE triggers to update the fields automatically.
Using the SaveToDB Change Framework to track changes is optional. - The application includes a new complete sample for a railway company.
The sample includes a complete set of Excel and DBEdit workbooks.
It has new application pages in the DBGate and ODataDB web applications.
The sample includes English, German, French, Italian, Spanish, and Russian translations. Users may change the language on-the-fly.
Version 3.1, January 27, 2020
The copyright changed to Gartle LLC, former Gartle Technology Corporation.
Impovements:
- Updated sample dates
Version 3.0, October 17, 2019
New Features:
- SaveToDB Planning Application 3.0 has two packages: public and paid.
The public package contains basic functionality, which is the best to learn features.
It has several encrypted stored procedures.
The paid package contains all features, including complete source codes. - The application does not require the following frameworks that become optional:
- SaveToDB Administrator Framework
- SaveToDB Developer Framework
- Database Help Framework
- Change Tracking Framework - The application allows using DBEdit 1.2 in addition to Microsoft Excel with SaveToDB to customize the app and input data.
- The application uses a new DBSetup.exe installer.
Version 2.6, February 5, 2019
Impovements:
- Removed dependency on the frameworks:
- Change Tracking Framework
- Database Help Framework
- SaveToDB Developer Framework
- SaveToDB Administrator Framework
You may install the application in a minimal configuration. - Updated frameworks:
- SaveToDB Framework 9.0
- SaveToDB Developer Framework 9.0
- SaveToDB Administrator Framework 9.0
- Change Tracking Framework 2.1
- Database Help Framework 1.1 - The planning_app_administrators role renamed to planning_app_admins.
- Renamed test users:
pa_admin_01 - planning_app_admin_01
pa_analyst_01 - planning_app_analyst_01
pa_developer_01 - planning_app_developer_01
pa_user_01 - planning_app_user_01 - Updated sample dates
Version 2.5, September 10, 2018
New Features:
- Complete database documentation
- Integrated [Database Help Framework](https://www.savetodb.com/help/database-help-framework.htm) 1.0
Impovements:
- Updated [SaveToDB Framework](https://www.savetodb.com/help/savetodb-framework.htm) 9.0
- Updated [Change Tracking Framework](https://www.savetodb.com/help/change-tracking-framework.htm) 2.0
- An updated set of application workbooks
- Other minor improvements
Diagrams
Diagram | Description |
---|---|
Diagram 01 | Application Architecture |
Diagram 02 | Master Data |
Diagram 03 | Calculation Rules |
Diagram 04 | Member Hierarchies |
Diagram 05 | String Values |
Diagram 06 | Source Cube |
Diagram 07 | Calculated Cube |
Diagram 08 | Form Layouts |
Diagram 09 | Form Rowsets and Parameters |
Diagram 10 | Member Relations |
Diagram 11 | Member Permissions |
Diagram 12 | Form Permissions |
Diagram 01. Application Architecture
The application has the following logic blocks:
- Master data
- Calculation rules
- Source cube
- String values
- Calculated cube
- Form settings
- Forms
- User permissions
- Tracking changes
Master data include dimensions, dimension members and its properties.
The application creates calculation rules to calculate aggregates based on master data and source cube.
The source cube contains number data entered by users or loaded from external systems.
The block of string values contains string values entered by users. The application does not aggregate such values.
The calculated cube allows getting the source and aggregated data in forms.
Form settings define available forms including their layouts, rows, columns, page data, and parameters.
The Forms block is an engine that executes configured forms to allow getting data and saving data back to a database.
User permissions is a block that allows managing user permissions on forms and dimension members.
Tracking changes is an optional block implemented with the Change Tracking Framework.
Diagram 02. Master Data
The master data includes:
- Currencies and units in the dbo25.units table;
- Tax rates in the dbo25.tax_rates table;
- Dimensions in the dbo25.dimensions table;
- Dimension members in the dbo25.members table;
- Dimension member parents in the dbo25.parents table.
Use the following procedures to edit master data:
xls25.usp_units, xls25.usp_tax_rates, xls25.usp_dimensions, xls25.usp_members.
The dbo25.calc_types and dbo25.name_formats table contains application defined values.
The dbo25.dimensions table contains seven dimensions.
The first four (Accounts, Times, Categories, and Entities) have specific built-in support and must be active.
Analysts may activate or deactivate the last three dimensions, and change their meaning.
Adding additional dimensions requires changes in the application code.
The dbo25.members table contains members of all dimensions.
It contains columns of the member calculation and display properties.
The application supports multiple hierarchies. Each member can have multiple parents.
The dbo25.parents table contains such relations.
The application allows editing parents and its factors using the xls25.usp_members procedure.
Diagram 03. Calculation Rules
Based on child-parent relations, calculation type, and previous periods,
the xls25.xl_actions_update_hierarchies procedure updates the dbo25.factors table.
This table is used to calculate aggregates and balances.
For example, for member parents A1 - A2 and A2 - A3 the factor table contains A1 - A2, A2 - A3, and A1 - A3.
Use the xls25.view_hierarchies view to check the generated rules.
Diagram 04. Member Hierarchies
Based on child-parent relations, the xls25.xl_actions_update_hierarchies procedure also updates the dbo25.hierarchies table.
This table is used to select members of the specified parent in forms.
For example, for member parents A1 - A2 and A2 - A3 the hierarchy table contains A1 - A1, A2 - A2, A3 - A3, A1 - A2, A2 - A3, and A1 - A3.
Use the xls25.view_hierarchies view to check the generated rules.
Diagram 05. String Values
The application stores string values in the dbo25.strings table.
The application does not aggregate such values.
So, it stores values for members at any hierarchy level.
The dbo25.strings table contains member id values in columns id1-id7.
If the dimension is not active, its column contains the dbo25.dimensions.default_member_id value.
To store string values, specify the string calculation type of the target account (dimension 1).
Diagram 06. Source Cube
The application stores number values in the dbo25.facts table.
The dbo25.facts table contains member id values in columns id1-id7.
If the dimension is not active, its column contains the dbo25.dimensions.default_member_id value.
The table contains source values of the user input, in the account currency or unit, in the source_value column.
The application calculates the cube values, in the system currency or base unit, and updates the value column immediately on input.
It uses the dbo25.currency_rates table values for currency accounts and just a dbo25.units.factor value for other accounts.
Use the xls25.xl_actions_update_facts procedure to update cube values after currency rate changes.
Note that the application uses hard-coded dimension id values:
1 - Accounts
2 - Times
3 - Categories
4 - Entities
Diagram 07. Calculated Cube
The application calculates aggregates and balances on the fly.
It uses the source and calculated cube values of the dbo25.facts table and calculation relations and factors from the dbo25.factors table.
You may use the code of the dbo25.view_facts view to learn the calculation rules.
The application uses the dbo25.members.previous_period_id and dbo25.member.same_period_id fields to select values of the referred periods.
Also, the forms output Excel formulas as is. Such values are calculated in Microsoft Excel.
Diagram 08. Form Layouts
The application allows creating any number of forms in the dbo25.forms table.
Analysts have to define the form layouts including:
- the dimension axis (row, column, page),
- the dimension order in the axis (header_order),
- and the parameter order at the ribbon (parameter_index).
Analysts may test any form using the xls25.usp_run_form and xls25.usp_run_offline_form procedures.
End users use the inherited forms with the predefined sets of the parameters.
They have to use the xls25.view_query_list_forms and xls25.view_query_list_offline_forms views in the SaveToDB Connection Wizard.
By default, the application shows child members of the dbo25.dimensions.root_member_id member in the parameters and axes.
Analysts may configure member lists using the feature described below.
Diagram 09. Form Rowsets and Parameters
Analysts may customize member lists for parameters, rows, and columns.
The fist option is to redefine dbo25.form_dimensions.root_member_id.
For example, you may set the "Sales" account as a parent for the "Sales" form.
The second option is to limit a member list in parameters by levels using the parameter_start_level and parameter_end_level parameters.
For example, the time dimension has a hierarchy: Times - Years - Year - Month.
If you need to show only years in the parameter, set Years as a root_member_id and 1 as parameter_start_level and parameter_end_level.
You may use the same technique for rows and columns.
Just use the form_start_level and form_end_level parameters instead.
For example, to show years only in columns, set Years as a root_member_id and 1 as form_start_level and form_end_level parameters.
And the final option is to define a member list completely manually.
Use it, for example, if you need to have selected rows from multiple hierarchies, add empty lines, or change codes, names, or Excel look of members.
To do this, create a member with calc_type_id = 9 (rowset) and add rows into the dbo25.form_rows table (you copy and paste rows in Excel).
Then rewrite any property of the underlying member in the row.
The application shows rowsets in the ribbon parameters automatically.
If you need to use the rowset only and to disable other options, set the rowset as the root_member_id value and clear the parameter_index value.
Diagram 10. Member Relations
The dbo25.member_relations table contains relations between members of different dimensions.
The first use case is eliminating rows in forms.
For example, the "Sales" account is not applicable for all entities.
So, you may set the select_permission to 0 for such pairs of the account and the required entities.
The second case is disabling data changes, for example, for closed periods.
In this case, you may set the update_permission to 0 for the pair of time and category members.
These settings are common for all users of the application.
Diagram 11. Member Permissions
The dbo25.member_permissions table contains user permissions for dimension members.
Administrators (members of the planning_app_administrators role) may allow:
- reading (select_permission = 1, update_permission = 0),
- reading and writing (select_permission = 1, update_permission = 1),
or deny reading and writing (select_permission = 0, update_permission = 0).
These modes have mnemonic letters R, W, and D accordingly.
When an administrator sets the permission, the application applies it to children also with the is_inherited = 1 flag.
For example, if the administrator disables the "Sales" account, the user will not have access to the child members of the "Sales" account also.
The administrator can set different permissions for children in this case.
Such direct child permissions have a higher priority.
Analysts and developers may enable or disable verifying permissions using the dbo25.dimensions.is_protected field.
Also, analysts may define the default permissions for dimension members in the dbo25.dimensions table.
The application uses the USER_NAME() function to get the username.
The application checks the permissions for members of the planning_app_users role only.
So, the developers and analysts always see the complete sets of members.
The application does not implement permission management by roles.
Diagram 12. Form Permissions
The dbo25.form_permissions table contains user permissions on forms.
The application does not allow executing disabled forms and does not show such forms
in the xls25.view_query_list_forms and xls25.view_query_list_offline_forms views used in the SaveToDB Connection Wizard.
The application uses the USER_NAME() function to get the username.
The application checks the permissions for members of the planning_app_users role only.
So, the developers and analysts always see the complete sets of forms.
The application does not implement permission management by roles.
Roles
Role | Description |
---|---|
planning_app_admins | The role includes permissions for planning application administrators. |
planning_app_analysts | The role includes permissions for planning application analysts. |
planning_app_developers | The role includes permissions for planning application developers. |
planning_app_users | The role includes permissions for planning application users. |
planning_app_admins
The role includes permissions for planning application administrators.
Assign this role to users who manage business user permissions.
This role members have permission to execute permission management forms and procedures and do not have permission to execute business reports.
See actual database permissions in the dbo25.xl_actions_set_role_permissions procedure.
planning_app_analysts
The role includes permissions for planning application analysts.
Assign this role to users who configure dimensions, members, reports, and other business-related objects.
This role members have full control over any business-related objects and do not have permissions to manage user permissions and change the application configuration.
See actual database permissions in the dbo25.xl_actions_set_role_permissions procedure.
planning_app_developers
The role includes permissions for planning application developers.
Assign this role to users who configure or develop the application.
This role members have full read and write permissions on any object in the dbo25 and xls25 schemas.
See actual database permissions in the dbo25.xl_actions_set_role_permissions procedure.
planning_app_users
The role includes permissions for planning application users.
Assign this role to business users who work with configured forms only.
This role members may have additional restrictions configured at the application level.
Do not assign this role to users that are members of the roles listed above.
See actual database permissions in the dbo25.xl_actions_set_role_permissions procedure.
Schemas
Schema | Description |
---|---|
dbo25 | The schema contains data tables and technical views and procedures of the planning application. |
xls25 | The schema contains end-user views and stored procedures used in the Excel planning application. |
xls25a | The schema contains objects of dynamic online forms. |
xls25b | The schema contains objects of dynamic offline forms. |
dbo25
The schema contains data tables and technical views and procedures of the planning application.
Administrators and developers have select permissions on views and execute permissions on stored procedures.
There is no direct access to application tables.
xls25
The schema contains end-user views and stored procedures used in the Excel planning application.
Business users have access to a limited set of schema objects.
See default permissions in the dbo25.xl_actions_set_role_permissions procedure.
xls25a
The schema contains objects of dynamic online forms.
Do not add other objects to this schema.
xls25b
The schema contains objects of dynamic offline forms.
Do not add other objects to this schema.
Views
View | Description |
---|---|
xls25.view_hierarchies | This view selects member parents, factors, and hierarchies. |
xls25.xl_formats | This view selects table formats of the forms configured in dbo25.forms. |
xls25.xl_handlers | This view selects the handler configuration of the forms configured in dbo25.forms. |
xls25.xl_query_list | This view selects user objects for the SaveToDB Connection Wizard and SaveToDB Query List. |
xls25.xl_query_list_offline_forms | This view selects offline user forms for the SaveToDB Connection Wizard and SaveToDB Query List. |
xls25.xl_query_list_online_forms | This view selects user forms for the SaveToDB Connection Wizard and SaveToDB Query List. |
xls25.xl_translations | This view selects translations of the forms configured in dbo25.forms. |
xls25.view_hierarchies
This view selects member parents, factors, and hierarchies.
Column | DataType | Comment |
---|---|---|
company_id | int | dbo25.members.company_id |
company | nvarchar(100) | dbo25.companies.name |
dimension_id | tinyint | dbo25.dimensions.id |
dimension_name | nvarchar(50) | dbo25.dimensions.name |
table_name | varchar(11) | The field shows the source table: dbo25.parents, dbo25.hierarchies, or dbo25.factors. |
member_id | int | Child member ID |
parent_id | int | Parent member ID |
calc_type_id | tinyint | dbo25.factors.calc_type_id |
member | nvarchar(453) | Child member display name |
parent | nvarchar(453) | Parent member display name |
calc_type | nvarchar(100) | dbo25.calc_types.name |
factor | float | dbo25.parents.factor or dbo25.factors.factor |
level | int |
Use this view to check member relation properties generated by the application.
xls25.xl_formats
This view selects table formats of the forms configured in dbo25.forms.
Source tables: xls.formats
Column | DataType | Comment |
---|---|---|
TABLE_SCHEMA | varchar(6) | dbo25.formats.TABLE_SCHEMA |
TABLE_NAME | nvarchar(101) | dbo25.formats.TABLE_NAME |
TABLE_EXCEL_FORMAT_XML | xml | dbo25.formats.TABLE_EXCEL_FORMAT_XML |
This view selects table formats of the configured forms for the SaveToDB add-in.
It uses the format of xls25.usp_run_form for every form that has no format.
Use the SaveToDB [Table Format Wizard](https://www.savetodb.com/savetodb/wizard-table-format.htm) to save table formats.
See also [Configuring Table Formats](https://www.savetodb.com/dev-guide/table-formats.htm).
xls25.xl_handlers
This view selects the handler configuration of the forms configured in dbo25.forms.
Source tables: xls.handlers
Column | DataType | Comment |
---|---|---|
TABLE_SCHEMA | nvarchar(128) | xls.handlers.TABLE_SCHEMA |
TABLE_NAME | nvarchar(128) | xls.handlers.TABLE_NAME |
COLUMN_NAME | nvarchar(128) | xls.handlers.COLUMN_NAME |
EVENT_NAME | varchar(25) | xls.handlers.EVENT_NAME |
HANDLER_SCHEMA | nvarchar(128) | xls.handlers.HANDLER_SCHEMA |
HANDLER_NAME | nvarchar(280) | xls.handlers.HANDLER_NAME |
HANDLER_TYPE | varchar(25) | xls.handlers.HANDLER_TYPE |
HANDLER_CODE | nvarchar(max) | xls.handlers.HANDLER_CODE |
TARGET_WORKSHEET | nvarchar(255) | xls.handlers.TARGET_WORKSHEET |
MENU_ORDER | bigint | xls.handlers.MENU_ORDER |
EDIT_PARAMETERS | bit | xls.handlers.EDIT_PARAMETERS |
This view selects event handler configurations of the configured forms for the SaveToDB add-in.
See also [Configuring Event Handlers](https://www.savetodb.com/dev-guide/xls-handlers.htm).
xls25.xl_query_list
This view selects user objects for the SaveToDB Connection Wizard and SaveToDB Query List.
Source tables: xls.queries
Column | DataType | Comment |
---|---|---|
TABLE_SCHEMA | nvarchar(128) | xls.queries.TABLE_SCHEMA |
TABLE_NAME | nvarchar(128) | xls.queries.TABLE_NAME |
TABLE_TYPE | nvarchar(128) | xls.queries.TABLE_TYPE |
TABLE_CODE | nvarchar(max) | xls.queries.TABLE_CODE |
INSERT_PROCEDURE | nvarchar(max) | xls.queries.INSERT_PROCEDURE |
UPDATE_PROCEDURE | nvarchar(max) | xls.queries.UPDATE_PROCEDURE |
DELETE_PROCEDURE | nvarchar(max) | xls.queries.DELETE_PROCEDURE |
PROCEDURE_TYPE | nvarchar(50) | xls.queries.PROCEDURE_TYPE |
The view filters output of the SaveToDB Framework xls.queries view.
See also [Configuring Query Lists](https://www.savetodb.com/dev-guide/query-lists.htm).
xls25.xl_query_list_offline_forms
This view selects offline user forms for the SaveToDB Connection Wizard and SaveToDB Query List.
Column | DataType | Comment |
---|---|---|
TABLE_SCHEMA | varchar(6) | Configured form schema: xls25b |
TABLE_NAME | nvarchar(101) | dbo25.forms.code |
TABLE_TYPE | varchar(4) | Type of the configured object: CODE |
TABLE_CODE | nvarchar(max) | SQL code to execute the xls25.run_offline_form procedure with the form parameters |
INSERT_PROCEDURE | varchar(33) | xls25.usp_run_offline_form_insert |
UPDATE_PROCEDURE | varchar(33) | xls25.usp_run_offline_form_update |
DELETE_PROCEDURE | varchar(33) | xls25.usp_run_offline_form_delete |
PROCEDURE_TYPE | varchar(9) | Type of edit procedures for information purposes: PROCEDURE |
Use this view to connect to configured forms in the SaveToDB Data Connection Wizard in the business user workbooks.
The forms of this list use edit procedures to update the underlying cube values. Users must click the Save button to save changes.
This feature works with the SaveToDB Standard edition.
This view shows configured forms with actual select permissions.
See also [Configuring Query Lists](https://www.savetodb.com/dev-guide/query-lists.htm).
xls25.xl_query_list_online_forms
This view selects user forms for the SaveToDB Connection Wizard and SaveToDB Query List.
Column | DataType | Comment |
---|---|---|
TABLE_SCHEMA | varchar(6) | Configured form schema: xls25a |
TABLE_NAME | nvarchar(101) | dbo25.forms.code |
TABLE_TYPE | varchar(4) | Type of the configured object: CODE |
TABLE_CODE | nvarchar(max) | SQL code to execute the xls25.run_form procedure with the form parameters |
INSERT_PROCEDURE | nvarchar(max) | NULL |
UPDATE_PROCEDURE | nvarchar(max) | NULL |
DELETE_PROCEDURE | nvarchar(max) | NULL |
PROCEDURE_TYPE | nvarchar(128) | NULL |
Use this view to connect to configured forms in the SaveToDB Data Connection Wizard in the business user workbooks.
The forms of this list use cell change event handlers to update the underlying cube values. So, this feature requires the SaveToDB Enterprise edition.
This view shows configured forms with actual select permissions.
See also [Configuring Query Lists](https://www.savetodb.com/dev-guide/query-lists.htm).
xls25.xl_translations
This view selects translations of the forms configured in dbo25.forms.
Column | DataType | Comment |
---|---|---|
TABLE_SCHEMA | varchar(6) | xls25a or xls25b |
TABLE_NAME | nvarchar(101) | Dynamic form code |
COLUMN_NAME | nvarchar(128) | Dynamic form column name or parameter name or NULL |
LANGUAGE_NAME | varchar(10) | dbo25.translations.language |
TRANSLATED_NAME | nvarchar(452) | dbo25.translations.name or dbo25.dimension_properties.parameter_name |
TRANSLATED_DESC | nvarchar(max) | NULL |
TRANSLATED_COMMENT | nvarchar(max) |
This view selects translations of the configured forms for the SaveToDB add-in.
See also [Configuring Data Translation](https://www.savetodb.com/dev-guide/translating-data-and-ui.htm).
Procedures
Procedure | Description |
---|---|
dbo25.usp_export_all | This procedure exports all data. |
dbo25.usp_export_companies | This procedure exports companies. |
dbo25.usp_export_currency_rates | This procedure exports currency rates. |
dbo25.usp_export_dimension_calc_types | This procedure exports dimension calculation types. |
dbo25.usp_export_dimension_members | This procedure exports dimension members. |
dbo25.usp_export_dimension_properties | This procedure exports dimension properties. |
dbo25.usp_export_dimensions | This procedure exports dimensions. |
dbo25.usp_export_facts | This procedure exports source numbers. |
dbo25.usp_export_form_dimensions | This procedure exports form dimension settings. |
dbo25.usp_export_form_permissions | This procedure exports form permissions. |
dbo25.usp_export_form_rows | This procedure exports form row settings. |
dbo25.usp_export_form_subtotals | This procedure exports form subtotal settings. |
dbo25.usp_export_formats | This procedure exports Excel table formats. |
dbo25.usp_export_forms | This procedure exports forms and form settings. |
dbo25.usp_export_member_parents | This procedure exports member parents. |
dbo25.usp_export_member_permissions | This procedure exports member permissions. |
dbo25.usp_export_member_properties | This procedure exports member properties. |
dbo25.usp_export_member_relations | This procedure exports member relations. |
dbo25.usp_export_members | This procedure exports members. |
dbo25.usp_export_strings | This procedure exports source strings. |
dbo25.usp_export_tax_rates | This procedure exports tax rates. |
dbo25.usp_export_translations | This procedure exports company-related translations. |
dbo25.usp_export_units | This procedure exports units. |
dbo25.usp_export_users | This procedure exports users. |
dbo25.usp_import_clear_all_data | This procedure clears all data before importing data. |
dbo25.usp_import_companies | This procedure imports companies. |
dbo25.usp_import_currency_rates | This procedure imports currency rates. |
dbo25.usp_import_dimension_calc_types | This procedure imports calculation types by dimensions. |
dbo25.usp_import_dimension_members | This procedure imports dimension members. |
dbo25.usp_import_dimension_properties | This procedure imports dimension properties. |
dbo25.usp_import_dimensions | This procedure imports dimensions. |
dbo25.usp_import_facts | This procedure imports source numbers. |
dbo25.usp_import_finish | This procedure executes the required actions after importing data. |
dbo25.usp_import_form_dimensions | This procedure imports form dimension properties. |
dbo25.usp_import_form_permissions | This procedure imports form permissions. |
dbo25.usp_import_form_rows | This procedure imports custom form rowsets. |
dbo25.usp_import_form_subtotals | This procedure imports form subtotal settings. |
dbo25.usp_import_formats | This procedure imports Excel table formats. |
dbo25.usp_import_forms | This procedure imports forms. |
dbo25.usp_import_member_parents | This procedure imports member parents. |
dbo25.usp_import_member_permissions | This procedure imports member permissions. |
dbo25.usp_import_member_properties | This procedure imports member properties. |
dbo25.usp_import_member_relations | This procedure imports member relations. |
dbo25.usp_import_members | This procedure imports dimension members. |
dbo25.usp_import_strings | This procedure imports source strings. |
dbo25.usp_import_tax_rates | This procedure imports tax rates. |
dbo25.usp_import_translations | This procedure imports company-related translations. |
dbo25.usp_import_units | This procedure imports units. |
dbo25.usp_import_users | This procedure imports users. |
dbo25.xl_actions_create_standard_forms | This procedure creates a set of standard forms. |
dbo25.xl_actions_create_standard_members | This procedure creates standard dimension members. |
dbo25.xl_actions_create_standard_tax_rates | This procedure creates a set of standard tax rates. |
dbo25.xl_actions_create_standard_units | This procedure creates a set of standard units. |
dbo25.xl_actions_set_doc_role_permissions | This procedure sets the permissions of user roles for the Database Help Framework. |
dbo25.xl_actions_set_log_role_permissions | This procedure sets the permissions of user roles for the Change Tracking Framework. |
dbo25.xl_actions_set_role_permissions | This procedure grants permissions to the planning application roles. |
xls25.usp_axis_types | This procedure selects form axis types. |
xls25.usp_calc_types | This procedure is an Excel form for editing calculation types. |
xls25.usp_closed_periods | This procedure is an Excel form for editing closed periods. |
xls25.usp_closed_periods_change | This procedure updates a database on cell changes of xls25.usp_closed_periods. |
xls25.usp_companies | This procedure is a form of editing companies. |
xls25.usp_companies_delete | This procedure deletes rows of xls25.usp_companies. |
xls25.usp_companies_insert | This procedure inserts rows of xls25.usp_companies. |
xls25.usp_companies_update | This procedure updates rows of xls25.usp_companies. |
xls25.usp_currency_rates | This procedure is an Excel form for editing currency rates. |
xls25.usp_currency_rates_change | This procedure updates a database on cell changes of xls25.usp_rates. |
xls25.usp_data_management | This procedure is an Excel form for data management. |
xls25.usp_dimensions | This procedure is an Excel form for editing dimensions. |
xls25.usp_dimensions_change | This procedure checks user input on cell changes of xls25.usp_dimensions. |
xls25.usp_dimensions_delete | This procedure deletes rows of xls25.usp_dimensions. |
xls25.usp_dimensions_insert | This procedure inserts rows of xls25.usp_dimensions. |
xls25.usp_dimensions_update | This procedure updates rows of xls25.usp_dimensions. |
xls25.usp_facts | This procedure selects the calculated facts. |
xls25.usp_facts_data | This procedure selects source cube data. |
xls25.usp_facts_strings | This procedure selects source cube strings. |
xls25.usp_form_dimensions | This procedure is an Excel form for editing form dimension properties. |
xls25.usp_form_dimensions_delete | This procedure deletes rows of xls25.usp_form_dimensions. |
xls25.usp_form_dimensions_insert | This procedure inserts rows of xls25.usp_form_dimensions. |
xls25.usp_form_dimensions_update | This procedure updates rows of xls25.usp_form_dimensions. |
xls25.usp_form_permissions | This procedure is an Excel form for editing form permissions. |
xls25.usp_form_permissions_change | This procedure updates a database on cell changes of xls25.usp_form_permissions. |
xls25.usp_form_rows | This procedure is an Excel form for editing form rowsets. |
xls25.usp_form_rows_delete | This procedure deletes rows of xls25.usp_form_rows. |
xls25.usp_form_rows_insert | This procedure inserts rows of xls25.usp_form_rows. |
xls25.usp_form_rows_update | This procedure updates rows of xls25.usp_form_rows. |
xls25.usp_forms | This procedure is an Excel form for editing a list of forms. |
xls25.usp_forms_delete | This procedure deletes rows of xls25.usp_forms. |
xls25.usp_forms_insert | This procedure inserts rows of xls25.usp_forms. |
xls25.usp_forms_update | This procedure updates rows of xls25.usp_forms. |
xls25.usp_member_permissions | This procedure is an Excel form for editing member permissions. |
xls25.usp_member_permissions_change | This procedure updates a database on cell changes of xls25.usp_member_permissions. |
xls25.usp_member_relations | This procedure is an Excel form for editing member relations. |
xls25.usp_member_relations_change | This procedure updates a database on cell changes of xls25.usp_member_relations. |
xls25.usp_members | This procedure is an Excel form for editing dimension members. |
xls25.usp_members_delete | This procedure deletes rows of xls25.usp_members. |
xls25.usp_members_insert | This procedure inserts rows of xls25.usp_members. |
xls25.usp_members_update | This procedure updates rows of xls25.usp_members. |
xls25.usp_name_formats | This procedure selects name formats. |
xls25.usp_role_members | This procedure is a form for managing user roles. |
xls25.usp_role_members_change | This procedure updates a role membership on cell changes of xls25.usp_role_members. |
xls25.usp_rowsets | This procedure is an Excel form for editing rowset members. |
xls25.usp_rowsets_delete | This procedure deletes rows of xls25.usp_rowsets. |
xls25.usp_rowsets_insert | This procedure inserts rows of xls25.usp_rowsets. |
xls25.usp_rowsets_update | This procedure updates rows of xls25.usp_rowsets. |
xls25.usp_run_form | This procedure executes forms configured using dbo25.forms and dbo25.form_dimensions. |
xls25.usp_run_form_change | This procedure updates a database on cell changes of xls25.usp_run_form. |
xls25.usp_run_json_form | This procedure returns calculated cube data requested with JSON parameters. |
xls25.usp_run_offline_form | This procedure executes forms configured using dbo25.forms and dbo25.form_dimensions. |
xls25.usp_run_offline_form_delete | This procedure deletes rows of xls25.usp_run_offline_form. |
xls25.usp_run_offline_form_insert | This procedure inserts rows of xls25.usp_run_offline_form. |
xls25.usp_run_offline_form_update | This procedure updates rows of xls25.usp_run_offline_form. |
xls25.usp_tax_rates | This procedure is an Excel form for editing tax rates. |
xls25.usp_tax_rates_delete | This procedure deletes rows of xls25.usp_tax_rates. |
xls25.usp_tax_rates_insert | This procedure inserts rows of xls25.usp_tax_rates. |
xls25.usp_tax_rates_update | This procedure updates rows of xls25.usp_tax_rates. |
xls25.usp_translations | This procedure is a form of editing company-related translations. |
xls25.usp_translations_change | This procedure updates an element translation on cell changes of xls25.usp_translations. |
xls25.usp_translations_common | This procedure is a form of editing application-level element translations. |
xls25.usp_translations_xls | This procedure is a form of editing actual application-level element translations. |
xls25.usp_translations_xls_change | This procedure updates an application element translation on cell changes of xls25.usp_translations_xls. |
xls25.usp_units | This procedure is an Excel form for editing units. |
xls25.usp_units_delete | This procedure deletes rows of xls25.usp_units. |
xls25.usp_units_insert | This procedure inserts rows of xls25.usp_units. |
xls25.usp_units_update | This procedure updates rows of xls25.usp_units. |
xls25.usp_users | This procedure is a form of editing users. |
xls25.usp_users_delete | This procedure deletes rows of xls25.usp_users. |
xls25.usp_users_insert | This procedure inserts rows of xls25.usp_users. |
xls25.usp_users_update | This procedure updates rows of xls25.usp_users. |
xls25.xl_actions_add_language | This procedure adds a new language for company-related elements. |
xls25.xl_actions_add_quarters | This procedure adds quarter members. |
xls25.xl_actions_add_year | This procedure adds year members. |
xls25.xl_actions_copy_data | This procedure copies data from a category to category. |
xls25.xl_actions_delete_data | This procedure deletes source cube data from a category. |
xls25.xl_actions_delete_year | This procedure deletes year members. |
xls25.xl_actions_run_form_cell_data | This procedure selects underlying cube data for a reporting cell. |
xls25.xl_actions_set_functional_currency | This procedure changes the system currency of the application. |
xls25.xl_actions_update_facts | This procedure updates cube values after the currency rate changes. |
xls25.xl_actions_update_hierarchies | This procedure updates the required tables after member changes. |
xls25.xl_actions_update_member_permissions | This procedure updates member permissions after member changes. |
xls25.xl_aliases_members | This procedure configures column sets of xls25.usp_members procedure. |
xls25.xl_parameter_values_0_or_1 | This procedure selects 0 or 1 for Excel ribbon parameters. |
xls25.xl_parameter_values_calc_type_id | This procedure selects calculation types for Excel ribbon parameters. |
xls25.xl_parameter_values_calc_type_id_or_null | This procedure selects calculation types for Excel ribbon parameters. |
xls25.xl_parameter_values_company_id | This procedure selects companies for Excel ribbon parameters. |
xls25.xl_parameter_values_currency_id | This procedure selects currencies for Excel ribbon parameters. |
xls25.xl_parameter_values_dimension_id | This procedure selects dimensions for Excel ribbon parameters. |
xls25.xl_parameter_values_dimension_id_or_null | This procedure selects dimensions for Excel ribbon parameters. |
xls25.xl_parameter_values_form_id | This procedure selects forms for Excel ribbon parameters. |
xls25.xl_parameter_values_form_id_or_null | This procedure selects forms for Excel ribbon parameters. |
xls25.xl_parameter_values_member_id_by_dimension_id | This procedure selects members for Excel ribbon parameters. |
xls25.xl_parameter_values_member_id_dim1 | This procedure selects 1st dimension members for Excel ribbon parameters. |
xls25.xl_parameter_values_member_id_dim2 | This procedure selects 2nd dimension members for Excel ribbon parameters. |
xls25.xl_parameter_values_member_id_dim3 | This procedure selects 3rd dimension members for Excel ribbon parameters. |
xls25.xl_parameter_values_member_id_dim4 | This procedure selects 4th dimension members for Excel ribbon parameters. |
xls25.xl_parameter_values_member_id_dim5 | This procedure selects 5th dimension members for Excel ribbon parameters. |
xls25.xl_parameter_values_member_id_dim6 | This procedure selects 6th dimension members for Excel ribbon parameters. |
xls25.xl_parameter_values_member_id_dim7 | This procedure selects 7th dimension members for Excel ribbon parameters. |
xls25.xl_parameter_values_relation_dimension_id | This procedure selects dimensions for Excel ribbon parameters. |
xls25.xl_parameter_values_relation_partner_id | This procedure selects members for Excel ribbon parameters. |
xls25.xl_parameter_values_root_member_id_code | This procedure selects possible root members for Excel ribbon parameters. |
xls25.xl_parameter_values_rowset_id | This procedure selects rowsets for Excel ribbon parameters. |
xls25.xl_parameter_values_rowset_id_or_null | This procedure selects rowsets for Excel ribbon parameters. |
xls25.xl_parameter_values_run_form_p | This procedure selects values for the ribbon parameters of the configured forms. |
xls25.xl_parameter_values_run_form_p1 | This procedure selects values for the 1st ribbon parameter of the configured forms. |
xls25.xl_parameter_values_run_form_p2 | This procedure selects values for the 2nd ribbon parameter of the configured forms. |
xls25.xl_parameter_values_run_form_p3 | This procedure selects values for the 3rd ribbon parameter of the configured forms. |
xls25.xl_parameter_values_run_form_p4 | This procedure selects values for the 4th ribbon parameter of the configured forms. |
xls25.xl_parameter_values_run_form_p5 | This procedure selects values for the 5th ribbon parameter of the configured forms. |
xls25.xl_parameter_values_run_form_p6 | This procedure selects values for the 6th ribbon parameter of the configured forms. |
xls25.xl_parameter_values_run_form_p7 | This procedure selects values for the 7th ribbon parameter of the configured forms. |
xls25.xl_parameter_values_unit_id | This procedure selects units for Excel ribbon parameters. |
xls25.xl_parameter_values_username | This procedure selects usernames for Excel ribbon parameters. |
xls25.xl_validation_list_axis_type_id | This procedure selects axis types to use as an Excel validation list source. |
xls25.xl_validation_list_calc_type_id | This procedure selects calculation types to use as an Excel validation list source. |
xls25.xl_validation_list_calc_type_id_by_dimension_id | This procedure selects calculation types to use as an Excel validation list source. |
xls25.xl_validation_list_default_member_id_code | This procedure selects possible default members to use as an Excel validation list source. |
xls25.xl_validation_list_dimension_id | This procedure selects dimensions to use as an Excel validation list source. |
xls25.xl_validation_list_member_id | This procedure selects members to use as an Excel validation list source. |
xls25.xl_validation_list_member_id_code_by_dimension_id | This procedure selects members to use as an Excel validation list source. |
xls25.xl_validation_list_member_id_code_by_rowset_id | This procedure selects members to use as an Excel validation list source. |
xls25.xl_validation_list_name_format_id | This procedure selects name formats to use as an Excel validation list source. |
xls25.xl_validation_list_previous_period_id_by_dimension_id | This procedure selects previous period members to use as an Excel validation list source. |
xls25.xl_validation_list_root_member_id_code | This procedure selects possible root members to use as an Excel validation list source. |
xls25.xl_validation_list_root_member_or_rowset_id_code | This procedure selects possible root members to use as an Excel validation list source. |
xls25.xl_validation_list_rowset_id | This procedure selects rowsets to use as an Excel validation list source. |
xls25.xl_validation_list_same_period_id_by_dimension_id | This procedure selects the same period members to use as an Excel validation list source. |
xls25.xl_validation_list_tax_rate_id_by_dimension_id | This procedure selects tax rates to use as an Excel validation list source. |
xls25.xl_validation_list_unit_id_by_dimension_id | This procedure selects units to use as an Excel validation list source. |
xls25a.usp_update_table_format | This procedure updates Excel table formats of online dynamic forms. |
xls25b.usp_update_table_format | This procedure updates Excel table formats of offline dynamic forms. |
dbo25.usp_export_all
This procedure exports all data.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@print_go | bit | IN | 1 to print GO commands |
It calls other export procedures in the right order to prepare the complete import SQL script.
dbo25.usp_export_companies
This procedure exports companies.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source table: dbo25.companies
dbo25.usp_export_currency_rates
This procedure exports currency rates.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source table: dbo25.currency_rates
dbo25.usp_export_dimension_calc_types
This procedure exports dimension calculation types.
Source table: dbo25.dimension_calc_types
dbo25.usp_export_dimension_members
This procedure exports dimension members.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source table: dbo25.dimension_properties, dbo25.members
dbo25.usp_export_dimension_properties
This procedure exports dimension properties.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source table: dbo25.dimension_properties
dbo25.usp_export_dimensions
This procedure exports dimensions.
Source table: dbo25.dimensions
dbo25.usp_export_facts
This procedure exports source numbers.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source table: dbo25.facts
dbo25.usp_export_form_dimensions
This procedure exports form dimension settings.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source table: dbo25.forms, dbo25.form_dimensions
dbo25.usp_export_form_permissions
This procedure exports form permissions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source table: dbo25.forms, dbo25.form_permissions
dbo25.usp_export_form_rows
This procedure exports form row settings.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source table: dbo25.forms, dbo25.form_rows
dbo25.usp_export_form_subtotals
This procedure exports form subtotal settings.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source table: dbo25.forms, dbo25.form_subtotals
dbo25.usp_export_formats
This procedure exports Excel table formats.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source table: dbo25.formats
dbo25.usp_export_forms
This procedure exports forms and form settings.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source table: dbo25.forms
dbo25.usp_export_member_parents
This procedure exports member parents.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source tables: dbo25.members, dbo25.parents
dbo25.usp_export_member_permissions
This procedure exports member permissions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source tables: dbo25.members, dbo25.member_permissions
dbo25.usp_export_member_properties
This procedure exports member properties.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source tables: dbo25.members
dbo25.usp_export_member_relations
This procedure exports member relations.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source tables: dbo25.members, dbo25.member_relations
dbo25.usp_export_members
This procedure exports members.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source tables: dbo25.members, dbo25.parents, dbo25.member_relations, dbo25.member_permissions.
dbo25.usp_export_strings
This procedure exports source strings.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source table: dbo25.strings
dbo25.usp_export_tax_rates
This procedure exports tax rates.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source table: dbo25.tax_rates
dbo25.usp_export_translations
This procedure exports company-related translations.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@language | varchar(10) | IN | dbo25.translations.LANGUAGE_NAME |
Source table: dbo25.translations
dbo25.usp_export_units
This procedure exports units.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source table: dbo25.units
dbo25.usp_export_users
This procedure exports users.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
Source table: dbo25.users
dbo25.usp_import_clear_all_data
This procedure clears all data before importing data.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@confirm | nvarchar(50) | IN | yes - to confirm deleting data |
@data_language | varchar(10) | IN | Context data language |
You may clear all the data to create a complete copy of the exported application.
The procedure does not delete dimensions.
dbo25.usp_import_companies
This procedure imports companies.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@code | nvarchar(50) | IN | dbo25.companies.code |
@name | nvarchar(100) | IN | dbo25.companies.name |
@default_language | varchar(10) | IN | dbo25.companies.default_language |
@sort_order | int | IN | dbo25.companies.sort_order |
Target table: dbo25.companies
dbo25.usp_import_currency_rates
This procedure imports currency rates.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@base_currency_code | nvarchar(50) | IN | dbo25.rates.base_currency_id |
@quote_currency_code | nvarchar(50) | IN | dbo25.rates.quote_currency_id |
@time_code | nvarchar(50) | IN | dbo25.rates.time_id |
@category_code | nvarchar(50) | IN | dbo25.rates.category_id |
@currency_rate | float | IN | dbo25.rates.currency_rate |
Target table: dbo25.currency_rates
dbo25.usp_import_dimension_calc_types
This procedure imports calculation types by dimensions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@dimension_id | tinyint | IN | dbo25.dimension_calc_types.dimension_id |
@calc_type_id | tinyint | IN | dbo25.dimension_calc_types.calc_type_id |
@is_active | bit | IN | dbo25.dimension_calc_types.is_active |
Target table: dbo25.dimension_calc_types
dbo25.usp_import_dimension_members
This procedure imports dimension members.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@dimension_id | tinyint | IN | dbo25.dimension_properties.id |
@root_member_code | nvarchar(50) | IN | dbo25.members.code used to calculate dbo25.dimension_properties.root_member_id |
@default_member_code | nvarchar(50) | IN | dbo25.members.code used to calculate dbo25.dimension_properties.default_member_id |
Target table: dbo25.dimensions
dbo25.usp_import_dimension_properties
This procedure imports dimension properties.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@id | tinyint | IN | dbo25.dimension_properties.id |
@code | nvarchar(50) | IN | dbo25.dimension_properties.code |
@name | nvarchar(100) | IN | dbo25.dimension_properties.name |
@parameter_name | nvarchar(50) | IN | dbo25.dimension_properties.parameter_name |
@sort_order | tinyint | IN | dbo25.dimension_properties.sort_order |
@join_order | tinyint | IN | dbo25.dimension_properties.join_order |
@name_format_id | tinyint | IN | dbo25.dimension_properties.name_format_id |
@is_protected | bit | IN | dbo25.dimension_properties.is_protected |
@default_select_permission | bit | IN | dbo25.dimension_properties.default_select_permission |
@default_update_permission | bit | IN | dbo25.dimension_properties.default_update_permission |
@is_active | bit | IN | dbo25.dimension_properties.is_active |
@external_id | int | IN | dbo25.dimension_properties.external_id |
@external_code | nvarchar(50) | IN | dbo25.dimension_properties.external_code |
Target table: dbo25.dimensions
Call this procedure after importing dimension members.
dbo25.usp_import_dimensions
This procedure imports dimensions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | tinyint | IN | dbo25.dimensions.id |
@code | nvarchar(50) | IN | dbo25.dimensions.code |
@name | nvarchar(100) | IN | dbo25.dimensions.name |
@parameter_name | nvarchar(50) | IN | dbo25.dimensions.parameter_name |
@sort_order | tinyint | IN | dbo25.dimensions.sort_order |
@join_order | tinyint | IN | dbo25.dimensions.join_order |
@name_format_id | tinyint | IN | dbo25.dimensions.name_format_id |
@is_protected | bit | IN | dbo25.dimensions.is_protected |
@default_select_permission | bit | IN | dbo25.dimensions.default_select_permission |
@default_update_permission | bit | IN | dbo25.dimensions.default_update_permission |
@is_active | bit | IN | dbo25.dimensions.is_active |
Target table: dbo25.dimensions
dbo25.usp_import_facts
This procedure imports source numbers.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@value | float | IN | dbo25.facts.source_value, dbo25.facts.value |
@code1 | nvarchar(50) | IN | dbo25.facts.id1 |
@code2 | nvarchar(50) | IN | dbo25.facts.id2 |
@code3 | nvarchar(50) | IN | dbo25.facts.id3 |
@code4 | nvarchar(50) | IN | dbo25.facts.id4 |
@code5 | nvarchar(50) | IN | dbo25.facts.id5 |
@code6 | nvarchar(50) | IN | dbo25.facts.id6 |
@code7 | nvarchar(50) | IN | dbo25.facts.id7 |
Target table: dbo25.facts
The procedure sets the same value into the value and source_value fields.
Use the xls25.xl_actions_update_facts procedure to calculate values that depend on unit factors and currency rates.
dbo25.usp_import_finish
This procedure executes the required actions after importing data.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
This procedure calls other stored procedures to update member hierarchies and permissions, and recalculate facts.
dbo25.usp_import_form_dimensions
This procedure imports form dimension properties.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@form_code | nvarchar(50) | IN | dbo25.form_dimensions.id |
@dimension_id | tinyint | IN | dbo25.form_dimensions.dimension_id |
@axis_type_id | tinyint | IN | dbo25.form_dimensions.axis_type_id |
@parameter_index | tinyint | IN | dbo25.form_dimensions.parameter_index |
@header_order | tinyint | IN | dbo25.form_dimensions.header_order |
@root_member_code | nvarchar(50) | IN | dbo25.form_dimensions.root_member_id |
@parameter_start_level | tinyint | IN | dbo25.form_dimensions.parameter_start_level |
@parameter_end_level | tinyint | IN | dbo25.form_dimensions.parameter_end_level |
@form_start_level | tinyint | IN | dbo25.form_dimensions.form_start_level |
@form_end_level | tinyint | IN | dbo25.form_dimensions.form_end_level |
Target table: dbo25.form_dimensions
dbo25.usp_import_form_permissions
This procedure imports form permissions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@form_code | nvarchar(50) | IN | dbo25.form_permissions.form_id |
@username | nvarchar(128) | IN | dbo25.form_permissions.username |
@select_permission | tinyint | IN | dbo25.form_permissions.select_permission |
Target table: dbo25.form_permissions
dbo25.usp_import_form_rows
This procedure imports custom form rowsets.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@rowset_code | nvarchar(50) | IN | dbo25.form_rows.rowset_id |
@sort_order | int | IN | dbo25.form_rows.sort_order |
@member_code | nvarchar(50) | IN | dbo25.form_rows.member_id |
@code | nvarchar(50) | IN | dbo25.form_rows.code |
@name | nvarchar(400) | IN | dbo25.form_rows.name |
@decimal_places | tinyint | IN | dbo25.form_rows.decimal_places |
@is_percent | tinyint | IN | dbo25.form_rows.is_percent |
@row_color | tinyint | IN | dbo25.form_rows.row_color |
@row_bold | tinyint | IN | dbo25.form_rows.row_bold |
@row_indent | tinyint | IN | dbo25.form_rows.row_indent |
Target table: dbo25.form_rows
dbo25.usp_import_form_subtotals
This procedure imports form subtotal settings.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@form_code | nvarchar(50) | IN | dbo25.form_subtotals.form_id |
@show | bit | IN | dbo25.form_subtotals.show |
@dimension_id1 | tinyint | IN | dbo25.form_subtotals.dimension_id1 |
@dimension_id2 | tinyint | IN | dbo25.form_subtotals.dimension_id2 |
@dimension_id3 | tinyint | IN | dbo25.form_subtotals.dimension_id3 |
@member_code1 | nvarchar(50) | IN | dbo25.form_subtotals.member_id1 |
@member_code2 | nvarchar(50) | IN | dbo25.form_subtotals.member_id2 |
@member_code3 | nvarchar(50) | IN | dbo25.form_subtotals.member_id3 |
Target table: dbo25.form_subtotals
dbo25.usp_import_formats
This procedure imports Excel table formats.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@TABLE_SCHEMA | nvarchar(128) | IN | dbo25.formats.TABLE_SCHEMA |
@TABLE_NAME | nvarchar(128) | IN | dbo25.formats.TABLE_NAME |
@TABLE_EXCEL_FORMAT_XML | xml | IN | dbo25.formats.TABLE_EXCEL_FORMAT_XML |
Target table: dbo25.formats
dbo25.usp_import_forms
This procedure imports forms.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@code | nvarchar(50) | IN | dbo25.forms.code |
@name | nvarchar(100) | IN | dbo25.forms.name |
@sort_order | int | IN | dbo25.forms.sort_order |
@is_active | bit | IN | dbo25.forms.is_active |
Target table: dbo25.forms
dbo25.usp_import_member_parents
This procedure imports member parents.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@member_code | nvarchar(50) | IN | dbo25.parents.member_id |
@parent_code | nvarchar(50) | IN | dbo25.parents.parent_id |
@factor | float | IN | dbo25.parents.factor |
Target table: dbo25.parents
dbo25.usp_import_member_permissions
This procedure imports member permissions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@member_code | nvarchar(50) | IN | dbo25.member_permissions.member_id |
@username | nvarchar(128) | IN | dbo25.member_permissions.username |
@select_permission | tinyint | IN | dbo25.member_permissions.select_permission |
@update_permission | tinyint | IN | dbo25.member_permissions.update_permission |
Target table: dbo25.member_permissions
dbo25.usp_import_member_properties
This procedure imports member properties.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@member_code | nvarchar(50) | IN | dbo25.members.id |
@previous_period_code | nvarchar(50) | IN | dbo25.members.previous_period_id |
@same_period_code | nvarchar(50) | IN | dbo25.members.same_period_id |
@tax_rate_code | nvarchar(50) | IN | dbo25.members.tax_rate_id |
@unit_code | nvarchar(50) | IN | dbo25.members.unit_id |
Target table: dbo25.members
dbo25.usp_import_member_relations
This procedure imports member relations.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@member_code | nvarchar(50) | IN | dbo25.member_relations.member_id |
@partner_code | nvarchar(50) | IN | dbo25.member_relations.partner_id |
@select_permission | tinyint | IN | dbo25.member_relations.select_permission |
@update_permission | tinyint | IN | dbo25.member_relations.update_permission |
Target table: dbo25.member_relations
dbo25.usp_import_members
This procedure imports dimension members.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@dimension_id | tinyint | IN | dbo25.members.dimension_id |
@sort_order | int | IN | dbo25.members.sort_order |
@code | nvarchar(50) | IN | dbo25.members.code |
@name | nvarchar(400) | IN | dbo25.members.name |
@calc_type_id | tinyint | IN | dbo25.members.calc_type_id |
@decimal_places | tinyint | IN | dbo25.members.decimal_places |
@is_percent | bit | IN | dbo25.members.is_percent |
@row_color | tinyint | IN | dbo25.members.row_color |
@row_bold | tinyint | IN | dbo25.members.row_bold |
@row_indent | tinyint | IN | dbo25.members.row_indent |
@show_line | bit | IN | dbo25.members.show_line |
@show_line_before | bit | IN | dbo25.members.show_line_before |
@show_line_after | bit | IN | dbo25.members.show_line_after |
@is_translatable | bit | IN | dbo25.members.is_translatable |
@is_active | bit | IN | dbo25.members.is_active |
@external_id | int | IN | dbo25.members.external_id |
@external_code | nvarchar(50) | IN | dbo25.members.external_code |
@excel_formula | nvarchar(400) | IN | dbo25.members.excel_formula |
Target table: dbo25.members
dbo25.usp_import_strings
This procedure imports source strings.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@value | nvarchar(4000) | IN | dbo25.strings.value |
@code1 | nvarchar(50) | IN | dbo25.strings.id1 |
@code2 | nvarchar(50) | IN | dbo25.strings.id2 |
@code3 | nvarchar(50) | IN | dbo25.strings.id3 |
@code4 | nvarchar(50) | IN | dbo25.strings.id4 |
@code5 | nvarchar(50) | IN | dbo25.strings.id5 |
@code6 | nvarchar(50) | IN | dbo25.strings.id6 |
@code7 | nvarchar(50) | IN | dbo25.strings.id7 |
Target table: dbo25.strings
dbo25.usp_import_tax_rates
This procedure imports tax rates.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@code | nvarchar(50) | IN | dbo25.tax_rates.code |
@name | nvarchar(100) | IN | dbo25.tax_rates.name |
@sort_order | tinyint | IN | dbo25.tax_rates.sort_order |
@is_translatable | bit | IN | dbo25.tax_rates.is_translatable |
@is_active | bit | IN | dbo25.tax_rates.is_active |
Target table: dbo25.tax_rates
dbo25.usp_import_translations
This procedure imports company-related translations.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@table | nvarchar(50) | IN | dbo25.translated_tables.code |
@member | nvarchar(50) | IN | The member code used to find dbo25.translations.member_id |
@language | varchar(10) | IN | dbo25.translations.language |
@name | nvarchar(400) | IN | dbo25.translations.name |
Target table: dbo25.translations
dbo25.usp_import_units
This procedure imports units.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@code | nvarchar(50) | IN | dbo25.units.code |
@name | nvarchar(100) | IN | dbo25.units.name |
@sort_order | int | IN | dbo25.units.sort_order |
@factor | float | IN | dbo25.units.factor |
@is_currency | bit | IN | dbo25.units.is_currency |
@is_functional_currency | bit | IN | dbo25.units.is_functional_currency |
@is_translatable | bit | IN | dbo25.units.is_translatable |
@is_active | bit | IN | dbo25.units.is_active |
Target table: dbo25.units
dbo25.usp_import_users
This procedure imports users.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company | nvarchar(50) | IN | dbo25.companies.code |
@username | nvarchar(128) | IN | dbo25.users.username |
@name | nvarchar(100) | IN | dbo25.users.name |
@is_admin | bit | IN | dbo25.users.is_admin |
@is_default | bit | IN | dbo25.users.is_default |
@is_active | bit | IN | dbo25.users.is_active |
Target table: dbo25.users
dbo25.xl_actions_create_standard_forms
This procedure creates a set of standard forms.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.companies.id |
@data_language | varchar(10) | IN | Context data language |
Use it to initialize settings for a new company.
dbo25.xl_actions_create_standard_members
This procedure creates standard dimension members.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.companies.id |
@data_language | varchar(10) | IN | Context data language |
Use it to initialize the empty cube.
The procedure uses the dbo25.get_standard_members function to select standard members.
dbo25.xl_actions_create_standard_tax_rates
This procedure creates a set of standard tax rates.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.companies.id |
@data_language | varchar(10) | IN | Context data language |
Use it to initialize settings for a new company.
dbo25.xl_actions_create_standard_units
This procedure creates a set of standard units.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.companies.id |
@data_language | varchar(10) | IN | Context data language |
Use it to initialize settings for a new company.
dbo25.xl_actions_set_doc_role_permissions
This procedure sets the permissions of user roles for the Database Help Framework.
Execute this procedure after installation of the Database Help Framework.
dbo25.xl_actions_set_log_role_permissions
This procedure sets the permissions of user roles for the Change Tracking Framework.
Execute this procedure after installation of the Change Tracking Framework.
dbo25.xl_actions_set_role_permissions
This procedure grants permissions to the planning application roles.
Execute this procedure if you recreated any table of the dbo25 schema.
xls25.usp_axis_types
This procedure selects form axis types.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.axis_types
xls25.usp_calc_types
This procedure is an Excel form for editing calculation types.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.calc_types
xls25.usp_closed_periods
This procedure is an Excel form for editing closed periods.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.member_relations
Editing data requires the SaveToDB Enterprise edition.
Example:

xls25.usp_closed_periods_change
This procedure updates a database on cell changes of xls25.usp_closed_periods.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@column_name | nvarchar(128) | IN | dbo25.member_relations.category_id |
@cell_number_value | int | IN | dbo25.member_relations.update_permission |
@id | int | IN | dbo25.member_relations.member_id |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_companies
This procedure is a form of editing companies.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@data_language | varchar(10) | IN | Context data language |
Source table: dbo25.companies
xls25.usp_companies_delete
This procedure deletes rows of xls25.usp_companies.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.companies.id |
xls25.usp_companies_insert
This procedure inserts rows of xls25.usp_companies.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@code | nvarchar(50) | IN | dbo25.companies.code |
@name | nvarchar(100) | IN | dbo25.companies.name |
@translated_name | nvarchar(100) | IN | dbo25.translations.name |
@default_language | varchar(10) | IN | dbo25.companies.default_language |
@sort_order | int | IN | dbo25.companies.sort_order |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_companies_update
This procedure updates rows of xls25.usp_companies.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.companies.id |
@code | nvarchar(50) | IN | dbo25.companies.code |
@name | nvarchar(100) | IN | dbo25.companies.name |
@translated_name | nvarchar(100) | IN | dbo25.translations.name |
@default_language | varchar(10) | IN | dbo25.companies.default_language |
@sort_order | int | IN | dbo25.companies.sort_order |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_currency_rates
This procedure is an Excel form for editing currency rates.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@base_currency_id | tinyint | IN | dbo25.units.id |
@quote_currency_id | tinyint | IN | dbo25.units.id |
@data_language | varchar(10) | IN | Context data language |
Use the xls25.xl_actions_update_facts procedure to recalculate facts after currency rate changes.
Underlying table: dbo25.rates
Editing data requires the SaveToDB Enterprise edition.
xls25.usp_currency_rates_change
This procedure updates a database on cell changes of xls25.usp_rates.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@column_name | nvarchar(128) | IN | dbo25.rates.category_id |
@cell_number_value | float | IN | dbo25.rates.rate |
@id | int | IN | dbo25.rates.time_id |
@base_currency_id | tinyint | IN | dbo25.rates.base_currency_id |
@quote_currency_id | tinyint | IN | dbo25.rates.quote_currency_id |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_data_management
This procedure is an Excel form for data management.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.companies.id |
@data_language | varchar(10) | IN | Context data language |
Use the Excel context menu to delete and copy data.
Underlying table: dbo25.facts
Actions: xls25.xl_actions_copy_data, xls25.xl_actions_delete_data
Example:

xls25.usp_dimensions
This procedure is an Excel form for editing dimensions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.dimension_properties.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.dimensions
Example:

xls25.usp_dimensions_change
This procedure checks user input on cell changes of xls25.usp_dimensions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@column_name | nvarchar(255) | IN | Excel cell column name |
@cell_value | nvarchar(255) | IN | Excel cell object value |
@cell_number_value | float | IN | Excel cell number value |
@cell_address | nvarchar(255) | IN | Excel cell address |
@company_id | int | IN | dbo25.dimension_properties.company_id |
@id | int | IN | dbo25.dimension_properties.id |
@root_member_id | int | IN | dbo25.dimension_properties.root_member_id |
@default_member_id | int | IN | dbo25.dimension_properties.default_member_id |
@data_language | varchar(10) | IN | Context data language |
The procedure just checks the changes. It does not save any data.
xls25.usp_dimensions_delete
This procedure deletes rows of xls25.usp_dimensions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | tinyint | IN | dbo25.dimension_properties.id |
@data_language | varchar(10) | IN | Context data language |
The procedure blocks deleting dimensions and raises an exception.
Use an SQL command to delete a dimension.
xls25.usp_dimensions_insert
This procedure inserts rows of xls25.usp_dimensions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.dimension_properties.company_id |
@id | tinyint | IN | dbo25.dimension_properties.id |
@code | nvarchar(50) | IN | dbo25.dimension_properties.code |
@name | nvarchar(100) | IN | dbo25.dimension_properties.name |
@translated_name | nvarchar(100) | IN | dbo25.translations.name |
@parameter_name | nvarchar(50) | IN | dbo25.dimension_properties.parameter_name |
@translated_parameter_name | nvarchar(50) | IN | dbo25.translations.name |
@sort_order | tinyint | IN | dbo25.dimension_properties.sort_order |
@name_format_id | tinyint | IN | dbo25.dimension_properties.name_format_id |
@root_member_id | int | IN | dbo25.dimension_properties.root_member_id |
@default_member_id | int | IN | dbo25.dimension_properties.default_member_id |
@is_protected | tinyint | IN | dbo25.dimension_properties.is_protected |
@default_select_permission | tinyint | IN | dbo25.dimension_properties.default_select_permission |
@default_update_permission | tinyint | IN | dbo25.dimension_properties.default_update_permission |
@is_active | tinyint | IN | dbo25.dimension_properties.is_active |
@data_language | varchar(10) | IN | Context data language |
The procedure blocks inserting dimensions and raises an exception.
Use an SQL command to insert a dimension.
However, note that you have to modify the application code also.
xls25.usp_dimensions_update
This procedure updates rows of xls25.usp_dimensions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.dimension_properties.company_id |
@id | tinyint | IN | dbo25.dimension_properties.id |
@code | nvarchar(50) | IN | dbo25.dimension_properties.code |
@name | nvarchar(100) | IN | dbo25.dimension_properties.name |
@translated_name | nvarchar(100) | IN | dbo25.translations.name |
@parameter_name | nvarchar(50) | IN | dbo25.dimension_properties.parameter_name |
@translated_parameter_name | nvarchar(50) | IN | dbo25.translations.name |
@sort_order | tinyint | IN | dbo25.dimension_properties.sort_order |
@name_format_id | tinyint | IN | dbo25.dimension_properties.name_format_id |
@root_member_id | int | IN | dbo25.dimension_properties.root_member_id |
@default_member_id | int | IN | dbo25.dimension_properties.default_member_id |
@is_protected | tinyint | IN | dbo25.dimension_properties.is_protected |
@default_select_permission | tinyint | IN | dbo25.dimension_properties.default_select_permission |
@default_update_permission | tinyint | IN | dbo25.dimension_properties.default_update_permission |
@is_active | tinyint | IN | dbo25.dimension_properties.is_active |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_facts
This procedure selects the calculated facts.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@id1 | int | IN | dbo25.members.id |
@id2 | int | IN | dbo25.members.id |
@id3 | int | IN | dbo25.members.id |
@id4 | int | IN | dbo25.members.id |
@id5 | int | IN | dbo25.members.id |
@id6 | int | IN | dbo25.members.id |
@id7 | int | IN | dbo25.members.id |
@unit_id | int | IN | dbo25.members.unit_id |
@calc_type_id | int | IN | dbo25.members.calc_type_id |
@data_language | varchar(10) | IN | Context data language |
This procedure selects the calculated cube values.
You may load the data into your BI tool, for example, PowerPivot.
xls25.usp_facts_data
This procedure selects source cube data.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@id1 | int | IN | dbo25.members.id |
@id2 | int | IN | dbo25.members.id |
@id3 | int | IN | dbo25.members.id |
@id4 | int | IN | dbo25.members.id |
@id5 | int | IN | dbo25.members.id |
@id6 | int | IN | dbo25.members.id |
@id7 | int | IN | dbo25.members.id |
@unit_id | int | IN | dbo25.members.unit_id |
@calc_type_id | int | IN | dbo25.members.calc_type_id |
@data_language | varchar(10) | IN | Context data language |
Use this procedure to check and edit source cube values directly.
xls25.usp_facts_strings
This procedure selects source cube strings.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@id1 | int | IN | dbo25.members.id |
@id2 | int | IN | dbo25.members.id |
@id3 | int | IN | dbo25.members.id |
@id4 | int | IN | dbo25.members.id |
@id5 | int | IN | dbo25.members.id |
@id6 | int | IN | dbo25.members.id |
@id7 | int | IN | dbo25.members.id |
@data_language | varchar(10) | IN | Context data language |
Use this procedure to check and edit source cube string values directly.
xls25.usp_form_dimensions
This procedure is an Excel form for editing form dimension properties.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.forms.company_id |
@data_language | varchar(10) | IN | Context data language |
The form selects dbo25.forms cross dbo25.dimensions.
Underlying tables: dbo25.forms, dbo25.dimensions, dbo25.form_dimensions
Example:

xls25.usp_form_dimensions_delete
This procedure deletes rows of xls25.usp_form_dimensions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@form_id | int | IN | dbo25.form_dimensions.form_id |
@dimension_id | tinyint | IN | dbo25.form_dimensions.dimension_id |
xls25.usp_form_dimensions_insert
This procedure inserts rows of xls25.usp_form_dimensions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@form_id | int | IN | dbo25.form_dimensions.form_id |
@dimension_id | tinyint | IN | dbo25.form_dimensions.dimension_id |
@axis_type_id | tinyint | IN | dbo25.form_dimensions.axis_type_id |
@parameter_index | tinyint | IN | dbo25.form_dimensions.parameter_index |
@header_order | tinyint | IN | dbo25.form_dimensions.header_order |
@root_member_id | int | IN | dbo25.form_dimensions.root_member_id |
@parameter_start_level | tinyint | IN | dbo25.form_dimensions.parameter_start_level |
@parameter_end_level | tinyint | IN | dbo25.form_dimensions.parameter_end_level |
@form_start_level | tinyint | IN | dbo25.form_dimensions.form_start_level |
@form_end_level | tinyint | IN | dbo25.form_dimensions.form_end_level |
xls25.usp_form_dimensions_update
This procedure updates rows of xls25.usp_form_dimensions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@form_id | int | IN | dbo25.form_dimensions.form_id |
@dimension_id | tinyint | IN | dbo25.form_dimensions.dimension_id |
@axis_type_id | tinyint | IN | dbo25.form_dimensions.axis_type_id |
@parameter_index | tinyint | IN | dbo25.form_dimensions.parameter_index |
@header_order | tinyint | IN | dbo25.form_dimensions.header_order |
@root_member_id | int | IN | dbo25.form_dimensions.root_member_id |
@parameter_start_level | tinyint | IN | dbo25.form_dimensions.parameter_start_level |
@parameter_end_level | tinyint | IN | dbo25.form_dimensions.parameter_end_level |
@form_start_level | tinyint | IN | dbo25.form_dimensions.form_start_level |
@form_end_level | tinyint | IN | dbo25.form_dimensions.form_end_level |
xls25.usp_form_permissions
This procedure is an Excel form for editing form permissions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.forms.company_id |
Underlying table: dbo25.form_permisssions
Editing data requires the SaveToDB Enterprise edition.
Example:

xls25.usp_form_permissions_change
This procedure updates a database on cell changes of xls25.usp_form_permissions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@column_name | nvarchar(128) | IN | dbo25.member_permissions.username |
@cell_number_value | int | IN | 1 - select_permission = 1
0 - select_permission = 0 |
@id | int | IN | dbo25.member_permissions.member_id |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_form_rows
This procedure is an Excel form for editing form rowsets.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.forms.company_id |
@rowset_id | int | IN | dbo25.form_rows.rowset_id |
@data_language | varchar(10) | IN | Context data language |
Note that you may create rowsets to use in rows and columns.
Underlying table: dbo25.form_rows
The following example shows configuring columns to compare budget vs. actuals:

xls25.usp_form_rows_delete
This procedure deletes rows of xls25.usp_form_rows.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.form_rows.id |
xls25.usp_form_rows_insert
This procedure inserts rows of xls25.usp_form_rows.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@rowset_id | int | IN | dbo25.form_rows.rowset_id |
@rownum | int | IN | dbo25.form_rows.sort_order
@rownum is a predefined SaveToDB add-in parameter |
@member_id | int | IN | dbo25.form_rows.member_id |
@code | nvarchar(50) | IN | dbo25.form_rows.code |
@name | nvarchar(400) | IN | dbo25.form_rows.name |
@translated_name | nvarchar(400) | IN | dbo25.translations.name |
@decimal_places | tinyint | IN | dbo25.form_rows.decimal_places |
@is_percent | tinyint | IN | dbo25.form_rows.is_percent |
@row_color | tinyint | IN | dbo25.form_rows.row_color |
@row_bold | tinyint | IN | dbo25.form_rows.row_bold |
@row_indent | tinyint | IN | dbo25.form_rows.row_indent |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_form_rows_update
This procedure updates rows of xls25.usp_form_rows.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.form_rows.id |
@rowset_id | int | IN | dbo25.form_rows.rowset_id |
@rownum | int | IN | dbo25.form_rows.sort_order
@rownum is a predefined SaveToDB add-in parameter |
@member_id | int | IN | dbo25.form_rows.member_id |
@code | nvarchar(50) | IN | dbo25.form_rows.code |
@name | nvarchar(400) | IN | dbo25.form_rows.name |
@translated_name | nvarchar(400) | IN | dbo25.translations.name |
@decimal_places | tinyint | IN | dbo25.form_rows.decimal_places |
@is_percent | tinyint | IN | dbo25.form_rows.is_percent |
@row_color | tinyint | IN | dbo25.form_rows.row_color |
@row_bold | tinyint | IN | dbo25.form_rows.row_bold |
@row_indent | tinyint | IN | dbo25.form_rows.row_indent |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_forms
This procedure is an Excel form for editing a list of forms.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.forms.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.forms
Example:

xls25.usp_forms_delete
This procedure deletes rows of xls25.usp_forms.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.forms.id |
xls25.usp_forms_insert
This procedure inserts rows of xls25.usp_forms.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.forms.company_id |
@code | nvarchar(50) | IN | dbo25.forms.code |
@name | nvarchar(100) | IN | dbo25.forms.name |
@translated_name | nvarchar(100) | IN | dbo25.translations.name |
@sort_order | int | IN | dbo25.forms.sort_order |
@is_active | tinyint | IN | dbo25.forms.is_active |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_forms_update
This procedure updates rows of xls25.usp_forms.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.forms.id |
@code | nvarchar(50) | IN | dbo25.forms.code |
@name | nvarchar(100) | IN | dbo25.forms.name |
@translated_name | nvarchar(100) | IN | dbo25.translations.name |
@sort_order | int | IN | dbo25.forms.sort_order |
@is_active | tinyint | IN | dbo25.forms.is_active |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_member_permissions
This procedure is an Excel form for editing member permissions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@dimension_id | tinyint | IN | Dimension filter |
@root_id | int | IN | Root member filter |
@username | nvarchar(128) | IN | Username filter |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.member_permissions
Editing data requires the SaveToDB Enterprise edition.
Example:

Type "r", "w", or "d" to change permissions.
The application applies new permissions immediately after changes.
xls25.usp_member_permissions_change
This procedure updates a database on cell changes of xls25.usp_member_permissions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@column_name | nvarchar(128) | IN | dbo25.member_permissions.username |
@cell_value | nvarchar(255) | IN | D - deny (select_permission = 0, update_permission = 0)
R - read (select_permission = 1, update_permission = 0) W - write (select_permission = 1, update_permission = 1) |
@id | int | IN | dbo25.member_permissions.member_id |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_member_relations
This procedure is an Excel form for editing member relations.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@dimension_id | int | IN | Dimension filter |
@root_id | int | IN | Root member filter |
@partner_id | int | IN | Partner dimension filter |
@field | nvarchar(50) | IN | update_permission, fixed value |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.member_relations
Editing data requires the SaveToDB Enterprise edition.
The example below shows the relations between accounts and regions:

xls25.usp_member_relations_change
This procedure updates a database on cell changes of xls25.usp_member_relations.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@column_name | nvarchar(128) | IN | dbo25.member_relations.partner_id |
@cell_number_value | int | IN | dbo25.member_relations.update_permission
1 - update_permission = 1 0 - update_permission = 0 |
@id | int | IN | dbo25.member_relations.member_id |
@field | nvarchar(50) | IN | update_permission, fixed value |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_members
This procedure is an Excel form for editing dimension members.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@dimension_id | tinyint | IN | Dimension filter |
@root_id | int | IN | Root member filter |
@data_language | varchar(10) | IN | Context data language |
Use the Actions menu to add typical members.
After saving data click Actions, Update Hierarchies, then Reload, Reload Data and Configuration.
These actions update member hierarchies and reload new members into Microsoft Excel.
Underlying tables: dbo25.members, dbo25.parents
Actions: xls25.xl_actions_update_hierarchies
Example:

xls25.usp_members_delete
This procedure deletes rows of xls25.usp_members.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.members.id |
xls25.usp_members_insert
This procedure inserts rows of xls25.usp_members.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@dimension_id | tinyint | IN | dbo25.members.dimension_id |
@code | nvarchar(50) | IN | dbo25.members.code |
@name | nvarchar(400) | IN | dbo25.members.name |
@translated_name | nvarchar(400) | IN | dbo25.translations.name |
@comment | nvarchar(1000) | IN | dbo25.members.comment |
@sort_order | int | IN | dbo25.members.sort_order |
@tax_rate_id | tinyint | IN | dbo25.members.tax_rate_id |
@unit_id | tinyint | IN | dbo25.members.unit_id |
@calc_type_id | tinyint | IN | dbo25.members.calc_type_id |
@previous_period_id | int | IN | dbo25.members.previous_period_id |
@same_period_id | int | IN | dbo25.members.same_period_id |
@decimal_places | tinyint | IN | dbo25.members.decimal_places |
@is_percent | tinyint | IN | dbo25.members.is_percent |
@row_color | tinyint | IN | dbo25.members.row_color |
@row_bold | tinyint | IN | dbo25.members.row_bold |
@row_indent | tinyint | IN | dbo25.members.row_indent |
@show_line | tinyint | IN | dbo25.members.show_line |
@show_line_before | tinyint | IN | dbo25.members.show_line_before |
@show_line_after | tinyint | IN | dbo25.members.show_line_after |
@is_active | tinyint | IN | dbo25.members.is_active |
@excel_formula | nvarchar(400) | IN | dbo25.members.excel_formula |
@parent1 | int | IN | dbo25.parents.parent_id |
@parent2 | int | IN | dbo25.parents.parent_id |
@parent3 | int | IN | dbo25.parents.parent_id |
@parent4 | int | IN | dbo25.parents.parent_id |
@parent5 | int | IN | dbo25.parents.parent_id |
@parent6 | int | IN | dbo25.parents.parent_id |
@parent7 | int | IN | dbo25.parents.parent_id |
@factor1 | float | IN | dbo25.parents.factor |
@factor2 | float | IN | dbo25.parents.factor |
@factor3 | float | IN | dbo25.parents.factor |
@factor4 | float | IN | dbo25.parents.factor |
@factor5 | float | IN | dbo25.parents.factor |
@factor6 | float | IN | dbo25.parents.factor |
@factor7 | float | IN | dbo25.parents.factor |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_members_update
This procedure updates rows of xls25.usp_members.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.members.id, dbo25.parents.member_id |
@code | nvarchar(50) | IN | dbo25.members.code |
@name | nvarchar(400) | IN | dbo25.members.name |
@translated_name | nvarchar(400) | IN | dbo25.translations.name |
@comment | nvarchar(1000) | IN | dbo25.members.comment |
@sort_order | int | IN | dbo25.members.sort_order |
@tax_rate_id | tinyint | IN | dbo25.members.tax_rate_id |
@unit_id | tinyint | IN | dbo25.members.unit_id |
@calc_type_id | tinyint | IN | dbo25.members.calc_type_id |
@previous_period_id | int | IN | dbo25.members.previous_period_id |
@same_period_id | int | IN | dbo25.members.same_period_id |
@decimal_places | tinyint | IN | dbo25.members.decimal_places |
@is_percent | tinyint | IN | dbo25.members.is_percent |
@row_color | tinyint | IN | dbo25.members.row_color |
@row_bold | tinyint | IN | dbo25.members.row_bold |
@row_indent | tinyint | IN | dbo25.members.row_indent |
@show_line | tinyint | IN | dbo25.members.show_line |
@show_line_before | tinyint | IN | dbo25.members.show_line_before |
@show_line_after | tinyint | IN | dbo25.members.show_line_after |
@is_active | tinyint | IN | dbo25.members.is_active |
@excel_formula | nvarchar(400) | IN | dbo25.members.excel_formula |
@parent1 | int | IN | dbo25.parents.parent_id |
@parent2 | int | IN | dbo25.parents.parent_id |
@parent3 | int | IN | dbo25.parents.parent_id |
@parent4 | int | IN | dbo25.parents.parent_id |
@parent5 | int | IN | dbo25.parents.parent_id |
@parent6 | int | IN | dbo25.parents.parent_id |
@parent7 | int | IN | dbo25.parents.parent_id |
@factor1 | float | IN | dbo25.parents.factor |
@factor2 | float | IN | dbo25.parents.factor |
@factor3 | float | IN | dbo25.parents.factor |
@factor4 | float | IN | dbo25.parents.factor |
@factor5 | float | IN | dbo25.parents.factor |
@factor6 | float | IN | dbo25.parents.factor |
@factor7 | float | IN | dbo25.parents.factor |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_name_formats
This procedure selects name formats.
Underlying table: dbo25.name_formats
xls25.usp_role_members
This procedure is a form for managing user roles.
A user must have VIEW DEFINITION permissions to see users.
xls25.usp_role_members_change
This procedure updates a role membership on cell changes of xls25.usp_role_members.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@column_name | nvarchar(128) | IN | username |
@cell_number_value | int | IN | 1 - include the user into a role
0 - exclude the user from the role |
@name | nvarchar(128) | IN | role |
@data_language | varchar(10) | IN | Context data language |
A user must have ALTER USER and ALTER ROLE permissions to change permissions.
xls25.usp_rowsets
This procedure is an Excel form for editing rowset members.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@dimension_id | tinyint | IN | Dimension filter |
@data_language | varchar(10) | IN | Context data language |
The form shows members of the dbo25.members table with calc_type_id = 9 (rowset).
You may add new rowsets here.
Use the xls25.usp_form_rows procedure to edit rowset rows.
Underlying table: dbo25.members
The example below shows the rowsets of the time dimension that contains years only and quarters only:

We recommend adding the asterisk at the end of codes and names to distinguish rowsets from regular hierarchy members.
xls25.usp_rowsets_delete
This procedure deletes rows of xls25.usp_rowsets.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.members.id |
xls25.usp_rowsets_insert
This procedure inserts rows of xls25.usp_rowsets.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@dimension_id | tinyint | IN | dbo25.members.dimension_id |
@code | nvarchar(50) | IN | dbo25.members.code |
@name | nvarchar(100) | IN | dbo25.members.name |
@translated_name | nvarchar(100) | IN | dbo25.translations.name |
@sort_order | int | IN | dbo25.members.sort_order |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_rowsets_update
This procedure updates rows of xls25.usp_rowsets.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.members.id |
@code | nvarchar(50) | IN | dbo25.members.code |
@name | nvarchar(100) | IN | dbo25.members.name |
@translated_name | nvarchar(100) | IN | dbo25.translations.name |
@sort_order | int | IN | dbo25.members.sort_order |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_run_form
This procedure executes forms configured using dbo25.forms and dbo25.form_dimensions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.forms.company_id |
@form_id | int | IN | dbo25.forms.id |
@form_p1 | int | IN | dbo25.members.id of the 1st ribbon parameter |
@form_p2 | int | IN | dbo25.members.id of the 2nd ribbon parameter |
@form_p3 | int | IN | dbo25.members.id of the 3rd ribbon parameter |
@form_p4 | int | IN | dbo25.members.id of the 4th ribbon parameter |
@form_p5 | int | IN | dbo25.members.id of the 5th ribbon parameter |
@form_p6 | int | IN | dbo25.members.id of the 6th ribbon parameter |
@form_p7 | int | IN | dbo25.members.id of the 7th ribbon parameter |
@data_language | varchar(10) | IN | Context data language |
This procedure is a form engine.
It returns the form layout configured using the dbo25.forms, dbo25.form_dimenstions, dbo25.form_rows, and dbo25.form_subtotals tables.
The form may have up to three dimensions in rows and up to three in columns.
Other dimensions must have member id values at the ribbon.
Ribbon parameters are dynamic and configured using dbo25.form_dimensions.
The Excel form has the cell change handler, xls25.usp_run_form_change, that updates underlying data.
This form requires the SaveToDB Enterprise edition.
You may use the offline form, xls25.usp_run_offline_form, with the SaveToDB Standard edition.
This is the most complicated procedure. If you need new features, you may contact us.
Example:

xls25.usp_run_form_change
This procedure updates a database on cell changes of xls25.usp_run_form.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@column_name | nvarchar(255) | IN | Excel cell column name.
Data column names contain dimension member codes separated by spaces. |
@table_name | nvarchar(255) | IN | Active form database object name |
@cell_value | nvarchar(255) | IN | Excel cell object value |
@cell_number_value | float | IN | Excel cell number value |
@cell_address | nvarchar(255) | IN | Excel cell address |
@changed_cell_count | int | IN | Total number of changed cells |
@changed_cell_index | int | IN | Cell index in the changed cells, starting 1.
The last cell has the index equal to @changed_cell_count. |
@id | int | IN | dbo25.form_rows.id |
@member_id | int | IN | dbo25.members.id of the 1st row dimension |
@member_id2 | int | IN | dbo25.members.id of the 2nd row dimension |
@member_id3 | int | IN | dbo25.members.id of the 3rd row dimension |
@form_id | int | IN | dbo25.forms.id |
@form_p1 | int | IN | dbo25.members.id of the 1st ribbon parameter |
@form_p2 | int | IN | dbo25.members.id of the 2nd ribbon parameter |
@form_p3 | int | IN | dbo25.members.id of the 3rd ribbon parameter |
@form_p4 | int | IN | dbo25.members.id of the 4th ribbon parameter |
@form_p5 | int | IN | dbo25.members.id of the 5th ribbon parameter |
@form_p6 | int | IN | dbo25.members.id of the 6th ribbon parameter |
@form_p7 | int | IN | dbo25.members.id of the 7th ribbon parameter |
@quiet_mode | tinyint | IN | 0 - raise exceptions on errors
1 - return on errors without exceptions |
@data_language | varchar(10) | IN | Context data language |
Note that this feature is available in the SaveToDB Enterprise edition only.
xls25.usp_run_json_form
This procedure returns calculated cube data requested with JSON parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.forms.company_id |
@request | nvarchar(max) | IN | Form parameters in the JSON format. |
You may use this procedure to create web forms.
See usage examples in the procedure code.
xls25.usp_run_offline_form
This procedure executes forms configured using dbo25.forms and dbo25.form_dimensions.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.forms.company_id |
@form_id | int | IN | dbo25.forms.id |
@form_p1 | int | IN | dbo25.members.id of the 1st ribbon parameter |
@form_p2 | int | IN | dbo25.members.id of the 2nd ribbon parameter |
@form_p3 | int | IN | dbo25.members.id of the 3rd ribbon parameter |
@form_p4 | int | IN | dbo25.members.id of the 4th ribbon parameter |
@form_p5 | int | IN | dbo25.members.id of the 5th ribbon parameter |
@form_p6 | int | IN | dbo25.members.id of the 6th ribbon parameter |
@form_p7 | int | IN | dbo25.members.id of the 7th ribbon parameter |
@data_language | varchar(10) | IN | Context data language |
This procedure is an offline form engine.
It calls xls25.usp_run_form internally and has the same output features.
However, it has a different saving configuration.
A user must click the Save button to save changes.
So, the user may edit data offline and save the changes when required.
Example:

xls25.usp_run_offline_form_delete
This procedure deletes rows of xls25.usp_run_offline_form.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.form_rows.id |
The procedure does nothing as users cannot delete the form rows.
xls25.usp_run_offline_form_insert
This procedure inserts rows of xls25.usp_run_offline_form.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.form_rows.id |
The procedure does nothing as users cannot add form rows.
xls25.usp_run_offline_form_update
This procedure updates rows of xls25.usp_run_offline_form.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.companies.id |
@table_name | nvarchar(255) | IN | Active form database object name |
@form_id | int | IN | dbo25.forms.id |
@form_p1 | int | IN | dbo25.members.id of the 1st ribbon parameter |
@form_p2 | int | IN | dbo25.members.id of the 2nd ribbon parameter |
@form_p3 | int | IN | dbo25.members.id of the 3rd ribbon parameter |
@form_p4 | int | IN | dbo25.members.id of the 4th ribbon parameter |
@form_p5 | int | IN | dbo25.members.id of the 5th ribbon parameter |
@form_p6 | int | IN | dbo25.members.id of the 6th ribbon parameter |
@form_p7 | int | IN | dbo25.members.id of the 7th ribbon parameter |
@member_id | int | IN | dbo25.members.id of the 1st row dimension |
@member_id2 | int | IN | dbo25.members.id of the 2nd row dimension |
@member_id3 | int | IN | dbo25.members.id of the 3rd row dimension |
@json_columns | nvarchar(max) | IN | An array of column names in the JSON format |
@json_values | nvarchar(max) | IN | An array of row values in the JSON format |
xls25.usp_tax_rates
This procedure is an Excel form for editing tax rates.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.tax_rates.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.tax_rates
xls25.usp_tax_rates_delete
This procedure deletes rows of xls25.usp_tax_rates.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.tax_rates.id |
xls25.usp_tax_rates_insert
This procedure inserts rows of xls25.usp_tax_rates.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.companies.id |
@code | nvarchar(50) | IN | dbo25.tax_rates.code |
@name | nvarchar(100) | IN | dbo25.tax_rates.name |
@translated_name | nvarchar(100) | IN | dbo25.translations.name |
@sort_order | int | IN | dbo25.tax_rates.sort_order |
@factor | float | IN | dbo25.tax_rates.factor |
@is_active | bit | IN | dbo25.tax_rates.is_active |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_tax_rates_update
This procedure updates rows of xls25.usp_tax_rates.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.tax_rates.id |
@code | nvarchar(50) | IN | dbo25.tax_rates.code |
@name | nvarchar(100) | IN | dbo25.tax_rates.name |
@translated_name | nvarchar(100) | IN | dbo25.translations.name |
@sort_order | int | IN | dbo25.tax_rates.sort_order |
@factor | float | IN | dbo25.tax_rates.factor |
@is_active | bit | IN | dbo25.tax_rates.is_active |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_translations
This procedure is a form of editing company-related translations.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.translations.company_id |
@is_translatable | bit | IN | 1 - select translatable elements only
0 - select non-translatable elements |
@is_complete | bit | IN | 1 - show values with complete translations
0 - show values with incomplete translations |
Source table: dbo25.translations
xls25.usp_translations_change
This procedure updates an element translation on cell changes of xls25.usp_translations.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.translations.company_id |
@table_id | int | IN | dbo25.translations.table_id |
@member_id | int | IN | dbo25.translations.member_id |
@column_name | nvarchar(128) | IN | dbo25.translations.language |
@cell_value | nvarchar(400) | IN | dbo25.translations.name |
@cell_number_value | int | IN | The value for the is_translatable column in supported tables |
xls25.usp_translations_common
This procedure is a form of editing application-level element translations.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@is_complete | bit | IN | 1 - show values with complete translations
0 - show values with incomplete translations |
Source table: xls.translations
This procedure selects all elements available for translations.
xls25.usp_translations_xls
This procedure is a form of editing actual application-level element translations.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@field | nvarchar(128) | IN | TRANSLATED_NAME, TRANSLATED_DESC, or TRANSLATED_COMMENT |
@schema | nvarchar(128) | IN | xls.translations.TABLE_SCHEMA |
@is_complete | bit | IN | 1 - show values with complete translations
0 - show values with incomplete translations |
Source table: xls.translations
This procedure selects existing elements.
xls25.usp_translations_xls_change
This procedure updates an application element translation on cell changes of xls25.usp_translations_xls.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@column_name | nvarchar(128) | IN | xls.translations.LANGUAGE_NAME |
@cell_value | nvarchar(max) | IN | A value for the specified field |
@TABLE_SCHEMA | nvarchar(128) | IN | xls.translations.TABLE_SCHEMA |
@TABLE_NAME | nvarchar(128) | IN | xls.translations.TABLE_NAME |
@COLUMN | nvarchar(128) | IN | xls.translations.COLUMN_NAME |
@field | nvarchar(128) | IN | TRANSLATED_NAME, TRANSLATED_DESC, or TRANSLATED_COMMENT |
@data_language | varchar(10) | IN | xls.translations.LANGUAGE_NAME |
xls25.usp_units
This procedure is an Excel form for editing units.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.units.company_id |
@data_language | varchar(10) | IN | Context data language |
Use the Excel context menu to change the system currency (the unit with id 0).
Underlying table: dbo25.units
Example:

xls25.usp_units_delete
This procedure deletes rows of xls25.usp_units.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.units.id |
xls25.usp_units_insert
This procedure inserts rows of xls25.usp_units.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.companies.id |
@code | nvarchar(50) | IN | dbo25.units.code |
@name | nvarchar(100) | IN | dbo25.units.name |
@translated_name | nvarchar(100) | IN | dbo25.translations.name |
@sort_order | int | IN | dbo25.units.sort_order |
@factor | float | IN | dbo25.units.factor |
@is_currency | bit | IN | dbo25.units.is_currency |
@is_functional_currency | bit | IN | dbo25.units.is_functional_currency |
@is_active | bit | IN | dbo25.units.is_active |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_units_update
This procedure updates rows of xls25.usp_units.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.units.id |
@code | nvarchar(50) | IN | dbo25.units.code |
@name | nvarchar(100) | IN | dbo25.units.name |
@translated_name | nvarchar(100) | IN | dbo25.translations.name |
@sort_order | int | IN | dbo25.units.sort_order |
@factor | float | IN | dbo25.units.factor |
@is_currency | bit | IN | dbo25.units.is_currency |
@is_functional_currency | bit | IN | dbo25.units.is_functional_currency |
@is_active | bit | IN | dbo25.units.is_active |
@data_language | varchar(10) | IN | Context data language |
xls25.usp_users
This procedure is a form of editing users.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.users.company_id |
Source table: dbo25.users
xls25.usp_users_delete
This procedure deletes rows of xls25.usp_users.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.users.company_id |
@username | nvarchar(128) | IN | dbo25.users.username |
xls25.usp_users_insert
This procedure inserts rows of xls25.usp_users.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.users.company_id |
@username | nvarchar(128) | IN | dbo25.users.username |
@name | nvarchar(100) | IN | dbo25.users.name |
@is_admin | bit | IN | dbo25.users.is_admin |
@is_active | bit | IN | dbo25.users.is_active |
@is_default | bit | IN | dbo25.users.is_default |
xls25.usp_users_update
This procedure updates rows of xls25.usp_users.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.users.company_id |
@username | nvarchar(128) | IN | dbo25.users.username |
@name | nvarchar(100) | IN | dbo25.users.name |
@is_admin | bit | IN | dbo25.users.is_admin |
@is_active | bit | IN | dbo25.users.is_active |
@is_default | bit | IN | dbo25.users.is_default |
xls25.xl_actions_add_language
This procedure adds a new language for company-related elements.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.companies.id |
@language | varchar(10) | IN | dbo25.translations.language |
Users may run this procedure from the Actions menu.
xls25.xl_actions_add_quarters
This procedure adds quarter members.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.companies.id |
@year | int | IN | Year |
@data_language | varchar(10) | IN | Context data language |
Use this procedure if you need only years and quarters but not months.
Target tables: dbo25.members, dbo25.parents
xls25.xl_actions_add_year
This procedure adds year members.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.companies.id |
@year | int | IN | Year |
@data_language | varchar(10) | IN | Context data language |
Use this procedure if you need years, quarters, and months.
Target tables: dbo25.members, dbo25.parents
xls25.xl_actions_copy_data
This procedure copies data from a category to category.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.companies.id |
@code | nvarchar(50) | IN | Time dbo25.members.id |
@source_category_code | nvarchar(50) | IN | Source category dbo25.members.id |
@target_category_code | nvarchar(50) | IN | Target category dbo25.members.id |
@set_1_to_copy | tinyint | IN | 1 - to confirm copying data |
@data_language | varchar(10) | IN | Context data language |
For example, you may use this procedure to copy BUDGET data to FORECAST, or just create a copy of the budget data.
The procedure does not copy string data.
Target table: dbo25.facts
xls25.xl_actions_delete_data
This procedure deletes source cube data from a category.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.companies.id |
@code | nvarchar(50) | IN | Time dbo25.members.id |
@category_code | nvarchar(50) | IN | Category dbo25.members.id |
@set_1_to_delete | tinyint | IN | 1 - to confirm deleting data |
@data_language | varchar(10) | IN | Context data language |
Target tables: dbo25.facts, dbo25.strings
xls25.xl_actions_delete_year
This procedure deletes year members.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.companies.id |
@year | int | IN | Year |
@set_1_to_delete | tinyint | IN | 1 - to confirm deleting data |
@data_language | varchar(10) | IN | Context data language |
Delete the cube data of the required year before deleting the members.
Target tables: dbo25.members, dbo25.parents
xls25.xl_actions_run_form_cell_data
This procedure selects underlying cube data for a reporting cell.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@column_name | nvarchar(255) | IN | Excel cell column name.
Data column names contain dimension member codes separated by spaces. |
@table_name | nvarchar(255) | IN | Active form database object name |
@member_id | int | IN | dbo25.members.id of the 1st row dimension |
@member_id2 | int | IN | dbo25.members.id of the 2nd row dimension |
@member_id3 | int | IN | dbo25.members.id of the 3rd row dimension |
@form_id | int | IN | dbo25.forms.id |
@form_p1 | int | IN | dbo25.members.id of the 1st ribbon parameter |
@form_p2 | int | IN | dbo25.members.id of the 2nd ribbon parameter |
@form_p3 | int | IN | dbo25.members.id of the 3rd ribbon parameter |
@form_p4 | int | IN | dbo25.members.id of the 4th ribbon parameter |
@form_p5 | int | IN | dbo25.members.id of the 5th ribbon parameter |
@form_p6 | int | IN | dbo25.members.id of the 6th ribbon parameter |
@form_p7 | int | IN | dbo25.members.id of the 7th ribbon parameter |
@data_language | varchar(10) | IN | Context data language |
This procedure is used in the Excel context menu to drill-down cell values.
Underlying table: dbo25.facts
Output example:

xls25.xl_actions_set_functional_currency
This procedure changes the system currency of the application.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@id | int | IN | dbo25.units.id |
@data_language | varchar(10) | IN | Context data language |
Target table: dbo25.units
xls25.xl_actions_update_facts
This procedure updates cube values after the currency rate changes.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
Target table: dbo25.facts
xls25.xl_actions_update_hierarchies
This procedure updates the required tables after member changes.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
Target tables: dbo25.hierarchies, dbo25.factors
xls25.xl_actions_update_member_permissions
This procedure updates member permissions after member changes.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
Target table: dbo25.member_permissions
xls25.xl_aliases_members
This procedure configures column sets of xls25.usp_members procedure.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@dimension_id | tinyint | IN | dbo25.members.dimension_id |
@data_language | varchar(10) | IN | Context data language |
The SaveToDB add-in allows showing and hiding columns on ribbon parameter value changes.
This procedure selects column sets depending on dimension_id.
xls25.xl_parameter_values_0_or_1
This procedure selects 0 or 1 for Excel ribbon parameters.
Use this procedure in the xls.handlers table for parameters that accept 0 or 1 only.
You do not need to use for parameters with the bit datatype.
The SaveToDB add-in suggests 1 (yes) and 0 (no) values by default.
xls25.xl_parameter_values_calc_type_id
This procedure selects calculation types for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.calc_types
xls25.xl_parameter_values_calc_type_id_or_null
This procedure selects calculation types for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.calc_types
xls25.xl_parameter_values_company_id
This procedure selects companies for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.companies
xls25.xl_parameter_values_currency_id
This procedure selects currencies for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.units.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.units
xls25.xl_parameter_values_dimension_id
This procedure selects dimensions for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.dimension_properties.company_id |
Underlying table: dbo25.dimensions
xls25.xl_parameter_values_dimension_id_or_null
This procedure selects dimensions for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.dimension_properties.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.dimensions
xls25.xl_parameter_values_form_id
This procedure selects forms for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.forms.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.forms
xls25.xl_parameter_values_form_id_or_null
This procedure selects forms for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.forms.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.forms
xls25.xl_parameter_values_member_id_by_dimension_id
This procedure selects members for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@dimension_id | tinyint | IN | dbo25.members.dimension_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_member_id_dim1
This procedure selects 1st dimension members for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_member_id_dim2
This procedure selects 2nd dimension members for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_member_id_dim3
This procedure selects 3rd dimension members for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_member_id_dim4
This procedure selects 4th dimension members for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_member_id_dim5
This procedure selects 5th dimension members for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_member_id_dim6
This procedure selects 6th dimension members for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_member_id_dim7
This procedure selects 7th dimension members for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_relation_dimension_id
This procedure selects dimensions for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.dimension_properties.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.dimensions
xls25.xl_parameter_values_relation_partner_id
This procedure selects members for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.dimension_properties.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.dimensions
xls25.xl_parameter_values_root_member_id_code
This procedure selects possible root members for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@dimension_id | tinyint | IN | dbo25.members.dimension_id |
Underlying table: dbo25.members
xls25.xl_parameter_values_rowset_id
This procedure selects rowsets for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_rowset_id_or_null
This procedure selects rowsets for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_run_form_p
This procedure selects values for the ribbon parameters of the configured forms.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@form_id | int | IN | dbo25.form_dimensions.form_id |
@parameter_index | int | IN | dbo25.form_dimensions.parameter_index |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_run_form_p1
This procedure selects values for the 1st ribbon parameter of the configured forms.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@form_id | int | IN | dbo25.form_dimensions.form_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_run_form_p2
This procedure selects values for the 2nd ribbon parameter of the configured forms.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@form_id | int | IN | dbo25.form_dimensions.form_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_run_form_p3
This procedure selects values for the 3rd ribbon parameter of the configured forms.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@form_id | int | IN | dbo25.form_dimensions.form_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_run_form_p4
This procedure selects values for the 4th ribbon parameter of the configured forms.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@form_id | int | IN | dbo25.form_dimensions.form_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_run_form_p5
This procedure selects values for the 5th ribbon parameter of the configured forms.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@form_id | int | IN | dbo25.form_dimensions.form_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_run_form_p6
This procedure selects values for the 6th ribbon parameter of the configured forms.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@form_id | int | IN | dbo25.form_dimensions.form_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_run_form_p7
This procedure selects values for the 7th ribbon parameter of the configured forms.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@form_id | int | IN | dbo25.form_dimensions.form_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_parameter_values_unit_id
This procedure selects units for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.units.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.units
xls25.xl_parameter_values_username
This procedure selects usernames for Excel ribbon parameters.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.users.company_id |
The procedure selects usernames of members of the planning_app_users role only.
To manage users, grant the VIEW DEFINITION permission. Other permissions are not required.
Underlying tables: sys.database_principals, sys.database_role_members
xls25.xl_validation_list_axis_type_id
This procedure selects axis types to use as an Excel validation list source.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.axis_types
xls25.xl_validation_list_calc_type_id
This procedure selects calculation types to use as an Excel validation list source.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.calc_types
xls25.xl_validation_list_calc_type_id_by_dimension_id
This procedure selects calculation types to use as an Excel validation list source.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@dimension_id | tinyint | IN | dbo25.dimension_calc_types.dimension_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.calc_types
xls25.xl_validation_list_default_member_id_code
This procedure selects possible default members to use as an Excel validation list source.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
Underlying table: dbo25.members
xls25.xl_validation_list_dimension_id
This procedure selects dimensions to use as an Excel validation list source.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.dimension_properties.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.dimensions
xls25.xl_validation_list_member_id
This procedure selects members to use as an Excel validation list source.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_validation_list_member_id_code_by_dimension_id
This procedure selects members to use as an Excel validation list source.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@dimension_id | tinyint | IN | dbo25.members.dimension_id |
Underlying table: dbo25.members
xls25.xl_validation_list_member_id_code_by_rowset_id
This procedure selects members to use as an Excel validation list source.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@rowset_id | int | IN | dbo25.members.id |
Underlying table: dbo25.members
xls25.xl_validation_list_name_format_id
This procedure selects name formats to use as an Excel validation list source.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.name_formats
xls25.xl_validation_list_previous_period_id_by_dimension_id
This procedure selects previous period members to use as an Excel validation list source.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@dimension_id | tinyint | IN | dbo25.members.dimension_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_validation_list_root_member_id_code
This procedure selects possible root members to use as an Excel validation list source.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
Underlying table: dbo25.members
xls25.xl_validation_list_root_member_or_rowset_id_code
This procedure selects possible root members to use as an Excel validation list source.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
Underlying table: dbo25.members
xls25.xl_validation_list_rowset_id
This procedure selects rowsets to use as an Excel validation list source.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_validation_list_same_period_id_by_dimension_id
This procedure selects the same period members to use as an Excel validation list source.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.members.company_id |
@dimension_id | tinyint | IN | dbo25.members.dimension_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.members
xls25.xl_validation_list_tax_rate_id_by_dimension_id
This procedure selects tax rates to use as an Excel validation list source.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.tax_rates.company_id |
@dimension_id | tinyint | IN | dbo25.members.dimension_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.tax_rates
xls25.xl_validation_list_unit_id_by_dimension_id
This procedure selects units to use as an Excel validation list source.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@company_id | int | IN | dbo25.units.company_id |
@dimension_id | tinyint | IN | dbo25.members.dimension_id |
@data_language | varchar(10) | IN | Context data language |
Underlying table: dbo25.units
xls25a.usp_update_table_format
This procedure updates Excel table formats of online dynamic forms.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@schema | nvarchar(128) | IN | |
@name | nvarchar(128) | IN | |
@ExcelFormatXML | xml | IN |
Underlying table: dbo25.formats
Analysts and developers may use the Save Table Format menu item to save formats.
Users may use the Load Table Format menu item to load formats.
xls25b.usp_update_table_format
This procedure updates Excel table formats of offline dynamic forms.
Parameter | DataType | Mode | Comment |
---|---|---|---|
@schema | nvarchar(128) | IN | |
@name | nvarchar(128) | IN | |
@ExcelFormatXML | xml | IN |
Underlying table: dbo25.formats
Analysts and developers may use the Save Table Format menu item to save formats.
Users may use the Load Table Format menu item to load formats.
Functions
Function | Description |
---|---|
dbo25.get_translated_string | This function returns a company-related translated string. |
dbo25.get_translated_string
This function returns a company-related translated string.
Parameter | DataType | Comment |
---|---|---|
Result | nvarchar(128) | xls.translations.TRANSLATED_NAME |
@string | nvarchar(128) | xls.translations.COLUMN_NAME |
@data_language | varchar(10) | xls.translations.LANGUAGE_NAME |
Underlying table: dbo25.translations