Show TOC

Function documentationGeneral Query Parameters Locate this document in the navigation structure

 

You use the parameters on the General screen of an SAP Manufacturing Integration and Intelligence query to set the following:

  • Maximum number of rows returned from the query

  • Numeric format for data values

    For more details on numeric format, see Number Format Symbols.

  • Amount of time queries are kept in a cache

Features

The query caching parameters define whether a query should be cached and how long cached data is considered fresh. If the duration for the data set was reached and the associated query is called, the data source retrieves the data and not the expired cache.

For a query request to return results from the cache, the following must be the same in the request and cache data:

  • Parameter values including the start time and end time

  • Name-value pairs

If the query is set for caching, but the parameters are set at runtime, a new cache is created for each set of name-value pairs. If you change the parameter values at runtime, the previous cache instance is overwritten.

Example Example

If you have a query that returns the material usage for a batch from a database, the query might be similar to the following:

Select

b.BatchID,

b.BatchName,

m.MaterialID,

m.MaterialName,

m.Quantity

from

Batch b,

BatchMaterialHistory m

where

b.BatchID = M.BatchID and

b.BatchID = [Param.1]

Param.1 may be passed in at runtime through an HTML page, agent, or other user interaction. The query and result set is different for each requested BatchID. Only the last instance of the query is saved in the cache.

End of the example.
Number Format Symbols

Symbol

Meaning

0

A digit

#

A digit, zero shows as absent

.

Placeholder for decimal separator

,

Placeholder for grouping separator

-

Default negative prefix

%

Multiply by 100 and show as percentage

?

Multiply by 1000 and show as per mille

¤

Currency sign. Will be replaced by currency symbol; if doubled, replaced by international currency symbol. If present in a pattern, the monetary decimal separator is used instead of the decimal separator

X

Any other characters can be used in the prefix or suffix

'

Used to quote special characters in a prefix or suffix

Activities

To clear the cache, use the following URL: http://<servername>/XMII/Illuminator?Service=QueryCaching&Mode=ClearCache