Embed Size (px)
Citation preview
•
•
•
SELECT
EnglishProductCategoryName,
ProductCategoryKey
FROM
DimProductCategory
SELECT
EnglishProductCategoryName,
ProductCategoryKey
FROM
DimProductCategory
WHERE
ProductCategoryKey IN [@Categoria]
SELECT
ProductCategoryKey,
ProductSubcategoryKey,
EnglishProductSubcategoryName
FROM
DimProductSubcategory
SELECT
categoria.EnglishProductCategoryName,
subcategoria.ProductSubcategoryKey,
subcategoria.EnglishProductSubcategoryName,
categoria.ProductCategoryKey
FROM
DimProductCategory as categoria
INNER JOIN DimProductSubcategory as subcategoria
ON categoria.ProductCategoryKey =
subcategoria.ProductCategoryKey
SELECT
ProductCategoryKey,
ProductSubcategoryKey,
EnglishProductSubcategoryName
FROM
DimProductSubcategory
WHERE
ProductCategoryKey IN [@Categoria]
SELECT
categoria.EnglishProductCategoryName,
subcategoria.ProductSubcategoryKey,
subcategoria.EnglishProductSubcategoryName,
categoria.ProductCategoryKey
FROM
DimProductCategory as categoria
INNER JOIN DimProductSubcategory as subcategoria
ON categoria.ProductCategoryKey =
subcategoria.ProductCategoryKey
WHERE
categoria.ProductCategoryKey IN [@Categoria]
AND subcategoria.ProductSubcategoryKey IN
[@Subcategoria]
Más Videotutoriales y Manuales sobre Power BI:
