Database Reference
In-Depth Information
Figure 11-36.
Adding SQL code to the Edit Named Query dialog window
Clicking OK adds the derived members to the fact table. Now the data source view will display these
additional members, as shown in Figure
11-37
. When the cube is processed, the SQL statement that represents
the FactSales table will run and copy the new DerivedTotalPrice values to the SSAS cube folder.
