SIEBEL FAQ'S

Siebel Answers

 

Data objects layer

1. What are the various layers of object definition?

2. What are the various types of tables that are present in siebel?

     The various types of tables are

a.       Data tables

b.      Intersection tables

c.       Extension tables

d.      Interface tables

Q. What are the types of extension tables?

            There are 1:1 extension table, 1:M extension table, and intersection tables.

Q. What are the uses of these extension tables?

A 1:1 extension table extends the base table horizontally and has a suffix _X.

In a 1:M extension table, there are multiple extension rows for each base table row. There are standard one to many extention tables for certain major business components including opportunity, contact and account. These are primarily used to create MVG based on user created business components.

An intersection table implements a many to many relationship between two business components.

Q. What is the S_PARTY table?

The S_PARTY table allows you to configure business components related to access control and to import access control data and populate the necessary extension tables with data about persons and organizations. Party refers to all types of siebel persons and business data. A person refers to someone using the application or referred to in the application.

S_PARTY serves as the base table for all party related business components and stores the party name and party type. It has multiple extension tables that store the business data for the party business components.

Person related business components store the majority of their data in S_CONTACT. Multiple business components use these tables.

User responsibility relationship uses the S_PER_RESP intersection table. Any user can be given a responsibility.

Organization related data represents any business enterprise associated with a siebel application. Organization related business components store their primary data in S_ORG_EXT and store additional data in S_BU. Multiple business components use these tables. S_BU table does the following:

• Permits indexing on organization name
• Supports organizational visibility

Single organization visibility is implemented by BU_ID foreign key column in the table for a single organization business component.

Multiple organization visibility is implemented by an intersection table between S_BU and the table for the multiple organization business components. Intersection tables for an organization have a _BU suffix.

 

 

Business objects layer

3. What is a business component?

     One fundamental entity in the enterprise and consists of multiple fields. It maps to one main table in the data objects layer and can include data from related tables. The grouping of data can be achieved by

• Referencing an extension table
• Join of two tables
• Link that joins data in an intersection table

4. What is a business object?

    A business object represents a major functional area, every major entity has a business object e.g. opportunity, account, contact etc.

It is also a collection of related business components. Opportunity business object consists of opportunity related plus related contacts, activities, products etc.

Each business object serves as the master or driving business component. A business object has only one parent; a link would be required for other business components to connect with the parent.

5. What is a join?

        A join creates a relationship between a business component and a table that is not the business components base table.

The join uses a foreign key in the business component to obtain rows on a one to one basis from the joined table even though the two do not have a one to one relationship.

6. What is a join specification?

    A join specification is a child object the join that provides the details about how the join is implemented the business component

7   What is an implied join?

     Underlying the one to one extension table relationship with the base table and business component is a set of hidden relationships called implied or implicit joins.

The implied join makes the extension table rows available on a one to one basis to the business component that uses the extension table. This join always has the name of the extension table.

A join column data cannot be updated while an implied column data can be updated. The following participate in the implementation of an implied join,

• Id field – system field represents ROW_ID column in the base table.
• PAR_ROW_ID column – stands for parent row id. Every extension table has this column and every extension table row has a value there. It is used as a foreign key to the base table that is eventually extended by the extension table

            8. What is a link?

   A link implements a one to many relationships between business components. It makes a master – detail view possible. A pair of links may also be used to implement a many to many relationship.

9. What is a multivalue link?

    This is used to implement a multi value group.

21. What is sort specification?

    The value in the sort specification property, if it is non blank is the name of the field or list of fields that imposes a sort order on the records returned to an applet that is associated with this business component. The field or fields must be child object definitions the business component. If a predefined query exists it can potentially override a sort specification in the business component.

22. Can you implement a sort in a MVF?

Yes. The MVF uses a MVL, which in turn uses a master and detail business component. If the sort specification is implemented in the detail business component sort can be done

23. Can a sort be implemented in a picklist?

Yes. For sorting different from default sorting the sort specification of the business component can be overridden with sort specification on picklist object.

24. What is search specification property?

This field if the value is non-blank in a business component definition restricts the set of records provided to an applet using this business component, because a conditional expression is the value used.

Records, which evaluate to value TRUE, are displayed and when the value is FALSE are not displayed.

25. What is data driven read only behavior?

    Business components and fields can be configured as dynamically accessible, with their read only status turned ‘on’ and ‘off’ depending on the value in a particular field in the current record.

·         BC Read only Field user property when TRUE causes current record to be read only.

·         Field read only field specifies TRUE or FALSE test field and target field in same business component. When value is TRUE, the target field becomes read only

·         Parent read only specifies a TRUE or FALSE test business component or field combination in the parent chain (parent, grandparent and so on) that when TRUE, causes the target business component to become read only

27. What is a calculated field? How is it used?

    This is a field whose values are derived from the values in other fields in the business component or from the master business component in active link in which the current record is in detail but not stored in the database.

Calculated fields have a calculated property of TRUE and a non-blank calculated value property. The calculated value field contains an expression built from field names, standard functions, and string, numerical and logical operators.

27. What is force active property? How is it used?

    The Force active setting of TRUE indicates to the system that it must obtain data for the field every time the business component is accessed, even though the field is not displayed in the current applet. This adds the field in the SQL query each time.

28. How do you implement a join?

    Choose the base business component in OBLE, expand in OE

    Choose Join in OBLE > add new record in OBLE specify the table to be joined,

If necessary, set alias property. Set the outer join flag to TRUE.

    Choose SVF of base business component in OBLE; select the column, which references the table to be joined. This is the foreign key. Give this a name and set type property to DTYPE_ID.

    Choose Join object again, select Join specification under join. > Add new record. Give it a name. Fill source field column with foreign key. This will be retrieved from the SVF.

    Select SVF again > add record, select join field and choose joined table from picklist. Fill in column with columns now being retrieved from joined table. Fill in the name property. Add as many records as necessary.

    Add the joined columns to appropriate applet. For list applet add under list column. Edit web layout of applet and drag and drop added fields for all modes. For form applet drag text controls from toolbar and set property in properties window in all modes

   Save and compile. Test application.

29. How do you implement a link?

    There are two types of links. They are the one to many link, and, the many to many link.

The one to many link is configured as below:

·         Choose link object in OE > Add new record in OBLE.

    Enter values for – Name

                                 Project

                                 Parent business component

                                 Child business component

                                 Source field (default ROW_ID)

                                 Destination field

·         Add SVF in destination B.C to expose foreign key

·         Now add link object to the column ‘link’ in business object component

·         Now create a view to display the applets of both the linked business components

·         Add view to views and responsibilities in application admin

Compile and test the application.

The many to many links make use of an intersection table. The relationship is one to many each way. So the intersection table, the parent inter column, the child inter column properties are used.

·         Choose link object in OE > Add new record in OBLE.

                                                                        Enter values for  - Name

                                                                                                      Project

                                                                                                      Parent business component

                                                                                                      Child business component

                                                                                                      Inter table

                                                                                                      Inter parent column

                                                                                                      Inter child column

·         Add detail business component to business object component.

·         Now add link object to the column ‘link’ in the bus. Obj. component

·         Now create the view, which will display the applets of the linked business components.

·         Now add this view to screen view of parent screen.

·         Add view to views and responsibilities (application admin)

Compile and test the application.

30. How do you use link in Multi value group?

31. How do you use link in M:M relationship?

32. How do you use link when merging records?

33. How do you implement multi value links?

34. How do you implement indirect multi value links?

User interface layer

11. What is a view?

    A view presents one or more applets together at one time in a predefined visual arrangement and logical data relationship. Views are named and a specific view is selected by name. A given view is mapped to a single business object which determines the relationship between the data displayed in two or more applets in the view. Each applet in a view must map to a business component in that business object. The business components that are required to be included in each view are (1) For a view on a business object – all the business components to which, applets in that view are mapped, (2) Any business component whose data is exported in a report from a view based on the business object.

12. What are screens?

   These are a collection of related views. All views in a screen map to the same business object (except administration screens).

13. What are the various steps in configuration?

        The following are the steps in configuration:

• Create Project
• Create business component
• Create business object
• Create Applets, views, and screens
• Associate each applet & view with correct template
• Modify each template as needed to reflect corporate image
• Establish mappings between controls and templates
• Create web application definition
• Compile the repository changes into .srf file.
• Test the application
• Deploy the application

14. What is visibility?

    Visibility refers to the level of access users have to the content of the application

• Each employee has a login name value assigned, which is the same as that person’s database user name.

• Each employee record also has a position field and a responsibility field (each of which can hold multiple values). These two fields plus the user logon establish visibility for that user.

 The set of access rights which allows portions of the application and data to be seen by specific users (employees) is called visibility.

15. What is responsibility?

   A user can have one or more responsibilities assigned. A user’s responsibilities (one or more) identify the views to which the user can navigate in siebel applications.

The user has access to all the views in the union of all the responsibilities assigned e.g. you could assign a sales manager, both the sales manager responsibility and the field sales responsibility.

If a users responsibility does not include a specific view the ability to navigate to that particular view is disabled (using menu option, drilldown etc.).

16. What is position?

    A user can have one or more positions assigned. The position describes the persons job title in the organization. The position is also used to determine if the user has manager supervises persons who have visibility to particular records. In this case the user has manager visibility to these records.

17. What are the mechanisms used for access control?

   Access control is implemented through 3 mechanisms

38. What are the various modes of an applet?

    An applet ca be displayed in 5 modes (1) Base – read only (2) Edit – for updating values (3) New – for creating a new record (4) Query – where query is different from edit (5) Edit list – for editing records.

39. What are the various types of applets?

    The various types of applets are:

1. Form applet
2. List applet
3. Pick applet
4. Multi value group applet
5. Chart applet
6. Association applet
7. Explorer or tree applet
8. File attachment applets

41. What is field display format for? How many display formats are there?

    This specification is for data displayed by the text box control in an applet, and non-data types as well. There are 6 types primarily,

            DTYPE_NUMBER    numeric values, if left blank the regional settings are taken              

DTYPE_CURRENCY           currency, unless explicitly declared regional windows settings are taken. Display of currency values can also be controlled in currency administration view.

DTYPE_DATETIME             One of the key words date, DateTime, DateTimeNoSec, TimeNoSec may be specified

DTYPE_DATE                      Blank picks up regional settings or explicitly using M, D, Y, and / symbols

DTYPE_TIME                       Blank takes regional settings. Explicit declaration H, h, m, s and :               

DTYPE_PHONE                   Blank uses regional setting

42. What is runtime property?

    When a text box has an MVG applet or a picklist property other than blank, a True/False value directs the system to activate or deactivate an icon or dropdown arrow, A False value will deactivate the MVG or picklist. A runtime value of True combined with blank MVG or pickapplet property will direct the system to determine from the data type to display an icon for calculator, calendar or currency popup.

50. How do you configure thread behavior?

    The following properties are set.

• Thread applet property – Specifies which of the applets appearing in the view supplies the data value for the thread field.
• Thread field property – The name of the field whose data value is included in the arrow box, following the thread title. This is a field in the business component, associated with the applet identified in the thread applet property.
• Thread title property – The text used in the thread to identify the view.

51. What is drilldown?

    It allows the user to navigate (drilldown) from a cell in an applet to a particular view Drill down controls consist of colored underlined text like a hyperlink.

52. How many types of drilldown are there? How are they different?

    There are two types of drilldown, the static or standard drilldown, and the dynamic drilldown. In a static drilldown. The user is taken from one view to another view, which is the same every time. A dynamic drilldown enables hyperlink navigation to multiple views from the same hyperlink field. This depends on the value of a field in the applets current record.

55. What is a web template?

    This establishes a relationship between a representation on an swt file in the repository and the actual file stored in the directory. The child object of this is the web template file, which contains the actual file name stored in the directory.

56. What is an applet web template?

    The applet web template establishes an association between a parent applet and a web template. There are 5 modes, and each of these modes are mapped to a template. Applets may have several edit and new applet web templates, but will have at most one base and query applet web template. Applet web template item is the child object and has list items, applet controls and web controls that belong to the applet web templates.

61. What happens if you set the show in list property to false?

The list column is hidden. But it can be seen by selecting the columns displayed from the rt. Click menu. You can then select this column to be displayed.

62. What does the web applet editor do?

    This helps ensure visually accurate and correctly translated configuration, by providing design time preview of the applet in various modes and with various language settings. It allows you to map controls and list columns to web templates. You can also add controls by dragging and dropping them from the toolbar including custom controls such as minibutton and position on row.

63. What is the role of the visibility applet property in a view?

    A null value places the view in a view tab. A non-null view places the view in the show: combobox.

    64. How do you provide user access to a new view?

• You have to log in as administrator.
• Add the new view to the list of views
• Add the view to a responsibility

Depending upon the nature of the view and the users, the application administrator may also need to,

(a)    Add new responsibilities

(b)   Add employees to the new responsibilities.

 67. What happens if you define a screen under the screen menu item object?

    It will appear as hyperlinks in the site map

·         In the object explorer, select web page object

·         Select a custom control from the combobox on the toolbar and drag it to the placeholder.

·         Set the properties (like Caption, InvokeMethod) using the properties window.

• Verify that the method, you want for this toolbar icon to invoke, currently exists. If not add to PreInvokeMethod.
• Navigate to command object in OE. Add a new command object definition in the object list editor. Specify the HTML bitmap to use in the bitmap property, the method to invoke in the method property and other properties.
• Navigate to the toolbar object definition, to which the new toolbar item is to be added.
• In the OE select the toolbar item object type.
• In the OE, add a new toolbar item object definition. Specify the name, the name of the command object definition which supplies the bitmap and method, and the sequence of the toolbar icon related to the other toolbar icons relative to the other toolbar icons appearing in the toolbar items list in the OBLE.

73. What is a pick applet?

    Pick applets allow users to select values from a list, and have the selection entered into controls or list columns. They are invoked by clicking the ‘Select’ button that appears next to a certain field.

Pick applets contain a scrolling list table of available selection in one list column. The pick applet selection can populate more than one field in the original applet.

Pick applets maintain the foreign keys that facilitate join relationships.

74. How is a pick list configured?

75. What are the different types of pick lists?

The different types are the static picklist and the dynamic picklist.

76. What is static pick list, dynamic pick list, and constrained pick list?

A static pick list is a selection choice invoked from a particular text box or list column in an applet.

You can dynamically filter a pick applet to display only records that have field values matching corresponding fields in the originating business component’s records. This is called constraining a picklist. Pick applet constraints are defined using the constraints property in the pick map object type If the constraint property is True then the pickmap behaves as a constraint pick map. If false it behaves as a copy picklist. If the constrained field refers to a joined table in the pick business component, the foreign key field must also be constrained.

77. How are these pick lists configured?

78. What is the difference between a static pick list and a dynamic pick list?

·   They are similar in nature because both of them display a list for the user to choose.

·   They are different because the static picklist does not draw values dynamically from a pick business component.

·   The static picklist does not invoke a dialogbox with multiple list columns and buttons.

·   The static picklist dies not populate multiple columns in the originating applet.

79.What is popup visibility?

79.What is a multivalue group?

80.How do you configure a Multi Value Field to include multiple values?

81.What is an association applet?

    An association applet provides users with the ability to associate a parent record with one or more children, through an intersection table. An association applet is a dialog box. Multi selection is available only in the association applet. Fields in the association applet cannot be updated. Association applets are used only with pairs of business components that have a many to many relationship, which is implemented, by an intersection table and a pair of links. An association applet cannot be constrained through properties like a pick applet. You have to use eScript or VB Script.

82.How many types of templates are there in Siebel?

    There are four types,

1. View template
2. Applet template
3. Web page template
4. Formatting templates

83.What are siebel tags?

    These are special tags that you insert into template files. They specify how objects defined in the repository should be laid out, and formatted in the final HTML page in the user’s web browser.

84.What is high interactivity?

Traditional web applications follow a model whereby almost every user action results in a page refresh. These frequent ‘page refreshes’ slow down users and waste time. The Siebel high interactivity framework reduces the number of refreshes, and is used only in employee applications such as Siebel sales and call center. Applications such as esales and Eservice do use the high interactity framework and are called standard interactivity applications. The interactivity is defined in the application by setting HighIteractivity to true in the [SWE] section of the .cfg file.

Access control

1.      What is Siebel authentication manager?

The authentication manager runs within the siebel object manager. It is responsible for verifying credentials and establishing a connection to the application database.

2.      What are the various ways of authentication in Siebel?

Here are three approaches,

• Database authentication – this relies on the underlying application database for user authentication.
• Security adapter authentication – Siebel supports authentication to Microsoft Active Directory Server, and LDAP compliant directives using a Siebel provided security adapter, or a custom adapter. The adapter authenticates the users against the directory.
• Web Single sign On – This approach uses an external authentication service to authenticate users before they access the Siebel application. The security adapter simply looks up and retrieves a user Siebel id and database account from the directory, based on identity that is accepted from the external authentication service.

3.      How do you implement database authentication?

An administrator has to perform the following tasks,

Create a database account for the user.

Create a record for the user in the Siebel database in which the user id matches the user name for the database account.

4.      How do you change the Siebel administrator password?

When the windows login name is the same as user name in the database.

Change the windows domain login password.

Change the password for the Siebel server system service in the windows control panel.

a.       Start > programs > administrative tools > services.

b.      Select the Siebel server system service – startup.

c.       Change the password.

d.      Click O.K

Change the password in server manager.

a.       Log in to Siebel employee application.

b.      Choose view > site map > server admin > servers

c.       In the Siebel servers list, select the server.

d.      Click the server parameters tab.

e.       In the server parameter list, select password.

f.       In the current value field, type in the new password and save.

Change the password in the database.

Stop and restart Siebel server service.

When the Windows login name is not the same as user name in the database.

Change the Windows domain login password.

Change the password for the Siebel server system service in the windows control panel.

Start and restart Siebel server service.

5.What is basic access control?

Basic access control consists of the following:

• View level access control – Restriction of what views a user can see.
• Record level access control – Restriction of what data records a user can see.

6.      What are the mechanisms for record level access control?

The mechanisms are;

• Personal access control
• Postion based access control
• Organization based access control
• ‘All’ access control.
• Access group access control.

7.      What is personal access control?

If individual data can be associated with a user’s Person record in the database, then you can restrict access to the data, to that person. E.g. My activities, My service requests. Some ‘My’ views apply Position or organization based access control. E.g. ‘My opportunities’ applies position based access control.

8.      What is position based access control?

A position is a job title in a company. A position represents reporting hierarchy. Positions provide an appropriate basis for access control because a position is more stable than the individual’s assignment to that position. Customer data and some types of referential data can be associated with one or more positions.

If individual data can be associated with a position, then you can apply position based access control to the data by one or more of the following means:

• Single position – Associate single position to individual data.
• Sales Team – associate multiple positions to individual data.
• Manager – Grant access concurrently to data associated with subordinate positions in a reporting hierarchy.

All position based access control for an employee or partner user is determined by an active position. One of the user’s position is designated as the primary position. When a user logs in, the primary position is the active position.

9.      Describe single position access control?

You can associate a single position to individual data. A business components’ view modes determine whether single position access control, can be applied in a view that is based on the business component. To have a single position access control available, a business component must have a view mode of owner type ‘Position’, with an entry in the visibility field column.

10.  Describe sales team access control?

You can associate multiple positions, in the form of a team, to individual data e.g. In My opportunities view, an internal employee or partner with a particular active position can see all the opportunities for which that position is included in the opportunities sales team.

A business components’ view modes, determine whether a Sales Team access control can be applied in a view that is based on a business component. The business component must have a view mode of owner type ‘Position’, with entries in the ‘Visibility MV Field’ and ‘Visibility MV Link’ columns.

11.  Describe manager access control?

You can indirectly associate a position with data associated with subordinate positions in a reporting hierarchy.

Manager – subordinate relationships are determined from a position hierarchy. You can specify one present [position for a position, which represents that, the position is a direct report to the parent. The parent of an internal position may be in the same division or in a different division.

In a view using manager access control, the employee or partner has access to the following data.

• If the business component on which the view is based uses a single position access control, the user sees data associated directly with the users’ active position or with subordinate positions.
• If the business component on which the view is based uses sales team access control, the user sees data for which the users active position is the primary position on the team or, a subordinate position is the primary member on the team.

Manager access control is set at view level. It requires that the business component on which the view is based has a view mode with owner type position. (i.e. the visibility applet & visibility applet type ).

12.  Describe organization based access control?

When individual data can be associated with an organization, you can apply organization based access control to the data by one or more of the following.

• Single organization – Single organization with individual data.
• Multiple organizations – Multiple organization with individual data.
• Sub-organizations – Grant access concurrently to the data associated with subordinate organizations in the organization hierarchy.

A user is associated with one organization at any given time, the organization to which the user’s active position belongs.

13.  What is single organization and multiple organization access control?

You can associate one organization or multiple organizations to individual data. The user can see the data associated with the users active organization.

For data that is associated with multiple organizations, one of the organizations is designated as the primary organization. The primary organization is a factor in the sub-organization access control, but not in the single or multiple organization access control.

A business components view modes determine whether single organization or multiple organization access control can be applied in a view that is based on the business component.

To have single organization access control available, a business component must have a view mode of ‘owner’ type organization with an entry in the ‘visibility field’ column (not in visibility MV field).

To have multiple organization access control available, a business component should have view mode of ‘owner’ type organization with entries in ,visibility MV field and ‘visibility MV link’ columns.

Sub-organization access control based organizations are analogous to Manager access control, based on ‘Positions’.

For any organization in the organization hierarchy, you can grant access to data, associated with subordinate organizations. The access control is designed to provide roll-up of views of data.

Subordinate relationships are determined from the organizations hierarchy, as an administrator. In a view using sub-organization access control, the user has access to the following data,

If the business component on which the view is based uses single organization access control, the user sees data associated directly with the users active organization, or with a descendant organization.

If the business component, on which the view is based, uses multiple organization access control, then the user sees data for which the users active organization or a descendant organization is the primary organization.

14.  What is ‘All’ access control?

‘All’ access control provides access to all records that have a valid owner, as defined in any of the business components view modes. ‘All’ visibility essentially provides a view of data access all organizations. There are no business component view modes specific to ‘All’ access control. ‘All’ access control is set at the view level

.What is access group access control?

This is meant to control access by groups of diverse party types to categorized master data. An access group is a collection of  any combination of positions, organizations, divisions, accounts, households and user lists. Its members cannot be individual people.

A user is associated with an access group if during the current session, the user is associated with a position, organization, division, account, households and user list that is a member of the access group.

You can create hierarchies of access groups. An access group can belong to only one access group hierarchy. You can grant access groups, access to catalogs and categories of master data.

You can only control access to catalogs and categories of master data. You cannot control access to individual master data, using access group access control.

When access groups are associated with a catalog or with categories, in a catalog, you can apply access group access control. Control can be done in the following ways,

• Group – While in a given category, the user sees either a list of categories sub-categories, to which the user has access, or, all the data records in the current category, depending on the applet being used.
• Catalog – The user sees a flat list, of all the data, in categories, across all catalogs to which the user has access.

15.  What components determine, the data within a view to which a user has access?

The following components determine what data a user sees, within a view,

• Business component view mode – A view can have several applets – lists, forms, or trees. Each applet is based on a business component. The business components view mode determines the allowable properties, on which access control can be based for the business component.
• Applet visibility properties – A view can specify one of it’s applets as the visibility applet. The visibility applet connects the business component to the view. The visibility applet specifies which business component to use, and the display names for the business components fields.

• View visibility properties – A view’s visibility properties determines the access control mechanism that is applied to the business component, on which the view is based. The business component may have personal or position based access control available. The view specifies which of these to use.

The application and a users’ responsibility, restrict the views presented to the user. Within a view, view visibility properties determine the applet that drives the visibility in the view, and, specifies the access control mechanism to apply to the business component.

The views visibility applet specifies the business component being used in the view. The business component specifies how a user can be associated with data to provide access.

16.  What is local access?

Each view has a ‘Local access’ flag. If set to True, all users with the view, in their responsibility, can access the view from, either the local or server database. When set to false, users can access the view when they are connected to the server database.

The ‘Local access’ column is primarily a mechanism for controlling, which views mobile users can work in offline mode.

17.  What determines allowable visibility for a business component?

The following fields in the business component view modes applet in Siebel tools determine allowable visibility for a business component.

Owner type – This is the party type. The allowable owner types are,

• Person – Access control can be based on the user’s ‘person’ record.
• Position – Access control can be based on the position of the user.
• Organization – Access control can be based on the organization of the user, determined by which organization, the underlying current position belongs to.

• Group – Access control can be based on membership in access groups, that have access to particular catalogs, and categories.
• Catalog category – This is not a party type. Access can be restricted to all of the data, in all of the categories across catalogs, to which the user has access. The user sees a flat list of data.

Private field – This flag determines whether the record is private or public. If it is not private, then the record is shown, independent of its view mode. If it is set as private, then the access control is applied as specified by the business components visibility field or visibility MV field. This is applicable to all view modes.

Visibility field – A value in one of either visibility field or visibility MV field is required. The value in this field is compared with the corresponding value for the user, as specified in the owner type, to determine whether the user is associated with a record. If they are associated the user gets the record.

• A value in this field indicates, that there is only one property associated with the business component, when using this view mode.

Visibility MV field – This field has the same purpose as visibility field, except a value in this field indicates that there can be more than one party associated with this business component, when using this view mode.

Visibility MV link – An entry in this field is required if there is a value in the visibility MV field.

• This field specifies which of the business components multi value links should be used, to determine the value in the MV field for this record. Links establish a parent/child relationship between business components, often by specifying an intersection table (in the case of M:M relationship). The MV link destination field property indicates which link ultimately defines this relationship.

Name – The name typically suggests the view mode. However, view mode records for a business component must have unique names.

• Personal           – owner type person
• Sales rep          – owner type position
• Organization   – owner type organization
• Group              – owner type group
• Catalog            – owner type catalog

18.  Which properties drive the access control for a view?

The following fields in the views list applet help determine data visibility.

Title – The title should suggest the level of access control of the views data.

Visibility applet – Typically this is the master in the master detail applet. This applet defines the business component on which the view is based, and how the fields of the business component are displayed.

A view has an entry in this field if the view is not derived from another view.

Multiple views can have the same visibility applet.

Visibility applet type – This field determines the access control mechanism that is applied to that view. It specifies which of the business component’s view modes are applied. The following choices are available in the picklist.

            All – The user can access all records, except those with a missing or invalid owner.

Personal – Applies ‘Personal’ access control. User can access records with which the users ‘Person’ record is associated, as determined by the business components’ visibility field. To use this visibility applet type, the business component must have a view mode with Owner type ‘Person’.

Sales rep – This view applies ‘Single position’ or ‘sales team’ access control. The user can access records owned by the user’s position or whose sales team contains the user’s position, as determined by the business components visibility field or visibility MV field. To use this visibility applet type, the business component must have a view mode with owner type ‘Position’.

Manager – This view applies Manager access control. The user can access records associated with the user’s own position, and, positions that report directly to the user’s position, and, positions subordinate to those direct reports.

• If the business component on which the view is based uses ‘Single position’ access control, the user sees data associated with the user’s active position, or, with subordinate positions.

• If the business component on which the view is based uses ‘Sale team’ access control then, the user sees data for which the user’s active position is the primary position on the team, or a subordinate position is the primary member on the team.

To use this visibility applet type, the business component must have a view mode with owner type ‘Position’.

      Organization – Applies ‘Single’ or ‘Multiple’ organization access control, as determined by the visibility field or visibility MV field in the business component. To use this visibility applet type, the business component must have a view mode with owner type ‘Organization’.

      Sub_organization – Applies sub-organization access control.

·         For single organization – the user sees data associated directly with the users active organization, or with a descendant organization.

·         For multiple organization – the user sees data for which the user’s active organization or descendant organization is the primary organization.

To use this visibility applet type, the business component must have a view mode with owner type ‘Organization’

      Group – The view applies ‘Group’ access control, if the user is associated with an ‘Access group’. The user can access categories of master data, that are associated with any of the access groups with which the user is associated.

      Catalog – This view applies Catalog access control, which is one mechanism of the access group access control. If the user is associated with an access group, the user sees a flat list of all the data in all of the categories across catalogs. To use this visibility applet type, the business component must have a view mode with an owner type of ‘Catalog’ category.

      Admin mode – Requires a True or False value. Operates as admin mode in True mode. In this mode, the No Insert, No Delete, No Merge. And No Update restrictions at applet level are ignored. Admin mode does not override a Read-only restriction on a field, in the business component.

19.  How do you override the visibility property set in the ‘business component popup visibility type’ property?

The developer can override the visibility property set in the business component popup visibility type by,

·         Setting the visibility of picklist object.

·         Use the visibility ‘Auto all’ property.

·         Use the special Frame class and user property.