Objects that are not visible in IBM Cognos 10. Properties are typically not localizable. Specifies a name for the parent object. Objects that are visible in IBM Cognos 10. Properties are typically localizable NOTE: if a property is localizable, there must be exactly one instance of it for each locale supported in this model (see project/locales). The name of an object. The local attribute indicates the language of the name value. Specifies a name for the parent object. Provides a text-based description for the parent element in the specified language. Defines the text that will be displayed when a user passes the cursor over an interface element. Text should be specific to the language of the locale attribute. Specifies the status of the resolution of a relationship. *** work around Engine limitation *** The type of prompt control to be used when prompting for a value for this item. Note: For SAP BW, selectWithSearch, selectDateTime, and selectInterval prompt types are not supported. The selectTime prompt type should only be used for SAP BW query items (facts) of type time. If prompted for, a preceding prompt is generated for each of the referenced query items. If prompted for, one or more of the referenced objects is used as the display value of the prompt control. If automatic filters are generated for this object, they will actually be created on the referenced objects. If prompted for, one or more of the referenced objects is used as the prompt value(s). Defines the search path in displayable form. Specifies that the property is of the indicated type. Specifies that the securityObject is an account. Specifies that the securityObject is a group. Specifies that the securityObject is a role. First item is the major sort key. Those that follow are progressively more minor sort keys. Must contain a reference to a query item within the level. Ascending or descending sort rule. NULLs are always at the end. sort in ascending order sort in descending order Placement of NULLs, either first, last, or depending on the underlying database. For most databases NULLS LAST is the default for ascending order, and NULLS FIRST is the default for descending order. Placement of NULLs is not specified NULL appear first in the sort order NULLs appear last in the sort order If true, this package is RESERVED for specifying object security by role. There is one package for each role for which object security has been set. The package must have exactly one security view that specifies the role. For that role, each object referenced by that security view has visibility opposite to the normal state, in all normal packages published for this model. For more information, see the secured property. If true, this package is RESERVED for specifying object security by role. There is one package for each role for which object security has been set. The package must have exactly one security view that specifies the role. For that role, each object referenced by that security view has visibility opposite to the normal state, in all normal packages published for this model. For more information, see the secured property. If set to true, the object is hidden in all published packages. Note: For SAP BW data sources, the folder that contains the surrogate keys should have its hidden property set to true. A filter, which at execution time must be AND'ed with the filter in the object that has the matching securityObject. References an object. Specifies the name that will be displayed to the user for the parent object. Specifies a name for the property. Specifies a type for the property. Specifies the type for this object as blob. Specifies the type for this object as boolean. Specifies that the type for this object is composed of a combination of types. Specifies that this object represents a date and time. Specifies that this object is an enumeration. Specifies that this object is hidden. Specifies the type for this object as numeric. Specifies that this object is read only. Specifies that this object is a reference. Specifies the type for this object as string. Specifies the status of the execution of a query. The queryItems being referenced must belong to the same querySubject. When a parameterMap has been defined, the query looks for this unique identifier when it executes and returns the value in the valueRef element. When a parameterMap has been defined, and the unique identifier (keyRef) has been found by the query, this value gets returned when the query executes. Defines a column in the specified database. Defines a database table. Note: Not applicable to models based on SAP BW data sources. Specifies the level of flexibility the system is allowed in optimizing the SQL from this element, before presenting it to the data source. Cognos SQL can be optimized by the system and combined with other SQL before being sent to the data source. OBSOLETE OBSOLETE OBSOLETE OBSOLETE OBSOLETE: synonym for native. Native SQL cannot be modified except by macro substitution, but can be combined with other SQL into a single SQL query to send to the data source. Pass-through SQL cannot be modified except by macro substitution, and cannot be combined with other SQL. It must be sent to the data source as a stand-alone query. However, results can be combined with results of other queries. Describes the syntax that is required by a function. Specifies the name by which an object is known in the database or plug-in. Contains the value resulting from the execution of a function. References a function. RESERVED for future use. References an object. References an object. The minimum number (cardinality) of rows that will match this end of the relationship. Normally zero or one. The maximum number (cardinality) of rows that will match this end of the relationship. The value is normally one or many. References an object. References an object. The element tag name (type) of the object that is referenced by refobj. The shortcut acts as a namespace for object naming purposes if and only if targetType is namespace, folder, or function. Specifies the CQE behaviour for the shortcut alias - shortcut will be treated as an alias table in the generated sql reference - (default) shortcut will be treated as a simple reference to the target object. Related with the contextSensitiveJoinSelection governor, when the setting is explicit If set to true, the shortcut will be used in the joinPath References the left object in a relationship. References an object. References the right object in a relationship. References an object. References a relationship. Specifies the locale that applies to the parent object. Determines what degree of local processing is allowed. Note: For SAP BW data sources in this release, this object is ignored but should be set to databaseOnly. The database server does all the SQL processing and execution. A run-time error will appear if any part of the query relating to this data source requires local SQL processing (that is, on the report server). The database server does as much of the SQL processing and execution as possible. The remainder is done on the report server. Determines whether aggregate rollups above the lowest level are computed locally or in the database. The default is set to local if local query processing is enabled, and is set to database otherwise. Note: Not applicable for SAP BW data sources. The aggregation rollup is not specified. All aggregation rollups are computed locally (in the report server) using a running aggregate (for example, RSUM). Running aggregates spread the cost of this computation as the data is retrieved. Use this option if the local computer has more idle resources than the database computer, or if you find through experiment that it is the fastest method. Aggregation rollups are computed by the underlying database software if possible. Otherwise, they are computed locally (provided local query processing is enabled). Running aggregates are used, but the cost is incurred by the database server instead of the report server. Use this option if the database computer has more idle resources than the local computer, or if you find through experiment that it is the fastest method. All aggregation rollups are computed by the database server using an extended aggregate (for example, XSUM). Extended aggregates incur the entire cost of this computation up front. Typically, this is the fastest method, but only where the database is set up to take advantage of materialized views. For databases where OLAP functionality is supported, this is translated into the appropriate OLAP aggregate functions. Specifies the access mode of a new transaction. Specifies that a new transaction will be started in the default mode. In CQM, the default mode is 'read-only'. Specifies that a new transaction will be started in 'read-only' mode. Specifies that a new transaction will be started in 'read-write' mode. Specifies the action to be taken when a transaction ends. Specifies that the default action will be taken when a transaction ends. In CQM, the default action is 'rollback'. If the underlying database supports 'autocommit', then the default action will be 'commit'. Specifies that a transaction will be rolled back when it ends. Specifies that a transaction will be committed when it ends. Specifies that autocommit will be carried out for a transaction. Specifies the null value sorting order. Specifies that the default action will be taken when sorting null value. The default behavior is the default database vendor behavior. Specifies that nulls first when ascending, null last when descending. Specifies that nulls last when ascending, null first when descending. Specifies that null always first no matter ascending or descending. Specifies that null always last no matter ascending or descending. Specifies the name of the dataSource in Content Manager. It may be parameterized. A hierarchical element that can represent different information for different databases or that may not be used at all. For example, if the database is SQL Server, the element contains the name of the database, and if the database is Oracle, it is not used. Note: For SAP BW data sources, this is the catalog name returned by MDDataProviderBW::GetCatalogs. The internal name of the cube. A hierarchical element that can represent different information for different databases, or that may not be used at all. For example, for SQL server or Oracle, the element contains the name of the owner. Note: For SAP BW data sources, assign this object a value of SAP_BW. Specifies the type for a given parent object. The type of query model that this data source understands. SQL sources are relational. MDS sources are multidimensional. Note: For SAP BW data sources, the value is multidimensional. RESERVED for internal use. Element is maintained by the application. Note: For SAP BW data sources, set the value to BW. Defines the function set that applies to a data source. Used in the initial population of the functionSets of a securityView when a package is created. To view or edit the list of available function sets, refer to the FileList.xml file, located in the install-location\bin\configuration\functions directory on the server where Framework Manager is installed. Note: For SAP BW data sources, set the value to V_SAPBW. Defines the connection string in the form required for UDA, to a data source. If defined, takes precedence any string defined in Content Manager. References a parameterMap that represents a DB2OLAP or Applix alias table map. The description of the cube. The full qualified path to the cube. The date time that the cube was created. The date time that data in the cube was last updated. The date time that the cube schema was last updated. Returns true if the cube is optimized. The name of the default measure for the cube. The current period for the cube. Specifies the behavior of the suppression in the studios (setting the default mode of their sparsity removal capability). The suppression is not specified. The studio will suppress empty cells only. The studio will suppress zero cells only. The studio will suppress both zero and empty cells. "True" means Essbase attribute dimensions are to be presented as properties of other dimensions. It is set to "false" if Essbase attribute dimensions are to be presented as separate dimensions. Specifies a name for the parent object. A list of query items that together uniquely identify row value sets in a query subject. Defines a query against the specified database. Note: Not supported for multidimensional data sources, including SAP BW. Only one data source is allowed if sql/@type is native. Note: Not applicable to models based on SAP BW data sources. Deprecated functionality will be covered by determinants. **** Will be deprecated functionality will be covered by determinants Deprecated functionality will be covered by determinants. If true, the indexed values are unique. Note: Not applicable to models based on SAP BW data sources. A list of query items that together uniquely identify row value sets in a query subject. Defines the type of the underling table on which the query subject is based. The type can be a table, a view, or unknown. Used by the query engine for fetching a blob. Specifies the table as a table. Specifies the table as a view. Specifies the table as non-transparent. Specifies that the table type is not known. Specifies that the database definition references multiple databases. A query for a multidimensional data source. Note: An mdQuery object provides additional metadata required for modeling multidimensional query subjects. Only one data source is allowed if sql/@type is native. Note: Not applicable to models based on SAP BW data sources. A representation of the data components that reflect specific business structures. Typically, a dimension is a nested representation of a business concept. Note: For SAP BW, the value of this object is the unique name of the dimension as obtained from MDDataProviderBW::GetDimensions. A query that references metadata in the model; it does not directly reference a data source. A read-only cache of the SQL that results from planning the model query. It is updated every time the modelQuery changes, and can be used as a backup if the dependant model objects are lost. Note: Not applicable to models based on SAP BW data sources. RESERVED for future use. Defines a relationship. References an object. RESERVED for future use. Specifies the name, data source, parameters, and type of a procedure stored in the database. Note: Not applicable to models based on SAP BW data sources. A query that represents the union or intersection of two query subjects. Note: This does not apply to dimensions. References two query subjects to be included in the set. Defines the unique identifier for the object. The value that gets returned when the parameter map locates the key value. Specifies the value to use if no key match is found. If not set, external sources for parameterMaps of this name may be searched. During macro evaluation, the parameter map will be reloaded if it was loaded more than the specified number of seconds ago. The default is -1, which means that the data will be loaded only once. When set to true, then the map will be loaded one key-value at a time, when a key-ed accesses is made. When a getAllEntries access is made, then this flag is ignored. Specifies that the object is an entry in a parameter map. Specifies that the set of entries in the parameterMap is based on two queryItem references: one represents the set of keys, and the second represents the set of values. Specifies whether or not the parameterMap element is hidden. Represents a locale that is available for reports based on a package or a project. A locale should not be added to this list until all objects have been translated into the language for the locale. Specifies the status of the resolution of a calculation. Note: The result type of a filter expression must be Boolean. Specifies the status of the resolution of a filter. Captures the relationship between a key and the attributes uniquely described by the key. An arbitrary name to identify the determinate. Initially generated during import and modifiable by the user. Determinants must have a unique name. Unilingual name to identify the determinant used only by FMUI. The key is a reference to one or more query items that uniquely identifies the referenced attributes within the query subject. A collection of query items that are uniquely identified by the key. When set to true, indicates that the query items referenced by the determinant will be grouped by the determinate key. When set to true, it means that the key can uniquely identify a row. Captures the relationship between a key and the attributes uniquely described by the key. Specifies a name for the parent object. A string that identifies this object in the external data source. Note: For SAP BW, the value of this object is the unique name of the level as obtained from MDDataProviderBW::GetLevels. Represents the identifier for this level. For example, month or number. Note: For SAP BW, the level number is obtained from MDDataProviderBW::GetLevels. References a key within a query subject. Note: Represents the key name only; it is not an object reference. Defines the unique identifier for the object. Note: For SAP BW data sources, the key for a level references the query item that represents the level identifier. The isUnique attribute should be set to true. Specifies whether or not the key is unique. A collection of queryItems that provide additional information for the level, but do not identify it. For example, the names of the months in different languages. Note: The collection of attributes for the level of an SAP BW hierarchy contains the properties associated with the level, as indicated by MDDataProviderBW::GetProperties. Specifies a name for the parent object. A string that identifies the object in the external data source. Note: For SAP BW, the value of this object is the unique name of the hierarchy as obtained from MDDataProviderBW::GetHierarchies. Represents the identifier for this hierarchy. For example, month or number. Note: For SAP BW, the hierchary number is obtained from MDDataProviderBW::GetHierarchies. Represents an ordered list of levels. For example: year, month, or day. Text that may contain macro substitutions. This syntax is defined in the Framework Manager User Guide. References an object. Specifies whether or not objects in the set are included, excluded, or hidden. Specifies that the set represents objects that are to be included. Specifies that the set represents objects that are to be hidden. Specifies that the set represents objects that are to be excluded. TO DO This needs to be normalized with the relationship object. References either a measure or regular dimension. points to the dimension References either a measure or a regular dimension. Points to the measure dimension. Defines the level to measure scope. In order for there to be a scopeAssociation there must be at least one level to measure scope. This element is optional, and when not supplied implies that all measures scope to the leaf level of the dimension. References a level within a dimension. References a measure to which the measure scope applies. (FUTURE) defines the rollup to be applied within this scope. It overrides any rollup defined in the measure, the dimension, or in the underling query subject item for the measure. (FUTURE) allocation type of levels under the level defined under the left element. References a measure in a measure dimension. References a measure or a reference to the entire measures dimension. If the reference is to a measure dimension then it implies that the scope applies to all measures within the dimension. If set true, then the measure is excluded from the hierarchy implied in the levelRef property. Specifies that the prompt will be determined by the server during execution. Specifies that the prompt will be displayed as an edit box. Specifies that the prompt will display a selectable date. Specifies that the prompt will display a selectable date and time. Specifies that the prompt will display a selectable interval. Specifies that the prompt will display a selectable time. Specifies that the prompt will display a list of values from which the user can select. Specifies that the prompt will be displayed as a user-defined search. Note: Not applicable to a queryItem where usage is set to fact. The additive aggregation rule. Unless otherwise specified, zero and NULL values are included in calculating the result. Aggregation is not supported for this object. Aggregation is unknown for this object. Aggregation is computed as an average of the values in the result set for this object. The aggregation rule is determined automatically at run time. Wherever possible, calculated is used, then sum where necessary, followed by unsupported. Aggregated values are computed by aggregating the elements of the expression rather than the result. For example, if the aggregate rule for Q1_a is set to sum, and the rule for q1_b is set to average, then if this query item is based on the expression (QI_a / QI_b) * 100, the aggregate is computed as: ( sum(QI_a) / average( QI_b ) ) * 100. Aggregation is computed as a count of the items in the result set for this object. Aggregation is computed as a count of unique items in the result set for this object. Excludes zero and NULL values. Aggregation determines the maximum value in the result set for this object. Aggregation determines the median value in the result set for this object. Aggregation determines the minimum value in the result set for this object. Aggregation determines the standard deviation in the result set for this object. Aggregation determines the sum of the values in the result set for this object. Aggregation determines the variance in the result set for this object. Specifies that the maximum number of rows is not known. Specifies that this feature is not supported. Specifies that this object has no rows. Specifies that this object has one row only. Specifies that this object can have many rows. A reference to an FDS function set. Specifies that the syntax of the object is valid. Specifies that the syntax of the object is not valid. Specifies that the object syntax needs to be reviewed. Specifies that the filter is applied before autoAggregation. Specifies that the filter is applied after autoAggregation. A container for procParameter elements. Defines a parameter required to call a stored procedure or function. Used to determine whether an expression that uses the stored procedure or function is valid. The value of the parameter is supplied from the expression that uses this function or stored procedure. Note: SAP BW does not support stored procedures and therefore this object should not form part of a Framework Manager model based on an SAP BW data source. The value to be passed when the procedure is called. Specifies the name by which an object is known in the database or plug-in. Specifies the type for a given parent object. Specifies that the type is not known. Specifies the type as procedure. Specifies the type as something other than a procedure. External name as found in the datasource that this hierarchy represents. This is only applicable for OLAP sources. A string that identifies this object in the external data source. Note: For SAP BW, the value of this object is the unique name of the level as obtained from MDDataProviderBW::GetLevels. Indicates to OQP if a hierarchy has a single root member, or has multiple members at the highest level. This affects the generated MDX. A balanced hierarchy contains no skipped or empty levels. All branches of the dimension hierarchy tree descend through all existing levels, and each level has at least one member. All members at a given level have the same number of ancestors. The only conceptual difference between a ragged and an unbalanced hierarchy is the fact that branches of a ragged hierarchy descend through all existing levels, even levels that do not contain data. Indicates if the members at each level of a hierarchy are sorted: asc, desc, none. Used by OQP to optimize query generation in the presence of user-specified sorts. Number of nodes/members/categories in a hierarchy. Used by OQP to assign solve orders to expressions. Indicates that the hierarchy is a collection of members arranged in a parent-child hierarchy. Number of levels in a hierarchy. This property is hidden. It is used by OQP to determine which levels are included in the model when constructing the query spec for the RootMembers function. When true indicates that one or more members may have a large number of child members. In some cases this will trigger an optimization that executes more than one query to populate a dynamic cube. A container object for previewFilter elements. A filter that is applied at execution time when the report or model is being used in design mode. It is not applied when the report is run. References an object. Specifies the name that will be displayed to the user for the parent object. Specifies if the filter is applied before or after autoAggregation. At execution time, all filters that match the security objects for this session are applied, combined by OR. Defines a filter that determines the security for the parent object in the current session. Specifies the properties of a query subject. A container for the specified child element. When the parent object is a package, the definition element describes a view of the model. When the parent is a securityView, the definition element describes a set. When the parent element is a querySubject, the definition element can contain a dbQuery, mdQuery, modelQuery, or storedProcedure description. Specifies the external form for a query subject. For example, if set to csv, a csv file will be generated that contains the entire result set of a query subject. Externalization can only be triggered during a publish operation. Specifies that the method used will be the default. Specifies that a csv format file will be generated. Specifies that a tab-delimited file format will be generated. Specifies that the file generated will be in the format for input to Cognos Impromptu. Related with the contextSensitiveJoinSelection governor, when the setting is explicit If set to true, the querySubject will be used in the joinPath Represents the magnitude of a level; the higher the number of rows the higher the value. Expected values are 0 to 16 with two decimals at most. This is the log10 of the number of rows - for instance log10 of 100 000 rows is 5, therefore the orderOfMagnitude is 5 Defines the intended usage of the query subject. Specifies that the querySubject usage is automatic and therefore it will be computed by the planning code. Specifies that the querySubject refers to a bridge table. Specifies that the querySubject will be treated as a summaryQuery. Property that is processed in relational query planning when the query subject usage is specified as summaryQuery. The properties of a function or procedure call parameter. Specifies a name for a parameter passed to, or resulting from, execution of a procedure. Specifies whether the parameter passed to a procedure is an input parameter, an output parameter, or an input parameter that is changed during execution. Specifies an input parameter. Specifies an output parameter. Specifies a parameter that is overwritten during execution. SAP-HANA input parameter that requires prompting. SAP-HANA input parameter that does not require prompting. Properties that are needed by Cognos Universal Data Access (UDA) to handle string collation. These are an internal optimization that modelers do not normally need to be concerned with. They are managed automatically by the system, and should never be edited directly. Cached for UDA only. Used only for sortable character data in a dbQuery. Cached for UDA only. Used only for sortable character data in a dbQuery. Cached for UDA only. Used only for sortable character data in a dbQuery. Specifies how the data is encoded in the database. Cached for UDA only. Used only for sortable character data in a dbQuery. Basic properties of data from a database. Represents the allowed number of digits or characters. Default is context-dependent. Used only for numeric and decimal types. Note: The precision of numeric values from SAP BW data sources should be set to zero. Defines the number of digits to the right of the implied decimal point. Used only for numeric and decimal types. Specifies the maximum number of bytes needed to hold a value. If true, this object can contain NULL values. Note: For all SAP BW query items this is false. How the query item is aggregated in the datasource. The properties of a reporting column. If true, the object is hidden in all published packages. Defines the intended usage of the query item. Specifies that the usage is not known. Specifies that the object is to be treated as an identifier. Specifies that the object is to be treated as a fact. Specifies that the object is to be treated as an attribute. Specifies the format for the parent object. The ISO currency code. Should be present if and only if the data is currency. If the element is present but empty, the currency code is unknown at modeling time, and must be determined by the data at execution time (currently not supported for relational data sources). Note: This object is not relevant for SAP BW data sources. SAP BW returns currency information for each value of a fact or measure. The display type for the query item. Note: By default, the display type for all SAP BW query items and calculations is set to value; its value may also be set to link, if applicable. Specifies that the object is displayed as a graphic. Specifies that the object is displayed as a hypertext link. Specifies that the object is displayed as its return value. Used only when the display type is set to picture or link. The default is context dependent. Specifies the additive aggregation rule. Note: For SAP BW data sources, may take the values: unsupported, average, averageNotZero, count, countNotZero, automatic, calculated (for expressions), sum, maximum, minimum, median, standardDeviation, variance. For a measure query item, its value may be different from what is defined in SAP BW (with the exception that a redefined aggregate cannot be averageNotZero or countNotZero). Specifies the semi-additive aggregation rule. This property is not supported for relational sources. For OLAP sources this property is read-only. Specifies that when sorting this item, use the query item referred to as the sort key. If true, data values for this object cannot be compared, and reports cannot sort or group by it. Used mainly for data of type blob. not used Reserved for future use. This property is only applicable for query items that act as attributes for a level or hierarchy. A multilingual property that indicates the role of a member attribute such as the caption or description etc. All roles names that start with an underscore. When true indicates that the attribute with this role will not be displayed in the studios but is available via the roleValue() function. If more than one role is specified the intrinsic property is ANDed for all roles. References another query item that represents a column with the same data. Property is only added for Planning for SAP extract. External name from the datasource that this query item represents. For example a column name within a table. Specifies the name of the underlying object (for relational sources, the column name or alias). Note: For SAP BW, the value of the column name depends on the underlying object: for query items representing a hierarchy level, the value is [MEMBER_UNIQUE_NAME]; for level properties, the value is the unique property name as obtained from MDDataProviderBW::GetProperties; for measures, the value is the unique measure name as obtained from MDDataProviderBW::GetMeasures; for query items that represent surrogate keys (created by Framework Manager to present a star schema representation of an SAP BW data source), the value is the unique dimension name it represents, as obtained from MDDataProviderBW::GetDimensions. References the left object in a relationship. References the right object in a relationship. Presence of this element triggers filter join optimization in which is generated in order to optimize local join processing. The filter will be applied to the many side of the relationship. If there is no many side or if both are many, then the filter will be applied to the right side. Values can be one of: none, in, between, table. IN will generate an IN predicate of constant values. BETWEEN will generate a BETWEEN predicate comprised of MIN and MAX values of the join keys.TABLE will generate a table row constructor form of the IN predicate. Advanced filter join optimization properties. It may be parameterized. Example: filterRequired=true absoluteLimit=1000 percentageLimit=10. A container for the specified child element. When the parent object is a package, the definition element describes a view of the model. When the parent is a securityView, the definition element describes a set. When the parent element is a querySubject, the definition element can contain a dbQuery, mdQuery, modelQuery, or storedProcedure description. A set of included or excluded objects, or included securityViews. Defines who has access to a subset in the published model. Defines the last date and time that the package was published to Content Manager. Last Content Manager path used when package was published. The maximum number of published versions of a package to be stored in Content Manager. If this element is absent, versioning is disabled. The value 0 means unlimited versions. A container element that groups all locale elements for a package or a project. Note: This list cannot be independently edited. There must be exactly one instance of every localizable property on every object for each locale in this list. Defines the objects that will be available in the package. A container for the specified child element. When the parent object is a package, the definition element describes a view of the model. When the parent is a securityView, the definition element describes a set. When the parent element is a querySubject, the definition element can contain a dbQuery, mdQuery, modelQuery, or storedProcedure description. The set of security objects to which administrative permissions are granted on the published model, as defined in Content Manager. The permissions are Read, Write, Traverse, and setPolicy. Note: The original publisher of the package, its owner, is always granted these permissions. Controls whether or not NULL suppression is turned on in the query engines Indicates whether or not it is permissible to suppress on more than a single edge. The default value is "true". Indicates that the user is allowed to modify the suppression options. The default is that all forms of suppression are enabled and accessible ("true"). Controls whether or not the V5 Data Server (XQE engine) is used instead of the legacy one. This is a temporary property that will be removed once the XQE engine will be the default engine. Indicates the type of dimension as either a measure, time, regular or currency dimension. When set true, this property indicates that all measure values for members can be rollup using the aggregation of the measure. If the value is false, it means the values may be computed differently for some or all members. When set true, this property indicates that the members will appear sorted in the metadata tree and by default on the report without causing a negative performance impact When set true, this property indicates that indicates that the data will be sorted on the report without causing a negative performance impact When set true, this property will cause multiple queries to the underlying relational database (as per CR1432) If any mdProperties are set then it implies that the calculation is read-only since it has been imported from an OLAP source. A string that identifies this object in the external data source. A non-emptyvalue indicates that the object was created during an import. If that is the case the expression will be set to read-only in the UI. If the calculation is imported from OLAP sources, calculation can represent either a named set or a substitution variable. List of hierarchy references the set calculation it represents. References an object. List of dimension references the set calculation it represents. References the datasource object for calculations that represent subsitution variables (or 'macros' as they're called in the OLAP import doc). Represents a parent/child tree of members. Each query item under the hierarchy represents the attribute of all members within the hierarchy. A hierarchy of levels. A dimension that contains a hierarchy of levels or represents a parent/child hierarchy of members. References the default hierarchy for this dimension. Measure dimension contains measures. It may also contain query items which would represent the foreign keys of the dimension connected to the measure dimension. In the case of a model measure dimension, query items are not required. For backward compatibility purposes. This will be deprecated in a future release. For backward compatibility only. To be deprecated. For backward compatibility only. To be deprecated. A collection of query items that would represent the foreign keys in a fact table. These would only be applicable in the case of a database measure dimension. These properties only apply if the hierarchy contains a single root member. These properties will not be set for multiroot hierarchies. The external name of the root member for a hierarchy as captured from the datasource. This property is only applicable to OLAP sources. Member unique name for the root member.This property is only set if the hierarchy has only a single root member. This is a multilingual property. Caption property of the root member. This property is only set if the hierarchy has only a single root member. This is a multilingual property. Properties related to change management. Specifies the date and time of the most recent change to the parent object. User name of the last user to change the object. Model developer comment. This property is only used by the FM application. The Properties of a project. A container element that groups all locale elements for a package or a project. Note: This list cannot be independently edited. There must be exactly one instance of every localizable property on every object for each locale in this list. Specifies the default locale for a project. FM-Durable Models Controls whether or not NULL suppression is turned on in the query engines NOTE: This value is not modifiable and is copied from the package object when the model is being published. Indicates whether or not it is permissible to suppress on more than a single edge. The default value is "true". NOTE: This value is not modifiable and is copied from the package object when the model is being published. Indicates that the user is allowed to modify the suppression options. The default is that all forms of suppression are enabled and accessible ("true"). NOTE: This value is not modifiable and is copied from the package object when the model is being published. Properties related to statistics. These properties are used by the query engine to optimize query planning when the "Use statistics" governor is enabled. Specifies the number of rows of data for the parent query subject. The root object of the model. For object referencing purposes, the name of this namespace is empty. A container element that groups dataSource elements. A container element that groups parameterMap elements. A container for securityView elements. Note: Not applicable for SAP BW data sources in this release. A container element that groups package elements. Internal Use Only - Enables the model to be opened using the metadata framework Internal Use Only - Indicates that the model contains references to external metadata sources Indicates which query mode the model is in. In dynamic mode XQE is used through out, while in mixed mode, XQE is used as a check box option in testing and publishing Represents a packaging of model objects to be published for one or more reporting applications. A relationship between a subset of the model and who has access to it in the published model for reporting purposes. Note: Not supported for SAP BW data sources in this release. A container that does not participate in object references. A container that participates in object references. The first part of a reference to any object is its nearest containing namespace (which may be itself). Note: Each SAP BW data source (for example, InfoCube, Query) must be represented in a Framework Manager model in a separate namespace. Defines a link to a metadata source (RESERVED for internal use) Information required for connect to the source Information needed to scope the source (e.g. catalog or schema) Credential needed to connec to the source type of the metadata source, such as modelFM, reportCRN, PC and so on. The query that is executed on the source to retrieve the linked objects Type of the linked objects, e.g. namespace or dimension A function that is stored in a database instance, as specified by its schema. Sometimes called a user-defined database function. Contrast this with functions that are built in by the database vendor. Note: As there is no provision in SAP BW 3.0B for user defined functions, this object should not be used in a model for an SAP BW data source. Causes a query to generate the SQL commands used. If set to minimized, only the required query items appear in the generated SQL. If set to asView, all query items appear. Specifies that all query items appear in the generated SQL. Specifies that only the required query items appear in the generated SQL. Represents an update action for a physical database. Represents a view or query of a physical database. A reportable data item from a query subject or as an attribute of a dimension. For example, an item in the projection list of the SQL definition of a query subject. Represents a generic customizable object. An expression that can be used to join two query subjects. Note: There is no SQL associated with a relationship in a model based on an SAP BW data source. Represents a multilingual customizable property. Specifies the locale that applies to the parent object. Represents a generic customizable property. An object that points to another object. Used to represent an object in another container, or at the other end of a self-join. Defines a shortcut reference to a relationship. Used to represent that relationship in a container where one or both ends are represented by shortcuts. Defines a filter or a calculation. A read-only cache of the SQL that results from planning the model query. It is updated every time the modelQuery changes, and can be used as a backup if the dependant model objects are lost. References the data source object. Specifies a data source for a project. A lookup table for controlling query generation. As a minimum, the _env and _governor maps are required. Specifies the data type for the parent object. Note: The supported datatypes for SAP BW data sources are: float, character, date, and time. Data type is not known. Data type is not supported. Data type is 16 bit integer. Data type is 32 bit integer. Data type is 64 bit integer. Data type is decimal. Data type is numeric. Data type is floating point. Data type is 32 bit floating point. Data type is 64 bit floating point. Data type is binary. Data type is 16 bit binary. Data type is date format (YYMMDD). Data type is time format (HHMMSS). Data type is date/time format. Data type represents a time interval. Data type is character. Data type is 16 bit character. Data type is 32 bit character. Data type is blob. Data type is blob, containing text. Data type is blob, containing an array. Data type represents a database key. Data type is variable bit. Data type is bit. Data type is boolean. Data type represents time, that includes the time zone. Data type represents a time stamp, that includes the time zone. Data type represents a year and month interval. Data type is character, with a length of n. Data type is character, with a variable length whose maximum is n. A folder containing only query items. Defines an expression that returns a value. Specifies an expression used to query the data in the specified database. RESERVED for future use. References a security view. Defines an account, group, or role. The Content Manager search path (Cognos Access Manager ID) for an object. References a query item that goes through a shortcut. The first reference is to a shortcut for a query subject. The second reference is to a query item within that query subject. This reference form preserves the container context used by the system to choose between join paths that would otherwise be ambiguous. References an object. References an object. A level within a hierarchy. Each query item under a level represents a level attribute and/or key. When set to true, it indicates that the members can be uniquely identified with the businessKey attribute without the additional context from the parent members. The external name as found in the datasource that this level represents. This is only applicable for OLAP sources. A string that identifies this object in the external data source. Note: For SAP BW, the value of this object is the unique name of the level as obtained from MDDataProviderBW::GetLevels. Represents the identifier for this level. For example, month or number. Note: For SAP BW, the level number is obtained from MDDataProviderBW::GetLevels. When set to true, it means that the level has been manually added and does not exist in the datasource. An ordered list of sort items that describe how the members will be sorted under a level. Represents the magnitude of a level; the higher the number of rows the higher the value. Expected values are 0 to 16 with two decimals at most. This is the log10 of the number of rows - for instance log10 of 100 000 rows is 5, therefore the orderOfMagnitude is 5 Defines that a dimension is within scope of a measure dimension. A folder containing only measures or other measure folders. An item that represents the fact in a measure dimension. When set to true, it indicates that this measure contains other measures. Used to optimize runtime performance. A collection of aggregate rules. The aggregation rule for a that applies to this measure for the specified dimension. References the dimension that the aggregation rule applies to. Aggregation to apply .... sum, first, last, avg, etc. Needed to extend the Measure Scope support for Multifact DMR Models. Constant allocation in list queries and once-only allocation in crosstab queries Constant allocation in all cases. A hierarchy within a dimension. Defines the function sets available to report authors. Typically, they are the same as those of the data sources used. A quality of service overriding specification An id that identifies a function. This is the same as the id saved in FDS. Quality of service indicator for qos as defined in FDS. Multilingual string of additional description text to include in the expression editor tips window. Represents an arbitrary mix of conditions and references to filters. Specifies the definition of a filter to be applied to the parent object. References an object. Specifies the name that will be displayed to the user for the parent object. Specifies the frequency with which the definition of the filter will be applied. Specifies that the filter is always applied. When the filter contains a prompt, allows the user to choose not to supply a value, in which case the filter is not applied. Specifies if the filter is applied before or after autoAggregation. A folder containing only hierarchies or other hierarchy folders. The name of the person or process responsible for the object Unique identifier for an object in the model References a parameterMap that represents a DB2OLAP or Applix alias table map.