on 03-13-2007 9:58 AM
can u please give the complete details of Queries used in QueryTemplate.
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??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
11 | |
6 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.