Table 32. Validation Rules for Metadata Elements
|
|
|
ComplexJoinFactsRule |
[Fact Logical Table Source]Complex Physical Joins not supported %qn has a complex Join %qn between Physical Tables %qn and %qn |
If the physical fact tables are connected through complex joins, the join is not supported. A complex join is defined as any join between two tables that do not have a foreign key relationship. |
ComplexJoinDimsRule |
[Dimension Logical Table Source]Complex Physical Joins not supported %qn has a complex Join %qn between Physical Tables %qn and %qn |
If the dimension physical tables are connected through a complex join, then that join is not supported. |
ComplexJoinFactDimRule |
[Fact Logical Table Source -> Dimension Logical Table Source] Complex Physical Joins not supported. %qn has a complex Join %qn between Physical Tables %qn and %qn. |
If a dimension physical table and a fact physical table are connected through a complex join, that join is not supported and the dimension table source is invalidated. |
OpaqueViewFactRule |
[Fact Logical table Source] Physical SQL Select Statements not supported. %qn uses the SQL Select Statement %qn. |
When the physical fact table is generated by a SQL select statement, the logical fact table source that contains the table is invalidated. All logical dimension table sources connected to this logical fact table source are also invalidated. This construct allows subquery processing. |
OpaqueViewDimRule |
[Dimension Logical table Source] Physical SQL Select Statements not supported. %qn uses the SQL Select Statement %qn. |
When a physical dimension table is generated by a SQL select statement, the logical dimension table source containing that table is invalidated. |
OuterJoinFactRule |
[Fact Logical Table Source] Physical Outer Joins not supported. %qn has an outer join %qn between physical tables %qn and %qn. |
If the logical fact table source has an outer join linkage, then that logical fact table source is invalidated and all logical dimension table sources linked to this source will also be invalidated. |
OuterJoinDimRule |
[Dimension Logical Table Source] Physical Outer Joins not supported. %qn has an outer join %qn between physical tables %qn and %qn. |
If the logical dimension table source has an outer join linkage, that logical dimension table source is invalidated. |
WhereClauseFactRule |
[Fact Logical Table Source] WHERE clauses are not supported. %qn has a where condition %s. |
If the fact table source uses a WHERE clause to filter the data that is loaded, then this table source is invalidated. |
WhereClauseDimRule |
[Dimension Logical Table Source] WHERE clauses are not supported. %qn has a where condition %s. |
If the dimension table source uses a WHERE clause to filter the data that is loaded, this table source is invalidated. |
TwoJoinFactDimRule |
[Fact Logical Table Source -> Dimension Logical Table Source] Multiple Joins between sources not supported. %qn and %qn have at least the following joins : %qn, %qn. |
If a physical fact table is linked to two dimension tables from the same dimension source (if the fact table is not exclusively linked to the most detailed table in the table source), the dimension table source is invalidated. |
HiddenManyManyRule |
[Fact Logical Table Source -> Dimension Logical Table Source] Join between (physical or logical?) fact and dimension is not on the most detailed table. %qn between %qn and %qn is not on the most detailed table %qn {Join name, facttable, dimtable). |
This is related to the TwoJoinFactDimRule. If the fact table is joined to a dimension table that is not the most detailed table in the table source, the dimension table source is invalidated. |
ComplexMeasureRule |
[Column] Complex Aggregation Rules not supported. %qn uses an aggregation rule of %s which is not supported. |
The supported aggregations are SUM, COUNT, AVG, MIN, MAX, STDDEV, COUNT-DISTINCT, and COUNT. |
CountDistMeasureRule |
[Column] COUNT-DISTINCT Aggregation Rule not supported. %qn uses an aggregation rule of %s which is not supported. |
COUNT-DISTINCT aggregation is not supported. |
InvalidColumnLevelRule |
[Level] Some columns that are part of the Primary Level Key are invalid. %qn has %qn as part of its primary key, when %qn has already been marked invalid. |
COUNT-DISTINCT aggregation is not supported. |
VariableBasedColumnRule |
[Logical Table Source -> Column] Column uses a Variable in the Expression Column %qn uses a variable in its mapping. |
COUNT-DISTINCT aggregation is not supported. The logical column uses repository and session variables in the expression. |
OneFactToManyDimRule |
[Fact Logical Table Source -> Dimension Logical Table Source] There must be a unique join path between the most detailed tables in the (logical or physical?) fact and the dimension. No join paths found between %qn and %qn (both physical table names). Found at least the following join paths: (%qn->%qn....), (%qn->%qn....) |
Same as in TwoJoinFactDimRule or HiddenManyManyRule. |
ManyMDTinFactRule |
[Fact Logical Table Source] Fact Logical Table Source must have a unique most detailed table. %qn has at least the following most detailed tables : %qn,%qn. |
A fact that has more than one table that is the most detailed table. |
NoMeasureFactRule |
[Fact Logical Table Source] Fact Logical Table Source does not have any Measures. %qn does not have any deployable measures. |
A fact table does not have any measures because all the measures have been invalidated. |
NoInActiveFactRule |
[Fact Logical Table Source] Fact Logical Table Source is not marked Active. |
A fact source is not active. |
NoInActiveDimRule |
[Dimension Logical Table Source] Dimension Logical Table Source is not marked Active. |
A dimension source is not active. |
NoAttributeInFactRule |
[Fact Logical Table Source -> Column] Attribute found in Fact. %qn in a fact source %qn does not have an aggregation rule. |
No attributes in the fact source. |
NoMeasureInDimRule |
[Dimension Logical Table Source -> Column] Measure found in Dimension. %qn in a dimension source %qn has an aggregation rule. |
No measures in the dimension source. |
VisibleColumnsAttrRule |
[Column] -> The run_as_user does not have visibility to this Logical Column. %qn is not accessible to the run_as_user %qn due to visibility rules. |
A column does not have visibility for this user. |
VisibleColumnsMeasRule |
[Column] -> The run_as_user does not have visibility to this Logical Column. %qn is not accessible to the run_as_user %qn due to visibility rules. |
A column does not have visibility for this user. |
MultiplePrimaryKeysDimRule |
[Dimension Logical Table Source] A Join uses an alternate key in the Dimension Logical Table Source. %qn between %qn and %qn in %qn uses the alternate key %qn. |
A dimension physical table can contain only one primary key. It is joined to another dimension physical table using a different unique key and that join is invalid. IBM Cube Views does not accept any unique keys to be used for foreign joins and always requires the primary key. |
MultiplePrimaryKeysFactRule |
[Dimension Logical Table Source] A Join uses an alternate key in the Dimension Logical Table Source. %qn between %qn and %qn in %qn uses the alternate key %qn. |
A fact physical table can contain only one primary key. It is joined to another fact physical table using a different unique key and that join is invalid. IBM Cube Views does not accept any unique keys to be used for foreign joins and always requires the primary key. |
MultiplePrimaryKeysFactDimRule |
[Fact Logical Table Source -> Dim Logical Table Source] A Join uses an alternate key between the Logical Table sources. %qn between %qn and %qn for sources %qn and %qn uses the alternate key %qn. |
A fact physical table can contain only one primary key. It is joined to a dimension physical table using a different unique key and is invalid. IBM Cube Views does not accept any unique keys to be used for foreign joins and always requires the primary key. |
NotDB2ExpressionAttrRule |
[Dimension Logical Table Source -> Column] The Column contains an Expression not supported. %qn has expression %s which is not supported. |
The attribute contains an expression not supported by IBM Cube Views. This includes metadata expressions that use DateTime functions (for example, CURRENT_DATE). |
NotDB2ExpressionMeasRule |
[Fact Logical Table Source -> Column] The Column contains an Expression not supported. %qn has expression %s which is not supported. |
A measure contains an expression not supported by IBM Cube Views. This includes metadata expressions that use DateTime functions (for example,. CURRENT_DATE). |
NoAttributeDimRule |
[Dimension Logical Table Source] Dimension Logical Table Source does not have any attributes visible to the run_as_user. %qn can not be queried by user %qn since none of its attributes are visible. |
A dimension does not have any attributes. |