Exporting 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":"2021-01-21T05:53:25.8884867"},{"SettingUID":2,"Name":"Schema.Version","Value":"3.5.0","DateEntered_UTC":"2021-01-21T06:27:33.5066039"},{"SettingUID":3,"Name":"PurgeEventLogRefreshIntervalInMinutes","Value":"1440","DateEntered_UTC":"2021-01-21T06:27:38.0868721"},{"SettingUID":4,"Name":"EventLogRetentionPeriodInDays","Value":"7","DateEntered_UTC":"2021-01-21T06:27:38.0878724"},{"SettingUID":5,"Name":"ErrorEventLogEnabled","Value":"1","DateEntered_UTC":"2021-01-21T06:27:38.0888801"},{"SettingUID":6,"Name":"WarningEventLogEnabled","Value":"1","DateEntered_UTC":"2021-01-21T06:27:38.0898736"},{"SettingUID":7,"Name":"TraceEventLogEnabled","Value":"0","DateEntered_UTC":"2021-01-21T06:27:38.0898736"},{"SettingUID":8,"Name":"InfoEventLogEnabled","Value":"1","DateEntered_UTC":"2021-01-21T06:27:38.0909202"},{"SettingUID":9,"Name":"CustomEventLogEnabled","Value":"0","DateEntered_UTC":"2021-01-21T06:27:38.0918744"}],"Calculations":[{"CalculationUID":1,"Id":"cf0ddf00-3ea0-4b29-8317-aa347edc6f7a","MeasureDataItemUID":1,"MeasureDataItemVersion":1,"Name":"Calculation_001","Function":"Count","FunctionFieldMapping_MappingTypeUID":0,"FunctionFieldMapping_SourceFieldName":"StateType","PeriodFieldMapping_MappingTypeUID":0,"PeriodFieldMapping_SourceFieldName":"LastModified","ModificationPeriodFieldMapping_MappingTypeUID":0,"ModificationPeriodFieldMapping_SourceFieldName":"<None>","ModificationPeriodInterval":null,"ModificationPeriodUnit":null,"ReturnDataTypeUID":7,"FilterExpression":null}],"CalculationSourceDataItemMappings":[{"CalculationSourceDataItemMappingUID":1,"CalculationUID":1,"SourceDataItemUID":3,"Priority":0}],"DataItemType":[{"DataItemTypeUID":1,"Name":"DataSource"},{"DataItemTypeUID":2,"Name":"Dimension"},{"DataItemTypeUID":3,"Name":"Measure"}],"DataSources":[{"DataSourceUID":1,"Version":1,"DeployStateUID":0,"IsDirty":false,"Id":"74f2fc22-04bc-4437-81c7-03de1866a84f","Name":"DataSource_001","NodeName":"TEST2016","Port":8732,"ConnectionInfo":"","DataSourceType":"Online Insight","LastUpdate_UTC":"2021-01-21T08:50:13.3989843","Description":"AVEVA BI Gateway DataSource Object","SerializedTimeZone":"UTC;0;(UTC) Coordinated Universal Time;Coordinated Universal Time;Coordinated Universal Time;;","UseDaylightSavingTime":false}],"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":1,"Id":"18293812-384a-4aea-96fe-13e4ba518632","MeasureDataItemUID":1,"MeasureDataItemVersion":1,"Alias":"FK_Dimension_001_01","DimensionDataItemUID":1,"DimensionDataItemVersion":1,"ContextLink":false}],"DimensionDataItems":[{"DimensionDataItemUID":1,"Version":1,"DeployStateUID":0,"IsDirty":false,"Id":"56550d78-da8a-41c5-ad41-de609376625c","Name":"Dimension_001","Description":"AVEVA BI Gateway 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":null,"UpdatePeriodEnabled":false,"UpdatePeriodStartDate":null,"UpdatePeriodTime_DimensionFieldUID":null,"UpdatePeriodInterval":null,"UpdatePeriodUnit":null,"DeploymentTimestamp_UTC":null,"LastUpdate_UTC":"2021-01-21T08:51:37.5180329"}],"DimensionDataItemFields":[{"DimensionDataItemFieldUID":1,"Id":"c5601b6a-21ff-4812-8a76-94f19da023ee","DimensionDataItemUID":1,"DimensionDataItemVersion":1,"Name":"Id","FieldDataTypeUID":10,"Active":true,"KeyField":true},{"DimensionDataItemFieldUID":2,"Id":"451b382c-4431-4ff6-a0a4-db6ad14c0361","DimensionDataItemUID":1,"DimensionDataItemVersion":1,"Name":"Name","FieldDataTypeUID":10,"Active":true,"KeyField":false},{"DimensionDataItemFieldUID":3,"Id":"a20b71e1-ce90-4a6e-b08f-a1b7be7c0409","DimensionDataItemUID":1,"DimensionDataItemVersion":1,"Name":"DisableDate","FieldDataTypeUID":2,"Active":true,"KeyField":false}],"DimensionDataItemFieldMappings":[{"DimensionDataItemFieldMappingUID":1,"DimensionDataItemFieldUID":1,"DimensionDataItemMappingUID":1,"FieldMappingTypeUID":0,"Constant":null,"DimensionFieldName":"Id","SourceDataItemFieldUID":22},{"DimensionDataItemFieldMappingUID":2,"DimensionDataItemFieldUID":2,"DimensionDataItemMappingUID":1,"FieldMappingTypeUID":0,"Constant":null,"DimensionFieldName":"Name","SourceDataItemFieldUID":17},{"DimensionDataItemFieldMappingUID":3,"DimensionDataItemFieldUID":3,"DimensionDataItemMappingUID":1,"FieldMappingTypeUID":0,"Constant":null,"DimensionFieldName":"DisableDate","SourceDataItemFieldUID":21}],"DimensionDataItemLinks":[],"DimensionDataItemLinkMappings":[],"DimensionDataItemMappings":[{"DimensionDataItemMappingUID":1,"DimensionDataItemUID":1,"DimensionDataItemVersion":1,"SourceDataItemUID":3,"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":1,"Version":1,"DeployStateUID":0,"IsDirty":false,"Id":"c9aaba5a-e97e-403c-805f-41363dda8756","Name":"Measure_001","Description":"AVEVA BI Gateway Measure Object","RefreshRateOffset":0,"RefreshRateInterval":1,"RefreshRateStartDateTime":"2021-01-21T00:00:00","UsePeriodValues":true,"Period":1,"PeriodUnit":"Hour","RefreshRateUnit":"Day","UpdatePeriod":1,"UpdatePeriodUnit":"Day","ServerFileGroupEnabled":false,"ServerFileGroupName":null,"LastUpdate_UTC":"2021-01-21T00:54:30.7434626"}],"Relationships":[{"RelationshipUID":1,"CalculationUID":1,"DimensionAliasUID":1,"RelationshipDimensionReferenceUID":1,"RelationshipSourceMappingUID":1,"MapType":"Key"}],"RelationshipDimensionReferences":[{"RelationshipDimensionReferenceUID":1,"DimensionDataItemFieldUID":1,"DimensionDataItemLinkUID":null}],"RelationshipSourceMappings":[{"RelationshipSourceMappingUID":1,"SourceDataItemFieldUID":22,"SourceDimensionAliasUID":null,"Constant":null}],"SourceDataItems":[{"SourceDataItemUID":3,"DataSourceUID":1,"DataSourceVersion":1,"Id":"ef8b6eda-b3b4-4063-b387-6b2358708af3","Name":"CustomQuery_001","Description":null,"Namespace":null,"ObjectName":null,"IsCustomQuery":true,"CustomQuery":"{\n\"QueryName\":\"EquipmentStates\",\n\"SelectColumn\":[\"*\"]\n}","DateEntered":"2021-01-21T08:51:23.4341864","DateModified":"2021-01-21T08:51:23.4341864"}],"SourceDataItemFields":[{"SourceDataItemFieldUID":17,"SourceDataItemUID":3,"Id":"f6e7da6a-85e2-4fcc-af6f-2872d508b138","Name":"Name","FieldDataTypeUID":10,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":18,"SourceDataItemUID":3,"Id":"bdf1ec1a-d28d-4eae-a9ae-88bf102eb4db","Name":"Description","FieldDataTypeUID":10,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":19,"SourceDataItemUID":3,"Id":"00b5b4c0-1310-4f13-92e9-292b62b8dc9c","Name":"Color","FieldDataTypeUID":10,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":20,"SourceDataItemUID":3,"Id":"225f10ae-4324-43a0-9500-075c12fc4a2b","Name":"StateType","FieldDataTypeUID":7,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":21,"SourceDataItemUID":3,"Id":"a18ac442-b728-4a4e-a6a4-8aaeb64633dc","Name":"DisableDate","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":22,"SourceDataItemUID":3,"Id":"837abce8-3527-436e-8538-dddefd10cf45","Name":"Id","FieldDataTypeUID":10,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":23,"SourceDataItemUID":3,"Id":"4704cbc1-73be-451b-8912-d170f8208c19","Name":"LastModified","FieldDataTypeUID":2,"Active":true,"KeyField":false},{"SourceDataItemFieldUID":24,"SourceDataItemUID":3,"Id":"181cacf6-6d46-4850-b2f5-e74d0f1de694","Name":"_etag","FieldDataTypeUID":10,"Active":true,"KeyField":false}],"UserDefinedFunctionCalculations":[],"UserDefinedFunctionParameters":[]}