Business Insights Statistical Analysis in the Database My first ever presentation at the UKOUG conference (long before I started working with Mark Rittman and Jon Mead) was an introduction to analytic functions. Since then analytics have remained a key part of my work as a DW developer; many of the processes that I have implemented would be
Technical Oracle Data Integrator Designer for OWB Developers Last time [https://www.rittmanmead.com/blog/2012/03/oracle-data-integrator-topologies-for-owb-developers/] I described some of the aspects of ODI Topology. I only touched the surface of this subject and mainly kept to database sources; if you attend one of the Rittman Mead ODI bootcamps [http://www.rittmanmead.com/training/] (we have
Anatomy of BI EE Page Rendering - Use of HTTP/Web Server & Compression There are many aspects/variables thatcan affect the performance of a BI Deployment. Generally whenever a BI Dashboard is slow the general tendency is to attribute the slowness in performance to eitherthe BI Reports or underlying databases. Of course, in 90% of the cases this will be truebut there are
Business Insights New Training Courses and Seminars from Rittman Mead I've recently joined Rittman Mead to head-up our Training [http://www.rittmanmead.com/training] area, and for the past few weeks have been working on a number of new topics, modules and delivery channels for our courses. We're now going to be offering public, focused half-day
OBIEE 11g Security Week : Connecting to Active Directory, and Obtaining Group Membership from Database Tables In this final posting in the OBIEE 11g Security Week, we're going to look at two common tasks that an OBIEE 11g administrator might have to perform: * Connecting the system to Microsoft Active Directory, so users can log-into the dashboard using their Windows Active Directory username and password,
Deploying ODI 11g Agents for High-Availability and Load-Balancing A couple of weeks ago I was with one of our clients, who were planning their migration from home-grown ETL to using Oracle Data Integrator 11g. One of their requirements was for the agents that ODI uses to be deployed in a high-availability environment, so that for example: * More than
OBIEE 11g Security Week : Managing Application Roles and Policies, and Managing Security Migrations and Deployments In yesterdays blog post on OBIEE 11g security, we looked at OBIEE 11g's security architecture [https://www.rittmanmead.com/blog/2012/03/obiee-11g-security-week-understanding-obiee-11g-security-application-roles-and-application-policies/] , and what's called the "Default Security Configuration". We looked at how new users were created and assigned to existing LDAP groups
OBIEE 11g Security Week : Understanding OBIEE 11g Security, Application Roles and Application Policies This week, in preparation for the final, Security chapter of the book that I'm writing, I'm running through the key areas in OBIEE 11g and inviting feedback on what readers are encountering in the field. So far we've looked at row-level security [http://www.
OBIEE 11g Security Week : Subject Area, Catalog and Functional Area Security In the previous posting in this series, we looked at an overview of OBIEE 11g security [http://www.rittmanmead.com/blog/2012/03/an-obiee-11g-security-primer-introduction/] , and then looked at row-level security [http://www.rittmanmead.com/blog/2012/03/obiee-11g-security-week-row-level-security/] , which allows us to deploy the same analysis or dashboard out to
OBIEE 11g Security Week : Row-Level Security So we'll start this week's focus on OBIEE 11g security [http://www.rittmanmead.com/blog/2012/03/an-obiee-11g-security-primer-introduction/] with the topic that most people associate with "security" around reports - row-level security. Row-level security is where groups of users have access to a set
Rittman Mead at the Hotsos Symposium 2012, Dallas Last week I was very proud to present at the Hotsos Symposium 2012 [http://www.hotsos.com/sym12.html], in Dallas, Texas, on the new Oracle Exalytics In-Memory Machine. It'd always been a personal objective of mine to speak at the Hotsos event, as I'd seen
An OBIEE 11g Security Primer : Introduction For anyone who's been waiting for the Oracle Press "OBIEE 11g Developers Guide" that I've seemingly been working on ever since Oracle acquired Siebel, you'll be pleased to know that I'm working on the final chapter now. The only issue
Business Insights About the Oracle BI Developer (NDA) Day at the BI Forum Events We were pleased to finally launch the website and registration page for the Rittman Mead BI Forum 2012 [http://www.rittmanmead.com/biforum2012] yesterday, and something that's new this year is an extra day, at the end, run in conjunction with Oracle BI Product Development and ourselves. The
Business Insights Rittman Mead BI Forum 2012, Brighton & Atlanta : Registration Now Open! I'm very pleased to announce that registration for the Rittman Mead BI Forum 2012, running in Brighton and Atlanta in May 2012, is now open, with details of the event and how to register on this page [http://www.rittmanmead.com/biforum2012]. [http://www.rittmanmead.com/biforum2012] This
How, and Why, Should I Upgrade to OBIEE 11.1.1.6? Over the past few weeks we've run a series of articles on the blog about the new, 11.1.1.6 release of OBIEE, and talked about some of the new features that this release enables. So you may well be asking yourself, what's involved in
Oracle BI Suite EE OBIEE 11.1.1.6 : New Dashboard, Analysis and Reporting Features So apart from support for a new type of repository storage [http://www.rittmanmead.com/blog/2012/02/obiee-11-1-1-6-mds-xml-repositories-and-integration-with-source-control/] , and enablement of the Oracle Exalytics In-Memory Machine [http://www.rittmanmead.com/category/oracle-exalytics/], OBIEE 11.1.1.6 brought in a number of new features that could be of benefit
Business Insights Oracle Exalytics : An Example Optimization Exercise It's Saturday afternoon, and I'm writing this whilst on a plane going over to Dallas, Texas, traveling to what will be my first Hotsos Symposium [http://www.hotsos.com/sym12.html]. For anyone mainly working in the BI world who's not heard of the
Technical Oracle Data Integrator Topologies for OWB Developers Back in October of 2011 I posted [https://www.rittmanmead.com/blog/2011/10/oracle-warehouse-builder-and-data-integrator/] the first part of a series of blogs that aimed to describe some of the key features of Oracle Data Integrator (ODI) from the point of view of an ETL developer who already knows Oracle
Oracle BI Suite EE Oracle Exalytics Week : How Does it Perform, and How Can I Test It? This week we've been looking in-depth at the new Oracle Exalytics In-Memory Machine, the new Exa-appliance from Oracle aimed at the BI tier in an Oracle BI/DW system. We've looked at what problem Exalytics looks to solve, how it's architected and how TimesTen
Oracle BI Suite EE Oracle Exalytics Week : The Summary Advisor This week we've been taking an in-depth look at Oracle Exalytics In-Memory Machine, the new engineered system from Oracle that combines Sun hardware with customized versions of Oracle Business Intelligence, Oracle Essbase and Oracle TimesTen, all running on 64-bit Oracle Linux. Here's a quick recap of
Oracle BI Suite EE Oracle Exalytics Week : Exalytics & TimesTen - Under the Covers So in the first two postings in our Exalytics week series, we looked at why Oracle created Exalytics, and what Exalytics actually comprises of. If you missed the first two postings in the series, here's the week's agenda including links that I'll complete once
Oracle BI Suite EE Oracle Exalytics Week : Introducing Oracle Exalytics In-Memory Machine In the first post in this Oracle Exalytics week series, we looked BI in general and how users wanted fast, consistent response times from their dashboards and reports. The are several potential solutions for improving query performance including adding materialized views and indexes, using MOLAP technologies such as Oracle Essbase
Oracle BI Suite EE Oracle Exalytics Week : The Case for Exalytics OBIEE 11.1.1.6 was released last week [https://www.rittmanmead.com/blog/2012/02/obiee-11-1-1-6-now-available-for-download-release-highlights/] , and what with all the news on the new features, and support for version control in the BI Administration Tool [https://www.rittmanmead.com/blog/2012/02/obiee-11-1-1-6-mds-xml-repositories-and-integration-with-source-control/] , the thing that most excited
Oracle Magazine Article on Oracle BI Mobile [http://www.oracle.com/technetwork/issue-archive/2012/12-mar/index.html]The March/April 2012 edition of Oracle Magazine is now out, and includes my latest BI article, this time on Oracle BI Mobile with OBIEE11g [http://www.oracle.com/technetwork/issue-archive/2012/12-mar/o22bi-1518268.html] . In the article, I talk
Rittman Mead at RMOUG Training Days 2012, Denver A week or so ago several of Rittman Mead's consultants were pleased to be taking part in RMOUG Training Days 2012 [http://www.rmoug.org/training.htm], in Denver, Colorado. RMOUG (Rocky Mountains Oracle User Group [http://www.rmoug.org/index.html]) is probably the largest regional Oracle
