OAC OAC v105.4: Understanding Map Data Quality OAC 105.4 new Feature "Maps ambiguous location matches" lets you understand the quality of your mapping matches.
Technical Security patches released for OBIEE 11.1.1.7/11.1.1.9, and ODI DQ 11.1.1.3 Oracle issued their quarterly Critical Patch Update yesterday, and with it notice of several security issues of note: The most serious for OBIEE (CVE-2013-2186) rates 7.5 (out of 10) on the CVSS scale, affecting the OBIEE Security Platform on both 11.1.1.7 and 11.1.1.9.
Technical Getting The Users' Trust - Part 2 Last time I wrote about the performance aspects of a BI system and how they could affect a user’s confidence. I concluded by mentioning that incorrect data might be generated by poorly coded ETL routines causing data loss or duplication. This time I am looking more at the quality
Technical Oracle Enterprise Data Quality Revisited Recently I have be working with Oracle Enterprise Data Quality (EDQ) combined with Oracle Data Integrator (ODI), we will tell you more about exactly what we have been doing in another blog, but for now I would like to revisit our earlier EDQ blogs. I am going to keep to
Technical Introducing Oracle Enterprise Data Quality Visually, BI dashboards and analyses can be impressive and appear to meet the user’s needs, but if the data displayed on the dashboards isn't reliable or correct then those same users can quickly lose faith in what they contain. Therefore, it’s important that assessing and managing data quality
Business Insights Geography Hierarchies I have been thinking about address a lot recently, in part it was moving house and all of the 1001 people that need to be notified. In the main, though, it was thoughts inspired by a data warehouse project I am working on. For this DWH people are geo-located by
Technical Regular Expressions in OBIEE When reporting against an OLTP system, in many ways, OBIEE works like an ETL tool, transforming the source system data and presenting it as a star schema. After years of writing ETL code, if there's one thing I hate to be without, it's regular expressions. So, when working on a
Technical End-to-end data quality One of our customers is about to embark on a significant BI project; but being in the "public sector" they have to (by EU law) publish tender documents so that qualified suppliers throughout the EU can bid to do the work. This means they have a gap of
Technical Being Flexible One of the things I really love about working with the team here at Rittman Mead is how we can offer our clients a flexible service, I guess this flexibility must be appreciated by our customers as we have just won the UKOUG Business Intelligence Partner of the Year award.
Technical Quality thoughts as I continue to chill out Over at another Blog, Beth notes that she is editor of the month for the Carnival of Data Quality. When It comes out I urge you to take a look. With those strange quirks of global IT companies Beth and I once worked for the same employer, but we have
Technical A flat world A lot of data warehouses get some (if not all) of their data feeds through data files; in fact I can't recall a recent project where at least one feed from an external system did not arrive as some form of flat file. I have had customers whose corporate data
Technical Product dimensions The other day a colleague invited me to sit in on workshop session with a customer to discuss changes to an attribute of product. On the face of it it sounds a bit of overkill to spend two hours discussing the meaning of just one attribute, but when that attribute
Technical GIGO (or part 2) As an acronym, GIGO for Garbage In, Garbage Out seems to have a better ring to it than the less common (or non-existent) terms TITO, RIRO or CICO. But the principle is the same; if you want good results, don't store rubbish. As I mentioned earlier we must guarantee the
Technical Data quality for success The final installment on the ingredients for successful BI is about data quality. For some strange reason, if users do not trust the quality of data in a BI system the system will fall into disrepute and be seen as a failure. Now I said "strange reason" and
