query.html
来自「基于mondrian 开源框架进行OLAP多维分析」· HTML 代码 · 共 1,467 行 · 第 1/5 页
HTML
1,467 行
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><!--NewPage--><HTML><HEAD><!-- Generated by javadoc (build 1.5.0_15) on Thu Jul 31 17:20:10 EDT 2008 --><TITLE>Query (Mondrian OLAP Server, version 3.0.4.11371)</TITLE><META NAME="keywords" CONTENT="mondrian.olap.Query class"><LINK REL ="stylesheet" TYPE="text/css" HREF="../../stylesheet.css" TITLE="Style"><SCRIPT type="text/javascript">function windowTitle(){ parent.document.title="Query (Mondrian OLAP Server, version 3.0.4.11371)";}</SCRIPT><NOSCRIPT></NOSCRIPT></HEAD><BODY BGCOLOR="white" onload="windowTitle();"><!-- ========= START OF TOP NAVBAR ======= --><A NAME="navbar_top"><!-- --></A><A HREF="#skip-navbar_top" 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_top_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> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD> <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD> </TR></TABLE></TD><TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM></EM></TD></TR><TR><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../mondrian/olap/PropertyFormatter.html" title="interface in mondrian.olap"><B>PREV CLASS</B></A> <A HREF="../../mondrian/olap/QueryAxis.html" title="class in mondrian.olap"><B>NEXT CLASS</B></A></FONT></TD><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../index.html?mondrian/olap/Query.html" target="_top"><B>FRAMES</B></A> <A HREF="Query.html" target="_top"><B>NO FRAMES</B></A> <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: NESTED | <A HREF="#field_summary">FIELD</A> | <A HREF="#constructor_summary">CONSTR</A> | <A HREF="#method_summary">METHOD</A></FONT></TD><TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">DETAIL: <A HREF="#field_detail">FIELD</A> | <A HREF="#constructor_detail">CONSTR</A> | <A HREF="#method_detail">METHOD</A></FONT></TD></TR></TABLE><A NAME="skip-navbar_top"></A><!-- ========= END OF TOP NAVBAR ========= --><HR><!-- ======== START OF CLASS DATA ======== --><H2><FONT SIZE="-1">mondrian.olap</FONT><BR>Class Query</H2><PRE><A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html" title="class or interface in java.lang">java.lang.Object</A> <IMG SRC="../../resources/inherit.gif" ALT="extended by "><A HREF="../../mondrian/olap/QueryPart.html" title="class in mondrian.olap">mondrian.olap.QueryPart</A> <IMG SRC="../../resources/inherit.gif" ALT="extended by "><B>mondrian.olap.Query</B></PRE><DL><DT><B>All Implemented Interfaces:</B> <DD><A HREF="../../mondrian/olap/Walkable.html" title="interface in mondrian.olap">Walkable</A></DD></DL><HR><DL><DT><PRE>public class <B>Query</B><DT>extends <A HREF="../../mondrian/olap/QueryPart.html" title="class in mondrian.olap">QueryPart</A></DL></PRE><P><code>Query</code> is an MDX query. <p>It is created by calling <A HREF="../../mondrian/olap/Connection.html#parseQuery(java.lang.String)"><CODE>Connection.parseQuery(java.lang.String)</CODE></A>, and executed by calling <A HREF="../../mondrian/olap/Connection.html#execute(mondrian.olap.Query)"><CODE>Connection.execute(mondrian.olap.Query)</CODE></A>, to return a <A HREF="../../mondrian/olap/Result.html" title="interface in mondrian.olap"><CODE>Result</CODE></A>.</p> <h3>Query control</h3> <p>Most queries are model citizens, executing quickly (often using cached results from previous queries), but some queries take more time, or more database resources, or more results, than is reasonable. Mondrian offers three ways to control rogue queries:<ul> <li>You can set a query timeout by setting the <A HREF="../../mondrian/olap/MondrianProperties.html#QueryTimeout"><CODE>MondrianProperties.QueryTimeout</CODE></A> parameter. If the query takes longer to execute than the value of this parameter, the system will kill it.</li> <li>The <A HREF="../../mondrian/olap/MondrianProperties.html#QueryLimit"><CODE>MondrianProperties.QueryLimit</CODE></A> parameter limits the number of cells returned by a query.</li> <li>At any time while a query is executing, another thread can call the <A HREF="../../mondrian/olap/Query.html#cancel()"><CODE>cancel()</CODE></A> method. The call to <A HREF="../../mondrian/olap/Connection.html#execute(mondrian.olap.Query)"><CODE>Connection.execute(Query)</CODE></A> will throw an exception.</li> </ul><P><P><DL><DT><B>Version:</B></DT> <DD>$Id: //open/mondrian-release/3.0/src/main/mondrian/olap/Query.java#4 $</DD><DT><B>Author:</B></DT> <DD>jhyde</DD></DL><HR><P><!-- =========== FIELD SUMMARY =========== --><A NAME="field_summary"><!-- --></A><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2"><B>Field Summary</B></FONT></TH></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>(package private) <A HREF="http://java.sun.com/javase/6/docs/api/java/util/Set.html" title="class or interface in java.util">Set</A><<A HREF="../../mondrian/olap/FunDef.html" title="interface in mondrian.olap">FunDef</A>></CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/olap/Query.html#alertedNonNativeFunDefs">alertedNonNativeFunDefs</A></B></CODE><BR> Set of FunDefs for which alerts about non-native evaluation have already been posted.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../mondrian/olap/QueryAxis.html" title="class in mondrian.olap">QueryAxis</A>[]</CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/olap/Query.html#axes">axes</A></B></CODE><BR> public-private: This must be public because it is still accessed in rolap.RolapConnection</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../mondrian/calc/Calc.html" title="interface in mondrian.calc">Calc</A>[]</CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/olap/Query.html#axisCalcs">axisCalcs</A></B></CODE><BR> </TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../mondrian/olap/Formula.html" title="class in mondrian.olap">Formula</A>[]</CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/olap/Query.html#formulas">formulas</A></B></CODE><BR> public-private: This must be public because it is still accessed in rolap.RolapCube</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../mondrian/olap/QueryAxis.html" title="class in mondrian.olap">QueryAxis</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/olap/Query.html#slicerAxis">slicerAxis</A></B></CODE><BR> public-private: This must be public because it is still accessed in rolap.RolapResult</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../mondrian/calc/Calc.html" title="interface in mondrian.calc">Calc</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/olap/Query.html#slicerCalc">slicerCalc</A></B></CODE><BR> </TD></TR></TABLE> <!-- ======== CONSTRUCTOR SUMMARY ======== --><A NAME="constructor_summary"><!-- --></A><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2"><B>Constructor Summary</B></FONT></TH></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE><B><A HREF="../../mondrian/olap/Query.html#Query(mondrian.olap.Connection, mondrian.olap.Cube, mondrian.olap.Formula[], mondrian.olap.QueryAxis[], mondrian.olap.QueryAxis, mondrian.olap.QueryPart[], mondrian.olap.Parameter[], boolean, boolean)">Query</A></B>(<A HREF="../../mondrian/olap/Connection.html" title="interface in mondrian.olap">Connection</A> connection, <A HREF="../../mondrian/olap/Cube.html" title="interface in mondrian.olap">Cube</A> mdxCube, <A HREF="../../mondrian/olap/Formula.html" title="class in mondrian.olap">Formula</A>[] formulas, <A HREF="../../mondrian/olap/QueryAxis.html" title="class in mondrian.olap">QueryAxis</A>[] axes, <A HREF="../../mondrian/olap/QueryAxis.html" title="class in mondrian.olap">QueryAxis</A> slicerAxis, <A HREF="../../mondrian/olap/QueryPart.html" title="class in mondrian.olap">QueryPart</A>[] cellProps, <A HREF="../../mondrian/olap/Parameter.html" title="interface in mondrian.olap">Parameter</A>[] parameters, boolean load, boolean strictValidation)</CODE><BR> Creates a Query.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE><B><A HREF="../../mondrian/olap/Query.html#Query(mondrian.olap.Connection, mondrian.olap.Formula[], mondrian.olap.QueryAxis[], java.lang.String, mondrian.olap.QueryAxis, mondrian.olap.QueryPart[], boolean, boolean)">Query</A></B>(<A HREF="../../mondrian/olap/Connection.html" title="interface in mondrian.olap">Connection</A> connection, <A HREF="../../mondrian/olap/Formula.html" title="class in mondrian.olap">Formula</A>[] formulas, <A HREF="../../mondrian/olap/QueryAxis.html" title="class in mondrian.olap">QueryAxis</A>[] axes, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A> cube, <A HREF="../../mondrian/olap/QueryAxis.html" title="class in mondrian.olap">QueryAxis</A> slicerAxis, <A HREF="../../mondrian/olap/QueryPart.html" title="class in mondrian.olap">QueryPart</A>[] cellProps, boolean load, boolean strictValidation)</CODE><BR> Creates a Query.</TD></TR></TABLE> <!-- ========== METHOD SUMMARY =========== --><A NAME="method_summary"><!-- --></A><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2"><B>Method Summary</B></FONT></TH></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html" title="class or interface in java.lang">Object</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/olap/Query.html#accept(mondrian.mdx.MdxVisitor)">accept</A></B>(<A HREF="../../mondrian/mdx/MdxVisitor.html" title="interface in mondrian.mdx">MdxVisitor</A> visitor)</CODE><BR> </TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> void</CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/olap/Query.html#addFormula(mondrian.olap.Id, mondrian.olap.Exp)">addFormula</A></B>(<A HREF="../../mondrian/olap/Id.html" title="class in mondrian.olap">Id</A> id, <A HREF="../../mondrian/olap/Exp.html" title="interface in mondrian.olap">Exp</A> exp)</CODE><BR> Adds a new formula specifying a set to an existing query.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> void</CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/olap/Query.html#addFormula(mondrian.olap.Id, mondrian.olap.Exp, mondrian.olap.MemberProperty[])">addFormula</A></B>(<A HREF="../../mondrian/olap/Id.html" title="class in mondrian.olap">Id</A> id, <A HREF="../../mondrian/olap/Exp.html" title="interface in mondrian.olap">Exp</A> exp, <A HREF="../../mondrian/olap/MemberProperty.html" title="class in mondrian.olap">MemberProperty</A>[] memberProperties)</CODE><BR> Adds a new formula specifying a member to an existing query.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> void</CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/olap/Query.html#addLevelToAxis(mondrian.olap.AxisOrdinal, mondrian.olap.Level)">addLevelToAxis</A></B>(<A HREF="../../mondrian/olap/AxisOrdinal.html" title="enum in mondrian.olap">AxisOrdinal</A> axis, <A HREF="../../mondrian/olap/Level.html" title="interface in mondrian.olap">Level</A> level)</CODE><BR> Adds a level to an axis expression.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> void</CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/olap/Query.html#addMeasuresMembers(mondrian.olap.OlapElement)">addMeasuresMembers</A></B>(<A HREF="../../mondrian/olap/OlapElement.html" title="interface in mondrian.olap">OlapElement</A> olapElement)</CODE><BR> Keeps track of references to members of the measures dimension</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> void</CODE></FONT></TD>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?