2 Replies Latest reply: Jan 31, 2017 5:19 PM by Bilge Aydin RSS

    multiple section access tables, all with USERID field

    Bilge Aydin

      Can I have two section access tables (both with USERID field) in order to reduce the data through two dimension tables, as follows?

       

      Section Access:

       

      Table1:

      USERIDPRODUCT_ID
      USER1A
      USER2B

       

      Table2:

      USERIDCOUNTRY_ID
      USER110
      USER220

       

      Section Application:

       

      ProductDim:

      PRODUCT_IDPRD_NAME
      APhone
      BTelevision

       

      CountryDim:

      USERIDCOUNTRY_ID
      10USA
      20Canada

       

      FactTable

      PRODUCT_IDCOUNTRY_IDSales
      A10100
      B20200

       

      So that, fact table data is reduced to records where PRODUCT_ID=A and COUNTRY_ID=10 for USER1.

       

      Thx


      PRODUCT_IDPRODUCT_ID