Database Reference
In-Depth Information
3. Nowclickon Run... tostart theprocessingofthedatabase andalltheobjects
in it.
When the processing has finished in the processing window, you will see a message
that shows you the status of all the steps that was executed. If you expand them to
see the duration of the execution and if you drill further, you can see the command
that was sent down to the relational source. As an example, you can see that the fol-
lowing command was sent down to the database when the Fact Internet Sales
measure group was processed:
SELECT
[dbo_FactInternetSales].[dbo_FactInternetSalesSalesAmount0_0]
AS
[dbo_FactInternetSalesSalesAmount0_0],[dbo_FactInternetSales].[dbo_FactInternetSales0_1]
AS
[dbo_FactInternetSales0_1],[dbo_FactInternetSales].[dbo_FactInternetSalesOrderDateKey0_2]
AS
[dbo_FactInternetSalesOrderDateKey0_2],[dbo_FactInternetSales].[dbo_FactInternetSalesShipDateKey0_3]
AS
[dbo_FactInternetSalesShipDateKey0_3],[dbo_FactInternetSales].[dbo_FactInternetSalesDueDateKey0_4]
AS
[dbo_FactInternetSalesDueDateKey0_4],[dbo_FactInternetSales].[dbo_FactInternetSalesProductKey0_5]
AS
[dbo_FactInternetSalesProductKey0_5],[dbo_FactInternetSales].[dbo_FactInternetSalesCustomerKey0_6]
AS
[dbo_FactInternetSalesCustomerKey0_6],[dbo_FactInternetSales].[dbo_FactInternetSalesPromotionKey0_7]
AS
[dbo_FactInternetSalesPromotionKey0_7],[dbo_FactInternetSales].[dbo_FactInternetSalesSalesTerritoryKey0_8]
AS [dbo_FactInternetSalesSalesTerritoryKey0_8]
FROM
(
SELECT [SalesAmount] AS
[dbo_FactInternetSalesSalesAmount0_0],1 AS
[dbo_FactInternetSales0_1],[OrderDateKey] AS
[dbo_FactInternetSalesOrderDateKey0_2],[ShipDateKey]
AS
Search WWH ::




Custom Search