Previous Topic: V_FORMULA_TO_RAW_DATANext Topic: V_FORMULA_TO_DATA

Business Intelligence (BI) Interface Guide › Business Intelligence Interface › SQL Interfaces › Additional Calculated Data Interface › V_FORMULA_TO_INTERMEDIATE_DATA

V_FORMULA_TO_INTERMEDIATE_DATA

This view enables the user to retrieve intermediate data events while filtering those events according to the formulas that used them.

The view exposes the field FORMULA_ID which is a foreign key to T_FORMULAS and in addition the 112 fields that make up the table T_INTERMEDIATE_DATA_FIELDS:

Name

Type

Content

FORMULA_ID

number

Foreign Key to T_FORMULAS

It points to a formula that uses this event.

METRIC_EVENT_ID

number

The ID of the event in T_INTERMEDIATE_DATA.

METRIC_ID

number

Foreign Key to T_RULES.

METRIC_GLOBAL_ID

number

Foreign Key to T_GLOBAL_RULES.

EVENT_TYPE_ID

number

Foreign Key to T_EVENT_TYPES.

RESOURCE_ID

number

Foreign Key to T_RESOURCES. Null if the Event is not related to a specific Resource.

TIME_UNIT

varchar2(30)

Refers to the sending Metric: HOUR/DAY/WEEK/MONTH/QUARTER/YEAR (for doing a join with V_PSL_EXTENDED).

IS_PERIOD

number

Refers to the sending Metric:

  • 0 - Operational calculation.
  • 1 - Business calculation according to the tracking period defined in the contract.

COMPLETE_PERIOD

number

Refers to the sending Metric:

  • 0 - Ongoing calculation in the middle of a period.
  • 1 - Calculation of a period that was completed.

INTERVAL_LENGTH

number

Refers to the sending Metric: the number of TIME_UNITs in the calculated period.

SRC_TIME_STAMP

date

The time stamp of the event was written.

TRG_TIME_STAMP

date

Time stamp of the Event (UTC time).

WITH_EXCEPTION

number
  • 0 - Calculation that ignores Exceptions.
  • 1 - Calculation that takes Exceptions into account.

WITH_CORRECTION

number
  • 0 - Calculation that ignores Corrections.
  • 1 - Calculation that takes Corrections into account.

CORRECTION_FOLDED

number
  • 0 - Correction took place, and the current calculation was performed with and without Corrections separately.
  • 1 - No Correction took place, and the current calculation was performed with and without Corrections together.

EXCEPTION_FOLDED

number
  • 0 - Exception took place, and the current calculation was performed with and without Exceptions separately.
  • 1 - No Exception took place, and the current calculation was performed with and without Exceptions together.

CREATE_DATE

date

Creation date of the record.

MODIFY_DATE

date

Modification date of the record.

CALCULATION_MODE

varchar2(20)

Either NORMAL or FORECAST.

DATA_HTML

CLOB

Aggregation of all values of all the dynamic fields of the event in HTML format including field names.

HTML_DATA_STR

varchar2(4000)

The first 4000 characters of the HTML data.

Note: This field content might not be complete if the event data is longer than 4000 characters.

FIELD_001

varchar2(4000)

The 1st value of the first dynamic field of this event

FIELD_002

varchar2(4000)

The 2nd value of the first dynamic field of this event

FIELD_099

varchar2(4000)

The 99th value of the first dynamic field of this event

FIELD_100

varchar2(4000)

The 100th value of the first dynamic field of this event

Each event has an event type and each event type has a predefined structure which dictates how many (if at all) dynamic fields it has, their names, order and type. So one event of a certain type may have three dynamic fields and another may have 10 fields.