Friday, 5 September 2014

Application Roles in OBIEE


Default OBIEE Application Roles
Application Role
LDAP Group
Description
BIConsumer
BIConsumers
Base-level role that grants the user access to OBIEE analyses, dashboards and agents.
BIAuthor
BIAuthors
All BIConsumer rights, grants and permissions + allows users to create new analyses, dashboards and other BI objects
BIAdministrator
BIAdministrators
All BIAuthor and BIConsumer rights, grants and permissions + allows the user to administer all parts of the system.

By default, OBIEE 11g have three application roles:
  • BIConsumer : The base-level role that grants the user access to existing analyses, dashboards and agents, allows them to run or schedule existing BI Publisher reports, but not create any new ones. That means user can view the existing reports and dashboards.
  • BIAuthor : A role that allows users to create new analyses, dashboards and other BI objects. This role will recursively granted the privileges of BIConsumer role.
  • BIAdministrator : This role has the privileges of BIAuthor &BIConsumer roles. In addition to that this role allows the user to administer all parts of the system, including modifying catalog permissions and privileges. This user is the most privileged user in OBIEE environment.
In some cases, a need may arise to add another role that suits well between the BIConsumer and BIAuthor roles; one called BIAnalyst, that allows users to create and edit analyses, but not creates new dashboards.

Thursday, 4 September 2014

Informatica Scenario: How to Load Data in Cyclic Order using Informatica

To Load source records from DEP table to target in a cyclic order.
In this scenario  we will load the records present in the DEP table to Flat files in a cyclic order such that the first record will go to TargetFile01 ,2nd to TargetFile 02 ,3rd to Target File03 and 4th record again to TargetFile01.



For implementing this we can make use of sequence generator  with properties as given below.


You can route the records based on the NEXT VAL of sequence Generator using a Router as given below.



The overall mapping will look like this.



Below is the expected format in which target files will be created.



Related Posts Plugin for WordPress, Blogger...

ShareThis