In Business atmosphere Siebel Analytics is "Oxygen..."
Connection pool:-
Connection pool is a physical layer object that contains the database connectivity details (parameters). Siebel Analytical Server uses the details in the connection pool to establish connection to the physical data source.We need minimum one connection pool and No maximum limits. Depends on the requirement CP(s) be created.Example: When Usage Tracking (or Write Back Feature) is enabled and configured to use the DB, then it is recommended to use dedicated CP.
Multi-user Checkout process:-
a) The master repository should be made available in the shared or network folder.
b) Then the shared or network folder where the master repository is available should be specified in the ‘Multi user development directory’ (AdminTool->Tools->Options->More tab).
c) Whenever changes need to be made, activate use File->Multi user->Checkout menu. It lists the projects available in the master repository. Select desired Project. Then save the repository with unique name. It automatically makes another repository with original.rpd, as suffix and this repository will be used at the time of merge.
d) After making changes in the repository, activate File->Multi User Checkout -> Merge Local Changes menu. This makes a lock on the master repository in the shared folder, a log entry is created and the master repository is copied into the local system’s Repository folder.
e) After the merge is completed, then invoke File-> Multi User Checkout -> Publish to Network menu. This copies back the master repository into shared folder, releases the lock on it and makes an entry in the log marking the completion of changes.
Security methods:-
There are two types of securities are there they are,
a) Data Level security and
b) Object Level security
Data level security:-
Data Level security is restricting data being retrieved by or listed to the user. This is implemented using an expression defined in the ‘Filter’ tab of User/Groups permission dialog or in the Where condition in the content tab.Example: Sales Rep can see only what he/she sold. Sales Regional Mgr can see only see sales made by reps reported to him/her.Country Mgr can see all the sales made by people reporting to him/her.
Object level security:-
Object level security is granting or restricting access to a repository objects, Web Objects (Presentation Catalog/Tables, Connection Pools shared Folder Shared Dashboards, etc.) to the user/groups.
Prompt:-
There are four types of prompts are there, They are
a) Dashboard Prompt (Global Filter)
b) Page Prompt
c) Column Filter Prompt and
d) Image Prompt.
Dashboard Prompt (Global Filter)
Global filter is used in the Dashboard to prompt the user to select report criteria on the fly. It affects all the requests in the dashboard that are having same column or set of columns with ‘Is Prompted’ assigned as filter.
Page Prompt:-
Page Prompt is used in the dashboard to enable the user to select criteria for requests listed in the dashboard page that is being used currently by the user. Scope of Page Prompt is limited to the dashboard page it is associated with.
Column Filter Prompt:-
Column Filter prompt is associated with a request. When this request is assigned to a dashboard, Siebel analytics will prompt the user to select the criteria for that column, and then generates the request using the criteria selected.
Image Prompt:-
Image prompt and Column Filter prompt are functionally same, instead of showing values, the image prompt displays an image and allows the user to select the region (co-ordinate) in the image and takes value associated for that region and generates the request. When image prompt is created column values are assigned to particular co-ordinates of the image.
Connection pool:-
Connection pool is a physical layer object that contains the database connectivity details (parameters). Siebel Analytical Server uses the details in the connection pool to establish connection to the physical data source.We need minimum one connection pool and No maximum limits. Depends on the requirement CP(s) be created.Example: When Usage Tracking (or Write Back Feature) is enabled and configured to use the DB, then it is recommended to use dedicated CP.
Multi-user Checkout process:-
a) The master repository should be made available in the shared or network folder.
b) Then the shared or network folder where the master repository is available should be specified in the ‘Multi user development directory’ (AdminTool->Tools->Options->More tab).
c) Whenever changes need to be made, activate use File->Multi user->Checkout menu. It lists the projects available in the master repository. Select desired Project. Then save the repository with unique name. It automatically makes another repository with original.rpd, as suffix and this repository will be used at the time of merge.
d) After making changes in the repository, activate File->Multi User Checkout -> Merge Local Changes menu. This makes a lock on the master repository in the shared folder, a log entry is created and the master repository is copied into the local system’s Repository folder.
e) After the merge is completed, then invoke File-> Multi User Checkout -> Publish to Network menu. This copies back the master repository into shared folder, releases the lock on it and makes an entry in the log marking the completion of changes.
Security methods:-
There are two types of securities are there they are,
a) Data Level security and
b) Object Level security
Data level security:-
Data Level security is restricting data being retrieved by or listed to the user. This is implemented using an expression defined in the ‘Filter’ tab of User/Groups permission dialog or in the Where condition in the content tab.Example: Sales Rep can see only what he/she sold. Sales Regional Mgr can see only see sales made by reps reported to him/her.Country Mgr can see all the sales made by people reporting to him/her.
Object level security:-
Object level security is granting or restricting access to a repository objects, Web Objects (Presentation Catalog/Tables, Connection Pools shared Folder Shared Dashboards, etc.) to the user/groups.
Prompt:-
There are four types of prompts are there, They are
a) Dashboard Prompt (Global Filter)
b) Page Prompt
c) Column Filter Prompt and
d) Image Prompt.
Dashboard Prompt (Global Filter)
Global filter is used in the Dashboard to prompt the user to select report criteria on the fly. It affects all the requests in the dashboard that are having same column or set of columns with ‘Is Prompted’ assigned as filter.
Page Prompt:-
Page Prompt is used in the dashboard to enable the user to select criteria for requests listed in the dashboard page that is being used currently by the user. Scope of Page Prompt is limited to the dashboard page it is associated with.
Column Filter Prompt:-
Column Filter prompt is associated with a request. When this request is assigned to a dashboard, Siebel analytics will prompt the user to select the criteria for that column, and then generates the request using the criteria selected.
Image Prompt:-
Image prompt and Column Filter prompt are functionally same, instead of showing values, the image prompt displays an image and allows the user to select the region (co-ordinate) in the image and takes value associated for that region and generates the request. When image prompt is created column values are assigned to particular co-ordinates of the image.
