Package mondrian.rolap.sql

Interface MemberChildrenConstraint

All Superinterfaces:
SqlConstraint
All Known Implementing Classes:
DefaultMemberChildrenConstraint, RolapNativeSet.SetConstraint, SqlContextConstraint
public interface MemberChildrenConstraint extends SqlConstraint
Restricts the SQL result of a MembersChildren query in SqlMemberSource.
Since:
Nov 2, 2005
Author:
av
See Also:
  • SqlMemberSource

  • Method Details

    • addMemberConstraint

      void addMemberConstraint(SqlQuery sqlQuery, RolapCube baseCube, AggStar aggStar, RolapMember parent)
      Modifies a Member.Children query so that only the children of parent will be returned in the result set.
      Parameters:
      sqlQuery - the query to modify
      baseCube - base cube for virtual members
      aggStar - Aggregate star, if we are reading from an aggregate table,
      parent - the parent member that restricts the returned children

    • addMemberConstraint

      void addMemberConstraint(SqlQuery sqlQuery, RolapCube baseCube, AggStar aggStar, List<RolapMember> parents)
      Modifies a Member.Children query so that (all or some) children of all parent members contained in parents will be returned in the result set.
      Parameters:
      sqlQuery - Query to modify
      baseCube - Base cube for virtual members
      aggStar - Aggregate table, or null if query is against fact table
      parents - List of parent members that restrict the returned children

    • addLevelConstraint

      void addLevelConstraint(SqlQuery query, RolapCube baseCube, AggStar aggStar, RolapLevel level)
      Will be called once for the level that contains the children of a Member.Children query. If the condition requires so, it may join the levels table to the fact table.
      Parameters:
      query - the query to modify
      baseCube - base cube for virtual members
      aggStar - Aggregate table, or null if query is against fact table
      level - the level that contains the children