Release notes: BI Module - ETL Connector

Introduction

Perfect Gym offers a Business Intelligence Module subscription. ETL Connector is an add-on to the BI module. With this functionality, you can freely customize your reports. Data can be extracted to your very own data warehouse which provides great flexibility for creating reports and joining data from different sources.

This article describes changes added to the data scope available through the ETL Connector.
This article is dedicated to PG Champions and Data Analysts who would like to understand BI capabilities

Before you start

If you want to learn more about the data scope of the ETL Connector, make sure you're familiar with the article BI Module - ETL Connector: Data Scope.

Feature description

Changes in v105

This section contains a list of changes introduced with 1.05 ETL connector

Adding new table DimTaxRate

Table	Column	Description	Datatype
DimTaxRate	TaxRateKey	This is PK of table	bigint
DimTaxRate	TaxId	TaxId	bigint
DimTaxRate	DateFrom	tax rate start date	date
DimTaxRate	DateTo	tax rate end date	date
DimTaxRate	ValueType	Value or percentage	nvarchar
DimTaxRate	ValueType	Value or percentage	sysname
DimTaxRate	Value	Value	decimal
DimTaxRate	IsDeleted	if it is deleted	bit
DimTaxRate	InAllClubs	if it is in all clubs	bit
DimTaxRate	MetaJobId	NULL	bigint
DimTaxRate	MetaDateInserted	NULL	datetime
DimTaxRate	MetaDateUpdated	NULL	datetime

Adding new table DimProductTax

Table	Column	Description	Datatype
DimProductTax	ProductTaxKey	This is PK of table	bigint
DimProductTax	ProductKey	PK to DimProduct	int
DimProductTax	TaxId	Technical column with taxid	bigint
DimProductTax	TaxName	Name of tax	nvarchar
DimProductTax	TaxName	Name of tax	sysname
DimProductTax	IsDeleted	If tax is deleted	bit
DimProductTax	MetaJobId	NULL	bigint
DimProductTax	MetaDateInserted	NULL	datetime
DimProductTax	MetaDateUpdated	NULL	datetime

Adding new table DimCustomerTransactionType

Table	Column	Description	Datatype
DimCustomerTransactionType	CustomerTransactionTypeKey	This is PK of table	bigint
DimCustomerTransactionType	CustomerTransactionTypeName	Name of Customer Transaction Type	nvarchar
DimCustomerTransactionType	CustomerTransactionTypeName	Name of Customer Transaction Type	sysname
DimCustomerTransactionType	CustomerTransactionTypeCode	Code	nvarchar
DimCustomerTransactionType	CustomerTransactionTypeCode	Code	sysname
DimCustomerTransactionType	IsDeleted	NULL	bit
DimCustomerTransactionType	IsVat	Id type is Vat related	bit
DimCustomerTransactionType	IsDebitSide	If type is debit	bit
DimCustomerTransactionType	AccountingCode	Accounting Code	nvarchar
DimCustomerTransactionType	AccountingCode	Accounting Code	sysname

Other changes:

Renaming column UserTransactionTypeId in table FactCustomerTransaction to CustomerTransactionTypeKey

It became FK to DimCustomerTransactionType

Adding new columns to table DictDebtors

ContractKey FK to DimContract
AmountToSettle Amount to settle by debtor

Changes in v1.04

Adding new table DimState

DimState	StateKey	Private Key of this table	int
DimState	SateId	NULL	bigint
DimState	StateNativeName	NULL	nvarchar
DimState	StateNativeName	NULL	sysname
DimState	StateEnglishName	NULL	nvarchar
DimState	StateEnglishName	NULL	sysname
DimState	StateSymbol	NULL	nvarchar
DimState	StateSymbol	NULL	sysname
DimState	MetaJobId	NULL	bigint
DimState	MetaDateInserted	NULL	datetime
DimState	MetaDateUpdated	NULL	datetime

Reports