cancel
Showing results for 
Search instead for 
Did you mean: 

New Member

former_member331856
Participant
0 Kudos

can u please give the complete details of Queries used in QueryTemplate.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi giridhar,

what details do u want in Query Templates? Can u be a bit clear. Do u mean to ask what are the diff kind of queries used for??

former_member331856
Participant
0 Kudos

yes. can u explain each and every query clearly

Former Member
0 Kudos

Hi Giridhar,

There are 7 types of Queries in xMII, each used to talk to a diff datasource using diff connectors. U can see the type of data source u can access using a query in the Data Source tab. And with each query, u've got diff modes to query the data based.

For e.g:

1) Tag Query- Used to access historian, human-machine interface (HMI,

SCADA, and I/O systems)

2) SQL Query- Used to access relational data in a wide range of database

sources

3) Alarm Query- Used to access alarm/event management systems (HMI,

building automation, network management, etc.)

4) XML Query- Used to access static or dynamic XML content (typical interface

to ERP and related systems)

5) Aggregate Query- used to take data from multiple queries and combine them

into a single document.

6) OLAP Query- used to query data from data warehouse, or cubed data, using

MDX query syntax

7) Xacute Query- used to run an SAP xMII Business Logic Transaction and

return the results to an SAP xMII visual component.

OLAP - used to query data from data warehouse, or cubed data, using MDX query syntax

Answers (0)