IACALCMBR

UPDATED BY
ACBA.1 ACBC.1 ACBP.1 ACBR.1 ACBS.1 ACBU.1
ACBY.1 AMAS.1 AMBK.1 AMCV.1 AMLF.1 AMMD.1
AMME.1 AMPD.1 AMYR.1 CBBB.1 CBBC.1 CBBD.1
CBBO.1 CBBR.1 CBBT.1 HCAG.1 HCCP.1 HCEM.1
HCHM.1 HCJC.1 HCMS.1 HCPO.1 HCRV.1 HCSC.1
HCSU.1 HCYR.1 IA120 IA150 IAMB.1 IATM.1
IAVO.1 IAYR.1 GLBA.1 GLBD.1 GLBP.1 GLBT.1
GLBY.1 IFBA.1 IFBC.1 IFBO.1 IFBS.1 POAB.1
POAM.1 POAO.1 POAP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CCM-DIM-OBJ-ID
Element: Dim Obj Id
Numeric 12
The Dimension Object Identifier field contains a unique numeric identifier assigned to the dimension, which associates this record to the member records.
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 AMAS.1
AMBK.1 AMCV.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
HCAG.1 HCCP.1
HCEM.1 HCHM.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAMB.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1 POAB.1
POAM.1 POAO.1
POAP.1
CCM-MEMBER-NAME
Element: Member Name
Alpha 50 (Lower Case)
This is an override member name for Data Mart dimensions with no association to a Budget dimension.
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 AMAS.1
AMBK.1 AMCV.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
HCAG.1 HCCP.1
HCEM.1 HCHM.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAMB.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1 POAB.1
POAM.1 POAO.1
POAP.1
CCM-PARENT-NAME
Element: Member Name
Alpha 50 (Lower Case)
This is an override member name for Data Mart dimensions with no association to a Budget dimension.
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 AMAS.1
AMBK.1 AMCV.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
HCAG.1 HCCP.1
HCEM.1 HCHM.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAMB.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1 POAB.1
POAM.1 POAO.1
POAP.1
CCM-ALIAS-NAME
Element: Alias Name
Alpha 80 (Lower Case)
The Alias Name field contains an alias name for the dimension.
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 AMAS.1
AMBK.1 AMCV.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
HCAG.1 HCCP.1
HCEM.1 HCHM.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAMB.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1 POAB.1
POAM.1 POAO.1
POAP.1
CCM-RECORD-OWNER
Element: Record Owner
Alpha 1
The Record Owner field contains the name of the record owner. Valid values are: L = Lawson U = User
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 AMAS.1
AMBK.1 AMCV.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
HCAG.1 HCCP.1
HCEM.1 HCHM.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAMB.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1 POAB.1
POAM.1 POAO.1
POAP.1
CCM-LAST-UPD-DATE
Element: Last Upd Date
Numeric 8 (yyyymmdd)
The Last Update Date field contains the date the member was last updated.
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 AMAS.1
AMBK.1 AMCV.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
HCAG.1 HCCP.1
HCEM.1 HCHM.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAMB.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1 POAB.1
POAM.1 POAO.1
POAP.1
CCM-LAST-UPD-TIME
Element: Last Upd Time
Numeric 6 (hhmmss)
The Last Update Time field contains the time the member was last updated.
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 AMAS.1
AMBK.1 AMCV.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
HCAG.1 HCCP.1
HCEM.1 HCHM.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAMB.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1 POAB.1
POAM.1 POAO.1
POAP.1
CCM-MS-CALCULATION
Element: Ms Calculation
Alpha 1000 (Lower Case)
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 AMAS.1
AMBK.1 AMCV.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 GLBA.1
GLBD.1 GLBP.1
GLBT.1 GLBY.1
HCAG.1 HCCP.1
HCEM.1 HCHM.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
IA150 IAMB.1
IATM.1 IAVO.1
IAYR.1 IFBA.1
IFBC.1 IFBO.1
IFBS.1 POAB.1
POAM.1 POAO.1
POAP.1


IACALCMBR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CCMSET1 DIM-OBJ-ID
MEMBER-NAME
RECORD-OWNER
...
ACBA.1 ACBC.1
ACBP.1 ACBR.1
ACBS.1 ACBU.1
ACBY.1 AMAS.1
AMBK.1 AMCV.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 HCAG.1
HCCP.1 HCEM.1
HCHM.1 HCJC.1
HCMS.1 HCPO.1
HCRV.1 HCSC.1
CCMSET2 DIM-OBJ-ID
RECORD-OWNER
MEMBER-NAME
IA150


File created: Thu Jun 09 02:18:01 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.