Determine All OLAP Catalogue Objects Visible to a Schema (10.2.0) - History Page

	Date/Time	Made By	Type	Scope
	Apr 17 2008, 4:01 PM EDT	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 489)
	Apr 17 2008, 3:59 PM EDT	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 489)
	Apr 17 2008, 3:59 PM EDT	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 489)
	Apr 17 2008, 3:58 PM EDT	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 489)
	Apr 17 2008, 3:58 PM EDT	olapdba	edit	10 words added
Change: Measure Folder or Catalogueset lines 110 pages500 echo off col aw format a60 heading "AWs"col catalog format a60 heading "Catalog"col cube format a60 heading "Cubes"col dimension format a60 heading "Dimensions"col measure format a60 heading "Measures"col cat format a7 heading "Catalog"col valid View changes from previous version. (Word count: 489)
	Jan 24 2008, 2:18 PM EST	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 478)
	Jan 15 2008, 10:11 AM EST	olapdba	edit	4 words added 2 words deleted
Change: specific schema objects.CWM1 = First Generation OLAP Relational Common Warehouse Metadata (OEM)CWM2 = Second Generation OLAP Relational or Multidimensional Common Warehouse MetadataAWMD = Active OLAP Catalogue Metadata for Analytic Workspacesset lines 110 pages500 echo offcol aw format a60 heading "AWs"col catalog format View changes from previous version. (Word count: 478)
	Jan 15 2008, 10:10 AM EST	olapdba	edit	1 word added 4 words deleted
Change: and GLOBAL schemas.schema.CWM1 = First Generation OLAP Relational Common Warehouse Metadata (OEM)CWM2 = Second Generation OLAP Relational or Multidimensional Common Warehouse MetadataAWMD = Active OLAP Catalogue Metadata for Analytic Workspacesset lines 110 pages500 echo offcol aw format a60 heading "AWs"col catalog View changes from previous version. (Word count: 475)
	Jan 15 2008, 10:08 AM EST	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 478)
	Jan 15 2008, 10:07 AM EST	olapdba	edit	65 words added 65 words deleted
Change: select aw_owner\|\|'.AW$'\|\|aw_name AW from ALL$OLAP2_AW_CUBES group by aw_owner,aw_name;Catalog......................................................Catalog------------------------------------------------------------ -------SH.SH_CAT....................................................CWM1Cubes......................................,,,,,,,,,,,,,,,,,,Catalog Valid------------------------------------------------------------ ------- -----SH.COST_CUBE.................................................CWM2....YESSH.SALES_CUBE................................................CWM2....YESSCOTT.STORE!SALES............................................AWMD....YESDimensions...................................................Catalog.Valid------------------------------------------------------------ ------- -----SH.CHANNELS_DIM..............................................CWM1....YESSH.CUSTOMERS_DIM View changes from previous version. (Word count: 478)
	Jan 15 2008, 10:06 AM EST	olapdba	edit	382 words added
Change: This is a script you can run as your user (i.e., SCOTT) to see what OLAP Catalogue Metadata you have access to. This example assumes Scott has read access to XADEMO, SH and GLOBAL schemas.CWM1 = First Generation OLAP Relational Common Warehouse Metadata (OEM)CWM2 = Second View changes from previous version. (Word count: 478)
	Jan 15 2008, 10:01 AM EST	olapdba	create	No content added or deleted.
Change: Created by olapdba Jan 15 2008, 10:01 AM EST for: no reason given