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 |