public class MondrianHelper extends Object
Mondrian Helper class
...Constructor and Description |
---|
MondrianHelper(org.pentaho.di.core.database.DatabaseMeta databaseMeta,
String catalog,
String queryString,
org.pentaho.di.core.variables.VariableSpace space) |
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.
|
org.pentaho.di.core.row.RowMetaInterface |
getCachedRowMeta() |
String |
getCatalog() |
org.pentaho.di.core.database.DatabaseMeta |
getDatabaseMeta() |
List<String> |
getHeadings() |
org.pentaho.di.core.row.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(org.pentaho.di.core.database.DatabaseMeta databaseMeta) |
void |
setQueryString(String queryString) |
void |
setRole(String role) |
public void openQuery() throws org.pentaho.di.core.exception.KettleDatabaseException
org.pentaho.di.core.exception.KettleDatabaseException
public void close()
public void createRectangularOutput() throws org.pentaho.di.core.exception.KettleDatabaseException
org.pentaho.di.core.exception.KettleDatabaseException
- in case some or other error occurspublic void createFlattenedOutput() throws org.pentaho.di.core.exception.KettleDatabaseException
org.pentaho.di.core.exception.KettleDatabaseException
- in case something goes wrong
TODO: this is not quite working for our purposes.public org.pentaho.di.core.row.RowMetaInterface getCachedRowMeta()
public org.pentaho.di.core.database.DatabaseMeta getDatabaseMeta()
public void setDatabaseMeta(org.pentaho.di.core.database.DatabaseMeta databaseMeta)
databaseMeta
- the databaseMeta to setpublic String getCatalog()
public void setCatalog(String catalog)
catalog
- the catalog to setpublic String getQueryString()
public void setQueryString(String queryString)
queryString
- the queryString to setpublic org.pentaho.di.core.row.RowMetaInterface getOutputRowMeta()
public mondrian.olap.Result getResult()
public mondrian.olap.Query getQuery()
public String getRole()
public void setRole(String role)