Strategy ONE
Providing Access to Intelligent Cube Data: Dynamic Sourcing
The table below summarizes the Dynamic sourcing VLDB properties. Additional details about each property, including examples where necessary, are available by clicking on the links in the table.
| Property | Description | Possible Values | Default Value |
|
Defines whether dynamic sourcing is enabled or disabled for aggregate tables. |
Aggregate tables contain the same data as corresponding detail tables and the aggregation function is SUM Aggregate tables contain either less data or more data than their corresponding detail tables and/or the aggregation function is not SUM |
Aggregate tables contain the same data as corresponding detail tables and the aggregation function is SUM |
|
|
Defines whether dynamic sourcing is enabled or disabled for attributes. |
Attribute columns in fact tables and lookup tables do not contain NULLs and all attribute elements in fact tables are present in lookup tables Attribute columns in fact tables or lookup tables may contain NULLs and/or some attribute elements in fact tables are not present in lookup tables |
Attribute columns in fact tables and lookup tables do not contain NULLs and all attribute elements in fact tables are present in lookup tables |
|
|
Defines whether the Intelligent Cube Parse log is displayed in the SQL View of an Intelligent Cube. This log helps determine which reports use dynamic sourcing to connect to the Intelligent Cube. |
Disable Cube Parse Log in SQL View Enable Cube Parse Log in SQL View |
Disable Cube Parse Log in SQL View |
|
|
Defines whether dynamic sourcing is enabled or disabled for reports. |
Disable dynamic sourcing for report Enable dynamic sourcing for report |
Enable dynamic sourcing for report |
|
|
Defines whether the extended mismatch log is displayed in the SQL View of a report. The extended mismatch log helps determine why a metric prevents the use of dynamic sourcing is provided in the extended mismatch log. |
Disable Extended Mismatch Log in SQL View Enable Extended Mismatch Log in SQL View |
Disable Extended Mismatch Log in SQL View |
|
|
Defines whether the mismatch log is displayed in the SQL View of a report. This log helps determine why a report that can use dynamic sourcing cannot connect to a specific Intelligent Cube. |
Disable Mismatch Log in SQL View Enable Mismatch Log in SQL View |
Disable Mismatch Log in SQL View |
|
|
Defines whether the Report Parse log is displayed in the SQL View of a report. This log helps determine whether the report can use dynamic sourcing to connect to an Intelligent Cube. |
Disable Report Parse Log in SQL View Enable Report Parse Log in SQL View |
Disable Report Parse Log in SQL View |
|
|
Defines whether dynamic sourcing is enabled or disabled for metrics. |
Enable dynamic sourcing for metric Disable dynamic sourcing for metric |
Enable dynamic sourcing for metric |
|
|
Defines whether dynamic sourcing is enabled or disabled for attributes that are used in filter qualifications. |
Use case insensitive string comparison with dynamic sourcing Do not allow any string comparison with dynamic sourcing |
Use case insensitive string comparison with dynamic sourcing |