29 December 2010

How to create MVG?

How to create MVG?

First create parent BC and required fields, then create child BC and required fields (or) Select existing Parent and child BC's and check the relationship between them. For MVG relation should be 1:M or M:M.

If there isn’t an existing link between them, create a new link. In link object enter Name, Parent Business Component, Child business Component, Inter Table, Inter parent column, Inter Child Column properties.

Then go to parent BC, click Multi Value Link, It identifies the link that provides the field values from the multi-value group business component (child BC). In this enter Name, Destination Business Component, Destination Link and Use Primary Join (It will convert 1: M to 1:1 relationship). Use Primary Join identifies the foreign key field in the originating, or joined, business component. The foreign key field identifies the primary record in the set of records for one multi-value group.

Next select Multi Value Fields object, these fields are in the originating business component that are populated by the multi-value link. In Parent BC’s Multi Value Fields object enter Multi Value Field Name, Multi Value Link and Field properties.

Next which fields you created in MVF, add in Parent BC List Applet's List columns and edit web layout.

Then create a MVG Applet, in this enter Name, Business Component (Child BC) and Type as MVG. In the list columns enter Name, Field and Display Name. In list columns should enter "SSA Primary Field" as a field.

In MVG Applet go to Control object, enter

Name Caption HTML Row Sensitive HTML TypeMethodInvoke

PopupQueryPick-- OK -- Active-- MiniButton -- CloseApplet


Next go to Parent BC's List Column object. In this where you want to see popup applet, in that record enter MVG Applet name and Runtime Properties.

Then go to View object and edit web layout as View Detail (Parent with Pointer) template.

Next Add view name in screen, add screen in application.

Then Compile the Project.

20 December 2010

Certification Questions

1. In order to change the fonts used by your Siebel application, what file(s) should you modify? Select one answer.

A.Siebel.exe file
B.Siebel template files
C.Cascading style sheets
D.SQL scripts to change the data model

2. Which Link property must be populated for a MVG with a M:M relationship, but is not populated for a MVG with a 1:M relationship?

A.Inter Table
B.Destination Field
C.Child Business Component
D.Parent Business Component

3. You have enabled the Workflow Management component group on the server through the Siebel user interface, but you are unable to run workflows using Workflow policies. Which step might have you forgotten to execute? (Choose two.)

A.restarting the Siebel Server service
B.running a Generate Triggers batch job
C.enabling the Generate Triggers component
D.setting the Workflow Policy properties in Tools
E.specifying the triggering event in the detail applet for the workflow step branch following the Start Step

4. Which three are true about a task in Siebel task UI? (Choose three.)

A.It implements process automation.
B.It must be invoked by a run-time event.
C.It consists of a sequenced set of views.
D.It does not support conditional processing.
E.It does not support transactional processing.
F.It is designed for novice users performing complex tasks.

5. Business rules consist, in part, of concepts. Which two are examples of concepts? (Choose two.)

A.Field
B.Entity
C.Value
D.Object

6. Which describes the role of Assignment Objects for Assignment Manager?

A.to identify the people that will be assigned to records
B.to describe when a record should be assigned to candidates
C.to identify the types of data to assign using Assignment Manager
D.to evaluate all people for a matching skill in order to assign records

7. Which statement is true regarding making changes to assignment rules?

A.To make changes you must first deactivate the rule.
B.If you make changes to a released assignment rule, you must release the rule again.
C.Changes to a released assignment rule take affect automatically when the record is saved.
D.Once an assignment rule is released it cannot be changed, it must be revised before it can be edited.

8. Which two statements concerning interface tables are true? (Choose two.)

A.An interface table can populate only one base table.
B.An interface table may populate more than one base table.
C.A base table may be populated by more than one interface table.
D.A base table is always populated by one and only one interface table.

9. When should you use implicit primaries through Enterprise Integration Manager?

A.any time you have more than one child record in the dataset
B.when you need to have multiple primaries associated with a record
C.when the external system defines which child record should be the primary
D.when the external system does not define which child record should be the primary

10. Your Accounts.ifb file appears as follows:
[Siebel Interface Manager]
USER NAME = "SADMIN"
PASSWORD = "SADMIN"
PROCESS = Import Accounts
[Import Accounts]
TYPE = Import
BATCH = 100
TABLE = EIM_ACCOUNT

After running the import, you find that the IF_ROW_STAT for all of your accounts is PARTIALLY IMPORTED, yet you can see the accounts in the Accounts Administration view.
What is the most likely cause of this?

A.Not all of the required flags were set.
B.The EIM job generated an internal error.
C.Some of the required flags were set incorrectly.
D.Not all of the base tables that EIM_ACCOUNT maps to were populated.
E.EIM_ACCOUNT did not contain required information for the S_ACCOUNT base table.

Answers

1. C
2. A
3. AB
4. ACF
5. BC
6. C
7. B
8. BC
9. D
10.D

17 December 2010

Pre Default & Post Default

Post Default Value:

The value used for an empty field when the record is initially written to the database. This value is not used if the field is left empty on subsequent updates to the record. The post-default value for the field is used even when the field is not exposed in the user interface.
This property is not validated for a calculated field.

Pre Default Value:

The value used for an empty field when a new record is created through an Add New Record or Copy Record operation. The value can be changed by the user before the record is written to the database. The pre-default value for the field is used even when the field is not exposed in the user interface.
This is true for Copy Record operation only if the No Copy property is set to TRUE.
This property is not validated for a calculated field.

Long List:

A TRUE or FALSE value that specifies whether the Siebel application should attempt to position the cursor on the current value in a long list of values.
When you specify Long List = TRUE for a picklist list, the Siebel application does not keep focus on the current record.
A value of TRUE means that the picklist returns a large set of values, so to scroll through that list of values and position the cursor on the current value in the field could be very costly from a performance standpoint. For this reason, Long List does not keep focus.
TRUE = Recommendation is to set this attribute to TRUE if pick list is expected to contain more than 500 records.

16 December 2010

Extension Tables

What is Extension table?

Base table has default columns. Preconfigured extension tables are called Static extension tables and includes generic columns ATTRIB_01 ATTRIB_02...., are the customizable columns which you can use for your purpose other than given by Siebel (ATTRIB_) that you can use to store custom attributes. Static extension tables are already part of the data model so using them does not require updating the physical database. Is it possible to add base and extension table for the same BC? You can also create your own extension tables using the New Table Wizard. Extension tables that you create are changes to the logical schema and therefore must be also be applied to the physical database. Creation of base table is not possible.

Difference between MVG and Dynamic Picklist

What is the difference between MVG & Dynamic PickList?

MVG applet displays the related child records for the parent record. MVG uses link object.

Dynamic picklist displays all the child records for the parent record. It uses join object.

11 December 2010

How to create Drilldown in Form applet?

The situation like drilldown on form applet happens rare cases. Always we'll do in list applet. But we can't say that drilldown can't be done in form applet. As I've tried and it's working perfect.
If you've any doubt let me know & try this...

1) Create a control within the Account Entry Applet Or any Applet you want to try for drill down -
Create the following properties:
HTML Type = Link
Field = Name
Method Invoke = Drilldown

1) In the Account Entry Applet create new Drilldown object with the following properties:
Name ? GotoActivity
Hyper Link Field ? Name
View - Account Detail - Activities View
3) Add the control to the applet.

Flow of Siebel application

The data it will get to the application or UI with the help of layers.
The layers are given below,
1. Application layer
2. Business layer
3. Data layer.
The working function of Siebel is it will fetch the data from Data layer then it will give the fetched data to Application layer through Business layer.
(When we enter URL in web client and request send to web server, in the web server the virtual directory receives the request and checks against each installed application and if it finds the application [URL], then the request forward to SWSE (Siebel web server extension). SWSE creates and maintains TCP/IP connections with Siebel server. It obtains the connectivity parameters from eapps.cfg file. Then the object manager takes the request and gives it to the Siebel server, the Siebel server interns sends the request to data manager and data manager send response to Siebel server. The Siebel server interns response back to object manager. The object manager pushes the data on to the web client.)