At first I thought it would be done through the web application only to find no edit button associated with the user. I had to go through the online repository, update the user, and commit those changes. Not really sure what all that means yet, but it's a start.
I had a crash tutorial on this last week as the person I replaced was off to start his own company. OBIEE is a vast, vast world.
Where does one go to learn OBIEE from the bottom? OTN naturally. The Oracle By Example series is excellent so that's where I started.
First up, Creating a Repository Using the Oracle Business Intelligence Administration Tool . I've made it through the Physical Mappings and the Business Mappings so far, one more section to go. I can't say I completely understand all the lingo, but I'll catch on sooner or later. I'm more concerned with the basics of support at this point.
Official Oracle Documentation
- 10.1.3.4.1 and prior
- OBIA 220.127.116.11
- OBIA 18.104.22.168
I have noticed quite a bit of traffic comes to this page so I am going to continue to update it in regards to OBIEE 11g. I'll keep the 10g stuff here as well as many of the principles are the same, I'll just point to specific posts in this section.
Sample Applications for both 10g and 11g provided by Oracle are here. Good way to learn as you get to see how others do certain tasks.
22.214.171.124 Sample App (v107) is here.
OBIEE 126.96.36.199.2 BP1 - Sample Application (V207)
- Oracle BI EE 11g – Upgrading from BI EE 10g – Repository & Web Catalog
- An Oracle Fusion Middleware 11g Primer for EBS Sysadmins - Don't let the EBS part fool you. Fusion Middleware is now the underpinning of OBIEE so understanding it is key.
- OBIEE 11g - Demystifying the directory structure - Great overview of the new directory structure. I still get lost trying to figure out what is what. Doesn't help that there are multiple folders under different roots with the same name...
--> Here's my take, Fun With Folders!
- Startup/Shutdown Script for Linux Installations
- Starting and Stopping Services on Linux (mine)
- OBIEE: Start/Stop Individual Components (Enterprise Manager)
- OBIEE: Start/Stop Individual Components (Manually)
- Customizing Oracle Business Intelligence Enterprise Edition 11g
- OBE: Creating and Deploying Custom Styles, Skin, and Messages in Oracle BI EE 11g
- So Just What Does WebLogic Server Do Within OBIEE 11g?
- So How Does Enterprise Manager work, Within OBIEE 11g?
Bob Ertl - Bob is the first person I have seen from the BI team to actually blog. What better place to get information than straight from the source?
- Oracle BI Server Modeling, Part 1- Designing a Query Factory
- Oracle BI Server Modeling 2- Dimensional Schema Shapes
- Oracle BI Server Modeling, Part 3- Conformed Logical Dimensions
OBIEE 10g 10.1.3.4
- The RittmanMead blog is the premier online resource for all things OBI EE. It can be found here.
- John Minkjan over at OBIEE 101 has quite a bit of information. He posts often and detail posts. I've already been able to reference individual posts a number of times.
- gerardnico There are some great resources here.
- Christian Berg - who has helped me quite a bit writes over here.
- rnm1978 - same goes for this guy. Very helpful articles.
- OTN Forums
BI Architecture Series
This just started recently by Mark Rittman, I'm looking forward to future posts in this regard:
Inside the Oracle BI Server Part 1 : The BI Server Architecture
Inside the Oracle BI Server Part 2 : How Is A Query Processed?
Inside the Oracle BI Server Part 3 : BI Server In-Memory Joins
- XML File as Data Source
- Text File as Data Source
- Excel File as Source
- Migrate Your RPD
- Aggregation Persistence Wizard (h/t Christian Berg [blog|twitter])
- Report Drilldown
- Install 10.1.3.4 on Oracle Enterprise Linux 5, Update 4 - Details on issues with installation (using VirtualBox)
- Uninstall on Oracle Enterprise Linux 5, Update 4
- Install 10.1.3.4 on Windows Vista Ultimate
- Install on Windox 7, x64
My articles on said subject can be found here.
- Connect to Remote RPD
- Usage Tracking Performance Improvements
- error : Odbc driver returned an error (SQLExecDirectW)
- Don't Change the Administrator Password!
- Direct Database Request
I'm sure as time goes on my tastes will ebb and flow. I'll update as appropriate.