Tutorial/Schema cheatsheet - Revision history

Tvi: 76 revisions imported

2021-12-10T10:55:46Z

76 revisions imported

← Older revision	Revision as of 12:55, 10 December 2021
(No difference)

2014-02-28T07:52:00Z

Defining dimensions for inline values

← Older revision		Revision as of 09:52, 28 February 2014
Line 255:		Line 255:
	=== Enumeration values ===		=== Enumeration values ===

			'''Cube schema'''

			...
	<Dimension name="Severity">		<Dimension name="Severity">
	<Hierarchy hasAll="true" primaryKey="SEVERITY">		<Hierarchy hasAll="true" primaryKey="SEVERITY">
Line 278:		Line 280:
	</Hierarchy>		</Hierarchy>
	</Dimension>		</Dimension>
			...

	== Defining measures ==		== Defining measures ==

2014-02-28T07:51:00Z

Defining dimensions for inline values

@@ Line 205: / Line 205: @@
 == Defining dimensions for inline values ==
 === Year/integer values ===
@@ Line 242: / Line 254: @@
 === Enumeration values ===
 == Defining measures ==

2014-02-28T07:40:27Z

Introduction

← Older revision		Revision as of 09:40, 28 February 2014
Line 5:		Line 5:

	Precise documentation on how to define a schema, can be found at:		Precise documentation on how to define a schema, can be found at:
	[http://mondrian.pentaho.com/documentation/schema.php~~\|http://mondrian.pentaho.com/documentation/schema.php]~~		http://mondrian.pentaho.com/documentation/schema.php

	== Schema structure overview ==		== Schema structure overview ==

2014-02-28T07:39:30Z

Simple year/number values

← Older revision		Revision as of 09:39, 28 February 2014
Line 206:		Line 206:
	== Defining dimensions for inline values ==		== Defining dimensions for inline values ==

	=== ~~Simple year~~/~~number~~ values ===		=== Year/integer values ===


			'''Cube schema'''
	...		...
	<Dimension name="Period" type="TimeDimension">		<Dimension name="Period" type="TimeDimension">

2014-02-28T07:38:42Z

Simple year/number values

← Older revision		Revision as of 09:38, 28 February 2014
Line 209:		Line 209:


			...
	<Dimension name="Period" type="TimeDimension">		<Dimension name="Period" type="TimeDimension">
	<Hierarchy hasAll="true">		<Hierarchy hasAll="true">
	<Level name="Aar" column="YEAR" type="Numeric" uniqueMembers="false" levelType="TimeYears"/>		<Level name="Aar" column="YEAR" type="Numeric" uniqueMembers="false" levelType="TimeYears"/>
	</Hierarchy>		</Hierarchy>
	</Dimension>		</Dimension>
			...

	=== Date / datetime values ===		=== Date / datetime values ===

2014-02-28T07:37:57Z

Simple text/number values

← Older revision		Revision as of 09:37, 28 February 2014
Line 206:		Line 206:
	== Defining dimensions for inline values ==		== Defining dimensions for inline values ==

	=== Simple ~~text~~/number values ===		=== Simple year/number values ===



			<Dimension name="Period" type="TimeDimension">
			<Hierarchy hasAll="true">
			<Level name="Aar" column="YEAR" type="Numeric" uniqueMembers="false" levelType="TimeYears"/>
			</Hierarchy>
			</Dimension>

	=== Date / datetime values ===		=== Date / datetime values ===

2014-02-28T07:36:07Z

Date/period values

@@ Line 208: / Line 208: @@
 === Simple text/number values ===
-=== Date/period values ===
+=== Date / datetime values ===
 === Enumeration values ===

2014-02-28T07:32:40Z

Introduction

← Older revision		Revision as of 09:32, 28 February 2014
Line 5:		Line 5:

	Precise documentation on how to define a schema, can be found at:		Precise documentation on how to define a schema, can be found at:
	[[http://mondrian.pentaho.com/documentation/schema.php\|http://mondrian.pentaho.com/documentation/schema.php]]		[http://mondrian.pentaho.com/documentation/schema.php\|http://mondrian.pentaho.com/documentation/schema.php]

	== Schema structure overview ==		== Schema structure overview ==

2014-02-28T07:32:26Z

Introduction

← Older revision		Revision as of 09:32, 28 February 2014
Line 5:		Line 5:

	Precise documentation on how to define a schema, can be found at:		Precise documentation on how to define a schema, can be found at:
	[http://mondrian.pentaho.com/documentation/schema.php\|http://mondrian.pentaho.com/documentation/schema.php]		[[http://mondrian.pentaho.com/documentation/schema.php\|http://mondrian.pentaho.com/documentation/schema.php]]

	== Schema structure overview ==		== Schema structure overview ==