MSC_DISAGG_MEASURE_DATA

This table is used by snapshot to store the diaaggregate query for the measures loaded at aggregated level. The primary keys are id, plan_id, granularity_id and measure_is

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MSC_DISAGG_MEASURE_DATA_PK	PLAN_ID, GRANULARITY_ID, MEASURE_ID, ID

Columns

Name	Datatype	Length	Not-null	Comments
PLAN_ID	NUMBER		Yes	Identifier of the plan
GRANULARITY_ID	NUMBER		Yes	the granularity of Measure
MEASURE_ID	NUMBER		Yes	Identify the Measure
ID	NUMBER		Yes	Sequence of numbers from 1 . This starts form 1 for each plan.
UPDATE_SQL	CLOB			This is SQL query which is used for disaggregate of measure
SELECT_SQL	CLOB			SELECT_SQL is used to retrive the measures loaded at higher granular level
LEVEL_LIST	VARCHAR2	500	Yes	List of Level memebers
LEVEL_COUNT	NUMBER		Yes	The number of levels present in the measures
EXPRESSION	VARCHAR2	30	Yes	Expression shows if the meaure os value , date or text measure
LEVEL_NAME_ID_COMBO	VARCHAR2	500		This column store the level names and level Ids.
LAST_REFRESH_NUMBER	NUMBER			Last refresh number
CREATED_BY	VARCHAR2	64	Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP		Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32		Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATED_BY	VARCHAR2	64	Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP		Yes	Who column: indicates the date and time of the last update of the row.

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_DISAGG_MEASURE_DATA_U1	Unique	Default	PLAN_ID, GRANULARITY_ID, MEASURE_ID, ID