Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ROLAPIDS


                             ROLAPIDS FILE

REFERENCED BY

ACDL.1    AMDL.1    HCDL.1    HCHP.1    GLOP.1    POA3.1
SALD.1    WODL.1    IFEO.1    IASD.1

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    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    SACU.1    SALO.1    SAMM.1
SAOR.1    SASC.1    SATE.1    WOME.1    WOOR.1    WOPR.1
WOSC.1    IAAP.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RID-DIM-OBJ-ID         Numeric 12                                ACBA.1  ACBC.1
Element: Dim Obj Id    The Dimension Object Identifier field     ACBP.1  ACBR.1
                       contains a unique numeric identifier      ACBS.1  ACBU.1
                       assigned to the dimension, which          ACBY.1  AMAS.1
                       associates this record to the member      AMBK.1  AMCV.1
                       records.                                  AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.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  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

RID-META-ID            Numeric 9                                 ACBA.1  ACBC.1
Element: Meta Id                                                 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  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  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

RID-MEMBER-NAME        Alpha 50  (Lower Case)                    ACBA.1  ACBC.1
Element: Member Name   This is an override member name for       ACBP.1  ACBR.1
                       Data Mart dimensions with no association  ACBS.1  ACBU.1
                       to a Budget dimension.                    ACBY.1  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.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  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

RID-SHARED-OCCURS      Numeric 3                                 ACBA.1  ACBC.1
Element: Shared Occurs                                           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  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  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

RID-GENERATION         Numeric 3                                 ACBA.1  ACBC.1
Element: Generation    Optional. The Generation Reference        ACBP.1  ACBR.1
                       field contains the Essbase generation     ACBS.1  ACBU.1
                       reference number for the member. This     ACBY.1  AMAS.1
                       number is 2 or higher.                    AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.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  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

RID-ROLAP-NAME         Alpha 50  (Lower Case)                    ACBA.1  ACBC.1
Element: Rolap Name                                              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  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  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

RID-ID-STRING          Alpha 50                                  ACBA.1  ACBC.1
Element: Id String                                               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  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  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

RID-LAST-UPD-DATE      Numeric 8  (yyyymmdd)                     ACBA.1  ACBC.1
Element: Last Update DaThe Last Update Date field contains the   ACBP.1  ACBR.1
                       date the member was last updated.         ACBS.1  ACBU.1
                                                                 ACBY.1  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.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  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

RID-LAST-UPD-TIME      Numeric 6  (hhmmss)                       ACBA.1  ACBC.1
Element: Last Upd Time The Last Update Time field contains the   ACBP.1  ACBR.1
                       time the member was last updated.         ACBS.1  ACBU.1
                                                                 ACBY.1  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.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  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

RID-PARAM-STRING       Alpha 300  (Lower Case)
Element: Param String

RID-RECORD-OWNER       Alpha 1                                   ACBA.1  ACBC.1
Element: Record Owner  The Record Owner field contains the       ACBP.1  ACBR.1
                       name of the record owner.                 ACBS.1  ACBU.1
                                                                 ACBY.1  AMAS.1
                       Valid values are:                         AMBK.1  AMCV.1
                       L = Lawson                                AMLF.1  AMMD.1
                       U = User                                  AMME.1  AMPD.1
                                                                 AMYR.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  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

RID-UNARY-OPERATOR     Alpha 1                                   ACBA.1  ACBC.1
Element: Unary OperatorThe Unary Operator field contains the     ACBP.1  ACBR.1
                       unary operator for the member. This       ACBS.1  ACBU.1
                       field is not used in release 7.0.7 of     ACBY.1  AMAS.1
                       the Analytic Architect system.            AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.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  SACU.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

                         ROLAPIDS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RIDSET1   DIM-OBJ-ID    KeyChange                                ACBA.1  ACBC.1
          META-ID                                                ACBP.1  ACBR.1
                                                                 ACBS.1  ACBU.1
                                                                 ACBY.1  ACDL.1
                                                                 AMAS.1  AMBK.1
                                                                 AMCV.1  AMDL.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.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
                                                                 ...

RIDSET2   DIM-OBJ-ID    KeyChange                                ACBA.1  ACBC.1
          MEMBER-NAME                                            ACBP.1  ACBR.1
          SHARED-OCCURS                                          ACBS.1  ACBU.1
                                                                 ACBY.1  ACDL.1
                                                                 AMAS.1  AMBK.1
                                                                 AMCV.1  AMDL.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.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
                                                                 ...

RIDSET3   DIM-OBJ-ID    KeyChange                                ACBA.1  ACBC.1
          ID-STRING                                              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  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
                                                                 ...

RIDSET4   DIM-OBJ-ID    KeyChange                                ACBA.1  ACBC.1
          ROLAP-NAME                                             ACBP.1  ACBR.1
          GENERATION                                             ACBS.1  ACBU.1
          META-ID                                                ACBY.1  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.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
                                                                 ...

RIDSET5   DIM-OBJ-ID    KeyChange
          UNARY-OPERATOR
          META-ID

RIDSET6   DIM-OBJ-ID    KeyChange, Subset
          LAST-UPD-DATE Where RECORD-OWNER = "L"
          LAST-UPD-TIME
          META-ID