Planning Application Views

Planning Application Views

ViewDescription
dbo25.view_dynamic_form_fieldsThis view selects empty data of dynamic forms.
dbo25.view_factsThis view selects the calculated facts.
dbo25.view_facts_dataThis view selects source cube data.
dbo25.view_query_listThis view selects developer objects for the SaveToDB Connection Wizard and SaveToDB Query List.
xls25.view_hierarchiesThis view selects member parents, factors, and hierarchies.
xls25.xl_formatsThis view selects table formats of the forms configured in dbo25.forms.
xls25.xl_handlersThis view selects the handler configuration of the forms configured in dbo25.forms.
xls25.xl_query_listThis view selects user objects for the SaveToDB Connection Wizard and SaveToDB Query List.
xls25.xl_query_list_offline_formsThis view selects offline user forms for the SaveToDB Connection Wizard and SaveToDB Query List.
xls25.xl_query_list_online_formsThis view selects user forms for the SaveToDB Connection Wizard and SaveToDB Query List.
xls25.xl_translationsThis 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

ColumnDataTypeComment
idintRowset id of the first dimension of the row
id2intRowset id of the second dimension of the row
id3intRowset id of the third dimension of the row
sort_orderintdbo25.members.sort_order
sort_order2intdbo25.members.sort_order
sort_order3intdbo25.members.sort_order
member_idintMember id of the first dimension of the row
member_id2intMember id of the second dimension of the row
member_id3intMember id of the third dimension of the row
is_editableint1 - the line is editable
0 - the line is readonly
decimal_placestinyintDecimal places
is_percentbit1 - format data values as percent
row_colortinyintRow color index for conditional formatting
row_boldtinyint1 - format the row as bold
row_indenttinyintRow indent
codenvarchar(50)Line code
namenvarchar(400)Member name or rowset name
commentnvarchar(1000)dbo25.members.comment
code1nvarchar(50)Member code of the first dimension of the row
code2nvarchar(50)Member code of the second dimension of the row
name2nvarchar(400)Member name of the second dimension of the row
code3nvarchar(50)Member code of the third dimension of the row
name3nvarchar(400)Member name of the third dimension of the row
calc_typenvarchar(100)dbo25.calc_types.name
tax_ratenvarchar(50)dbo25.tax_rates.name
unitnvarchar(100)dbo25.units.name
data_formatintAn 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

ColumnDataTypeComment
company_idintdbo25.factors.company_id
id1intdbo25.facts.id1 - Accounts
id2intdbo25.facts.id2 - Times
id3intdbo25.facts.id3 - Categories
id4intdbo25.facts.id4 - Entities
id5intdbo25.facts.id5 - Dimension 5
id6intdbo25.facts.id6 - Dimension 6
id7intdbo25.facts.id7 - Dimension 7
calc_type_idtinyintdbo25.members.calc_type_id value of the id1 member
unit_idintdbo25.members.unit_id value of the id1 member
source_valuefloatdbo25.facts.source_value
valuefloatdbo25.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

ColumnDataTypeComment
idintdbo25.facts.id
company_idintdbo25.factors.company_id
id1intdbo25.facts.id1
id2intdbo25.facts.id2
id3intdbo25.facts.id3
id4intdbo25.facts.id4
id5intdbo25.facts.id5
id6intdbo25.facts.id6
id7intdbo25.facts.id7
unit_idintdbo25.members.unit_id
calc_type_idtinyintdbo25.members.calc_type_id
source_valuefloatdbo25.facts.source_value
valuefloatdbo25.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

ColumnDataTypeComment
TABLE_SCHEMAnvarchar(128)xls.queries.TABLE_SCHEMA
TABLE_NAMEnvarchar(128)xls.queries.TABLE_NAME
TABLE_TYPEnvarchar(128)xls.queries.TABLE_TYPE
TABLE_CODEnvarchar(max)xls.queries.TABLE_CODE
INSERT_PROCEDUREnvarchar(max)xls.queries.INSERT_PROCEDURE
UPDATE_PROCEDUREnvarchar(max)xls.queries.UPDATE_PROCEDURE
DELETE_PROCEDUREnvarchar(max)xls.queries.DELETE_PROCEDURE
PROCEDURE_TYPEnvarchar(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

ColumnDataTypeComment
company_idintdbo25.members.company_id
companynvarchar(100)dbo25.companies.name
dimension_idtinyintdbo25.dimensions.id
dimension_namenvarchar(50)dbo25.dimensions.name
table_namevarchar(11)The field shows the source table: dbo25.parents, dbo25.hierarchies, or dbo25.factors.
member_idintChild member ID
parent_idintParent member ID
calc_type_idtinyintdbo25.factors.calc_type_id
membernvarchar(453)Child member display name
parentnvarchar(453)Parent member display name
calc_typenvarchar(100)dbo25.calc_types.name
factorfloatdbo25.parents.factor or dbo25.factors.factor
levelintdbo25.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

ColumnDataTypeComment
TABLE_SCHEMAvarchar(6)dbo25.formats.TABLE_SCHEMA
TABLE_NAMEnvarchar(102)dbo25.formats.TABLE_NAME
TABLE_EXCEL_FORMAT_XMLxmldbo25.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

ColumnDataTypeComment
TABLE_SCHEMAnvarchar(128)xls.handlers.TABLE_SCHEMA
TABLE_NAMEnvarchar(128)xls.handlers.TABLE_NAME
COLUMN_NAMEnvarchar(128)xls.handlers.COLUMN_NAME
EVENT_NAMEvarchar(25)xls.handlers.EVENT_NAME
HANDLER_SCHEMAnvarchar(128)xls.handlers.HANDLER_SCHEMA
HANDLER_NAMEnvarchar(280)xls.handlers.HANDLER_NAME
HANDLER_TYPEvarchar(25)xls.handlers.HANDLER_TYPE
HANDLER_CODEnvarchar(max)xls.handlers.HANDLER_CODE
TARGET_WORKSHEETnvarchar(255)xls.handlers.TARGET_WORKSHEET
MENU_ORDERbigintxls.handlers.MENU_ORDER
EDIT_PARAMETERSbitxls.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

ColumnDataTypeComment
TABLE_SCHEMAnvarchar(128)xls.queries.TABLE_SCHEMA
TABLE_NAMEnvarchar(128)xls.queries.TABLE_NAME
TABLE_TYPEnvarchar(128)xls.queries.TABLE_TYPE
TABLE_CODEnvarchar(max)xls.queries.TABLE_CODE
INSERT_PROCEDUREnvarchar(max)xls.queries.INSERT_PROCEDURE
UPDATE_PROCEDUREnvarchar(max)xls.queries.UPDATE_PROCEDURE
DELETE_PROCEDUREnvarchar(max)xls.queries.DELETE_PROCEDURE
PROCEDURE_TYPEnvarchar(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

ColumnDataTypeComment
TABLE_SCHEMAvarchar(6)Configured form schema: xls25b
TABLE_NAMEnvarchar(102)dbo25.forms.code
TABLE_TYPEvarchar(4)Type of the configured object: CODE
TABLE_CODEnvarchar(max)SQL code to execute the xls25.run_offline_form procedure with the form parameters
INSERT_PROCEDUREvarchar(33)xls25.usp_run_offline_form_insert
UPDATE_PROCEDUREvarchar(33)xls25.usp_run_offline_form_update
DELETE_PROCEDUREvarchar(33)xls25.usp_run_offline_form_delete
PROCEDURE_TYPEvarchar(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

ColumnDataTypeComment
TABLE_SCHEMAvarchar(6)Configured form schema: xls25a
TABLE_NAMEnvarchar(102)dbo25.forms.code
TABLE_TYPEvarchar(4)Type of the configured object: CODE
TABLE_CODEnvarchar(max)SQL code to execute the xls25.run_form procedure with the form parameters
INSERT_PROCEDUREnvarchar(max)NULL
UPDATE_PROCEDUREnvarchar(max)NULL
DELETE_PROCEDUREnvarchar(max)NULL
PROCEDURE_TYPEnvarchar(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

ColumnDataTypeComment
TABLE_SCHEMAvarchar(6)xls25a or xls25b
TABLE_NAMEnvarchar(102)Dynamic form code
COLUMN_NAMEnvarchar(128)Dynamic form column name or parameter name or NULL
LANGUAGE_NAMEvarchar(2)dbo25.translations.language
TRANSLATED_NAMEnvarchar(452)dbo25.translations.name or dbo25.dimension_properties.parameter_name
TRANSLATED_DESCnvarchar(max)NULL
TRANSLATE_COMMENTnvarchar(max)NULL

This view selects translations of the configured forms for the SaveToDB add-in.

See also Configuring Data Translation.