org.pentaho.di.trans.steps.mondrianinput
Class MondrianHelper

java.lang.Object
  org.pentaho.di.trans.steps.mondrianinput.MondrianHelper

public class MondrianHelper
extends Object

Mondrian Helper class ...

Since:

Mar 12, 2007

Author:

jhyde

Constructor Summary

MondrianHelper(DatabaseMeta databaseMeta, String catalog, String queryString, VariableSpace space)

Method Summary

void	close()
void	createFlattenedOutput() Retrieve the rows from the opened query.
void	createRectangularOutput() Outputs one row per tuple on the rows axis.
RowMetaInterface	getCachedRowMeta()
String	getCatalog()
DatabaseMeta	getDatabaseMeta()
List<String>	getHeadings()
RowMetaInterface	getOutputRowMeta()
mondrian.olap.Query	getQuery()
String	getQueryString()
mondrian.olap.Result	getResult()
List<List<Object>>	getRows()
void	openQuery()
void	setCatalog(String catalog)
void	setDatabaseMeta(DatabaseMeta databaseMeta)
void	setQueryString(String queryString)

Methods inherited from class java.lang.Object

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

Constructor Detail

MondrianHelper

public MondrianHelper(DatabaseMeta databaseMeta,
                      String catalog,
                      String queryString,
                      VariableSpace space)

Method Detail

openQuery

public void openQuery()
               throws KettleDatabaseException

Throws:

KettleDatabaseException

close

public void close()

createRectangularOutput

public void createRectangularOutput()
                             throws KettleDatabaseException

Outputs one row per tuple on the rows axis.

Throws:

KettleDatabaseException - in case some or other error occurs

createFlattenedOutput

public void createFlattenedOutput()
                           throws KettleDatabaseException

Retrieve the rows from the opened query. Also create a description of the flattened output of the query. This call populated rowMetaInterface and rows The query needs to be opened beforehand.

Throws:

KettleDatabaseException - in case something goes wrong TODO: this is not quite working for our purposes.

getCachedRowMeta

public RowMetaInterface getCachedRowMeta()

getDatabaseMeta

public DatabaseMeta getDatabaseMeta()

Returns:

the databaseMeta

setDatabaseMeta

public void setDatabaseMeta(DatabaseMeta databaseMeta)

Parameters:

databaseMeta - the databaseMeta to set

getCatalog

public String getCatalog()

Returns:

the catalog

setCatalog

public void setCatalog(String catalog)

Parameters:

catalog - the catalog to set

getQueryString

public String getQueryString()

Returns:

the queryString

setQueryString

public void setQueryString(String queryString)

Parameters:

queryString - the queryString to set

getOutputRowMeta

public RowMetaInterface getOutputRowMeta()

Returns:

the outputRowMeta

getResult

public mondrian.olap.Result getResult()

Returns:

the result

getQuery

public mondrian.olap.Query getQuery()

Returns:

the query

getRows

public List<List<Object>> getRows()

Returns:

the rows

getHeadings

public List<String> getHeadings()

Returns:

the headings