Workflow Checklist

  • KPIs
    • Please have the key performance indicators such as cost or embodied carbon identified for the project.
    • Make sure you have all the formulas accessible for calculating the KPI.
      • e.g. for cost KPI, cost formulas for all structural design should be available such as concrete column cost = Volume * 350 + (Volume * 0.003) * 2500 + Area * 12.7

  • Schema Definition
    • Please make sure Schema Configuration contains all properties needed to support KPI calculations.
      • e.g. for Columns with the formula above, the schema must contain material, Volume and Area

  • KPIs to Ancillary Data
    • Please make sure individual entries are created for each KPI.
      • e.g. if Construction and Procurement Costs need to be tracked separately, Ancillary Data should have two separate tabs; One for Construction Cost and one for Procurement Cost
    • Placeholder formulas should be entered when creating these KPIs. Actual formulas will be entered in later stage of the workflow
      • e.g., placeholder formula for columns = Volume * 10

  • Understanding available data
    • Using https://imodelconsole.bentley.com/ explore data structure in the iModel
      • Useful queries
      • All Classes with Design Element counts - 
        • select be.ecclassid,COUNT(be.ecclassid), cl.Description from bis.element be join meta.ecclassdef cl on be.ecclassid = cl.ecinstanceid GROUP BY be.ecclassid
      • Classes with specific term, for example all classes with "column" string in the name
        • select distinct be.ecclassid, cl.Description from bis.element be join meta.ecclassdef cl on be.ecclassid = cl.ecinstanceid where cl.name like '%column%'

  • Schema Mapping
    • Only upon understanding the data using iModel Console, create schema mappings.

  • Once Data Extractions are complete, check the KPI data in Data Explorer.
  • Created by Bentley Colleague
  • When:
  • Revisions: 1
  • Comments: 0
Recommended
Related