Working with Users and Groups in the Embedded LDAP Server..!

When you install OBIEE, the installer asks you to enter the username and password for an administrative user, which we use it to log in to Fusion Middleware Control.

To add new users to your system and assign them to groups (ex LDAP groups, AD groups) , you use the web based Oracle WebLogic  Administration Console, which contains features for managing the embedded LDAP server.

Example of Creating New Users and adding them to Groups  

01.   Log in to Oracle WebLogic  Administration Console(http://:7001/console) from the user having administrative privileges (example weblogic/welcome1)
02.  When the home page appears, click on Security Realms

03.    When Summary of Security Realms page appears, click on “myrealm”. ”myrealm” is the default container for security settings.
04.    Once you click on “myrealm” it will take you to the next page. Click on “Users and Groups” tab to start creating new users.

05.    Click on New button and enter the details for new users.”DefaultAuthenticator” refers to your embedded LDAP server ,which is default provider for authentication for newly configured system.Click “OK” to create the user.

 

06.    To add the user to one of the LDAP group in your LDAP directory , therefore to grant the user to a application role , click the user (“mayank”), it will take you to the another  page , Go to groups.

07.    Select the LDAP group/s and from the left pane and click “save” to complete the process.

Working with Application Roles and Policies

The user is created and added him/her in BIAuthors LDAP group, this group must be linked to BIAuthor application role .This role is granted to “BIAuthors” LDAP group in OPSS policy store as part of default security configuration.
To check how Application Roles and Policies are administrated in using Fusion Middleware Control
01.    Login to Enterprise Manager using url (http://:7001/em) using administrative user.
02.    When the home page is displayed, Go to Business Intelligence --> coreapplication. Right click “coreapplication”. Security --> Application Policies/Role will get displayed.

03.    Click on Application Roles. Locate on BIAuthor Application Role  and click on it.

04.    You can see in the bottom pane, two other objects have been granted this role.One is the BIAuthors LDAP group and other is the BIAdministrator  application role.This means this very object “BIAuthor” inherits the permission and privileges of BIAdministrator  application role.

Creating and Managing Application Roles

01.    Create an application role using the Fusion Middleware Control(em)
02.    Create a matching LDAP group using the Oracle Weblogic Admin Console or identify in FMW which existing LDAP group you want to map it to the application role.
03.    In FMW(em), grant the role to LDAP group.
04.    Using Admin Console, add user to relevant LDAP groups.
05.    Launch the Oracle BI Administrator tool and refresh its view of the current application roles in your Policy Store.
Example:
01.    Create an application role as shown above by logging into (http://:7001/em)
Name: FINANCE Manager
Description: Financial Analytics Manager

02.    Create the corresponding LDAP group and assign it to the required user to the group. For doing this log in to Oracle WebLogic  Administration Console(http://:7001/console)  from the user having administrative privileges (example weblogic/welcome1)
Name: FINANCE Managers
03.    Finally add the required user to this LDAP group.
04.    Log in back to the Fusion Middleware Control (em) and launch the application role page again. Click on the application role “FINANCE Manager”. Click on the Edit button.

05. To grant this new application role to the corresponding LDAP group, in the Member section Click add button and then select the LDAP group from the searched principal group.

Creating and Managing Application Policies

Application Policies like application role are created and held in a policy store and administrated and accessed by OPSS. You can access the existing by logging into Enterprise Manager using url (http://:7001/em) using administrative user. When the home page is displayed, Go to Business Intelligence --> coreapplication. Right click “coreapplication”. Security --> Application Policies/Role will get displayed.

Application Policies are basically set of JAVA permissions associated with a principle. For Example: The BI Author application policy allow you to develop reports and other perform other report authoring task.

Few application policies which are granted to the application role BIAuthor as below :-
oracle.bi.publisher.developReport
oracle.bi.publisher.developDataModel
EPM_Essbase_Administrator
EPM_Essbase_Calculate
EPM_Calc_Manager_Designer
oracle.epm.financialreporting.editBatch   
oracle.epm.financialreporting.editBook
oracle.epm.financialreporting.editReport
oracle.epm.financialreporting.scheduleBatch
oracle.epm.essbasestudio.cpadmi

The above are set of JAVA permissions associated with a principle. Oracle BI ship all possible combination of policies under the application role BIAdministrator, BISystem, BIConsumer, BIAuthor.
Therefore if you created an application role which is linked to a LDAP group and finally to an user, you just need to assign the any of the four application role to inherit their policies.

If you freshly want to create an application policy which is not among the available policies under the given four application role, you need to write the JAVA program for the same and then deploy it into the weblogic.
Always remember BIConsumer is by default assigned to user once you create it.

WORKING WITH EVENT TASKS[Informatica Workflow Task]

WORKING WITH EVENT TASKS

We can define events in the workflow to specify the sequence of task execution.

Use the following tasks to help you use events in the workflow:

v    Event-Wait task. The Event-Wait task waits for an event to occur. Once the event triggers, the Integration Service continues executing the rest of the workflow.

Types of Events:

·        Pre-defined event: A pre-defined event is a file-watch event. This event waits for a specified file to arrive at a given location or directory.

Let us try to understand it with an example. You wanted to wait for a file to arrive in a directory while keeping the workflow on running mode. Once the file arrives in the directory the mapping session should automatically be kicked off to load the data into target.

·        User-defined event: A user-defined event is a sequence of tasks in the Workflow. We create events and then raise them as per need. In this case we first raise a user defined event and then configure the event wait which will wait for user defined event to occur and triggers the next session in the workflow

    EVENT RAISE: Event-Raise task represents a user-defined event. We use this task to raise a user defined event.

    EVENT WAIT: Event-Wait task waits for a file watcher event or user defined event to occur before executing the next session in the workflow.

Scenario:-

You have two sessions. The first session first remove the duplicates from the file (s_remove_dups) and once this gets completed then you need to run another session which calculates minimum and maximum salary (s_max_min_sal)

How to configure User-defined event

·         Workflow -> Create -> Give name wf_event_wait_event_raise -> Click ok.

·         Workflow -> Edit -> Events Tab and add events EVENT1 there.

·         Drag “s_remove_dups”

·         Click Tasks -> Create -> Select EVENT RAISE from list. Give name.

·         Right click event_raise_example -> EDIT -> Properties Tab -> Open Value for User Defined Event and Select EVENT1 from the list displayed. Apply -> OK.

·         Click link between event_raise_example and s_remove_dups and give the condition $s_remove_dups.Status=SUCCEEDED

·         Click Tasks -> Create -> Select EVENT WAIT from list. Give name event_wait_example. Click Create and then done.

·         Link event_wait_example to START task.

·         Right click event_wait_example -> EDIT-> EVENTS tab.

·         Select User Defined there. Select the Event1 by clicking Browse Events button.

·         Apply -> OK.

·         Drag s_max_min_sal and link it to event_wait_example.

·         Mapping -> Validate

·         Repository -> Save.

·         Run workflow and see.

Screenshot of Details

Journey of Joy - A night spent at Kabani

It's really surprising and exceedingly well for me that first time I am in Bangalore and weekdays were more of trips and photowalks. Straight-away,credit goes to my loving family who has made it possible.My loving bro's mesmerized me with their ability to capture simple yet profound beauty of nature located in southern part of India, The Kabani.It is most popular wildlife destinations of Karnataka originates from the Wayanad District of Kerala state empties into the Bay of Bengal.Lush green landscape surrounding the large lake gives a spectacular view of wildlife and bird life where chirping of migratory bird specially in March,closer look of how the group of herbivorous wild animals interact among themselves to save their life from giant tiger and leopards and nonetheless feel of slow moving river is just like icing on the cake.During the summer many hidden Islands emerge out of backwaters & its a perfect place for Camping.No hard treks, No extreme adventure, Its just camping although we choose to stay like Maharaja in Maharaja Cottage.

We started our journey to “Kabani” on March 19th @ 7.15 AM from Bangalore, en-route we reached Mysore and met Miss Monalisha my sister at her college.We spent some quality family time with her and started @ 10:20 AM from Mysore towards our destination The Kabani. we reached Kabani @ 1:20 PM delay by an hour.But the moment we were near the entrance of wildlife resort the only expression which I could notice at the entrance from each one of us is WOW!!! such a nice place...The excitement and energy were in full upswing even if the weather was hot and dry.

We reached near the reception desk and looked for the proceeding of day.We explored the map of resort with the help of one of the person sitting at reception desk.From there straight-away towards our Maharaja Cottages. The cottage were influenced with more of Colonial style architecture.The breathtaking view of the backwaters of River, full of lusty green view from cottage gives us a heavenly feeling and we were sure that we are gonna spend some quality time away from fast,furious and crowded world.

We were asked to get ready for lunch.The dining facilities was amazingly good.It was of circular shape which is referred as the Ghol Ghar. About the food you can check with Mr Ranjan & Mr. Tej my bro's.They were eating as if they didn't had since a month or so.We get back to Maharaja Cottage somewhere around 3:00 PM.We among ourselves were discussing about the ambience & facilities meanwhile somebody knocked the door and asked us to get ready for motorboat safari.We get into the motorboat. It was an amazing ride. Watched the forest from river and spotted few animals.Among the animals, deer, elephants, gaur and crocodiles were most common. Watched different types of birds.Later that evening we enjoyed the company of a large "Stripe-necked Mongoose" before ending the motorboat safari... The weather was hot still we were enjoying moments. At one place which is territory of one big tiger and 3 cubs, we waited for about 10 min in pin drop silence on boat. Our bad luck tiger didn't turn up near to water.Ended Boat Safari after 3 hours. It was very long and enjoyed every moment.

Got back to the cottage somewhere around 7:00 PM.Had a cup of coffee in the balcony of cottage.Mesmerizing view of river,jungle and chirping of different birds gives us feeling as if we are in heaven for sometime.This was serene, quiet and so pleasant. We chatted along for a while, talking about how we should spend more time outdoors, go camping somewhere maybe.Meanwhile Mr. Ranjan commented don't you guys think we should be ready for dinner.Obsession about the food shown by Mr Ranjan & Tej took us again back to Gol Ghar.The food comprises of piping hot buffet of multi-cuisine, well-planned menu which includes Indian, Chinese and Continental dishes.

After finishing the dinner, we assembled into a movie hall for about 45 mints for wildlife documentaries screened at the lodge.8:30 PM. After that we had an option to bask in the warmth of the campfire, while we opted to get back to Cottage and chat for some more time.Overall the day was good.There is plenty for us to see, hear and photograph. Varieties of birds fly about in colorful array chirping and singing through the day.The night spent at the cottage was good too.We can feel slow moving wind, peaceful, and a natural landscape right on the bank of river.

On the 20th March, early in the morning we head towards the vibrant wild forest in search of lively panther that dashed across the road, several wild dogs, elephants, gaurs, sambars, spotted deers,wild pigs and nonetheless a large variety of birds.This was indeed through Jeep Safari deep into the Jungle. we were more thrilled to enter into woods with great expectations.Suddenly Jeep halted deep into the Jungle for more than 10 mins and we were so fortunate to see fresh tiger mark on the mud.It was not even more than 15 mints suddenly few deer started barking & hooting sounds from monkey.We were little conscious.I suddenly turned towards trip guide and asked why this sound..!He informed us that its an alarm bell from monkeys & deer that tiger or leopard is around making watchful to entire herbivorous family. There was plenty of butterflies all moving around in patches. Just after a few metres we were greeted by a group of spotted deer.The group consisted of bucks,does and some very cute calves.Next we saw some more deer, magnificent nilgiri langoors and giant malabar squirrels and nonetheless peahen & peacocks.

Around 9:30 AM we came back to cottage had breakfast and coming towards an end of approx 225 KMs journey.My mind is refreshed enough for a fresh start.

Welcome to the beautiful world of nature !!!