Blog | Language | Customer Login | +1-925-218-6983
What is Visual KPI? | FREE 30-Day Trial | +1-925-218-6983 Subscribe via RSS Feed

 

Real-Time Dashboards & Alerts

Smartphones | Tablets | Web Browsers | PC & Mac | More

Visual KPI reads multiple data sources in real-time (big data, historians, databases, manual data, web services and more) and adds context with KPIs, groups/hierarchy, alerts, and geolocation. It gets your critical data in the hands of more users without extensive training and it can be deployed in days, not months. Want to see how we do it?

Mobile Operations Monitoring - Tour
Real-time KPIs on Browser, iPhone, iPad, Android, Windows Phone, tablet
The all-new Visual KPI v5 is here! Click to learn More…
What is it?

Visual KPI is mobile dashboard software for any device. It reads existing data sources and delivers KPIs, scorecards, analytics and alerts in real-time.

Who uses it?

Decision makers. Operations. Remote workers. Data Junkies. Anyone who values knowing what's happening right now, regardless of their device.

Why use it?

Mobility is no longer optional. Visual KPI presents problems and opportunities before it's too late. Oh, and there's no six-month project that "might" pay off.

American Electric Power BP Wind Energy con edison operations Exelon Energy Genentech FMI - Freeport McMoRan Corning Pemex Tesoro

Support Alert: iOS 8/9 Issues with Authenticated Sites. Read More

Support Alert: iOS and Android dedicated apps no longer supported (web client only). Read More


Free 30-Day Mobile BI Trial

Free Guide - Mobile BI Guide eBook

 

 

 

 

Support FAQ > Data Sources > How do I create flexible queries in a Visual KPI interface?

Search the FAQ for entries containing:

There are many ways to make an interface flexible.  Here are a couple of examples:

Example 1: Simple query (single parameter)
Here is our sample GetCurrentValue query from the ODBC interface, it is able to get data from a single table and use this across many KPIs. It is based on SQL Server so Oracle (or other ODBC sources) may require some date manipulation:

SELECT TOP 1 Value, Timestamp as Date FROM SampleData WHERE LookUp = '{0}' and Timestamp <= GetUTCDate() order by Timestamp DESC

If your Data is in a table called “test1” (for example) and your Value column is named “Level” and your Timestamp column is named “Date_Recorded” then you modify the query to look like this (the brackets and double quote marks are sometimes needed in Oracle, sometimes not). Also GETUTCDate () is SQL Server specific, so you can try CURRENT_TIMESTAMP (or whatever the equivalent of GetUTCDate is in your data source):

SELECT TOP 1 [Level] as [Value], [Date_Recorded] as “Date”, FROM test1 WHERE Unit = '{0}' and [Date_Recorded] <= CURRENT_TIMESTAMP order by [Date_Recorded] DESC

To use this query, you would then put the Unit Name ('unit 1' as the example) in the Actual column inside the Visual KPI Designer. So each row of KPIs would have different Actual values, as they would be from different Units. At runtime the interface will substitute the inbound parameter (in this case the Unit) and issue the query. The query as sent to the database at runtime would thus read:

SELECT TOP 1 [Level] as [Value], [Date_Recorded] as “Date”, FROM test1 WHERE Unit = 'unit 1’' and [Date_Recorded] <= CURRENT_TIMESTAMP order by [Date_Recorded] DESC

Example 2: More Flexible Query (4 parameters)
Here is an example of a GetCurrentValue query that can be used for thousands of different KPIs, using different lookup values across many different tables:

SELECT TOP 1 {3} as [Value], [Date_Recorded] as [Date] FROM {0} WHERE {1} = '{2}' and [Date_Recorded] <= CURRENT_TIMESTAMP order by [Date_Recorded] DESC

{0} = Table name (example: test1)

{1} = Column to use for lookup values (example: Unit)

{2} = Value to search for in column (example: unit 1)

{3} = Column name to return in query (example: Level)

To use this query, you would then put the test1|Unit|mm|Level in the Actual column inside the KPI Designer. So each row of KPIs would have different Actual values, as they would be from different Tables, Units, . At runtime the interface will substitute the inbound parameters in order to the parameter names and issue the query. The query as sent to the database at runtime would thus read:

SELECT TOP 1 [Level] as [Value], [Date_Recorded] as “Date”, FROM test1 WHERE Unit = 'unit 1’' and [Date_Recorded] <= CURRENT_TIMESTAMP order by [Date_Recorded] DESC

As always, contact us at support@transpara.com or +1-925-218-6983 if you have questions.

Last updated on May 13, 2013 by Transpara

Free 30-Day Trial

Transpara LLC
4715 W. Culpepper Drive‎
Phoenix, AZ 85087
USA
+1-925-218-6983

© 2005-2016 Transpara LLC. All rights reserved.
Privacy Policy | Terms of Use | Copyrights

© 2005-2016 Transpara LLC | Privacy Policy | Terms of Use | info@transpara.com | +1-925-218-6983