Contents Diagrams Roles Schemas Tables Views Procedures Functions

Planning Application
for Microsoft Excel and SQL Server

Views

ViewDescription
dbo25.view_dataThis view selects source cube data.
dbo25.view_factsThis view selects calculated facts.
dbo25.view_query_listThis view selects developer objects for the SaveToDB Connection Wizard and SaveToDB Query List.
dbo25.view_stringsThis view selects cube string data.
xls25.view_formatsThis view selects table formats of the forms configured in dbo25.forms.
xls25.view_handlersThis view selects the handler configuration of the forms configured in dbo25.forms.
xls25.view_hierarchiesThis view selects member parents, factors, and hierarchies.
xls25.view_query_listThis view selects user objects for the SaveToDB Connection Wizard and SaveToDB Query List.
xls25.view_query_list_formsThis view selects user forms for the SaveToDB Connection Wizard and SaveToDB Query List.
xls25.view_query_list_offline_formsThis view selects offline user forms for the SaveToDB Connection Wizard and SaveToDB Query List.
xls25.view_translationsThis view selects translations of the forms configured in dbo25.forms.

dbo25.view_data

This view selects source cube data.

Source tables: dbo25.calc_types, dbo25.facts, dbo25.members, dbo25.units

ColumnDataTypeComment
idintdbo25.facts.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
unit_idtinyintdbo25.members.unit_id value of the id1 member
calc_type_idtinyintdbo25.members.calc_type_id value of the id1 member
code1nvarchar(50)id1 member code
name1nvarchar(400)id1 member name
code2nvarchar(50)id2 member code
name2nvarchar(400)id2 member name
code3nvarchar(50)id3 member code
name3nvarchar(400)id3 member name
code4nvarchar(50)id4 member code
name4nvarchar(400)id4 member name
code5nvarchar(50)id5 member code
name5nvarchar(400)id5 member name
code6nvarchar(50)id6 member code
name6nvarchar(400)id6 member name
code7nvarchar(50)id7 member code
name7nvarchar(400)id7 member name
unitnvarchar(50)Account unit_id code
calc_typenvarchar(400)Account calc_type_id code
source_valuefloatdbo25.facts.source_value
valuefloatdbo25.facts.value

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

dbo25.view_facts

This view selects calculated facts.

Source tables: dbo25.calc_types, dbo25.factors, dbo25.facts, dbo25.members, dbo25.units

ColumnDataTypeComment
idintdbo25.facts.id
The value is NULL for calculated values.
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
unit_idtinyintdbo25.members.unit_id value of the id1 member
calc_type_idtinyintdbo25.members.calc_type_id value of the id1 member
code1nvarchar(50)id1 member code
name1nvarchar(400)id1 member name
code2nvarchar(50)id2 member code
name2nvarchar(400)id2 member name
code3nvarchar(50)id3 member code
name3nvarchar(400)id3 member name
code4nvarchar(50)id4 member code
name4nvarchar(400)id4 member name
code5nvarchar(50)id5 member code
name5nvarchar(400)id5 member name
code6nvarchar(50)id6 member code
name6nvarchar(400)id6 member name
code7nvarchar(50)id7 member code
name7nvarchar(400)id7 member name
unitnvarchar(50)Account unit_id code
calc_typenvarchar(400)Account calc_type_id code
source_valuefloatdbo25.facts.source_value
valuefloatdbo25.facts.value
is_formulaint0 - source value, 1 - calculated value

This view selects complete calculated cube values.

You may load the data into your BI tool, for example, PowerPivot.

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.

dbo25.view_strings

This view selects cube string data.

Source tables: dbo25.members, dbo25.strings

ColumnDataTypeComment
idintdbo25.strings.id
id1intdbo25.strings.id1 - Accounts
id2intdbo25.strings.id2 - Times
id3intdbo25.strings.id3 - Categories
id4intdbo25.strings.id4 - Entities
id5intdbo25.strings.id5 - Dimension 5
id6intdbo25.strings.id6 - Dimension 6
id7intdbo25.strings.id7 - Dimension 7
unit_idtinyintdbo25.members.unit_id value of the id1 member
calc_type_idtinyintdbo25.members.calc_type_id value of the id1 member
code1nvarchar(50)id1 member code
name1nvarchar(400)id1 member name
code2nvarchar(50)id2 member code
name2nvarchar(400)id2 member name
code3nvarchar(50)id3 member code
name3nvarchar(400)id3 member name
code4nvarchar(50)id4 member code
name4nvarchar(400)id4 member name
code5nvarchar(50)id5 member code
name5nvarchar(400)id5 member name
code6nvarchar(50)id6 member code
name6nvarchar(400)id6 member name
code7nvarchar(50)id7 member code
name7nvarchar(400)id7 member name
valuenvarchar(4000)dbo25.strings.value

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

xls25.view_formats

This view selects table formats of the forms configured in dbo25.forms.

Source tables: dbo25.forms, xls.formats

ColumnDataTypeComment
TABLE_SCHEMAvarchar(13)xls.formats.TABLE_SCHEMA
TABLE_NAMEnvarchar(50)xls.formats.TABLE_NAME
TABLE_EXCEL_FORMAT_XMLxmlxls.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.view_handlers

This view selects the handler configuration of the forms configured in dbo25.forms.

Source tables: dbo25.dimensions, dbo25.form_dimensions, dbo25.forms, dbo25.members, dbo25.parents, xls.handlers

ColumnDataTypeComment
TABLE_SCHEMAvarchar(13)Schema of the configured object: forms, offline_forms, or xls25
TABLE_NAMEnvarchar(50)Name of the configured object
COLUMN_NAMEnvarchar(128)Column or parameter name of the configured object
EVENT_NAMEvarchar(25)xls.handlers.EVENT_NAME
HANDLER_SCHEMAnvarchar(20)Schema of the handler object: xls25
HANDLER_NAMEnvarchar(128)Name the handler object
HANDLER_TYPEvarchar(25)xls.handlers.HANDLER_TYPE
HANDLER_CODEnvarchar(max)SQL code of the handler object
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.view_hierarchies

This view selects member parents, factors, and hierarchies.

Source tables: dbo25.calc_types, dbo25.dimensions, dbo25.factors, dbo25.hierarchies, dbo25.members, dbo25.parents

ColumnDataTypeComment
dimension_idtinyintdbo25.members.dimension_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(400)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.view_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.view_query_list_forms

This view selects user forms for the SaveToDB Connection Wizard and SaveToDB Query List.

Source tables: dbo25.dimensions, dbo25.form_dimensions, dbo25.form_permissions, dbo25.forms

ColumnDataTypeComment
TABLE_SCHEMAvarchar(5)Configured form schema: forms
TABLE_NAMEnvarchar(50)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.view_query_list_offline_forms

This view selects offline user forms for the SaveToDB Connection Wizard and SaveToDB Query List.

Source tables: dbo25.dimensions, dbo25.form_dimensions, dbo25.form_permissions, dbo25.forms

ColumnDataTypeComment
TABLE_SCHEMAvarchar(13)Configured offline form schema: offline_forms
TABLE_NAMEnvarchar(50)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.view_translations

This view selects translations of the forms configured in dbo25.forms.

Source tables: dbo25.dimensions, dbo25.form_dimensions, dbo25.forms, xls.translations

ColumnDataTypeComment
TABLE_SCHEMAvarchar(13)xls.translations.TABLE_SCHEMA
TABLE_NAMEnvarchar(50)xls.translations.TABLE_NAME
COLUMN_NAMEnvarchar(128)xls.translations.COLUMN_NAME
LANGUAGE_NAMEvarchar(2)xls.translations.LANGUAGE_NAME
TRANSLATED_NAMEnvarchar(255)xls.translations.TRANSLATED_NAME
TRANSLATED_DESCnvarchar(1024)xls.translations.TRANSLATED_DESC
TRANSLATED_COMMENTnvarchar(max)xls.translations.TRANSLATED_COMMENT

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

See also Configuring Data Translation.

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.