Drill Through Constraints

You can use the Cognos® Transformer user interface or Model Definition Language (MDL) to set up drill through to a wide variety of target reports simply by adding the destination filenames to the appropriate drill-through list. However, if the target file is renamed to make it more meaningful to your users, you must update the drill-through information in your model, then recreate and redeploy the cube.

If a drill-through filter applies to a level that was not declared unique in the model, the parameters passed to the target component must contain information for that level and for each ancestor level until a unique level or the highest level in the dimension is reached.

In PowerPlay-to-Impromptu drill-through operations, this is automatic. For example, if a category called Burlington belongs to the level City, which was not set to Unique on the Level property sheet, the filter contains City=Burlington plus the next higher level, State=Massachusetts.

For time dimensions, measure values are specified only for the most detailed leaf categories. Categories in Cognos Transformer time dimensions are expressed as ranges from the first to the last descendant. For example, the year 2006 is represented as 20060101-20061231.

For special categories and categories added manually, all child categories are handled successively until the source level is reached.