User manual BUSINESS OBJECTS REPOSITORY 6.5 REFERENCE GUIDE

[. . . ] The Business Objects Repository Reference Guide Version 6. 5 All operating systems 2 The Business Objects Repository Reference Guide Copyright Trademarks Copyright © 2004 Business Objects. Business Objects, the Business Objects logo, Crystal Reports, and Crystal Enterprise are trademarks or registered trademarks of Business Objects SA or its affiliated companies in the United States and other countries. All other names mentioned herein may be trademarks of their respective owners. Contains ICU libraries (c) 1995-2003 International Business Machines Corporation and others. [. . . ] Values are: 2 = Universe 3 = Document 4 = Stored Procedure 5 = Repository Domain 6 = Application 7 = Security command The Security Domain The Business Objects Repository Reference Guide 61 Column name M_RES_N_STATUS Value Non-null Type: int10 This is the resource status. Values are: 0 = Disabled (for resources other than security commands) 1 = Enabled (for all resources) The following values correspond to security commands, that is, when M_RES_N_RESTYPE=7: 2 = Disabled 3 = Hidden 5 = Inherited M_RES_N_INFO Non-null Type: int10 Not used M_RES_N_LAD Non-null Type: int10 This is the Last Action Date (see page 10). M_RES_N_LAT Non-null Type: int10 This is the Last Action Type (see page 10). Notes: OBJ_M_RESLINK 62 The Business Objects Repository Reference Guide OBJ_M_TIMESTAMP This table defines time constraints for user login or for Broadcast Agent actions. Column name M_TMS_N_ID Value Non-null Type: int10 This is the timestamp identifier. It is generated by OBJ_M_MAGICID (see page 51). M_TMS_N_ENTITYTYPE Non-null Type: int10 This is the type of entity the timestamp controls. Values are: 0 = undefined 1 = a user or group instance 2 = a Broadcast Agent M_TMS_N_ENTITYID Non-null Type: int10 This identifies the actor-resource link. M_ACTL_N_ID field. M_TMS_N_BEGINTIME Type: int10 This is the login start time, stored in the same format as the Last Action Date (see page 10). It defines the date and time at which login becomes authorized. M_TMS_N_ENDTIME Type: int10 This is the login end time, stored in the same format as the Last Action Date (see page 10). It defines the date and time at which login ceases to be authorized. The Security Domain The Business Objects Repository Reference Guide 63 Column name M_TMS_N_REPVALUE Value Non-null Type: int10 This is the periodicity of repeated actions (for example, when login is allowed every Wednesday, or every first day of the month). M_TMS_N_REPUNIT Non-null Type: int10 This is the periodicity type. Values are: 10 = hour (unused) 20 = day (unused) 30 = week 40 = month 50 = year M_TMS_N_DURREPVAL Non-null Type: int10 This the repeat duration value. It defines the duration of a periodic login permission (for example, a yearly period of two weeks has a repeat duration value of two). M_TMS_N_DURREPUNIT Non-null Type: int10 This is the repeat duration type. Values are: 10 = hour (unused) 20 = day (unused) 30 = week 40 = month 50 = year For example, a yearly period of two weeks has a repeat duration type of 30, or week. OBJ_M_TIMESTAMP 64 The Business Objects Repository Reference Guide Column name M_TMS_N_OFFREPVAL Value Non-null Type: int10 This is the repeat offset value. It defines the starting date of a period login permission (for example, if the timestamp allows login for two weeks every year, starting from the 4th month of the year, the repeat offset value is 4). M_TMS_N_OFFREPUNIT Non-null Type: int10 This is the repeat offset type. Values are: 10 = hour (unused) 20 = day (unused) 30 = week 40 = month 50 = year For example, if the timestamp allows login for two weeks every year, starting from the 4th month of the year, the repeat offset type is 40, or month. M_TMS_N_LAD TNon-null Type: int10 This is the Last Action Date (see page 10). M_TMS_N_LAT Non-null Type: int10 This is the Last Action Type (see page 10). The Security Domain The Business Objects Repository Reference Guide 65 Notes: How do timestamps work? When a month is selected in the How combo box: Repvalue January February . . . December 1 1 1 1 Repunit 50 50 50 50 Durrepvall 1 1 1 1 Durrepunit Offrepval 40 40 40 40 0 1 . . . 11 Offrepunit 40 40 40 40 This can be understood as follows: every 1 year (value 50 for REPUNIT = 1 year)) give permission for 1 month (value 40 for DUREPUNIT = 1 month) starting on the nth month (where n = OFFREPVAL+1, and applied to month because value 40 for OFFREPUNIT = month) OR every M_TMS_N_REPVALUE multiplied by the unit defined in M_TMS_REPUNIT, give permission for M_TMS_N_DUREPVAL multiplied by the unit defined by M_TMS_DUREPUNIT, starting on the (M_TMS_N_OFFREPVAL +1)th unit defined by M_TMS_N_OFFREPUNIT OBJ_M_TIMESTAMP 66 The Business Objects Repository Reference Guide When a day of the week is selected in the "How" combo box: Repvalue Monday Tuesday . . . Sunday 1 1 1 1 Repunit 30 30 30 30 Durrepvall 1 1 1 1 Durrepunit Offrepval 20 20 20 20 0 1 . . . 6 Offrepunit 20 20 20 20 This can be understood as: every 1 week (value 30 for REPUNIT = 1 week) give permission for 1 day (value 20 for DUREPUNIT = 1 day) starting the nth day (where n = OFFREPVAL+1, and applied to day because value 20 for OFFREPUNIT = 1 day) OR every M_TMS_N_REPVALUE multiplied by the unit defined in M_TMS_REPUNIT, give permission for M_TMS_N_DUREPVAL multiplied by the unit defined by M_TMS_DUREPUNIT starting on the (M_TMS_N_OFFREPVAL +1)th unit defined by M_TMS_N_OFFREPUNIT The Security Domain The Business Objects Repository Reference Guide 67 When `Last day of the month' or 'First day of the month' is selected in the `How' combo box: Repvalue First day of the month Last day of the month 1 1 Repunit 40 40 Durrepvall 1 1 Durrepunit Offrepval 20 20 0 -1 Offrepunit 20 20 This can be understood as: every 1 month (value 40 for REPUNIT = 1 month) give permission for 1 day (value 20 for DUREPUNIT = 1 day) starting the nth day (where n = OFFREPVAL+1, and applied to day because value 20 for OFFREPUNIT = 20) OR every M_TMS_N_REPVALUE multiplied by the unit defined by M_TMS_REPUNIT give permission for M_TMS_N_DUREPVAL multiplied by the unit defined by M_TMS_DUREPUNIT starting the (M_TMS_N_OFFREPVAL+1)th unit defined by M_TMS_N_OFFRELUNIT OBJ_M_TIMESTAMP 68 The Business Objects Repository Reference Guide OBJ_M_UNIVCST In Supervisor, the default parameters of a universe can be modified for a user or group. This table stores information on universe overloads concerning the connection, SQL and controls. The table is empty until overloads have been applied to a user or group for a universe. Other universe overload information is stored in OBJ_M_UNIVDBCST. Column name M_UNIC_N_UNILINKID Value Non-null Type: int10 This is the universe instance identifier. M_RES_N_ID The overload is applied to a universe for a particular actor. [. . . ] It is a foreign key to UNV_JOIN_OBJECT. OBJECT_ID. UNIVERSE_ID Non-null Type: int10 This is the universe identifier. It is a foreign key to UNV_TABLE. UNIVERSE_ID and UNV_JOIN_OBJECT. UNIVERSE_ID. Notes: UNV_TAB_OBJ 124 The Business Objects Repository Reference Guide UNV_TAB_PROP This table stores the list of "aggregate-incompatible" associations between tables and condition objects (used for aggregate navigation). Column name TABLE_ID Value Non-null Type: int10 This is the table identifier. It is a foreign key to UNV_TABLE. TABLE_ID. PROPERTY_ID Non-null Type: int10 This is the condition object identifier. It is a foreign key to UNV_PROPERTY. PROPERTY_ID. UNIVERSE_ID Non-null Type: int10 This is the universe identifier. [. . . ]