Mondrian Tables

Dimensions TABLE
CREATE TABLE AGENTS
(    A_ID               BIGINT
    ,A_NAME             VARCHAR(100)
    ,A_ROLE             VARCHAR(100)
    ,A_DEPARTMENT       VARCHAR(100)
    ,CONSTRAINT A_ID_PK PRIMARY KEY(A_ID)
);

Fact TABLE

CREATE TABLE TRANSACTIONS (
AGENT_ID BIGINT
,A_NAME VARCHAR
,A_ROLE VARCHAR
,TERRITORY_ID BIGINT
,T_ZIPCODE BIGINT
,T_PLACE_NAME VARCHAR
,T_STATE VARCHAR
,T_COUNTRY VARCHAR
,PRODUCT_ID BIGINT NOT NULL
,P_NAME VARCHAR
,P_CATEGORY VARCHAR
,CHANNEL_ID BIGINT
,CH_NAME VARCHAR
,CH_TYPE VARCHAR
,CUSTOMER_ID BIGINT NOT NULL
,CS_NAME VARCHAR
,CS_TYPE VARCHAR
,IS_NEW_CUSTOMER BOOLEAN
,CLOSE_DATE DATE
,DAY_CNT_SPENT INTEGER
,TOTAL_EXPENSES BIGINT
,FORCASTED_SALES BIGINT
,UNIT_CNT_SOLD BIGINT
,PRICE_PER_UNIT BIGINT
,DISCOUNT_PERCENT BIGINT
,TOTAL_SALES BIGINT
,CONSTRAINT pk PRIMARY KEY (PRODUCT_ID, CUSTOMER_ID)
);

Pre-aggregated TABLE - AG_TER_PRO
AGENT_ID,
TERRITORY_ID,
PRODUCT_ID,
SUM_TOTAL_SALES,
SUM_TOTAL_EXPENSES,