Mark Rittman

To schedule an OWB mapping or process flow to run at a set time, and optionally to run again after a set interval, without having to deploy it to OEM: First, log on as the Runtime Repository owner, and run the following script to create a function called RUN_OWB_

If you're looking to tune an SQL statement or a batch job, a common way to find out what happened during the execution of the SQL is to run an extended SQL trace and examine the wait events [http://download-west.oracle.com/docs/cd/B14117_01/server.101/

Neil Raden, who's article onModel-Driven Approaches For BI Projects [http://www.rittman.net/archives/000889.html] I linked to last year, dropped me a line to tell me about some new real-time ETL articles he'd written: > "Mark, I've written some articles and

A number of clients I've worked with recently have been looking to implement OracleBI Discoverer 10.1.2 for OLAP as their general ad-hoc query tool. Whether running against relational OLAP data or data in analytic workspace, Discoverer for OLAP comes with a slick new interface, an OLAP-aware

Oracle Rebrands Middleware As Fusion [http://informationweek.com/story/showArticle.jhtml?articleID=161501223] : "Oracle is slapping a new "Fusion" moniker on its array of middleware and development tools. "Oracle Fusion Middleware" to be formally announced Monday, will be the umbrella brand for some 32 products

Supercharging Star Transformations [http://www.evdbt.com/SuperChargingStarTransformations.doc] : "A star transformation is a methodology used to join tables to greatly improve performance of queries on dimensional data warehouse schemas.  Prior to star transformations, the primary join methods available were nested loops, merge, and hash joins.  Like many other

Tom Kyte, who'll you'll probably know through theAskTom [http://asktom.oracle.com/] site and the"Effective Oracle by Design" [http://www.amazon.co.uk/exec/obidos/ASIN/0072230657/markrittmansh-21/026-7358782-2852464] book, has started a blog [http://tkyte.blogspot.com/]. Tom's site is

Alan Alda's Interviewing Tips for Uncovering Business Requirements [http://www.intelligententerprise.com/showArticle.jhtml?articleID=160403897&pgno=1] : "Alan Alda is still widely known as "Hawkeye" Pierce from the hit television series "M*A*S*H" but he's also the

Tom Kyte :"In Search of the Truth - Or Correlation Is Not The Same As Causation" [http://asktom.oracle.com/pls/ask/download_file?p_file=3067171813508366601] > "... I have two guiding principles with regards to Oracle. One is that every day, each and every day, I

Larry's war: Oracle vs. SAP [http://news.com.com/Larrys+war+Oracle+vs.+SAP/2100-1014_3-5650929.html?tag=nefd.pop] :"Ellison's attack on SAP goes far deeper than words, as Oracle's recent acquisitions show. First, Oracle launched a full assault on joint rival

It's been busy, busy, busy around here over the last week with preparations taking place for ourOracle Business Intelligence & Reporting Seminar [http://www.oracle.com/webapps/events/Events.jsp?pagetype=NOADMIN&country=IE] over in Dublin. In the meantime, if like me [http://www.rittman.net/

The Dawn Of The BI Director [http://www.dmreview.com/article_sub.cfm?articleId=1021508] : "In most organizations, business intelligence (BI) has always played second fiddle to transaction applications. Organizations have traditionally lavished millions of dollars on projects to implement packaged operational applications and rewarded the IT managers who

Forbes.com : "Something's In The Water At Oracle" [http://www.forbes.com/work/management/2005/03/28/cx_ld_0328orcl.html] : "NEW YORK - As evidenced by our story on Keynote Systems and Umang Gupta, Oracle is fast becoming a breeding ground for ambitious executives

Maximizing Your ETL Tool Investment [http://www.dmreview.com/article_sub.cfm?articleId=1021507] : "Is your organization struggling to justify an ETL (extract, transform and load) tool purchase? If the tool is an enterprise level solution, the entry price is likely well into the six digits. At this price,

What's Holding XBRL Back? [http://www.intelligententerprise.com/showArticle.jhtml?articleID=159401688] : "Ventana Research believes metadata tagging holds great promise for the future of business intelligence and business process automation. So why is it taking so long for the Extensible Business Reporting Language (XBRL) to gain traction

One of our customers I worked with recently asked about implementing the equivalent of row-level security within analytic workspaces. I subsequently came acrossthis posting [http://forums.oracle.com/forums/thread.jsp?forum=16&thread=276546&tstart=105&trange=15] on the OTN OLAP Forum which details a

It's that time of year again when the various Oracle conferences start calling for papers. TheUKOUG Conference & Exhibition call for papers [http://conference.ukoug.org/conference.asp?sectionid=5] opened up a couple of weeks ago, and over the next few months it'll be possible

It's the Easter break over here at the moment, and I'm off work for the next week with a bit of paternity leave. Things are a bit hectic as I'm sure you can imagine, with a two and a half-year old and a two

I've been back in the office for a few days this week, and so it's a good chance to catch up on what's happened while I've been away. The big news for all us Oracle OLAP users is that the 10.1.

[https://storage.ghost.io/c/a3/6b/a36b5d7a-7ebf-48b4-a634-7224d6a30825/content/images/2016/05/01124isabella_small.jpg]Well, in the end she was a week late, but this morning our second child, Isabella Ruby Rittman, was born at theRoyal Sussex Hospital [http://www.nursing-in-sussex.co.uk/brighton.html]in Brighton. She'

If you've been following my work on putting anOWB Performance Tuning Framework [http://www.rittman.net/archives/001209.html] together, and you read yesterday's article onrunning an event 10046 extended trace on a mapping [http://www.rittman.net/archives/001211.html], you might be interested in

If you've read my OTN article"Building BI Dashboards with Oracle Database 10g, Oracle Discoverer, and Oracle Portal" [http://www.oracle.com/technology/pub/articles/rittman_dash.html] and were looking to set a BI dashboard up, you might be wondering how to set up OracleBI

Jon Garmany has written a nice article onintegrating HTML DB with Oracle Application Server 10g [http://www.dba-oracle.com/oracle9iAS_tips_Garmany_integrating_html_db_10gas.htm] . According to John, > "Lately I have been playing around with Oracle's HTML DB. This is a rapid development environment

A paper that caught my eye at the recentOTDUG Desktop Conference [http://www.desktopconference2005.org/] was the one by Kent Graziano onAgile Methods and Data Warehousing [http://www.desktopconference2005.org/03-agenda/28.html]. You have to be a conference attendee to view the presentations, but I got hold of Kent&

Investigation of collecting Cost Base Optimizer statistics [http://www.oaktable.net/fullArticle.jsp;jsessionid=C931210E5DD6CBF1C14898D160C7BF82?id=12] : "This article looks at some of the questions and challenges you need to consider when you are planning statistics collection for Oracle's Cost Based Optimizer (CBO). Many businesses require 24