Strategy ONE
Features that can be used with dynamic sourcing
Features that can be supported by dynamic sourcing include, but are not limited to, the list below:
- Security filters
- Compound attributes and joint element lists
- Conditional metrics
- Prompts in a report
- Transformation metrics, under the following conditions:
- A metric with the same formula and transformation exists in the Intelligent Cube.
- For the hierarchy used for the transformation, the report must be calculated at the same level as the Intelligent Cube. For example, if the transformation is along the Time hierarchy and the Intelligent Cube is calculated at the Month level, the report must also be calculated at the Month level.
- Metrics that include Count, Sum, Min, or Max in their formulas
- Metrics that include Count Distinct in their formula for reports and Intelligent Cubes that share the same level of attribute data
- Nested metrics for which the inner metric and all attributes used for aggregation are available in the Intelligent Cube
- Non-aggregatable metrics for which the non-aggregation attribute is available in the Intelligent Cube
- Filter qualifications including the functions Exactly, Different from, In list, Not in list, Greater than, Less than, Greater than or equal to, Less than or equal to, Between, Not Between, Is Null, and Is Not Null for data types Numeric, BigDecimal, DateTime, and String
- OLAP Services features in the report, including:
- OLAP features used in a report, such as: