ROLAPIDS

REFERENCED BY
IFEO.1


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 AMDL.1 CBOP.1
HCDL.1 HCHP.1 IAAP.1 IASD.1 GLOP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RID-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
RID-META-ID
Element: Meta Id
Numeric 9
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
RID-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
RID-SHARED-OCCURS
Element: Shared Occurs
Numeric 3
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
RID-GENERATION
Element: Generation
Numeric 3
Optional. The Generation Reference field contains the Essbase generation reference number for the member. This number is 2 or higher.
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
RID-ROLAP-NAME
Element: Rolap Name
Alpha 50 (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
RID-ID-STRING
Element: Id String
Alpha 50
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
RID-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
RID-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
RID-PARAM-STRING
Element: Param String
Alpha 300 (Lower Case)
RID-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
RID-UNARY-OPERATOR
Element: Unary Operator
Alpha 1
The Unary Operator field contains the unary operator for the member. This field is not used in release 7.0.7 of the Analytic Architect system.
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


ROLAPIDS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RIDSET1 DIM-OBJ-ID
META-ID
KeyChange
...
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.1
HCAG.1 HCCP.1
HCDL.1 HCEM.1
HCHM.1 HCHP.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
RIDSET2 DIM-OBJ-ID
MEMBER-NAME
SHARED-OCCURS
KeyChange
...
AMAS.1 AMBK.1
AMCV.1 AMDL.1
AMLF.1 AMMD.1
AMME.1 AMPD.1
AMYR.1 CBBB.1
CBBC.1 CBBD.1
CBBO.1 CBBR.1
CBBT.1 CBOP.1
HCAG.1 HCCP.1
HCDL.1 HCEM.1
HCHM.1 HCHP.1
HCJC.1 HCMS.1
HCPO.1 HCRV.1
HCSC.1 HCSU.1
HCYR.1 IA120
RIDSET3 DIM-OBJ-ID
ID-STRING
KeyChange
...
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
IASD.1 IATM.1
RIDSET4 DIM-OBJ-ID
ROLAP-NAME
GENERATION
META-ID
KeyChange
...
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
IASD.1 IATM.1
RIDSET5 DIM-OBJ-ID
UNARY-OPERATOR
META-ID
KeyChange
RIDSET6 DIM-OBJ-ID
LAST-UPD-DATE
LAST-UPD-TIME
META-ID
KeyChange, Subset
WhereRECORD-OWNER ="L"
...
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


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

Home
Contact Us



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