You can specify in the query some of the options that you can set in the universe design tool for UNV universes or the information design tool for UNX universes.
<queryOptions> <queryOption name="string" activated="Boolean" value="string"/>
Attribute | Type or Value | Description |
---|---|---|
name | string (values in table below) | The option name |
activated | Boolean | The option does not apply if activated is false. Is optional. If not present, the option is activated. |
value | string | 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. |
The following snippet of a query specification for a UNX universe 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>