Power BI reports - Intergraph Spoolgen - Help

Intergraph Spoolgen Help

Language
English
Product
Intergraph Spoolgen
Search by Category
Help
SmartPlant Foundation / SDx Version
10
I-Configure Version
6.0(2016)
Isogen Version
13.0(2016)
Smart Isometrics Version
7.0(2019)
Spoolgen Version
9.0(2019)

An example of a Power BI report created using Isogen web service data is shown below.

Getting started

  • Install Power BI Desktop (Used for report authoring. You can download the software from the Microsoft web site).

  • Install the latest available version of the Intergraph SmartĀ® API Custom Connector for Power BI (enables Power BI to connect to the Isogen web service).

  • Identify the URL of the Isogen web service.

  • Locate the project ID for the project for which you are creating reports.

    The URL of the Isogen web service and the project ID display in the Project Defaults dialog box in I-Configure.

    You can retrieve both parameters directly from the ATTRIBUTES section of the <Project Name>_Data.xml file.

    The path to <Project Name>_Data.xml file displays in the I-Configure Properties panel. The example below shows that the location of the .xml file for the ISODB6 project is the C:\Users\Public\SampleIsoDir\ISODB6\ folder.

  • Make note of the SelectListItemType property value for the Available status (Used for filtering. The value for the Available status is always d4c4bef5-7237-4a5b-b1ab-a3d7a4cb5c5).

  • Determine the drawing style to use for project deliverables (as defined in I-Configure).

Reporting Isometrics

You can use isometrics data for estimating and bid preparation. Reporting isometrics relies on the data visible in the Isogen database grid that displays in Spoolgen or Smart Isometrics and is not dependent on generating any deliverables. To limit the isometrics to the latest version available in the database (in other words, only isometrics where IsCurrentVersion is set to True), we recommend using the $filter parameter on the Isogen web service URL to limit the isometrics returned by the Power BI query. Example syntax is shown below:

<web_service_url>/Isogen/V1/Projects(ā€˜<project_id>')/Isometrics?$filter=IsCurrentVersion eq true

Although you can filter within Power BI, that is retrieve all isometrics and then filter on the IsCurrentVersion value, using the ODATA filter will:

  • minimize data that has to be retrieved

  • simplify the development of additional reports by eliminating all non-current isometrics

Create a Power BI data source

  1. Open Power BI Desktop.

  2. Click Home > Get Data.

  3. Select Intergraph SmartĀ® API, and then click Connect.

  4. In the OData Service document URL box, type the Isogen web service URL with the $filter parameter to retrieve all current isometrics (<web_service_url>/Isogen/V1/Projects(ā€˜<project_id>ā€™/Isometrics?$filter=IsCurrentVersion eq True).

  5. Click OK.

    The system retrieves the isometrics that meet the query criteria.

    To edit the query click Edit. For example, you can rename the query or restrict columns from being displayed.

  6. Use the library of Power BI visualizations to configure the report.

Reporting Deliverables

Deliverables are drawings, reports, and data generated by a run of Isogen using a particular isometric drawing style.

A style is a set of options that determine the content and format of the deliverable.

Drawings, reports, and data associated with a deliverable are guaranteed to be consistent with one another as well as with the isometric from which they were generated. You access the detailed piping data on spools, welds, parts, cut pieces, and joints through the deliverable.

To find a set of deliverables for a particular style with the deliverable status set to Available, you use the following ODATA query:

<web_service_url>/Isogen/V1/Projects(ā€˜<project_id>')/Deliverables?$filter=(Style eq ā€˜<style>' and cast(Status,Edm.String) eq 'd4c4bef5-7237-4a5b-b1ab-a3d7a4cb5c58')

The value for Available is always d4c4bef5-7237-4a5b-b1ab-a3d7a4cb5c58.

Reporting Current Deliverables

In most cases, you want the set of deliverables for current isometrics only as these deliverables represent the latest versions that exist in the project. In Power BI, you can use the Merge Queries command to retrieve the deliverables only for current isometrics.

  1. Select Merge Queries as New to create a new query.

  2. Select the CurrentIsometrics and AvailableDeliverables queries.

  3. Perform an Inner Join on Deliverables.IsometricID and Isometrics.ID.

The result is a query that limits the results to the latest version. You can expand the Pipelines table (1) and other child tables such as Pipeline.Parts (2), to bring in data for reports and dashboards.

You can copy this query to create different views.