Contents Diagrams Roles Schemas Tables Views Procedures Functions

Planning Application
for Microsoft Excel and SQL Server

Procedures

ProcedureDescription
dbo25.usp_export_allThis procedure exports all data.
dbo25.usp_export_currency_ratesThis procedure exports currency rates.
dbo25.usp_export_dimensionsThis procedure exports dimensions.
dbo25.usp_export_factsThis procedure exports source numbers.
dbo25.usp_export_formsThis procedure exports forms and form settings.
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_unitsThis procedure exports units.
dbo25.usp_import_clear_all_dataThis procedure clears all data before importing data.
dbo25.usp_import_currency_ratesThis procedure imports currency rates.
dbo25.usp_import_dimensionThis procedure imports dimensions.
dbo25.usp_import_dimension_calc_typesThis procedure imports calculation types by dimensions.
dbo25.usp_import_dimension_propertiesThis procedure imports dimension properties.
dbo25.usp_import_factThis procedure imports source numbers.
dbo25.usp_import_formThis procedure imports forms.
dbo25.usp_import_form_dimensionThis procedure imports form dimension properties.
dbo25.usp_import_form_permissionsThis procedure imports form permissions.
dbo25.usp_import_form_rowThis procedure imports custom form rowsets.
dbo25.usp_import_form_subtotalsThis procedure imports form subtotal settings.
dbo25.usp_import_memberThis procedure imports dimension members.
dbo25.usp_import_member_parentThis 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_stringThis procedure imports source strings.
dbo25.usp_import_tax_ratesThis procedure imports tax rates.
dbo25.usp_import_unitThis procedure imports units.
dbo25.xl_actions_create_standard_membersThis procedure creates standard dimension members.
dbo25.xl_actions_set_role_permissionsThis procedure grants permissions to the planning application roles.
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_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_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_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_unitsThis procedure is an Excel form for editing units.
xls25.xl_actions_add_cash_flow_exampleThis procedure adds members and settings of the cash flow example.
xls25.xl_actions_add_cost_center_exampleThis procedure adds members and settings of the cost center example.
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_system_currencyThis procedure changes the system currency of the application.
xls25.xl_actions_update_factsThis procedure updates cube values after currency rate changes.
xls25.xl_actions_update_hierarchiesThis procedure updates required tables after member changes.
xls25.xl_actions_update_member_permissionsThis procedure updates member permissions after member changes.
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_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_idThis 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_id_by_dimension_idThis procedure selects calculation types to use as an Excel validation list source.
xls25.xl_validation_list_default_member_idThis 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_by_dimension_idThis procedure selects members to use as an Excel validation list source.
xls25.xl_validation_list_member_id_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_idThis procedure selects possible root members to use as an Excel validation list source.
xls25.xl_validation_list_root_member_or_rowset_idThis 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 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.

dbo25.usp_export_all

This procedure exports all data.

It calls other export procedures in the right order to prepare the complete import SQL script.

dbo25.usp_export_currency_rates

This procedure exports currency rates.

Source table: dbo25.currency_rates

dbo25.usp_export_dimensions

This procedure exports dimensions.

ParameterDataTypeModeComment
@parttinyintIN1 - dbo25.usp_import_dimension
2 - dbo25.usp_import_dimension_calc_types
3 - dbo25.usp_import_dimension_properties

Source table: dbo25.dimensions

dbo25.usp_export_facts

This procedure exports source numbers.

Source table: dbo25.facts

dbo25.usp_export_forms

This procedure exports forms and form settings.

ParameterDataTypeModeComment
@parttinyintIN1 - dbo25.usp_import_form
2 - dbo25.usp_import_form_dimension
3 - dbo25.usp_import_form_row
4 - dbo25.usp_import_form_permissions
5 - dbo25.usp_import_form_subtotals

Source table: dbo25.forms

dbo25.usp_export_members

This procedure exports members.

ParameterDataTypeModeComment
@parttinyintIN1 - dbo25.usp_import_member
2 - dbo25.usp_import_member_properties
3 - dbo25.usp_import_member_parent
4 - dbo25.usp_import_member_relations
5 - dbo25.usp_import_member_permissions

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

dbo25.usp_export_strings

This procedure exports source strings.

Source table: dbo25.strings

dbo25.usp_export_tax_rates

This procedure exports tax rates.

Source table: dbo25.tax_rates

dbo25.usp_export_units

This procedure exports units.

Source table: dbo25.units

dbo25.usp_import_clear_all_data

This procedure clears all data before importing data.

ParameterDataTypeModeComment
@confirmnvarchar(50)INyes - to confirm deleting data

You may clear all the data to create a complete copy of the exported application.

The procedure does not delete dimensions.

dbo25.usp_import_currency_rates

This procedure imports currency rates.

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

This procedure imports dimensions.

ParameterDataTypeModeComment
@idtinyintINdbo25.dimensions.id
@codenvarchar(50)INdbo25.dimensions.code
@namenvarchar(50)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
@external_idintINdbo25.dimensions.external_id
@external_codenvarchar(50)INdbo25.dimensions.external_code

Target table: dbo25.dimensions

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_properties

This procedure imports dimension properties.

ParameterDataTypeModeComment
@dimension_idtinyintINdbo25.dimensions.id
@root_member_codenvarchar(50)INdbo25.dimensions.root_member_id
@default_member_codenvarchar(50)INdbo25.dimensions.default_member_id

Target table: dbo25.dimensions

Call this procedure after importing dimension members.

dbo25.usp_import_fact

This procedure imports source numbers.

ParameterDataTypeModeComment
@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_form

This procedure imports forms.

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

Target table: dbo25.forms

dbo25.usp_import_form_dimension

This procedure imports form dimension properties.

ParameterDataTypeModeComment
@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
@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_row

This procedure imports custom form rowsets.

ParameterDataTypeModeComment
@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
@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_member

This procedure imports dimension members.

ParameterDataTypeModeComment
@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
@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_member_parent

This procedure imports member parents.

ParameterDataTypeModeComment
@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
@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
@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
@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_string

This procedure imports source strings.

ParameterDataTypeModeComment
@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
@idtinyintINdbo25.tax_rates.id
@codenvarchar(50)INdbo25.tax_rates.code
@namenvarchar(50)INdbo25.tax_rates.name
@sort_ordertinyintINdbo25.tax_rates.sort_order
@is_activebitINdbo25.tax_rates.is_active

Target table: dbo25.tax_rates

dbo25.usp_import_unit

This procedure imports units.

ParameterDataTypeModeComment
@idtinyintINdbo25.units.id
@codenvarchar(50)INdbo25.units.code
@namenvarchar(255)INdbo25.units.name
@sort_orderintINdbo25.units.sort_order
@factorfloatINdbo25.units.factor
@is_currencybitINdbo25.units.is_currency
@is_activebitINdbo25.units.is_active

Target table: dbo25.units

dbo25.xl_actions_create_standard_members

This procedure creates standard dimension members.

Use it to initialize the empty cube.

The procedure uses the dbo25.get_standard_members function to select standard members.

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_calc_types

This procedure is an Excel form for editing calculation types.

Underlying table: dbo25.calc_types

xls25.usp_closed_periods

This procedure is an Excel form for editing closed periods.

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.

ParameterDataTypeModeComment
@column_namenvarchar(128)INdbo25.member_relations.category_id
@cell_number_valueintINdbo25.member_relations.update_permission
@idintINdbo25.member_relations.member_id

xls25.usp_currency_rates

This procedure is an Excel form for editing currency rates.

ParameterDataTypeModeComment
@base_currency_idtinyintINdbo25.units.id
@quote_currency_idtinyintINdbo25.units.id

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

xls25.usp_data_management

This procedure is an Excel form for data management.

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.

Underlying table: dbo25.dimensions

Example:

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
@idintINdbo25.dimensions.id
@root_member_idintINdbo25.dimensions.root_member_id
@default_member_idintINdbo25.dimensions.default_member_id

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.dimensions.id

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
@idtinyintINdbo25.dimensions.id
@codenvarchar(50)INdbo25.dimensions.code
@namenvarchar(50)INdbo25.dimensions.name
@parameter_namenvarchar(50)INdbo25.dimensions.parameter_name
@sort_ordertinyintINdbo25.dimensions.sort_order
@name_format_idtinyintINdbo25.dimensions.name_format_id
@root_member_idintINdbo25.dimensions.root_member_id
@default_member_idintINdbo25.dimensions.default_member_id
@is_protectedtinyintINdbo25.dimensions.is_protected
@default_select_permissiontinyintINdbo25.dimensions.default_select_permission
@default_update_permissiontinyintINdbo25.dimensions.default_update_permission
@is_activetinyintINdbo25.dimensions.is_active

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
@idtinyintINdbo25.dimensions.id
@codenvarchar(50)INdbo25.dimensions.code
@namenvarchar(50)INdbo25.dimensions.name
@parameter_namenvarchar(50)INdbo25.dimensions.parameter_name
@sort_ordertinyintINdbo25.dimensions.sort_order
@name_format_idtinyintINdbo25.dimensions.name_format_id
@root_member_idintINdbo25.dimensions.root_member_id
@default_member_idintINdbo25.dimensions.default_member_id
@is_protectedtinyintINdbo25.dimensions.is_protected
@default_select_permissiontinyintINdbo25.dimensions.default_select_permission
@default_update_permissiontinyintINdbo25.dimensions.default_update_permission
@is_activetinyintINdbo25.dimensions.is_active

xls25.usp_form_dimensions

This procedure is an Excel form for editing form dimension properties.

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.

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.

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.

ParameterDataTypeModeComment
@column_namenvarchar(128)INdbo25.member_permissions.username
@cell_number_valueintIN1 - select_permission = 1
0 - select_permission = 0
@idintINdbo25.member_permissions.member_id

xls25.usp_form_rows

This procedure is an Excel form for editing form rowsets.

ParameterDataTypeModeComment
@rowset_idintINdbo25.form_rows.rowset_id

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.

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
@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

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
@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

xls25.usp_forms

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

Underlying table: dbo25.forms

Example:

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
@codenvarchar(50)INdbo25.forms.code
@namenvarchar(400)INdbo25.forms.name
@sort_orderintINdbo25.forms.sort_order
@is_activetinyintINdbo25.forms.is_active

xls25.usp_forms_update

This procedure updates rows of xls25.usp_forms.

ParameterDataTypeModeComment
@idintINdbo25.forms.id
@codenvarchar(50)INdbo25.forms.code
@namenvarchar(400)INdbo25.forms.name
@sort_orderintINdbo25.forms.sort_order
@is_activetinyintINdbo25.forms.is_active

xls25.usp_member_permissions

This procedure is an Excel form for editing member permissions.

ParameterDataTypeModeComment
@dimension_idtinyintINDimension filter
@root_idintINRoot member filter
@usernamenvarchar(128)INUsername filter

Underlying table: dbo25.member_permissions

Editing data requires the SaveToDB Enterprise edition.

Example:

Type "r", "w", or "d" to change permissions.

The application applies for 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

xls25.usp_member_relations

This procedure is an Excel form for editing member relations.

ParameterDataTypeModeComment
@dimension_idintINDimension filter
@root_idintINRoot member filter
@partner_idintINPartner dimension filter
@fieldnvarchar(50)INupdate_permission, fixed value

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.

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(128)INupdate_permission, fixed value

xls25.usp_members

This procedure is an Excel form for editing dimension members.

ParameterDataTypeModeComment
@dimension_idtinyintINDimension filter
@root_idintINRoot member filter

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.

ParameterDataTypeModeComment
@idintINdbo25.members.id

xls25.usp_members_insert

This procedure inserts rows of xls25.usp_members.

ParameterDataTypeModeComment
@dimension_idtinyintINdbo25.members.dimension_id
@codenvarchar(50)INdbo25.members.code
@namenvarchar(400)INdbo25.members.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
@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

xls25.usp_members_update

This procedure updates rows of xls25.usp_members.

ParameterDataTypeModeComment
@idintINdbo25.members.id, dbo25.parents.member_id
@dimension_idtinyintINdbo25.members.dimension_id
@codenvarchar(50)INdbo25.members.code
@namenvarchar(400)INdbo25.members.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
@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

xls25.usp_rowsets

This procedure is an Excel form for editing rowset members.

ParameterDataTypeModeComment
@dimension_idtinyintINDimension filter

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.

ParameterDataTypeModeComment
@idintINdbo25.members.id

xls25.usp_rowsets_insert

This procedure inserts rows of xls25.usp_rowsets.

ParameterDataTypeModeComment
@dimension_idtinyintINdbo25.members.dimension_id
@codenvarchar(50)INdbo25.members.code
@namenvarchar(400)INdbo25.members.name
@sort_orderintINdbo25.members.sort_order

xls25.usp_rowsets_update

This procedure updates rows of xls25.usp_rowsets.

ParameterDataTypeModeComment
@idintINdbo25.members.id
@dimension_idtinyintINdbo25.members.dimension_id
@codenvarchar(50)INdbo25.members.code
@namenvarchar(400)INdbo25.members.name
@sort_orderintINdbo25.members.sort_order

xls25.usp_run_form

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

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

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 thee 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.

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

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
@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
@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

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.

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

Underlying table: dbo25.tax_rates

xls25.usp_units

This procedure is an Excel form for editing units.

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

Underlying table: dbo25.units

Example:

xls25.xl_actions_add_cash_flow_example

This procedure adds members and settings of the cash flow example.

ParameterDataTypeModeComment
@set_1_to_confirmtinyintIN1 - to create example members

Target tables: dbo25.members, dbo25.parents

xls25.xl_actions_add_cost_center_example

This procedure adds members and settings of the cost center example.

ParameterDataTypeModeComment
@set_1_to_confirmtinyintIN1 - to create example members

Target tables: dbo25.members, dbo25.parents

xls25.xl_actions_add_quarters

This procedure adds quarter members.

ParameterDataTypeModeComment
@yearintINYear

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
@yearintINYear

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
@codenvarchar(128)INTime dbo25.members.id
@source_category_codenvarchar(128)INSource category dbo25.members.id
@target_category_codenvarchar(128)INTarget category dbo25.members.id
@set_1_to_copytinyintIN1 - to confirm copying data

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
@codenvarchar(128)INTime dbo25.members.id
@category_codenvarchar(128)INCategory dbo25.members.id
@set_1_to_deletetinyintIN1 - to confirm deleting data

Target tables: dbo25.facts, dbo25.strings

xls25.xl_actions_delete_year

This procedure deletes year members.

ParameterDataTypeModeComment
@yearintINYear
@set_1_to_deletetinyintIN1 - to confirm deleting data

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

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

Underlying table: dbo25.facts

Output example:

xls25.xl_actions_set_system_currency

This procedure changes the system currency of the application.

ParameterDataTypeModeComment
@idintINdbo25.units.id

Target table: dbo25.units

xls25.xl_actions_update_facts

This procedure updates cube values after currency rate changes.

Target table: dbo25.facts

xls25.xl_actions_update_hierarchies

This procedure updates required tables after member changes.

Target tables: dbo25.hierarchies, dbo25.factors

xls25.xl_actions_update_member_permissions

This procedure updates member permissions after member changes.

Target table: dbo25.member_permissions

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.

Underlying table: dbo25.calc_types

xls25.xl_parameter_values_calc_type_id_or_null

This procedure selects calculation types for Excel ribbon parameters.

Underlying table: dbo25.calc_types

xls25.xl_parameter_values_currency_id

This procedure selects currencies for Excel ribbon parameters.

Underlying table: dbo25.units

xls25.xl_parameter_values_dimension_id

This procedure selects dimensions for Excel ribbon parameters.

Underlying table: dbo25.dimensions

xls25.xl_parameter_values_dimension_id_or_null

This procedure selects dimensions for Excel ribbon parameters.

Underlying table: dbo25.dimensions

xls25.xl_parameter_values_form_id

This procedure selects forms for Excel ribbon parameters.

Underlying table: dbo25.forms

xls25.xl_parameter_values_form_id_or_null

This procedure selects forms for Excel ribbon parameters.

Underlying table: dbo25.forms

xls25.xl_parameter_values_member_id_by_dimension_id

This procedure selects members for Excel ribbon parameters.

ParameterDataTypeModeComment
@dimension_idtinyintINdbo25.members.dimension_id

Underlying table: dbo25.members

xls25.xl_parameter_values_member_id_dim1

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

Underlying table: dbo25.members

xls25.xl_parameter_values_member_id_dim2

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

Underlying table: dbo25.members

xls25.xl_parameter_values_member_id_dim3

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

Underlying table: dbo25.members

xls25.xl_parameter_values_member_id_dim4

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

Underlying table: dbo25.members

xls25.xl_parameter_values_member_id_dim5

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

Underlying table: dbo25.members

xls25.xl_parameter_values_member_id_dim6

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

Underlying table: dbo25.members

xls25.xl_parameter_values_member_id_dim7

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

Underlying table: dbo25.members

xls25.xl_parameter_values_relation_dimension_id

This procedure selects dimensions for Excel ribbon parameters.

Underlying table: dbo25.dimensions

xls25.xl_parameter_values_relation_partner_id

This procedure selects members for Excel ribbon parameters.

Underlying table: dbo25.dimensions

xls25.xl_parameter_values_root_member_id

This procedure selects possible root members for Excel ribbon parameters.

ParameterDataTypeModeComment
@dimension_idtinyintINdbo25.members.dimension_id

Underlying table: dbo25.members

xls25.xl_parameter_values_rowset_id

This procedure selects rowsets for Excel ribbon parameters.

Underlying table: dbo25.members

xls25.xl_parameter_values_rowset_id_or_null

This procedure selects rowsets for Excel ribbon parameters.

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

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

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

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

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

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

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

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

Underlying table: dbo25.members

xls25.xl_parameter_values_unit_id

This procedure selects units for Excel ribbon parameters.

Underlying table: dbo25.units

xls25.xl_parameter_values_username

This procedure selects usernames for Excel ribbon parameters.

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.

Underlying table: dbo25.axis_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

Underlying table: dbo25.calc_types

xls25.xl_validation_list_default_member_id

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

Underlying table: dbo25.members

xls25.xl_validation_list_dimension_id

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

Underlying table: dbo25.dimensions

xls25.xl_validation_list_member_id

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

Underlying table: dbo25.members

xls25.xl_validation_list_member_id_by_dimension_id

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

ParameterDataTypeModeComment
@dimension_idtinyintINdbo25.members.dimension_id

Underlying table: dbo25.members

xls25.xl_validation_list_member_id_by_rowset_id

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

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

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
@dimension_idtinyintINdbo25.members.dimension_id

Underlying table: dbo25.members

xls25.xl_validation_list_root_member_id

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

Underlying table: dbo25.members

xls25.xl_validation_list_root_member_or_rowset_id

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

Underlying table: dbo25.members

xls25.xl_validation_list_rowset_id

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

Underlying table: dbo25.members

xls25.xl_validation_list_same_period_id_by_dimension_id

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

ParameterDataTypeModeComment
@dimension_idtinyintINdbo25.members.dimension_id

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
@dimension_idtinyintINdbo25.members.dimension_id

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
@dimension_idtinyintINdbo25.members.dimension_id

Underlying table: dbo25.units

Contents

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.