Cognos Dimensional function
Current Member: Returns the Current member of a hierarchy.
Ancestor; Returns the ancestor of the specified member
Children: Returns the set of children of a specified member.
Cognos MDx Functions
Tuple – Refers to an intersection of one or members from one or more dimensions to define a specific measure value
Set – A group of members or tuples. In the [Years] hierarchy, the members [Q1 2006], [Q2 2006], [Q1 2005], [Q2 2005] taken together is a set of members.
Slicer – A slicer is similar to the SQL “where” clause that limits the data returned in a query. As an example, a slicer of [2005] will limit any data returned to 2005. There are some considerations for the report writer when using a slicer:
1. Values returned will be only for the slicer condition. In the previous example, the [Revenue] measure value will be in context of the [2005] member for all calculations and values returned.
2. With a slicer for [2005], year over year comparisons will not be valid since the other years have been “sliced” from the returned data set.
3. Slicers can be sets of data. A valid slicer could be the set of the year members [2004] and [2005].
4. Unlike the SQL “where” clause, slicers do not remove members from other rows or columns. For example, by slicing on [2004] this will not remove [2005] if the years are displayed on the rows. The result would be that [2005] is still present but does not show any measure values.
Detail Filter
A set of conditions in a query that narrow the scope of the data returned. A detail filter is applied
before aggregation is complete.
Summary Filter
A set of conditions in a query that narrow the scope of the data returned. A summary filter is
applied after aggregation is complete.
