[ROOT]  dt  FactInternetSale  SELECT%20SalesTerritory,%20DimCustomer.DimGeography.DimSalesTerritory.Name,%20DimSalesTerritory.Name  SKIP%200  TAKE 500  TITLE Demonstrate how foreign key DimSalesTerritoryId is not really needed in FactInternetSales  

ERROR:

At hierarhical level dt/FactInternetSale, key 'SELECT%20SalesTerritory,%20DimCustomer.DimGeography.DimSalesTerritory.Name,%20DimSalesTerritory.Name' not found

In case you attempted to supply a QueryExpression, this error message may be of help:

Start of query expression 'SELECT%20SALESTERRITORY,%20DIMCUSTOMER.DIMGEOGRAPHY.DIMSALESTERRITORY.NAME,%20DIMSALESTERRITORY.NAME' not recognized. Must start with one of

----, AGGREGATE, ALL, CACHE, COMMENT, DATASTORAGE, HINT, LIMIT, LOG, ORDER (as in (OrderBy), PIVOT, REL, SELECT, SELFCREATE, SHUFFLE, SKIP, STRICT, TAKE, THEN (as in (ThenBy), TITLE, WHERE


Use this link to see available keys at this level:

FactInternetSale

Edit


Generated 2024-03-28 09:42:02.958 UTC