Package com.microstrategy.web.objects
Interface WebReportManipulation
- 
- All Superinterfaces:
- WebResultSetManipulation
 
 public interface WebReportManipulation extends WebResultSetManipulation The report manipulation interface allows the user to apply a set of manipulations to the associated report instance. This interface is obtained from, and connected to, aWebReportInstanceobject. In addition, this interface contains many methods relating to derived metric manipulations.- Since:
- MicroStrategy Web 7.3.1 or earlier
 
- 
- 
Method SummaryAll Methods Instance Methods Abstract Methods Deprecated Methods Modifier and Type Method Description WebReportInstanceaddDerivedMetric(java.lang.String formulae, int position)Adds a new derived metric to the report.WebReportInstanceaddDerivedMetric(java.lang.String formulae, int position, java.lang.String alias)Adds a new derived metric to the report.WebReportInstanceaddDerivedMetric(java.lang.String formulae, int position, java.lang.String alias, int aggFromBase, int stFromBase, java.lang.Boolean isTokenStream)Adds a new derived metric to the report.WebReportInstanceaddDerivedMetric(java.lang.String formulae, int position, java.lang.String alias, int aggFromBase, int stFromBase, java.lang.Boolean isTokenStream, boolean isPassThrough)WebReportInstanceaddDerivedMetric(java.lang.String formulae, int position, java.lang.String alias, java.lang.Boolean aggFromBase)Adds a new derived metric to the report.WebReportInstanceaddDerivedMetric(java.lang.String formulae, int position, java.lang.String alias, java.lang.Boolean aggFromBase, boolean isPassThrough)WebReportInstanceaddPercentToTotalMetric(WebPercentToTotalMetric metric)Adds a percent to total metric to the Report.WebReportInstanceaddQuickCalculationGroup(java.lang.String deName, java.lang.String attId, int depth, int[] ordinals, int function)Deprecated.WebReportInstanceaddQuickCalculationGroup(java.lang.String deName, java.lang.String attId, int depth, int[] ordinals, int function, WebDerivedElements target)WebReportInstanceaddQuickListGroup(java.lang.String deName, java.lang.String attId, int depth, int[] ordinals)Deprecated.WebReportInstanceaddQuickListGroup(java.lang.String deName, java.lang.String attId, int depth, int[] ordinals, WebDerivedElements target)WebReportInstanceaddRankMetric(WebRankMetric metric)Adds a rank metric to the Report.WebReportInstanceaddShortcutMetric(int functionType, int functionType2, java.util.List<WebObjectInfo> unitsInfo)WebReportInstanceaddTransformationMetric(WebTransformationMetric metric)Adds a transformation metric to the Report.WebReportInstanceapplyChangeForReplaceObjects(java.util.List<org.apache.commons.lang3.tuple.Pair<WebObjectInfo,WebObjectInfo>> listOfWebObjectsToReplace, int clearAlias, int clearFormats, int clearFilter)Creates XML request either to remove or replace objects from different data source.WebReportInstanceapplyChanges()Sends all changes to the template and filter to the Intelligence Server.WebReportInstanceapplyChanges(java.lang.String deltaXML)Sends the given report manipulation XML to the Intelligence Server.WebReportInstanceapplyChanges(java.lang.String deltaXML, int requestTimeout)Sends the given report manipulation XML to the Intelligence Server.WebReportInstanceapplyChanges(java.lang.String deltaXML, int requestTimeout, StringWrapper resultXML)Sends the given report manipulation XML to the Intelligence Server.WebReportInstanceapplyStyleByID(java.lang.String id)Apply a style by style DSSID.WebReportInstanceapplyStyleByName(java.lang.String name)Apply a style by style name.WebReportInstancechangeDerivedMetric(int key, java.lang.String formula, java.lang.String alias)This changes the formula or alias of the derived metric.WebReportInstancechangeDerivedMetric(int key, java.lang.String formula, java.lang.String alias, int aggFromBase, int stFromBase, java.lang.Boolean isTokenStream)This changes the formula or alias of the derived metric.WebReportInstancechangeDerivedMetric(int key, java.lang.String formula, java.lang.String alias, int aggFromBase, int stFromBase, java.lang.Boolean isTokenStream, boolean isPassThrough)WebReportInstancechangeDerivedMetric(int key, java.lang.String formula, java.lang.String alias, java.lang.Boolean aggFromBase)This changes the formula or alias of the derived metric.WebReportInstancechangeDerivedMetric(int key, java.lang.String formula, java.lang.String alias, java.lang.Boolean aggFromBase, boolean isPassThrough)WebReportInstancechangeDerivedMetric(java.lang.String objectID, java.lang.String formula, java.lang.String alias, int aggFromBase, int stFromBase, java.lang.Boolean isTokenStream, boolean isPassThrough)This changes the formula or alias of the derived metric.WebReportInstancechangeDerivedMetricAggFromBase(java.lang.String formulae, int position, java.lang.String alias, java.lang.Boolean aggFromBase)This changes the formula or alias of the derived metric.WebReportInstancechangeDerivedMetricAggFromBase(java.lang.String formulae, int position, java.lang.String alias, java.lang.Boolean aggFromBase, java.lang.Boolean isTokenStream)This changes the formula or alias of the derived metric.WebReportInstancechangeEmmaSourceTablesExecutionAction(java.util.Map<java.lang.String,java.lang.Integer> tbs)Change EMMA source tables execution action flagsEnumDSSXMLTableStateExecutionActionaccording to the policy, suggest to pass all the source tables with its policy together.WebReportInstancechangeEmmaSourceTablesPolicy(java.util.Map<java.lang.String,java.lang.Integer> tbs)Change EMMA source tables policy, suggest to pass all the source tables with its policy togetherWebReportInstancechangeMapping(java.lang.String tableID, java.lang.String tableName, java.util.List<MappingOperation> mappings)change mappingWebReportInstanceclearDiscoverCache(java.lang.String tableId)clear discover cacheWebReportInstancecreatePickTable(java.lang.String tableID, java.lang.String xdaType, java.lang.String dict, java.lang.String tableName, java.lang.String dbTableName, java.lang.String nameSpace, java.lang.String dbrID)Create pick tableWebReportInstancecreatePushDataTables(java.util.List<java.lang.String> tableNames)create pushdatatablesWebReportInstancecreateSourceTable(java.lang.String tableId, java.lang.String tableName, java.lang.String xdaType, java.lang.String connectorType)create tableWebReportInstancecustomMappingForEmmaSourceTable(java.lang.String tableName, MappingCreator mappingCreator)custom mapping for EMMA source tableWebReportInstancecustomMappingForEmmaSourceTables(java.util.List<MappingCreator> mappingCreators)customMapping for EmmaSourceTablesWebReportInstancedrill(java.lang.String drillKey, java.lang.String[] drillElements, java.util.Map drillProperties)Drills on the current report instance using the drill path key and settings passed as arguments.WebReportInstanceeditEMMASourceTable(java.lang.String srcTableID, java.lang.String tableName, java.lang.String tableFormatLeft, java.lang.String tableFormatTop, java.lang.String tableFormatWidth, java.lang.String tableFormatHeight, java.lang.String executionFlag, java.lang.String isImportBinary, java.lang.String refreshType)edit editEMMASourceTableWebReportInstanceeditEMMASourceTables(JSONArray commands)edit editEMMASourceTables in batchWebReportInstanceeditFreeFormSQL(java.lang.String expdef, java.lang.String emmaSourceTableId)edit FreeFormSQLWebReportInstanceeditRelationship(java.lang.String tableName, java.util.List<MappingRelationship> relationships)edit relationshipWebReportInstancefilterOnSelections(java.lang.String[] drillElements, java.util.Map drillProperties)booleangetAcceptSQLManipulation()Returns the value of the acceptSQLManipulation flag.java.lang.StringgetDeltaXML()Returns the delta XML which would be sent to the Intelligence Server upon calling applyChanges().intgetExecutionFlags()Returns the current setting of execution flags.WebGraphPropertiesgetGraphProperties()Return aWebGraphPropertiesobject, which can be used to set the web graph properties.intgetManipulationType()Returns the manipulation type of a submission of changes to a report instance.WebPercentToTotalMetricgetNewPercentToTotalMetric(WebMetric metric)Returns a new instance of theWebPercentToTotalMetricobject.WebRankMetricgetNewRankMetric(WebMetric metric)Returns a new instance of theWebRankMetricobject.WebTransformationMetricgetNewTransformationMetric(WebMetric metric, WebObjectInfo transformationRole)Returns a new instance of theWebTransformationMetricobject.intgetPreviewRows()Returns the number of preview rows.WebPropertiesgetReportProperties()Return current setting for WebProperties.intgetResultFlags()Returns the result flags which will be sent upon calling applyChanges.WebResultWindowgetResultWindow()Returns the result window which can be used to set the result window to be passed to the Intelligence server upon calling applyChanges.intgetValidationLevel()Returns the validation level of a submission of changes to a report instance.booleanisInstanceModified()This method will return whether the submission of the changes to the report instance so far will cause a new report instance to be created.WebReportInstancemakeTabular()WebReportInstanceraExpandCollapse(java.lang.String attId, int axis, int ordinal, int depth, boolean expand)WebReportInstancerefresh(boolean rePrompt)refreshes the report results.WebReportInstancerefresh(java.lang.String promptAnswerXML)refreshes the report results.WebReportInstancerefreshEmmaCubeTablesWithExtParam(java.lang.String extParam)Refresh EMMA cube with extended parametersbooleanrequiresNewInstance()Determines whether the changes made to the filter and template of this report will cause a new report instance (and thus, a reexecution of SQL).WebReportInstanceresetChanges()Return a new WebReportInstanceWebReportInstancewhich is the same as this report instance, except that the returned report instsance does not have any manipulation having been done for this report instance.voidsetAcceptSQLManipulation(boolean acceptSQLManipulation)Sets the value of the acceptSQLManipulation flag.WebReportInstancesetCurrentPageByElement(java.lang.String elementID, int elementStatus, boolean applyChanges)WebReportInstancesetDataImportInfo(java.lang.String tbID, java.lang.String dbRoleID, java.lang.String sourceAccountID, java.lang.String url, java.lang.String userDisplayName, java.lang.String reportAddress, java.lang.String reportDesc, java.lang.String reportMimetype, java.lang.String reportName, java.lang.String shtIx, java.lang.String fileType, java.lang.String sparkURL)set DataImportInfovoidsetExecutionFlags(int executionFlags)Sets the execution flags property.voidsetPreviewRows(int previewRows)Sets the number of preview rows.voidsetResultFlags(int resultFlags)Allows the user to set the result flags which will be sent upon calling applyChanges.WebReportInstanceshowAllThresholds(boolean show)Show all thresholds for all metrics.WebReportInstanceshowAllThresholds(boolean show, WebMetric metric)Show all thresholds for a specific metric.WebReportInstancesyncModel(java.lang.String modelJSON, int serveMode)edit syncModelWebReportInstancesyncModel(java.lang.String modelJSON, int serveMode, java.util.List<TableAction> tableActions)edit syncModelWebReportInstancetoggleDatasetServerMode(int serverMode)Toggle dataset server modejava.lang.StringvalidateExpression(java.lang.String tokenStreamXML, boolean isForMetric, int outFlags, int baseFormType)- 
Methods inherited from interface com.microstrategy.web.objects.WebResultSetManipulationgetAcceptPartialResults, setAcceptPartialResults
 
- 
 
- 
- 
- 
Method Detail- 
getAcceptSQLManipulationboolean getAcceptSQLManipulation() Returns the value of the acceptSQLManipulation flag. This flag determines whether to allow the Intelligence Server to perform a SQL manipulation in response to an applyChanges call. By default, this flag is true.- Returns:
- The current value of the acceptSQLManipulation flag.
- See Also:
- setAcceptSQLManipulation(boolean)
 
 - 
setAcceptSQLManipulationvoid setAcceptSQLManipulation(boolean acceptSQLManipulation) Sets the value of the acceptSQLManipulation flag. This flag determines whether to allow the Intelligence Server to perform a SQL manipulation in response to an applyChanges call.- Parameters:
- acceptSQLManipulation- The new value for the acceptSQLManipulation flag.
- See Also:
- getAcceptSQLManipulation()
 
 - 
applyChangesWebReportInstance applyChanges() throws WebObjectsException, WebReportValidationException Sends all changes to the template and filter to the Intelligence Server. Returns a WebReportInstance object. The returned object will be the same as the object which applyChanges was called upon, with the difference of the state ID being increased by 1, if it was not necessary to generate a new report instance. If a new report instance was necessary (i.e. the report changes caused SQL generation), then this method will return a new WebReportInstance object with the new message ID. Finally, note that this method will update the manipulation type and validation level properties on this object.- Returns:
- The resultant WebReportInstance object from applying the changes.
- Throws:
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
- WebReportValidationException- Signals a report validation error from the Intelligence Server.
 
 - 
applyChangesWebReportInstance applyChanges(java.lang.String deltaXML) throws WebObjectsException, WebReportValidationException Sends the given report manipulation XML to the Intelligence Server. Returns a WebReportInstance object. The returned object will be the same as the object which applyChanges was called upon, with the difference of the state ID being increased by 1, if it was not necessary to generate a new report instance. If a new report instance was necessary (i.e. the report changes caused SQL generation), then this method will return a new WebReportInstance object with the new message ID. Finally, note that this method will update the manipulation type and validation level properties on this object.- Parameters:
- deltaXML- The report manipulation delta XML to send to the Intelligence Server.
- Returns:
- The resultant WebReportInstance object from applying the changes.
- Throws:
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
- WebReportValidationException- Signals a report validation error from the Intelligence Server.
 
 - 
applyChangesWebReportInstance applyChanges(java.lang.String deltaXML, int requestTimeout) throws WebObjectsException, WebReportValidationException Sends the given report manipulation XML to the Intelligence Server. Returns a WebReportInstance object. The returned object will be the same as the object which applyChanges was called upon, with the difference of the state ID being increased by 1, if it was not necessary to generate a new report instance. If a new report instance was necessary (i.e. the report changes caused SQL generation), then this method will return a new WebReportInstance object with the new message ID. Finally, note that this method will update the manipulation type and validation level properties on this object.- Parameters:
- deltaXML- The report manipulation delta XML to send to the Intelligence Server.
- requestTimeout- The session request timeout value. It is used to override the default session request timeout.
- Returns:
- The resultant WebReportInstance object from applying the changes.
- Throws:
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
- WebReportValidationException- Signals a report validation error from the Intelligence Server.
 
 - 
applyChangesWebReportInstance applyChanges(java.lang.String deltaXML, int requestTimeout, StringWrapper resultXML) throws WebObjectsException, WebReportValidationException Sends the given report manipulation XML to the Intelligence Server. Returns a WebReportInstance object. The returned object will be the same as the object which applyChanges was called upon, with the difference of the state ID being increased by 1, if it was not necessary to generate a new report instance. If a new report instance was necessary (i.e. the report changes caused SQL generation), then this method will return a new WebReportInstance object with the new message ID. Finally, note that this method will update the manipulation type and validation level properties on this object.- Parameters:
- deltaXML- The report manipulation delta XML to send to the Intelligence Server.
- requestTimeout- The session request timeout value. It is used to override the default session request timeout.
- resultXML- The manipulation result XML returned
- Returns:
- The resultant WebReportInstance object from applying the changes.
- Throws:
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
- WebReportValidationException- Signals a report validation error from the Intelligence Server.
 
 - 
getReportPropertiesWebProperties getReportProperties() Return current setting for WebProperties. Its default one is from WebReportSource (TBD). If there is no setting, an empty WebProperties object will be return. Then through WebProperties interface, property can be added/removed/changed. The properties in this WebProperties object will be used when re-execute the report.?- Returns:
- the current WebPropertiesin this instance.
 
 - 
getGraphPropertiesWebGraphProperties getGraphProperties() Return aWebGraphPropertiesobject, which can be used to set the web graph properties. The user can use the methods exposed by WebGraphProperties interface to add and manipulate the properties inside it.- Returns:
- Return a WebGraphPropertiesobject to represent current settings of WebGraphProperties.
 
 - 
isInstanceModifiedboolean isInstanceModified() throws WebObjectsExceptionThis method will return whether the submission of the changes to the report instance so far will cause a new report instance to be created. Note that this method will NOT cause the actual execution of the changes made to the report instance. This method will also update the manipulation type and validation level properties with more information on the type of change that the operation would cause.- Specified by:
- isInstanceModifiedin interface- WebResultSetManipulation
- Returns:
- Whether the report instance change submission would cause a new report instance to be created.
- Throws:
- WebObjectsException- Thrown if the server could not be contacted or another fatal error occurs.
 
 - 
getDeltaXMLjava.lang.String getDeltaXML() throws WebObjectsExceptionReturns the delta XML which would be sent to the Intelligence Server upon calling applyChanges(). This XML will be derived from the changes made to the template and filters of the owner report instance.- Specified by:
- getDeltaXMLin interface- WebResultSetManipulation
- Returns:
- The delta XML string for the current state of the report instance.
- Throws:
- WebObjectsException- Signals that the delta XML could not be determined.
 
 - 
requiresNewInstanceboolean requiresNewInstance() throws WebObjectsExceptionDetermines whether the changes made to the filter and template of this report will cause a new report instance (and thus, a reexecution of SQL).- Specified by:
- requiresNewInstancein interface- WebResultSetManipulation
- Returns:
- True if the changes made will cause a reexecution of SQL, false if they will not cause SQL to be executed.
- Throws:
- WebObjectsException- Signals an error when contacting the Intelligence Server.
 
 - 
getManipulationTypeint getManipulationType() Returns the manipulation type of a submission of changes to a report instance. This variable is updated after calling applyChanges or requiresNewInstance. The return value comes fromEnumDSSXMLManipulationType.- Returns:
- The manipulation type of the last report manipulation sent to the Intelligence Server.
 
 - 
getValidationLevelint getValidationLevel() Returns the validation level of a submission of changes to a report instance. This variable is updated after calling applyChanges or requiresNewInstance. The return value comes fromEnumDSSXMLValidationLevel.- Returns:
- The validation level of the last report manipulation sent to the Intelligence Server.
 
 - 
getNewPercentToTotalMetricWebPercentToTotalMetric getNewPercentToTotalMetric(WebMetric metric) throws java.lang.IllegalArgumentException, WebObjectsException Returns a new instance of theWebPercentToTotalMetricobject. This derived metric is based on the specified metric on the template or working set.- Parameters:
- metric- The- WebMetricobject used to create the derived metric.
- Returns:
- the WebPercentToTotalMetricobject created.
- Throws:
- java.lang.IllegalArgumentException- thrown if the metric is null or does not exist in the template or in the working set.
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
 
 - 
getNewRankMetricWebRankMetric getNewRankMetric(WebMetric metric) throws java.lang.IllegalArgumentException, WebObjectsException Returns a new instance of theWebRankMetricobject. This derived metric is based on the specified metric on the template or working set.- Parameters:
- metric- The- WebMetricobject used to create the derived metric.
- Returns:
- The WebRankMetricobject created.
- Throws:
- java.lang.IllegalArgumentException- thrown if the metric is null or does not exist in the template or in the working set.
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
 
 - 
getNewTransformationMetricWebTransformationMetric getNewTransformationMetric(WebMetric metric, WebObjectInfo transformationRole) throws java.lang.IllegalArgumentException, WebObjectsException Returns a new instance of theWebTransformationMetricobject. This derived metric is based on the specified metric on the template or working set.- Parameters:
- metric- The- WebMetricobject used to create the derived metric.
- transformationRole- a- WebObjectInfoobject that should have a type of DssXmlTypeRole and a subtype of DssXmlSubTypeRoleTransformation from- EnumDSSXMLObjectSubTypes.
- Returns:
- The WebTransformationMetricobject created.
- Throws:
- java.lang.IllegalArgumentException- thrown if the metric is null or does not exist in the template or in the working set. Also thrown if the transformation role object does not have the correct type and subtype.
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
 
 - 
addDerivedMetricWebReportInstance addDerivedMetric(java.lang.String formulae, int position) throws WebObjectsException, WebReportValidationException Adds a new derived metric to the report. This method will call addDerivedMetric with the same parameters but adding an empty alias name.- Parameters:
- formulae- The formula of the derived metric that can be understood by the parser.
- position- The position for the metric on the metrics template unit.
- Returns:
- A WebReportInstanceobject with the applied changes.
- Throws:
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
- WebReportValidationException- Signals a report validation error from the Intelligence Server.
 
 - 
addDerivedMetricWebReportInstance addDerivedMetric(java.lang.String formulae, int position, java.lang.String alias) throws WebObjectsException, WebReportValidationException Adds a new derived metric to the report.- Parameters:
- formulae- The formula of the derived metric that can be understood by the parser.
- position- The position for the metric on the metrics template unit.
- alias- The display name for the metric.
- Returns:
- A WebReportInstanceobject with the applied changes.
- Throws:
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
- WebReportValidationException- Signals a report validation error from the Intelligence Server.
 
 - 
addDerivedMetricWebReportInstance addDerivedMetric(java.lang.String formulae, int position, java.lang.String alias, java.lang.Boolean aggFromBase) throws WebObjectsException, WebReportValidationException Adds a new derived metric to the report.- Parameters:
- formulae- The formula of the derived metric that can be understood by the parser.
- position- The position for the metric on the metrics template unit.
- alias- The display name for the metric.
- aggFromBase- flag to indicate whether the metric should aggregate from base.
- Returns:
- A WebReportInstanceobject with the applied changes.
- Throws:
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
- WebReportValidationException- Signals a report validation error from the Intelligence Server.
 
 - 
addDerivedMetricWebReportInstance addDerivedMetric(java.lang.String formulae, int position, java.lang.String alias, java.lang.Boolean aggFromBase, boolean isPassThrough) throws WebObjectsException, WebReportValidationException 
 - 
addDerivedMetricWebReportInstance addDerivedMetric(java.lang.String formulae, int position, java.lang.String alias, int aggFromBase, int stFromBase, java.lang.Boolean isTokenStream) throws WebObjectsException, WebReportValidationException Adds a new derived metric to the report.- Parameters:
- formulae- The formula of the derived metric that can be understood by the parser.
- position- The position for the metric on the metrics template unit.
- alias- The display name for the metric.
- aggFromBase- flag to indicate whether the metric should aggregate from base.
- stFromBase- flag to indicate whether the metric should subtotal from base.
- isTokenStream- flag to indicate whether the formula is a token stream.
- Returns:
- A WebReportInstanceobject with the applied changes.
- Throws:
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
- WebReportValidationException- Signals a report validation error from the Intelligence Server.
 
 - 
addDerivedMetricWebReportInstance addDerivedMetric(java.lang.String formulae, int position, java.lang.String alias, int aggFromBase, int stFromBase, java.lang.Boolean isTokenStream, boolean isPassThrough) throws WebObjectsException, WebReportValidationException 
 - 
changeDerivedMetricAggFromBaseWebReportInstance changeDerivedMetricAggFromBase(java.lang.String formulae, int position, java.lang.String alias, java.lang.Boolean aggFromBase) throws WebObjectsException, WebReportValidationException This changes the formula or alias of the derived metric. If the key of the metric that is passed in does not correspond to a derived metric and a formula is passed in, then the existing metric is replaced by a derived metric with the given formula and alias- Parameters:
- key- key of the metric for which changes need to be made. The key can be obtained using- WebTemplateMetric.getKey()
- formula- The formula of the derived metric that can be understood by the parser.
- alias- The display name for the metric.
- aggFromBase- flag to indicate whether the metric should aggregate from base.
- Returns:
- A WebReportInstanceobject with the applied changes.
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
changeDerivedMetricAggFromBaseWebReportInstance changeDerivedMetricAggFromBase(java.lang.String formulae, int position, java.lang.String alias, java.lang.Boolean aggFromBase, java.lang.Boolean isTokenStream) throws WebObjectsException, WebReportValidationException This changes the formula or alias of the derived metric. If the key of the metric that is passed in does not correspond to a derived metric and a formula is passed in, then the existing metric is replaced by a derived metric with the given formula and alias- Parameters:
- key- key of the metric for which changes need to be made. The key can be obtained using- WebTemplateMetric.getKey()
- formula- The formula of the derived metric that can be understood by the parser.
- alias- The display name for the metric.
- aggFromBase- flag to indicate whether the metric should aggregate from base.
- isTokenStream- flag to indicate whether the formula is a token stream.
- Returns:
- A WebReportInstanceobject with the applied changes.
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
changeDerivedMetricWebReportInstance changeDerivedMetric(int key, java.lang.String formula, java.lang.String alias) throws WebObjectsException, WebReportValidationException This changes the formula or alias of the derived metric. If the key of the metric that is passed in does not correspond to a derived metric and a formula is passed in, then the existing metric is replaced by a derived metric with the given formula and alias- Parameters:
- key- key of the metric for which changes need to be made. The key can be obtained using- WebTemplateMetric.getKey()
- formula- The formula of the derived metric that can be understood by the parser.
- alias- The display name for the metric.
- Returns:
- A WebReportInstanceobject with the applied changes.
- Throws:
- WebObjectsException
- WebReportValidationException
- Since:
- MicroStrategy Web 8.0.0
 
 - 
changeDerivedMetricWebReportInstance changeDerivedMetric(int key, java.lang.String formula, java.lang.String alias, java.lang.Boolean aggFromBase) throws WebObjectsException, WebReportValidationException This changes the formula or alias of the derived metric. If the key of the metric that is passed in does not correspond to a derived metric and a formula is passed in, then the existing metric is replaced by a derived metric with the given formula and alias- Parameters:
- key- key of the metric for which changes need to be made. The key can be obtained using- WebTemplateMetric.getKey()
- formula- The formula of the derived metric that can be understood by the parser.
- alias- The display name for the metric.
- aggFromBase- flag to indicate whether the metric should aggregate from base.
- Returns:
- A WebReportInstanceobject with the applied changes.
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
changeDerivedMetricWebReportInstance changeDerivedMetric(int key, java.lang.String formula, java.lang.String alias, java.lang.Boolean aggFromBase, boolean isPassThrough) throws WebObjectsException, WebReportValidationException 
 - 
changeDerivedMetricWebReportInstance changeDerivedMetric(int key, java.lang.String formula, java.lang.String alias, int aggFromBase, int stFromBase, java.lang.Boolean isTokenStream) throws WebObjectsException, WebReportValidationException This changes the formula or alias of the derived metric. If the key of the metric that is passed in does not correspond to a derived metric and a formula is passed in, then the existing metric is replaced by a derived metric with the given formula and alias- Parameters:
- key- key of the metric for which changes need to be made. The key can be obtained using- WebTemplateMetric.getKey()
- formula- The formula of the derived metric that can be understood by the parser.
- alias- The display name for the metric.
- aggFromBase- flag to indicate whether the metric should aggregate from base.
- stFromBase- flag to indicate whether the metric should subtotal from base.
- isTokenStream- flag to indicate whether the formula is a token stream.
- Returns:
- A WebReportInstanceobject with the applied changes.
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
changeDerivedMetricWebReportInstance changeDerivedMetric(int key, java.lang.String formula, java.lang.String alias, int aggFromBase, int stFromBase, java.lang.Boolean isTokenStream, boolean isPassThrough) throws WebObjectsException, WebReportValidationException 
 - 
changeDerivedMetricWebReportInstance changeDerivedMetric(java.lang.String objectID, java.lang.String formula, java.lang.String alias, int aggFromBase, int stFromBase, java.lang.Boolean isTokenStream, boolean isPassThrough) throws WebObjectsException, WebReportValidationException This changes the formula or alias of the derived metric.- Parameters:
- objectID- The DSS ID of the metric for which changes need to be made.
- formula- The formula of the derived metric that can be understood by the parser.
- alias- The display name for the metric.
- aggFromBase- flag to indicate whether the metric should aggregate from base.
- stFromBase- flag to indicate whether the metric should subtotal from base.
- isTokenStream- flag to indicate whether the formula is a token stream.
- Returns:
- A WebReportInstanceobject with the applied changes.
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
addPercentToTotalMetricWebReportInstance addPercentToTotalMetric(WebPercentToTotalMetric metric) throws java.lang.IllegalArgumentException, WebObjectsException, WebReportValidationException Adds a percent to total metric to the Report.- Parameters:
- metric- the- WebPercentToTotalMetricto be added to the report.
- Returns:
- A WebReportInstanceobject with the applied changes.
- Throws:
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
- WebReportValidationException- Signals a report validation error from the Intelligence Server.
- java.lang.IllegalArgumentException- if the metric to be added is null.
 
 - 
addRankMetricWebReportInstance addRankMetric(WebRankMetric metric) throws java.lang.IllegalArgumentException, WebObjectsException, WebReportValidationException Adds a rank metric to the Report.- Parameters:
- metric- the- WebRankMetricto be added to the report.
- Returns:
- A WebReportInstanceobject with the applied changes.
- Throws:
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
- WebReportValidationException- Signals a report validation error from the Intelligence Server.
- java.lang.IllegalArgumentException- if the metric to be added is null.
 
 - 
addTransformationMetricWebReportInstance addTransformationMetric(WebTransformationMetric metric) throws java.lang.IllegalArgumentException, WebObjectsException, WebReportValidationException Adds a transformation metric to the Report.- Parameters:
- metric- the- WebTransformationMetricto be added to the report.
- Returns:
- A WebReportInstanceobject with the applied changes.
- Throws:
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
- WebReportValidationException- Signals a report validation error from the Intelligence Server.
- java.lang.IllegalArgumentException- if the metric to be added is null.
 
 - 
applyStyleByNameWebReportInstance applyStyleByName(java.lang.String name) throws java.lang.IllegalArgumentException, WebObjectsException, WebReportValidationException Apply a style by style name.- Parameters:
- name- the name of the style to be applied.
- Returns:
- A WebReportInstanceobject with the applied style.
- Throws:
- java.lang.IllegalArgumentException- Thrown when the name is null or empty string.
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
- WebReportValidationException- Signals a report validation error from the Intelligence Server.
 
 - 
applyStyleByIDWebReportInstance applyStyleByID(java.lang.String id) throws java.lang.IllegalArgumentException, WebObjectsException, WebReportValidationException Apply a style by style DSSID.- Parameters:
- id- the DSSID of the style object to be applied.
- Returns:
- A WebReportInstanceobject with the applied style.
- Throws:
- java.lang.IllegalArgumentException- Thrown when id is null or empty string.
- WebObjectsException- Singals an error when sending the changes to the Intelligence Server.
- WebReportValidationException- Signals a report validation error from the Intelligence Server.
 
 - 
showAllThresholdsWebReportInstance showAllThresholds(boolean show) throws WebObjectsException, WebReportValidationException Show all thresholds for all metrics.- Parameters:
- show- true to show all thresholds for all metrics, false to hide the thresholds for all metrics
- Returns:
- The resultant WebReportInstance object
- Throws:
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
- WebReportValidationException- Signals a report validation error from the Intelligence Server.
 
 - 
showAllThresholdsWebReportInstance showAllThresholds(boolean show, WebMetric metric) throws java.lang.IllegalArgumentException, WebObjectsException, WebReportValidationException Show all thresholds for a specific metric.- Parameters:
- show- true to show thresholds, false to hide thresholds.
- metric- the- WebMetricobject, whose thresholds will be affected.
- Returns:
- The resultant WebReportInstance object
- Throws:
- WebObjectsException- Signals an error when sending the changes to the Intelligence Server.
- WebReportValidationException- Signals a report validation error from the Intelligence Server.
- java.lang.IllegalArgumentException- if parameter metric is null
 
 - 
getResultWindowWebResultWindow getResultWindow() Returns the result window which can be used to set the result window to be passed to the Intelligence server upon calling applyChanges.- Returns:
- The WebResultWindowobject which can be used to send a window to the Server upon calling the applyChanges.
 
 - 
resetChangesWebReportInstance resetChanges() Return a new WebReportInstanceWebReportInstancewhich is the same as this report instance, except that the returned report instsance does not have any manipulation having been done for this report instance. This is an opposite operation of applyChanges(). The returned WebReportInstance is identical to current WebReportInstance, except that all manipulations have been cleared.- Returns:
- WebReportInstance A new WebReportInstance.
 
 - 
getExecutionFlagsint getExecutionFlags() Returns the current setting of execution flags. This flag value tells the Intelligence Server the settings to use when executing a report.- Returns:
- The current execution flags, from EnumDSSXMLExecutionFlags.
- See Also:
- setExecutionFlags(int)
 
 - 
setExecutionFlagsvoid setExecutionFlags(int executionFlags) Sets the execution flags property. This flag value tells the Intelligence Server the settings to use when executing a report.- Parameters:
- executionFlags- The new value of execution flags, a value which is the bitwise or (|) from values in- EnumDSSXMLExecutionFlags.
- See Also:
- getExecutionFlags()
 
 - 
getPreviewRowsint getPreviewRows() Returns the number of preview rows. This field value tells the Intelligence Server to use the number of rows for data preview.- Returns:
- The number of rows of preview data.
- See Also:
- setPreviewRows(int)
 
 - 
setPreviewRowsvoid setPreviewRows(int previewRows) Sets the number of preview rows. This field value tells the Intelligence Server the set the number of rows for data preview.- Parameters:
- previewRows- The number of rows of preview data.
- See Also:
- getPreviewRows()
 
 - 
getResultFlagsint getResultFlags() Returns the result flags which will be sent upon calling applyChanges.- Returns:
- The result flag value sent upon calling applyChanges.  This will be
 the bitwise or (|) of values from EnumDSSXMLResultFlags.
- See Also:
- setResultFlags(int)
 
 - 
setResultFlagsvoid setResultFlags(int resultFlags) Allows the user to set the result flags which will be sent upon calling applyChanges.- Parameters:
- resultFlags- The result flags which will be used upon calling applyChanges, from the bitwise or (|) of values from- EnumDSSXMLResultFlags.
- See Also:
- getResultFlags()
 
 - 
drillWebReportInstance drill(java.lang.String drillKey, java.lang.String[] drillElements, java.util.Map drillProperties) throws WebObjectsException Drills on the current report instance using the drill path key and settings passed as arguments.- Parameters:
- drillKey- This is the key to the drill path to be used for drilling. The drill key can be obtained from- WebDrillPath.getKey()
- drillElements- This is a string array of the drill elements representing the user filter. Each drill element is represented by an identifier (String) that can be obtained from- WebHeader.getDrillElement()
- drillProperties- This should be a map of drill settings that the user wants to override while drilling. The keys in the map should be from- EnumWebDrillProperties. Based on the type of drill property (int/boolean), following are the object types that can be passed as values in the Map :
 [1] For a drill property that can have integer values, an Integer or String object, wrapping the (integer) value, should be set.
 [2] For a drill property that can have only boolean values, a Boolean or String object representing the (boolean) value should be set. The String object should have values {"true", "false", "1", "0"} only.
- Returns:
- the new instance upon drilling.
- Throws:
- WebObjectsException- signal error encountered by IServer while executing the drill.
- Since:
- MicroStrategy Web 8.0.0
 
 - 
filterOnSelectionsWebReportInstance filterOnSelections(java.lang.String[] drillElements, java.util.Map drillProperties) throws WebObjectsException - Throws:
- WebObjectsException
- Since:
- MicroStrategy Web 9.0.0
 
 - 
refreshWebReportInstance refresh(boolean rePrompt) throws WebObjectsException refreshes the report results.- Parameters:
- rePrompt- should be sent to true, if prompts need to be re-answered.
- Returns:
- new report instance upon refresh.
- Throws:
- WebObjectsException- thrown if server encountered an error while refreshing the results.
- Since:
- MicroStrategy Web 8.0.0
 
 - 
refreshWebReportInstance refresh(java.lang.String promptAnswerXML) throws WebObjectsException refreshes the report results.- Parameters:
- promptAnswerXML- the answer xml for the prompts.
- Returns:
- new report instance upon refresh.
- Throws:
- WebObjectsException- thrown if server encountered an error while refreshing the results.
 
 - 
makeTabularWebReportInstance makeTabular() throws WebObjectsException, WebReportValidationException - Throws:
- WebObjectsException
- WebReportValidationException
- Since:
- MicroStrategy Web 8.1.0
 
 - 
addQuickListGroupWebReportInstance addQuickListGroup(java.lang.String deName, java.lang.String attId, int depth, int[] ordinals) throws WebObjectsException, WebReportValidationException Deprecated.- Throws:
- WebObjectsException
- WebReportValidationException
- Since:
- MicroStrategy Web 9.0.0
 
 - 
addQuickListGroupWebReportInstance addQuickListGroup(java.lang.String deName, java.lang.String attId, int depth, int[] ordinals, WebDerivedElements target) throws WebObjectsException, WebReportValidationException 
 - 
addQuickCalculationGroupWebReportInstance addQuickCalculationGroup(java.lang.String deName, java.lang.String attId, int depth, int[] ordinals, int function) throws WebObjectsException, WebReportValidationException Deprecated.- Throws:
- WebObjectsException
- WebReportValidationException
- Since:
- MicroStrategy Web 9.0.0
 
 - 
addQuickCalculationGroupWebReportInstance addQuickCalculationGroup(java.lang.String deName, java.lang.String attId, int depth, int[] ordinals, int function, WebDerivedElements target) throws WebObjectsException, WebReportValidationException 
 - 
setCurrentPageByElementWebReportInstance setCurrentPageByElement(java.lang.String elementID, int elementStatus, boolean applyChanges) throws WebObjectsException, WebReportValidationException 
 - 
addShortcutMetricWebReportInstance addShortcutMetric(int functionType, int functionType2, java.util.List<WebObjectInfo> unitsInfo) throws WebObjectsException, WebReportValidationException 
 - 
raExpandCollapseWebReportInstance raExpandCollapse(java.lang.String attId, int axis, int ordinal, int depth, boolean expand) throws WebReportValidationException, WebObjectsException 
 - 
validateExpressionjava.lang.String validateExpression(java.lang.String tokenStreamXML, boolean isForMetric, int outFlags, int baseFormType) throws WebObjectsException- Throws:
- WebObjectsException
 
 - 
toggleDatasetServerModeWebReportInstance toggleDatasetServerMode(int serverMode) throws WebObjectsException, WebReportValidationException Toggle dataset server mode- Parameters:
- serverMode-- EnumDSSXMLDatasetServeMode
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
changeEmmaSourceTablesPolicyWebReportInstance changeEmmaSourceTablesPolicy(java.util.Map<java.lang.String,java.lang.Integer> tbs) throws WebObjectsException, WebReportValidationException Change EMMA source tables policy, suggest to pass all the source tables with its policy together- Parameters:
- tbs- Key indicates source table IDs, and Value indicates policies- EnumDSSXMLCubeRefreshType
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
changeEmmaSourceTablesExecutionActionWebReportInstance changeEmmaSourceTablesExecutionAction(java.util.Map<java.lang.String,java.lang.Integer> tbs) throws WebObjectsException, WebReportValidationException Change EMMA source tables execution action flagsEnumDSSXMLTableStateExecutionActionaccording to the policy, suggest to pass all the source tables with its policy together.For the tables we changed their policy, we will set it's action to Force Execution. For the tables we ignored, we will set it's action to Ignore., - Parameters:
- tbs- Key indicates source table IDs, and Value indicates execution action- EnumDSSXMLCubeRefreshType
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
refreshEmmaCubeTablesWithExtParamWebReportInstance refreshEmmaCubeTablesWithExtParam(java.lang.String extParam) throws WebObjectsException Refresh EMMA cube with extended parameters- Parameters:
- extParam-
- Returns:
- Throws:
- WebObjectsException
 
 - 
customMappingForEmmaSourceTableWebReportInstance customMappingForEmmaSourceTable(java.lang.String tableName, MappingCreator mappingCreator) throws WebObjectsException, WebReportValidationException custom mapping for EMMA source table- Parameters:
- tableName-
- mappingsJson-
- relationshipsJson-
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
createPickTableWebReportInstance createPickTable(java.lang.String tableID, java.lang.String xdaType, java.lang.String dict, java.lang.String tableName, java.lang.String dbTableName, java.lang.String nameSpace, java.lang.String dbrID) throws WebObjectsException, WebReportValidationException Create pick table- Parameters:
- tableID-
- xdaType-
- dict-
- tableName-
- dbTableName-
- nameSpace-
- dbrID-
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
changeMappingWebReportInstance changeMapping(java.lang.String tableID, java.lang.String tableName, java.util.List<MappingOperation> mappings) throws WebObjectsException, WebReportValidationException change mapping- Parameters:
- tableID-
- tableName-
- cubeRepublishBehavior-
- changeMappingsJson-
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
editRelationshipWebReportInstance editRelationship(java.lang.String tableName, java.util.List<MappingRelationship> relationships) throws WebObjectsException, WebReportValidationException edit relationship- Parameters:
- tableName-
- relationships-
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
createSourceTableWebReportInstance createSourceTable(java.lang.String tableId, java.lang.String tableName, java.lang.String xdaType, java.lang.String connectorType) throws WebObjectsException, WebReportValidationException create table- Parameters:
- tableId-
- tableName-
- xdaType-
- connectorType-
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
editFreeFormSQLWebReportInstance editFreeFormSQL(java.lang.String expdef, java.lang.String emmaSourceTableId) throws WebObjectsException, WebReportValidationException edit FreeFormSQL- Parameters:
- expdef-
- emmaSourceTableId-
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
setDataImportInfoWebReportInstance setDataImportInfo(java.lang.String tbID, java.lang.String dbRoleID, java.lang.String sourceAccountID, java.lang.String url, java.lang.String userDisplayName, java.lang.String reportAddress, java.lang.String reportDesc, java.lang.String reportMimetype, java.lang.String reportName, java.lang.String shtIx, java.lang.String fileType, java.lang.String sparkURL) throws WebObjectsException, WebReportValidationException set DataImportInfo- Parameters:
- tbID-
- dbRoleID-
- sourceAccountID-
- url-
- userDisplayName-
- reportAddress-
- reportDesc-
- reportMimetype-
- reportName-
- shtIx-
- fileType-
- sparkURL-
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
syncModelWebReportInstance syncModel(java.lang.String modelJSON, int serveMode) throws WebObjectsException, WebReportValidationException edit syncModel- Parameters:
- modelJSON-
- serveMode-
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
syncModelWebReportInstance syncModel(java.lang.String modelJSON, int serveMode, java.util.List<TableAction> tableActions) throws WebObjectsException, WebReportValidationException edit syncModel- Parameters:
- modelJSON-
- serveMode-
- tableActions-
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
editEMMASourceTableWebReportInstance editEMMASourceTable(java.lang.String srcTableID, java.lang.String tableName, java.lang.String tableFormatLeft, java.lang.String tableFormatTop, java.lang.String tableFormatWidth, java.lang.String tableFormatHeight, java.lang.String executionFlag, java.lang.String isImportBinary, java.lang.String refreshType) throws WebObjectsException, WebReportValidationException edit editEMMASourceTable- Parameters:
- srcTableID-
- tableName-
- tableFormatLeft-
- tableFormatTop-
- tableFormatWidth-
- tableFormatHeight-
- executionFlag-
- isImportBinary-
- refreshType-
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
editEMMASourceTablesWebReportInstance editEMMASourceTables(JSONArray commands) throws WebObjectsException, WebReportValidationException edit editEMMASourceTables in batch- Parameters:
- commands- {did: srcTableId, exef: executeAction}
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
createPushDataTablesWebReportInstance createPushDataTables(java.util.List<java.lang.String> tableNames) throws WebObjectsException, WebReportValidationException create pushdatatables- Parameters:
- tableNames-
- tableIds-
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
customMappingForEmmaSourceTablesWebReportInstance customMappingForEmmaSourceTables(java.util.List<MappingCreator> mappingCreators) throws WebObjectsException, WebReportValidationException customMapping for EmmaSourceTables- Parameters:
- mappingCreators-
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
clearDiscoverCacheWebReportInstance clearDiscoverCache(java.lang.String tableId) throws WebObjectsException, WebReportValidationException clear discover cache- Parameters:
- tableId-
- Returns:
- the new instance
- Throws:
- WebObjectsException
- WebReportValidationException
 
 - 
applyChangeForReplaceObjectsWebReportInstance applyChangeForReplaceObjects(java.util.List<org.apache.commons.lang3.tuple.Pair<WebObjectInfo,WebObjectInfo>> listOfWebObjectsToReplace, int clearAlias, int clearFormats, int clearFilter) throws WebObjectsException, WebReportValidationException Creates XML request either to remove or replace objects from different data source. clr_a: controls whether to clear the alias. Default value is 0. If it is set to non-zero value, then during reconciliation, server will clear alias from template attribute and template metric. clr_f: controls whether to clear the formats. Default value is 0. If it is set to non-zero value, then during reconciliation, server will clear both grid and header formats from template attribute and template metric. clr_fs: controls whether to clear the expression from view filter or metric limit. Default value is 1. If non-zero value is passed or the parameter is not passed, server will try to clear a part of the expression from the view filter or metric limit if the expression is going to be changed.- Parameters:
- listOfWebObjectsToReplace- List of pair containing source WebObjectInfo, target WebObjectInfo
- clearAlias- clr_a: controls whether to clear the alias. Default value is 0. If it is set to non-zero value, then during reconciliation, server will clear alias from template attribute and template metric.
- clearFormats- clr_f: controls whether to clear the formats. Default value is 0. If it is set to non-zero value, then during reconciliation, server will clear both grid and header formats from template attribute and template metric.
- clearFilter- controls whether to clear the expression from view filter or metric limit. Default value is 1. If non-zero value is passed or the parameter is not passed, server will try to clear a part of the expression from the view filter or metric limit if the expression is going to be changed.
- Returns:
- Throws:
- WebObjectsException
- WebReportValidationException
 
 
- 
 
-