Interface MDXHierarchy

<xsd:complexType name="row">
   <xsd:sequence>
       <xsd:element sql:field="CATALOG_NAME" name="CATALOG_NAME" type="xsd:string" minOccurs="0"/>
       <xsd:element sql:field="SCHEMA_NAME" name="SCHEMA_NAME" type="xsd:string" minOccurs="0"/>
       <xsd:element sql:field="CUBE_NAME" name="CUBE_NAME" type="xsd:string"/>
       <xsd:element sql:field="DIMENSION_UNIQUE_NAME" name="DIMENSION_UNIQUE_NAME" type="xsd:string"/>
       <xsd:element sql:field="HIERARCHY_NAME" name="HIERARCHY_NAME" type="xsd:string"/>
       <xsd:element sql:field="HIERARCHY_UNIQUE_NAME" name="HIERARCHY_UNIQUE_NAME" type="xsd:string"/>
       <xsd:element sql:field="HIERARCHY_GUID" name="HIERARCHY_GUID" type="uuid" minOccurs="0"/>
       <xsd:element sql:field="HIERARCHY_CAPTION" name="HIERARCHY_CAPTION" type="xsd:string"/>
       <xsd:element sql:field="DIMENSION_TYPE" name="DIMENSION_TYPE" type="xsd:short"/>
       <xsd:element sql:field="HIERARCHY_CARDINALITY" name="HIERARCHY_CARDINALITY" type="xsd:unsignedInt"/>
       <xsd:element sql:field="DEFAULT_MEMBER" name="DEFAULT_MEMBER" type="xsd:string" minOccurs="0"/>
       <xsd:element sql:field="ALL_MEMBER" name="ALL_MEMBER" type="xsd:string" minOccurs="0"/>
       <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsd:string" minOccurs="0"/>
       <xsd:element sql:field="STRUCTURE" name="STRUCTURE" type="xsd:short"/>
       <xsd:element sql:field="IS_VIRTUAL" name="IS_VIRTUAL" type="xsd:boolean"/>
       <xsd:element sql:field="IS_READWRITE" name="IS_READWRITE" type="xsd:boolean"/>
       <xsd:element sql:field="DIMENSION_UNIQUE_SETTINGS" name="DIMENSION_UNIQUE_SETTINGS" type="xsd:int"/>
       <xsd:element sql:field="DIMENSION_IS_VISIBLE" name="DIMENSION_IS_VISIBLE" type="xsd:boolean"/>
       <xsd:element sql:field="HIERARCHY_IS_VISIBLE" name="HIERARCHY_IS_VISIBLE" type="xsd:boolean"/>
       <xsd:element sql:field="HIERARCHY_ORDINAL" name="HIERARCHY_ORDINAL" type="xsd:unsignedInt"/>
       <xsd:element sql:field="DIMENSION_IS_SHARED" name="DIMENSION_IS_SHARED" type="xsd:boolean"/>
       <xsd:element sql:field="PARENT_CHILD" name="PARENT_CHILD" type="xsd:boolean" minOccurs="0"/>
       <xsd:element sql:field="LEVELS" name="LEVELS" minOccurs="0"/>
   </xsd:sequence>
</xsd:complexType>

<row>
   <CATALOG_NAME>FoodMart</CATALOG_NAME>
   <SCHEMA_NAME>FoodMart</SCHEMA_NAME>
   <CUBE_NAME>HR</CUBE_NAME>
   <DIMENSION_UNIQUE_NAME>[Department]</DIMENSION_UNIQUE_NAME>
   <HIERARCHY_NAME>Department</HIERARCHY_NAME>
   <HIERARCHY_UNIQUE_NAME>[Department]</HIERARCHY_UNIQUE_NAME>
   <HIERARCHY_CAPTION>Department</HIERARCHY_CAPTION>
   <DIMENSION_TYPE>3</DIMENSION_TYPE>
   <HIERARCHY_CARDINALITY>13</HIERARCHY_CARDINALITY>
   <DEFAULT_MEMBER>[Department].[All Departments]</DEFAULT_MEMBER>
   <ALL_MEMBER>[Department].[All Departments]</ALL_MEMBER>
   <DESCRIPTION>HR Cube - Department Hierarchy</DESCRIPTION>
   <STRUCTURE>0</STRUCTURE>
   <IS_VIRTUAL>false</IS_VIRTUAL>
   <IS_READWRITE>false</IS_READWRITE>
   <DIMENSION_UNIQUE_SETTINGS>0</DIMENSION_UNIQUE_SETTINGS>
   <DIMENSION_IS_VISIBLE>true</DIMENSION_IS_VISIBLE>
   <HIERARCHY_IS_VISIBLE>true</HIERARCHY_IS_VISIBLE>
   <HIERARCHY_ORDINAL>6</HIERARCHY_ORDINAL>
   <DIMENSION_IS_SHARED>true</DIMENSION_IS_SHARED>
   <PARENT_CHILD>false</PARENT_CHILD>
</row>
interface MDXHierarchy {
    __id__?: string;
    allLevelName?: string;
    allMember?: string;
    allMemberCaption?: string;
    allMemberName?: string;
    caption?: string;
    catalogName?: string;
    cubeName: string;
    dataType?: string;
    defaultMember?: string;
    description?: string;
    dimension?: string;
    dimensionIsShared: boolean;
    dimensionIsVisible: boolean;
    dimensionType: number;
    dimensionUniqueName: string;
    dimensionUniqueSettings: number;
    entity?: string;
    formatter?: string;
    hasAll?: boolean;
    hierarchyCaption: string;
    hierarchyCardinality: number;
    hierarchyGuid?: string;
    hierarchyIsVisible: boolean;
    hierarchyName: string;
    hierarchyOrdinal: number;
    hierarchyUniqueName: string;
    isReadwrite: boolean;
    isVirtual: boolean;
    join?: Join;
    levels?: MDXLevel[];
    memberCaption?: string;
    members?: Member[];
    name: string;
    parentChild?: boolean;
    primaryKey?: string;
    primaryKeyTable?: string;
    role?: AggregationRole;
    rt?: boolean;
    schemaName?: string;
    semantic?: Semantics;
    semantics?: {
        formatter?: string;
        semantic?: Semantics;
    };
    structure: number;
    tables?: Table[];
    text?: string | EntityProperty;
    uniqueName?: string;
    unit?: string | EntityProperty;
    visible?: boolean;
}

Hierarchy

  • PropertyHierarchy
  • MDXCube
    • MDXHierarchy

Properties

__id__? allLevelName? allMember? allMemberCaption? allMemberName? caption? catalogName? cubeName dataType? defaultMember? description? dimension? dimensionIsShared dimensionIsVisible dimensionType dimensionUniqueName dimensionUniqueSettings entity? formatter? hasAll? hierarchyCaption hierarchyCardinality hierarchyGuid? hierarchyIsVisible hierarchyName hierarchyOrdinal hierarchyUniqueName isReadwrite isVirtual join? levels? memberCaption? members? name parentChild? primaryKey? primaryKeyTable? role? rt? schemaName? semantic? semantics? structure tables? text? uniqueName? unit? visible?

Properties

Optional __id__

__id__?: string

Optional allLevelName

allLevelName?: string

Optional allMember

allMember?: string

Optional allMemberCaption

allMemberCaption?: string

Optional allMemberName

allMemberName?: string

Optional caption

caption?: string

Caption of dimension

Optional catalogName

catalogName?: string

cubeName

cubeName: string

Optional dataType

dataType?: string

Optional defaultMember

defaultMember?: string

Optional description

description?: string

Optional dimension

dimension?: string

dimensionIsShared

dimensionIsShared: boolean

dimensionIsVisible

dimensionIsVisible: boolean

dimensionType

dimensionType: number

dimensionUniqueName

dimensionUniqueName: string

dimensionUniqueSettings

dimensionUniqueSettings: number

Optional entity

entity?: string

所属的 Entity

Optional formatter

formatter?: string

Deprecated

use semantics

Optional hasAll

hasAll?: boolean

hierarchyCaption

hierarchyCaption: string

hierarchyCardinality

hierarchyCardinality: number

Optional hierarchyGuid

hierarchyGuid?: string

hierarchyIsVisible

hierarchyIsVisible: boolean

hierarchyName

hierarchyName: string

hierarchyOrdinal

hierarchyOrdinal: number

hierarchyUniqueName

hierarchyUniqueName: string

isReadwrite

isReadwrite: boolean

isVirtual

isVirtual: boolean

Optional join

join?: Join

Optional levels

levels?: MDXLevel[]

Optional memberCaption

memberCaption?: string

The caption field of members in this property

Optional members

members?: Member[]

如当 Dimension = "Measures" 时可以设置 members 为 ["Gross Margin", "Discount"] 等度量字段名 也可以为 dimension 设置固定的成员

name

name: string

Optional parentChild

parentChild?: boolean

Optional primaryKey

primaryKey?: string

Optional primaryKeyTable

primaryKeyTable?: string

Optional role

role?: AggregationRole

Property role

Optional rt

rt?: boolean

Property is in Runtime only, not in Semantic Model

Optional schemaName

schemaName?: string

Optional semantic

semantic?: Semantics

Deprecated

use semantics

Optional semantics

semantics?: {
    formatter?: string;
    semantic?: Semantics;
}

Type declaration

  • Optional formatter?: string
  • Optional semantic?: Semantics

structure

structure: number

Optional tables

tables?: Table[]

Optional text

text?: string | EntityProperty

Deprecated

use memberCaption

Optional uniqueName

uniqueName?: string

Optional unit

unit?: string | EntityProperty

Optional visible

visible?: boolean

Visible Property

Settings

Member Visibility

Theme

On This Page

Generated using TypeDoc