BI Automation Level Indicator

This topic contains information about the logic used to calculate the automation level indicator for Tableau to target cloud platform conversion.

Tableau Conversion

Automation level indicator provides the extent of automation coverage for converting Tableau to target cloud platform.

Automation Level Indicator of each file = (((Successful Charts +(Partially Successful Charts* Weightage of Charts With Todo))* Weightage of Charts + Successful Visual Objects * Weightage of Visual Objects (Sets, Groups, Parameters) + Successful Calculations * Weightage of Plain/Nested Calculations + Successful Quick Table Calculations * Weightage of Quick Table Calculations + Successful Table Calculations * Weightage of Table Calculations + Successful LOD Calculations * Weightage of Level of Detail(LOD) Calculations + Successful Filters * Weightage of Filters + Successful Actions * Weightage of Actions + Successful Transformed SQLs * Weightage of Custom SQL + Successful DataModels * Weightage of DataModels*IF(Successful Relationships=0, 1, Successful Relationships)) / (No. of Charts * Weightage of Charts + Visual Objects (Sets, Groups, Parameters) * Weightage of Visual Objects (Sets, Groups, Parameters) + Plain/Nested Calculations * Weightage of Plain/Nested Calculations + Quick Table Calculations * Weightage of Quick Table Calculations + Table Calculations * Weightage of Table Calculations + LOD Calculations * Weightage of Level of Detail(LOD) Calculations + Filters * Weightage of Filters + Actions * Weightage of Actions + Custom SQLs * Weightage of Custom SQL + DataModels * Weightage of DataModels *IF(Relationships=0, 1, Relationships))) * 100

where,

Successful Charts: Number of successfully converted charts.
Partially Successful Charts: Number of converted charts with ToDo message.
Weightage of Charts With Todo: Default weightage assigned to a chart with ToDo message.
Weightage of Charts: Default weightage assigned to a chart.
Successful Visual Objects: Number of successfully converted visual objects such as sets, groups, parameters.
Weightage of Visual Objects (Sets, Groups, Parameters): Default weightage assigned to visual objects such as sets, groups, parameters.
Successful Calculations: Number of successfully converted calculations.
Weightage of Plain/Nested Calculations: Default weightage assigned to the calculations.
Successful Quick Table Calculations: Number of successfully converted quick table calculations.
Weightage of Quick Table Calculations: Default weightage assigned to quick table calculations.
Successful Table Calculations: Number of successfully converted table calculations.
Weightage of Table Calculations: Default weightage assigned to table calculations.
Successful LOD Calculations: Number of successfully converted LOD calculations.
Weightage of Level of Detail (LOD) Calculations: Default weightage assigned to LOD calculations.
Successful Filters: Number of successfully converted filters.
Weightage of Filters: Default weightage assigned to filters.
Successful Actions: Number of successfully converted actions.
Weightage of Actions: Default weightage assigned to actions.
Successful Transformed SQLs: Number of successfully converted SQLs.
Weightage of Custom SQL: Default weightage assigned to SQLs.
Successful DataModels: Number of successfully converted data models.
Weightage of DataModels: Default weightage assigned to data models.
Successful Relationships: Number of successful relationships in datamodel.
No of Charts: Total number of charts.
Visual Objects (Sets, Groups, Parameters): Total number of visual objects such as sets, groups, parameters.
Plain/Nested Calculations: Total number of plain or nested calculations.
Quick Table Calculations: Total number of quick table calculations.
Table Calculations: Total number of table calculations.
LOD Calculations: Total number of LOD calculations.
Filters: Total number of filters.
Actions: Total number of actions.
Custom SQLs: Total number of custom SQLs.
DataModels: Total number of data models.

Note:

The default weightage of Charts with ToDo message is 0.9 (configurable).
If the number of relationships in datamodel is zero, then you need to add 1 in the Relationships field.