You can specify in the query some of the options that you can set in the information design tool.
The query specification model defines query options by using the <queryOption> XML element.
<queryOptions> <queryOption name="string" activated="true|false" value="string"/>
<queryOption> Attribute | Description |
---|---|
name | The option name |
activated | The option does not apply if activated is false. Is optional. If not present, the option is activated. |
value | The option value |
name Attribute Value | Description |
---|---|
duplicatedRows | If true, the query returns all related rows, even if there are duplicated rows. |
maxRetrievalTimeInSeconds | It defines the maximum time that a query can run before the query is stopped. |
maxRowsRetrieved | If true, the query returns all the
possible rows, but only displays the first n rows,where n is the maximum
number of rows set for this option. If the user only needs a certain amount of data, you can set this option to restrict the number of rows of data displayed in reports. |
samplingResultSetSize | It defines the maximum number of rows that a query returns as a sample. |
samplingResultSetFixed | It defines the type of sampling used. Option values are true for fixed sampling and false for random. |
See the Information Design Tool User Guide for more information about these options.
The following snippet of a query specification shows the query options.
<query xmlns="http://www.sap.com/rws/sl/universe" id="589789982204141561 dataSourceType="unx" dataSourceId="5808"> <querySpecification version="1.0"> <queryOptions> <queryOption name="duplicatedRows" value="true"/> <queryOption name="maxRetrievalTimeInSeconds" activated="false" value="600"/> <queryOption name="maxRowsRetrieved" activated="true" value="5000"/> <queryOption name="samplingResultSetSize" activated="false" value="200"> <queryOption name="samplingResultSetFixed" activated="false" value="false"> </queryOptions> ... </querySpecification> </query>