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    HCOP.1    HCOP.2    GLOP.1    IFEO.1
POA3.1    WODL.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    HCAC.1    HCAG.1    HCCL.1
HCCP.1    HCEC.1    HCEM.1    HCEO.1    HCEX.1    HCGL.1
HCGN.1    HCJC.1    HCLO.1    HCMS.1    HCMS.2    HCPL.1
HCPO.1    HCRV.1    HCSC.1    HCSH.1    HCST.1    HCSU.1
HCTM.1    HCUF.1    HCUL.1    HCUN.1    HCYR.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
POAV.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
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.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
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.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
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.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
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.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
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.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
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.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
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.1  WOME.1
                                                                 WOOR.1  WOPR.1
                                                                 WOSC.1

RID-LAST-UPD-DATE      Numeric 8  (yyyymmdd)                     ACBA.1  ACBC.1
Element: Date                                                    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
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.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
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.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
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.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
                                                                 HCAC.1  HCAG.1
                                                                 HCCL.1  HCCP.1
                                                                 HCEC.1  HCEM.1
                                                                 HCEO.1  HCEX.1
                                                                 HCGL.1  HCGN.1
                                                                 HCJC.1  HCLO.1
                                                                 HCMS.1  HCMS.2
                                                                 HCPL.1  HCPO.1
                                                                 HCRV.1  HCSC.1
                                                                 HCSH.1  HCST.1
                                                                 HCSU.1  HCTM.1
                                                                 HCUF.1  HCUL.1
                                                                 HCUN.1  HCYR.1
                                                                 IFBA.1  IFBC.1
                                                                 IFBO.1  IFBS.1
                                                                 POAB.1  POAM.1
                                                                 POAO.1  POAP.1
                                                                 POAV.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  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  HCAC.1
                                                                 HCAG.1  HCCL.1
                                                                 HCCP.1  HCEC.1
                                                                 HCEM.1  HCEO.1
                                                                 HCEX.1  HCGL.1
                                                                 HCGN.1  HCJC.1
                                                                 HCLO.1  HCMS.1
                                                                 HCMS.2  HCPL.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  HCAC.1
                                                                 HCAG.1  HCCL.1
                                                                 HCCP.1  HCEC.1
                                                                 HCEM.1  HCEO.1
                                                                 HCEX.1  HCGL.1
                                                                 HCGN.1  HCJC.1
                                                                 HCLO.1  HCMS.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  HCAC.1
                                                                 HCAG.1  HCCL.1
                                                                 HCCP.1  HCEC.1
                                                                 HCEM.1  HCEO.1
                                                                 HCEX.1  HCGL.1
                                                                 HCGN.1  HCJC.1
                                                                 HCLO.1  HCMS.1
                                                                 HCMS.2  HCPL.1
                                                                 ...

RIDSET4   DIM-OBJ-ID    KeyChange
          ROLAP-NAME
          GENERATION
          META-ID

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

RIDSET6   DIM-OBJ-ID    KeyChange, Subset                        ACBA.1  ACBC.1
          LAST-UPD-DATE Where RECORD-OWNER = "L"                 ACBP.1  ACBR.1
          LAST-UPD-TIME                                          ACBS.1  ACBU.1
          META-ID                                                ACBY.1  AMAS.1
                                                                 AMBK.1  AMCV.1
                                                                 AMLF.1  AMMD.1
                                                                 AMME.1  AMPD.1
                                                                 AMYR.1  HCAC.1
                                                                 HCAG.1  HCCL.1
                                                                 HCCP.1  HCEC.1
                                                                 HCEM.1  HCEO.1
                                                                 HCEX.1  HCGL.1
                                                                 HCGN.1  HCJC.1
                                                                 HCLO.1  HCMS.1
                                                                 HCMS.2  HCPL.1
                                                                 ...