Tutorial/OLAP example - Revision history

Tvi: 20 revisions imported

2021-12-10T10:55:42Z

20 revisions imported

← Older revision

Revision as of 12:55, 10 December 2021

old>Tvi: Syntax highlighting

2021-10-07T13:15:33Z

Syntax highlighting

← Older revision		Revision as of 15:15, 7 October 2021
Line 87:		Line 87:
	* http://technet.microsoft.com/en-us/library/ms145971.aspx		* http://technet.microsoft.com/en-us/library/ms145971.aspx

	~~select~~		<syntaxhighlight lang="mysql">
	NON EMPTY {([Measures].[Estimate],[Measures].[Realized])} ON COLUMNS,		SELECT
	NON EMPTY {([Period],[Type],[Status])} ON ROWS		NON EMPTY {([Measures].[Estimate],[Measures].[Realized])} ON COLUMNS,
	~~from~~ [sample1cube]		NON EMPTY {([Period],[Type],[Status])} ON ROWS
			FROM [sample1cube]
			</syntaxhighlight>

	== Results ==		== Results ==

old>Tvi: Added syntax-highlighting

2021-10-07T13:14:19Z

Added syntax-highlighting

← Older revision		Revision as of 15:14, 7 October 2021
Line 32:		Line 32:
	* http://mondrian.pentaho.com/documentation/schema.php		* http://mondrian.pentaho.com/documentation/schema.php

	<Cube name="sample1cube">		<syntaxhighlight lang="xml">
	<Table name="data_changemanagement"/>		<Cube name="sample1cube">
	<Dimension name="Scope" foreignKey="TASKTYPE">		<Table name="data_changemanagement"/>
	<Hierarchy hasAll="true" primaryKey="LookupID">		<Dimension name="Scope" foreignKey="TASKTYPE">
	<Table name="formfieldlookup"/>		<Hierarchy hasAll="true" primaryKey="LookupID">
	<Level name="Type" column="Value" uniqueMembers="true"/>		<Table name="formfieldlookup"/>
	</Hierarchy>		<Level name="Type" column="Value" uniqueMembers="true"/>
	</Dimension>		</Hierarchy>
	<Dimension name="Type" foreignKey="TYPE">		</Dimension>
	<Hierarchy hasAll="true" primaryKey="LookupID">		<Dimension name="Type" foreignKey="TYPE">
	<Table name="formfieldlookup"/>		<Hierarchy hasAll="true" primaryKey="LookupID">
	<Level name="Type" column="Value" uniqueMembers="true"/>		<Table name="formfieldlookup"/>
	</Hierarchy>		<Level name="Type" column="Value" uniqueMembers="true"/>
	</Dimension>		</Hierarchy>
	<Dimension name="Status" foreignKey="StatusID">		</Dimension>
	<Hierarchy hasAll="true" primaryKey="StatusID">		<Dimension name="Status" foreignKey="StatusID">
	<Table name="formstatus"/>		<Hierarchy hasAll="true" primaryKey="StatusID">
	<Level name="Type" column="Status" uniqueMembers="true"/>		<Table name="formstatus"/>
	</Hierarchy>		<Level name="Type" column="Status" uniqueMembers="true"/>
	</Dimension>		</Hierarchy>
	<Dimension name="Period" type="TimeDimension">		</Dimension>
	<Hierarchy name="Periode" hasAll="true" allMemberName="All period">		<Dimension name="Period" type="TimeDimension">
	<Table name="data_changemanagement"/>		<Hierarchy name="Periode" hasAll="true" allMemberName="All period">
	<Level name="Aar" levelType="TimeYears" uniqueMembers="true">		<Table name="data_changemanagement"/>
	<KeyExpression>		<Level name="Aar" levelType="TimeYears" uniqueMembers="true">
	<SQL dialect="mysql">Year(CreatedAt)</SQL>		<KeyExpression>
	<SQL dialect="generic">YEAR</SQL>		<SQL dialect="mysql">Year(CreatedAt)</SQL>
	</KeyExpression>		<SQL dialect="generic">YEAR</SQL>
	</Level>		</KeyExpression>
	<Level name="Kvartal" uniqueMembers="false" levelType="TimeQuarters">		</Level>
	<KeyExpression>		<Level name="Kvartal" uniqueMembers="false" levelType="TimeQuarters">
	<SQL dialect="mysql">Quarter(CreatedAt)</SQL>		<KeyExpression>
	<SQL dialect="generic">Quarter</SQL>		<SQL dialect="mysql">Quarter(CreatedAt)</SQL>
	</KeyExpression>		<SQL dialect="generic">Quarter</SQL>
	</Level>		</KeyExpression>
	<Level name="Maaned" uniqueMembers="false" levelType="TimeMonths">		</Level>
	<KeyExpression>		<Level name="Maaned" uniqueMembers="false" levelType="TimeMonths">
	<SQL dialect="mysql">Month(CreatedAt)</SQL>		<KeyExpression>
	<SQL dialect="generic">Month</SQL>		<SQL dialect="mysql">Month(CreatedAt)</SQL>
	</KeyExpression>		<SQL dialect="generic">Month</SQL>
	</Level>		</KeyExpression>
	</Hierarchy>		</Level>
	</Dimension>		</Hierarchy>
	<Measure name="Revision" column="Revision" aggregator="sum" formatString="Standard"/>		</Dimension>
	<Measure name="Estimate" column="ESTIMATTIMER" aggregator="sum" formatString="Standard"/>		<Measure name="Revision" column="Revision" aggregator="sum" formatString="Standard"/>
	<Measure name="Realized" column="REALISERETTIMER" aggregator="sum" formatString="Standard"/>		<Measure name="Estimate" column="ESTIMATTIMER" aggregator="sum" formatString="Standard"/>
	</Cube>		<Measure name="Realized" column="REALISERETTIMER" aggregator="sum" formatString="Standard"/>
			</Cube>
			</syntaxhighlight>

	=== MDX query ("Cube Query MDX") ===		=== MDX query ("Cube Query MDX") ===

old>Admin: /* Basic information */

2013-11-28T07:57:42Z

Basic information

← Older revision		Revision as of 09:57, 28 November 2013
Line 24:		Line 24:
	=== Basic information ===		=== Basic information ===

	* Name / display: sample1		* Name display: sample1
	* Cube header: Report sample1		* Cube header: Report sample1

old>Admin: /* MDX query ("Cube Query MDX") */

2013-11-28T06:36:27Z

MDX query ("Cube Query MDX")

← Older revision		Revision as of 08:36, 28 November 2013
Line 81:		Line 81:

	=== MDX query ("Cube Query MDX") ===		=== MDX query ("Cube Query MDX") ===

			For further help to designing queries please refer to the following ressources
			* http://technet.microsoft.com/en-us/library/ms145971.aspx

	select		select
Line 86:		Line 89:
	NON EMPTY {([Period],[Type],[Status])} ON ROWS		NON EMPTY {([Period],[Type],[Status])} ON ROWS
	from [sample1cube]		from [sample1cube]


	== Results ==		== Results ==

old>Admin: /* Cube definition ("Cube Schema XML") */

2013-11-28T06:35:01Z

Cube definition ("Cube Schema XML")

← Older revision		Revision as of 08:35, 28 November 2013
Line 28:		Line 28:

	=== Cube definition ("Cube Schema XML") ===		=== Cube definition ("Cube Schema XML") ===

			For further help to designing schemas please refer to the following ressources
			* http://mondrian.pentaho.com/documentation/schema.php

	<Cube name="sample1cube">		<Cube name="sample1cube">

old>Admin: /* Results */

2013-11-28T05:54:51Z

Results

← Older revision		Revision as of 07:54, 28 November 2013
Line 91:		Line 91:


	[[File:Sample_olap.PNG][		[[File:Sample_olap.PNG]]

	[[~~File:~~File:Sample_olap_expanded.PNG]]		[[File:Sample_olap_expanded.PNG]]

old>Admin: /* Results */

2013-11-28T05:54:31Z

Results

← Older revision		Revision as of 07:54, 28 November 2013
Line 91:		Line 91:


	[File:Sample_olap.PNG]		[[File:Sample_olap.PNG][

	[File:File:Sample_olap_expanded.PNG]		[[File:File:Sample_olap_expanded.PNG]]

old>Admin: /* Results */

2013-11-28T05:54:12Z

Results

← Older revision		Revision as of 07:54, 28 November 2013
Line 91:		Line 91:


	[File:~~olap_sample~~.PNG]		[File:Sample_olap.PNG]

			[File:File:Sample_olap_expanded.PNG]

old>Admin at 05:49, 28 November 2013

2013-11-28T05:49:27Z

← Older revision		Revision as of 07:49, 28 November 2013
Line 83:		Line 83:
	NON EMPTY {([Period],[Type],[Status])} ON ROWS		NON EMPTY {([Period],[Type],[Status])} ON ROWS
	from [sample1cube]		from [sample1cube]


			== Results ==

			The cube is acccesed via this URL (or press "test" form the OLAP overview)
			http://YOUR_DOMAIN/TempusServa/olapview.jsp?query=sample1


			[File:olap_sample.PNG]