Package mondrian.rolap.aggmatcher

Class AggGen

java.lang.Object

mondrian.rolap.aggmatcher.AggGen

public class AggGen
extends Object

This class is used to create "lost" and "collapsed" aggregate table creation sql (creates the rdbms table and inserts into it from the base fact table).

Author:

Richard M. Emberson

Constructor Summary

Constructors

Constructor	Description
AggGen(String cubeName, RolapStar star, RolapStar.Column[] columns)

Method Summary

Modifier and Type	Method	Description
protected void	addForeignKeyToNotLostColumnUsages(JdbcSchema.Table.Column column)
String	createCollapsed()	Return a String containing the sql code to create a collapsed dimension table.
String	createLost()	Return a String containing the sql code to create a lost dimension table.
protected JdbcSchema.Table.Column	getColumn(JdbcSchema.Table table, String name)
protected String	getFactCount()
protected RolapStar.Table	getFactTable()
protected String	getFactTableName()
protected String	getRolapStarColumnName(RolapStar.Column rColumn)
protected SqlQuery	getSqlQuery()
protected JdbcSchema.Table	getTable(JdbcSchema db, String name)
protected JdbcSchema.Table	getTable(JdbcSchema db, RolapStar.Table rt)
String	insertIntoCollapsed()	Return the sql code to populate a collapsed dimension table from the fact table.
String	insertIntoLost()	Return the sql code to populate a lost dimension table from the fact table.
boolean	isReady()	Return true if this instance is ready to generate the sql.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

AggGen

public AggGen(String cubeName,
 RolapStar star,
 RolapStar.Column[] columns)

Method Details

isReady

public boolean isReady()

Return true if this instance is ready to generate the sql. If false, then something went wrong as it was trying to understand the columns.

getFactTable

protected RolapStar.Table getFactTable()

getFactTableName

protected String getFactTableName()

getSqlQuery

protected SqlQuery getSqlQuery()

getFactCount

protected String getFactCount()

getTable

protected JdbcSchema.Table getTable(JdbcSchema db,
 RolapStar.Table rt)

getTable

protected JdbcSchema.Table getTable(JdbcSchema db,
 String name)

getColumn

protected JdbcSchema.Table.Column getColumn(JdbcSchema.Table table,
 String name)

getRolapStarColumnName

protected String getRolapStarColumnName(RolapStar.Column rColumn)

addForeignKeyToNotLostColumnUsages

protected void addForeignKeyToNotLostColumnUsages(JdbcSchema.Table.Column column)

createLost

public String createLost()

Return a String containing the sql code to create a lost dimension table.

Returns:

lost dimension sql code

insertIntoLost

public String insertIntoLost()

Return the sql code to populate a lost dimension table from the fact table.

createCollapsed

public String createCollapsed()

Return a String containing the sql code to create a collapsed dimension table.

Returns:

collapsed dimension sql code

insertIntoCollapsed

public String insertIntoCollapsed()

Return the sql code to populate a collapsed dimension table from the fact table.