Sunday, February 16, 2014

How to create users and groups in OBIEE11g

Use console link to create user/group in OBIEE11g

1.       Go to console link ( http://localhost:portnumber/console ) and provide the credentials to login.Once logged into the console link click on the Security Realms link which is appeared in the left side pane

2.       Click on the  Myrealm

3.       Go to the Users and Group tab then select the user in below tab and click on new button
4.       Give the below information
User Name, Password and Confirm Password
Example: Here we are created user with name of mark0099
User is created and we can see the user in users list
5.       To create group select Group tab and click New button then create Group
6.       Assigned Group to user
                                 a. Click on the user  then go to the Groups tab
                b. Move the Group from left side to right side using the arrow and click on the save button










Monday, February 10, 2014

Security in OBIEE 11g


In 10g we are having Users and Groups as part of security but in OBIEE11g Application roles are newly added feature

OBIEE10g -> (Users, Groups)
OBIEE11g -> (Users, Groups, Application roles)

Default Application roles in OBIEE 11g
3 main default Application roles
BIAdministrator
                BIAuthor
BIConsumer  

BIAdministrator : BI Administrator can change the OBIEE Installation configure and implicitly granted the BIAuthor and BIConsumer roles
BIAuthor:  has permissions to create and edit content for other users and implicitly added BIConsumer role

BIConsumer: By default every user is part of the BIConsumers groups


 

Sunday, December 29, 2013

How to stop forcefully running Scheduler in OBIEE10g (disabled Restart Option in OBIEE10g Scheduler)

Issue: disabled restart option in BI Schedule

Solution: Go to command prompt and use the below scripts to stop the services forcely then we can see the restart link as enabled
                 1. Go to command prompt and type “taskkill /IM NQSServer.exe” script in command then we can find the task PID number
               2. Use “taskkill /f /PID PIDNumber” script to stop task forcely .

   Example:  Here 5940 is the PID number
If the task is completely killed then you can see the message as “SUCCESS: The process with PID PIDNumber has been Terminated.
3. In above we have stopped the BI Server, like we can stop the BI Scheduler like as in the below screen shots.
Then Restart option will enabled