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
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
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.
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 |
To clear the cache, use the following URL: http://<servername>/XMII/Illuminator?Service=QueryCaching&Mode=ClearCache