IACALCMBR

UPDATED BY
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

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.
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
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.
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
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.
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
CCM-ALIAS-NAME
Element: Alias Name
Alpha 80 (Lower Case)
The Alias Name field contains an alias name for the dimension.
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
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
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
CCM-LAST-UPD-DATE
Element: Last Upd Date
Numeric 8 (yyyymmdd)
The Last Update Date field contains the date the member was last updated.
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
CCM-LAST-UPD-TIME
Element: Last Upd Time
Numeric 6 (hhmmss)
The Last Update Time field contains the time the member was last updated.
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
CCM-MS-CALCULATION
Element: Ms Calculation
Alpha 1000 (Lower Case)
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


IACALCMBR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CCMSET1 DIM-OBJ-ID
MEMBER-NAME
RECORD-OWNER
...
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
CCMSET2 DIM-OBJ-ID
RECORD-OWNER
MEMBER-NAME
IA150


File created: Wed Jun 08 20:49:32 2016

Home
Contact Us



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