ANALYSIS_DB

index back

Cube Instance Definition


PeopleSoft Field NameField TypeColumn TypeDescription
ANALYSIS_DB_IDCharacter(15)VARCHAR2(15) NOT NULLCube Instance ID
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
DESCRLONGLong CharacterCLOBLong Description
ANALYSIS_PLATFORMCharacter(3)VARCHAR2(3) NOT NULLAnalysis Platform
ESS=Hyperion Essbase
IAS=PS/ROLAP
MOS=Microsoft OLAP Services
PPL=Cognos PowerPlay
STS=Generic Star Schema
ANALYSIS_MODEL_IDCharacter(15)VARCHAR2(15) NOT NULLCube Definition ID

Prompt Table: BASE_CUBE3_VW

BASE_CUBE_INST_IDCharacter(15)VARCHAR2(15) NOT NULLBase Cube Instance ID

Prompt Table: BASE_CUBE2_VW

ANALYSIS_DB_NAMECharacter(8)VARCHAR2(8) NOT NULLDatabase Name
ANALYSIS_DB_SERVERCharacter(30)VARCHAR2(30) NOT NULLDatabase Server
ANALYSIS_DB_APPCharacter(8)VARCHAR2(8) NOT NULLApplication Name
ANL_DB_LOGON_IDCharacter(30)VARCHAR2(30) NOT NULLUser Name
ANL_DB_LOGON_PASSCharacter(30)VARCHAR2(30) NOT NULLLogon Password
MD_UPDATE_ACTIONCharacter(1)VARCHAR2(1) NOT NULLMeta-Data Update Action
C=Create or Re-create
M=Incremental Update
N=No Action
R=Incremental Replace All
U=Incremental Update

Default: R

DATA_UPDATE_ACTIONCharacter(1)VARCHAR2(1) NOT NULLRestructuring options
A=Keep only input data
D=Keep only level 0 data
I=Reload all data
N=Keep all data
R=Discard all data

Default: D

RATE_UPDATE_ACTIONCharacter(1)VARCHAR2(1) NOT NULLRate Update Action
C=Create All
N=No Action
U=Rate Update Only

Default: N

RATE_CUBE_NAMECharacter(8)VARCHAR2(8) NOT NULLRate Cube Name
ESS_INTEL_RESTRUCTCharacter(1)VARCHAR2(1) NOT NULLIntelligent Restructure

Y/N Table Edit

Default: Y

ESS_INTEL_RECALCCharacter(1)VARCHAR2(1) NOT NULLIntelligent Recalc

Y/N Table Edit

Default: Y

ESS_USER_ACCESSCharacter(1)VARCHAR2(1) NOT NULLUser Access
C=Calculate
D=Design
N=None
R=Read-Only
W=Read-Write

Default: R

ESS_RUN_DEF_CALCCharacter(1)VARCHAR2(1) NOT NULLRun Default Calc

Y/N Table Edit

Default: Y

ESS_AUTO_SPARSITYCharacter(1)VARCHAR2(1) NOT NULLAuto Configure Sparsity

Default: Y

PPL_MDL_PATHFILECharacter(253)VARCHAR2(253) NOT NULLModel Path/File (.MDL)
PPL_MDC_PATHFILECharacter(253)VARCHAR2(253) NOT NULLPowerCube Path/File (.MDC)
PPL_LEVEL_COLUMNCharacter(1)VARCHAR2(1) NOT NULLData At Non Detail Members
PPL_DATA_PATHFILECharacter(253)VARCHAR2(253) NOT NULLData Working Directory
PPL_ALWAYS_INCLUDECharacter(1)VARCHAR2(1) NOT NULLAlways Include

Y/N Table Edit

Default: N

EARLIEST_DATEDate(10)DATEEarliest Date
LATEST_DATEDate(10)DATELatest Date
EARLIEST_DT_OPTIONCharacter(1)VARCHAR2(1) NOT NULLEarliest Date Option
A=Use As Of Date
C=Use Current Date
U=Use Specific Date
LATEST_DT_OPTIONCharacter(1)VARCHAR2(1) NOT NULLLatest Date Option
A=Use As Of Date
C=Use Current Date
U=Use Specific Date
IA_CATEGORYCharacter(30)VARCHAR2(30) NOT NULLDatamart Name
IA_CATALOGCharacter(30)VARCHAR2(30) NOT NULLCatalog Table Name
IA_PORTNumber(5,0)INTEGER NOT NULLService Port
NAME_PREFIXCharacter(4)VARCHAR2(4) NOT NULLName Prefix

Default: DW_

LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
VIRTUAL_CUBE_FLAGCharacter(1)VARCHAR2(1) NOT NULLVirtual Cube Flag

Y/N Table Edit

Default: N

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19