net.datenwerke.rs.saiku.service.saiku

Interface ThinQueryService

All Superinterfaces:

java.io.Serializable

All Known Implementing Classes:

ThinQueryServiceImpl

public interface ThinQueryService
extends java.io.Serializable

Method Summary

Modifier and Type	Method and Description
void	calculateTotals(ThinQuery tq, Cube cub, CellDataSet result, CellSet cellSet, ICellSetFormatter formatter)
void	cancel(java.lang.String queryName)
ThinQuery	convertQuery(java.lang.String xml, Cube cube, SaikuReport report)
ThinQuery	createQuery(ThinQuery tq, Cube cube)
ThinQuery	drillacross(java.lang.String queryName, Cube cub, SaikuReport report, java.util.List<java.lang.Integer> cellPosition, java.util.Map<java.lang.String,java.util.List<java.lang.String>> levels)
java.sql.ResultSet	drillthrough(java.lang.String queryName, SaikuReport report, int maxrows, java.lang.String returns)
java.sql.ResultSet	drillthrough(java.lang.String queryName, SaikuReport report, java.util.List<java.lang.Integer> cellPosition, java.lang.Integer maxrows, java.lang.String returns)
java.sql.ResultSet	drillthrough(ThinQuery tq, SaikuReport report)
CellDataSet	execute(java.lang.String username, ThinQuery tq, SaikuReport report, Cube cube)
CellDataSet	execute(java.lang.String username, ThinQuery tq, SaikuReport report, Cube cube, java.lang.String formatter)
CellSet	executeInternalQuery(java.lang.String username, ThinQuery query, SaikuReport report, Cube cube)
CellSet	executeInternalQuery(User user, ParameterSet parameterSet, ThinQuery query, SaikuReport report, Cube cube)
byte[]	exportResultSetCsv(java.sql.ResultSet rs)
byte[]	exportResultSetCsv(java.sql.ResultSet rs, java.lang.String delimiter, java.lang.String enclosing, boolean printHeader, java.util.List<<any>> additionalColumns)
QueryContext	getContext(java.lang.String name)
byte[]	getExport(java.lang.String queryName, Cube cube, java.lang.String type)
byte[]	getExport(java.lang.String queryName, Cube cube, java.lang.String type, java.lang.String formatter)
CellDataSet	getFormattedResult(java.lang.String query, Cube cube, java.lang.String format)
java.util.List<SimpleCubeElement>	getResultMetadataMembers(java.lang.String queryName, Cube cube, boolean preferResult, java.lang.String hierarchyName, java.lang.String levelName, java.lang.String searchString, int searchLimit)
boolean	isMdxDrillthrough(ThinQuery query, SaikuReport report)
boolean	isOldQuery(java.lang.String filecontent)
java.lang.String	toJSONString(ThinQuery query)
ThinQuery	updateQuery(ThinQuery old, Cube cube, SaikuReport report)
ThinQuery	zoomIn(java.lang.String queryName, Cube cub, SaikuReport report, java.util.List<java.util.List<java.lang.Integer>> realPositions)

Method Detail

isOldQuery

boolean isOldQuery(java.lang.String filecontent)

convertQuery

ThinQuery convertQuery(java.lang.String xml,
                       Cube cube,
                       SaikuReport report)

createQuery

ThinQuery createQuery(ThinQuery tq,
                      Cube cube)

isMdxDrillthrough

boolean isMdxDrillthrough(ThinQuery query,
                          SaikuReport report)

drillthrough

java.sql.ResultSet drillthrough(ThinQuery tq,
                                SaikuReport report)

execute

CellDataSet execute(java.lang.String username,
                    ThinQuery tq,
                    SaikuReport report,
                    Cube cube)

getContext

QueryContext getContext(java.lang.String name)

cancel

void cancel(java.lang.String queryName)
     throws java.sql.SQLException

Throws:

java.sql.SQLException

updateQuery

ThinQuery updateQuery(ThinQuery old,
                      Cube cube,
                      SaikuReport report)

getResultMetadataMembers

java.util.List<SimpleCubeElement> getResultMetadataMembers(java.lang.String queryName,
                                                           Cube cube,
                                                           boolean preferResult,
                                                           java.lang.String hierarchyName,
                                                           java.lang.String levelName,
                                                           java.lang.String searchString,
                                                           int searchLimit)

getExport

byte[] getExport(java.lang.String queryName,
                 Cube cube,
                 java.lang.String type)

getExport

byte[] getExport(java.lang.String queryName,
                 Cube cube,
                 java.lang.String type,
                 java.lang.String formatter)

zoomIn

ThinQuery zoomIn(java.lang.String queryName,
                 Cube cub,
                 SaikuReport report,
                 java.util.List<java.util.List<java.lang.Integer>> realPositions)

drillthrough

java.sql.ResultSet drillthrough(java.lang.String queryName,
                                SaikuReport report,
                                int maxrows,
                                java.lang.String returns)

drillthrough

java.sql.ResultSet drillthrough(java.lang.String queryName,
                                SaikuReport report,
                                java.util.List<java.lang.Integer> cellPosition,
                                java.lang.Integer maxrows,
                                java.lang.String returns)

exportResultSetCsv

byte[] exportResultSetCsv(java.sql.ResultSet rs)

exportResultSetCsv

byte[] exportResultSetCsv(java.sql.ResultSet rs,
                          java.lang.String delimiter,
                          java.lang.String enclosing,
                          boolean printHeader,
                          java.util.List<<any>> additionalColumns)

getFormattedResult

CellDataSet getFormattedResult(java.lang.String query,
                               Cube cube,
                               java.lang.String format)
                        throws java.lang.Exception

Throws:

java.lang.Exception

execute

CellDataSet execute(java.lang.String username,
                    ThinQuery tq,
                    SaikuReport report,
                    Cube cube,
                    java.lang.String formatter)

drillacross

ThinQuery drillacross(java.lang.String queryName,
                      Cube cub,
                      SaikuReport report,
                      java.util.List<java.lang.Integer> cellPosition,
                      java.util.Map<java.lang.String,java.util.List<java.lang.String>> levels)

toJSONString

java.lang.String toJSONString(ThinQuery query)

executeInternalQuery

CellSet executeInternalQuery(java.lang.String username,
                             ThinQuery query,
                             SaikuReport report,
                             Cube cube)
                      throws java.lang.Exception

Throws:

java.lang.Exception

executeInternalQuery

CellSet executeInternalQuery(User user,
                             ParameterSet parameterSet,
                             ThinQuery query,
                             SaikuReport report,
                             Cube cube)
                      throws java.lang.Exception

Throws:

java.lang.Exception

calculateTotals

void calculateTotals(ThinQuery tq,
                     Cube cub,
                     CellDataSet result,
                     CellSet cellSet,
                     ICellSetFormatter formatter)
              throws java.lang.Exception

Throws:

java.lang.Exception