5 Replies Latest reply on Feb 8, 2012 9:59 PM by Nathan Krisanski

    Blending data using a cube and an excel secondary source

      I have a cube with City and Population data. But the viz I want to create is basically population by state.

       

      So I created a spreadsheet with city and state mapping and included that as the secondary source. Defined a relation using City.

       

      But I am unable to create the view I need as I dont understand as to how to achieve this blending.

       

      This may be a basic question but I have searched the forums without any luck. Any help will be appreciated.

       

      Thanks.