ANALYSIS_DB

index back

Cube Instance Definition


PeopleSoft Field Name Field Type Column Type Description
ANALYSIS_DB_ID Character(15) VARCHAR2(15) NOT NULL Cube Instance ID
DESCR Character(30) VARCHAR2(30) NOT NULL Description
DESCRLONG Long Character CLOB Long Description
ANALYSIS_PLATFORM Character(3) VARCHAR2(3) NOT NULL Analysis Platform
ESS=Hyperion Essbase
IAS=PS/ROLAP
MOS=Microsoft OLAP Services
PPL=Cognos PowerPlay
STS=Generic Star Schema
ANALYSIS_MODEL_ID Character(15) VARCHAR2(15) NOT NULL Cube Definition ID

Prompt Table: BASE_CUBE3_VW

BASE_CUBE_INST_ID Character(15) VARCHAR2(15) NOT NULL Base Cube Instance ID

Prompt Table: BASE_CUBE2_VW

ANALYSIS_DB_NAME Character(8) VARCHAR2(8) NOT NULL Database Name
ANALYSIS_DB_SERVER Character(30) VARCHAR2(30) NOT NULL Database Server
ANALYSIS_DB_APP Character(8) VARCHAR2(8) NOT NULL Application Name
ANL_DB_LOGON_ID Character(30) VARCHAR2(30) NOT NULL User Name
ANL_DB_LOGON_PASS Character(30) VARCHAR2(30) NOT NULL Logon Password
MD_UPDATE_ACTION Character(1) VARCHAR2(1) NOT NULL Meta-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_ACTION Character(1) VARCHAR2(1) NOT NULL Restructuring 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_ACTION Character(1) VARCHAR2(1) NOT NULL Rate Update Action
C=Create All
N=No Action
U=Rate Update Only

Default: N

RATE_CUBE_NAME Character(8) VARCHAR2(8) NOT NULL Rate Cube Name
ESS_INTEL_RESTRUCT Character(1) VARCHAR2(1) NOT NULL Intelligent Restructure

Y/N Table Edit

Default: Y

ESS_INTEL_RECALC Character(1) VARCHAR2(1) NOT NULL Intelligent Recalc

Y/N Table Edit

Default: Y

ESS_USER_ACCESS Character(1) VARCHAR2(1) NOT NULL User Access
C=Calculate
D=Design
N=None
R=Read-Only
W=Read-Write

Default: R

ESS_RUN_DEF_CALC Character(1) VARCHAR2(1) NOT NULL Run Default Calc

Y/N Table Edit

Default: Y

ESS_AUTO_SPARSITY Character(1) VARCHAR2(1) NOT NULL Auto Configure Sparsity

Default: Y

PPL_MDL_PATHFILE Character(253) VARCHAR2(253) NOT NULL Model Path/File (.MDL)
PPL_MDC_PATHFILE Character(253) VARCHAR2(253) NOT NULL PowerCube Path/File (.MDC)
PPL_LEVEL_COLUMN Character(1) VARCHAR2(1) NOT NULL Data At Non Detail Members
PPL_DATA_PATHFILE Character(253) VARCHAR2(253) NOT NULL Data Working Directory
PPL_ALWAYS_INCLUDE Character(1) VARCHAR2(1) NOT NULL Always Include

Y/N Table Edit

Default: N

EARLIEST_DATE Date(10) DATE Earliest Date
LATEST_DATE Date(10) DATE Latest Date
EARLIEST_DT_OPTION Character(1) VARCHAR2(1) NOT NULL Earliest Date Option
A=Use As Of Date
C=Use Current Date
U=Use Specific Date
LATEST_DT_OPTION Character(1) VARCHAR2(1) NOT NULL Latest Date Option
A=Use As Of Date
C=Use Current Date
U=Use Specific Date
IA_CATEGORY Character(30) VARCHAR2(30) NOT NULL Datamart Name
IA_CATALOG Character(30) VARCHAR2(30) NOT NULL Catalog Table Name
IA_PORT Number(5,0) INTEGER NOT NULL Service Port
NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

Default: DW_

LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
VIRTUAL_CUBE_FLAG Character(1) VARCHAR2(1) NOT NULL Virtual Cube Flag

Y/N Table Edit

Default: N

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