Case Study: Emailing OBIEE dashboards with ad-hoc agent that dynamically passes dashboard prompt values based on user request -- Part 3

After rpd work is done, let's go to the dashboard. Well before that, I am manually creating these users with '_1' and so on in weblogics and make sure they all have their OBIEE account set up with the proper emails. Now go to dashboard and we will copy the existing dashboard and reports and create another version for emailing agents. First, modify the date and month prompt and manufacturer prompt Here in the default section, we are adding...

Read More

Case Study: Emailing OBIEE dashboards with ad-hoc agent that dynamically passes dashboard prompt values based on user request -- Part 2

From the previous time, I have finalized the DB table design, now let's check out what I did in the rpd. Below are the session initialization blocks. 'Security' and 'GROUPS' where created for the existing data level and object level security implemented before. Now I am adding a new one 'Security_Agent': In Security Agent, I have created session variables for each columns of the table. These session variables will be passed on to the dashboard...

Read More

Case Study: Emailing OBIEE dashboards with ad-hoc agent that dynamically passes dashboard prompt values based on user request -- Part 1

Hello Today I want to share this requirement that I encountered. This seems like a straightforward implementation but it's tricky actually. Currently, OBIEE's agent framework is not flexible enough to achieve this, therefore I feel like sharing this requirement out and maybe someone else will have even better ideas. First, let me explain the requirements and the background. Take the below dashboard for instance: The dashboard has 5 prompts and...

Read More

Case study: How to implement Object level security and Data Level Security in OBIEE 11G - Part3

Last part we have gone through the DB changes and RPD configuration for implementing data level and object level securities. Now there are some final pieces that needs to be done in order to make this implementation perfect. Let's start with object level security. We need to set them up so that different user group will only have access to their dashboards first. So here are the different folders that stores dashboards and reports meant for different...

Read More

Case study: How to implement Object level security and Data Level Security in OBIEE 11G - Part2

Last time, we have described the security requirements and the basic implementation strategy. Now let's take a look at the next step after the user table has been created. One thing I forgot to mentioned from the last entry was that, the password has encryption. Therefore, a method of decoding encrypted password is needed. Having that into consideration, we have created a few DB functions. 1. Ret_User_Auth does the authentication process by passing...

Read More

Case study: How to implement Object level security and Data Level Security in OBIEE 11G - Part1

Hello Again. Recently my team has implemented data level security and object level security in OBIEE 11G for a client who is selling their data to external customers. The requirement is very quintessential of any BI Project and the implementation process is trivial. Therefore, I have decided to detail the process, which I think can be very beneficial to any future security implementation. A little bit of background here. This is a client that...

Read More