A Wetpaint Site

Sign in to Wetpaint

Sign in or

Determine Cube Derived Measures Information (11.1.0)

Page Versions

Key: additions deletions

Showing 8 pages

	Date/Time	Made By	Edit Note	Type	Scope
	Mar 12 2008, 10:08 AM EDT	olapdba		edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 192)
	Jan 9 2008, 1:47 PM EST	olapdba		edit	1 word added
Change: OVER HIERARCHY (DM.TIME.CALENDAR BY ANCESTOR ................................................... AT LEVEL DM.TIME.YEAR POSITION FROM BEGINNING)DM.SALES_CUBE .. QUANTITY_PR_YEAR_PCT_CHG ..... LAG_VARIANCE_PERCENT(DM.SALES_CUBE.QUANTITY, 1) ..................................................OVER HIERARCHY (DM.TIME.CALENDAR BY ANCESTOR ................................................... AT LEVEL DM.TIME.YEAR POSITION FROM BEGINNING)DM.SALES_CUBE .. QUANTITY_RANK_BY_PRODUCT ..... RANK() OVER HIERARCHY (DM.PRODUCT.STANDARD ..................................................ORDER BY DM.SALES_CUBE.QUANTITY DESC NULLS LAST ................................................. WITHIN PARENT)... View changes from previous version. (Word count: 192)
	Jan 9 2008, 1:46 PM EST	olapdba		edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 192)
	Jan 9 2008, 1:45 PM EST	olapdba		edit	2 words added
Change: ........... MEASURE ...................... EXPRESSION---------------- ------------------------------ ---------------------------------------------------..DM.SALES_CUBE .. QUANTITY_3_MONTH_MOVING_AVG .. AVG(DM.SALES_CUBE.QUANTITY) ................................................. OVER HIERARCHY (DM.TIME.CALENDAR BETWEEN 2 ................................................... PRECEDING AND CURRENT MEMBER WITHIN LEVEL)DM.SALES_CUBE .. QUANTITY_3_MONTH_MOVING_MAX .. MAX(DM.SALES_CUBE.QUANTITY) ................................................. OVER HIERARCHY (DM.TIME.CALENDAR BETWEEN 2 ................................................... PRECEDING AND CURRENT MEMBER WITHIN LEVEL)DM.SALES_CUBE .. QUANTITY_PR_PERIOD ........... LAG(DM.SALES_CUBE.QUANTITY, 1) View changes from previous version. (Word count: 192)
	Jan 9 2008, 1:44 PM EST	olapdba		edit	6 words added
Change: .. MAX(DM.SALES_CUBE.QUANTITY) ................................................. OVER HIERARCHY (DM.TIME.CALENDAR BETWEEN 2 ................................................... PRECEDING AND CURRENT MEMBER WITHIN LEVEL)DM.SALES_CUBE .. QUANTITY_PR_PERIOD ........... LAG(DM.SALES_CUBE.QUANTITY, 1) ..................................................OVER HIERARCHY (DM.TIME.CALENDAR)DM.SALES_CUBE .. QUANTITY_PR_PERIOD_PCT_CHG ... LAG_VARIANCE_PERCENT(DM.SALES_CUBE.QUANTITY, 1) ..................................................OVER HIERARCHY (DM.TIME.CALENDAR)DM.SALES_CUBE .. QUANTITY_PR_YEAR ............. LAG(DM.SALES_CUBE.QUANTITY, 1) ..................................................OVER HIERARCHY (DM.TIME.CALENDAR BY ANCESTOR ................................................... AT View changes from previous version. (Word count: 192)
	Jan 9 2008, 1:43 PM EST	olapdba		edit	7 words added
Change: .. AVG(DM.SALES_CUBE.QUANTITY) ................................................. OVER HIERARCHY (DM.TIME.CALENDAR BETWEEN 2 ................................................... PRECEDING AND CURRENT MEMBER WITHIN LEVEL)DM.SALES_CUBE .. QUANTITY_3_MONTH_MOVING_MAX MAX(DM.SALES_CUBE.QUANTITY) ................................................. OVER HIERARCHY (DM.TIME.CALENDAR BETWEEN 2 ................................................... PRECEDING AND CURRENT MEMBER WITHIN LEVEL)DM.SALES_CUBE .. QUANTITY_PR_PERIOD LAG(DM.SALES_CUBE.QUANTITY, 1) ..................................................OVER HIERARCHY (DM.TIME.CALENDAR)DM.SALES_CUBE .. QUANTITY_PR_PERIOD_PCT_CHG LAG_VARIANCE_PERCENT(DM.SALES_CUBE.QUANTITY, 1) ..................................................OVER HIERARCHY (DM.TIME.CALENDAR) View changes from previous version. (Word count: 192)
	Jan 9 2008, 1:40 PM EST	olapdba		edit	159 words added
Change: To determine derived cube measures in Oracle Database 11g consider using this script. set lines 110 pages 1000 col cb for a16 hea CUBEcol measure_name for a30 hea MEASURE col expression for a51 wrap bre on owner on cube_name select owner\|\|'.'\|\|cube_name cb, measure_name, to_char(expression) expression from all_cube_measures View changes from previous version. (Word count: 192)
	Jan 9 2008, 1:30 PM EST	olapdba		create	No content added or deleted.
Change: Created by olapdba Jan 9 2008, 1:30 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