rowsetdefinition.html

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

 Not supported
<P>
<DL>
</DL>
</DL>
<HR>

<A NAME="MDSCHEMA_CUBES"><!-- --></A><H3>
MDSCHEMA_CUBES</H3>
<PRE>
public static final <A HREF="../../mondrian/xmla/RowsetDefinition.html" title="enum in mondrian.xmla">RowsetDefinition</A> <B>MDSCHEMA_CUBES</B></PRE>
<DL>
<DD>http://msdn2.microsoft.com/en-us/library/ms126271(SQL.90).aspx
 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/olapproperties_rowset.asp

 restrictions
   CATALOG_NAME Optional.
   SCHEMA_NAME Optional.
   CUBE_NAME Optional.
   CUBE_TYPE
      (Optional) A bitmap with one of these valid values:
      1 CUBE
      2 DIMENSION
     Default restriction is a value of 1.
   BASE_CUBE_NAME Optional.

 Not supported
   CREATED_ON
   LAST_SCHEMA_UPDATE
   SCHEMA_UPDATED_BY
   LAST_DATA_UPDATE
   DATA_UPDATED_BY
   ANNOTATIONS
<P>
<DL>
</DL>
</DL>
<HR>

<A NAME="MDSCHEMA_DIMENSIONS"><!-- --></A><H3>
MDSCHEMA_DIMENSIONS</H3>
<PRE>
public static final <A HREF="../../mondrian/xmla/RowsetDefinition.html" title="enum in mondrian.xmla">RowsetDefinition</A> <B>MDSCHEMA_DIMENSIONS</B></PRE>
<DL>
<DD>http://msdn2.microsoft.com/en-us/library/ms126180(SQL.90).aspx
 http://msdn2.microsoft.com/en-us/library/ms126180.aspx

 restrictions
    CATALOG_NAME Optional.
    SCHEMA_NAME Optional.
    CUBE_NAME Optional.
    DIMENSION_NAME Optional.
    DIMENSION_UNIQUE_NAME Optional.
    CUBE_SOURCE (Optional) A bitmap with one of the following valid values:
      1 CUBE
      2 DIMENSION
    Default restriction is a value of 1.

    DIMENSION_VISIBILITY (Optional) A bitmap with one of the following valid values:
      1 Visible
      2 Not visible
    Default restriction is a value of 1.
<P>
<DL>
</DL>
</DL>
<HR>

<A NAME="MDSCHEMA_FUNCTIONS"><!-- --></A><H3>
MDSCHEMA_FUNCTIONS</H3>
<PRE>
public static final <A HREF="../../mondrian/xmla/RowsetDefinition.html" title="enum in mondrian.xmla">RowsetDefinition</A> <B>MDSCHEMA_FUNCTIONS</B></PRE>
<DL>
<DD>http://msdn2.microsoft.com/en-us/library/ms126257(SQL.90).aspx
 http://msdn.microsoft.com/library/en-us/oledb/htm/olapfunctions_rowset.asp

 restrictions
   LIBRARY_NAME Optional.
   INTERFACE_NAME Optional.
   FUNCTION_NAME Optional.
   ORIGIN Optional.

 Not supported
  DLL_NAME
    Optional
  HELP_FILE
    Optional
  HELP_CONTEXT
    Optional
    - SQL Server xml schema says that this must be present
  OBJECT
    Optional
  CAPTION The display caption for the function.
<P>
<DL>
</DL>
</DL>
<HR>

<A NAME="MDSCHEMA_HIERARCHIES"><!-- --></A><H3>
MDSCHEMA_HIERARCHIES</H3>
<PRE>
public static final <A HREF="../../mondrian/xmla/RowsetDefinition.html" title="enum in mondrian.xmla">RowsetDefinition</A> <B>MDSCHEMA_HIERARCHIES</B></PRE>
<DL>
<DD>http://msdn2.microsoft.com/en-us/library/ms126062(SQL.90).aspx
 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/olapproperties_rowset.asp

 restrictions
    CATALOG_NAME Optional.
    SCHEMA_NAME Optional.
    CUBE_NAME Optional.
    DIMENSION_UNIQUE_NAME Optional.
    HIERARCHY_NAME Optional.
    HIERARCHY_UNIQUE_NAME Optional.
    HIERARCHY_ORIGIN
       (Optional) A default restriction is in effect
       on MD_USER_DEFINED and MD_SYSTEM_ENABLED.
    CUBE_SOURCE
      (Optional) A bitmap with one of the following valid values:
      1 CUBE
      2 DIMENSION
      Default restriction is a value of 1.
    HIERARCHY_VISIBILITY
      (Optional) A bitmap with one of the following valid values:
      1 Visible
      2 Not visible
      Default restriction is a value of 1.

 Not supported
  HIERARCHY_IS_VISIBLE
  HIERARCHY_ORIGIN
  HIERARCHY_DISPLAY_FOLDER
  INSTANCE_SELECTION
<P>
<DL>
</DL>
</DL>
<HR>

<A NAME="MDSCHEMA_LEVELS"><!-- --></A><H3>
MDSCHEMA_LEVELS</H3>
<PRE>
public static final <A HREF="../../mondrian/xmla/RowsetDefinition.html" title="enum in mondrian.xmla">RowsetDefinition</A> <B>MDSCHEMA_LEVELS</B></PRE>
<DL>
<DD>http://msdn2.microsoft.com/en-us/library/ms126038(SQL.90).aspx
 http://msdn.microsoft.com/library/en-us/oledb/htm/olaplevels_rowset.asp

 restriction
   CATALOG_NAME Optional.
   SCHEMA_NAME Optional.
   CUBE_NAME Optional.
   DIMENSION_UNIQUE_NAME Optional.
   HIERARCHY_UNIQUE_NAME Optional.
   LEVEL_NAME Optional.
   LEVEL_UNIQUE_NAME Optional.
   LEVEL_ORIGIN
       (Optional) A default restriction is in effect
       on MD_USER_DEFINED and MD_SYSTEM_ENABLED
   CUBE_SOURCE
       (Optional) A bitmap with one of the following valid values:
       1 CUBE
       2 DIMENSION
       Default restriction is a value of 1.
   LEVEL_VISIBILITY
       (Optional) A bitmap with one of the following values:
       1 Visible
       2 Not visible
       Default restriction is a value of 1.

 Not supported
  CUSTOM_ROLLUP_SETTINGS
  LEVEL_UNIQUE_SETTINGS
  LEVEL_ORDERING_PROPERTY
  LEVEL_DBTYPE
  LEVEL_MASTER_UNIQUE_NAME
  LEVEL_NAME_SQL_COLUMN_NAME Customers:(All)!NAME
  LEVEL_KEY_SQL_COLUMN_NAME Customers:(All)!KEY
  LEVEL_UNIQUE_NAME_SQL_COLUMN_NAME Customers:(All)!UNIQUE_NAME
  LEVEL_ATTRIBUTE_HIERARCHY_NAME
  LEVEL_KEY_CARDINALITY
  LEVEL_ORIGIN
<P>
<DL>
</DL>
</DL>
<HR>

<A NAME="MDSCHEMA_MEASURES"><!-- --></A><H3>
MDSCHEMA_MEASURES</H3>
<PRE>
public static final <A HREF="../../mondrian/xmla/RowsetDefinition.html" title="enum in mondrian.xmla">RowsetDefinition</A> <B>MDSCHEMA_MEASURES</B></PRE>
<DL>
<DD>http://msdn2.microsoft.com/en-us/library/ms126250(SQL.90).aspx
 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/olapmeasures_rowset.asp

 restrictions
   CATALOG_NAME Optional.
   SCHEMA_NAME Optional.
   CUBE_NAME Optional.
   MEASURE_NAME Optional.
   MEASURE_UNIQUE_NAME Optional.
   CUBE_SOURCE
     (Optional) A bitmap with one of the following valid values:
     1 CUBE
     2 DIMENSION
     Default restriction is a value of 1.
   MEASURE_VISIBILITY
     (Optional) A bitmap with one of the following valid values:
     1 Visible
     2 Not Visible
     Default restriction is a value of 1.

 Not supported
  MEASURE_GUID
  NUMERIC_PRECISION
  NUMERIC_SCALE
  MEASURE_UNITS
  EXPRESSION
  MEASURE_NAME_SQL_COLUMN_NAME
  MEASURE_UNQUALIFIED_CAPTION
  MEASUREGROUP_NAME
  MEASURE_DISPLAY_FOLDER
  DEFAULT_FORMAT_STRING
<P>
<DL>
</DL>
</DL>
<HR>

<A NAME="MDSCHEMA_MEMBERS"><!-- --></A><H3>
MDSCHEMA_MEMBERS</H3>
<PRE>
public static final <A HREF="../../mondrian/xmla/RowsetDefinition.html" title="enum in mondrian.xmla">RowsetDefinition</A> <B>MDSCHEMA_MEMBERS</B></PRE>
<DL>
<DD>http://msdn2.microsoft.com/es-es/library/ms126046.aspx


 restrictions
   CATALOG_NAME Optional.
   SCHEMA_NAME Optional.
   CUBE_NAME Optional.
   DIMENSION_UNIQUE_NAME Optional.
   HIERARCHY_UNIQUE_NAME Optional.
   LEVEL_UNIQUE_NAME Optional.
   LEVEL_NUMBER Optional.
   MEMBER_NAME Optional.
   MEMBER_UNIQUE_NAME Optional.
   MEMBER_CAPTION Optional.
   MEMBER_TYPE Optional.
   TREE_OP (Optional) Only applies to a single member:
      MDTREEOP_ANCESTORS (0x20) returns all of the ancestors.
      MDTREEOP_CHILDREN (0x01) returns only the immediate children.
      MDTREEOP_SIBLINGS (0x02) returns members on the same level.
      MDTREEOP_PARENT (0x04) returns only the immediate parent.
      MDTREEOP_SELF (0x08) returns itself in the list of
                 returned rows.
      MDTREEOP_DESCENDANTS (0x10) returns all of the descendants.
   CUBE_SOURCE (Optional) A bitmap with one of the
      following valid values:
        1 CUBE
        2 DIMENSION
      Default restriction is a value of 1.

 Not supported
<P>
<DL>
</DL>
</DL>
<HR>

<A NAME="MDSCHEMA_PROPERTIES"><!-- --></A><H3>
MDSCHEMA_PROPERTIES</H3>
<PRE>
public static final <A HREF="../../mondrian/xmla/RowsetDefinition.html" title="enum in mondrian.xmla">RowsetDefinition</A> <B>MDSCHEMA_PROPERTIES</B></PRE>
<DL>
<DD>http://msdn2.microsoft.com/en-us/library/ms126309(SQL.90).aspx
 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/olapproperties_rowset.asp

 restrictions
    CATALOG_NAME Mandatory
    SCHEMA_NAME Optional
    CUBE_NAME Optional
    DIMENSION_UNIQUE_NAME Optional
    HIERARCHY_UNIQUE_NAME Optional
    LEVEL_UNIQUE_NAME Optional

    MEMBER_UNIQUE_NAME Optional
    PROPERTY_NAME Optional
    PROPERTY_TYPE Optional
    PROPERTY_CONTENT_TYPE
       (Optional) A default restriction is in place on MDPROP_MEMBER
       OR MDPROP_CELL.
    PROPERTY_ORIGIN
       (Optional) A default restriction is in place on MD_USER_DEFINED
       OR MD_SYSTEM_ENABLED
    CUBE_SOURCE
       (Optional) A bitmap with one of the following valid values:
       1 CUBE
       2 DIMENSION
       Default restriction is a value of 1.
    PROPERTY_VISIBILITY
       (Optional) A bitmap with one of the following valid values:
       1 Visible
       2 Not visible
       Default restriction is a value of 1.

 Not supported
    PROPERTY_ORIGIN
    CUBE_SOURCE
    PROPERTY_VISIBILITY
    CHARACTER_MAXIMUM_LENGTH
    CHARACTER_OCTET_LENGTH
    NUMERIC_PRECISION
    NUMERIC_SCALE
    DESCRIPTION
    SQL_COLUMN_NAME
    LANGUAGE