sqlconstraintutils.html

来自「基于mondrian 开源框架进行OLAP多维分析」· HTML 代码 · 共 414 行 · 第 1/2 页

<TH ALIGN="left"><B>Methods inherited from class java.lang.<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html" title="class or interface in java.lang">Object</A></B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html#clone()" title="class or interface in java.lang">clone</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html#equals(java.lang.Object)" title="class or interface in java.lang">equals</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html#finalize()" title="class or interface in java.lang">finalize</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html#getClass()" title="class or interface in java.lang">getClass</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html#hashCode()" title="class or interface in java.lang">hashCode</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html#notify()" title="class or interface in java.lang">notify</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html#notifyAll()" title="class or interface in java.lang">notifyAll</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html#toString()" title="class or interface in java.lang">toString</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html#wait()" title="class or interface in java.lang">wait</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html#wait(long)" title="class or interface in java.lang">wait</A>, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html#wait(long, int)" title="class or interface in java.lang">wait</A></CODE></TD>
</TR>
</TABLE>
&nbsp;
<P>

<!-- ============ METHOD DETAIL ========== -->

<A NAME="method_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
<B>Method Detail</B></FONT></TH>
</TR>
</TABLE>

<A NAME="addContextConstraint(mondrian.rolap.sql.SqlQuery, mondrian.rolap.aggmatcher.AggStar, mondrian.olap.Evaluator, boolean)"><!-- --></A><H3>
addContextConstraint</H3>
<PRE>
public static void <B>addContextConstraint</B>(<A HREF="../../mondrian/rolap/sql/SqlQuery.html" title="class in mondrian.rolap.sql">SqlQuery</A>&nbsp;sqlQuery,
                                        <A HREF="../../mondrian/rolap/aggmatcher/AggStar.html" title="class in mondrian.rolap.aggmatcher">AggStar</A>&nbsp;aggStar,
                                        <A HREF="../../mondrian/olap/Evaluator.html" title="interface in mondrian.olap">Evaluator</A>&nbsp;evaluator,
                                        boolean&nbsp;restrictMemberTypes)</PRE>
<DL>
<DD>For every restricting member in the current context, generates
 a WHERE condition and a join to the fact table.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sqlQuery</CODE> - the query to modify<DD><CODE>aggStar</CODE> - Aggregate table, or null if query is against fact table<DD><CODE>restrictMemberTypes</CODE> - defines the behavior if the current context contains
   calculated members.
   If true, an exception is thrown.<DD><CODE>evaluator</CODE> - Evaluator</DL>
</DD>
</DL>
<HR>

<A NAME="removeCalculatedMembers(mondrian.olap.Member[])"><!-- --></A><H3>
removeCalculatedMembers</H3>
<PRE>
static <A HREF="../../mondrian/olap/Member.html" title="interface in mondrian.olap">Member</A>[] <B>removeCalculatedMembers</B>(<A HREF="../../mondrian/olap/Member.html" title="interface in mondrian.olap">Member</A>[]&nbsp;members)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="containsCalculatedMember(mondrian.olap.Member[])"><!-- --></A><H3>
containsCalculatedMember</H3>
<PRE>
public static boolean <B>containsCalculatedMember</B>(<A HREF="../../mondrian/olap/Member.html" title="interface in mondrian.olap">Member</A>[]&nbsp;members)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="joinLevelTableToFactTable(mondrian.rolap.sql.SqlQuery, mondrian.rolap.RolapCube, mondrian.rolap.aggmatcher.AggStar, mondrian.olap.Evaluator, mondrian.rolap.RolapCubeLevel)"><!-- --></A><H3>
joinLevelTableToFactTable</H3>
<PRE>
public static void <B>joinLevelTableToFactTable</B>(<A HREF="../../mondrian/rolap/sql/SqlQuery.html" title="class in mondrian.rolap.sql">SqlQuery</A>&nbsp;sqlQuery,
                                             <A HREF="../../mondrian/rolap/RolapCube.html" title="class in mondrian.rolap">RolapCube</A>&nbsp;baseCube,
                                             <A HREF="../../mondrian/rolap/aggmatcher/AggStar.html" title="class in mondrian.rolap.aggmatcher">AggStar</A>&nbsp;aggStar,
                                             <A HREF="../../mondrian/olap/Evaluator.html" title="interface in mondrian.olap">Evaluator</A>&nbsp;e,
                                             <A HREF="../../mondrian/rolap/RolapCubeLevel.html" title="class in mondrian.rolap">RolapCubeLevel</A>&nbsp;level)</PRE>
<DL>
<DD>Ensures that the table of <code>level</code> is joined to the fact
 table
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sqlQuery</CODE> - sql query under construction<DD><CODE>aggStar</CODE> - <DD><CODE>e</CODE> - evaluator corresponding to query<DD><CODE>level</CODE> - level to be added to query</DL>
</DD>
</DL>
<HR>

<A NAME="addMemberConstraint(mondrian.rolap.sql.SqlQuery, mondrian.rolap.RolapCube, mondrian.rolap.aggmatcher.AggStar, mondrian.rolap.RolapMember, boolean)"><!-- --></A><H3>
addMemberConstraint</H3>
<PRE>
public static void <B>addMemberConstraint</B>(<A HREF="../../mondrian/rolap/sql/SqlQuery.html" title="class in mondrian.rolap.sql">SqlQuery</A>&nbsp;sqlQuery,
                                       <A HREF="../../mondrian/rolap/RolapCube.html" title="class in mondrian.rolap">RolapCube</A>&nbsp;baseCube,
                                       <A HREF="../../mondrian/rolap/aggmatcher/AggStar.html" title="class in mondrian.rolap.aggmatcher">AggStar</A>&nbsp;aggStar,
                                       <A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap">RolapMember</A>&nbsp;parent,
                                       boolean&nbsp;restrictMemberTypes)</PRE>
<DL>
<DD>Creates a "WHERE parent = value" constraint.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sqlQuery</CODE> - the query to modify<DD><CODE>baseCube</CODE> - base cube if virtual<DD><CODE>aggStar</CODE> - Definition of the aggregate table, or null<DD><CODE>parent</CODE> - the list of parent members<DD><CODE>restrictMemberTypes</CODE> - defines the behavior if <code>parent</code>
 is a calculated member. If true, an exception is thrown</DL>
</DD>
</DL>
<HR>

<A NAME="addMemberConstraint(mondrian.rolap.sql.SqlQuery, mondrian.rolap.RolapCube, mondrian.rolap.aggmatcher.AggStar, java.util.List, boolean, boolean)"><!-- --></A><H3>
addMemberConstraint</H3>
<PRE>
public static void <B>addMemberConstraint</B>(<A HREF="../../mondrian/rolap/sql/SqlQuery.html" title="class in mondrian.rolap.sql">SqlQuery</A>&nbsp;sqlQuery,
                                       <A HREF="../../mondrian/rolap/RolapCube.html" title="class in mondrian.rolap">RolapCube</A>&nbsp;baseCube,
                                       <A HREF="../../mondrian/rolap/aggmatcher/AggStar.html" title="class in mondrian.rolap.aggmatcher">AggStar</A>&nbsp;aggStar,
                                       <A HREF="http://java.sun.com/javase/6/docs/api/java/util/List.html" title="class or interface in java.util">List</A>&lt;<A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap">RolapMember</A>&gt;&nbsp;members,
                                       boolean&nbsp;restrictMemberTypes,
                                       boolean&nbsp;crossJoin)</PRE>
<DL>
<DD>Creates a "WHERE exp IN (...)" condition containing the values
 of all parents.  All parents must belong to the same level.

 <p>If this constraint is part of a native cross join, there are
 multiple constraining members, and the members comprise the cross
 product of all unique member keys referenced at each level, then
 generating IN expressions would result in incorrect results.  In that
 case, "WHERE ((level1 = val1a AND level2 = val2a AND ...)
 OR (level1 = val1b AND level2 = val2b AND ...) OR ..." is generated
 instead.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sqlQuery</CODE> - the query to modify<DD><CODE>baseCube</CODE> - base cube if virtual<DD><CODE>aggStar</CODE> - (not used)<DD><CODE>members</CODE> - the list of members for this constraint<DD><CODE>restrictMemberTypes</CODE> - defines the behavior if <code>parents</code>
   contains calculated members.
   If true, and one of the members is calculated, an exception is thrown.<DD><CODE>crossJoin</CODE> - true if constraint is being generated as part of
   a native crossjoin</DL>
</DD>
</DL>
<HR>

<A NAME="constrainLevel(mondrian.rolap.RolapLevel, mondrian.rolap.sql.SqlQuery, mondrian.rolap.RolapCube, java.lang.String, boolean)"><!-- --></A><H3>
constrainLevel</H3>
<PRE>
public static <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A> <B>constrainLevel</B>(<A HREF="../../mondrian/rolap/RolapLevel.html" title="class in mondrian.rolap">RolapLevel</A>&nbsp;level,
                                    <A HREF="../../mondrian/rolap/sql/SqlQuery.html" title="class in mondrian.rolap.sql">SqlQuery</A>&nbsp;query,
                                    <A HREF="../../mondrian/rolap/RolapCube.html" title="class in mondrian.rolap">RolapCube</A>&nbsp;baseCube,
                                    <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A>&nbsp;columnValue,
                                    boolean&nbsp;caseSensitive)</PRE>
<DL>
<DD>Generates a sql expression constraining a level by some value
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>level</CODE> - the level<DD><CODE>query</CODE> - the query that the sql expression will be added to<DD><CODE>baseCube</CODE> - base cube for virtual levels<DD><CODE>columnValue</CODE> - value constraining the level<DD><CODE>caseSensitive</CODE> - if true, need to handle case sensitivity of the
 member value
<DT><B>Returns:</B><DD>generated string corresponding to the expression</DL>
</DD>
</DL>
<!-- ========= END OF CLASS DATA ========= -->
<HR>


<!-- ======= START OF BOTTOM NAVBAR ====== -->
<A NAME="navbar_bottom"><!-- --></A>
<A HREF="#skip-navbar_bottom" title="Skip navigation links"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_bottom_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
  <TR ALIGN="center" VALIGN="top">
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A>&nbsp;</TD>
  </TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
<a href="http://sourceforge.net/projects/mondrian"><img src="http://sourceforge.net/sflogo.php?group_id=35302&type=1" width="88" height="31" border="0" alt="SourceForge.net_Logo"></a></EM>
</TD>
</TR>

<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
&nbsp;<A HREF="../../mondrian/rolap/SqlConstraintFactory.html" title="class in mondrian.rolap"><B>PREV CLASS</B></A>&nbsp;
&nbsp;<A HREF="../../mondrian/rolap/SqlContextConstraint.html" title="class in mondrian.rolap"><B>NEXT CLASS</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../index.html?mondrian/rolap/SqlConstraintUtils.html" target="_top"><B>FRAMES</B></A>  &nbsp;
&nbsp;<A HREF="SqlConstraintUtils.html" target="_top"><B>NO FRAMES</B></A>  &nbsp;
&nbsp;<SCRIPT type="text/javascript">
  <!--
  if(window==top) {
    document.writeln('<A HREF="../../allclasses-noframe.html"><B>All Classes</B></A>');
  }
  //-->
</SCRIPT>
<NOSCRIPT>
  <A HREF="../../allclasses-noframe.html"><B>All Classes</B></A>
</NOSCRIPT>


</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
  SUMMARY:&nbsp;NESTED&nbsp;|&nbsp;FIELD&nbsp;|&nbsp;CONSTR&nbsp;|&nbsp;<A HREF="#method_summary">METHOD</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
DETAIL:&nbsp;FIELD&nbsp;|&nbsp;CONSTR&nbsp;|&nbsp;<A HREF="#method_detail">METHOD</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_bottom"></A>
<!-- ======== END OF BOTTOM NAVBAR ======= -->

<HR>

</BODY>
</HTML>