Part 2 Adding Users to Application Roles in OBIEE

Steps to add users to Application Roles and to resolve issues if encountred 1. Once the LDAP is configured then the next task would be to add users to the Application Roles. This is to be done in em Traverse through the path  Business Intelligence–>coreapplication–>Security–>Application Roles 2. Then click on BI Administration Roles and edit. In that add the user from the LDAP  3. Once … Continue reading Part 2 Adding Users to Application Roles in OBIEE

Setting up Active Directory with OBIEE 11g and their issues resolved

Hi All, I have been recently setting up Active Directory(Microsoft) with OBIEE 11g and assigning roles and privileges from users from LDAP and faced a lot of issues. I composing a document on all of them and will share my research soon. Topics to be covered in Securities in this Post 1. How to set up LDAP along with Default Authenticator 2. How to add … Continue reading Setting up Active Directory with OBIEE 11g and their issues resolved

Steps to create Master Repository and Work repository in ODI 11.1.1.7.0

Hi All, Using the normal configuration of the ODI sometimes the screen hangs at the stage of creation of Agents. In that case the best possible method is to create the Master repository and the Work Repository Manually. Please find the steps below Creation of Master Repository 1. First we have to create schema for the Master Repository     Connect as sys(Administrator) and then create … Continue reading Steps to create Master Repository and Work repository in ODI 11.1.1.7.0

Screen disappears after choosing Desktop Class in Oracle Server 11G R2 installation – (Solved)

Hi All, I was recently installing Oracle 11g R2 64 bit installation in  my local. I have done this step multiple times but this time after choosing the setup and in the 3 or 4the step choosing the desktop class option the screen disappears. If you try looking for the logs there is no entry. I sat with this days until I found a  solution … Continue reading Screen disappears after choosing Desktop Class in Oracle Server 11G R2 installation – (Solved)

Passing All Choices in Presentation Variables

Hi All, I was working on this report and had faced this issue and took some time to work around it so thought would be helpful to post it. Scenario- I have a dashboard which has reports from different Subject Areas and I’m using a Presentation Variable in the Prompts to filter out the report data. This is quite simple and can be done easily … Continue reading Passing All Choices in Presentation Variables

Installation of ODI in Windows7/8

Hi All, Its been a while since I have written something. I’m on the process of installing ODI in Windows 7/8 and will post the steps soon with the errors and the how to over come the issues. There are basically 2 major steps to install the ODI Integrator To install the metadata using the RCU Install the ODI by using the schema created by … Continue reading Installation of ODI in Windows7/8

Variables in Oracle OBIEE

   There are basically 4 different types of variables in OBIEE 11g. Session Variables Repository Variables Presentation Variables Request Variables. Session Variables: As the name suggests, session variables are created during the creation of session i.e., as soon as a user logs into the BI server.  So, Every login has its own session variable. There are two types of session variables  System (which are defined … Continue reading Variables in Oracle OBIEE

TIMESTAMP Expression for Date Calculation in OBIEE 11g/12c

First Day of the Previous Year TIMESTAMPADD( SQL_TSI_YEAR , -1, TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( DAY_OF_YEAR FROM CURRENT_DATE) * -(1) + 1, CURRENT_DATE))  From right to left the first TIMESTAMPADD returns the first day of the current year. The second TIMESTAMPADD removes a year from the returned date for the First Day of the Previous Year. First Day of the Current Year TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( … Continue reading TIMESTAMP Expression for Date Calculation in OBIEE 11g/12c

Installation of DAC 10.1.3.4.1 in Windows7/8

I was just installing DAC 10.1.3.4.1 in my new Windows 8 machine and was facing this issue for a quite some time. I just got it resolved and thought post it.   1. Go to the instllation setup in the path DAC/disk1/install and click on setup.exe as Administrator. You will get the following error mentioned below.           2.  To avoid this … Continue reading Installation of DAC 10.1.3.4.1 in Windows7/8