EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB30665: How to change the syntax with column names and table names by using "Column Pattern" VLDB property with MicroStrategy SQL Engine in MicroStrategy 2021


Community Admin

• Strategy


This article describes how to change the syntax for column names using the column pattern VLDB property

There is a method to change the default syntax for table and column names while generating Strategy SQL during report execution in Strategy by using VLDB properties. How to change the syntax is described in detail by using examples.
 
The default syntax can be modified by using 'Column Pattern' VLDB property. The 'Column Pattern' VLDB property can be found in Strategy Developer > Administration > Database Instance Manager > right click the Database Instance > VLDB Properties > Tables > 'Column Pattern'. 'Show Advanced Settings' needs to be enabled the VLDB properties manager (Tools > 'Show Advanced Settings') for viewing the 'Column Pattern' VLDB property. The placehoders are used to define which part of the SQL is the table name and which part is the column name.

ka0PW0000000sQDYAY_0EM440000002ERk.jpeg

 
EXAMPLE:
The syntax for the column pattern is defined as follows. The place holders are representing the components of the column for SQL generation:

1 Byte
WH or MD Database EncodingKANJISJIS_0SUTF8WHKANJISJIS_0SUTF8MDUTF8UTF8WH or MD Database EncodingKANJISJIS_0SUTF8WHKANJISJIS_0SUFT8MDUTF8UTF8Quarter_IDMonth_IDFact20061200601102006120060220200612006033020062200604402006220060550BIRDS OF A FEATHER 
Join industry-specific leaders and product experts to discuss common goals, challenges, and success stories. 
 
 BRING YOUR OWN LAPTOP
Engage in hands-on workshops from the convenience of your own laptop. 
 INDUSTRY TRENDS 
Gain a deeper understanding of the latest technologies and AI+BI trends, and why they matter. 
  
 CUSTOMER SUCCESS 
Learn directly from industry experts as they share the art of the possible. 
 Strategy 
Dive deep into the Strategy platform with our product experts to level-up your skills. 
  
 PARTNER 
Hear our partners share how they can transform your business with the latest technologies. 
 ConstantObject TypeObject DescriptionDssTypeUnknown-1Type of object is not specifiedDssTypeReserved0Never used, and all functions should check that zero(0) never pass for a type.DssTypeFilter1A restriction on the data in the warehouse (Filters)DssTypeTemplate2The layout of a report (Templates)DssTypeReportDefinition3Describes a report that can be executed (Reports)DssTypeMetric4A formula to be evaluated at a specific dimensionality (Metrics)Unused5NoneDssTypeAutostyles6A custom or predefined formatted layout for a report (Autostyle)DssTypeAggMetric7A formula to be evaluated at any dimensionality (Base Formulas)DssTypeFolder8A collection of objects (Folders)Unused9NoneDssTypePrompt10A method to prompt the user for information (Prompts)DssTypeFunction11A function that can be used to build expressions (Functions)DssTypeAttribute12A natural grouping of data (Attributes)DssTypeFact13A value that can be read directly from the warehouse (Facts)DssTypeDimension14A grouping of related attributes (Hierarchies)DssTypeTable15A logical table (Logical Table)Unused16NoneDssTypeFactGroup17A collection of related facts (Fact groups)DssTypeShortcut18Contains a reference to another DSS Object (Shortcuts)DssTypeResolution19A collection of answers to prompts (Prompt answers)Unused20NoneDssTypeAttributeForm21Represents a value on elements of an attribute (Attribute forms)DssTypeSchema22Collection of objects that define the warehouse structure (Schema)DssTypeFindObject23(Deprecated) Describes a simple search (Search definition)DssTypeCatalog24List of (relevant) tables in a database (Catalogs)DssTypeCatalogDefn25Describes how to construct a catalog (Catalog definitions)DssTypeColumn26The properties needed to define a column of a DB table (Columns)DssTypePropertyGroup27Used to cache lists of property sets (Internal Object)DssTypePropertySet28Holds the definition of a property set (Properties)DssTypeDBRole29Represents a logical database (Database Instance)DssTypeDBLogin30Describes how to login to a database (Database Login)DssTypeDBConnection31Describes how to connect to a database (Database Connection)DssTypeProject32A environment in which to perform OLAP analysis (Projects)DssTypeServerDef33A description of a configuration of a DSS Server (Server Definitions)DssTypeUser34Represents a user or group of users of the system (Groups / Users)Unused35NoneDssTypeConfiguration36Top level object - represents a Castor installation (Castor Server Config.)DssTypeRequest37Describes a DSS Server request (Scheduled requests)Unused38NoneDssTypeSearch39Describes criteria that specify a search for objects (Searches)DssTypeSearchFolder40Folder-like object used to store result of a search (Search Folders)Unused41NoneDssTypeFunctionPackageDefinition42Describes a package of functions (Functions Definitions)DssTypeRole43Placeholder to describe way of extending an attribute (Transformations)DssTypeSecurityRole44Holds privileges of a user that plays a certain role (Security Roles)DssTypeInBox45Shortcut to a folder (Shortcuts to folders)DssTypeInBoxMsg46Describes an uncollected report on a DSS Server (DSS Server Reports)DssTypeConsolidation47Collection of consolidation elements (Consolidations)DssTypeConsolidationElement48Arithmetic expression over elements (Consolidation elements)DssTypeScheduleEvent49An event that can trigger a scheduled report (Scheduled events)DssTypeScheduleObject50Something that can be triggered (Scheduled objects)DssTypeScheduleTrigger51Binding between schedule event and object (Scheduled triggers)DssTypeLink52Holder of a property that spans objects (Links)DssTypeDBTable53A physical table in a database (Physical tables)DssTypeTableSource54Physical tables with same suffix and prefix (Same suffix and prefix tables)DssTypeDocumentDefinition55An document built from reports and HTML text (Report Services Documents)DssTypeDrillMap56Describes a set of possible drill paths (Drill Maps)DssTypeDBMS57Holds information about a type of physical database (DBMS definition)DssTypeMDSecurityFilter58Holds filter restrictions that can be applied to a user (Security Filters)DssTypePromptAnswer59Holds single prompt answer informationDssTypePromptAnswers60Holds multiple prompt answer informationDssTypeGraphStyle61Holds grapth style information for report templatesDssTypeChangeJournalSearch62Holds information about Change Journal search objectsDssTypeBlob63Holds information about Blob imagesDssTypeDashboardTemplate64Describes templates used in dashboardsDssTypeFlag65Used to flag certain objects. The flag itself doesn't store the relationship, which is stored in link item insteadDssTypeChangeJournal66Holds a list of Change Journal entriesDssTypeExternalShortcut67A shortcut object whose target is ExternalShortcutTarget (rather than regular object)DssTypeExternalShortcutTarget68A transient object which is used to refer to external resource like web server fileDssTypeReconciliation69Identifies equivilent objects in two environments. Mainly used for dataset replacement.DssTypeLayer70Holds a collection of tables and attributes with their position infoDssTypePalette71Holds a collection of colorsDssTypeThresholds72Standalone thresholds object which holds a collection of tranditional thresholds structuresDssTypePersonalView73Holds user's manipulation on RWD and dashboard. (Personal View)DssTypeFeatureFlag74Holds the on/off/default state of a feature SQL syntax:TABLE_NAME  COLUMN_NAME VLDB place holder syntax: #0 #1

1 Byte
WH or MD Database EncodingKANJISJIS_0SUTF8WHKANJISJIS_0SUTF8MDUTF8UTF8WH or MD Database EncodingKANJISJIS_0SUTF8WHKANJISJIS_0SUFT8MDUTF8UTF8Quarter_IDMonth_IDFact20061200601102006120060220200612006033020062200604402006220060550BIRDS OF A FEATHER 
Join industry-specific leaders and product experts to discuss common goals, challenges, and success stories. 
 
 BRING YOUR OWN LAPTOP
Engage in hands-on workshops from the convenience of your own laptop. 
 INDUSTRY TRENDS 
Gain a deeper understanding of the latest technologies and AI+BI trends, and why they matter. 
  
 CUSTOMER SUCCESS 
Learn directly from industry experts as they share the art of the possible. 
 Strategy 
Dive deep into the Strategy platform with our product experts to level-up your skills. 
  
 PARTNER 
Hear our partners share how they can transform your business with the latest technologies. 
 ConstantObject TypeObject DescriptionDssTypeUnknown-1Type of object is not specifiedDssTypeReserved0Never used, and all functions should check that zero(0) never pass for a type.DssTypeFilter1A restriction on the data in the warehouse (Filters)DssTypeTemplate2The layout of a report (Templates)DssTypeReportDefinition3Describes a report that can be executed (Reports)DssTypeMetric4A formula to be evaluated at a specific dimensionality (Metrics)Unused5NoneDssTypeAutostyles6A custom or predefined formatted layout for a report (Autostyle)DssTypeAggMetric7A formula to be evaluated at any dimensionality (Base Formulas)DssTypeFolder8A collection of objects (Folders)Unused9NoneDssTypePrompt10A method to prompt the user for information (Prompts)DssTypeFunction11A function that can be used to build expressions (Functions)DssTypeAttribute12A natural grouping of data (Attributes)DssTypeFact13A value that can be read directly from the warehouse (Facts)DssTypeDimension14A grouping of related attributes (Hierarchies)DssTypeTable15A logical table (Logical Table)Unused16NoneDssTypeFactGroup17A collection of related facts (Fact groups)DssTypeShortcut18Contains a reference to another DSS Object (Shortcuts)DssTypeResolution19A collection of answers to prompts (Prompt answers)Unused20NoneDssTypeAttributeForm21Represents a value on elements of an attribute (Attribute forms)DssTypeSchema22Collection of objects that define the warehouse structure (Schema)DssTypeFindObject23(Deprecated) Describes a simple search (Search definition)DssTypeCatalog24List of (relevant) tables in a database (Catalogs)DssTypeCatalogDefn25Describes how to construct a catalog (Catalog definitions)DssTypeColumn26The properties needed to define a column of a DB table (Columns)DssTypePropertyGroup27Used to cache lists of property sets (Internal Object)DssTypePropertySet28Holds the definition of a property set (Properties)DssTypeDBRole29Represents a logical database (Database Instance)DssTypeDBLogin30Describes how to login to a database (Database Login)DssTypeDBConnection31Describes how to connect to a database (Database Connection)DssTypeProject32A environment in which to perform OLAP analysis (Projects)DssTypeServerDef33A description of a configuration of a DSS Server (Server Definitions)DssTypeUser34Represents a user or group of users of the system (Groups / Users)Unused35NoneDssTypeConfiguration36Top level object - represents a Castor installation (Castor Server Config.)DssTypeRequest37Describes a DSS Server request (Scheduled requests)Unused38NoneDssTypeSearch39Describes criteria that specify a search for objects (Searches)DssTypeSearchFolder40Folder-like object used to store result of a search (Search Folders)Unused41NoneDssTypeFunctionPackageDefinition42Describes a package of functions (Functions Definitions)DssTypeRole43Placeholder to describe way of extending an attribute (Transformations)DssTypeSecurityRole44Holds privileges of a user that plays a certain role (Security Roles)DssTypeInBox45Shortcut to a folder (Shortcuts to folders)DssTypeInBoxMsg46Describes an uncollected report on a DSS Server (DSS Server Reports)DssTypeConsolidation47Collection of consolidation elements (Consolidations)DssTypeConsolidationElement48Arithmetic expression over elements (Consolidation elements)DssTypeScheduleEvent49An event that can trigger a scheduled report (Scheduled events)DssTypeScheduleObject50Something that can be triggered (Scheduled objects)DssTypeScheduleTrigger51Binding between schedule event and object (Scheduled triggers)DssTypeLink52Holder of a property that spans objects (Links)DssTypeDBTable53A physical table in a database (Physical tables)DssTypeTableSource54Physical tables with same suffix and prefix (Same suffix and prefix tables)DssTypeDocumentDefinition55An document built from reports and HTML text (Report Services Documents)DssTypeDrillMap56Describes a set of possible drill paths (Drill Maps)DssTypeDBMS57Holds information about a type of physical database (DBMS definition)DssTypeMDSecurityFilter58Holds filter restrictions that can be applied to a user (Security Filters)DssTypePromptAnswer59Holds single prompt answer informationDssTypePromptAnswers60Holds multiple prompt answer informationDssTypeGraphStyle61Holds grapth style information for report templatesDssTypeChangeJournalSearch62Holds information about Change Journal search objectsDssTypeBlob63Holds information about Blob imagesDssTypeDashboardTemplate64Describes templates used in dashboardsDssTypeFlag65Used to flag certain objects. The flag itself doesn't store the relationship, which is stored in link item insteadDssTypeChangeJournal66Holds a list of Change Journal entriesDssTypeExternalShortcut67A shortcut object whose target is ExternalShortcutTarget (rather than regular object)DssTypeExternalShortcutTarget68A transient object which is used to refer to external resource like web server fileDssTypeReconciliation69Identifies equivilent objects in two environments. Mainly used for dataset replacement.DssTypeLayer70Holds a collection of tables and attributes with their position infoDssTypePalette71Holds a collection of colorsDssTypeThresholds72Standalone thresholds object which holds a collection of tranditional thresholds structuresDssTypePersonalView73Holds user's manipulation on RWD and dashboard. (Personal View)DssTypeFeatureFlag74Holds the on/off/default state of a feature SQL syntax:TABLE_NAME  COLUMN_NAME VLDB place holder syntax: #0 #1

1 Byte
WH or MD Database EncodingKANJISJIS_0SUTF8WHKANJISJIS_0SUTF8MDUTF8UTF8WH or MD Database EncodingKANJISJIS_0SUTF8WHKANJISJIS_0SUFT8MDUTF8UTF8Quarter_IDMonth_IDFact20061200601102006120060220200612006033020062200604402006220060550BIRDS OF A FEATHER 
Join industry-specific leaders and product experts to discuss common goals, challenges, and success stories. 
 
 BRING YOUR OWN LAPTOP
Engage in hands-on workshops from the convenience of your own laptop. 
 INDUSTRY TRENDS 
Gain a deeper understanding of the latest technologies and AI+BI trends, and why they matter. 
  
 CUSTOMER SUCCESS 
Learn directly from industry experts as they share the art of the possible. 
 Strategy 
Dive deep into the Strategy platform with our product experts to level-up your skills. 
  
 PARTNER 
Hear our partners share how they can transform your business with the latest technologies. 
 ConstantObject TypeObject DescriptionDssTypeUnknown-1Type of object is not specifiedDssTypeReserved0Never used, and all functions should check that zero(0) never pass for a type.DssTypeFilter1A restriction on the data in the warehouse (Filters)DssTypeTemplate2The layout of a report (Templates)DssTypeReportDefinition3Describes a report that can be executed (Reports)DssTypeMetric4A formula to be evaluated at a specific dimensionality (Metrics)Unused5NoneDssTypeAutostyles6A custom or predefined formatted layout for a report (Autostyle)DssTypeAggMetric7A formula to be evaluated at any dimensionality (Base Formulas)DssTypeFolder8A collection of objects (Folders)Unused9NoneDssTypePrompt10A method to prompt the user for information (Prompts)DssTypeFunction11A function that can be used to build expressions (Functions)DssTypeAttribute12A natural grouping of data (Attributes)DssTypeFact13A value that can be read directly from the warehouse (Facts)DssTypeDimension14A grouping of related attributes (Hierarchies)DssTypeTable15A logical table (Logical Table)Unused16NoneDssTypeFactGroup17A collection of related facts (Fact groups)DssTypeShortcut18Contains a reference to another DSS Object (Shortcuts)DssTypeResolution19A collection of answers to prompts (Prompt answers)Unused20NoneDssTypeAttributeForm21Represents a value on elements of an attribute (Attribute forms)DssTypeSchema22Collection of objects that define the warehouse structure (Schema)DssTypeFindObject23(Deprecated) Describes a simple search (Search definition)DssTypeCatalog24List of (relevant) tables in a database (Catalogs)DssTypeCatalogDefn25Describes how to construct a catalog (Catalog definitions)DssTypeColumn26The properties needed to define a column of a DB table (Columns)DssTypePropertyGroup27Used to cache lists of property sets (Internal Object)DssTypePropertySet28Holds the definition of a property set (Properties)DssTypeDBRole29Represents a logical database (Database Instance)DssTypeDBLogin30Describes how to login to a database (Database Login)DssTypeDBConnection31Describes how to connect to a database (Database Connection)DssTypeProject32A environment in which to perform OLAP analysis (Projects)DssTypeServerDef33A description of a configuration of a DSS Server (Server Definitions)DssTypeUser34Represents a user or group of users of the system (Groups / Users)Unused35NoneDssTypeConfiguration36Top level object - represents a Castor installation (Castor Server Config.)DssTypeRequest37Describes a DSS Server request (Scheduled requests)Unused38NoneDssTypeSearch39Describes criteria that specify a search for objects (Searches)DssTypeSearchFolder40Folder-like object used to store result of a search (Search Folders)Unused41NoneDssTypeFunctionPackageDefinition42Describes a package of functions (Functions Definitions)DssTypeRole43Placeholder to describe way of extending an attribute (Transformations)DssTypeSecurityRole44Holds privileges of a user that plays a certain role (Security Roles)DssTypeInBox45Shortcut to a folder (Shortcuts to folders)DssTypeInBoxMsg46Describes an uncollected report on a DSS Server (DSS Server Reports)DssTypeConsolidation47Collection of consolidation elements (Consolidations)DssTypeConsolidationElement48Arithmetic expression over elements (Consolidation elements)DssTypeScheduleEvent49An event that can trigger a scheduled report (Scheduled events)DssTypeScheduleObject50Something that can be triggered (Scheduled objects)DssTypeScheduleTrigger51Binding between schedule event and object (Scheduled triggers)DssTypeLink52Holder of a property that spans objects (Links)DssTypeDBTable53A physical table in a database (Physical tables)DssTypeTableSource54Physical tables with same suffix and prefix (Same suffix and prefix tables)DssTypeDocumentDefinition55An document built from reports and HTML text (Report Services Documents)DssTypeDrillMap56Describes a set of possible drill paths (Drill Maps)DssTypeDBMS57Holds information about a type of physical database (DBMS definition)DssTypeMDSecurityFilter58Holds filter restrictions that can be applied to a user (Security Filters)DssTypePromptAnswer59Holds single prompt answer informationDssTypePromptAnswers60Holds multiple prompt answer informationDssTypeGraphStyle61Holds grapth style information for report templatesDssTypeChangeJournalSearch62Holds information about Change Journal search objectsDssTypeBlob63Holds information about Blob imagesDssTypeDashboardTemplate64Describes templates used in dashboardsDssTypeFlag65Used to flag certain objects. The flag itself doesn't store the relationship, which is stored in link item insteadDssTypeChangeJournal66Holds a list of Change Journal entriesDssTypeExternalShortcut67A shortcut object whose target is ExternalShortcutTarget (rather than regular object)DssTypeExternalShortcutTarget68A transient object which is used to refer to external resource like web server fileDssTypeReconciliation69Identifies equivilent objects in two environments. Mainly used for dataset replacement.DssTypeLayer70Holds a collection of tables and attributes with their position infoDssTypePalette71Holds a collection of colorsDssTypeThresholds72Standalone thresholds object which holds a collection of tranditional thresholds structuresDssTypePersonalView73Holds user's manipulation on RWD and dashboard. (Personal View)DssTypeFeatureFlag74Holds the on/off/default state of a feature SQL syntax:TABLE_NAME  COLUMN_NAME VLDB place holder syntax: #0 #1

1 Byte
WH or MD Database EncodingKANJISJIS_0SUTF8WHKANJISJIS_0SUTF8MDUTF8UTF8WH or MD Database EncodingKANJISJIS_0SUTF8WHKANJISJIS_0SUFT8MDUTF8UTF8Quarter_IDMonth_IDFact20061200601102006120060220200612006033020062200604402006220060550BIRDS OF A FEATHER 
Join industry-specific leaders and product experts to discuss common goals, challenges, and success stories. 
 
 BRING YOUR OWN LAPTOP
Engage in hands-on workshops from the convenience of your own laptop. 
 INDUSTRY TRENDS 
Gain a deeper understanding of the latest technologies and AI+BI trends, and why they matter. 
  
 CUSTOMER SUCCESS 
Learn directly from industry experts as they share the art of the possible. 
 Strategy 
Dive deep into the Strategy platform with our product experts to level-up your skills. 
  
 PARTNER 
Hear our partners share how they can transform your business with the latest technologies. 
 ConstantObject TypeObject DescriptionDssTypeUnknown-1Type of object is not specifiedDssTypeReserved0Never used, and all functions should check that zero(0) never pass for a type.DssTypeFilter1A restriction on the data in the warehouse (Filters)DssTypeTemplate2The layout of a report (Templates)DssTypeReportDefinition3Describes a report that can be executed (Reports)DssTypeMetric4A formula to be evaluated at a specific dimensionality (Metrics)Unused5NoneDssTypeAutostyles6A custom or predefined formatted layout for a report (Autostyle)DssTypeAggMetric7A formula to be evaluated at any dimensionality (Base Formulas)DssTypeFolder8A collection of objects (Folders)Unused9NoneDssTypePrompt10A method to prompt the user for information (Prompts)DssTypeFunction11A function that can be used to build expressions (Functions)DssTypeAttribute12A natural grouping of data (Attributes)DssTypeFact13A value that can be read directly from the warehouse (Facts)DssTypeDimension14A grouping of related attributes (Hierarchies)DssTypeTable15A logical table (Logical Table)Unused16NoneDssTypeFactGroup17A collection of related facts (Fact groups)DssTypeShortcut18Contains a reference to another DSS Object (Shortcuts)DssTypeResolution19A collection of answers to prompts (Prompt answers)Unused20NoneDssTypeAttributeForm21Represents a value on elements of an attribute (Attribute forms)DssTypeSchema22Collection of objects that define the warehouse structure (Schema)DssTypeFindObject23(Deprecated) Describes a simple search (Search definition)DssTypeCatalog24List of (relevant) tables in a database (Catalogs)DssTypeCatalogDefn25Describes how to construct a catalog (Catalog definitions)DssTypeColumn26The properties needed to define a column of a DB table (Columns)DssTypePropertyGroup27Used to cache lists of property sets (Internal Object)DssTypePropertySet28Holds the definition of a property set (Properties)DssTypeDBRole29Represents a logical database (Database Instance)DssTypeDBLogin30Describes how to login to a database (Database Login)DssTypeDBConnection31Describes how to connect to a database (Database Connection)DssTypeProject32A environment in which to perform OLAP analysis (Projects)DssTypeServerDef33A description of a configuration of a DSS Server (Server Definitions)DssTypeUser34Represents a user or group of users of the system (Groups / Users)Unused35NoneDssTypeConfiguration36Top level object - represents a Castor installation (Castor Server Config.)DssTypeRequest37Describes a DSS Server request (Scheduled requests)Unused38NoneDssTypeSearch39Describes criteria that specify a search for objects (Searches)DssTypeSearchFolder40Folder-like object used to store result of a search (Search Folders)Unused41NoneDssTypeFunctionPackageDefinition42Describes a package of functions (Functions Definitions)DssTypeRole43Placeholder to describe way of extending an attribute (Transformations)DssTypeSecurityRole44Holds privileges of a user that plays a certain role (Security Roles)DssTypeInBox45Shortcut to a folder (Shortcuts to folders)DssTypeInBoxMsg46Describes an uncollected report on a DSS Server (DSS Server Reports)DssTypeConsolidation47Collection of consolidation elements (Consolidations)DssTypeConsolidationElement48Arithmetic expression over elements (Consolidation elements)DssTypeScheduleEvent49An event that can trigger a scheduled report (Scheduled events)DssTypeScheduleObject50Something that can be triggered (Scheduled objects)DssTypeScheduleTrigger51Binding between schedule event and object (Scheduled triggers)DssTypeLink52Holder of a property that spans objects (Links)DssTypeDBTable53A physical table in a database (Physical tables)DssTypeTableSource54Physical tables with same suffix and prefix (Same suffix and prefix tables)DssTypeDocumentDefinition55An document built from reports and HTML text (Report Services Documents)DssTypeDrillMap56Describes a set of possible drill paths (Drill Maps)DssTypeDBMS57Holds information about a type of physical database (DBMS definition)DssTypeMDSecurityFilter58Holds filter restrictions that can be applied to a user (Security Filters)DssTypePromptAnswer59Holds single prompt answer informationDssTypePromptAnswers60Holds multiple prompt answer informationDssTypeGraphStyle61Holds grapth style information for report templatesDssTypeChangeJournalSearch62Holds information about Change Journal search objectsDssTypeBlob63Holds information about Blob imagesDssTypeDashboardTemplate64Describes templates used in dashboardsDssTypeFlag65Used to flag certain objects. The flag itself doesn't store the relationship, which is stored in link item insteadDssTypeChangeJournal66Holds a list of Change Journal entriesDssTypeExternalShortcut67A shortcut object whose target is ExternalShortcutTarget (rather than regular object)DssTypeExternalShortcutTarget68A transient object which is used to refer to external resource like web server fileDssTypeReconciliation69Identifies equivilent objects in two environments. Mainly used for dataset replacement.DssTypeLayer70Holds a collection of tables and attributes with their position infoDssTypePalette71Holds a collection of colorsDssTypeThresholds72Standalone thresholds object which holds a collection of tranditional thresholds structuresDssTypePersonalView73Holds user's manipulation on RWD and dashboard. (Personal View)DssTypeFeatureFlag74Holds the on/off/default state of a feature SQL syntax:TABLE_NAME  COLUMN_NAME VLDB place holder syntax: #0 #1

1 Byte
WH or MD Database EncodingKANJISJIS_0SUTF8WHKANJISJIS_0SUTF8MDUTF8UTF8WH or MD Database EncodingKANJISJIS_0SUTF8WHKANJISJIS_0SUFT8MDUTF8UTF8Quarter_IDMonth_IDFact20061200601102006120060220200612006033020062200604402006220060550BIRDS OF A FEATHER 
Join industry-specific leaders and product experts to discuss common goals, challenges, and success stories. 
 
 BRING YOUR OWN LAPTOP
Engage in hands-on workshops from the convenience of your own laptop. 
 INDUSTRY TRENDS 
Gain a deeper understanding of the latest technologies and AI+BI trends, and why they matter. 
  
 CUSTOMER SUCCESS 
Learn directly from industry experts as they share the art of the possible. 
 Strategy 
Dive deep into the Strategy platform with our product experts to level-up your skills. 
  
 PARTNER 
Hear our partners share how they can transform your business with the latest technologies. 
 ConstantObject TypeObject DescriptionDssTypeUnknown-1Type of object is not specifiedDssTypeReserved0Never used, and all functions should check that zero(0) never pass for a type.DssTypeFilter1A restriction on the data in the warehouse (Filters)DssTypeTemplate2The layout of a report (Templates)DssTypeReportDefinition3Describes a report that can be executed (Reports)DssTypeMetric4A formula to be evaluated at a specific dimensionality (Metrics)Unused5NoneDssTypeAutostyles6A custom or predefined formatted layout for a report (Autostyle)DssTypeAggMetric7A formula to be evaluated at any dimensionality (Base Formulas)DssTypeFolder8A collection of objects (Folders)Unused9NoneDssTypePrompt10A method to prompt the user for information (Prompts)DssTypeFunction11A function that can be used to build expressions (Functions)DssTypeAttribute12A natural grouping of data (Attributes)DssTypeFact13A value that can be read directly from the warehouse (Facts)DssTypeDimension14A grouping of related attributes (Hierarchies)DssTypeTable15A logical table (Logical Table)Unused16NoneDssTypeFactGroup17A collection of related facts (Fact groups)DssTypeShortcut18Contains a reference to another DSS Object (Shortcuts)DssTypeResolution19A collection of answers to prompts (Prompt answers)Unused20NoneDssTypeAttributeForm21Represents a value on elements of an attribute (Attribute forms)DssTypeSchema22Collection of objects that define the warehouse structure (Schema)DssTypeFindObject23(Deprecated) Describes a simple search (Search definition)DssTypeCatalog24List of (relevant) tables in a database (Catalogs)DssTypeCatalogDefn25Describes how to construct a catalog (Catalog definitions)DssTypeColumn26The properties needed to define a column of a DB table (Columns)DssTypePropertyGroup27Used to cache lists of property sets (Internal Object)DssTypePropertySet28Holds the definition of a property set (Properties)DssTypeDBRole29Represents a logical database (Database Instance)DssTypeDBLogin30Describes how to login to a database (Database Login)DssTypeDBConnection31Describes how to connect to a database (Database Connection)DssTypeProject32A environment in which to perform OLAP analysis (Projects)DssTypeServerDef33A description of a configuration of a DSS Server (Server Definitions)DssTypeUser34Represents a user or group of users of the system (Groups / Users)Unused35NoneDssTypeConfiguration36Top level object - represents a Castor installation (Castor Server Config.)DssTypeRequest37Describes a DSS Server request (Scheduled requests)Unused38NoneDssTypeSearch39Describes criteria that specify a search for objects (Searches)DssTypeSearchFolder40Folder-like object used to store result of a search (Search Folders)Unused41NoneDssTypeFunctionPackageDefinition42Describes a package of functions (Functions Definitions)DssTypeRole43Placeholder to describe way of extending an attribute (Transformations)DssTypeSecurityRole44Holds privileges of a user that plays a certain role (Security Roles)DssTypeInBox45Shortcut to a folder (Shortcuts to folders)DssTypeInBoxMsg46Describes an uncollected report on a DSS Server (DSS Server Reports)DssTypeConsolidation47Collection of consolidation elements (Consolidations)DssTypeConsolidationElement48Arithmetic expression over elements (Consolidation elements)DssTypeScheduleEvent49An event that can trigger a scheduled report (Scheduled events)DssTypeScheduleObject50Something that can be triggered (Scheduled objects)DssTypeScheduleTrigger51Binding between schedule event and object (Scheduled triggers)DssTypeLink52Holder of a property that spans objects (Links)DssTypeDBTable53A physical table in a database (Physical tables)DssTypeTableSource54Physical tables with same suffix and prefix (Same suffix and prefix tables)DssTypeDocumentDefinition55An document built from reports and HTML text (Report Services Documents)DssTypeDrillMap56Describes a set of possible drill paths (Drill Maps)DssTypeDBMS57Holds information about a type of physical database (DBMS definition)DssTypeMDSecurityFilter58Holds filter restrictions that can be applied to a user (Security Filters)DssTypePromptAnswer59Holds single prompt answer informationDssTypePromptAnswers60Holds multiple prompt answer informationDssTypeGraphStyle61Holds grapth style information for report templatesDssTypeChangeJournalSearch62Holds information about Change Journal search objectsDssTypeBlob63Holds information about Blob imagesDssTypeDashboardTemplate64Describes templates used in dashboardsDssTypeFlag65Used to flag certain objects. The flag itself doesn't store the relationship, which is stored in link item insteadDssTypeChangeJournal66Holds a list of Change Journal entriesDssTypeExternalShortcut67A shortcut object whose target is ExternalShortcutTarget (rather than regular object)DssTypeExternalShortcutTarget68A transient object which is used to refer to external resource like web server fileDssTypeReconciliation69Identifies equivilent objects in two environments. Mainly used for dataset replacement.DssTypeLayer70Holds a collection of tables and attributes with their position infoDssTypePalette71Holds a collection of colorsDssTypeThresholds72Standalone thresholds object which holds a collection of tranditional thresholds structuresDssTypePersonalView73Holds user's manipulation on RWD and dashboard. (Personal View)DssTypeFeatureFlag74Holds the on/off/default state of a feature SQL syntax:TABLE_NAME  COLUMN_NAME VLDB place holder syntax: #0 #1

1 Byte
WH or MD Database EncodingKANJISJIS_0SUTF8WHKANJISJIS_0SUTF8MDUTF8UTF8WH or MD Database EncodingKANJISJIS_0SUTF8WHKANJISJIS_0SUFT8MDUTF8UTF8Quarter_IDMonth_IDFact20061200601102006120060220200612006033020062200604402006220060550BIRDS OF A FEATHER 
Join industry-specific leaders and product experts to discuss common goals, challenges, and success stories. 
 
 BRING YOUR OWN LAPTOP
Engage in hands-on workshops from the convenience of your own laptop. 
 INDUSTRY TRENDS 
Gain a deeper understanding of the latest technologies and AI+BI trends, and why they matter. 
  
 CUSTOMER SUCCESS 
Learn directly from industry experts as they share the art of the possible. 
 Strategy 
Dive deep into the Strategy platform with our product experts to level-up your skills. 
  
 PARTNER 
Hear our partners share how they can transform your business with the latest technologies. 
 ConstantObject TypeObject DescriptionDssTypeUnknown-1Type of object is not specifiedDssTypeReserved0Never used, and all functions should check that zero(0) never pass for a type.DssTypeFilter1A restriction on the data in the warehouse (Filters)DssTypeTemplate2The layout of a report (Templates)DssTypeReportDefinition3Describes a report that can be executed (Reports)DssTypeMetric4A formula to be evaluated at a specific dimensionality (Metrics)Unused5NoneDssTypeAutostyles6A custom or predefined formatted layout for a report (Autostyle)DssTypeAggMetric7A formula to be evaluated at any dimensionality (Base Formulas)DssTypeFolder8A collection of objects (Folders)Unused9NoneDssTypePrompt10A method to prompt the user for information (Prompts)DssTypeFunction11A function that can be used to build expressions (Functions)DssTypeAttribute12A natural grouping of data (Attributes)DssTypeFact13A value that can be read directly from the warehouse (Facts)DssTypeDimension14A grouping of related attributes (Hierarchies)DssTypeTable15A logical table (Logical Table)Unused16NoneDssTypeFactGroup17A collection of related facts (Fact groups)DssTypeShortcut18Contains a reference to another DSS Object (Shortcuts)DssTypeResolution19A collection of answers to prompts (Prompt answers)Unused20NoneDssTypeAttributeForm21Represents a value on elements of an attribute (Attribute forms)DssTypeSchema22Collection of objects that define the warehouse structure (Schema)DssTypeFindObject23(Deprecated) Describes a simple search (Search definition)DssTypeCatalog24List of (relevant) tables in a database (Catalogs)DssTypeCatalogDefn25Describes how to construct a catalog (Catalog definitions)DssTypeColumn26The properties needed to define a column of a DB table (Columns)DssTypePropertyGroup27Used to cache lists of property sets (Internal Object)DssTypePropertySet28Holds the definition of a property set (Properties)DssTypeDBRole29Represents a logical database (Database Instance)DssTypeDBLogin30Describes how to login to a database (Database Login)DssTypeDBConnection31Describes how to connect to a database (Database Connection)DssTypeProject32A environment in which to perform OLAP analysis (Projects)DssTypeServerDef33A description of a configuration of a DSS Server (Server Definitions)DssTypeUser34Represents a user or group of users of the system (Groups / Users)Unused35NoneDssTypeConfiguration36Top level object - represents a Castor installation (Castor Server Config.)DssTypeRequest37Describes a DSS Server request (Scheduled requests)Unused38NoneDssTypeSearch39Describes criteria that specify a search for objects (Searches)DssTypeSearchFolder40Folder-like object used to store result of a search (Search Folders)Unused41NoneDssTypeFunctionPackageDefinition42Describes a package of functions (Functions Definitions)DssTypeRole43Placeholder to describe way of extending an attribute (Transformations)DssTypeSecurityRole44Holds privileges of a user that plays a certain role (Security Roles)DssTypeInBox45Shortcut to a folder (Shortcuts to folders)DssTypeInBoxMsg46Describes an uncollected report on a DSS Server (DSS Server Reports)DssTypeConsolidation47Collection of consolidation elements (Consolidations)DssTypeConsolidationElement48Arithmetic expression over elements (Consolidation elements)DssTypeScheduleEvent49An event that can trigger a scheduled report (Scheduled events)DssTypeScheduleObject50Something that can be triggered (Scheduled objects)DssTypeScheduleTrigger51Binding between schedule event and object (Scheduled triggers)DssTypeLink52Holder of a property that spans objects (Links)DssTypeDBTable53A physical table in a database (Physical tables)DssTypeTableSource54Physical tables with same suffix and prefix (Same suffix and prefix tables)DssTypeDocumentDefinition55An document built from reports and HTML text (Report Services Documents)DssTypeDrillMap56Describes a set of possible drill paths (Drill Maps)DssTypeDBMS57Holds information about a type of physical database (DBMS definition)DssTypeMDSecurityFilter58Holds filter restrictions that can be applied to a user (Security Filters)DssTypePromptAnswer59Holds single prompt answer informationDssTypePromptAnswers60Holds multiple prompt answer informationDssTypeGraphStyle61Holds grapth style information for report templatesDssTypeChangeJournalSearch62Holds information about Change Journal search objectsDssTypeBlob63Holds information about Blob imagesDssTypeDashboardTemplate64Describes templates used in dashboardsDssTypeFlag65Used to flag certain objects. The flag itself doesn't store the relationship, which is stored in link item insteadDssTypeChangeJournal66Holds a list of Change Journal entriesDssTypeExternalShortcut67A shortcut object whose target is ExternalShortcutTarget (rather than regular object)DssTypeExternalShortcutTarget68A transient object which is used to refer to external resource like web server fileDssTypeReconciliation69Identifies equivilent objects in two environments. Mainly used for dataset replacement.DssTypeLayer70Holds a collection of tables and attributes with their position infoDssTypePalette71Holds a collection of colorsDssTypeThresholds72Standalone thresholds object which holds a collection of tranditional thresholds structuresDssTypePersonalView73Holds user's manipulation on RWD and dashboard. (Personal View)DssTypeFeatureFlag74Holds the on/off/default state of a feature SQL syntax:TABLE_NAME  COLUMN_NAME VLDB place holder syntax: #0 #1

 
 
As an example it is shown how to add double quotes around the Table Name' and 'Column Name' while generating SQL for Strategy reports.
 
Example 1.
In the first example there are no double quotes around the column and table (#0.#1), this is the default syntax generated.

ka0PW0000000sQDYAY_0EM440000002ERm.jpeg

 
Sql generated:
select a11.COLUMN_NAME1  COLUMN_ID,
 sum(a11.COLUMN_NAME2)  WJXBFS1
from TABLE_NAME a11
group by a11.COLUMN_NAME1
 
Example 2.
The second example shows how double quotes are added around the table and column name ("#0"."#1"). Also brackets or other symbols can be used to change syntax if required.

ka0PW0000000sQDYAY_0EM440000002ERq.jpeg

 
Sql generated
select "a11"."COLUMN_NAME1"  COLUMN_ID,
 sum("a11"."COLUMN_NAME2")  WJXBFS1
from TABLE_NAME a11
group by "a11"."COLUMN_NAME1"
 
 


Comment

0 comments

Details

Knowledge Article

Published:

April 14, 2017

Last Updated:

February 26, 2024