0 Replies Latest reply on Jun 20, 2013 12:52 AM by dheeraj.ravi

    Dynamically Splitting Workbooks

    dheeraj.ravi

      Hi,

       

      I have a huge national workbook, which contains US data across all dimensions and measures (population, GDP, etc.). I would like to dynamically split the workbook to individual state workbooks with the same fields. I am currently using Custom SQL to filter it on something like 'where State = New York'. Ideally I don't want to hard code this and change it for all 50 states.

       

      Is there anyway to automate this process? I have explored filtering the data when first connecting to the extract, but again this is a manual process.

       

      Thanks!