Virtual table parameters

Let us specify virtual table parameters.

  1. In the Tables list, click PricesSliceLast and then click the Virtual table parameters  button.
  2. Specify that the period is passed in the ReportDate parameter (fig. 13.86).

    Fig. 13.86. Virtual table parameters
  3. Select the following fields from the tables (fig. 13.87):
    • MaterialsAndTablesCat.Parent
    • MaterialsAndTablesCat.Ref
    • PricesSliceLast.Price

    13.87. Selected fields
Next page: Left join of tables