2 Replies Latest reply on Jul 25, 2012 10:28 PM by vadim.kazakov

    I can't link 3 datasources builded from the flat files (csv )

      I can't link 3 datasources builded from the flat files (csv ) and stored them as a *.tde files. I can see relationships builded in th Data menu but I can't see any chained icon near corresponding dimensions in these datasets.

       

      Files have a very simple structure

       

      Products:

      MRDR

      CATEGORY

      NAME

       

      POPS:

      POP_ID

      POP_NAME

      COUNTRY

       

      SALES:

      INV_ID

      POP_ID

      MRDR

      QTY

       

      So when I try to build pivot with CATEGORY in rows and SUM(QTY) in cells - I can see only a warning suggesting to join the data in the data menu

      What's wrong ?