Planning Application Views
| View | Description |
|---|---|
| dbo25.view_dynamic_form_fields | This view selects empty data of dynamic forms. |
| dbo25.view_facts | This view selects the calculated facts. |
| dbo25.view_facts_data | This view selects source cube data. |
| dbo25.view_query_list | This view selects developer objects for the SaveToDB Connection Wizard and SaveToDB Query List. |
| xls25.view_hierarchies | This view selects member parents, factors, and hierarchies. |
| xls25.xl_formats | This view selects table formats of the forms configured in dbo25.forms. |
| xls25.xl_handlers | This view selects the handler configuration of the forms configured in dbo25.forms. |
| xls25.xl_query_list | This view selects user objects for the SaveToDB Connection Wizard and SaveToDB Query List. |
| xls25.xl_query_list_offline_forms | This view selects offline user forms for the SaveToDB Connection Wizard and SaveToDB Query List. |
| xls25.xl_query_list_online_forms | This view selects user forms for the SaveToDB Connection Wizard and SaveToDB Query List. |
| xls25.xl_translations | This view selects translations of the forms configured in dbo25.forms. |
dbo25.view_dynamic_form_fields
This view selects empty data of dynamic forms.
Source tables: dbo25.calc_types, dbo25.members, dbo25.tax_rates, dbo25.units
| Column | DataType | Comment |
|---|---|---|
| id | int | Rowset id of the first dimension of the row |
| id2 | int | Rowset id of the second dimension of the row |
| id3 | int | Rowset id of the third dimension of the row |
| sort_order | int | dbo25.members.sort_order |
| sort_order2 | int | dbo25.members.sort_order |
| sort_order3 | int | dbo25.members.sort_order |
| member_id | int | Member id of the first dimension of the row |
| member_id2 | int | Member id of the second dimension of the row |
| member_id3 | int | Member id of the third dimension of the row |
| is_editable | int | 1 - the line is editable
0 - the line is readonly |
| decimal_places | tinyint | Decimal places |
| is_percent | bit | 1 - format data values as percent |
| row_color | tinyint | Row color index for conditional formatting |
| row_bold | tinyint | 1 - format the row as bold |
| row_indent | tinyint | Row indent |
| code | nvarchar(50) | Line code |
| name | nvarchar(400) | Member name or rowset name |
| comment | nvarchar(1000) | dbo25.members.comment |
| code1 | nvarchar(50) | Member code of the first dimension of the row |
| code2 | nvarchar(50) | Member code of the second dimension of the row |
| name2 | nvarchar(400) | Member name of the second dimension of the row |
| code3 | nvarchar(50) | Member code of the third dimension of the row |
| name3 | nvarchar(400) | Member name of the third dimension of the row |
| calc_type | nvarchar(100) | dbo25.calc_types.name |
| tax_rate | nvarchar(50) | dbo25.tax_rates.name |
| unit | nvarchar(100) | dbo25.units.name |
| data_format | int | An empty column to store Excel format for data columns |
The xls25.usp_run_form procedure uses this view to select empty data.
dbo25.view_facts
This view selects the calculated facts.
Source tables: dbo25.factors, dbo25.facts, dbo25.members, dbo25.users
| Column | DataType | Comment |
|---|---|---|
| company_id | int | dbo25.factors.company_id |
| id1 | int | dbo25.facts.id1 - Accounts |
| id2 | int | dbo25.facts.id2 - Times |
| id3 | int | dbo25.facts.id3 - Categories |
| id4 | int | dbo25.facts.id4 - Entities |
| id5 | int | dbo25.facts.id5 - Dimension 5 |
| id6 | int | dbo25.facts.id6 - Dimension 6 |
| id7 | int | dbo25.facts.id7 - Dimension 7 |
| calc_type_id | tinyint | dbo25.members.calc_type_id value of the id1 member |
| unit_id | int | dbo25.members.unit_id value of the id1 member |
| source_value | float | dbo25.facts.source_value |
| value | float | dbo25.facts.value |
This is a system view used by xls25.usp_facts.
dbo25.view_facts_data
This view selects source cube data.
Source tables: dbo25.calc_types, dbo25.companies, dbo25.facts, dbo25.members, dbo25.units, dbo25.users
| Column | DataType | Comment |
|---|---|---|
| id | int | dbo25.facts.id |
| company_id | int | dbo25.factors.company_id |
| id1 | int | dbo25.facts.id1 |
| id2 | int | dbo25.facts.id2 |
| id3 | int | dbo25.facts.id3 |
| id4 | int | dbo25.facts.id4 |
| id5 | int | dbo25.facts.id5 |
| id6 | int | dbo25.facts.id6 |
| id7 | int | dbo25.facts.id7 |
| unit_id | int | dbo25.members.unit_id |
| calc_type_id | tinyint | dbo25.members.calc_type_id |
| source_value | float | dbo25.facts.source_value |
| value | float | dbo25.facts.value |
This is a system view used by xls25.usp_facts_data.
dbo25.view_query_list
This view selects developer objects for the SaveToDB Connection Wizard and SaveToDB Query List.
Source tables: xls.queries
| Column | DataType | Comment |
|---|---|---|
| TABLE_SCHEMA | nvarchar(128) | xls.queries.TABLE_SCHEMA |
| TABLE_NAME | nvarchar(128) | xls.queries.TABLE_NAME |
| TABLE_TYPE | nvarchar(128) | xls.queries.TABLE_TYPE |
| TABLE_CODE | nvarchar(max) | xls.queries.TABLE_CODE |
| INSERT_PROCEDURE | nvarchar(max) | xls.queries.INSERT_PROCEDURE |
| UPDATE_PROCEDURE | nvarchar(max) | xls.queries.UPDATE_PROCEDURE |
| DELETE_PROCEDURE | nvarchar(max) | xls.queries.DELETE_PROCEDURE |
| PROCEDURE_TYPE | nvarchar(50) | xls.queries.PROCEDURE_TYPE |
The view filters output of the SaveToDB Framework xls.queries view to show planning application objects only.
See also Configuring Query Lists.
xls25.view_hierarchies
This view selects member parents, factors, and hierarchies.
Source tables: dbo25.calc_types, dbo25.companies, dbo25.dimension_properties, dbo25.factors, dbo25.hierarchies, dbo25.members, dbo25.parents, dbo25.users
| Column | DataType | Comment |
|---|---|---|
| company_id | int | dbo25.members.company_id |
| company | nvarchar(100) | dbo25.companies.name |
| dimension_id | tinyint | dbo25.dimensions.id |
| dimension_name | nvarchar(50) | dbo25.dimensions.name |
| table_name | varchar(11) | The field shows the source table: dbo25.parents, dbo25.hierarchies, or dbo25.factors. |
| member_id | int | Child member ID |
| parent_id | int | Parent member ID |
| calc_type_id | tinyint | dbo25.factors.calc_type_id |
| member | nvarchar(453) | Child member display name |
| parent | nvarchar(453) | Parent member display name |
| calc_type | nvarchar(100) | dbo25.calc_types.name |
| factor | float | dbo25.parents.factor or dbo25.factors.factor |
| level | int | dbo25.hierarchies.level |
Use this view to check member relation properties generated by the application.
xls25.xl_formats
This view selects table formats of the forms configured in dbo25.forms.
Source tables: dbo25.companies, dbo25.formats, dbo25.forms, dbo25.users, xls.formats
| Column | DataType | Comment |
|---|---|---|
| TABLE_SCHEMA | varchar(6) | dbo25.formats.TABLE_SCHEMA |
| TABLE_NAME | nvarchar(101) | dbo25.formats.TABLE_NAME |
| TABLE_EXCEL_FORMAT_XML | xml | dbo25.formats.TABLE_EXCEL_FORMAT_XML |
This view selects table formats of the configured forms for the SaveToDB add-in.
It uses the format of xls25.usp_run_form for every form that has no format.
Use the SaveToDB Table Format Wizard to save table formats.
See also Configuring Table Formats.
xls25.xl_handlers
This view selects the handler configuration of the forms configured in dbo25.forms.
Source tables: dbo25.companies, dbo25.dimension_properties, dbo25.form_dimensions, dbo25.forms, dbo25.members, dbo25.parents, dbo25.users, xls.handlers
| Column | DataType | Comment |
|---|---|---|
| TABLE_SCHEMA | nvarchar(128) | xls.handlers.TABLE_SCHEMA |
| TABLE_NAME | nvarchar(128) | xls.handlers.TABLE_NAME |
| COLUMN_NAME | nvarchar(128) | xls.handlers.COLUMN_NAME |
| EVENT_NAME | varchar(25) | xls.handlers.EVENT_NAME |
| HANDLER_SCHEMA | nvarchar(128) | xls.handlers.HANDLER_SCHEMA |
| HANDLER_NAME | nvarchar(280) | xls.handlers.HANDLER_NAME |
| HANDLER_TYPE | varchar(25) | xls.handlers.HANDLER_TYPE |
| HANDLER_CODE | nvarchar(max) | xls.handlers.HANDLER_CODE |
| TARGET_WORKSHEET | nvarchar(255) | xls.handlers.TARGET_WORKSHEET |
| MENU_ORDER | bigint | xls.handlers.MENU_ORDER |
| EDIT_PARAMETERS | bit | xls.handlers.EDIT_PARAMETERS |
This view selects event handler configurations of the configured forms for the SaveToDB add-in.
See also Configuring Event Handlers.
xls25.xl_query_list
This view selects user objects for the SaveToDB Connection Wizard and SaveToDB Query List.
Source tables: xls.queries
| Column | DataType | Comment |
|---|---|---|
| TABLE_SCHEMA | nvarchar(128) | xls.queries.TABLE_SCHEMA |
| TABLE_NAME | nvarchar(128) | xls.queries.TABLE_NAME |
| TABLE_TYPE | nvarchar(128) | xls.queries.TABLE_TYPE |
| TABLE_CODE | nvarchar(max) | xls.queries.TABLE_CODE |
| INSERT_PROCEDURE | nvarchar(max) | xls.queries.INSERT_PROCEDURE |
| UPDATE_PROCEDURE | nvarchar(max) | xls.queries.UPDATE_PROCEDURE |
| DELETE_PROCEDURE | nvarchar(max) | xls.queries.DELETE_PROCEDURE |
| PROCEDURE_TYPE | nvarchar(50) | xls.queries.PROCEDURE_TYPE |
The view filters output of the SaveToDB Framework xls.queries view.
See also Configuring Query Lists.
xls25.xl_query_list_offline_forms
This view selects offline user forms for the SaveToDB Connection Wizard and SaveToDB Query List.
Source tables: dbo25.companies, dbo25.dimension_properties, dbo25.form_dimensions, dbo25.form_permissions, dbo25.forms, dbo25.users
| Column | DataType | Comment |
|---|---|---|
| TABLE_SCHEMA | varchar(6) | Configured form schema: xls25b |
| TABLE_NAME | nvarchar(101) | dbo25.forms.code |
| TABLE_TYPE | varchar(4) | Type of the configured object: CODE |
| TABLE_CODE | nvarchar(max) | SQL code to execute the xls25.run_offline_form procedure with the form parameters |
| INSERT_PROCEDURE | varchar(33) | xls25.usp_run_offline_form_insert |
| UPDATE_PROCEDURE | varchar(33) | xls25.usp_run_offline_form_update |
| DELETE_PROCEDURE | varchar(33) | xls25.usp_run_offline_form_delete |
| PROCEDURE_TYPE | varchar(9) | Type of edit procedures for information purposes: PROCEDURE |
Use this view to connect to configured forms in the SaveToDB Data Connection Wizard in the business user workbooks.
The forms of this list use edit procedures to update the underlying cube values. Users must click the Save button to save changes.
This feature works with the SaveToDB Standard edition.
This view shows configured forms with actual select permissions.
See also Configuring Query Lists.
xls25.xl_query_list_online_forms
This view selects user forms for the SaveToDB Connection Wizard and SaveToDB Query List.
Source tables: dbo25.companies, dbo25.dimension_properties, dbo25.form_dimensions, dbo25.form_permissions, dbo25.forms, dbo25.users
| Column | DataType | Comment |
|---|---|---|
| TABLE_SCHEMA | varchar(6) | Configured form schema: xls25a |
| TABLE_NAME | nvarchar(101) | dbo25.forms.code |
| TABLE_TYPE | varchar(4) | Type of the configured object: CODE |
| TABLE_CODE | nvarchar(max) | SQL code to execute the xls25.run_form procedure with the form parameters |
| INSERT_PROCEDURE | nvarchar(max) | NULL |
| UPDATE_PROCEDURE | nvarchar(max) | NULL |
| DELETE_PROCEDURE | nvarchar(max) | NULL |
| PROCEDURE_TYPE | nvarchar(128) | NULL |
Use this view to connect to configured forms in the SaveToDB Data Connection Wizard in the business user workbooks.
The forms of this list use cell change event handlers to update the underlying cube values. So, this feature requires the SaveToDB Enterprise edition.
This view shows configured forms with actual select permissions.
See also Configuring Query Lists.
xls25.xl_translations
This view selects translations of the forms configured in dbo25.forms.
Source tables: dbo25.companies, dbo25.dimension_properties, dbo25.form_dimensions, dbo25.form_permissions, dbo25.forms, dbo25.translations, dbo25.users
| Column | DataType | Comment |
|---|---|---|
| TABLE_SCHEMA | varchar(6) | xls25a or xls25b |
| TABLE_NAME | nvarchar(101) | Dynamic form code |
| COLUMN_NAME | nvarchar(128) | Dynamic form column name or parameter name or NULL |
| LANGUAGE_NAME | varchar(10) | dbo25.translations.language |
| TRANSLATED_NAME | nvarchar(452) | dbo25.translations.name or dbo25.dimension_properties.parameter_name |
| TRANSLATED_DESC | nvarchar(max) | NULL |
| TRANSLATED_COMMENT | nvarchar(max) |
This view selects translations of the configured forms for the SaveToDB add-in.
See also Configuring Data Translation.