Show TOC

Function documentationGeneral Query Parameters

 

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

  • Digital Settings

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
Comment

You can provide a short description that will be visible in the Data Buffer Jobs and Entries screen.

Allow Buffering

Select this checkbox to enable data buffering of a query.

Restrict Property Override

Controls what parameters can be overridden from the web at runtime. For more information, see Template Security

Digital Settings

This checkbox is visible only for PCo query and is applicable for MII adapter for HANA SDA. Select this checkbox to display the data type of the “Value” column of the generated virtual table in HANA studio as string. By default, the data type is double.

Note Note

To retrieve values for selected tags as string in SAP MII, you must select DigStr as String in SAP PCo. For more details, see PI Source System: Settings Tab

End of the note.

Activities

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