enums ¶

enum mstrio.modeling.expression.enums.DependenceType(value)¶

Bases: AutoName

Enumeration constant indicating the dependence type of expression node

Valid values are as follows:

DEFAULT = DependenceType.DEFAULT¶

INDEPENDENT = DependenceType.INDEPENDENT¶

DEPENDENT = DependenceType.DEPENDENT¶

The Enum and its members also have the following methods:

classmethod has_value(value)¶

enum mstrio.modeling.expression.enums.DimtyType(value)¶

Bases: AutoName

Enumeration constant indicating the dimty type of expression node

Valid values are as follows:

NONE = DimtyType.NONE¶

CONTINUATION = DimtyType.CONTINUATION¶

EXCLUSIVE_CONTINUATION = DimtyType.EXCLUSIVE_CONTINUATION¶

OUTPUT_LEVEL = DimtyType.OUTPUT_LEVEL¶

BREAK_BY = DimtyType.BREAK_BY¶

EMBEDDED = DimtyType.EMBEDDED¶

UNSPECIFIED = DimtyType.UNSPECIFIED¶

PARAMETER = DimtyType.PARAMETER¶

The Enum and its members also have the following methods:

classmethod has_value(value)¶

enum mstrio.modeling.expression.enums.ExpressionFormat(value)¶

Bases: AutoName

Expression format to be fetched from server, it might be tree or token: - tree: tree data structure fully defining the expression. This format can be used if you want to examine and modify the expression programmatically. - tokens: list of parsed tokens. This format can be used if you want to examine and modify the expression using the parser component. Note that generating tokens requires additional time.

Valid values are as follows:

TREE = ExpressionFormat.TREE¶

TOKENS = ExpressionFormat.TOKENS¶

The Enum and its members also have the following methods:

classmethod has_value(value)¶

enum mstrio.modeling.expression.enums.ExpressionType(value)¶

Bases: AutoName

Enumeration constant indicating the expression type of expression node

Valid values are as follows:

DYNAMIC = ExpressionType.DYNAMIC¶

STATIC = ExpressionType.STATIC¶

GENERIC = ExpressionType.GENERIC¶

FILTER_SINGLE_BASE_FORM_QUAL = ExpressionType.FILTER_SINGLE_BASE_FORM_QUAL¶

FILTER_MULTI_BASE_FORM_QUAL = ExpressionType.FILTER_MULTI_BASE_FORM_QUAL¶

FILTER_JOINT_FORM_QUAL = ExpressionType.FILTER_JOINT_FORM_QUAL¶

FILTER_LIST_QUAL = ExpressionType.FILTER_LIST_QUAL¶

FILTER_LIST_FORM_QUAL = ExpressionType.FILTER_LIST_FORM_QUAL¶

FILTER_JOINT_LIST_QUAL = ExpressionType.FILTER_JOINT_LIST_QUAL¶

FILTER_JOINT_LIST_FORM_QUAL = ExpressionType.FILTER_JOINT_LIST_FORM_QUAL¶

FILTER_SINGLE_BASE_FORM_EXPRESSION = ExpressionType.FILTER_SINGLE_BASE_FORM_EXPRESSION¶

FILTER_SINGLE_METRIC_QUAL = ExpressionType.FILTER_SINGLE_METRIC_QUAL¶

FILTER_MULTI_METRIC_QUAL = ExpressionType.FILTER_MULTI_METRIC_QUAL¶

FILTER_METRIC_EXPRESSION = ExpressionType.FILTER_METRIC_EXPRESSION¶

FILTER_EMBED_QUAL = ExpressionType.FILTER_EMBED_QUAL¶

FILTER_BRANCH_QUAL = ExpressionType.FILTER_BRANCH_QUAL¶

FILTER_RELATIONSHIP_QUAL = ExpressionType.FILTER_RELATIONSHIP_QUAL¶

FILTER_ALL_ATTRIBUTE_QUAL = ExpressionType.FILTER_ALL_ATTRIBUTE_QUAL¶

FILTER_ATTRIBUTE_ID_QUAL = ExpressionType.FILTER_ATTRIBUTE_ID_QUAL¶

FILTER_ATTRIBUTE_DESC_QUAL = ExpressionType.FILTER_ATTRIBUTE_DESC_QUAL¶

AGG_METRIC = ExpressionType.AGG_METRIC¶

BANDING = ExpressionType.BANDING¶

FILTER_REPORT_QUAL = ExpressionType.FILTER_REPORT_QUAL¶

MDX_SAP_VARIABLE = ExpressionType.MDX_SAP_VARIABLE¶

SQL_QUERY_QUAL = ExpressionType.SQL_QUERY_QUAL¶

CANCELED_PROMPT = ExpressionType.CANCELED_PROMPT¶

ELEMENT_LIST = ExpressionType.ELEMENT_LIST¶

ELEMENT_SINGLE = ExpressionType.ELEMENT_SINGLE¶

FORM_OF_THIS_ATTRIBUTE = ExpressionType.FORM_OF_THIS_ATTRIBUTE¶

CSI_UPDATE = ExpressionType.CSI_UPDATE¶

CSI_INSERT = ExpressionType.CSI_INSERT¶

CSI_DELETE = ExpressionType.CSI_DELETE¶

CSI_GROUP = ExpressionType.CSI_GROUP¶

The Enum and its members also have the following methods:

classmethod has_value(value)¶

enum mstrio.modeling.expression.enums.Function(value)¶

Bases: AutoName

Enumeration constant used to specify the function used for calculation in expression nodes

Valid values are as follows:

THIRD_PARTY = Function.THIRD_PARTY¶

CUSTOM = Function.CUSTOM¶

PLUS = Function.PLUS¶

MINUS = Function.MINUS¶

TIMES = Function.TIMES¶

DIVIDE = Function.DIVIDE¶

UNARY_MINUS = Function.UNARY_MINUS¶

EQUALS = Function.EQUALS¶

NOT_EQUAL = Function.NOT_EQUAL¶

GREATER = Function.GREATER¶

LESS = Function.LESS¶

GREATER_EQUAL = Function.GREATER_EQUAL¶

LESS_EQUAL = Function.LESS_EQUAL¶

SUM = Function.SUM¶

COUNT = Function.COUNT¶

AVG = Function.AVG¶

MIN = Function.MIN¶

MAX = Function.MAX¶

BETWEEN = Function.BETWEEN¶

LIKE = Function.LIKE¶

AND = Function.AND¶

OR = Function.OR¶

NOT = Function.NOT¶

IN = Function.IN¶

RANK = Function.RANK¶

ABS = Function.ABS¶

RUNNING_SUM = Function.RUNNING_SUM¶

RUNNING_AVG = Function.RUNNING_AVG¶

MOVING_SUM = Function.MOVING_SUM¶

MOVING_AVG = Function.MOVING_AVG¶

PRODUCT = Function.PRODUCT¶

MEDIAN = Function.MEDIAN¶

MODE = Function.MODE¶

STDEV = Function.STDEV¶

VAR = Function.VAR¶

GEOMEAN = Function.GEOMEAN¶

EQUAL_ENHANCED = Function.EQUAL_ENHANCED¶

NOT_EQUAL_ENHANCED = Function.NOT_EQUAL_ENHANCED¶

GREATER_EQUAL_ENHANCED = Function.GREATER_EQUAL_ENHANCED¶

LESS_EQUAL_ENHANCED = Function.LESS_EQUAL_ENHANCED¶

BETWEEN_ENHANCED = Function.BETWEEN_ENHANCED¶

BANDING = Function.BANDING¶

BANDING_C = Function.BANDING_C¶

BANDING_P = Function.BANDING_P¶

NOT_LIKE = Function.NOT_LIKE¶

NOT_BETWEEN = Function.NOT_BETWEEN¶

INTERSECT = Function.INTERSECT¶

INTERSECT_IN = Function.INTERSECT_IN¶

NULL_TO_ZERO = Function.NULL_TO_ZERO¶

ZERO_TO_NULL = Function.ZERO_TO_NULL¶

APPLY_SIMPLE = Function.APPLY_SIMPLE¶

APPLY_AGGREGATION = Function.APPLY_AGGREGATION¶

APPLY_LOGIC = Function.APPLY_LOGIC¶

APPLY_COMPARISON = Function.APPLY_COMPARISON¶

APPLY_RELATIVE = Function.APPLY_RELATIVE¶

IS_NULL = Function.IS_NULL¶

IS_NOT_NULL = Function.IS_NOT_NULL¶

UCASE = Function.UCASE¶

NOT_IN = Function.NOT_IN¶

N_TILE = Function.N_TILE¶

PERCENTILE = Function.PERCENTILE¶

MOVING_MAX = Function.MOVING_MAX¶

MOVING_MIN = Function.MOVING_MIN¶

MOVING_DIFFERENCE = Function.MOVING_DIFFERENCE¶

MOVING_STDEV = Function.MOVING_STDEV¶

EXP_WGH_MOVING_AVG = Function.EXP_WGH_MOVING_AVG¶

MOVING_COUNT = Function.MOVING_COUNT¶

RUNNING_MAX = Function.RUNNING_MAX¶

RUNNING_MIN = Function.RUNNING_MIN¶

RUNNING_STDEV = Function.RUNNING_STDEV¶

RUNNING_COUNT = Function.RUNNING_COUNT¶

EXP_WGH_RUNNING_AVG = Function.EXP_WGH_RUNNING_AVG¶

NOT_BETWEEN_ENHANCED = Function.NOT_BETWEEN_ENHANCED¶

CONCAT = Function.CONCAT¶

FIRST_IN_RANGE = Function.FIRST_IN_RANGE¶

LAST_IN_RANGE = Function.LAST_IN_RANGE¶

VALUE_SEGMENT = Function.VALUE_SEGMENT¶

CONTAINS = Function.CONTAINS¶

BEGINS_WITH = Function.BEGINS_WITH¶

ENDS_WITH = Function.ENDS_WITH¶

NOT_CONTAINS = Function.NOT_CONTAINS¶

NOT_BEGINS_WITH = Function.NOT_BEGINS_WITH¶

NOT_ENDS_WITH = Function.NOT_ENDS_WITH¶

CASE = Function.CASE¶

CASE_V = Function.CASE_V¶

STDEV_P = Function.STDEV_P¶

RUNNING_STDEV_P = Function.RUNNING_STDEV_P¶

MOVING_STDEV_P = Function.MOVING_STDEV_P¶

N_TILE_S = Function.N_TILE_S¶

N_TILE_VS = Function.N_TILE_VS¶

VAR_P = Function.VAR_P¶

CURRENT_DATE = Function.CURRENT_DATE¶

DAY_OF_MONTH = Function.DAY_OF_MONTH¶

DAY_OF_WEEK = Function.DAY_OF_WEEK¶

DAY_OF_YEAR = Function.DAY_OF_YEAR¶

WEEK = Function.WEEK¶

MONTH = Function.MONTH¶

QUARTER = Function.QUARTER¶

YEAR = Function.YEAR¶

CURRENT_DATE_TIME = Function.CURRENT_DATE_TIME¶

CURRENT_TIME = Function.CURRENT_TIME¶

HOUR = Function.HOUR¶

MINUTE = Function.MINUTE¶

SECOND = Function.SECOND¶

MILLI_SECOND = Function.MILLI_SECOND¶

CONCAT_NO_BLANK = Function.CONCAT_NO_BLANK¶

LENGTH = Function.LENGTH¶

LOWER = Function.LOWER¶

L_TRIM = Function.L_TRIM¶

POSITION = Function.POSITION¶

R_TRIM = Function.R_TRIM¶

SUB_STR = Function.SUB_STR¶

INIT_CAP = Function.INIT_CAP¶

TRIM = Function.TRIM¶

RIGHT_STR = Function.RIGHT_STR¶

LEFT_STR = Function.LEFT_STR¶

GREATEST = Function.GREATEST¶

LEAST = Function.LEAST¶

FIRST = Function.FIRST¶

LAST = Function.LAST¶

DATE = Function.DATE¶

DAYS_BETWEEN = Function.DAYS_BETWEEN¶

MONTHS_BETWEEN = Function.MONTHS_BETWEEN¶

ADD_DAYS = Function.ADD_DAYS¶

ADD_MONTHS = Function.ADD_MONTHS¶

MONTH_START_DATE = Function.MONTH_START_DATE¶

MONTH_END_DATE = Function.MONTH_END_DATE¶

YEAR_START_DATE = Function.YEAR_START_DATE¶

YEAR_END_DATE = Function.YEAR_END_DATE¶

IF = Function.IF¶

APPLY_OPTIONAL = Function.APPLY_OPTIONAL¶

APPLY_CS_SECURITY_FILTER = Function.APPLY_CS_SECURITY_FILTER¶

UNION = Function.UNION¶

EXCEPT = Function.EXCEPT¶

COALESCE = Function.COALESCE¶

ADD = Function.ADD¶

AVERAGE = Function.AVERAGE¶

MULTIPLY = Function.MULTIPLY¶

BANDING_M = Function.BANDING_M¶

OLAP_SUM = Function.OLAP_SUM¶

OLAP_AVG = Function.OLAP_AVG¶

OLAP_COUNT = Function.OLAP_COUNT¶

OLAP_MAX = Function.OLAP_MAX¶

OLAP_MIN = Function.OLAP_MIN¶

LAG = Function.LAG¶

LEAD = Function.LEAD¶

OLAP_RANK = Function.OLAP_RANK¶

REPEAT = Function.REPEAT¶

BIT_AND = Function.BIT_AND¶

BIT_OR = Function.BIT_OR¶

BIT_XOR = Function.BIT_XOR¶

BIT_NOT = Function.BIT_NOT¶

BIT_LEFT_SHIFT = Function.BIT_LEFT_SHIFT¶

BIT_RIGHT_SHIFT = Function.BIT_RIGHT_SHIFT¶

AMPERSAND = Function.AMPERSAND¶

ORDINAL_RANK = Function.ORDINAL_RANK¶

HISTOGRAM_MEDIAN = Function.HISTOGRAM_MEDIAN¶

BAND_NAMES = Function.BAND_NAMES¶

PERCENT_RANK_RELATIVE = Function.PERCENT_RANK_RELATIVE¶

SEARCH = Function.SEARCH¶

IF_BY_DIMTY = Function.IF_BY_DIMTY¶

GET_EXTRA_OUTPUT = Function.GET_EXTRA_OUTPUT¶

TO_DATE_TIME = Function.TO_DATE_TIME¶

QUARTER_START_DATE = Function.QUARTER_START_DATE¶

WEEK_START_DATE = Function.WEEK_START_DATE¶

TO_STRING = Function.TO_STRING¶

TO_NUMBER = Function.TO_NUMBER¶

PERCENT_RANK = Function.PERCENT_RANK¶

STR_REPLACE = Function.STR_REPLACE¶

STR_MATCH = Function.STR_MATCH¶

STR_SPLIT = Function.STR_SPLIT¶

STR_CHAR = Function.STR_CHAR¶

STR_REPEAT = Function.STR_REPEAT¶

DATE_DIFF = Function.DATE_DIFF¶

STR_BEGINS_WITH = Function.STR_BEGINS_WITH¶

STR_ENDS_WITH = Function.STR_ENDS_WITH¶

WEIGHT_STD_P = Function.WEIGHT_STD_P¶

WEIGHT_MEAN_AVE = Function.WEIGHT_MEAN_AVE¶

CONCAT_AGG = Function.CONCAT_AGG¶

WEIGHT_COV = Function.WEIGHT_COV¶

WEIGHT_CORR = Function.WEIGHT_CORR¶

STR_LAST_POSITION = Function.STR_LAST_POSITION¶

STR_TITLE_CAP = Function.STR_TITLE_CAP¶

FISCAL_WEEK = Function.FISCAL_WEEK¶

FISCAL_MONTH = Function.FISCAL_MONTH¶

FISCAL_QUARTER = Function.FISCAL_QUARTER¶

FISCAL_YEAR = Function.FISCAL_YEAR¶

NULL_TO_EMPTY = Function.NULL_TO_EMPTY¶

DESCENDANTS = Function.DESCENDANTS¶

ANCESTORS = Function.ANCESTORS¶

PARENTS = Function.PARENTS¶

CHILDREN = Function.CHILDREN¶

TUPLE = Function.TUPLE¶

The Enum and its members also have the following methods:

classmethod has_value(value)¶

enum mstrio.modeling.expression.enums.IsIndependent(value)¶

Bases: Enum

Flag that indicates whether a node will be evaluated independently of other parts of the larger expression

Valid values are as follows:

YES = <IsIndependent.YES: 1>¶

NO = <IsIndependent.NO: 0>¶

enum mstrio.modeling.expression.enums.NodeType(value)¶

Bases: AutoName

Enumeration constant indicating the type of node within the expression tree

Valid values are as follows:

OPERATOR = NodeType.OPERATOR¶

OBJECT_REFERENCE = NodeType.OBJECT_REFERENCE¶

COLUMN_REFERENCE = NodeType.COLUMN_REFERENCE¶

CONSTANT = NodeType.CONSTANT¶

RELATIONSHIP = NodeType.RELATIONSHIP¶

FORM_SHORTCUT = NodeType.FORM_SHORTCUT¶

DYNAMIC_DATE_TIME = NodeType.DYNAMIC_DATE_TIME¶

PREDICATE_CUSTOM = NodeType.PREDICATE_CUSTOM¶

PREDICATE_PROMPT_QUALIFICATION = NodeType.PREDICATE_PROMPT_QUALIFICATION¶

PREDICATE_METRIC_QUALIFICATION = NodeType.PREDICATE_METRIC_QUALIFICATION¶

PREDICATE_RELATIONSHIP = NodeType.PREDICATE_RELATIONSHIP¶

PREDICATE_JOINT_ELEMENT_LIST = NodeType.PREDICATE_JOINT_ELEMENT_LIST¶

PREDICATE_ELEMENT_LIST = NodeType.PREDICATE_ELEMENT_LIST¶

PREDICATE_FORM_QUALIFICATION = NodeType.PREDICATE_FORM_QUALIFICATION¶

PREDICATE_FILTER_QUALIFICATION = NodeType.PREDICATE_FILTER_QUALIFICATION¶

PREDICATE_REPORT_QUALIFICATION = NodeType.PREDICATE_REPORT_QUALIFICATION¶

PREDICATE_BANDING_SIZE = NodeType.PREDICATE_BANDING_SIZE¶

PREDICATE_BANDING_COUNT = NodeType.PREDICATE_BANDING_COUNT¶

PREDICATE_BANDING_POINTS = NodeType.PREDICATE_BANDING_POINTS¶

PREDICATE_BANDING_DISTINCT = NodeType.PREDICATE_BANDING_DISTINCT¶

The Enum and its members also have the following methods:

classmethod has_value(value)¶

mstrio > modeling > expression > enums ¶

mstrio-py

Navigation

Related Topics

mstrio > modeling > expression > enums¶

mstrio > modeling > expression > enums ¶