Bentley Communities
Site
Search
User
Site
Search
User
Welcome
Products
Support
About
More
Cancel
Product Communities
Digital Twin Cloud Services
iTwin Services
Cancel
iTwin Services
Design Insights Wiki
Workflow Checklist
Sign In
-
Design Insights Wiki
Getting Started
-
Workflow
Schema Configuration.
Ancillary Data Configuration
Schema Mapping
Data Extraction
Troubleshooting
Workflow Checklist
Data Explorer
Ancillary Data
Key Performance Insights
Concept Compare
Change Report
Questions about this article, topic, or product? Click here.
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.
iTwin Design Insights
Design Insights
Share
History
More
Cancel
Created by
Kaustubh Page
When:
Wed, Mar 2 2022 10:37 PM
Revisions:
1
Comments:
0
Recommended
Related