Tag Archives: roles

Program listing the workbooks and queries in a BEx Role

SAP BW, ,

To build a list of BEx Workbooks and BEx Queries in a role use table AGR_HIER

keys = AGR_NAME + OBJECT_ID

  • AGR_NAME = role
  • OBJECT_ID  = ID fo the object in the role (1 is the root folder)
  • PARENT_ID = ID of the parent folder (1 for objects that are in the root folder)
  • FOLDER = X if it is a folder
  • TEXT = Either Role menu descripiption or report description
  • REPORT = RRMX for WBK / SAP_BW_QUERY for query
  • SAP_GUID = WBK ID or Query TECH NAME

The following program lists the Role / Workbook ID / Workbook name and all the queries that are in the workbook. Additionally it will list any replacement path variable that uses the result of another query as input.

Download – ZBW_WB_PROPERTIES – 17.4 KB – 541   downloads