Hi, I came across a requirement where I wanted the Departments to show all column values but do not want the dashboard prompt defaulted to all column values. Found this article in the blog where adding % as default values does the trick. When defining the presentation variable after defining the name in the filter in place of default values place % and that should … Continue reading All values as default option in OBIEE
Hello Guys, Recently I faced a dashboard privilege issue which I spend countless hours to resolve the issue. Scenario Create a new group and provide privilege to a dashboard. Pretty straight forward right !!. After creating the application roles and providing folder privileges I was hit by this error message and the error details didn’t provide much information. After researching and playing around with … Continue reading “O9XNZMXB” issue in OBIEE 11g Answers and Dashboards – Resolved
Scenario I had created a BIP report with a dynamic date of sysdate -8 as a prompt. The report works fine and the dataset is all good. However when I schedule this report I get and error stating ‘IOException:[INSTANCE_JOB_ID=344978] Invalid parameters requested.’ I tired to look into the code and also the trigger which I had set up and for some reason I could … Continue reading Dynamic Date Parameter in BIP Scheduler
Hello All, Its been a while that I have written something . I was busy with work and encountered this issue which I thought of posting it and could be helpful. Issue While uploading the rpd as usual I logged into EM (Enterprise Manager) and deployed the rpd. After clicking the activate changes option it was taking longer than expected. Once it was done, I … Continue reading FAILED_TO_APPLY_CHANGES error while uploading the RPD
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
Function explained – Partion by, Row_Number, Rank, Lead and Lag functions Continue reading Analytical Functions – Explained
We can place google search on the Dashboard .It is very simple. In the Dashboard take a text box and copy this HTML. Make sure to tick the HTML box. Once this is done save it and you can use Google search on your dashboard. Cheers !!Jethin Continue reading Google Search on the Dashboard
I installed OBIEE 11G in my machine and after the first restart faced this issue after which the weblogic server got shutdown. This is because there is a lock in the WLS which has to be removed. For that go to the path ORACLE_HOME//user_projects/domains/bifoundation_domain/servers/AdminServer/tmp and delete the file. When you later start the services its going to work fine. Continue reading Error: BEA-141281, unable to get file lock, will retry … – (Solved)
I was starting the BI Services and came across this error Problem: I got the error as below : Reason : A boot identity file contains user credentials for starting and stopping an instance of WebLogic Server. An Administration Server can refer to this file for user credentials instead of prompting you to provide them. Because the credentials are … Continue reading Force Shutdown of weblogic in OBIEE 11G – Solved
Its All About Data - By Jethin Abraham 