Multi-table support in Direct Discovery
ON THIS PAGE
Multi-table support in Direct Discovery
You can use Direct Discovery to load more than one table or view using
For example, you can link the tables loaded with Direct Discovery using either a Where clause or a Join clause.
- Direct Discovery can be deployed in a single fact/multi-dimension in memory scenario with large datasets.
- Direct Discovery can be used with more than one table which match any of the following criteria:
- The cardinality of the key field in the join is low.
The cardinality of the key field in the join is high, DirectEnableSubquery is set to true and all tables have been joined with Direct Discovery.
- Direct Discovery is not suitable for deployment in a Third Normal Form scenario with all tables in Direct Discovery form.
Linking Direct Discovery tables with a Where clause
In this example script, we load data from the database
Product_Join:
DIRECT QUERY
DIMENSION
[ProductID],
[AW2012].[Production].[Product].[Name] as [Product Name],
[AW2012].[Production].[ProductSubcategory].[Name] as [Sub Category Name],
Color,
[AW2012].[Production].[Product].ProductSubcategoryID as [SubcategoryID]
MEASURE
[ListPrice]
FROM [AW2012].[Production].[Product],
[AW2012].[Production].[ProductSubcategory]
WHERE [AW2012].[Production].[Product].ProductSubcategoryID =
[AW2012].[Production].[ProductSubcategory].ProductSubcategoryID ;
Linking Direct Discovery tables with Join On clauses
You can also use Join On clauses to link Direct Discovery tables. In this example statement we join the
In this example we create measures from the same logical table, which means we can use them in the same chart. For example, you can create a chart with