ibot configuration for database users - OBIEE 10g

ibot configuration to database users

By using SA System Subject Area

1.      Create the table SA_SYSTEM

CREATE TABLE SA_SYSTEM

(

EMAIL VARCHAR2(100),

EMAIL_PRIORITY VARCHAR2(10) DEFAULT 'HNL',

EMAIL_TYPE VARCHAR2(50) DEFAULT 'html',

CELL_PHONE VARCHAR2(40),

CELL_PHONE_PRIORITY VARCHAR2(20),

PAGER VARCHAR2(20),

PAGER_PRIORITY VARCHAR2(30),

HANDHELD VARCHAR2(20),

HANDHELD_PRIORITY VARCHAR2(30),

TIMEZONE VARCHAR2(100),

GROUP_NAME VARCHAR2(20),

LOGON VARCHAR2(50) NOT NULL,

DISPLAY_NAME VARCHAR2(100),

LOCALE VARCHAR2(20) DEFAULT 'en',

LANGUAGE VARCHAR2(20) DEFAULT 'en'

)

2.      Insert values into the following tables

 EMAIL,

GROUP_NAME,

LOGON,

DISPLAY_NAME

Note: the GROUP_NAME Should be same as that is given in the repository eg ‘Administrators’

Email: abcd@mail.com

LOGON: The user name should be entered here (Same as in the Repository).

DISPLAY NAME: Provide the display name (Not mandatory).

Use of each column

EMAIL                                  – Stores the email addresses of the user.

EMAIL_PRIORITY              – Can take 3 values. ‘H’ for High, ‘N’ for Normal, ‘L’ for low. ‘HNL’ means High, Low and Normal. You can use these in any combination.

EMAIL_TYPE                       – Can take ‘html’ or ‘text’. This primarily tells whether the email client  

                                                    supports html or only text.

CELL_PHONE                     – Cell phone details

CELL_PHONE_PRIORITY   – Same as EMAIL_PRIORITY

PAGER                                  – Pager details

PAGER_PRIORITY             – Same as EMAIL_PRIORITY

HANDHELD                         – Handheld details

HANDHELD_PRIORITY    – Same as EMAIL_PRIORITY

TIMEZONE                           – This can be Null. Basically tells the timezone of the user.

GROUP_NAME                    – The actual GROUPs to which the Logon user belongs.

LOGON                                 – User Login Name

DISPLAY_NAME                 – User Display Name

LOCALE                                 – Default it to ‘en. It specifies the user Locale.

LANGUAGE                        – Default it to ‘en’. It specifies the user Language.

Note : Make LOGON as primary key

3.      Create table USERS

CREATE TABLE USERS

(

    PASSWORD VARCHAR2(20 BYTE),

    UGROUP   VARCHAR2(20 BYTE),

    UNAME    VARCHAR2(20 BYTE) NOT NULL ENABLE,

    USERID   VARCHAR2(20 BYTE)

)

 

Note : Make UNAME  as primary key

4.      Create USERS_DETAILS TABLE

CREATE TABLE USERS_DETAILS

(

 USER_DESC VARCHAR2(20 BYTE),

USERID    VARCHAR2(20 BYTE) NOT NULL ENABLE

)

Note: Make USERID as primary key

5.      Fill in the details to USERS AND USERS_DETAILS TABLE

6.      Design the Physical and BMM layer

Import the following tables

SA_SYSTEM

USERS

USERS_DETAILS

Make a new business model  SA_System

Drag SA_SYSTEM, USERS in to this BMM layer (SA_System)

Make a new logical table SA_USERS in this business model (Fact  table)

Add USERS Column from USERS Table and LOGON Column from the SA_SYSTEM Table

(Make sure USERS AND LOGON are keys in the physical layer)

Make the star schema for this BMM Layer

Rename the SA_SYSTEM Columns in the logical layers as below (Exactly):

Cell Phone

Cell Phone Priority

Display Name

Email

Email Priority

Email Type

Group Name

Handheld

Handheld Priority

Language

Locale

Logon

Pager

Pager Priority

Time Zone

                BMM Layer

STAR  SCHEMA

7:Create the following initialization blocks

DISPLAYNAME

8: Once this is done restart the presentation services.

Now login as Administrator and go to Settings -> My Account.

You would notice that the delivery profile would automatically be populated and also the email id would also have been associated to the profile.

  

If you get an error like this. Check your presentation services log for the error or review your repository design. Fix all the warnings.

99:  Navigate to Manage Presentation Catalog Groups and users

Add the users in to the particular group (I’ve used PSA group in this case)

Note: Your Administrator user should be given the needed privileges (Manage Privileges)

  

110.  Navigate to the Delivers >> Recipients

Note: Make sure your scheduler services are running J

Follow the IBOT Configuration steps (Not mentioned here)

Check the job manager for the ibot status.

You are done.!!

Check the ibots now

Thanks,

Sandeep Venu

SHARE SHARE SHARE

About test