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

Constructors

Constructor and Description
MondrianHelper(DatabaseMeta databaseMeta, String catalog, String queryString, VariableSpace space)

Method Summary

Modifier and Type	Method and Description
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()
String	getRole()
List<List<Object>>	getRows()
void	openQuery()
void	setCatalog(String catalog)
void	setDatabaseMeta(DatabaseMeta databaseMeta)
void	setQueryString(String queryString)
void	setRole(String role)

Methods inherited from class java.lang.Object

clone, equals, finalize, 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

getRole

public String getRole()

setRole

public void setRole(String role)