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

The Service Integration Services could not be enabled due to the following error: SF_34004- Service initialization failed – (Solved)

This is an error caused in the configuration of Integration Services in the of Informatica9.0.1 Solution In the Power Center Repository Services make sure that the operating mode is changed from Exclusive mode to Normal mode. Once this is done restart both the Repository Services and the Integration Services Till next time cheers Continue reading The Service Integration Services could not be enabled due to the following error: SF_34004- Service initialization failed – (Solved)

Database driver event… Error occured loading library [pmora8.dll]. System error encountered is 193. Erorr text is %1 is not valid Win32 application. – (Solved)

Scenario I am trying to install Informatica Server and client 9.0.1 64bit on my Windows 7 64 bit operating system. I have my Oracle Server 64 bit also on the same system. I try to configure the Power Center Repository Services after the Informatica Server Installation but Im getting the error  Database driver event… Error occured laoding library [pmora8.dll]. System error encountered is 193.  Erorr … Continue reading Database driver event… Error occured loading library [pmora8.dll]. System error encountered is 193. Erorr text is %1 is not valid Win32 application. – (Solved)