6 Replies Latest reply on Sep 24, 2012 4:25 PM by Xiaodong Han

    GEO Code with Data Link

    Xiaodong Han

      I have two data sources:

       

      1. Store list with lat/Long

      2. Store sales by product by year

       

      I don't want to repeat lat/long in the Sales Fact table. So the second data source has no lat/long.  I created a data realtionship using 2nd source as primary. Then I try to map the data.  The data will map OK with out any other dimenstions from 2nd source used (as filter).  I can color the location with sum of sales.   However, as soon as I use a filter (Say product), the map will only work with "*" as filter.  If I select any product, the map go blank.  Am I doing anything wrong?

       

      Thanks