Interface MDXMeasure

<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="MEASURE_NAME" name="MEASURE_NAME" type="xsd:string"/>
       <xsd:element sql:field="MEASURE_UNIQUE_NAME" name="MEASURE_UNIQUE_NAME" type="xsd:string"/>
       <xsd:element sql:field="MEASURE_CAPTION" name="MEASURE_CAPTION" type="xsd:string"/>
       <xsd:element sql:field="MEASURE_GUID" name="MEASURE_GUID" type="uuid" minOccurs="0"/>
       <xsd:element sql:field="MEASURE_AGGREGATOR" name="MEASURE_AGGREGATOR" type="xsd:int"/>
       <xsd:element sql:field="DATA_TYPE" name="DATA_TYPE" type="xsd:unsignedShort"/>
       <xsd:element sql:field="MEASURE_IS_VISIBLE" name="MEASURE_IS_VISIBLE" type="xsd:boolean"/>
       <xsd:element sql:field="LEVELS_LIST" name="LEVELS_LIST" type="xsd:string" minOccurs="0"/>
       <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsd:string" minOccurs="0"/>
       <xsd:element sql:field="DEFAULT_FORMAT_STRING" name="DEFAULT_FORMAT_STRING" type="xsd:string" minOccurs="0"/>
   </xsd:sequence>
</xsd:complexType>
interface MDXMeasure {
    __id__?: string;
    caption?: string;
    catalogName?: string;
    column?: string;
    cubeName: string;
    dataType?: string;
    defaultFormatString?: string;
    defaultHierarchy?: string;
    description?: string;
    dimension?: string;
    entity?: string;
    expression?: string;
    foreignKey?: string;
    formatter?: string;
    hierarchies?: PropertyHierarchy[];
    hierarchyLevelFor?: string;
    hierarchyNodeFor?: string;
    hierarchyParentNodeFor?: string;
    keyExpression?: SQLExpression;
    levelsList?: string;
    measureAggregator: number;
    measureCaption: string;
    measureGuid?: string;
    measureIsVisible: boolean;
    measureName: string;
    measureUniqueName: string;
    memberCaption?: string;
    members?: Member[];
    name: string;
    properties?: EntityProperty[];
    role?: AggregationRole;
    rt?: boolean;
    schemaName?: string;
    semantic?: Semantics;
    semantics?: {
        formatter?: string;
        semantic?: Semantics;
    };
    text?: string | EntityProperty;
    type?: string;
    uniqueName?: string;
    unit?: string | EntityProperty;
    visible?: boolean;
}

Hierarchy

Properties

__id__? caption? catalogName? column? cubeName dataType? defaultFormatString? defaultHierarchy? description? dimension? entity? expression? foreignKey? formatter? hierarchies? hierarchyLevelFor? hierarchyNodeFor? hierarchyParentNodeFor? keyExpression? levelsList? measureAggregator measureCaption measureGuid? measureIsVisible measureName measureUniqueName memberCaption? members? name properties? role? rt? schemaName? semantic? semantics? text? type? uniqueName? unit? visible?

Properties

Optional __id__

__id__?: string

Optional caption

caption?: string

Caption of dimension

Optional catalogName

catalogName?: string

Optional column

column?: string

The column of Dimension table for this property

cubeName

cubeName: string

Optional dataType

dataType?: string

Optional defaultFormatString

defaultFormatString?: string

Optional defaultHierarchy

defaultHierarchy?: string

Optional description

description?: string

Optional dimension

dimension?: string

Optional entity

entity?: string

所属的 Entity

Optional expression

expression?: string

Optional foreignKey

foreignKey?: string

The foreignKey of Fact table for this property

Optional formatter

formatter?: string

Deprecated

use semantics

Optional hierarchies

hierarchies?: PropertyHierarchy[]

Optional hierarchyLevelFor

hierarchyLevelFor?: string

Deprecated

Optional hierarchyNodeFor

hierarchyNodeFor?: string

Deprecated

Optional hierarchyParentNodeFor

hierarchyParentNodeFor?: string

Deprecated

Optional keyExpression

keyExpression?: SQLExpression

Optional levelsList

levelsList?: string

measureAggregator

measureAggregator: number

measureCaption

measureCaption: string

Optional measureGuid

measureGuid?: string

measureIsVisible

measureIsVisible: boolean

measureName

measureName: string

measureUniqueName

measureUniqueName: string

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 properties

properties?: EntityProperty[]

维度的属性字段

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

Optional text

text?: string | EntityProperty

Deprecated

use memberCaption

Optional type

type?: string

维度类型, 或字段 DB 类型

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