Consolidation Properties Flashcards Preview

EPM BPC 10.0 > Consolidation Properties > Flashcards

Flashcards in Consolidation Properties Deck (18):
1

Consolidation properties on account

AERT - I

C_ACCOUNT
ACCTYPE
ELIMACC
RATETYPE
TYPELIM

O_ACCOUNT
IS_INPUT
special_SYS

R_ACCOUNT (avg, clo, 3)
RATETYPE

2

Category

FxOR - 11

FX_DIFFERENCE_ONLY
FX_SOURCE_CATEGORY

OPENING_CATEGORY/ CATEGORY_FOR_OPE
OPENING_PERIOD
OPENING_YEAR

OWN_CATEGORY
OWN_PERIOD
OWN_YEAR

RATE_CATEGORY
RATE_PERIOD
RATE_YEAR

3

DataSource

CDIO - 6
COPY_OPENING

DATASRC_TYPE
DATASRC_STAGE

IS_CONSOL
IS_CONVERTED

OPENING_DATASRC

4

Entity

CEFxIO - 7
CONTROL_LEVEL
CTRL_CURRENCY_NOT_LC
CURRENCY
ELIM
FX_TYPE
INTCO
OWNER

5

Group

CDEFGPS - 10

CONSO_TYPE
CURRENCY_TYPE
DATASRC_LEVEL
ENTITY
FIRST_CONS_DATE
GROUP_CURRENCY
PARENT_GROUP
STAGE_ONLY
STORE_ENTITY
STORE_GROUP_CURRENCY

6

Intercompany

E - 1
Entity

7

ReportCurency

CR - 2
Currency Type
Reporting

8

S Flow Subtable

DF-2
Dimlist
Flowtype

9

Time

PYM-3
Period
Year
Monthnum

10

AERT-I

AERT - I -
C_ACCOUNT
ACCTYPE
ELIMACC
RATETYPE
TYPELIM

O_ACCOUNT
IS_INPUT
special_SYS

R_ACCOUNT (avg, clo, 3)
RATETYPE

11

CFxOR

FxOR - 11 --- CPY (Category, Period, Year)

FX_DIFFERENCE_ONLY
FX_SOURCE_CATEGORY
Opening_Category/CATEGORY_FOR_OPE
OPENING_PERIOD
OPENING_YEAR
OWN_CATEGORY
OWN_PERIOD
OWN_YEAR
RATE_CATEGORY
RATE_PERIOD
RATE_YEAR

12

CDIO

CDIO-6

COPY_OPENING
DATASRC_TYPE
DATASRC_STAGE
IS_CONSOL
IS_CONVERTED
OPENING_DATASRC

13

CDEFGPS

CDEFGPS -10

CONSO_TYPE
CURRENCY_TYPE
DATASRC_LEVEL
ENTITY
FIRST_CONS_DATE
GROUP_CURRENCY
PARENT_GROUP
STAGE_ONLY
STORE_ENTITY
STORE_GROUP_CURRENCY

14

InterCompany

E1 Entity

15

CR2

Currency Type
Reporting

currency dimension

16

DF2

DIM_LIST
FLOW_TYPE

subtable, flow dimension

17

PYM3

PERIOD
YEAR
MONTHNUM

time dimension

18

AERT - I
CFxOR - 11
CDIO - 6
CEFxIO -7
CDEFGPS - 10
E - 1
CR - 2
DF -2
PYM 3

ACCOUNT
CATEGORY 11
D 1
ENTITY 1
G -GROUP or SCOPE
I - intercompany
R - currency
S - FLOW or SUBTABLE
TIME