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
Check out a 2-minute video and see the latest…
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


OSIsoft PI World Sponsor 

Support FAQ > Data Sources > How many database tables can I access through one interface?

Search the FAQ for entries containing:

VKPI can handle as many tables in a database as you wish (and more).  Each Visual KPI interface should go to a single DATABASE, but within that database you can access as many different tables and columns as you like.

Visual KPI SQL interfaces need 3 queries: 

  • Current Value (returns most recent Value and Date)
  • Historical Value (returns Value and Date as of a point in history)
  • Time Series (returns Value and Date pairs between start and end time) 

Each query must return data named Value and Date, so if the source data has columns of different names, then the query must mask the results as Value and Date.

Each query can take one or more parameters, allowing more than one independent variable for each returned dependent variable.   When the query is executed, it will take the value of each passed-in parameter, substitute the variable in the T-SQL string with the passed-in value, then issue the modified query to the source database.  Interface parameters take the form of {0}, {1}, {2} etc indicating the first, second and third passed-in value to be substituted before executing the query.

Example: Let’s say you have a table or even a series of complex related tables requiring inner and outer joins. Regardless of the complexity of the joining, the net result for us must look like this pattern (Current Value used as example, taking 4 inputs and generating 1 output). Of course, you can choose to “hard-code” any of these variables, this is just an illustration of the flexibility of our parameterized queries.

Select top 1 {1} as Value, ColumnYName as Date from {0} where {2} = {3} and ColumnYName <= GetUTCDate() order by ColumnYName Desc

We use GetUTCDate() or the equivalent in non-SQL SERVER systems to ensure that we avoid showing any future data that might be present in the result set.

Substitutions at runtime:

{0} = Table name in database
{1} = Column Name of Dependent (output) variable in database
{2} = Column Name of Independent (input) variable in database
{3} = Value of Independent variable in database

So in the KPI Designer, a Cell that wants to retrieve data from the interface using the Current Value query above would have data in it that looks like this:

Actual:  OpsData|Throughput|UnitNumber|A-617
Actual Interface:  ODBC-OpsData

{0} = OpsData = name of the table to be queried
{1} = Throughput = column name of the output data to be returned
{2} = UnitNumber = column name of the input data
{3} = A-617 = value of the independent variable

This was a long-winded answer to what may seem like a short and simple question, so we will summarize by saying this:

Visual KPI can support as many tables, views and complex inner and outer joins as you can possibly imagine.

Last updated on January 31, 2013 by Transpara

Free 30-Day Trial

Transpara LLC
4715 W. Culpepper Drive‎
Phoenix, AZ 85087

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

© 2005-2018 Transpara LLC | Privacy Policy | Terms of Use | | +1-925-218-6983