Analyzing query text

Let us analyze the generated query text (listing 13.10).

Listing 13.10. Query text

SELECT
    SalesTurnovers.Technician,
    SalesTurnovers.Period,
    SalesTurnovers.Customer,
    SalesTurnovers.RevenueTurnover AS Revenue
FROM
    AccumulationRegister.Sales.Turnovers( , , Day, ) AS SalesTurnovers

Note that in the query description the periodicity of data selected from the data source is set to Day (listing 13.11).

Listing 13.11. Specifying virtual table periodicity

FROM
    AccumulationRegister.Sales.Turnovers( , , Day, ) AS SalesTurnovers

This is why you can use the Period field in the selection.

Next page: Resources