OBIEE 11G: Configure Conditional Navigation Among Reports

Hello it's me again.This entry is to talk about the use of Actions in making reports (Or Analysis in 11G language) interactive. For those of you that are familiar with 10G or prior, we can set up report columns in such way that it will navigate to another report and the result of that new report will be filtered by the value we click from the source report. You know how that goes, right?Well, one of the limitation is that we can't make the navigation...

Read More

OBIEE Interviews and how to excel

Hello againOne of the biggest challenge for a lot of junior OBIEE professionals is to excel at interviews. In the past few years, I have had the opportunities to both take interviews for the new project and to interviews other candidates for projects that I had. When it comes to interview for OBIEE, specially when this is not an entry level opening, my goal as the interviewer is to find out what kind of experience the candidate has, that's all.I...

Read More

How to run stored procedure from DAC

Hello AgainIt's been a while.. This time I want to share something I just learned over the past few months, it is how to execute a stored procedure directly in DAC without having anything to do with Informatica (as discussed in the previous post).Let's say we have a store procedure or package 'mck_client_wip_load' in stance 'mck_build_revwip_pkg', or mck_build_revwip_pkg.mck_client_wip_load. In order to execute this stored procedure in directly DAC,...

Read More