Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h8THbID01523 for ; Mon, 29 Sep 2003 12:37:18 -0500 X-ClientAddr: 66.27.56.212 Received: from www3.fatcity.com (rrcs-west-66-27-56-212.biz.rr.com [66.27.56.212]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h8THbBc01500 for ; Mon, 29 Sep 2003 12:37:13 -0500 Received: (from root@localhost) by www3.fatcity.com (8.11.6/8.11.6) id h8TEul115292 for oracle-l@orafaq.net; Mon, 29 Sep 2003 07:56:47 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D15FE; Mon, 29 Sep 2003 07:55:18 -0800 Message-ID: Date: Mon, 29 Sep 2003 07:55:18 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Scott Canaan" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Scott Canaan" Subject: RE: Using dimensions Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C38699.8065A618" ------_=_NextPart_001_01C38699.8065A618 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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. =20 Scott Canaan (srcdco@rit.edu) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. =20 -----Original Message----- Sent: Monday, September 29, 2003 10:55 AM To: Multiple recipients of list ORACLE-L =20 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?=20 TIA=20 Raj=20 ------------------------------------------------------------------------ --------=20 Rajendra dot Jamadagni at nospamespn dot com=20 All Views expressed in this email are strictly personal.=20 QOTD: Any clod can have facts, having an opinion is an art !=20 ------_=_NextPart_001_01C38699.8065A618 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 = (srcdco@rit.edu)

(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:Rajendra.Jamadagni@espn.com]
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 ! =

=00 ------_=_NextPart_001_01C38699.8065A618-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan INET: srcdco@rit.edu Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).