Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > The Siebel ePharma 6.3 to 7.5 Analytics Bridge > Installation Process >

Adding 7.5 Siebel Analytics Responsibilities to 6.3 Siebel ePharma Users

---

The Siebel Analytics 7.5 repository has predefined Analytics responsibilities.

To see predefined Analytics responsibilities

Using the Siebel Analytics Server Administration Tool, open the repository.
Select Manage > Security.
From the left pane of Security Manager, select Groups.

NOTE:  These responsibilities are also defined in the Siebel 7.5 operational OLTP. They are used for dashboard and page visibility and for data visibility.

All Pharma Analytics responsibilities have the following characteristics:

In the Security Manager Groups view, their names are preceded by PH.
Data level security for Pharma Analytics responsibilities is based on Siebel Position ID.
Data level security for Pharma Analytics responsibilities is always resolved through the Fact table.
For administrative roles, data visibility is unconstrained.
For other roles, data visibility is controlled by one of two forms of position-based security: Brick or ZIP Code.
The data warehouse stores the relationship position-to-Brick/ZIP Code in the W_ALIGNMT_DH table: align_item_type = Zipcode or Brick.
The relationship user-to-position is stored in the W_PARTY_LOGIN table.

Therefore, users see only the data from the bricks or ZIP Codes that are available to their positions.

This security is enforced for all queries, with the exception of queries that deal exclusively with the following elements:
Time Period
Product
Invitee Status

The Siebel Analytics 7.5 responsibilities shown in the Siebel Analytics Server Administration Tool do not exist in the Siebel ePharma transactional database for version 6.3. You must first create the responsibilities in the Siebel ePharma transactional database, then assign them to Siebel Analytics users, depending on the visibility that you desire each user group to have.

NOTE:  To enable Horizontal (Siebel eBusiness Application) options, add them to the users.

Table 13 lists the Siebel ePharma Analytics responsibilities and their functions.

Table 13.  ePharma Analytics Responsibilities and Functions.

ePharma Analytics 7.5 Responsibility	ePharma Analytics 7.5 Data Visibility Constraint	ePharma Analytics 7.5 Dashboard or Page Access
LS Administrator	Unrestricted access to entire application	Dashboards—All Pages—All Subject Areas—All
PH US Sales Analytics User	Restricts data access to these relationships in the W_ALIGNMT_DH table: Login Position ID Zip to Position ID	Dashboard—Pharma Sales Pages—All except Brick Subject Area—Pharma Sales Effectiveness (Brick) Dashboard—Pharma Sales Objectives Pages—All except Brick Subject Area—Pharma Objective Achievement (non-Brick)
PH EMEA Sales Analytics User	Restricts data access to these relationships in the W_ALIGNMT_DH table: Login Position ID Brick to Position ID	Dashboard—Pharma Sales Pages—All (Brick) Subject Area—Pharma Sales Effectiveness (Brick) Dashboard—Pharma Sales Objectives Pages—All (Brick) Subject Area—Pharma Objective Achievement (Brick)
PH Sales Analytics Administrator	Unrestricted access to Pharma Sales Analytics	Dashboard—Pharma Sales Pages—All Subject Area—Pharma Sales Effectiveness Dashboard—Pharma Sales Objectives Pages—All Subject Area—Pharma Objective Achievement
PH US Marketing Analytics User	Restricts data access to these relationships in the W_ALIGNMT_DH table: Login Position ID ZIP to Position ID	Dashboard—Pharma Call Activity Profit & Loss Page—Call Activity Profit & Loss Subject Area—Pharma Promotional Effectiveness (non-Brick) Dashboard—Pharma Medical Education Page—Event ROI Subject Area—Pharma Medical Education Effectiveness (non-Brick)
PH EMEA Marketing Analytics User	Restricts data access to these relationships in the W_ALIGNMT_DH table: Login Position ID Brick to Position ID	Dashboard—Pharma Call Activity Profit & Loss Page—Call Activity Profit & Loss (Brick) Subject Area—Pharma Promotional Effectiveness (Brick)
PH Marketing Analytics Administrator	Unrestricted data access to Pharma ROI Analytics	Dashboard—Pharma Call Activity Profit & Loss Page—Call Activity Profit & Loss Subject Area—Pharma Promotional Effectiveness Dashboard—Pharma Medical Education Page—Event ROI Subject Area—Pharma Medical Education Effectiveness (non-Brick)
PH Mobile Analytics User	Restricts data access to these relationships in the W_ALIGNMT_DH table: Login Position ID ZIP to Position ID	Dashboard—Pharma Sales Rep Pages—All Subject Areas—Pharma Objective Achievement, Pharma Sales, Pharma Promotional Effectiveness
PH Mobile Analytics Admin	Unrestricted data access to Pharma Sales Rep Analytics	Dashboard—Pharma Sales Rep Pages—All Subject Areas—Pharma Objective Achievement, Pharma Sales, Pharma Promotional Effectiveness
PH Medical Education Analytics User	Restricts data access to these relationships in the W_ALIGNMT_DH table: Login Position ID ZIP to Position ID	Dashboard—Pharma Medical Education Pages—Event Analysis, Speaker Analysis, Budget Analysis Subject Area—Medical Education Effectiveness
PH Medical Education Analytics Admin	Unrestricted data access to Pharma Medical Education Analytics	Dashboard—Pharma Medical Education Pages—Event Analysis, Speaker Analysis, Budget Analysis, Event ROI Subject Area—Medical Education Effectiveness
PH US Call Activity Analytics User	Restricts data access to these relationships in the W_ALIGNMT_DH table: Login Position ID ZIP to Position ID	Dashboard—Pharma Contact Call Effectiveness Pages—Contact Effort vs Potential, Contact Priority & Indication Subject Area—Promotional Effectiveness
PH EMEA Call Activity Analytics User	Restricts data access to these relationships in the W_ALIGNMT_DH table: Login Position ID Brick to Position ID	Dashboard—Pharma Contact Call Effectiveness Pages—Contact Effort vs Potential, Contact Priority & Indication (Brick) Subject Area—Promotional Effectiveness (Brick)
PH EMEA Call Activity Analytics Admin	Unrestricted data access to Call Activity Analytics option	Dashboard—Pharma Contact Call Effectiveness Pages—Contact Effort vs Potential, Contact Priority & Indication, Contact Effort vs Potential (Brick), Contact Priority & Indication (Brick) Subject Areas—Promotional Effectiveness, Promotional Effectiveness (Brick)
PH US Executive Analytics User	Restricts data access to these relationships in the W_ALIGNMT_DH table: Login Position ID ZIP to Position ID	Dashboard—Pharma Sales Executive Page—Pharma Sales Executive Subject Area—All US
PH EMEA Executive Analytics User	Restricts data access to these relationships in the W_ALIGNMT_DH table: Login Position ID Brick to Position ID	Dashboard—Pharma Sales Executive Page—Pharma Sales Executive (Brick) Subject Area—All Brick
PH Executive Analytics Admin	Unrestricted access to all ePharma Analytics options with ZIP territories	Dashboard—Pharma Sales Executive Page—Pharma Sales Executive Subject Area—All US and EMEA

Bookshelf Home | Contents | Index | Search | PDF