Planning Application Procedures

Planning Application Procedures

ProcedureDescription
dbo25.usp_export_allThis procedure exports all data.
dbo25.usp_export_companiesThis procedure exports companies.
dbo25.usp_export_currency_ratesThis procedure exports currency rates.
dbo25.usp_export_dimension_calc_typesThis procedure exports dimension calculation types.
dbo25.usp_export_dimension_membersThis procedure exports dimension members.
dbo25.usp_export_dimension_propertiesThis procedure exports dimension properties.
dbo25.usp_export_dimensionsThis procedure exports dimensions.
dbo25.usp_export_factsThis procedure exports source numbers.
dbo25.usp_export_form_dimensionsThis procedure exports form dimension settings.
dbo25.usp_export_form_permissionsThis procedure exports form permissions.
dbo25.usp_export_form_rowsThis procedure exports form row settings.
dbo25.usp_export_form_subtotalsThis procedure exports form subtotal settings.
dbo25.usp_export_formatsThis procedure exports Excel table formats.
dbo25.usp_export_formsThis procedure exports forms and form settings.
dbo25.usp_export_member_parentsThis procedure exports member parents.
dbo25.usp_export_member_permissionsThis procedure exports member permissions.
dbo25.usp_export_member_propertiesThis procedure exports member properties.
dbo25.usp_export_member_relationsThis procedure exports member relations.
dbo25.usp_export_membersThis procedure exports members.
dbo25.usp_export_stringsThis procedure exports source strings.
dbo25.usp_export_tax_ratesThis procedure exports tax rates.
dbo25.usp_export_translationsThis procedure exports company-related translations.
dbo25.usp_export_unitsThis procedure exports units.
dbo25.usp_export_usersThis procedure exports users.
dbo25.usp_import_clear_all_dataThis procedure clears all data before importing data.
dbo25.usp_import_companiesThis procedure imports companies.
dbo25.usp_import_currency_ratesThis procedure imports currency rates.
dbo25.usp_import_dimension_calc_typesThis procedure imports calculation types by dimensions.
dbo25.usp_import_dimension_membersThis procedure imports dimension members.
dbo25.usp_import_dimension_propertiesThis procedure imports dimension properties.
dbo25.usp_import_dimensionsThis procedure imports dimensions.
dbo25.usp_import_factsThis procedure imports source numbers.
dbo25.usp_import_finishThis procedure executes the required actions after importing data.
dbo25.usp_import_form_dimensionsThis procedure imports form dimension properties.
dbo25.usp_import_form_permissionsThis procedure imports form permissions.
dbo25.usp_import_form_rowsThis procedure imports custom form rowsets.
dbo25.usp_import_form_subtotalsThis procedure imports form subtotal settings.
dbo25.usp_import_formatsThis procedure imports Excel table formats.
dbo25.usp_import_formsThis procedure imports forms.
dbo25.usp_import_member_parentsThis procedure imports member parents.
dbo25.usp_import_member_permissionsThis procedure imports member permissions.
dbo25.usp_import_member_propertiesThis procedure imports member properties.
dbo25.usp_import_member_relationsThis procedure imports member relations.
dbo25.usp_import_membersThis procedure imports dimension members.
dbo25.usp_import_stringsThis procedure imports source strings.
dbo25.usp_import_tax_ratesThis procedure imports tax rates.
dbo25.usp_import_translationsThis procedure imports company-related translations.
dbo25.usp_import_unitsThis procedure imports units.
dbo25.usp_import_usersThis procedure imports users.
dbo25.xl_actions_create_standard_formsThis procedure creates a set of standard forms.
dbo25.xl_actions_create_standard_membersThis procedure creates standard dimension members.
dbo25.xl_actions_create_standard_tax_ratesThis procedure creates a set of standard tax rates.
dbo25.xl_actions_create_standard_unitsThis procedure creates a set of standard units.
dbo25.xl_actions_set_doc_role_permissionsThis procedure sets the permissions of user roles for the Database Help Framework.
dbo25.xl_actions_set_log_role_permissionsThis procedure sets the permissions of user roles for the Change Tracking Framework.
dbo25.xl_actions_set_role_permissionsThis procedure grants permissions to the planning application roles.
xls25.usp_axis_typesThis procedure selects form axis types.
xls25.usp_calc_typesThis procedure is an Excel form for editing calculation types.
xls25.usp_closed_periodsThis procedure is an Excel form for editing closed periods.
xls25.usp_closed_periods_changeThis procedure updates a database on cell changes of xls25.usp_closed_periods.
xls25.usp_companiesThis procedure is a form of editing companies.
xls25.usp_companies_deleteThis procedure deletes rows of xls25.usp_companies.
xls25.usp_companies_insertThis procedure inserts rows of xls25.usp_companies.
xls25.usp_companies_updateThis procedure updates rows of xls25.usp_companies.
xls25.usp_currency_ratesThis procedure is an Excel form for editing currency rates.
xls25.usp_currency_rates_changeThis procedure updates a database on cell changes of xls25.usp_rates.
xls25.usp_data_managementThis procedure is an Excel form for data management.
xls25.usp_dimensionsThis procedure is an Excel form for editing dimensions.
xls25.usp_dimensions_changeThis procedure checks user input on cell changes of xls25.usp_dimensions.
xls25.usp_dimensions_deleteThis procedure deletes rows of xls25.usp_dimensions.
xls25.usp_dimensions_insertThis procedure inserts rows of xls25.usp_dimensions.
xls25.usp_dimensions_updateThis procedure updates rows of xls25.usp_dimensions.
xls25.usp_factsThis procedure selects the calculated facts.
xls25.usp_facts_dataThis procedure selects source cube data.
xls25.usp_facts_stringsThis procedure selects source cube strings.
xls25.usp_form_dimensionsThis procedure is an Excel form for editing form dimension properties.
xls25.usp_form_dimensions_deleteThis procedure deletes rows of xls25.usp_form_dimensions.
xls25.usp_form_dimensions_insertThis procedure inserts rows of xls25.usp_form_dimensions.
xls25.usp_form_dimensions_updateThis procedure updates rows of xls25.usp_form_dimensions.
xls25.usp_form_permissionsThis procedure is an Excel form for editing form permissions.
xls25.usp_form_permissions_changeThis procedure updates a database on cell changes of xls25.usp_form_permissions.
xls25.usp_form_rowsThis procedure is an Excel form for editing form rowsets.
xls25.usp_form_rows_deleteThis procedure deletes rows of xls25.usp_form_rows.
xls25.usp_form_rows_insertThis procedure inserts rows of xls25.usp_form_rows.
xls25.usp_form_rows_updateThis procedure updates rows of xls25.usp_form_rows.
xls25.usp_formsThis procedure is an Excel form for editing a list of forms.
xls25.usp_forms_deleteThis procedure deletes rows of xls25.usp_forms.
xls25.usp_forms_insertThis procedure inserts rows of xls25.usp_forms.
xls25.usp_forms_updateThis procedure updates rows of xls25.usp_forms.
xls25.usp_member_permissionsThis procedure is an Excel form for editing member permissions.
xls25.usp_member_permissions_changeThis procedure updates a database on cell changes of xls25.usp_member_permissions.
xls25.usp_member_relationsThis procedure is an Excel form for editing member relations.
xls25.usp_member_relations_changeThis procedure updates a database on cell changes of xls25.usp_member_relations.
xls25.usp_membersThis procedure is an Excel form for editing dimension members.
xls25.usp_members_deleteThis procedure deletes rows of xls25.usp_members.
xls25.usp_members_insertThis procedure inserts rows of xls25.usp_members.
xls25.usp_members_updateThis procedure updates rows of xls25.usp_members.
xls25.usp_name_formatsThis procedure selects name formats.
xls25.usp_role_membersThis procedure is a form for managing user roles.
xls25.usp_role_members_changeThis procedure updates a role membership on cell changes of xls25.usp_role_members.
xls25.usp_rowsetsThis procedure is an Excel form for editing rowset members.
xls25.usp_rowsets_deleteThis procedure deletes rows of xls25.usp_rowsets.
xls25.usp_rowsets_insertThis procedure inserts rows of xls25.usp_rowsets.
xls25.usp_rowsets_updateThis procedure updates rows of xls25.usp_rowsets.
xls25.usp_run_formThis procedure executes forms configured using dbo25.forms and dbo25.form_dimensions.
xls25.usp_run_form_changeThis procedure updates a database on cell changes of xls25.usp_run_form.
xls25.usp_run_json_formThis procedure returns calculated cube data requested with JSON parameters.
xls25.usp_run_offline_formThis procedure executes forms configured using dbo25.forms and dbo25.form_dimensions.
xls25.usp_run_offline_form_deleteThis procedure deletes rows of xls25.usp_run_offline_form.
xls25.usp_run_offline_form_insertThis procedure inserts rows of xls25.usp_run_offline_form.
xls25.usp_run_offline_form_updateThis procedure updates rows of xls25.usp_run_offline_form.
xls25.usp_tax_ratesThis procedure is an Excel form for editing tax rates.
xls25.usp_tax_rates_deleteThis procedure deletes rows of xls25.usp_tax_rates.
xls25.usp_tax_rates_insertThis procedure inserts rows of xls25.usp_tax_rates.
xls25.usp_tax_rates_updateThis procedure updates rows of xls25.usp_tax_rates.
xls25.usp_translationsThis procedure is a form of editing company-related translations.
xls25.usp_translations_changeThis procedure updates an element translation on cell changes of xls25.usp_translations.
xls25.usp_translations_commonThis procedure is a form of editing application-level element translations.
xls25.usp_translations_xlsThis procedure is a form of editing actual application-level element translations.
xls25.usp_translations_xls_changeThis procedure updates an application element translation on cell changes of xls25.usp_translations_xls.
xls25.usp_unitsThis procedure is an Excel form for editing units.
xls25.usp_units_deleteThis procedure deletes rows of xls25.usp_units.
xls25.usp_units_insertThis procedure inserts rows of xls25.usp_units.
xls25.usp_units_updateThis procedure updates rows of xls25.usp_units.
xls25.usp_usersThis procedure is a form of editing users.
xls25.usp_users_deleteThis procedure deletes rows of xls25.usp_users.
xls25.usp_users_insertThis procedure inserts rows of xls25.usp_users.
xls25.usp_users_updateThis procedure updates rows of xls25.usp_users.
xls25.xl_actions_add_languageThis procedure adds a new language for company-related elements.
xls25.xl_actions_add_quartersThis procedure adds quarter members.
xls25.xl_actions_add_yearThis procedure adds year members.
xls25.xl_actions_copy_dataThis procedure copies data from a category to category.
xls25.xl_actions_delete_dataThis procedure deletes source cube data from a category.
xls25.xl_actions_delete_yearThis procedure deletes year members.
xls25.xl_actions_run_form_cell_dataThis procedure selects underlying cube data for a reporting cell.
xls25.xl_actions_set_functional_currencyThis procedure changes the system currency of the application.
xls25.xl_actions_update_factsThis procedure updates cube values after the currency rate changes.
xls25.xl_actions_update_hierarchiesThis procedure updates the required tables after member changes.
xls25.xl_actions_update_member_permissionsThis procedure updates member permissions after member changes.
xls25.xl_aliases_membersThis procedure configures column sets of xls25.usp_members procedure.
xls25.xl_parameter_values_0_or_1This procedure selects 0 or 1 for Excel ribbon parameters.
xls25.xl_parameter_values_calc_type_idThis procedure selects calculation types for Excel ribbon parameters.
xls25.xl_parameter_values_calc_type_id_or_nullThis procedure selects calculation types for Excel ribbon parameters.
xls25.xl_parameter_values_company_idThis procedure selects companies for Excel ribbon parameters.
xls25.xl_parameter_values_currency_idThis procedure selects currencies for Excel ribbon parameters.
xls25.xl_parameter_values_dimension_idThis procedure selects dimensions for Excel ribbon parameters.
xls25.xl_parameter_values_dimension_id_or_nullThis procedure selects dimensions for Excel ribbon parameters.
xls25.xl_parameter_values_form_idThis procedure selects forms for Excel ribbon parameters.
xls25.xl_parameter_values_form_id_or_nullThis procedure selects forms for Excel ribbon parameters.
xls25.xl_parameter_values_member_id_by_dimension_idThis procedure selects members for Excel ribbon parameters.
xls25.xl_parameter_values_member_id_dim1This procedure selects 1st dimension members for Excel ribbon parameters.
xls25.xl_parameter_values_member_id_dim2This procedure selects 2nd dimension members for Excel ribbon parameters.
xls25.xl_parameter_values_member_id_dim3This procedure selects 3rd dimension members for Excel ribbon parameters.
xls25.xl_parameter_values_member_id_dim4This procedure selects 4th dimension members for Excel ribbon parameters.
xls25.xl_parameter_values_member_id_dim5This procedure selects 5th dimension members for Excel ribbon parameters.
xls25.xl_parameter_values_member_id_dim6This procedure selects 6th dimension members for Excel ribbon parameters.
xls25.xl_parameter_values_member_id_dim7This procedure selects 7th dimension members for Excel ribbon parameters.
xls25.xl_parameter_values_relation_dimension_idThis procedure selects dimensions for Excel ribbon parameters.
xls25.xl_parameter_values_relation_partner_idThis procedure selects members for Excel ribbon parameters.
xls25.xl_parameter_values_root_member_id_codeThis procedure selects possible root members for Excel ribbon parameters.
xls25.xl_parameter_values_rowset_idThis procedure selects rowsets for Excel ribbon parameters.
xls25.xl_parameter_values_rowset_id_or_nullThis procedure selects rowsets for Excel ribbon parameters.
xls25.xl_parameter_values_run_form_pThis procedure selects values for the ribbon parameters of the configured forms.
xls25.xl_parameter_values_run_form_p1This procedure selects values for the 1st ribbon parameter of the configured forms.
xls25.xl_parameter_values_run_form_p2This procedure selects values for the 2nd ribbon parameter of the configured forms.
xls25.xl_parameter_values_run_form_p3This procedure selects values for the 3rd ribbon parameter of the configured forms.
xls25.xl_parameter_values_run_form_p4This procedure selects values for the 4th ribbon parameter of the configured forms.
xls25.xl_parameter_values_run_form_p5This procedure selects values for the 5th ribbon parameter of the configured forms.
xls25.xl_parameter_values_run_form_p6This procedure selects values for the 6th ribbon parameter of the configured forms.
xls25.xl_parameter_values_run_form_p7This procedure selects values for the 7th ribbon parameter of the configured forms.
xls25.xl_parameter_values_unit_idThis procedure selects units for Excel ribbon parameters.
xls25.xl_parameter_values_usernameThis procedure selects usernames for Excel ribbon parameters.
xls25.xl_validation_list_axis_type_idThis procedure selects axis types to use as an Excel validation list source.
xls25.xl_validation_list_calc_type_idThis procedure selects calculation types to use as an Excel validation list source.
xls25.xl_validation_list_calc_type_id_by_dimension_idThis procedure selects calculation types to use as an Excel validation list source.
xls25.xl_validation_list_default_member_id_codeThis procedure selects possible default members to use as an Excel validation list source.
xls25.xl_validation_list_dimension_idThis procedure selects dimensions to use as an Excel validation list source.
xls25.xl_validation_list_member_idThis procedure selects members to use as an Excel validation list source.
xls25.xl_validation_list_member_id_code_by_dimension_idThis procedure selects members to use as an Excel validation list source.
xls25.xl_validation_list_member_id_code_by_rowset_idThis procedure selects members to use as an Excel validation list source.
xls25.xl_validation_list_name_format_idThis procedure selects name formats to use as an Excel validation list source.
xls25.xl_validation_list_previous_period_id_by_dimension_idThis procedure selects previous period members to use as an Excel validation list source.
xls25.xl_validation_list_root_member_id_codeThis procedure selects possible root members to use as an Excel validation list source.
xls25.xl_validation_list_root_member_or_rowset_id_codeThis procedure selects possible root members to use as an Excel validation list source.
xls25.xl_validation_list_rowset_idThis procedure selects rowsets to use as an Excel validation list source.
xls25.xl_validation_list_same_period_id_by_dimension_idThis procedure selects the same period members to use as an Excel validation list source.
xls25.xl_validation_list_tax_rate_id_by_dimension_idThis procedure selects tax rates to use as an Excel validation list source.
xls25.xl_validation_list_unit_id_by_dimension_idThis procedure selects units to use as an Excel validation list source.
xls25a.usp_update_table_formatThis procedure updates Excel table formats of online dynamic forms.
xls25b.usp_update_table_formatThis procedure updates Excel table formats of offline dynamic forms.

dbo25.usp_export_all

This procedure exports all data.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@print_gobitIN1 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.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source table: dbo25.companies

dbo25.usp_export_currency_rates

This procedure exports currency rates.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.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.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source table: dbo25.dimension_properties, dbo25.members

dbo25.usp_export_dimension_properties

This procedure exports dimension properties.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.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.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source table: dbo25.facts

dbo25.usp_export_form_dimensions

This procedure exports form dimension settings.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source table: dbo25.forms, dbo25.form_dimensions

dbo25.usp_export_form_permissions

This procedure exports form permissions.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source table: dbo25.forms, dbo25.form_permissions

dbo25.usp_export_form_rows

This procedure exports form row settings.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source table: dbo25.forms, dbo25.form_rows

dbo25.usp_export_form_subtotals

This procedure exports form subtotal settings.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source table: dbo25.forms, dbo25.form_subtotals

dbo25.usp_export_formats

This procedure exports Excel table formats.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source table: dbo25.formats

dbo25.usp_export_forms

This procedure exports forms and form settings.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source table: dbo25.forms

dbo25.usp_export_member_parents

This procedure exports member parents.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source tables: dbo25.members, dbo25.parents

dbo25.usp_export_member_permissions

This procedure exports member permissions.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source tables: dbo25.members, dbo25.member_permissions

dbo25.usp_export_member_properties

This procedure exports member properties.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source tables: dbo25.members

dbo25.usp_export_member_relations

This procedure exports member relations.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source tables: dbo25.members, dbo25.member_relations

dbo25.usp_export_members

This procedure exports members.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source tables: dbo25.members, dbo25.parents, dbo25.member_relations, dbo25.member_permissions.

dbo25.usp_export_strings

This procedure exports source strings.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source table: dbo25.strings

dbo25.usp_export_tax_rates

This procedure exports tax rates.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source table: dbo25.tax_rates

dbo25.usp_export_translations

This procedure exports company-related translations.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@languagechar(2)INdbo25.translations.LANGUAGE_NAME

Source table: dbo25.translations

dbo25.usp_export_units

This procedure exports units.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source table: dbo25.units

dbo25.usp_export_users

This procedure exports users.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code

Source table: dbo25.users

dbo25.usp_import_clear_all_data

This procedure clears all data before importing data.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@confirmnvarchar(50)INyes - to confirm deleting data
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@codenvarchar(50)INdbo25.companies.code
@namenvarchar(100)INdbo25.companies.name
@default_languagechar(2)INdbo25.companies.default_language
@sort_orderintINdbo25.companies.sort_order

Target table: dbo25.companies

dbo25.usp_import_currency_rates

This procedure imports currency rates.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@base_currency_codenvarchar(50)INdbo25.rates.base_currency_id
@quote_currency_codenvarchar(50)INdbo25.rates.quote_currency_id
@time_codenvarchar(50)INdbo25.rates.time_id
@category_codenvarchar(50)INdbo25.rates.category_id
@currency_ratefloatINdbo25.rates.currency_rate

Target table: dbo25.currency_rates

dbo25.usp_import_dimension_calc_types

This procedure imports calculation types by dimensions.

ParameterDataTypeModeComment
@dimension_idtinyintINdbo25.dimension_calc_types.dimension_id
@calc_type_idtinyintINdbo25.dimension_calc_types.calc_type_id
@is_activebitINdbo25.dimension_calc_types.is_active

Target table: dbo25.dimension_calc_types

dbo25.usp_import_dimension_members

This procedure imports dimension members.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@dimension_idtinyintINdbo25.dimension_properties.id
@root_member_codenvarchar(50)INdbo25.members.code used to calculate dbo25.dimension_properties.root_member_id
@default_member_codenvarchar(50)INdbo25.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.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@idtinyintINdbo25.dimension_properties.id
@codenvarchar(50)INdbo25.dimension_properties.code
@namenvarchar(100)INdbo25.dimension_properties.name
@parameter_namenvarchar(50)INdbo25.dimension_properties.parameter_name
@sort_ordertinyintINdbo25.dimension_properties.sort_order
@join_ordertinyintINdbo25.dimension_properties.join_order
@name_format_idtinyintINdbo25.dimension_properties.name_format_id
@is_protectedbitINdbo25.dimension_properties.is_protected
@default_select_permissionbitINdbo25.dimension_properties.default_select_permission
@default_update_permissionbitINdbo25.dimension_properties.default_update_permission
@is_activebitINdbo25.dimension_properties.is_active
@external_idintINdbo25.dimension_properties.external_id
@external_codenvarchar(50)INdbo25.dimension_properties.external_code

Target table: dbo25.dimensions

Call this procedure after importing dimension members.

dbo25.usp_import_dimensions

This procedure imports dimensions.

ParameterDataTypeModeComment
@idtinyintINdbo25.dimensions.id
@codenvarchar(50)INdbo25.dimensions.code
@namenvarchar(100)INdbo25.dimensions.name
@parameter_namenvarchar(50)INdbo25.dimensions.parameter_name
@sort_ordertinyintINdbo25.dimensions.sort_order
@join_ordertinyintINdbo25.dimensions.join_order
@name_format_idtinyintINdbo25.dimensions.name_format_id
@is_protectedbitINdbo25.dimensions.is_protected
@default_select_permissionbitINdbo25.dimensions.default_select_permission
@default_update_permissionbitINdbo25.dimensions.default_update_permission
@is_activebitINdbo25.dimensions.is_active

Target table: dbo25.dimensions

dbo25.usp_import_facts

This procedure imports source numbers.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@valuefloatINdbo25.facts.source_value, dbo25.facts.value
@code1nvarchar(50)INdbo25.facts.id1
@code2nvarchar(50)INdbo25.facts.id2
@code3nvarchar(50)INdbo25.facts.id3
@code4nvarchar(50)INdbo25.facts.id4
@code5nvarchar(50)INdbo25.facts.id5
@code6nvarchar(50)INdbo25.facts.id6
@code7nvarchar(50)INdbo25.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.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.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.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@form_codenvarchar(50)INdbo25.form_dimensions.id
@dimension_idtinyintINdbo25.form_dimensions.dimension_id
@axis_type_idtinyintINdbo25.form_dimensions.axis_type_id
@parameter_indextinyintINdbo25.form_dimensions.parameter_index
@header_ordertinyintINdbo25.form_dimensions.header_order
@root_member_codenvarchar(50)INdbo25.form_dimensions.root_member_id
@parameter_start_leveltinyintINdbo25.form_dimensions.parameter_start_level
@parameter_end_leveltinyintINdbo25.form_dimensions.parameter_end_level
@form_start_leveltinyintINdbo25.form_dimensions.form_start_level
@form_end_leveltinyintINdbo25.form_dimensions.form_end_level

Target table: dbo25.form_dimensions

dbo25.usp_import_form_permissions

This procedure imports form permissions.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@form_codenvarchar(50)INdbo25.form_permissions.form_id
@usernamenvarchar(128)INdbo25.form_permissions.username
@select_permissiontinyintINdbo25.form_permissions.select_permission

Target table: dbo25.form_permissions

dbo25.usp_import_form_rows

This procedure imports custom form rowsets.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@rowset_codenvarchar(50)INdbo25.form_rows.rowset_id
@sort_orderintINdbo25.form_rows.sort_order
@member_codenvarchar(50)INdbo25.form_rows.member_id
@codenvarchar(50)INdbo25.form_rows.code
@namenvarchar(400)INdbo25.form_rows.name
@decimal_placestinyintINdbo25.form_rows.decimal_places
@is_percenttinyintINdbo25.form_rows.is_percent
@row_colortinyintINdbo25.form_rows.row_color
@row_boldtinyintINdbo25.form_rows.row_bold
@row_indenttinyintINdbo25.form_rows.row_indent

Target table: dbo25.form_rows

dbo25.usp_import_form_subtotals

This procedure imports form subtotal settings.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@form_codenvarchar(50)INdbo25.form_subtotals.form_id
@showbitINdbo25.form_subtotals.show
@dimension_id1tinyintINdbo25.form_subtotals.dimension_id1
@dimension_id2tinyintINdbo25.form_subtotals.dimension_id2
@dimension_id3tinyintINdbo25.form_subtotals.dimension_id3
@member_code1nvarchar(50)INdbo25.form_subtotals.member_id1
@member_code2nvarchar(50)INdbo25.form_subtotals.member_id2
@member_code3nvarchar(50)INdbo25.form_subtotals.member_id3

Target table: dbo25.form_subtotals

dbo25.usp_import_formats

This procedure imports Excel table formats.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@TABLE_SCHEMAnvarchar(128)INdbo25.formats.TABLE_SCHEMA
@TABLE_NAMEnvarchar(128)INdbo25.formats.TABLE_NAME
@TABLE_EXCEL_FORMAT_XMLxmlINdbo25.formats.TABLE_EXCEL_FORMAT_XML

Target table: dbo25.formats

dbo25.usp_import_forms

This procedure imports forms.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@codenvarchar(50)INdbo25.forms.code
@namenvarchar(100)INdbo25.forms.name
@sort_orderintINdbo25.forms.sort_order
@is_activebitINdbo25.forms.is_active

Target table: dbo25.forms

dbo25.usp_import_member_parents

This procedure imports member parents.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@member_codenvarchar(50)INdbo25.parents.member_id
@parent_codenvarchar(50)INdbo25.parents.parent_id
@factorfloatINdbo25.parents.factor

Target table: dbo25.parents

dbo25.usp_import_member_permissions

This procedure imports member permissions.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@member_codenvarchar(50)INdbo25.member_permissions.member_id
@usernamenvarchar(128)INdbo25.member_permissions.username
@select_permissiontinyintINdbo25.member_permissions.select_permission
@update_permissiontinyintINdbo25.member_permissions.update_permission

Target table: dbo25.member_permissions

dbo25.usp_import_member_properties

This procedure imports member properties.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@member_codenvarchar(50)INdbo25.members.id
@previous_period_codenvarchar(50)INdbo25.members.previous_period_id
@same_period_codenvarchar(50)INdbo25.members.same_period_id
@tax_rate_codenvarchar(50)INdbo25.members.tax_rate_id
@unit_codenvarchar(50)INdbo25.members.unit_id

Target table: dbo25.members

dbo25.usp_import_member_relations

This procedure imports member relations.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@member_codenvarchar(50)INdbo25.member_relations.member_id
@partner_codenvarchar(50)INdbo25.member_relations.partner_id
@select_permissiontinyintINdbo25.member_relations.select_permission
@update_permissiontinyintINdbo25.member_relations.update_permission

Target table: dbo25.member_relations

dbo25.usp_import_members

This procedure imports dimension members.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@dimension_idtinyintINdbo25.members.dimension_id
@sort_orderintINdbo25.members.sort_order
@codenvarchar(50)INdbo25.members.code
@namenvarchar(400)INdbo25.members.name
@calc_type_idtinyintINdbo25.members.calc_type_id
@decimal_placestinyintINdbo25.members.decimal_places
@is_percentbitINdbo25.members.is_percent
@row_colortinyintINdbo25.members.row_color
@row_boldtinyintINdbo25.members.row_bold
@row_indenttinyintINdbo25.members.row_indent
@show_linebitINdbo25.members.show_line
@show_line_beforebitINdbo25.members.show_line_before
@show_line_afterbitINdbo25.members.show_line_after
@is_translatablebitINdbo25.members.is_translatable
@is_activebitINdbo25.members.is_active
@external_idintINdbo25.members.external_id
@external_codenvarchar(50)INdbo25.members.external_code
@excel_formulanvarchar(400)INdbo25.members.excel_formula

Target table: dbo25.members

dbo25.usp_import_strings

This procedure imports source strings.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@valuenvarchar(4000)INdbo25.strings.value
@code1nvarchar(50)INdbo25.strings.id1
@code2nvarchar(50)INdbo25.strings.id2
@code3nvarchar(50)INdbo25.strings.id3
@code4nvarchar(50)INdbo25.strings.id4
@code5nvarchar(50)INdbo25.strings.id5
@code6nvarchar(50)INdbo25.strings.id6
@code7nvarchar(50)INdbo25.strings.id7

Target table: dbo25.strings

dbo25.usp_import_tax_rates

This procedure imports tax rates.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@codenvarchar(50)INdbo25.tax_rates.code
@namenvarchar(100)INdbo25.tax_rates.name
@sort_ordertinyintINdbo25.tax_rates.sort_order
@is_translatablebitINdbo25.tax_rates.is_translatable
@is_activebitINdbo25.tax_rates.is_active

Target table: dbo25.tax_rates

dbo25.usp_import_translations

This procedure imports company-related translations.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@tablenvarchar(50)INdbo25.translated_tables.code
@membernvarchar(50)INThe member code used to find dbo25.translations.member_id
@languagechar(2)INdbo25.translations.language
@namenvarchar(400)INdbo25.translations.name

Target table: dbo25.translations

dbo25.usp_import_units

This procedure imports units.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@codenvarchar(50)INdbo25.units.code
@namenvarchar(100)INdbo25.units.name
@sort_orderintINdbo25.units.sort_order
@factorfloatINdbo25.units.factor
@is_currencybitINdbo25.units.is_currency
@is_functional_currencybitINdbo25.units.is_functional_currency
@is_translatablebitINdbo25.units.is_translatable
@is_activebitINdbo25.units.is_active

Target table: dbo25.units

dbo25.usp_import_users

This procedure imports users.

ParameterDataTypeModeComment
@companynvarchar(50)INdbo25.companies.code
@usernamenvarchar(128)INdbo25.users.username
@namenvarchar(100)INdbo25.users.name
@is_adminbitINdbo25.users.is_admin
@is_defaultbitINdbo25.users.is_default
@is_activebitINdbo25.users.is_active

Target table: dbo25.users

dbo25.xl_actions_create_standard_forms

This procedure creates a set of standard forms.

ParameterDataTypeModeComment
@company_idintINdbo25.companies.id
@data_languagechar(2)INContext data language

Use it to initialize settings for a new company.

dbo25.xl_actions_create_standard_members

This procedure creates standard dimension members.

ParameterDataTypeModeComment
@company_idintINdbo25.companies.id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.companies.id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.companies.id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@data_languagechar(2)INContext data language

Underlying table: dbo25.axis_types

xls25.usp_calc_types

This procedure is an Excel form for editing calculation types.

ParameterDataTypeModeComment
@data_languagechar(2)INContext data language

Underlying table: dbo25.calc_types

xls25.usp_closed_periods

This procedure is an Excel form for editing closed periods.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.member_relations

Editing data requires the SaveToDB Enterprise edition.

Example:

Planning Application - Closed Periods

xls25.usp_closed_periods_change

This procedure updates a database on cell changes of xls25.usp_closed_periods.

ParameterDataTypeModeComment
@column_namenvarchar(128)INdbo25.member_relations.category_id
@cell_number_valueintINdbo25.member_relations.update_permission
@idintINdbo25.member_relations.member_id
@data_languagechar(2)INContext data language

xls25.usp_companies

This procedure is a form of editing companies.

ParameterDataTypeModeComment
@data_languagechar(2)INContext data language

Source table: dbo25.companies

xls25.usp_companies_delete

This procedure deletes rows of xls25.usp_companies.

ParameterDataTypeModeComment
@idintINdbo25.companies.id

xls25.usp_companies_insert

This procedure inserts rows of xls25.usp_companies.

ParameterDataTypeModeComment
@codenvarchar(50)INdbo25.companies.code
@namenvarchar(100)INdbo25.companies.name
@translated_namenvarchar(100)INdbo25.translations.name
@default_languagechar(2)INdbo25.companies.default_language
@sort_orderintINdbo25.companies.sort_order
@data_languagechar(2)INContext data language

xls25.usp_companies_update

This procedure updates rows of xls25.usp_companies.

ParameterDataTypeModeComment
@idintINdbo25.companies.id
@codenvarchar(50)INdbo25.companies.code
@namenvarchar(100)INdbo25.companies.name
@translated_namenvarchar(100)INdbo25.translations.name
@default_languagechar(2)INdbo25.companies.default_language
@sort_orderintINdbo25.companies.sort_order
@data_languagechar(2)INContext data language

xls25.usp_currency_rates

This procedure is an Excel form for editing currency rates.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@base_currency_idtinyintINdbo25.units.id
@quote_currency_idtinyintINdbo25.units.id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@column_namenvarchar(128)INdbo25.rates.category_id
@cell_number_valuefloatINdbo25.rates.rate
@idintINdbo25.rates.time_id
@base_currency_idtinyintINdbo25.rates.base_currency_id
@quote_currency_idtinyintINdbo25.rates.quote_currency_id
@data_languagechar(2)INContext data language

xls25.usp_data_management

This procedure is an Excel form for data management.

ParameterDataTypeModeComment
@company_idintINdbo25.companies.id
@data_languagechar(2)INContext 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:

Planning Application - Data Management

xls25.usp_dimensions

This procedure is an Excel form for editing dimensions.

ParameterDataTypeModeComment
@company_idintINdbo25.dimension_properties.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.dimensions

Example:

Planning Application -Dimensions

xls25.usp_dimensions_change

This procedure checks user input on cell changes of xls25.usp_dimensions.

ParameterDataTypeModeComment
@column_namenvarchar(255)INExcel cell column name
@cell_valuenvarchar(255)INExcel cell object value
@cell_number_valuefloatINExcel cell number value
@cell_addressnvarchar(255)INExcel cell address
@company_idintINdbo25.dimension_properties.company_id
@idintINdbo25.dimension_properties.id
@root_member_idintINdbo25.dimension_properties.root_member_id
@default_member_idintINdbo25.dimension_properties.default_member_id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@idtinyintINdbo25.dimension_properties.id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.dimension_properties.company_id
@idtinyintINdbo25.dimension_properties.id
@codenvarchar(50)INdbo25.dimension_properties.code
@namenvarchar(100)INdbo25.dimension_properties.name
@translated_namenvarchar(100)INdbo25.translations.name
@parameter_namenvarchar(50)INdbo25.dimension_properties.parameter_name
@translated_parameter_namenvarchar(50)INdbo25.translations.name
@sort_ordertinyintINdbo25.dimension_properties.sort_order
@name_format_idtinyintINdbo25.dimension_properties.name_format_id
@root_member_idintINdbo25.dimension_properties.root_member_id
@default_member_idintINdbo25.dimension_properties.default_member_id
@is_protectedtinyintINdbo25.dimension_properties.is_protected
@default_select_permissiontinyintINdbo25.dimension_properties.default_select_permission
@default_update_permissiontinyintINdbo25.dimension_properties.default_update_permission
@is_activetinyintINdbo25.dimension_properties.is_active
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.dimension_properties.company_id
@idtinyintINdbo25.dimension_properties.id
@codenvarchar(50)INdbo25.dimension_properties.code
@namenvarchar(100)INdbo25.dimension_properties.name
@translated_namenvarchar(100)INdbo25.translations.name
@parameter_namenvarchar(50)INdbo25.dimension_properties.parameter_name
@translated_parameter_namenvarchar(50)INdbo25.translations.name
@sort_ordertinyintINdbo25.dimension_properties.sort_order
@name_format_idtinyintINdbo25.dimension_properties.name_format_id
@root_member_idintINdbo25.dimension_properties.root_member_id
@default_member_idintINdbo25.dimension_properties.default_member_id
@is_protectedtinyintINdbo25.dimension_properties.is_protected
@default_select_permissiontinyintINdbo25.dimension_properties.default_select_permission
@default_update_permissiontinyintINdbo25.dimension_properties.default_update_permission
@is_activetinyintINdbo25.dimension_properties.is_active
@data_languagechar(2)INContext data language

xls25.usp_facts

This procedure selects the calculated facts.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@id1intINdbo25.members.id
@id2intINdbo25.members.id
@id3intINdbo25.members.id
@id4intINdbo25.members.id
@id5intINdbo25.members.id
@id6intINdbo25.members.id
@id7intINdbo25.members.id
@unit_idintINdbo25.members.unit_id
@calc_type_idintINdbo25.members.calc_type_id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@id1intINdbo25.members.id
@id2intINdbo25.members.id
@id3intINdbo25.members.id
@id4intINdbo25.members.id
@id5intINdbo25.members.id
@id6intINdbo25.members.id
@id7intINdbo25.members.id
@unit_idintINdbo25.members.unit_id
@calc_type_idintINdbo25.members.calc_type_id
@data_languagechar(2)INContext data language

Use this procedure to check and edit source cube values directly.

xls25.usp_facts_strings

This procedure selects source cube strings.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@id1intINdbo25.members.id
@id2intINdbo25.members.id
@id3intINdbo25.members.id
@id4intINdbo25.members.id
@id5intINdbo25.members.id
@id6intINdbo25.members.id
@id7intINdbo25.members.id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.forms.company_id
@data_languagechar(2)INContext data language

The form selects dbo25.forms cross dbo25.dimensions.

Underlying tables: dbo25.forms, dbo25.dimensions, dbo25.form_dimensions

Example:

Planning Application - Form Dimensions

xls25.usp_form_dimensions_delete

This procedure deletes rows of xls25.usp_form_dimensions.

ParameterDataTypeModeComment
@form_idintINdbo25.form_dimensions.form_id
@dimension_idtinyintINdbo25.form_dimensions.dimension_id

xls25.usp_form_dimensions_insert

This procedure inserts rows of xls25.usp_form_dimensions.

ParameterDataTypeModeComment
@form_idintINdbo25.form_dimensions.form_id
@dimension_idtinyintINdbo25.form_dimensions.dimension_id
@axis_type_idtinyintINdbo25.form_dimensions.axis_type_id
@parameter_indextinyintINdbo25.form_dimensions.parameter_index
@header_ordertinyintINdbo25.form_dimensions.header_order
@root_member_idintINdbo25.form_dimensions.root_member_id
@parameter_start_leveltinyintINdbo25.form_dimensions.parameter_start_level
@parameter_end_leveltinyintINdbo25.form_dimensions.parameter_end_level
@form_start_leveltinyintINdbo25.form_dimensions.form_start_level
@form_end_leveltinyintINdbo25.form_dimensions.form_end_level

xls25.usp_form_dimensions_update

This procedure updates rows of xls25.usp_form_dimensions.

ParameterDataTypeModeComment
@form_idintINdbo25.form_dimensions.form_id
@dimension_idtinyintINdbo25.form_dimensions.dimension_id
@axis_type_idtinyintINdbo25.form_dimensions.axis_type_id
@parameter_indextinyintINdbo25.form_dimensions.parameter_index
@header_ordertinyintINdbo25.form_dimensions.header_order
@root_member_idintINdbo25.form_dimensions.root_member_id
@parameter_start_leveltinyintINdbo25.form_dimensions.parameter_start_level
@parameter_end_leveltinyintINdbo25.form_dimensions.parameter_end_level
@form_start_leveltinyintINdbo25.form_dimensions.form_start_level
@form_end_leveltinyintINdbo25.form_dimensions.form_end_level

xls25.usp_form_permissions

This procedure is an Excel form for editing form permissions.

ParameterDataTypeModeComment
@company_idintINdbo25.forms.company_id

Underlying table: dbo25.form_permisssions

Editing data requires the SaveToDB Enterprise edition.

Example:

Planning Application - Form Permissions

xls25.usp_form_permissions_change

This procedure updates a database on cell changes of xls25.usp_form_permissions.

ParameterDataTypeModeComment
@column_namenvarchar(128)INdbo25.member_permissions.username
@cell_number_valueintIN1 - select_permission = 1
0 - select_permission = 0
@idintINdbo25.member_permissions.member_id
@data_languagechar(2)INContext data language

xls25.usp_form_rows

This procedure is an Excel form for editing form rowsets.

ParameterDataTypeModeComment
@company_idintINdbo25.forms.company_id
@rowset_idintINdbo25.form_rows.rowset_id
@data_languagechar(2)INContext 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:

Planning Application - Form Rows

xls25.usp_form_rows_delete

This procedure deletes rows of xls25.usp_form_rows.

ParameterDataTypeModeComment
@idintINdbo25.form_rows.id

xls25.usp_form_rows_insert

This procedure inserts rows of xls25.usp_form_rows.

ParameterDataTypeModeComment
@rowset_idintINdbo25.form_rows.rowset_id
@rownumintINdbo25.form_rows.sort_order
@rownum is a predefined SaveToDB add-in parameter
@member_idintINdbo25.form_rows.member_id
@codenvarchar(50)INdbo25.form_rows.code
@namenvarchar(400)INdbo25.form_rows.name
@translated_namenvarchar(400)INdbo25.translations.name
@decimal_placestinyintINdbo25.form_rows.decimal_places
@is_percenttinyintINdbo25.form_rows.is_percent
@row_colortinyintINdbo25.form_rows.row_color
@row_boldtinyintINdbo25.form_rows.row_bold
@row_indenttinyintINdbo25.form_rows.row_indent
@data_languagechar(2)INContext data language

xls25.usp_form_rows_update

This procedure updates rows of xls25.usp_form_rows.

ParameterDataTypeModeComment
@idintINdbo25.form_rows.id
@rowset_idintINdbo25.form_rows.rowset_id
@rownumintINdbo25.form_rows.sort_order
@rownum is a predefined SaveToDB add-in parameter
@member_idintINdbo25.form_rows.member_id
@codenvarchar(50)INdbo25.form_rows.code
@namenvarchar(400)INdbo25.form_rows.name
@translated_namenvarchar(400)INdbo25.translations.name
@decimal_placestinyintINdbo25.form_rows.decimal_places
@is_percenttinyintINdbo25.form_rows.is_percent
@row_colortinyintINdbo25.form_rows.row_color
@row_boldtinyintINdbo25.form_rows.row_bold
@row_indenttinyintINdbo25.form_rows.row_indent
@data_languagechar(2)INContext data language

xls25.usp_forms

This procedure is an Excel form for editing a list of forms.

ParameterDataTypeModeComment
@company_idintINdbo25.forms.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.forms

Example:

Planning Application - Forms

xls25.usp_forms_delete

This procedure deletes rows of xls25.usp_forms.

ParameterDataTypeModeComment
@idintINdbo25.forms.id

xls25.usp_forms_insert

This procedure inserts rows of xls25.usp_forms.

ParameterDataTypeModeComment
@company_idintINdbo25.forms.company_id
@codenvarchar(50)INdbo25.forms.code
@namenvarchar(100)INdbo25.forms.name
@translated_namenvarchar(100)INdbo25.translations.name
@sort_orderintINdbo25.forms.sort_order
@is_activetinyintINdbo25.forms.is_active
@data_languagechar(2)INContext data language

xls25.usp_forms_update

This procedure updates rows of xls25.usp_forms.

ParameterDataTypeModeComment
@idintINdbo25.forms.id
@codenvarchar(50)INdbo25.forms.code
@namenvarchar(100)INdbo25.forms.name
@translated_namenvarchar(100)INdbo25.translations.name
@sort_orderintINdbo25.forms.sort_order
@is_activetinyintINdbo25.forms.is_active
@data_languagechar(2)INContext data language

xls25.usp_member_permissions

This procedure is an Excel form for editing member permissions.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@dimension_idtinyintINDimension filter
@root_idintINRoot member filter
@usernamenvarchar(128)INUsername filter
@data_languagechar(2)INContext data language

Underlying table: dbo25.member_permissions

Editing data requires the SaveToDB Enterprise edition.

Example:

Planning Application - Member Permissions

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.

ParameterDataTypeModeComment
@column_namenvarchar(128)INdbo25.member_permissions.username
@cell_valuenvarchar(255)IND - deny (select_permission = 0, update_permission = 0)
R - read (select_permission = 1, update_permission = 0)
W - write (select_permission = 1, update_permission = 1)
@idintINdbo25.member_permissions.member_id
@data_languagechar(2)INContext data language

xls25.usp_member_relations

This procedure is an Excel form for editing member relations.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@dimension_idintINDimension filter
@root_idintINRoot member filter
@partner_idintINPartner dimension filter
@fieldnvarchar(50)INupdate_permission, fixed value
@data_languagechar(2)INContext data language

Underlying table: dbo25.member_relations

Editing data requires the SaveToDB Enterprise edition.

The example below shows the relations between accounts and regions:

Planning Application - Member Relations

xls25.usp_member_relations_change

This procedure updates a database on cell changes of xls25.usp_member_relations.

ParameterDataTypeModeComment
@column_namenvarchar(128)INdbo25.member_relations.partner_id
@cell_number_valueintINdbo25.member_relations.update_permission

1 - update_permission = 1
0 - update_permission = 0
@idintINdbo25.member_relations.member_id
@fieldnvarchar(50)INupdate_permission, fixed value
@data_languagechar(2)INContext data language

xls25.usp_members

This procedure is an Excel form for editing dimension members.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@dimension_idtinyintINDimension filter
@root_idintINRoot member filter
@data_languagechar(2)INContext 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:

Planning Application - Dimension Members

xls25.usp_members_delete

This procedure deletes rows of xls25.usp_members.

ParameterDataTypeModeComment
@idintINdbo25.members.id

xls25.usp_members_insert

This procedure inserts rows of xls25.usp_members.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@dimension_idtinyintINdbo25.members.dimension_id
@codenvarchar(50)INdbo25.members.code
@namenvarchar(400)INdbo25.members.name
@translated_namenvarchar(400)INdbo25.translations.name
@commentnvarchar(1000)INdbo25.members.comment
@sort_orderintINdbo25.members.sort_order
@tax_rate_idtinyintINdbo25.members.tax_rate_id
@unit_idtinyintINdbo25.members.unit_id
@calc_type_idtinyintINdbo25.members.calc_type_id
@previous_period_idintINdbo25.members.previous_period_id
@same_period_idintINdbo25.members.same_period_id
@decimal_placestinyintINdbo25.members.decimal_places
@is_percenttinyintINdbo25.members.is_percent
@row_colortinyintINdbo25.members.row_color
@row_boldtinyintINdbo25.members.row_bold
@row_indenttinyintINdbo25.members.row_indent
@show_linetinyintINdbo25.members.show_line
@show_line_beforetinyintINdbo25.members.show_line_before
@show_line_aftertinyintINdbo25.members.show_line_after
@is_activetinyintINdbo25.members.is_active
@excel_formulanvarchar(400)INdbo25.members.excel_formula
@parent1intINdbo25.parents.parent_id
@parent2intINdbo25.parents.parent_id
@parent3intINdbo25.parents.parent_id
@parent4intINdbo25.parents.parent_id
@parent5intINdbo25.parents.parent_id
@parent6intINdbo25.parents.parent_id
@parent7intINdbo25.parents.parent_id
@factor1floatINdbo25.parents.factor
@factor2floatINdbo25.parents.factor
@factor3floatINdbo25.parents.factor
@factor4floatINdbo25.parents.factor
@factor5floatINdbo25.parents.factor
@factor6floatINdbo25.parents.factor
@factor7floatINdbo25.parents.factor
@data_languagechar(2)INContext data language

xls25.usp_members_update

This procedure updates rows of xls25.usp_members.

ParameterDataTypeModeComment
@idintINdbo25.members.id, dbo25.parents.member_id
@codenvarchar(50)INdbo25.members.code
@namenvarchar(400)INdbo25.members.name
@translated_namenvarchar(400)INdbo25.translations.name
@commentnvarchar(1000)INdbo25.members.comment
@sort_orderintINdbo25.members.sort_order
@tax_rate_idtinyintINdbo25.members.tax_rate_id
@unit_idtinyintINdbo25.members.unit_id
@calc_type_idtinyintINdbo25.members.calc_type_id
@previous_period_idintINdbo25.members.previous_period_id
@same_period_idintINdbo25.members.same_period_id
@decimal_placestinyintINdbo25.members.decimal_places
@is_percenttinyintINdbo25.members.is_percent
@row_colortinyintINdbo25.members.row_color
@row_boldtinyintINdbo25.members.row_bold
@row_indenttinyintINdbo25.members.row_indent
@show_linetinyintINdbo25.members.show_line
@show_line_beforetinyintINdbo25.members.show_line_before
@show_line_aftertinyintINdbo25.members.show_line_after
@is_activetinyintINdbo25.members.is_active
@excel_formulanvarchar(400)INdbo25.members.excel_formula
@parent1intINdbo25.parents.parent_id
@parent2intINdbo25.parents.parent_id
@parent3intINdbo25.parents.parent_id
@parent4intINdbo25.parents.parent_id
@parent5intINdbo25.parents.parent_id
@parent6intINdbo25.parents.parent_id
@parent7intINdbo25.parents.parent_id
@factor1floatINdbo25.parents.factor
@factor2floatINdbo25.parents.factor
@factor3floatINdbo25.parents.factor
@factor4floatINdbo25.parents.factor
@factor5floatINdbo25.parents.factor
@factor6floatINdbo25.parents.factor
@factor7floatINdbo25.parents.factor
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@column_namenvarchar(128)INusername
@cell_number_valueintIN1 - include the user into a role
0 - exclude the user from the role
@namenvarchar(128)INrole
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@dimension_idtinyintINDimension filter
@data_languagechar(2)INContext 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:

Planning Application - Rowsets

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.

ParameterDataTypeModeComment
@idintINdbo25.members.id

xls25.usp_rowsets_insert

This procedure inserts rows of xls25.usp_rowsets.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@dimension_idtinyintINdbo25.members.dimension_id
@codenvarchar(50)INdbo25.members.code
@namenvarchar(100)INdbo25.members.name
@translated_namenvarchar(100)INdbo25.translations.name
@sort_orderintINdbo25.members.sort_order
@data_languagechar(2)INContext data language

xls25.usp_rowsets_update

This procedure updates rows of xls25.usp_rowsets.

ParameterDataTypeModeComment
@idintINdbo25.members.id
@codenvarchar(50)INdbo25.members.code
@namenvarchar(100)INdbo25.members.name
@translated_namenvarchar(100)INdbo25.translations.name
@sort_orderintINdbo25.members.sort_order
@data_languagechar(2)INContext data language

xls25.usp_run_form

This procedure executes forms configured using dbo25.forms and dbo25.form_dimensions.

ParameterDataTypeModeComment
@company_idintINdbo25.forms.company_id
@form_idintINdbo25.forms.id
@form_p1intINdbo25.members.id of the 1st ribbon parameter
@form_p2intINdbo25.members.id of the 2nd ribbon parameter
@form_p3intINdbo25.members.id of the 3rd ribbon parameter
@form_p4intINdbo25.members.id of the 4th ribbon parameter
@form_p5intINdbo25.members.id of the 5th ribbon parameter
@form_p6intINdbo25.members.id of the 6th ribbon parameter
@form_p7intINdbo25.members.id of the 7th ribbon parameter
@data_languagechar(2)INContext 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:

Planning Application - Budget Form

xls25.usp_run_form_change

This procedure updates a database on cell changes of xls25.usp_run_form.

ParameterDataTypeModeComment
@column_namenvarchar(255)INExcel cell column name.
Data column names contain dimension member codes separated by spaces.
@table_namenvarchar(255)INActive form database object name
@cell_valuenvarchar(255)INExcel cell object value
@cell_number_valuefloatINExcel cell number value
@cell_addressnvarchar(255)INExcel cell address
@changed_cell_countintINTotal number of changed cells
@changed_cell_indexintINCell index in the changed cells, starting 1.
The last cell has the index equal to @changed_cell_count.
@idintINdbo25.form_rows.id
@member_idintINdbo25.members.id of the 1st row dimension
@member_id2intINdbo25.members.id of the 2nd row dimension
@member_id3intINdbo25.members.id of the 3rd row dimension
@form_idintINdbo25.forms.id
@form_p1intINdbo25.members.id of the 1st ribbon parameter
@form_p2intINdbo25.members.id of the 2nd ribbon parameter
@form_p3intINdbo25.members.id of the 3rd ribbon parameter
@form_p4intINdbo25.members.id of the 4th ribbon parameter
@form_p5intINdbo25.members.id of the 5th ribbon parameter
@form_p6intINdbo25.members.id of the 6th ribbon parameter
@form_p7intINdbo25.members.id of the 7th ribbon parameter
@quiet_modetinyintIN0 - raise exceptions on errors
1 - return on errors without exceptions
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.forms.company_id
@requestnvarchar(max)INForm 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.

ParameterDataTypeModeComment
@company_idintINdbo25.forms.company_id
@form_idintINdbo25.forms.id
@form_p1intINdbo25.members.id of the 1st ribbon parameter
@form_p2intINdbo25.members.id of the 2nd ribbon parameter
@form_p3intINdbo25.members.id of the 3rd ribbon parameter
@form_p4intINdbo25.members.id of the 4th ribbon parameter
@form_p5intINdbo25.members.id of the 5th ribbon parameter
@form_p6intINdbo25.members.id of the 6th ribbon parameter
@form_p7intINdbo25.members.id of the 7th ribbon parameter
@data_languagechar(2)INContext 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:

Planning Application - Offline Budget Form

xls25.usp_run_offline_form_delete

This procedure deletes rows of xls25.usp_run_offline_form.

ParameterDataTypeModeComment
@idintINdbo25.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.

ParameterDataTypeModeComment
@idintINdbo25.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.

ParameterDataTypeModeComment
@company_idintINdbo25.companies.id
@table_namenvarchar(255)INActive form database object name
@form_idintINdbo25.forms.id
@form_p1intINdbo25.members.id of the 1st ribbon parameter
@form_p2intINdbo25.members.id of the 2nd ribbon parameter
@form_p3intINdbo25.members.id of the 3rd ribbon parameter
@form_p4intINdbo25.members.id of the 4th ribbon parameter
@form_p5intINdbo25.members.id of the 5th ribbon parameter
@form_p6intINdbo25.members.id of the 6th ribbon parameter
@form_p7intINdbo25.members.id of the 7th ribbon parameter
@member_idintINdbo25.members.id of the 1st row dimension
@member_id2intINdbo25.members.id of the 2nd row dimension
@member_id3intINdbo25.members.id of the 3rd row dimension
@json_columnsnvarchar(max)INAn array of column names in the JSON format
@json_valuesnvarchar(max)INAn array of row values in the JSON format

xls25.usp_tax_rates

This procedure is an Excel form for editing tax rates.

ParameterDataTypeModeComment
@company_idintINdbo25.tax_rates.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.tax_rates

xls25.usp_tax_rates_delete

This procedure deletes rows of xls25.usp_tax_rates.

ParameterDataTypeModeComment
@idintINdbo25.tax_rates.id

xls25.usp_tax_rates_insert

This procedure inserts rows of xls25.usp_tax_rates.

ParameterDataTypeModeComment
@company_idintINdbo25.companies.id
@codenvarchar(50)INdbo25.tax_rates.code
@namenvarchar(100)INdbo25.tax_rates.name
@translated_namenvarchar(100)INdbo25.translations.name
@sort_orderintINdbo25.tax_rates.sort_order
@factorfloatINdbo25.tax_rates.factor
@is_activebitINdbo25.tax_rates.is_active
@data_languagechar(2)INContext data language

xls25.usp_tax_rates_update

This procedure updates rows of xls25.usp_tax_rates.

ParameterDataTypeModeComment
@idintINdbo25.tax_rates.id
@codenvarchar(50)INdbo25.tax_rates.code
@namenvarchar(100)INdbo25.tax_rates.name
@translated_namenvarchar(100)INdbo25.translations.name
@sort_orderintINdbo25.tax_rates.sort_order
@factorfloatINdbo25.tax_rates.factor
@is_activebitINdbo25.tax_rates.is_active
@data_languagechar(2)INContext data language

xls25.usp_translations

This procedure is a form of editing company-related translations.

ParameterDataTypeModeComment
@company_idintINdbo25.translations.company_id
@is_translatablebitIN1 - select translatable elements only
0 - select non-translatable elements
@is_completebitIN1 - 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.

ParameterDataTypeModeComment
@company_idintINdbo25.translations.company_id
@table_idintINdbo25.translations.table_id
@member_idintINdbo25.translations.member_id
@column_namenvarchar(128)INdbo25.translations.language
@cell_valuenvarchar(400)INdbo25.translations.name
@cell_number_valueintINThe value for the is_translatable column in supported tables

xls25.usp_translations_common

This procedure is a form of editing application-level element translations.

ParameterDataTypeModeComment
@is_completebitIN1 - 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.

ParameterDataTypeModeComment
@fieldnvarchar(128)INTRANSLATED_NAME, TRANSLATED_DESC, or TRANSLATED_COMMENT
@schemanvarchar(128)INxls.translations.TABLE_SCHEMA
@is_completebitIN1 - 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.

ParameterDataTypeModeComment
@column_namenvarchar(128)INxls.translations.LANGUAGE_NAME
@cell_valuenvarchar(max)INA value for the specified field
@TABLE_SCHEMAnvarchar(128)INxls.translations.TABLE_SCHEMA
@TABLE_NAMEnvarchar(128)INxls.translations.TABLE_NAME
@COLUMNnvarchar(128)INxls.translations.COLUMN_NAME
@fieldnvarchar(128)INTRANSLATED_NAME, TRANSLATED_DESC, or TRANSLATED_COMMENT
@data_languagechar(2)INxls.translations.LANGUAGE_NAME

xls25.usp_units

This procedure is an Excel form for editing units.

ParameterDataTypeModeComment
@company_idintINdbo25.units.company_id
@data_languagechar(2)INContext data language

Use the Excel context menu to change the system currency (the unit with id 0).

Underlying table: dbo25.units

Example:

Planning Application - Units

xls25.usp_units_delete

This procedure deletes rows of xls25.usp_units.

ParameterDataTypeModeComment
@idintINdbo25.units.id

xls25.usp_units_insert

This procedure inserts rows of xls25.usp_units.

ParameterDataTypeModeComment
@company_idintINdbo25.companies.id
@codenvarchar(50)INdbo25.units.code
@namenvarchar(100)INdbo25.units.name
@translated_namenvarchar(100)INdbo25.translations.name
@sort_orderintINdbo25.units.sort_order
@factorfloatINdbo25.units.factor
@is_currencybitINdbo25.units.is_currency
@is_functional_currencybitINdbo25.units.is_functional_currency
@is_activebitINdbo25.units.is_active
@data_languagechar(2)INContext data language

xls25.usp_units_update

This procedure updates rows of xls25.usp_units.

ParameterDataTypeModeComment
@idintINdbo25.units.id
@codenvarchar(50)INdbo25.units.code
@namenvarchar(100)INdbo25.units.name
@translated_namenvarchar(100)INdbo25.translations.name
@sort_orderintINdbo25.units.sort_order
@factorfloatINdbo25.units.factor
@is_currencybitINdbo25.units.is_currency
@is_functional_currencybitINdbo25.units.is_functional_currency
@is_activebitINdbo25.units.is_active
@data_languagechar(2)INContext data language

xls25.usp_users

This procedure is a form of editing users.

ParameterDataTypeModeComment
@company_idintINdbo25.users.company_id

Source table: dbo25.users

xls25.usp_users_delete

This procedure deletes rows of xls25.usp_users.

ParameterDataTypeModeComment
@company_idintINdbo25.users.company_id
@usernamenvarchar(128)INdbo25.users.username

xls25.usp_users_insert

This procedure inserts rows of xls25.usp_users.

ParameterDataTypeModeComment
@company_idintINdbo25.users.company_id
@usernamenvarchar(128)INdbo25.users.username
@namenvarchar(100)INdbo25.users.name
@is_adminbitINdbo25.users.is_admin
@is_activebitINdbo25.users.is_active
@is_defaultbitINdbo25.users.is_default

xls25.usp_users_update

This procedure updates rows of xls25.usp_users.

ParameterDataTypeModeComment
@company_idintINdbo25.users.company_id
@usernamenvarchar(128)INdbo25.users.username
@namenvarchar(100)INdbo25.users.name
@is_adminbitINdbo25.users.is_admin
@is_activebitINdbo25.users.is_active
@is_defaultbitINdbo25.users.is_default

xls25.xl_actions_add_language

This procedure adds a new language for company-related elements.

ParameterDataTypeModeComment
@company_idintINdbo25.companies.id
@languagechar(2)INdbo25.translations.language

Users may run this procedure from the Actions menu.

xls25.xl_actions_add_quarters

This procedure adds quarter members.

ParameterDataTypeModeComment
@company_idintINdbo25.companies.id
@yearintINYear
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.companies.id
@yearintINYear
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.companies.id
@codenvarchar(50)INTime dbo25.members.id
@source_category_codenvarchar(50)INSource category dbo25.members.id
@target_category_codenvarchar(50)INTarget category dbo25.members.id
@set_1_to_copytinyintIN1 - to confirm copying data
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.companies.id
@codenvarchar(50)INTime dbo25.members.id
@category_codenvarchar(50)INCategory dbo25.members.id
@set_1_to_deletetinyintIN1 - to confirm deleting data
@data_languagechar(2)INContext data language

Target tables: dbo25.facts, dbo25.strings

xls25.xl_actions_delete_year

This procedure deletes year members.

ParameterDataTypeModeComment
@company_idintINdbo25.companies.id
@yearintINYear
@set_1_to_deletetinyintIN1 - to confirm deleting data
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@column_namenvarchar(255)INExcel cell column name.
Data column names contain dimension member codes separated by spaces.
@table_namenvarchar(255)INActive form database object name
@member_idintINdbo25.members.id of the 1st row dimension
@member_id2intINdbo25.members.id of the 2nd row dimension
@member_id3intINdbo25.members.id of the 3rd row dimension
@form_idintINdbo25.forms.id
@form_p1intINdbo25.members.id of the 1st ribbon parameter
@form_p2intINdbo25.members.id of the 2nd ribbon parameter
@form_p3intINdbo25.members.id of the 3rd ribbon parameter
@form_p4intINdbo25.members.id of the 4th ribbon parameter
@form_p5intINdbo25.members.id of the 5th ribbon parameter
@form_p6intINdbo25.members.id of the 6th ribbon parameter
@form_p7intINdbo25.members.id of the 7th ribbon parameter
@data_languagechar(2)INContext data language

This procedure is used in the Excel context menu to drill-down cell values.

Underlying table: dbo25.facts

Output example:

Planning Application - Cell Drill-Down

xls25.xl_actions_set_functional_currency

This procedure changes the system currency of the application.

ParameterDataTypeModeComment
@idintINdbo25.units.id
@data_languagechar(2)INContext data language

Target table: dbo25.units

xls25.xl_actions_update_facts

This procedure updates cube values after the currency rate changes.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id

Target table: dbo25.facts

xls25.xl_actions_update_hierarchies

This procedure updates the required tables after member changes.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id

Target tables: dbo25.hierarchies, dbo25.factors

xls25.xl_actions_update_member_permissions

This procedure updates member permissions after member changes.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id

Target table: dbo25.member_permissions

xls25.xl_aliases_members

This procedure configures column sets of xls25.usp_members procedure.

ParameterDataTypeModeComment
@dimension_idtinyintINdbo25.members.dimension_id
@data_languagevarchar(2)INContext 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.

ParameterDataTypeModeComment
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@data_languagechar(2)INContext data language

Underlying table: dbo25.calc_types

xls25.xl_parameter_values_company_id

This procedure selects companies for Excel ribbon parameters.

ParameterDataTypeModeComment
@data_languagechar(2)INContext data language

Underlying table: dbo25.companies

xls25.xl_parameter_values_currency_id

This procedure selects currencies for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.units.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.units

xls25.xl_parameter_values_dimension_id

This procedure selects dimensions for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.dimension_properties.company_id

Underlying table: dbo25.dimensions

xls25.xl_parameter_values_dimension_id_or_null

This procedure selects dimensions for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.dimension_properties.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.dimensions

xls25.xl_parameter_values_form_id

This procedure selects forms for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.forms.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.forms

xls25.xl_parameter_values_form_id_or_null

This procedure selects forms for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.forms.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.forms

xls25.xl_parameter_values_member_id_by_dimension_id

This procedure selects members for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@dimension_idtinyintINdbo25.members.dimension_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.members

xls25.xl_parameter_values_member_id_dim1

This procedure selects 1st dimension members for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.members

xls25.xl_parameter_values_member_id_dim2

This procedure selects 2nd dimension members for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.members

xls25.xl_parameter_values_member_id_dim3

This procedure selects 3rd dimension members for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.members

xls25.xl_parameter_values_member_id_dim4

This procedure selects 4th dimension members for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.members

xls25.xl_parameter_values_member_id_dim5

This procedure selects 5th dimension members for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.members

xls25.xl_parameter_values_member_id_dim6

This procedure selects 6th dimension members for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.members

xls25.xl_parameter_values_member_id_dim7

This procedure selects 7th dimension members for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.members

xls25.xl_parameter_values_relation_dimension_id

This procedure selects dimensions for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.dimension_properties.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.dimensions

xls25.xl_parameter_values_relation_partner_id

This procedure selects members for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.dimension_properties.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.dimensions

xls25.xl_parameter_values_root_member_id_code

This procedure selects possible root members for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@dimension_idtinyintINdbo25.members.dimension_id

Underlying table: dbo25.members

xls25.xl_parameter_values_rowset_id

This procedure selects rowsets for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.members

xls25.xl_parameter_values_rowset_id_or_null

This procedure selects rowsets for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@form_idintINdbo25.form_dimensions.form_id
@parameter_indexintINdbo25.form_dimensions.parameter_index
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@form_idintINdbo25.form_dimensions.form_id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@form_idintINdbo25.form_dimensions.form_id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@form_idintINdbo25.form_dimensions.form_id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@form_idintINdbo25.form_dimensions.form_id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@form_idintINdbo25.form_dimensions.form_id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@form_idintINdbo25.form_dimensions.form_id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@form_idintINdbo25.form_dimensions.form_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.members

xls25.xl_parameter_values_unit_id

This procedure selects units for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.units.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.units

xls25.xl_parameter_values_username

This procedure selects usernames for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo25.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.

ParameterDataTypeModeComment
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@dimension_idtinyintINdbo25.dimension_calc_types.dimension_id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.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.

ParameterDataTypeModeComment
@company_idintINdbo25.dimension_properties.company_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.dimensions

xls25.xl_validation_list_member_id

This procedure selects members to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@dimension_idtinyintINdbo25.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.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@rowset_idintINdbo25.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.

ParameterDataTypeModeComment
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@dimension_idtinyintINdbo25.members.dimension_id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.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.

ParameterDataTypeModeComment
@company_idintINdbo25.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.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.members.company_id
@dimension_idtinyintINdbo25.members.dimension_id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.tax_rates.company_id
@dimension_idtinyintINdbo25.members.dimension_id
@data_languagechar(2)INContext 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.

ParameterDataTypeModeComment
@company_idintINdbo25.units.company_id
@dimension_idtinyintINdbo25.members.dimension_id
@data_languagechar(2)INContext data language

Underlying table: dbo25.units

xls25a.usp_update_table_format

This procedure updates Excel table formats of online dynamic forms.

ParameterDataTypeModeComment
@schemanvarchar(128)IN
@namenvarchar(128)IN
@ExcelFormatXMLxmlIN

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.

ParameterDataTypeModeComment
@schemanvarchar(128)IN
@namenvarchar(128)IN
@ExcelFormatXMLxmlIN

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.