Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
Asset Reliability | AssetWise APM
  • Product Communities
  • AssetWise
  • Asset Reliability | AssetWise APM
  • Cancel
Asset Reliability | AssetWise APM
Asset Reliability | AssetWise APM Wiki Sample of Calculated Indicator using a database Stored Procedure
    • Sign In
    Asset Reliability | AssetWise APM requires membership for participation - click to join

     
     Questions about this article, topic, or product? Click here. 

    Sample of Calculated Indicator using a database Stored Procedure

      Product(s): AssetWise APM Foundation
      Version(s): N\A
      Environment: N\A
      Area: Calculated Indicators
      Subarea: N\A

    Here is an example of a simple calculated indicator without inputs using a basic stored proc that returns 1.0 as the value

     
    CREATE PROCEDURE [dbo].[TestProcedure]
           @value float output
    AS
    Begin
           select @value = 1.0
    End
     
     Create an indicator like the following inside APM
     

     
    When I test it using the ‘Check (Live)’ button:
     

      Original Author: Diana Drummond
    • AssetWise APM
    • Assetwise APM Foundation
    • indicator
    • en
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • Diana Marin Created by Bentley Colleague Diana Marin
    • When: Tue, Nov 1 2016 1:27 PM
    • Diana Marin Last revision by Bentley Colleague Diana Marin
    • When: Tue, Nov 1 2016 1:28 PM
    • Revisions: 2
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies