Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: Cubes and Perspectives
| BASE_CUBE_NAME   | CATALOG_NAME                                            | SCHEMA_NAME   | CUBE_NAME                      | CUBE_TYPE   | CUBE_GUID   | CREATED_ON   | LAST_SCHEMA_UPDATE      | SCHEMA_UPDATED_BY   | LAST_DATA_UPDATE        | DATA_UPDATED_BY   | DESCRIPTION   | IS_DRILLTHROUGH_ENABLED   | IS_LINKABLE   | IS_WRITE_ENABLED   | IS_SQL_ENABLED   | CUBE_CAPTION                   |   CUBE_SOURCE |   PREFERRED_QUERY_PATTERNS | MultidimensionalOrTabular   | Cube                           | CatalogCubeID                                                                   | Cube or Perspective   | Schema Update Date      |
|:-----------------|:--------------------------------------------------------|:--------------|:-------------------------------|:------------|:------------|:-------------|:------------------------|:--------------------|:------------------------|:------------------|:--------------|:--------------------------|:--------------|:-------------------|:-----------------|:-------------------------------|--------------:|---------------------------:|:----------------------------|:-------------------------------|:--------------------------------------------------------------------------------|:----------------------|:------------------------|
|                  | Consolidated EDW Fixed Asset Cubes                      |               | Fixed Assets                   | CUBE        |             |              | 2015-12-14 11:11:14.000 |                     | 2016-07-06 08:25:25.000 |                   |               | True                      | True          | False              | True             | Fixed Assets                   |             1 |                          0 | Multidimensional            | Fixed Assets                   | Consolidated EDW Fixed Asset Cubes\Fixed Assets                                 | Cube                  | 2015-12-14 00:00:00.000 |
|                  | Consolidated EDW PL Finance Cubes                       |               | Global Ledger Entry            | CUBE        |             |              | 2016-12-20 10:48:36.000 |                     | 2017-09-27 06:00:27.000 |                   |               | True                      | True          | False              | True             | Global Ledger Entry            |             1 |                          0 | Multidimensional            | Global Ledger Entry            | Consolidated EDW PL Finance Cubes\Global Ledger Entry                           | Cube                  | 2016-12-20 00:00:00.000 |
|                  | Consolidated EDW Report and Cube Usage                  |               | Cube Usage                     | CUBE        |             |              | 2016-06-28 10:32:56.000 |                     | 2017-09-21 01:19:43.000 |                   |               | True                      | True          | False              | True             | Cube Usage                     |             1 |                          0 | Multidimensional            | Cube Usage                     | Consolidated EDW Report and Cube Usage\Cube Usage                               | Cube                  | 2016-06-28 00:00:00.000 |
|                  | Consolidated EDW Report and Cube Usage                  |               | Report Usage                   | CUBE        |             |              | 2016-06-28 10:32:55.000 |                     | 2017-09-21 01:14:04.000 |                   |               | True                      | True          | False              | True             | Report Usage                   |             1 |                          0 | Multidimensional            | Report Usage                   | Consolidated EDW Report and Cube Usage\Report Usage                             | Cube                  | 2016-06-28 00:00:00.000 |
|                  | OCH Consolidated Cubes POC                              |               | Purchases                      | CUBE        |             |              | 2015-11-09 11:33:44.000 |                     | 2015-11-20 09:48:30.000 |                   |               | True                      | True          | False              | True             | Purchases                      |             1 |                          0 | Multidimensional            | Purchases                      | OCH Consolidated Cubes POC\Purchases                                            | Cube                  | 2015-11-09 00:00:00.000 |
|                  | Ossur Consolidated EDW Cubes Orthopedics v2             |               | Consolidated Sales Orthopedics | CUBE        |             |              | 2014-12-29 10:12:03.000 |                     | 2017-09-24 04:37:41.000 |                   |               | True                      | True          | False              | True             | Consolidated Sales Orthopedics |             1 |                          0 | Multidimensional            | Consolidated Sales Orthopedics | Ossur Consolidated EDW Cubes Orthopedics v2\Consolidated Sales Orthopedics      | Cube                  | 2014-12-29 00:00:00.000 |
|                  | Ossur Consolidated EDW Customer Analysis Cubes          |               | ARSnapshot                     | CUBE        |             |              | 2017-08-22 13:29:15.000 |                     | 2017-09-27 01:38:56.000 |                   |               | True                      | True          | False              | True             | ARSnapshot                     |             1 |                          0 | Multidimensional            | ARSnapshot                     | Ossur Consolidated EDW Customer Analysis Cubes\ARSnapshot                       | Cube                  | 2017-08-22 00:00:00.000 |
|                  | Ossur Consolidated EDW Customer Analysis Cubes          |               | ARTransactions                 | CUBE        |             |              | 2017-08-22 13:29:15.000 |                     | 2017-09-27 01:38:27.000 |                   |               | True                      | True          | False              | True             | ARTransactions                 |             1 |                          0 | Multidimensional            | ARTransactions                 | Ossur Consolidated EDW Customer Analysis Cubes\ARTransactions                   | Cube                  | 2017-08-22 00:00:00.000 |
|                  | Ossur Consolidated EDW Product Rationalization Cubes v2 |               | Product Rationalization        | CUBE        |             |              | 2016-05-24 15:08:45.000 |                     | 2016-06-02 07:33:30.000 |                   |               | True                      | True          | False              | True             | Product Rationalization        |             1 |                          0 | Multidimensional            | Product Rationalization        | Ossur Consolidated EDW Product Rationalization Cubes v2\Product Rationalization | Cube                  | 2016-05-24 00:00:00.000 |
|                  | Ossur Consolidated EDW Product Services Cubes v1        |               | Product Services               | CUBE        |             |              | 2015-12-04 15:55:07.000 |                     | 2016-10-04 11:06:27.000 |                   |               | True                      | True          | False              | True             | Product Services               |             1 |                          0 | Multidimensional            | Product Services               | Ossur Consolidated EDW Product Services Cubes v1\Product Services               | Cube                  | 2015-12-04 00:00:00.000 |


Table: Datasources
| CATALOG_NAME                                            | SCHEMA_NAME   | DATASOURCE_NAME       | DATASOURCE_TYPE   | CREATED_ON              | LAST_SCHEMA_UPDATE      | DESCRIPTION   |   TIMEOUT | DBMS_NAME            | DBMS_VERSION   |
|:--------------------------------------------------------|:--------------|:----------------------|:------------------|:------------------------|:------------------------|:--------------|----------:|:---------------------|:---------------|
| Consolidated EDW Fixed Asset Cubes                      |               | EDW                   | Relational        | 2015-12-14 11:11:14.000 | 2015-12-14 11:11:14.000 |               |         0 | Microsoft SQL Server | 13.00.4451     |
| Consolidated EDW PL Finance Cubes                       |               | EDW                   | Relational        | 2016-05-23 12:55:30.000 | 2016-12-20 10:48:36.000 |               |         0 | Microsoft SQL Server | 13.00.4451     |
| Consolidated EDW Report and Cube Usage                  |               | SSASQueryLogAnalyzer  | Relational        | 2016-06-28 10:32:55.000 | 2016-06-28 10:34:42.000 |               |         0 | Microsoft SQL Server | 13.00.4451     |
| ILSSCI                                                  |               | ILSSCI                | Relational        | 2009-01-21 18:58:59.000 | 2015-05-07 14:41:29.000 |               |         0 | Microsoft SQL Server | 13.00.4451     |
| OCH Consolidated Cubes POC                              |               | EDW                   | Relational        | 2015-09-17 13:45:58.000 | 2015-11-09 11:33:44.000 |               |         0 | Microsoft SQL Server | 13.00.4451     |
| OCH Consolidated Cubes POC                              |               | OBIHistorical         | Relational        | 2015-09-17 13:45:58.000 | 2015-11-09 11:33:44.000 |               |         0 | Microsoft SQL Server | 13.00.4451     |
| Ossur Consolidated EDW Customer Analysis Cubes          |               | EDW                   | Relational        | 2016-06-27 15:31:28.000 | 2017-08-22 13:29:14.000 |               |         0 | Microsoft SQL Server | 13.00.4451     |
| Ossur Consolidated EDW Product Rationalization Cubes v2 |               | EDW                   | Relational        | 2016-01-12 13:40:14.000 | 2016-05-24 15:08:44.000 |               |         0 | Microsoft SQL Server | 13.00.4451     |
| Ossur Consolidated EDW Product Rationalization Cubes v2 |               | OBI Sandbox Reporting | Relational        | 2016-05-24 14:30:05.000 | 2016-05-24 15:08:44.000 |               |         0 | Microsoft SQL Server | 13.00.4451     |
| Ossur Consolidated EDW Product Services Cubes v1        |               | EDW                   | Relational        | 2014-12-19 11:50:11.000 | 2015-07-06 09:03:32.000 |               |         0 | Microsoft SQL Server | 13.00.4451     |


Table: Dimension Attributes
| DATABASE          | FOLDER   | VISIBLE   | CUBE_NAME   | DIMENSION_UNIQUE_NAME   | HIERARCHY_CAPTION   |   HIERARCHY_CARDINALITY | DESCRIPTION   | CatalogCubeDimensionID              |
|:------------------|:---------|:----------|:------------|:------------------------|:--------------------|------------------------:|:--------------|:------------------------------------|
| AllValueEntry5802 |          | True      | Model       | [vwdimTime]             | RollingMonthName    |                       0 |               | AllValueEntry5802\Model\[vwdimTime] |
| AllValueEntry5802 |          | True      | Model       | [vwdimTime]             | RollingDayName      |                       0 |               | AllValueEntry5802\Model\[vwdimTime] |
| AllValueEntry5802 |          | True      | Model       | [vwdimTime]             | QuarterNameOnly     |                       0 |               | AllValueEntry5802\Model\[vwdimTime] |
| AllValueEntry5802 |          | True      | Model       | [vwdimTime]             | Quarter             |                       0 |               | AllValueEntry5802\Model\[vwdimTime] |
| AllValueEntry5802 |          | True      | Model       | [vwdimTime]             | PriorQuarter-3      |                       0 |               | AllValueEntry5802\Model\[vwdimTime] |
| AllValueEntry5802 |          | True      | Model       | [vwdimTime]             | PriorQuarter-2      |                       0 |               | AllValueEntry5802\Model\[vwdimTime] |
| AllValueEntry5802 |          | True      | Model       | [vwdimTime]             | PriorQuarter        |                       0 |               | AllValueEntry5802\Model\[vwdimTime] |
| AllValueEntry5802 |          | True      | Model       | [vwdimTime]             | PriorMonth-2        |                       0 |               | AllValueEntry5802\Model\[vwdimTime] |
| AllValueEntry5802 |          | True      | Model       | [vwdimTime]             | PriorMonth-1        |                       0 |               | AllValueEntry5802\Model\[vwdimTime] |
| AllValueEntry5802 |          | True      | Model       | [vwdimTime]             | PriorMonth          |                       0 |               | AllValueEntry5802\Model\[vwdimTime] |


Table: Dimensions Members Hierarchies
| LEVEL_IS_VISIBLE   | CATALOG_NAME   | LEVEL_NAME            | LEVEL_ORDERING_PROPERTY   | CUBE_NAME   | DIMENSION_UNIQUE_NAME   | LEVEL_CAPTION         |   LEVEL_NUMBER | HIERARCHY_UNIQUE_NAME                 | LEVEL_NAME_SQL_COLUMN_NAME                     | LEVEL_KEY_SQL_COLUMN_NAME                     |   LEVEL_ORIGIN | DESCRIPTION   | SCHEMA_NAME   | LEVEL_UNIQUE_NAME                                             | LEVEL_GUID   |   LEVEL_CARDINALITY |   LEVEL_TYPE |   CUSTOM_ROLLUP_SETTINGS |   LEVEL_UNIQUE_SETTINGS |   LEVEL_DBTYPE | LEVEL_MASTER_UNIQUE_NAME   | LEVEL_UNIQUE_NAME_SQL_COLUMN_NAME                    | LEVEL_ATTRIBUTE_HIERARCHY_NAME   |   LEVEL_KEY_CARDINALITY | CatalogCubeDimensionID    |   IsHierarchy |   IsAttribute |   IsKey | Attribute Type   |
|:-------------------|:---------------|:----------------------|:--------------------------|:------------|:------------------------|:----------------------|---------------:|:--------------------------------------|:-----------------------------------------------|:----------------------------------------------|---------------:|:--------------|:--------------|:--------------------------------------------------------------|:-------------|--------------------:|-------------:|-------------------------:|------------------------:|---------------:|:---------------------------|:-----------------------------------------------------|:---------------------------------|------------------------:|:--------------------------|--------------:|--------------:|--------:|:-----------------|
| True               | TB_v3          | Account Chain         | Account Chain             | Model       | [dimCustomer]           | Account Chain         |              1 | [dimCustomer].[Account Chain]         | NAME( [$dimCustomer].[Account Chain] )         | KEY( [$dimCustomer].[Account Chain] )         |              2 |               |               | [dimCustomer].[Account Chain].[Account Chain]                 |              |                   0 |            0 |                        0 |                       0 |            130 |                            | UNIQUENAME( [$dimCustomer].[Account Chain] )         | Account Chain                    |                       1 | TB_v3\Model\[dimCustomer] |             0 |             1 |       0 |                  |
| True               | TB_v3          | Address 2             | Address 2                 | Model       | [dimCustomer]           | Address 2             |              1 | [dimCustomer].[Address 2]             | NAME( [$dimCustomer].[Address 2] )             | KEY( [$dimCustomer].[Address 2] )             |              2 |               |               | [dimCustomer].[Address 2].[Address 2]                         |              |                   0 |            0 |                        0 |                       0 |            130 |                            | UNIQUENAME( [$dimCustomer].[Address 2] )             | Address 2                        |                       1 | TB_v3\Model\[dimCustomer] |             0 |             1 |       0 |                  |
| True               | TB_v3          | Address               | Address                   | Model       | [dimCustomer]           | Address               |              1 | [dimCustomer].[Address]               | NAME( [$dimCustomer].[Address] )               | KEY( [$dimCustomer].[Address] )               |              2 |               |               | [dimCustomer].[Address].[Address]                             |              |                   0 |            0 |                        0 |                       0 |            130 |                            | UNIQUENAME( [$dimCustomer].[Address] )               | Address                          |                       1 | TB_v3\Model\[dimCustomer] |             0 |             1 |       0 |                  |
| True               | TB_v3          | Approved Count        | Approved Count            | Model       | [dimCustomer]           | Approved Count        |              1 | [dimCustomer].[Approved Count]        | NAME( [$dimCustomer].[Approved Count] )        | KEY( [$dimCustomer].[Approved Count] )        |              2 |               |               | [dimCustomer].[Approved Count].[Approved Count]               |              |                   0 |            0 |                        0 |                       0 |            130 |                            | UNIQUENAME( [$dimCustomer].[Approved Count] )        | Approved Count                   |                       1 | TB_v3\Model\[dimCustomer] |             0 |             1 |       0 |                  |
| True               | TB_v3          | Bill To NAV Code      | Bill To NAV Code          | Model       | [dimCustomer]           | Bill To NAV Code      |              1 | [dimCustomer].[Bill To NAV Code]      | NAME( [$dimCustomer].[Bill To NAV Code] )      | KEY( [$dimCustomer].[Bill To NAV Code] )      |              2 |               |               | [dimCustomer].[Bill To NAV Code].[Bill To NAV Code]           |              |                   0 |            0 |                        0 |                       0 |            130 |                            | UNIQUENAME( [$dimCustomer].[Bill To NAV Code] )      | Bill To NAV Code                 |                       1 | TB_v3\Model\[dimCustomer] |             0 |             1 |       0 |                  |
| True               | TB_v3          | Buying Group          | Buying Group              | Model       | [dimCustomer]           | Buying Group          |              1 | [dimCustomer].[Buying Group]          | NAME( [$dimCustomer].[Buying Group] )          | KEY( [$dimCustomer].[Buying Group] )          |              2 |               |               | [dimCustomer].[Buying Group].[Buying Group]                   |              |                   0 |            0 |                        0 |                       0 |            130 |                            | UNIQUENAME( [$dimCustomer].[Buying Group] )          | Buying Group                     |                       1 | TB_v3\Model\[dimCustomer] |             0 |             1 |       0 |                  |
| True               | TB_v3          | City                  | City                      | Model       | [dimCustomer]           | City                  |              1 | [dimCustomer].[City]                  | NAME( [$dimCustomer].[City] )                  | KEY( [$dimCustomer].[City] )                  |              2 |               |               | [dimCustomer].[City].[City]                                   |              |                   0 |            0 |                        0 |                       0 |            130 |                            | UNIQUENAME( [$dimCustomer].[City] )                  | City                             |                       1 | TB_v3\Model\[dimCustomer] |             0 |             1 |       0 |                  |
| True               | TB_v3          | CM_PartyCategory_Name | CM_PartyCategory_Name     | Model       | [dimCustomer]           | CM_PartyCategory_Name |              1 | [dimCustomer].[CM_PartyCategory_Name] | NAME( [$dimCustomer].[CM_PartyCategory_Name] ) | KEY( [$dimCustomer].[CM_PartyCategory_Name] ) |              2 |               |               | [dimCustomer].[CM_PartyCategory_Name].[CM_PartyCategory_Name] |              |                   0 |            0 |                        0 |                       0 |            130 |                            | UNIQUENAME( [$dimCustomer].[CM_PartyCategory_Name] ) | CM_PartyCategory_Name            |                       1 | TB_v3\Model\[dimCustomer] |             0 |             1 |       0 |                  |
| True               | TB_v3          | CM_SalesRegion_Code   | CM_SalesRegion_Code       | Model       | [dimCustomer]           | CM_SalesRegion_Code   |              1 | [dimCustomer].[CM_SalesRegion_Code]   | NAME( [$dimCustomer].[CM_SalesRegion_Code] )   | KEY( [$dimCustomer].[CM_SalesRegion_Code] )   |              2 |               |               | [dimCustomer].[CM_SalesRegion_Code].[CM_SalesRegion_Code]     |              |                   0 |            0 |                        0 |                       0 |            130 |                            | UNIQUENAME( [$dimCustomer].[CM_SalesRegion_Code] )   | CM_SalesRegion_Code              |                       1 | TB_v3\Model\[dimCustomer] |             0 |             1 |       0 |                  |
| True               | TB_v3          | CM_SalesRegion_Name   | CM_SalesRegion_Name       | Model       | [dimCustomer]           | CM_SalesRegion_Name   |              1 | [dimCustomer].[CM_SalesRegion_Name]   | NAME( [$dimCustomer].[CM_SalesRegion_Name] )   | KEY( [$dimCustomer].[CM_SalesRegion_Name] )   |              2 |               |               | [dimCustomer].[CM_SalesRegion_Name].[CM_SalesRegion_Name]     |              |                   0 |            0 |                        0 |                       0 |            130 |                            | UNIQUENAME( [$dimCustomer].[CM_SalesRegion_Name] )   | CM_SalesRegion_Name              |                       1 | TB_v3\Model\[dimCustomer] |             0 |             1 |       0 |                  |


Table: Dimensions
| CATALOG_NAME                                   | CUBE_NAME                            | DIMENSION_NAME         | DIMENSION_UNIQUE_NAME    | DIMENSION_CAPTION      |   DIMENSION_ORDINAL |   DIMENSION_CARDINALITY | DEFAULT_HIERARCHY                       | DESCRIPTION   | DIMENSION_IS_VISIBLE   | DIMENSION_MASTER_NAME   | SCHEMA_NAME   | DIMENSION_GUID   |   DIMENSION_TYPE | IS_VIRTUAL   | IS_READWRITE   |   DIMENSION_UNIQUE_SETTINGS | CatalogCubeID                                                                | CatalogCubeDimensionID                                                                      |
|:-----------------------------------------------|:-------------------------------------|:-----------------------|:-------------------------|:-----------------------|--------------------:|------------------------:|:----------------------------------------|:--------------|:-----------------------|:------------------------|:--------------|:-----------------|-----------------:|:-------------|:---------------|----------------------------:|:-----------------------------------------------------------------------------|:--------------------------------------------------------------------------------------------|
| Ossur Consolidated EDW Customer Analysis Cubes | ARTransactions                       | Currency LCY Dimension | [Currency LCY Dimension] | Currency LCY Dimension |                   7 |                      34 | [Currency LCY Dimension].[Currency LCY] |               | True                   | Dim Currency LCY        |               |                  |                3 | False        | False          |                           1 | Ossur Consolidated EDW Customer Analysis Cubes\ARTransactions                | Ossur Consolidated EDW Customer Analysis Cubes\ARTransactions\[Currency LCY Dimension]      |
| Ossur Consolidated EDW Customer Analysis Cubes | ARTransactions                       | Currency SCY Dimension | [Currency SCY Dimension] | Currency SCY Dimension |                   6 |                      34 | [Currency SCY Dimension].[Currency SCY] |               | True                   | Dim Currency SCY        |               |                  |                3 | False        | False          |                           1 | Ossur Consolidated EDW Customer Analysis Cubes\ARTransactions                | Ossur Consolidated EDW Customer Analysis Cubes\ARTransactions\[Currency SCY Dimension]      |
| Ossur Consolidated EDW Finance Cubes v3        | Global Ledger Entry                  | Currency LCY           | [Currency LCY]           | Currency LCY           |                   6 |                      34 | [Currency LCY].[Currency LCY]           |               | True                   | Dim Currency LCY        |               |                  |                3 | False        | False          |                           1 | Ossur Consolidated EDW Finance Cubes v3\Global Ledger Entry                  | Ossur Consolidated EDW Finance Cubes v3\Global Ledger Entry\[Currency LCY]                  |
| Ossur Consolidated EDW Finance Cubes v3        | Global Ledger Entry                  | Currency SCY           | [Currency SCY]           | Currency SCY           |                   8 |                      34 | [Currency SCY].[Currency SCY]           |               | True                   | Dim Currency SCY        |               |                  |                3 | False        | False          |                           1 | Ossur Consolidated EDW Finance Cubes v3\Global Ledger Entry                  | Ossur Consolidated EDW Finance Cubes v3\Global Ledger Entry\[Currency SCY]                  |
| Ossur Consolidated EDW Finance Cubes v3        | Bank Account                         | Dim Currency ACY       | [Dim Currency ACY]       | Dim Currency ACY       |                   4 |                      34 | [Dim Currency ACY].[Currency ACY]       |               | True                   | Dim Currency ACY        |               |                  |                3 | False        | False          |                           1 | Ossur Consolidated EDW Finance Cubes v3\Bank Account                         | Ossur Consolidated EDW Finance Cubes v3\Bank Account\[Dim Currency ACY]                     |
| Ossur Consolidated EDW Finance Cubes v3        | Currency Rates                       | Currency               | [Currency]               | Currency               |                   2 |                      34 | [Currency].[Currency Numberic Code]     |               | True                   | Dim Currency            |               |                  |                3 | False        | False          |                           1 | Ossur Consolidated EDW Finance Cubes v3\Currency Rates                       | Ossur Consolidated EDW Finance Cubes v3\Currency Rates\[Currency]                           |
| Ossur Consolidated EDW Finance Cubes v3        | Global Ledger Entry  R and D         | Currency LCY           | [Currency LCY]           | Currency LCY           |                   6 |                      34 | [Currency LCY].[Currency LCY]           |               | True                   | Dim Currency LCY        |               |                  |                3 | False        | False          |                           1 | Ossur Consolidated EDW Finance Cubes v3\Global Ledger Entry  R and D         | Ossur Consolidated EDW Finance Cubes v3\Global Ledger Entry  R and D\[Currency LCY]         |
| Ossur Consolidated EDW Finance Cubes v3        | Global Ledger Entry  R and D         | Currency SCY           | [Currency SCY]           | Currency SCY           |                   8 |                      34 | [Currency SCY].[Currency SCY]           |               | True                   | Dim Currency SCY        |               |                  |                3 | False        | False          |                           1 | Ossur Consolidated EDW Finance Cubes v3\Global Ledger Entry  R and D         | Ossur Consolidated EDW Finance Cubes v3\Global Ledger Entry  R and D\[Currency SCY]         |
| Ossur Consolidated EDW Finance Cubes v3        | Global Ledger Entry Finance Americas | Currency LCY           | [Currency LCY]           | Currency LCY           |                   6 |                      34 | [Currency LCY].[Currency LCY]           |               | True                   | Dim Currency LCY        |               |                  |                3 | False        | False          |                           1 | Ossur Consolidated EDW Finance Cubes v3\Global Ledger Entry Finance Americas | Ossur Consolidated EDW Finance Cubes v3\Global Ledger Entry Finance Americas\[Currency LCY] |
| Ossur Consolidated EDW Finance Cubes v3        | Global Ledger Entry Finance Americas | Currency SCY           | [Currency SCY]           | Currency SCY           |                   8 |                      34 | [Currency SCY].[Currency SCY]           |               | True                   | Dim Currency SCY        |               |                  |                3 | False        | False          |                           1 | Ossur Consolidated EDW Finance Cubes v3\Global Ledger Entry Finance Americas | Ossur Consolidated EDW Finance Cubes v3\Global Ledger Entry Finance Americas\[Currency SCY] |


Table: dna Catalogs
| CATALOG_NAME                                          |
|:------------------------------------------------------|
| AllValueEntry5802                                     |
| Consolidated EDW Fixed Asset Cubes                    |
| Consolidated EDW PL Finance Cubes                     |
| Consolidated EDW Report and Cube Usage                |
| CustomerHierarchy                                     |
| ILSSCI                                                |
| JobHistory                                            |
| JobHistoryTest                                        |
| Medi_agunnarsson_9ba0a39e-7644-4e5f-8b51-977465fa2dbc |
| MediFinance                                           |


Table: Measure Groups And Dimensions
| CATALOG_NAME                            | CUBE_NAME           | MEASUREGROUP_NAME   | MEASUREGROUP_CARDINALITY   | DIMENSION_UNIQUE_NAME    | DIMENSION_CARDINALITY   | DIMENSION_IS_FACT_DIMENSION   | DIMENSION_GRANULARITY                                    | DIMENSION_MASTER_NAME          |   Relationship | CatalogCubeID                                               | CatalogCubeDimensionID                                                               |   Is Fact | Relationship Type   | DIMENSION_NAME         |
|:----------------------------------------|:--------------------|:--------------------|:---------------------------|:-------------------------|:------------------------|:------------------------------|:---------------------------------------------------------|:-------------------------------|---------------:|:------------------------------------------------------------|:-------------------------------------------------------------------------------------|----------:|:--------------------|:-----------------------|
| Ossur Consolidated EDW Finance Cubes v4 | Global Ledger Entry | Ledger Entry        | ONE                        | [Account Admin]          | MANY                    | False                         | [Account Admin].[Dim Account Id]                         | Dim Account 4                  |              1 | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry\[Account Admin]          |         0 | R                   | Account Admin          |
| Ossur Consolidated EDW Finance Cubes v4 | Global Ledger Entry | Ledger Entry        | ONE                        | [Account Controller Map] | MANY                    | False                         | [Account Controller Map].[Dim Account Controller Map Id] | Dim Account Controller Mapping |              1 | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry\[Account Controller Map] |         0 | R                   | Account Controller Map |
| Ossur Consolidated EDW Finance Cubes v4 | Global Ledger Entry | Ledger Entry        | ONE                        | [Account CPA]            | MANY                    | False                         | [Account CPA].[dimAccountId]                             | Dim Account 2                  |              1 | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry\[Account CPA]            |         0 | R                   | Account CPA            |
| Ossur Consolidated EDW Finance Cubes v4 | Global Ledger Entry | Ledger Entry        | ONE                        | [Account FR]             | MANY                    | False                         | [Account FR].[Dim Account FR Id]                         | Dim Account FR                 |              1 | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry\[Account FR]             |         0 | R                   | Account FR             |
| Ossur Consolidated EDW Finance Cubes v4 | Global Ledger Entry | Ledger Entry        | ONE                        | [Account MO Iceland]     | MANY                    | False                         | [Account MO Iceland].[Dim Account Id]                    | Dim Account 6                  |              1 | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry\[Account MO Iceland]     |         0 | R                   | Account MO Iceland     |
| Ossur Consolidated EDW Finance Cubes v4 | Global Ledger Entry | Ledger Entry        | ONE                        | [Account RD]             | MANY                    | False                         | [Account RD].[dimAccountId]                              | Dim Account 3                  |              1 | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry\[Account RD]             |         0 | R                   | Account RD             |
| Ossur Consolidated EDW Finance Cubes v4 | Global Ledger Entry | Ledger Entry        | ONE                        | [Account SM]             | MANY                    | False                         | [Account SM].[Dim Account Id]                            | Dim Account 5                  |              1 | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry\[Account SM]             |         0 | R                   | Account SM             |
| Ossur Consolidated EDW Finance Cubes v4 | Global Ledger Entry | Ledger Entry        | ONE                        | [Account]                | MANY                    | False                         | [Account].[dimAccountId]                                 | Dim Account                    |              1 | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry\[Account]                |         0 | R                   | Account                |
| Ossur Consolidated EDW Finance Cubes v4 | Global Ledger Entry | Ledger Entry        | ONE                        | [Currency LCY]           | MANY                    | False                         | [Currency LCY].[Currency LCY]                            | Dim Currency LCY               |              1 | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry\[Currency LCY]           |         0 | R                   | Currency LCY           |
| Ossur Consolidated EDW Finance Cubes v4 | Global Ledger Entry | Ledger Entry        | ONE                        | [Currency SCY]           | MANY                    | False                         | [Currency SCY].[Currency SCY]                            | Dim Currency SCY               |              1 | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry | Ossur Consolidated EDW Finance Cubes v4\Global Ledger Entry\[Currency SCY]           |         0 | R                   | Currency SCY           |


Table: Measures And Calculated Members
| MEASURE_DISPLAY_FOLDER   | MEASURE_IS_VISIBLE   | EXPRESSION   | DEFAULT_FORMAT_STRING   |   MEASURE_AGGREGATOR | CATALOG_NAME                                 | SCHEMA_NAME   | CUBE_NAME    | MEASURE_NAME                                      | MEASURE_UNIQUE_NAME                                            | MEASURE_CAPTION                                   | MEASURE_GUID   |   DATA_TYPE |   NUMERIC_PRECISION |   NUMERIC_SCALE | MEASURE_UNITS   | DESCRIPTION   | LEVELS_LIST   | MEASURE_NAME_SQL_COLUMN_NAME                      | MEASURE_UNQUALIFIED_CAPTION                       | MEASUREGROUP_NAME   | CatalogCubeMeasureGroupID                                                | CatalogCubeID                                             | Calculated Measure   |
|:-------------------------|:---------------------|:-------------|:------------------------|---------------------:|:---------------------------------------------|:--------------|:-------------|:--------------------------------------------------|:---------------------------------------------------------------|:--------------------------------------------------|:---------------|------------:|--------------------:|----------------:|:----------------|:--------------|:--------------|:--------------------------------------------------|:--------------------------------------------------|:--------------------|:-------------------------------------------------------------------------|:----------------------------------------------------------|:---------------------|
|                          | False                |              | #,#                     |                    1 | Ossur Consolidated EDW Gross Profit Cubes v2 |               | Gross Profit | Invoice Current Gross Profit 2 SCY                | [Measures].[Invoice Current Gross Profit 2 SCY]                | Invoice Current Gross Profit 2 SCY                |                |           5 |                  16 |              -1 |                 |               |               | Invoice Current Gross Profit 2 SCY                | Invoice Current Gross Profit 2 SCY                | Sales Invoices      | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit\Sales Invoices | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit | Measure              |
|                          | True                 |              | #,#                     |                    1 | Ossur Consolidated EDW Gross Profit Cubes v2 |               | Gross Profit | Invoice Current Gross Profit 2 SCY Fixed Rate AUD | [Measures].[Invoice Current Gross Profit 2 SCY Fixed Rate AUD] | Invoice Current Gross Profit 2 SCY Fixed Rate AUD |                |           5 |                  16 |              -1 |                 |               |               | Invoice Current Gross Profit 2 SCY Fixed Rate AUD | Invoice Current Gross Profit 2 SCY Fixed Rate AUD | Sales Invoices      | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit\Sales Invoices | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit | Measure              |
|                          | True                 |              | #,#                     |                    1 | Ossur Consolidated EDW Gross Profit Cubes v2 |               | Gross Profit | Invoice Current Gross Profit 2 SCY Fixed Rate EUR | [Measures].[Invoice Current Gross Profit 2 SCY Fixed Rate EUR] | Invoice Current Gross Profit 2 SCY Fixed Rate EUR |                |           5 |                  16 |              -1 |                 |               |               | Invoice Current Gross Profit 2 SCY Fixed Rate EUR | Invoice Current Gross Profit 2 SCY Fixed Rate EUR | Sales Invoices      | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit\Sales Invoices | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit | Measure              |
|                          | True                 |              | #,#                     |                    1 | Ossur Consolidated EDW Gross Profit Cubes v2 |               | Gross Profit | Invoice Current Gross Profit 2 SCY Fixed Rate GBP | [Measures].[Invoice Current Gross Profit 2 SCY Fixed Rate GBP] | Invoice Current Gross Profit 2 SCY Fixed Rate GBP |                |           5 |                  16 |              -1 |                 |               |               | Invoice Current Gross Profit 2 SCY Fixed Rate GBP | Invoice Current Gross Profit 2 SCY Fixed Rate GBP | Sales Invoices      | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit\Sales Invoices | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit | Measure              |
|                          | True                 |              | #,#                     |                    1 | Ossur Consolidated EDW Gross Profit Cubes v2 |               | Gross Profit | Invoice Current Gross Profit 2 SCY Fixed Rate SEK | [Measures].[Invoice Current Gross Profit 2 SCY Fixed Rate SEK] | Invoice Current Gross Profit 2 SCY Fixed Rate SEK |                |           5 |                  16 |              -1 |                 |               |               | Invoice Current Gross Profit 2 SCY Fixed Rate SEK | Invoice Current Gross Profit 2 SCY Fixed Rate SEK | Sales Invoices      | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit\Sales Invoices | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit | Measure              |
|                          | True                 |              | #,#                     |                    1 | Ossur Consolidated EDW Gross Profit Cubes v2 |               | Gross Profit | Invoice Current Gross Profit 2 SCY Fixed Rate USD | [Measures].[Invoice Current Gross Profit 2 SCY Fixed Rate USD] | Invoice Current Gross Profit 2 SCY Fixed Rate USD |                |           5 |                  16 |              -1 |                 |               |               | Invoice Current Gross Profit 2 SCY Fixed Rate USD | Invoice Current Gross Profit 2 SCY Fixed Rate USD | Sales Invoices      | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit\Sales Invoices | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit | Measure              |
|                          | True                 |              | #,#                     |                    1 | Ossur Consolidated EDW Gross Profit Cubes v2 |               | Gross Profit | Invoice Current Gross Profit 2 SCY Fixed Rate ZAR | [Measures].[Invoice Current Gross Profit 2 SCY Fixed Rate ZAR] | Invoice Current Gross Profit 2 SCY Fixed Rate ZAR |                |           5 |                  16 |              -1 |                 |               |               | Invoice Current Gross Profit 2 SCY Fixed Rate ZAR | Invoice Current Gross Profit 2 SCY Fixed Rate ZAR | Sales Invoices      | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit\Sales Invoices | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit | Measure              |
|                          | False                |              | #,#                     |                    1 | Ossur Consolidated EDW Gross Profit Cubes v2 |               | Gross Profit | Invoice Current Gross Profit 3 SCY                | [Measures].[Invoice Current Gross Profit 3 SCY]                | Invoice Current Gross Profit 3 SCY                |                |           5 |                  16 |              -1 |                 |               |               | Invoice Current Gross Profit 3 SCY                | Invoice Current Gross Profit 3 SCY                | Sales Invoices      | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit\Sales Invoices | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit | Measure              |
|                          | False                |              | #,#                     |                    1 | Ossur Consolidated EDW Gross Profit Cubes v2 |               | Gross Profit | Invoice Gross Profit 2 SCY                        | [Measures].[Invoice Gross Profit 2 SCY]                        | Invoice Gross Profit 2 SCY                        |                |           5 |                  16 |              -1 |                 |               |               | Invoice Gross Profit 2 SCY                        | Invoice Gross Profit 2 SCY                        | Sales Invoices      | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit\Sales Invoices | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit | Measure              |
|                          | True                 |              | #,#                     |                    1 | Ossur Consolidated EDW Gross Profit Cubes v2 |               | Gross Profit | Invoice Gross Profit 3 LCY EMEA Fixed Rate in USD | [Measures].[Invoice Gross Profit 3 LCY EMEA Fixed Rate in USD] | Invoice Gross Profit 3 LCY EMEA Fixed Rate in USD |                |           5 |                  16 |              -1 |                 |               |               | Invoice Gross Profit 3 LCY EMEA Fixed Rate in USD | Invoice Gross Profit 3 LCY EMEA Fixed Rate in USD | Sales Invoices      | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit\Sales Invoices | Ossur Consolidated EDW Gross Profit Cubes v2\Gross Profit | Measure              |


Table: Measures Groups
| CATALOG_NAME                    | CUBE_NAME                       | MEASUREGROUP_NAME                | DESCRIPTION   | IS_WRITE_ENABLED   | CatalogCubeID                                                   | CatalogCubeMeasureGroupID                                                                        |
|:--------------------------------|:--------------------------------|:---------------------------------|:--------------|:-------------------|:----------------------------------------------------------------|:-------------------------------------------------------------------------------------------------|
| Ossur Consolidated EDW Cubes v3 | $Dim Country                    | Dim CountryMG                    |               | False              | Ossur Consolidated EDW Cubes v3\$Dim Country                    | Ossur Consolidated EDW Cubes v3\$Dim Country\Dim CountryMG                                       |
| Ossur Consolidated EDW Cubes v3 | $Dim Currency LCY               | Dim Currency LCYMG               |               | False              | Ossur Consolidated EDW Cubes v3\$Dim Currency LCY               | Ossur Consolidated EDW Cubes v3\$Dim Currency LCY\Dim Currency LCYMG                             |
| Ossur Consolidated EDW Cubes v3 | $Dim Currency PCY               | Dim Currency PCYMG               |               | False              | Ossur Consolidated EDW Cubes v3\$Dim Currency PCY               | Ossur Consolidated EDW Cubes v3\$Dim Currency PCY\Dim Currency PCYMG                             |
| Ossur Consolidated EDW Cubes v3 | $Dim Currency SCY               | Dim Currency SCYMG               |               | False              | Ossur Consolidated EDW Cubes v3\$Dim Currency SCY               | Ossur Consolidated EDW Cubes v3\$Dim Currency SCY\Dim Currency SCYMG                             |
| Ossur Consolidated EDW Cubes v3 | $Dim Customer                   | Dim CustomerMG                   |               | False              | Ossur Consolidated EDW Cubes v3\$Dim Customer                   | Ossur Consolidated EDW Cubes v3\$Dim Customer\Dim CustomerMG                                     |
| Ossur Consolidated EDW Cubes v3 | $Dim Day Id Contract Lead Date  | Dim Day Id Contract Lead DateMG  |               | False              | Ossur Consolidated EDW Cubes v3\$Dim Day Id Contract Lead Date  | Ossur Consolidated EDW Cubes v3\$Dim Day Id Contract Lead Date\Dim Day Id Contract Lead DateMG   |
| Ossur Consolidated EDW Cubes v3 | $Dim Day Id First Shipment Date | Dim Day Id First Shipment DateMG |               | False              | Ossur Consolidated EDW Cubes v3\$Dim Day Id First Shipment Date | Ossur Consolidated EDW Cubes v3\$Dim Day Id First Shipment Date\Dim Day Id First Shipment DateMG |
| Ossur Consolidated EDW Cubes v3 | $Dim Day Id Last Count Date     | Dim Day Id Last Count DateMG     |               | False              | Ossur Consolidated EDW Cubes v3\$Dim Day Id Last Count Date     | Ossur Consolidated EDW Cubes v3\$Dim Day Id Last Count Date\Dim Day Id Last Count DateMG         |
| Ossur Consolidated EDW Cubes v3 | $Dim Day Id Next Count Date     | Dim Day Id Next Count DateMG     |               | False              | Ossur Consolidated EDW Cubes v3\$Dim Day Id Next Count Date     | Ossur Consolidated EDW Cubes v3\$Dim Day Id Next Count Date\Dim Day Id Next Count DateMG         |
| Ossur Consolidated EDW Cubes v3 | $Dim Day Id Order Date          | Dim Day Id Order DateMG          |               | False              | Ossur Consolidated EDW Cubes v3\$Dim Day Id Order Date          | Ossur Consolidated EDW Cubes v3\$Dim Day Id Order Date\Dim Day Id Order DateMG                   |

 


tables: name: Cubes and Perspectives
data: Cubes and Perspectives.csv
name: Datasources
data: Datasources.csv
name: Dimension Attributes
data: Dimension Attributes.csv
name: Dimensions Members Hierarchies
data: Dimensions Members Hierarchies.csv
name: Dimensions
data: Dimensions.csv
name: dna Catalogs
data: dna Catalogs.csv
name: Measure Groups And Dimensions
data: Measure Groups And Dimensions.csv
name: Measures And Calculated Members
data: Measures And Calculated Members.csv
name: Measures Groups
data: Measures Groups.csv
label: Dimensions
CatalogCubeID
Cubes and Perspectives
CatalogCubeID
Measures Groups
CatalogCubeID
Cubes and Perspectives
CatalogCubeID
Dimensions Members Hierarchies
CatalogCubeDimensionID
Dimensions
CatalogCubeDimensionID
Dimension Attributes
CatalogCubeDimensionID
Dimensions
CatalogCubeDimensionID
Cubes and Perspectives
CATALOG_NAME
dna Catalogs
CATALOG_NAME
Datasources
CATALOG_NAME
dna Catalogs
CATALOG_NAME
Measures And Calculated Members
CatalogCubeID
Cubes and Perspectives
CatalogCubeID
Measure Groups And Dimensions
CatalogCubeDimensionID
Dimensions
CatalogCubeDimensionID
output: {
    "joins": [
        {
            "from_table": "Dimensions",
            "from_column": "CatalogCubeID",
            "to_table": "Cubes and Perspectives",
            "to_column": "CatalogCubeID"
        },
        {
            "from_table": "Measures Groups",
            "from_column": "CatalogCubeID",
            "to_table": "Cubes and Perspectives",
            "to_column": "CatalogCubeID"
        },
        {
            "from_table": "Dimensions Members Hierarchies",
            "from_column": "CatalogCubeDimensionID",
            "to_table": "Dimensions",
            "to_column": "CatalogCubeDimensionID"
        },
        {
            "from_table": "Dimension Attributes",
            "from_column": "CatalogCubeDimensionID",
            "to_table": "Dimensions",
            "to_column": "CatalogCubeDimensionID"
        },
        {
            "from_table": "Cubes and Perspectives",
            "from_column": "CATALOG_NAME",
            "to_table": "dna Catalogs",
            "to_column": "CATALOG_NAME"
        },
        {
            "from_table": "Datasources",
            "from_column": "CATALOG_NAME",
            "to_table": "dna Catalogs",
            "to_column": "CATALOG_NAME"
        },
        {
            "from_table": "Measures And Calculated Members",
            "from_column": "CatalogCubeID",
            "to_table": "Cubes and Perspectives",
            "to_column": "CatalogCubeID"
        },
        {
            "from_table": "Measure Groups And Dimensions",
            "from_column": "CatalogCubeDimensionID",
            "to_table": "Dimensions",
            "to_column": "CatalogCubeDimensionID"
        }
    ]
}