Re: Using dimensions

[Tanel Poder]

Title: Using dimensions

Query rewriting to use materialized views requires dimensions to be defined.   Tanel.   ----- Original Message ----- From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, September 29, 2003 7:14 PM Subject: RE: Using dimensions Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses of dimensions ... where does one use them? in SQLs?   I have scanned TFM, but haven't STFW'd yet ... scared of too many hits.   Thanks Raj -------------------------------------------------------------------------------- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -----Original Message----- From: Scott Canaan [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Subject: RE: Using dimensions Dimensions are data warehouse constructs.  They are implemented as tables in the database, but have the characteristic of a hierarchy that can be traversed.  For example:  a time dimension can have the hierarchy of date, day, week, month, quarter, year, decade, century.  This is used for rollup reporting within the data mart.  I don't see any good use of it in an OLTP environment, but I may be wrong.   Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.   -----Original Message----- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 10:55 AM To: Multiple recipients of list ORACLE-L Subject: Using dimensions   I have tried, but haven't found a good example of how to _use_ a dimension in 9ir2. I defined one, but then sat clueless on what to do with it. Is it any good in an OLTP environment? (I smell the answer is a NO, but still) ... Any notes from your experience? TIA Raj -------------------------------------------------------------------------------- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !