mondrian.rolap

Class RolapCubeHierarchy.RolapCubeSqlMemberSource

java.lang.Object

mondrian.rolap.RolapCubeHierarchy.RolapCubeSqlMemberSource

All Implemented Interfaces:

TupleReader.MemberBuilder

Enclosing class:

RolapCubeHierarchy

public static class RolapCubeHierarchy.RolapCubeSqlMemberSource
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SqlMemberSource.NullValuePoolFactory Default SqlMemberSource.ValuePoolFactory implementation, used if MondrianProperties.SqlMemberSourceValuePoolFactoryClass is not set.
static interface	SqlMemberSource.ValuePoolFactory Interface definition for the pluggable factory used to decide which implementation of Map to use to pool reusable values.
static class	SqlMemberSource.ValuePoolFactoryFactory Creates the ValuePoolFactory which is in turn used to create property-value maps for member properties.

Constructor Summary

Constructors

Constructor and Description
RolapCubeSqlMemberSource(RolapCubeHierarchy.RolapCubeHierarchyMemberReader memberReader, RolapCubeHierarchy hierarchy, MemberCacheHelper memberSourceCacheHelper, Object memberCacheLock)

Method Summary

Modifier and Type	Method and Description
RolapMember	allMember() Returns the 'all' member of the hierarchy.
int	compare(RolapMember m1, RolapMember m2, boolean siblingsAreEqual) Compares two members according to their order in a prefix ordered traversal.
RolapMember	desubstitute(RolapMember member) Returns the member which was substituted.
RolapMember	getDefaultMember()
RolapHierarchy	getHierarchy() Returns the hierarchy that this source is reading for.
RolapMember	getLeadMember(RolapMember member, int n) Returns the member n after member in the same level (or before, if n is negative).
int	getLevelMemberCount(RolapLevel level) Returns the number of members in this level.
TupleReader.MemberBuilder	getMemberBuilder()
RolapMember	getMemberByKey(RolapLevel level, List<Comparable> keyValues) Looks up a member by its key value.
mondrian.rolap.MemberCache	getMemberCache() Returns the MemberCache to look up members before creating them.
Object	getMemberCacheLock() use the same lock in the RolapCubeMemberSource as the RolapCubeHiearchyMemberReader to avoid deadlocks
void	getMemberChildren(List<RolapMember> parentMembers, List<RolapMember> children) Returns all members which are a child of one of the members in parentMembers, sorted by ordinal.
Map<? extends Member,Access>	getMemberChildren(List<RolapMember> parentMembers, List<RolapMember> children, MemberChildrenConstraint mcc) Populates a list of the children of a given set of Members, optionally applying a constraint.
void	getMemberChildren(RolapMember parentMember, List<RolapMember> children) Writes all children parentMember to children.
Map<? extends Member,Access>	getMemberChildren(RolapMember parentMember, List<RolapMember> children, MemberChildrenConstraint constraint) Populates a list of the children of a Member, optionally applying a constraint.
int	getMemberCount() Returns an estimate of number of members in this hierarchy.
RolapMember	getMemberParent(RolapMember member)
void	getMemberRange(RolapLevel level, RolapMember startMember, RolapMember endMember, List<RolapMember> memberList) Writes all members between startMember and endMember into list.
List<RolapMember>	getMembers() Returns all members of this hierarchy, sorted by ordinal.
List<RolapMember>	getMembersInLevel(RolapLevel level) Returns all of the members in level whose ordinal lies between startOrdinal and endOrdinal.
List<RolapMember>	getMembersInLevel(RolapLevel level, TupleConstraint constraint) Returns the members in the given Level, optionally applying a constraint.
List<RolapMember>	getRootMembers() Returns all members of this hierarchy which do not have a parent, sorted by ordinal.
static boolean	isLevelCollapsed(AggStar aggStar, RolapCubeLevel level) Determine if the given aggregate table has the dimension level specified within in (AggStar.FactTable) it, aka collapsed, or associated with foreign keys (AggStar.DimTable)
static boolean	levelContainsMultipleColumns(RolapLevel level) Determine if a level contains more than a single column for its data, such as an ordinal column or property column
RolapMember	lookupMember(List<Id.Segment> uniqueNameParts, boolean failIfNotFound) Finds a member based upon its unique name.
RolapMember	makeMember(RolapMember parentMember, RolapLevel childLevel, Object value, Object captionValue, boolean parentChild, SqlStatement stmt, Object key, int columnOffset) Creates a new member (together with its properties).
boolean	setCache(mondrian.rolap.MemberCache cache) Sets the cache which this MemberSource will write to.
RolapMember	substitute(RolapMember member) Substitutes a given member.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

RolapCubeSqlMemberSource

public RolapCubeSqlMemberSource(RolapCubeHierarchy.RolapCubeHierarchyMemberReader memberReader,
                                RolapCubeHierarchy hierarchy,
                                MemberCacheHelper memberSourceCacheHelper,
                                Object memberCacheLock)

Method Detail

makeMember

public RolapMember makeMember(RolapMember parentMember,
                              RolapLevel childLevel,
                              Object value,
                              Object captionValue,
                              boolean parentChild,
                              SqlStatement stmt,
                              Object key,
                              int columnOffset)
                       throws SQLException

Description copied from interface: TupleReader.MemberBuilder

Creates a new member (together with its properties).

Specified by:

makeMember in interface TupleReader.MemberBuilder

Parameters:

parentMember - Parent member

childLevel - Child level

value - Member value

captionValue - Caption

parentChild - Whether a parent-child hierarchy

stmt - SQL statement

key - Member key

columnOffset - Column ordinal (0-based)

Returns:

new member

Throws:

SQLException - on error

getMemberCache

public mondrian.rolap.MemberCache getMemberCache()

Description copied from interface: TupleReader.MemberBuilder

Returns the MemberCache to look up members before creating them.

Specified by:

getMemberCache in interface TupleReader.MemberBuilder

Returns:

member cache

getMemberCacheLock

public Object getMemberCacheLock()

use the same lock in the RolapCubeMemberSource as the RolapCubeHiearchyMemberReader to avoid deadlocks

Specified by:

getMemberCacheLock in interface TupleReader.MemberBuilder

Returns:

Object to lock

allMember

public RolapMember allMember()

Description copied from interface: TupleReader.MemberBuilder

Returns the 'all' member of the hierarchy.

Specified by:

allMember in interface TupleReader.MemberBuilder

Returns:

The 'all' member

getHierarchy

public RolapHierarchy getHierarchy()

Description copied from interface: MemberSource

Returns the hierarchy that this source is reading for.

setCache

public boolean setCache(mondrian.rolap.MemberCache cache)

Description copied from interface: MemberSource

Sets the cache which this MemberSource will write to.

Cache-writeback is optional (for example, SqlMemberSource supports it, and ArrayMemberSource does not), and the return value from this method indicates whether this object supports it.

If this method returns true, the MemberSource.getMembers(), MemberSource.getRootMembers() and MemberSource.getMemberChildren(mondrian.rolap.RolapMember, java.util.List<mondrian.rolap.RolapMember>) methods must write to the cache, in addition to returning members as a return value.

Parameters:

cache - The MemberCache which the caller would like this MemberSource to write to.

Returns:

Whether this MemberSource supports cache-writeback.

getMemberCount

public int getMemberCount()

Description copied from interface: MemberSource

Returns an estimate of number of members in this hierarchy.

substitute

public RolapMember substitute(RolapMember member)

Substitutes a given member. If member is null, returns null.

This method is called whenever a member is returned from the wrapped member reader and is to be returned to the caller. You could say that it translates 'to caller space'.

Parameters:

member - Member

Returns:

Substitute member

desubstitute

public RolapMember desubstitute(RolapMember member)

Returns the member which was substituted. If member is null, returns null.

This method is called whenever the caller passes a member into a method and needs to be passed to a method on the wrapped member reader. You could say that it translates 'from caller space'.

Parameters:

member - Member

Returns:

Internal member

getMemberByKey

public RolapMember getMemberByKey(RolapLevel level,
                                  List<Comparable> keyValues)

Looks up a member by its key value.

Parameters:

level - Level

keyValues - Key values

Returns:

Member, or null

lookupMember

public RolapMember lookupMember(List<Id.Segment> uniqueNameParts,
                                boolean failIfNotFound)

Description copied from interface: MemberSource

Finds a member based upon its unique name.

getLevelMemberCount

public int getLevelMemberCount(RolapLevel level)

Returns the number of members in this level.

Parameters:

level - Level

Returns:

number of members in level

getMembers

public List<RolapMember> getMembers()

Description copied from interface: MemberSource

Returns all members of this hierarchy, sorted by ordinal.

If this object supports cache-writeaback, also writes these members to the cache.

getMembersInLevel

public List<RolapMember> getMembersInLevel(RolapLevel level)

Returns all of the members in level whose ordinal lies between startOrdinal and endOrdinal.

If this object supports cache-writeback, also writes these members to the cache.

Returns:

List of RolapMember

getMembersInLevel

public List<RolapMember> getMembersInLevel(RolapLevel level,
                                           TupleConstraint constraint)

Returns the members in the given Level, optionally applying a constraint.

Parameters:

level - Level

constraint - Constraint

Returns:

list of members

getRootMembers

public List<RolapMember> getRootMembers()

Description copied from interface: MemberSource

Returns all members of this hierarchy which do not have a parent, sorted by ordinal.

If this object supports cache-writeback, also writes these members to the cache.

Returns:

List of RolapMembers

levelContainsMultipleColumns

public static boolean levelContainsMultipleColumns(RolapLevel level)

Determine if a level contains more than a single column for its data, such as an ordinal column or property column

Parameters:

level - the level to check

Returns:

true if multiple relational columns are involved in this level

isLevelCollapsed

public static boolean isLevelCollapsed(AggStar aggStar,
                                       RolapCubeLevel level)

Determine if the given aggregate table has the dimension level specified within in (AggStar.FactTable) it, aka collapsed, or associated with foreign keys (AggStar.DimTable)

Parameters:

aggStar - aggregate star if exists

level - level

Returns:

true if agg table has level or not

getMemberChildren

public void getMemberChildren(List<RolapMember> parentMembers,
                              List<RolapMember> children)

Description copied from interface: MemberSource

Returns all members which are a child of one of the members in parentMembers, sorted by ordinal.

If this object supports cache-writeaback, also writes these members to the cache.

getMemberChildren

public Map<? extends Member,Access> getMemberChildren(List<RolapMember> parentMembers,
                                                      List<RolapMember> children,
                                                      MemberChildrenConstraint mcc)

Populates a list of the children of a given set of Members, optionally applying a constraint.

Parameters:

parentMembers - List of members whose children to find

children - List to populate with members

mcc - Constraint

Returns:

After populating the list passed as an argument, this method returns a map of the members it just populated along with the Access information applicable. If no access control applies to the member, the map will contain null values.

getMemberChildren

public void getMemberChildren(RolapMember parentMember,
                              List<RolapMember> children)

Description copied from interface: MemberSource

Writes all children parentMember to children.

If this object supports cache-writeback, also writes these members to the cache.

getMemberChildren

public Map<? extends Member,Access> getMemberChildren(RolapMember parentMember,
                                                      List<RolapMember> children,
                                                      MemberChildrenConstraint constraint)

Populates a list of the children of a Member, optionally applying a constraint.

Parameters:

parentMember - Members whose children to find

children - List to populate with members

constraint - Constraint

Returns:

After populating the list passed as an argument, this method returns a map of the members it just populated along with the Access information applicable. If no access control applies to the member, the map will contain null values.

getLeadMember

public RolapMember getLeadMember(RolapMember member,
                                 int n)

Returns the member n after member in the same level (or before, if n is negative). Returns Hierarchy.getNullMember() if we run off the beginning or end of the level.

getMemberRange

public void getMemberRange(RolapLevel level,
                           RolapMember startMember,
                           RolapMember endMember,
                           List<RolapMember> memberList)

Writes all members between startMember and endMember into list.

compare

public int compare(RolapMember m1,
                   RolapMember m2,
                   boolean siblingsAreEqual)

Compares two members according to their order in a prefix ordered traversal. If siblingsAreEqual, then two members with the same parent will compare equal.

Returns:

less than zero if m1 occurs before m2, greater than zero if m1 occurs after m2, zero if m1 is equal to m2, or if siblingsAreEqual and m1 and m2 have the same parent

getMemberBuilder

public TupleReader.MemberBuilder getMemberBuilder()

getDefaultMember

public RolapMember getDefaultMember()

getMemberParent

public RolapMember getMemberParent(RolapMember member)