A Wetpaint Site

Sign in to Wetpaint

Sign in or

Determine OLAP Cube Dimensions Information (11.1.0)

Page Versions
To-Dos

Key: additions deletions

Showing 6 pages

	Date/Time	Made By	Edit Note	Type	Scope
	Oct 26 2009, 10:55 AM EDT	olapdba		edit	9 words added 18 words deleted
Change: owner for a15colaw_nm aw_name for a12 hea AWcol dimension_name for a12 hea DIMENSION col dimensions_type for a6 hea TYPE bre on owner on aw_name skip 1select owner,owner\|\|'.'\|\|aw_name aw_name,aw_nm, dimension_name , decode(dimension_type,'STANDARD','STD',dimension_type) dimensions_type , default_hierarchy_name from all_cube_dimensions order by 1,2,3;OWNER ......... AW ......... DIMENSION View changes from previous version. (Word count: 81)
	Feb 13 2008, 11:19 AM EST	olapdba		edit	4 words added 2 words deleted
Change: dimension_name,dimension_name , decode(dimension_type,'STANDARD','STD',dimension_type) dimensions_type,dimensions_type , default_hierarchy_name from all_cube_dimensions order by 1,2,3;OWNER ......... AW ......... DIMENSION .. TYPE . DEFAULT_HIERARCHY_NAME--------------- ------------ ------------ ------ ------------------------------DM ............ SALES ...... CHANNEL .... STD .. SALES_CHANNEL............................ CUSTOMER ... STD .. REGIONAL............................ PRODUCT .... STD .. STANDARD............................ TIME View changes from previous version. (Word count: 85)
	Jan 9 2008, 12:53 PM EST	olapdba		edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 85)
	Jan 9 2008, 12:52 PM EST	olapdba		edit	17 words added
Change: decode(dimension_type,'STANDARD','STD',dimension_type) dimensions_type, default_hierarchy_name from all_cube_dimensions order by 1,2,3; OWNER ......... AW ......... DIMENSION .. TYPE . DEFAULT_HIERARCHY_NAME--------------- ------------ ------------ ------ ------------------------------DM ............ SALES ...... CHANNEL .... STD .. SALES_CHANNEL ............................ CUSTOMER ... STD .. REGIONAL ............................ PRODUCT .... STD .. STANDARD ............................ TIME ....... TIME . CALENDAR View changes from previous version. (Word count: 85)
	Jan 9 2008, 12:49 PM EST	olapdba		edit	84 words added
Change: To determine Cube and AW information in Oracle Database 11g consider using this script. set lines 110 pages 1000 col owner for a15col aw_name for a12 hea AWcol dimension_name for a12 hea DIMENSION col dimensions_type for a6 hea TYPE bre on owner on aw_name skip 1 select View changes from previous version. (Word count: 85)
	Jan 9 2008, 12:46 PM EST	olapdba		create	No content added or deleted.
Change: Created by olapdba Jan 9 2008, 12:46 PM EST for: no reason given

JavaScript must be enabled in order for you to contribute to this site.
To start contributing, enable JavaScript by changing your browser options, then try again.

Home