我有这个事实表：

CREATE TABLE FACTPRODUCTSALES (
    TRANSACTIONID      NUMBER
        GENERATED ALWAYS AS IDENTITY ( START WITH 1 INCREMENT BY 1 )
    PRIMARY KEY,
    SALESINVOICENUMBER INT NOT NULL,
    SALESDATEKEY       NUMBER CONSTRAINT SALES_KEY_FK REFERENCES DIMDATE (DATEKEY),
    SALESTIMEKEY       NUMBER CONSTRAINT SALESTIME_KEY_FK REFERENCES DIM_TIME (TIMEKEY),
    STOREID            NUMBER NOT NULL CONSTRAINT STORE_ID_FK REFERENCES DIMSTORES (STOREID),
    CUSTOMERID         NUMBER NOT NULL CONSTRAINT CUSTOMER_ID_FK REFERENCES DIMCUSTOMER (CUSTOMERID),
    PRODUCTID          NUMBER NOT NULL CONSTRAINT PRODUCT_ID_FK REFERENCES DIMPRODUCT (PRODUCTKEY),
    SALESPERSONID      INT NOT NULL CONSTRAINT SALESPERSON_ID_FK REFERENCES DIMSALESPERSON ( SALESPERSONID ),
    QUANTITY          FLOAT,
    SALESTOTALCOST    INT as (DIMPRODUCT.PRODUCTSALESCOST * QUANTITY),
    PRODUCTACTUALCOST INT as (DIMPRODUCT.PRODUCTACTUALCOST * QUANTITY),
    DEVIATION         FLOAT
);

正如你在SALESTOTALCOST和PRODUCTACTUALCOST,中看到的，我希望每次在这个表中插入一些东西时，根据DIMPRODUCT.PRODUCTSALESCOST和DIMPRODUCT.PRODUCTACTUALCOST中的值自动计算它们的值，这取决于用户在DIMPRODUCT字段中插入的ID，当然，这段代码不会工作。
这可能吗？