Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – SA System Subject Area – Autoloading Profiles and Bursting

Posted by Venkatakrishnan J on April 25, 2008

Those users who have worked with Siebel Analytics 7.7 or above, they would be aware of a special subject area called SA System subject area that was necessary to set up Delivers. But with the advent of new releases(10.1.3.3 and above), SA System subject area is not mandatory any more. But still SA System Subject area can be very useful in a lot of scenarios. One of the major uses of this special subject area is that, by setting this up one can automatically populate the Delivery Profiles of all the users. If this is not setup, one would have to manually go into My Account section of each and every user and then set it up. For example, a typical use case is, you would be having the list of users and their corresponding email ids in an excel file. You do not want the users to manually go and enter their email ids. In such a case, just setup the SA System subject area, then all the users would automatically get their email ids, phone, pagers etc automatically assigned to their profiles. Today, we shall see how to go about setting this subject area. Lets start with a simple table script that would help us to store all the Users, their corresponding Groups and also their email ids, pager and phones. Remember, SA System subject expects you to specify all the shown columns below.

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'
)

    

Assume that we have 2 users <b>Administrator and Sample</b> in our repository. So, lets enter all their relevant details into the above table.

INSERT INTO SA_SYSTEM(EMAIL, GROUP_NAME, LOGON, DISPLAY_NAME) VALUES (<a href="mailto:'venkatakrishnan.janakiraman@oracle.com','Administrators','Administrator','Administrator'">'venkatakrishnan.janakiraman@oracle.com','Administrators','Administrator','Administrator'</a>);
INSERT INTO SA_SYSTEM(EMAIL, GROUP_NAME, LOGON, DISPLAY_NAME) VALUES (<a href="mailto:'krisvenky83@gmail.com','Administrators','Sample','Sample'">'krisvenky83@gmail.com','Administrators','Sample','Sample'</a>);
COMMIT;

Lets look at what each of the above columns do

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.

Now, import the above created table into the repository and design your BM and Presentation Layers. You should rename the Presentation Layer columns to the one shown below.

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

If you use any other names, SA System subject area would not work.

    

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. Same would be the case for the Sample user.

    

    

Sometimes this can be very useful. But always remember, if any user goes and modifies their delivery profile, that would take precedence over the SA System Subject area.. One other advantage of using this SA system subject area is that you can use this to do email bursting of reports. For example, in most cases, not every user would have the delivery profile created. In such a case, just load up the SA System subject area and then assign the email ids to the users. Just create a simple report on the SA System subject area to have a display on the LOGON names.

    

Use this in the conditional request and pass the LOGON field to the list of recipients.

    

This would automatically do the bursting to all the users. This would be very handy while doing mass email deliveries.

 

Advertisements

13 Responses to “Oracle BI EE 10.1.3.3/2 – SA System Subject Area – Autoloading Profiles and Bursting”

  1. Stijn Gabriels said

    Hi Venkat,

    thanks for this blog item, I was just working on this subject and struggling on how to select the users from the SA Subject area as recipients for the iBot.

    What I understand from this, that in order to select the users you want to target, you should create a request in the SA System subject area instead of selecting the recipients in the select box in Delivers. Is this correct?

    Thanks,
    Stijn

  2. BG said

    Venkat,

    Article is very helpful. Does the users have to exist in the repository for email bursting.

    Ex: user A is in a non analytics user and have to send an email to A and may such other users. Can I use SA System Subject area to send emails to non-analytics users

    Thanks

  3. VG said

    Hi Venkat,

    thanks for this blog.
    but …
    After adding the table sa_system in business model, I have the following message:
    ERRORS:
    [nQSError: 15001] Can not load space navigation for the field OFFICENTRAL.
    [15013] The table logical OFFICENTRAL.SA_SYSTEM, is attached to any other table logic

    In dashboard, SA_SYSTEM is empty.

    I’m worknig with OBIEE 10.1.3.3.x, i’m newbies…

    thank’s.

  4. Olivier L said

    By default it is true that if any user goes and modifies their delivery profile, that would take precedence over the SA System Subject area. However you can control this behavior using the following paramter in instanceconfig.xml
    SystemSubjectArea: Specifies whether to recognize the delivery devices and deliver profiles configured in the SA System subject area (true or false)
    IgnoreWebcatDeliveryProfiles: Specifies whether to ignore user-defined delivery devices and deliver profiles (true or false)
    regards
    Olivier

  5. ashish said

    +++ ThreadID: 1510 : 2008-09-12 12:30:41.163
    [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Path not found (/users/administrator/_ibots/practice)
    Error Codes: U9KP7Q94

    .
    Error Codes: AGEGTYVF

    +++ ThreadID: 1510 : 2008-09-12 12:30:41.225
    iBotID: /users/administrator/_ibots/practice
    …Trying main iBot loop again.

    +++ ThreadID: 1510 : 2008-09-12 12:30:41.256
    … Sleeping for 3 seconds.

    +++ ThreadID: 1510 : 2008-09-12 12:30:44.265
    [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Path not found (/users/administrator/_ibots/practice)
    Error Codes: U9KP7Q94

    .
    Error Codes: AGEGTYVF

    +++ ThreadID: 1510 : 2008-09-12 12:30:44.280
    iBotID: /users/administrator/_ibots/practice
    …Trying main iBot loop again.

    +++ ThreadID: 1510 : 2008-09-12 12:30:44.296
    … Sleeping for 5 seconds.

    +++ ThreadID: 1510 : 2008-09-12 12:30:49.299
    [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Path not found (/users/administrator/_ibots/practice)
    Error Codes: U9KP7Q94

    .
    Error Codes: AGEGTYVF

    +++ ThreadID: 1510 : 2008-09-12 12:30:49.346
    iBotID: /users/administrator/_ibots/practice
    Exceeded number of request retries.

  6. […] view plaincopy to clipboardprint […]

  7. Rajeev said

    Hi you mentioned that “But with the advent of new releases(10.1.3.3 and above), SA System subject area is not mandatory any more.” Then What is the new method to send emails to users? I tried to setup EMAIL session variable but that does not send emails.

    Appreciate if you can tell how to setup email without SA System subject area or point to documentation for that.

    Thanks,

  8. Kurt Wolff said

    Actually, you don’t need the SA System subject area as such to do the bursting Venkat describes in the section where he talks about assigning recipients via the conditional request. As long as a request returns the list of users, it doesn’t matter if the request itself used the SA System subject area (as long as the delivery information for each user is known by the system).

  9. Ashwin said

    Hey

    I am not able to deliver the mail to any recipients in the mailing list except for myself. The mail does not get delivered to any other recipient in the list. Is there any other change to be made to any of the tabs while using this feature?

    Thanks

  10. […] the SA system subject area ……. I have to admit for the first time I followed one post from Venkat. And then I can remember discussing this in Brighton with Benjamin and John. Next in my memory is a […]

  11. Luntu said

    Hi

    I am able to schedule and run one iBot report and it runs successfully, but when I schedule up more that one iBot i am getting this error.

    +++ ThreadID: 1374 : 2009-11-08 20:30:07.966
    [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Assertion failure: at line 192 of ./project/websubsystems/ibotruncr.cpp
    Error Codes: OQ78YWIW
    .
    Error Codes: AGEGTYVF

    +++ ThreadID: 1374 : 2009-11-08 20:30:08.013
    iBotID: /shared/_ibots/Sales_Report
    …Trying iBot RunCR loop again.

    +++ ThreadID: 1374 : 2009-11-08 20:30:08.044
    … Sleeping for 8 seconds.

    Can you please help me on this…

  12. Henrik Nielsen said

    Hi Venkat,

    Thanks for a great blog. I am trying to understand what will happen if the user changes for example the Time Zone, will that be stored in the SA_SYSTEM table or in the Webcat? My impression is that it is stored in the Webcat, as I see no changes in the table.

    Is this something that has to be enabled, or is it just not an existing funcitonality?

    Regards,

    Henrik

  13. Srinu B said

    Hi All,

    PPls help me how to solve this issue in Linux..

    while i saving the ibot.

    +++ ThreadID: 1510 : 2008-09-12 12:30:44.265
    [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Path not found (/users/administrator/_ibots/practice)
    Error Codes: U9KP7Q94

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: