How can we improve PI Developer Technologies for you?

Be able to access the UOM database as tables

The current method of accessing UOM data is inconsistent with the rest of PI OLEDB Enterprise. Instead of tables, we have functions such as UOMAbbreviation and UOMClassName. Imagine if we had a function for each non-ID column of information that we wanted to access (e.g. ElementName, ElementTemplateDescription). It doesn't make sense. Please make the UOM database available as tables.

This would also make it easier to manage and clean up the UOM database. For example, an administrator might want to make sure that compound units (e.g. m/s) are named consistently with their base units (e.g. Canadians might change "meter" to "metre"). An administrator might also want to check the conversion factors in the UOM database against a trusted source.

0 votes
Sign in Sign in with OSIsoft
Signed in as (Sign out)

We’ll send you updates on this idea

Kenneth Barber shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in Sign in with OSIsoft
Signed in as (Sign out)
Submitting...
  • Kenneth Barber commented  ·   ·  Flag as inappropriate

    Can someone from OSIsoft please decline this idea? The UOM database exists as tables in PI OLEDB Enterprise's successor: PI SQL Client.

Feedback and Knowledge Base

Posted ideas will have one of the following statuses.
Full definition of these statuses can be found on the Home Page.
No status
NEEDS MORE DISCUSSION
RESEARCHING/EVALUATING
DECLINED
PLANNED
STARTED/IN DEVELOPMENT
IN BETA
COMPLETED