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 |