Export a BI Gateway Model

You can export an existing BI Gateway Model to a .json file. The export considers the latest version of objects.

To export a BI Gateway Model

1. From the BI Gateway Model Home page, click Export All from the main menu. A confirmation message appears.

2. Click Done to finish exporting the Model. The Exported Model is save at the default location with a file name Data.json.

   NOTE: You can also export an individual model object using the Export icon available in the Object editor.

Editing the .JSON file

You can edit the exported file in any notepad editor to modify the BI Gateway Model as per the requirement before importing into a new setup and create a fresh BI Gateway Model. However, it is recommended that you should avoid editing the .json file.

Sample Exported Model File Format

{"Settings":[{"SettingUID":1,"Name":"Schema.Version","Value":"3.1.0","DateEntered_UTC":"2020-04-21T03:39:17.7828712"}],"Calculations":[{"CalculationUID":2,"Id":"18b6e6b9-381d-496e-8c12-ff5ee76b2284","MeasureDataItemUID":3,"MeasureDataItemVersion":1,"Name":"Cal_Avg","Function":"Average (Row Based)","FunctionFieldMapping_MappingTypeUID":0,"FunctionFieldMapping_SourceFieldName":"Calc_A","PeriodFieldMapping_MappingTypeUID":0,"PeriodFieldMapping_SourceFieldName":"DateEntered","ModificationPeriodFieldMapping_MappingTypeUID":0,"ModificationPeriodFieldMapping_SourceFieldName":"<None>","ModificationPeriodInterval":null,"ModificationPeriodUnit":null,"ReturnDataTypeUID":4,"FilterExpression":null},{"CalculationUID":3,"Id":"24362dc6-2b93-49ec-9c60-efdceed56695","MeasureDataItemUID":3,"MeasureDataItemVersion":1,"Name":"Cal_Count","Function":"Count","FunctionFieldMapping_MappingTypeUID":0,"FunctionFieldMapping_SourceFieldName":"Calc_A","PeriodFieldMapping_MappingTypeUID":0,"PeriodFieldMapping_SourceFieldName":"DateEntered","ModificationPeriodFieldMapping_MappingTypeUID":0,"ModificationPeriodFieldMapping_SourceFieldName":"<None>","ModificationPeriodInterval":null,"ModificationPeriodUnit":null,"ReturnDataTypeUID":4,"FilterExpression":null},{"CalculationUID":4,"Id":"0f96f8cd-9550-4ab3-8e0a-53899fc44c36","MeasureDataItemUID":3,"MeasureDataItemVersion":1,"Name":"Cal_Min","Function":"Min","FunctionFieldMapping_MappingTypeUID":0,"FunctionFieldMapping_SourceFieldName":"Calc_A","PeriodFieldMapping_MappingTypeUID":0,"PeriodFieldMapping_SourceFieldName":"DateEntered","ModificationPeriodFieldMapping_MappingTypeUID":0,"ModificationPeriodFieldMapping_SourceFieldName":"<None>","ModificationPeriodInterval":null,"ModificationPeriodUnit":null,"ReturnDataTypeUID":4,"FilterExpression":null},{"CalculationUID":5,"Id":"5ddd0ffe-7eb3-43bf-a400-fc2db01cfb78","MeasureDataItemUID":3,"MeasureDataItemVersion":1,"Name":"Cal_Max","Function":"Max","FunctionFieldMapping_MappingTypeUID":0,"FunctionFieldMapping_SourceFieldName":"Calc_A","PeriodFieldMapping_MappingTypeUID":0,"PeriodFieldMapping_SourceFieldName":"DateEntered","ModificationPeriodFieldMapping_MappingTypeUID":0,"ModificationPeriodFieldMapping_SourceFieldName":"<None>","ModificationPeriodInterval":null,"ModificationPeriodUnit":null,"ReturnDataTypeUID":4,"FilterExpression":null},{"CalculationUID":6,"Id":"bdb76c48-c469-46ea-bf25-d0bacfb9a5b9","MeasureDataItemUID":3,"MeasureDataItemVersion":1,"Name":"Cal_Sum","Function":"Sum","FunctionFieldMapping_MappingTypeUID":0,"FunctionFieldMapping_SourceFieldName":"Calc_A","PeriodFieldMapping_MappingTypeUID":0,"PeriodFieldMapping_SourceFieldName":"DateEntered","ModificationPeriodFieldMapping_MappingTypeUID":0,"ModificationPeriodFieldMapping_SourceFieldName":"<None>","ModificationPeriodInterval":null,"ModificationPeriodUnit":null,"ReturnDataTypeUID":4,"FilterExpression":null},{"CalculationUID":7,"Id":"6ead163f-3db0-40d8-bc70-6f7d1731bb97","MeasureDataItemUID":2,"MeasureDataItemVersion":1,"Name":"Cal_Sum","Function":"Sum","FunctionFieldMapping_MappingTypeUID":0,"FunctionFieldMapping_SourceFieldName":"Count","PeriodFieldMapping_MappingTypeUID":0,"PeriodFieldMapping_SourceFieldName":"DateEntered","ModificationPeriodFieldMapping_MappingTypeUID":0,"ModificationPeriodFieldMapping_SourceFieldName":"<None>","ModificationPeriodInterval":null,"ModificationPeriodUnit":null,"ReturnDataTypeUID":4,"FilterExpression":null},{"CalculationUID":8,"Id":"3a5fc4e4-24fd-403c-8199-201bbd141e59","MeasureDataItemUID":2,"MeasureDataItemVersion":1,"Name":"Cal_Avg","Function":"Average (Row Based)","FunctionFieldMapping_MappingTypeUID":0,"FunctionFieldMapping_SourceFieldName":"Count","PeriodFieldMapping_MappingTypeUID":0,"PeriodFieldMapping_SourceFieldName":"DateEntered","ModificationPeriodFieldMapping_MappingTypeUID":0,"ModificationPeriodFieldMapping_SourceFieldName":"<None>","ModificationPeriodInterval":null,"ModificationPeriodUnit":null,"ReturnDataTypeUID":4,"FilterExpression":null},{"CalculationUID":9,"Id":"f1d011a8-d716-4eaa-8ae8-11fc8ba455b1","MeasureDataItemUID":2,"MeasureDataItemVersion":1,"Name":"Cal_Min","Function":"Min","FunctionFieldMapping_MappingTypeUID":0,"FunctionFieldMapping_SourceFieldName":"Count","PeriodFieldMapping_MappingTypeUID":0,"PeriodFieldMapping_SourceFieldName":"DateEntered","ModificationPeriodFieldMapping_MappingTypeUID":0,"ModificationPeriodFieldMapping_SourceFieldName":"<None>","ModificationPeriodInterval":null,"ModificationPeriodUnit":null,"ReturnDataTypeUID":4,"FilterExpression":null},{"CalculationUID":10,"Id":"c2cb3a31-ea95-4315-addf-b9525cc06def","MeasureDataItemUID":2,"MeasureDataItemVersion":1,"Name":"Cal_Max","Function":"Max","FunctionFieldMapping_MappingTypeUID":0,"FunctionFieldMapping_SourceFieldName":"Count","PeriodFieldMapping_MappingTypeUID":0,"PeriodFieldMapping_SourceFieldName":"DateEntered","ModificationPeriodFieldMapping_MappingTypeUID":0,"ModificationPeriodFieldMapping_SourceFieldName":"<None>","ModificationPeriodInterval":null,"ModificationPeriodUnit":null,"ReturnDataTypeUID":4,"FilterExpression":null},{"CalculationUID":11,"Id":"e102684a-fead-4a83-9987-21561a008376","MeasureDataItemUID":2,"MeasureDataItemVersion":1,"Name":"Cal_Count","Function":"Count","FunctionFieldMapping_MappingTypeUID":0,"FunctionFieldMapping_SourceFieldName":"Count","PeriodFieldMapping_MappingTypeUID":0,"PeriodFieldMapping_SourceFieldName":"DateEntered","ModificationPeriodFieldMapping_MappingTypeUID":0,"ModificationPeriodFieldMapping_SourceFieldName":"<None>","ModificationPeriodInterval":null,"ModificationPeriodUnit":null,"ReturnDataTypeUID":4,"FilterExpression":null}],"CalculationSourceDataItemMappings":[{"CalculationSourceDataItemMappingUID":2,"CalculationUID":2,"SourceDataItemUID":1447,"Priority":0},{"CalculationSourceDataItemMappingUID":3,"CalculationUID":3,"SourceDataItemUID":1447,"Priority":0},{"CalculationSourceDataItemMappingUID":4,"CalculationUID":4,"SourceDataItemUID":1447,"Priority":0},{"CalculationSourceDataItemMappingUID":5,"CalculationUID":5,"SourceDataItemUID":1447,"Priority":0},{"CalculationSourceDataItemMappingUID":6,"CalculationUID":6,"SourceDataItemUID":1447,"Priority":0},{"CalculationSourceDataItemMappingUID":7,"CalculationUID":7,"SourceDataItemUID":1448,"Priority":0},{"CalculationSourceDataItemMappingUID":8,"CalculationUID":8,"SourceDataItemUID":1448,"Priority":0},{"CalculationSourceDataItemMappingUID":9,"CalculationUID":9,"SourceDataItemUID":1448,"Priority":0},{"CalculationSourceDataItemMappingUID":10,"CalculationUID":10,"SourceDataItemUID":1448,"Priority":0},{"CalculationSourceDataItemMappingUID":11,"CalculationUID":11,"SourceDataItemUID":1448,"Priority":0}],"DataItemType":[{"DataItemTypeUID":1,"Name":"DataSource"},{"DataItemTypeUID":2,"Name":"Dimension"},{"DataItemTypeUID":3,"Name":"Measure"}],"DataSources":[{"DataSourceUID":2,"Version":1,"DeployStateUID":0,"IsLocked":false,"IsDirty":false,"Id":"f40df100-dab3-4ef3-b0a2-ca396128d3ba","Name":"ds_CustomPSR","NodeName":"10.228.107.50","Port":8732,"ConnectionInfo":"","DataSourceType":"Microsoft SQL Server Database","LastUpdate_UTC":"2020-04-21T14:32:17.265651","Description":"Intelligence DataSource Object","SerializedTimeZone":"GMT Standard Time;0;(UTC+00:00) Dublin, Edinburgh, Lisbon, London;GMT Standard Time;GMT Daylight Time;[01:01:0001;12:31:9999;60;[0;01:00:00;3;5;0;];[0;02:00:00;10;5;0;];];","UseDaylightSavingTime":true}],"DataType":[{"DataTypeUID":0,"Name":"Boolean"},{"DataTypeUID":1,"Name":"Byte"},{"DataTypeUID":2,"Name":"DateTime"},{"DataTypeUID":3,"Name":"Decimal"},{"DataTypeUID":4,"Name":"Double"},{"DataTypeUID":5,"Name":"Guid"},{"DataTypeUID":6,"Name":"Int16"},{"DataTypeUID":7,"Name":"Int32"},{"DataTypeUID":8,"Name":"Int64"},{"DataTypeUID":9,"Name":"Other"},{"DataTypeUID":10,"Name":"String"}],"DeployStates":[{"DeployStateUID":0,"Name":"NotDeployed"},{"DeployStateUID":1,"Name":"Deployed"}],"DimensionAlias":[{"DimensionAliasUID":2,"Id":"246407e0-cb28-4704-815f-4b0030751009","MeasureDataItemUID":2,"MeasureDataItemVersion":1,"Alias":"FK_dim_Product_01","DimensionDataItemUID":2,"DimensionDataItemVersion":1,"ContextLink":true},{"DimensionAliasUID":3,"Id":"a8dda147-9f0b-4faa-8f72-abb5c33623bb","MeasureDataItemUID":2,"MeasureDataItemVersion":1,"Alias":"FK_dim_WorkOrder_01","DimensionDataItemUID":4,"DimensionDataItemVersion":1,"ContextLink":false},{"DimensionAliasUID":4,"Id":"8105ef5f-a2e5-4a7b-a3bc-d187cc12fb6a","MeasureDataItemUID":3,"MeasureDataItemVersion":1,"Alias":"FK_dim_Product_01","DimensionDataItemUID":2,"DimensionDataItemVersion":1,"ContextLink":true},{"DimensionAliasUID":5,"Id":"efe9536b-3066-4636-8d8b-1479c7ca7883","MeasureDataItemUID":3,"MeasureDataItemVersion":1,"Alias":"FK_dim_shift_01","DimensionDataItemUID":3,"DimensionDataItemVersion":1,"ContextLink":false},{"DimensionAliasUID":6,"Id":"9d573513-098d-4889-a2d6-e75ba29092cb","MeasureDataItemUID":3,"MeasureDataItemVersion":1,"Alias":"FK_dim_WorkOrder_01","DimensionDataItemUID":4,"DimensionDataItemVersion":1,"ContextLink":false}],"DimensionDataItems":[{"DimensionDataItemUID":2,"Version":1,"DeployStateUID":0,"IsLocked":false,"IsDirty":false,"Id":"2482be1f-ef59-42f8-ba70-684ce1e92716","Name":"dim_Product","Description":"Intelligence Dimension Object","RefreshRateInterval":1,"RefreshRateOffset":0,"RefreshRateUnit":"Day","TimeDefiningEnabled":false,"TimeDefiningType":null,"TimeDefiningStart_DimensionFieldUID":null,"TimeDefiningEnd_DimensionFieldUID":null,"TimeDefiningDuration_DimensionFieldUID":null,"TimeDefiningDuration_Constant":null,"TimeDefiningDuration_MappingTypeUID":null,"TimeDefiningDurationUnit":null,"FilterExpression":"","UpdatePeriodEnabled":false,"UpdatePeriodStartDate":null,"UpdatePeriodTime_DimensionFieldUID":null,"UpdatePeriodInterval":null,"UpdatePeriodUnit":null,"DeploymentTimestamp_UTC":null,"LastUpdate_UTC":"2017-11-06T11:57:39.6670683"},{"DimensionDataItemUID":3,"Version":1,"DeployStateUID":0,"IsLocked":false,"IsDirty":false,"Id":"914d1034-a991-4d23-b64e-1a5774c701df","Name":"dim_shift","Description":"Intelligence Dimension Object","RefreshRateInterval":20,"RefreshRateOffset":0,"RefreshRateUnit":"Minute","TimeDefiningEnabled":true,"TimeDefiningType":"StartEnd","TimeDefiningStart_DimensionFieldUID":8,"TimeDefiningEnd_DimensionFieldUID":9,"TimeDefiningDuration_DimensionFieldUID":null,"TimeDefiningDuration_Constant":null,"TimeDefiningDuration_MappingTypeUID":null,"TimeDefiningDurationUnit":null,"FilterExpression":"","UpdatePeriodEnabled":true,"UpdatePeriodStartDate":"2017-11-06T00:00:00","UpdatePeriodTime_DimensionFieldUID":8,"UpdatePeriodInterval":1,"UpdatePeriodUnit":"Day","DeploymentTimestamp_UTC":null,"LastUpdate_UTC":"2018-06-10T10:29:09.8277952"},{"DimensionDataItemUID":4,"Version":1,"DeployStateUID":0,"IsLocked":false,"IsDirty":false,"Id":"9e76a449-eb53-4966-bf78-05afa822c403","Name":"dim_WorkOrder","Description":"Intelligence Dimension Object","RefreshRateInterval":10,"RefreshRateOffset":0,"RefreshRateUnit":"Minute","TimeDefiningEnabled":true,"TimeDefiningType":"StartEnd","TimeDefiningStart_DimensionFieldUID":12,"TimeDefiningEnd_DimensionFieldUID":13,"TimeDefiningDuration_DimensionFieldUID":null,"TimeDefiningDuration_Constant":null,"TimeDefiningDuration_MappingTypeUID":null,"TimeDefiningDurationUnit":null,"FilterExpression":"","UpdatePeriodEnabled":true,"UpdatePeriodStartDate":"2017-11-06T00:00:00","UpdatePeriodTime_DimensionFieldUID":12,"UpdatePeriodInterval":1,"UpdatePeriodUnit":"Day","DeploymentTimestamp_UTC":null,"LastUpdate_UTC":"2018-06-10T10:29:22.1479001"}],"DimensionDataItemFields":[{"DimensionDataItemFieldUID":4,"Id":"d7071b13-1716-40c2-85e1-3ecce64fbb3f","DimensionDataItemUID":2,"DimensionDataItemVersion":1,"Name":"ProductId","FieldDataTypeUID":7,"Active":true,"KeyField":true},{"DimensionDataItemFieldUID":5,"Id":"dc4cffe6-5451-4243-863c-7f97c0d7093c","DimensionDataItemUID":2,"DimensionDataItemVersion":1,"Name":"Name","FieldDataTypeUID":10,"Active":true,"KeyField":false},{"DimensionDataItemFieldUID":6,"Id":"a737deed-48ef-4d98-93a7-8892ce093846","DimensionDataItemUID":2,"DimensionDataItemVersion":1,"Name":"DateEntered","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"DimensionDataItemFieldUID":7,"Id":"c9030228-f992-489d-8719-6011961b36fc","DimensionDataItemUID":3,"DimensionDataItemVersion":1,"Name":"ShiftId","FieldDataTypeUID":8,"Active":true,"KeyField":true},{"DimensionDataItemFieldUID":8,"Id":"5fa29c36-d867-4ffa-b8eb-23b0c04f9d59","DimensionDataItemUID":3,"DimensionDataItemVersion":1,"Name":"StartTime","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"DimensionDataItemFieldUID":9,"Id":"8c4d020d-e297-4494-9aa4-1d75893fc216","DimensionDataItemUID":3,"DimensionDataItemVersion":1,"Name":"EndTime","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"DimensionDataItemFieldUID":10,"Id":"e5bcbd94-c53c-4dea-942a-e2420a61320c","DimensionDataItemUID":3,"DimensionDataItemVersion":1,"Name":"DateEntered","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"DimensionDataItemFieldUID":11,"Id":"721ed332-3a03-42a7-b04a-e42779402562","DimensionDataItemUID":4,"DimensionDataItemVersion":1,"Name":"WorkOrderId","FieldDataTypeUID":8,"Active":true,"KeyField":true},{"DimensionDataItemFieldUID":12,"Id":"d4de2d71-9c0d-4fdf-b633-d211437d2ca0","DimensionDataItemUID":4,"DimensionDataItemVersion":1,"Name":"StartTime","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"DimensionDataItemFieldUID":13,"Id":"17a7c62e-b8d4-4a60-9490-c51e73fb3dbe","DimensionDataItemUID":4,"DimensionDataItemVersion":1,"Name":"EndTime","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"DimensionDataItemFieldUID":14,"Id":"7b187dc6-e574-4672-bb35-03015acbfcd0","DimensionDataItemUID":4,"DimensionDataItemVersion":1,"Name":"DateEntered","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"DimensionDataItemFieldUID":15,"Id":"89c0dd10-8a36-48a0-b391-f960666efe46","DimensionDataItemUID":4,"DimensionDataItemVersion":1,"Name":"ProductId","FieldDataTypeUID":7,"Active":true,"KeyField":false}],"DimensionDataItemFieldMappings":[{"DimensionDataItemFieldMappingUID":4,"DimensionDataItemFieldUID":4,"DimensionDataItemMappingUID":2,"FieldMappingTypeUID":0,"Constant":null,"DimensionFieldName":"ProductId","SourceDataItemFieldUID":25803},{"DimensionDataItemFieldMappingUID":5,"DimensionDataItemFieldUID":5,"DimensionDataItemMappingUID":2,"FieldMappingTypeUID":0,"Constant":null,"DimensionFieldName":"Name","SourceDataItemFieldUID":25806},{"DimensionDataItemFieldMappingUID":6,"DimensionDataItemFieldUID":6,"DimensionDataItemMappingUID":2,"FieldMappingTypeUID":0,"Constant":null,"DimensionFieldName":"DateEntered","SourceDataItemFieldUID":25796},{"DimensionDataItemFieldMappingUID":7,"DimensionDataItemFieldUID":7,"DimensionDataItemMappingUID":3,"FieldMappingTypeUID":0,"Constant":null,"DimensionFieldName":"ShiftId","SourceDataItemFieldUID":25804},{"DimensionDataItemFieldMappingUID":8,"DimensionDataItemFieldUID":8,"DimensionDataItemMappingUID":3,"FieldMappingTypeUID":0,"Constant":null,"DimensionFieldName":"StartTime","SourceDataItemFieldUID":25793},{"DimensionDataItemFieldMappingUID":9,"DimensionDataItemFieldUID":9,"DimensionDataItemMappingUID":3,"FieldMappingTypeUID":0,"Constant":null,"DimensionFieldName":"EndTime","SourceDataItemFieldUID":25794},{"DimensionDataItemFieldMappingUID":10,"DimensionDataItemFieldUID":10,"DimensionDataItemMappingUID":3,"FieldMappingTypeUID":0,"Constant":null,"DimensionFieldName":"DateEntered","SourceDataItemFieldUID":25795},{"DimensionDataItemFieldMappingUID":11,"DimensionDataItemFieldUID":11,"DimensionDataItemMappingUID":4,"FieldMappingTypeUID":0,"Constant":null,"DimensionFieldName":"WorkOrderId","SourceDataItemFieldUID":25805},{"DimensionDataItemFieldMappingUID":12,"DimensionDataItemFieldUID":12,"DimensionDataItemMappingUID":4,"FieldMappingTypeUID":0,"Constant":null,"DimensionFieldName":"StartTime","SourceDataItemFieldUID":25790},{"DimensionDataItemFieldMappingUID":13,"DimensionDataItemFieldUID":13,"DimensionDataItemMappingUID":4,"FieldMappingTypeUID":0,"Constant":null,"DimensionFieldName":"EndTime","SourceDataItemFieldUID":25791},{"DimensionDataItemFieldMappingUID":14,"DimensionDataItemFieldUID":14,"DimensionDataItemMappingUID":4,"FieldMappingTypeUID":0,"Constant":null,"DimensionFieldName":"DateEntered","SourceDataItemFieldUID":25792},{"DimensionDataItemFieldMappingUID":15,"DimensionDataItemFieldUID":15,"DimensionDataItemMappingUID":4,"FieldMappingTypeUID":0,"Constant":null,"DimensionFieldName":"ProductId","SourceDataItemFieldUID":25802}],"DimensionDataItemLinks":[{"DimensionDataItemLinkUID":1,"Id":"f4341a41-2920-459c-a126-11dd696029b7","Name":"FK_dim_WorkOrder_001","DimensionDataItemUID":4,"DimensionDataItemVersion":1,"LinkedDimensionDataItemUID":2,"LinkedDimensionDataItemVersion":1}],"DimensionDataItemLinkMappings":[{"DimensionDataItemLinkMappingUID":1,"DimensionDataItemLinkUID":1,"DimensionDataItemFieldUID":15,"LinkedDimensionDataItemFieldUID":4}],"DimensionDataItemMappings":[{"DimensionDataItemMappingUID":2,"DimensionDataItemUID":2,"DimensionDataItemVersion":1,"SourceDataItemUID":1444,"Priority":1},{"DimensionDataItemMappingUID":3,"DimensionDataItemUID":3,"DimensionDataItemVersion":1,"SourceDataItemUID":1446,"Priority":1},{"DimensionDataItemMappingUID":4,"DimensionDataItemUID":4,"DimensionDataItemVersion":1,"SourceDataItemUID":1445,"Priority":1}],"ExpressionCalculations":[],"MappingType":[{"MappingTypeUID":0,"Name":"SourceField"},{"MappingTypeUID":1,"Name":"Constant"},{"MappingTypeUID":2,"Name":"NULL"},{"MappingTypeUID":3,"Name":"Skip"},{"MappingTypeUID":4,"Name":"DimensionField"}],"MeasureDataItems":[{"MeasureDataItemUID":2,"Version":1,"DeployStateUID":0,"IsLocked":false,"IsDirty":false,"Id":"b527b290-3367-4520-93fb-980c48ad5ba6","Name":"fact_Production_Good","Description":"Intelligence Measure Object","RefreshRateOffset":0,"RefreshRateInterval":10,"RefreshRateStartDateTime":"2018-06-06T00:00:00","UsePeriodValues":true,"Period":10,"PeriodUnit":"Minute","RefreshRateUnit":"Minute","UpdatePeriod":10,"UpdatePeriodUnit":"Minute","ServerFileGroupEnabled":false,"ServerFileGroupName":null,"LastUpdate_UTC":"2018-06-10T03:34:10.064851"},{"MeasureDataItemUID":3,"Version":1,"DeployStateUID":0,"IsLocked":false,"IsDirty":false,"Id":"ea202643-c2c9-4aa4-8a23-3f1e55f3fd60","Name":"fact_ProductionBad","Description":"Intelligence Measure Object","RefreshRateOffset":0,"RefreshRateInterval":10,"RefreshRateStartDateTime":"2018-06-06T00:00:00","UsePeriodValues":true,"Period":10,"PeriodUnit":"Minute","RefreshRateUnit":"Minute","UpdatePeriod":10,"UpdatePeriodUnit":"Minute","ServerFileGroupEnabled":false,"ServerFileGroupName":null,"LastUpdate_UTC":"2018-06-10T03:32:40.0070257"}],"Relationships":[{"RelationshipUID":2,"CalculationUID":2,"DimensionAliasUID":6,"RelationshipDimensionReferenceUID":null,"RelationshipSourceMappingUID":null,"MapType":"Time"},{"RelationshipUID":3,"CalculationUID":2,"DimensionAliasUID":5,"RelationshipDimensionReferenceUID":null,"RelationshipSourceMappingUID":null,"MapType":"Time"},{"RelationshipUID":4,"CalculationUID":3,"DimensionAliasUID":6,"RelationshipDimensionReferenceUID":null,"RelationshipSourceMappingUID":null,"MapType":"Time"},{"RelationshipUID":5,"CalculationUID":3,"DimensionAliasUID":5,"RelationshipDimensionReferenceUID":null,"RelationshipSourceMappingUID":null,"MapType":"Time"},{"RelationshipUID":6,"CalculationUID":4,"DimensionAliasUID":6,"RelationshipDimensionReferenceUID":null,"RelationshipSourceMappingUID":null,"MapType":"Time"},{"RelationshipUID":7,"CalculationUID":4,"DimensionAliasUID":5,"RelationshipDimensionReferenceUID":null,"RelationshipSourceMappingUID":null,"MapType":"Time"},{"RelationshipUID":8,"CalculationUID":5,"DimensionAliasUID":6,"RelationshipDimensionReferenceUID":null,"RelationshipSourceMappingUID":null,"MapType":"Time"},{"RelationshipUID":9,"CalculationUID":5,"DimensionAliasUID":5,"RelationshipDimensionReferenceUID":null,"RelationshipSourceMappingUID":null,"MapType":"Time"},{"RelationshipUID":10,"CalculationUID":6,"DimensionAliasUID":6,"RelationshipDimensionReferenceUID":null,"RelationshipSourceMappingUID":null,"MapType":"Time"},{"RelationshipUID":11,"CalculationUID":6,"DimensionAliasUID":5,"RelationshipDimensionReferenceUID":null,"RelationshipSourceMappingUID":null,"MapType":"Time"},{"RelationshipUID":12,"CalculationUID":2,"DimensionAliasUID":4,"RelationshipDimensionReferenceUID":2,"RelationshipSourceMappingUID":2,"MapType":"Key"},{"RelationshipUID":13,"CalculationUID":3,"DimensionAliasUID":4,"RelationshipDimensionReferenceUID":3,"RelationshipSourceMappingUID":3,"MapType":"Key"},{"RelationshipUID":14,"CalculationUID":4,"DimensionAliasUID":4,"RelationshipDimensionReferenceUID":4,"RelationshipSourceMappingUID":4,"MapType":"Key"},{"RelationshipUID":15,"CalculationUID":5,"DimensionAliasUID":4,"RelationshipDimensionReferenceUID":5,"RelationshipSourceMappingUID":5,"MapType":"Key"},{"RelationshipUID":16,"CalculationUID":6,"DimensionAliasUID":4,"RelationshipDimensionReferenceUID":6,"RelationshipSourceMappingUID":6,"MapType":"Key"},{"RelationshipUID":17,"CalculationUID":7,"DimensionAliasUID":3,"RelationshipDimensionReferenceUID":null,"RelationshipSourceMappingUID":null,"MapType":"Time"},{"RelationshipUID":18,"CalculationUID":8,"DimensionAliasUID":3,"RelationshipDimensionReferenceUID":null,"RelationshipSourceMappingUID":null,"MapType":"Time"},{"RelationshipUID":19,"CalculationUID":9,"DimensionAliasUID":3,"RelationshipDimensionReferenceUID":null,"RelationshipSourceMappingUID":null,"MapType":"Time"},{"RelationshipUID":20,"CalculationUID":10,"DimensionAliasUID":3,"RelationshipDimensionReferenceUID":null,"RelationshipSourceMappingUID":null,"MapType":"Time"},{"RelationshipUID":21,"CalculationUID":11,"DimensionAliasUID":3,"RelationshipDimensionReferenceUID":null,"RelationshipSourceMappingUID":null,"MapType":"Time"},{"RelationshipUID":22,"CalculationUID":7,"DimensionAliasUID":2,"RelationshipDimensionReferenceUID":7,"RelationshipSourceMappingUID":7,"MapType":"Key"},{"RelationshipUID":23,"CalculationUID":8,"DimensionAliasUID":2,"RelationshipDimensionReferenceUID":8,"RelationshipSourceMappingUID":8,"MapType":"Key"},{"RelationshipUID":24,"CalculationUID":9,"DimensionAliasUID":2,"RelationshipDimensionReferenceUID":9,"RelationshipSourceMappingUID":9,"MapType":"Key"},{"RelationshipUID":25,"CalculationUID":10,"DimensionAliasUID":2,"RelationshipDimensionReferenceUID":10,"RelationshipSourceMappingUID":10,"MapType":"Key"},{"RelationshipUID":26,"CalculationUID":11,"DimensionAliasUID":2,"RelationshipDimensionReferenceUID":11,"RelationshipSourceMappingUID":11,"MapType":"Key"}],"RelationshipDimensionReferences":[{"RelationshipDimensionReferenceUID":2,"DimensionDataItemFieldUID":4,"DimensionDataItemLinkUID":null},{"RelationshipDimensionReferenceUID":3,"DimensionDataItemFieldUID":4,"DimensionDataItemLinkUID":null},{"RelationshipDimensionReferenceUID":4,"DimensionDataItemFieldUID":4,"DimensionDataItemLinkUID":null},{"RelationshipDimensionReferenceUID":5,"DimensionDataItemFieldUID":4,"DimensionDataItemLinkUID":null},{"RelationshipDimensionReferenceUID":6,"DimensionDataItemFieldUID":4,"DimensionDataItemLinkUID":null},{"RelationshipDimensionReferenceUID":7,"DimensionDataItemFieldUID":4,"DimensionDataItemLinkUID":null},{"RelationshipDimensionReferenceUID":8,"DimensionDataItemFieldUID":4,"DimensionDataItemLinkUID":null},{"RelationshipDimensionReferenceUID":9,"DimensionDataItemFieldUID":4,"DimensionDataItemLinkUID":null},{"RelationshipDimensionReferenceUID":10,"DimensionDataItemFieldUID":4,"DimensionDataItemLinkUID":null},{"RelationshipDimensionReferenceUID":11,"DimensionDataItemFieldUID":4,"DimensionDataItemLinkUID":null}],"RelationshipSourceMappings":[{"RelationshipSourceMappingUID":2,"SourceDataItemFieldUID":25807,"SourceDimensionAliasUID":null,"Constant":null},{"RelationshipSourceMappingUID":3,"SourceDataItemFieldUID":25807,"SourceDimensionAliasUID":null,"Constant":null},{"RelationshipSourceMappingUID":4,"SourceDataItemFieldUID":25807,"SourceDimensionAliasUID":null,"Constant":null},{"RelationshipSourceMappingUID":5,"SourceDataItemFieldUID":25807,"SourceDimensionAliasUID":null,"Constant":null},{"RelationshipSourceMappingUID":6,"SourceDataItemFieldUID":25807,"SourceDimensionAliasUID":null,"Constant":null},{"RelationshipSourceMappingUID":7,"SourceDataItemFieldUID":25808,"SourceDimensionAliasUID":null,"Constant":null},{"RelationshipSourceMappingUID":8,"SourceDataItemFieldUID":25808,"SourceDimensionAliasUID":null,"Constant":null},{"RelationshipSourceMappingUID":9,"SourceDataItemFieldUID":25808,"SourceDimensionAliasUID":null,"Constant":null},{"RelationshipSourceMappingUID":10,"SourceDataItemFieldUID":25808,"SourceDimensionAliasUID":null,"Constant":null},{"RelationshipSourceMappingUID":11,"SourceDataItemFieldUID":25808,"SourceDimensionAliasUID":null,"Constant":null}],"SourceDataItems":[{"SourceDataItemUID":1444,"DataSourceUID":2,"DataSourceVersion":1,"Id":"54446920-2c7c-4892-8f1f-711f88b271bc","Name":"[dbo].[v_Product]","Description":null,"Namespace":"dbo","ObjectName":"v_Product","IsCustomQuery":false,"CustomQuery":null,"DateEntered":"2017-11-06T11:56:23.0033696","DateModified":"2017-11-06T11:56:23.0033696"},{"SourceDataItemUID":1445,"DataSourceUID":2,"DataSourceVersion":1,"Id":"c7a49960-620f-4f09-9f55-0c3e776816b7","Name":"[dbo].[v_WorkOrder]","Description":null,"Namespace":"dbo","ObjectName":"v_WorkOrder","IsCustomQuery":false,"CustomQuery":null,"DateEntered":"2017-11-06T11:56:23.0163722","DateModified":"2017-11-06T11:56:23.0163722"},{"SourceDataItemUID":1446,"DataSourceUID":2,"DataSourceVersion":1,"Id":"ddc2727b-94bc-423e-96d9-cf569b1470e4","Name":"[dbo].[v_Shift]","Description":null,"Namespace":"dbo","ObjectName":"v_Shift","IsCustomQuery":false,"CustomQuery":null,"DateEntered":"2017-11-06T11:56:23.0373766","DateModified":"2017-11-06T11:56:23.0373766"},{"SourceDataItemUID":1447,"DataSourceUID":2,"DataSourceVersion":1,"Id":"fa892142-57fc-40f3-8808-7a0b589878e4","Name":"[dbo].[v_production_bad]","Description":null,"Namespace":"dbo","ObjectName":"v_production_bad","IsCustomQuery":false,"CustomQuery":null,"DateEntered":"2017-11-06T11:56:23.1043885","DateModified":"2017-11-06T11:56:23.1043885"},{"SourceDataItemUID":1448,"DataSourceUID":2,"DataSourceVersion":1,"Id":"05ae5079-e9dc-420c-9815-714215a158f7","Name":"[dbo].[v_production_good]","Description":null,"Namespace":"dbo","ObjectName":"v_production_good","IsCustomQuery":false,"CustomQuery":null,"DateEntered":"2017-11-06T11:56:23.1163912","DateModified":"2017-11-06T11:56:23.1163912"}],"SourceDataItemFields":[{"SourceDataItemFieldUID":25790,"SourceDataItemUID":1445,"Id":"7d94f12e-4047-463f-bdb1-ef10d432ab2a","Name":"StartTime","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25791,"SourceDataItemUID":1445,"Id":"28c13735-5230-499f-91e9-dd3bec7a1172","Name":"EndTime","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25792,"SourceDataItemUID":1445,"Id":"9ed88d71-c8a2-4b31-ba12-c5b134caaccd","Name":"DateEntered","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25793,"SourceDataItemUID":1446,"Id":"08d1c2a7-5084-4a0e-aac8-5308c4371f84","Name":"StartTime","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25794,"SourceDataItemUID":1446,"Id":"8ea4a2c1-0270-46bf-a966-215286b84ed9","Name":"EndTime","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25795,"SourceDataItemUID":1446,"Id":"dd0fb798-cde4-469e-8a17-a960a145d734","Name":"DateEntered","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25796,"SourceDataItemUID":1444,"Id":"5688e0e1-5c2b-4346-a8f8-bd5a2e95d126","Name":"DateEntered","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25797,"SourceDataItemUID":1447,"Id":"a560f4d5-2069-49ce-a356-229cd9c553a2","Name":"DateEntered","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25798,"SourceDataItemUID":1448,"Id":"cdd23012-e9b7-46cd-9289-5d84d698d788","Name":"DateEntered","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25799,"SourceDataItemUID":1448,"Id":"4643c468-5235-4731-83d5-799f85e244da","Name":"Count","FieldDataTypeUID":7,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25801,"SourceDataItemUID":1447,"Id":"8252ae6b-63a7-4a88-aa09-e9995b2a97f2","Name":"Calc_A","FieldDataTypeUID":7,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25802,"SourceDataItemUID":1445,"Id":"a32def88-9069-4604-8600-628a4d2e5805","Name":"ProductId","FieldDataTypeUID":7,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25803,"SourceDataItemUID":1444,"Id":"82c845d1-28d3-4882-8e74-227e8dded2c1","Name":"ProductId","FieldDataTypeUID":7,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25804,"SourceDataItemUID":1446,"Id":"8dc17938-8029-4dc9-8c05-aa13d50ac48d","Name":"ShiftId","FieldDataTypeUID":8,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25805,"SourceDataItemUID":1445,"Id":"6c47b0c6-8f3a-4de7-b99f-807da4c87562","Name":"WorkOrderId","FieldDataTypeUID":8,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25806,"SourceDataItemUID":1444,"Id":"ce066f78-b85c-496f-958a-ebd2f91aacb7","Name":"Name","FieldDataTypeUID":10,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25807,"SourceDataItemUID":1447,"Id":"8dc3cd12-4d25-41ef-961e-fdf33d117280","Name":"ProductId","FieldDataTypeUID":7,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":25808,"SourceDataItemUID":1448,"Id":"c8695005-1bf1-4620-8cbf-b76ff1c6d6c1","Name":"ProductId","FieldDataTypeUID":7,"Active":true,"KeyField":false}],"UserDefinedFunctionCalculations":[],"UserDefinedFunctionParameters":[]}