<freeMetaDataQuery>
     <sqlQuery>
     <distinct>false</distinct>
     <limit>0</limit>
         <select>
             <dataStreamElementName>products_name</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>orderfact_priceeach</dataStreamElementName>
             <dataStreamName>orderfact</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>orderfact_totalprice</dataStreamElementName>
             <dataStreamName>orderfact</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>timeline_year_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>timeline_month_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>timeline_day_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>timeline_month_name</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>timeline_day_name</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>timeline.day_in_week</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
         </select>
<formula>
<name>timeline_month_number</name>
<script>SUBSTRING(PUBLIC.timeline.id,5,8)</script>
<dataStreamNames>timeline</dataStreamNames>
</formula>
         <agg>
             <function>SUM</function>
             <formula>false</formula>
             <col>orderfact_quantityordered</col>
             <dataStreamName>orderfact</dataStreamName>
             <outputName>orderfact_quantityordered</outputName>
         </agg>
         <orderBy>
             <dataStreamElementName>products_name</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>orderfact_quantityordered</dataStreamElementName>
             <dataStreamName>orderfact</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>orderfact_priceeach</dataStreamElementName>
             <dataStreamName>orderfact</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>orderfact_totalprice</dataStreamElementName>
             <dataStreamName>orderfact</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>timeline_year_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>timeline_month_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>timeline_day_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>timeline_month_name</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>timeline_day_name</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>timeline.day_in_week</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
          </orderBy>
         <orderByForm>
<name>timeline_month_number</name>
<script>SUBSTRING(PUBLIC.timeline.id,5,8)</script>
<dataStreamNames>timeline</dataStreamNames>
         </orderByForm>
         <additionalResource>
++++++++%3CsqlFilter%3E%0A++++++++++++%3Cname%3Etoday%3C%2Fname%3E%0A++++++++++++%3CdataStreamElement%3Etimeline_id%3C%2FdataStreamElement%3E%0A++++++++++++%3CdataStream%3Etimeline%3C%2FdataStream%3E%0A++++++++++++%3Cquery%3E%26lt%3B%3D+NOW%28%29%3C%2Fquery%3E%0A++++++++++++%3CgroupNames%3E%3C%2FgroupNames%3E%0A++++++++%3C%2FsqlFilter%3E%0A>
         </additionalResource>
         <additionalResource>
++++++++%3Cprompt%3E%0A++++++++++++%3Cname%3EpromptOnproducts_name%3C%2Fname%3E%0A++++++++++++%3Cquestion%3Enull%3C%2Fquestion%3E%0A++++++++++++%3Coperator%3E%3D%3C%2Foperator%3E%0A++++++++++++%3CoriginDataStream%3Eproducts%3C%2ForiginDataStream%3E%0A++++++++++++%3CoriginDataStreamElement%3Eproducts_name%3C%2ForiginDataStreamElement%3E%0A++++++++++++%3CdestinationDataStream%3Eproducts%3C%2FdestinationDataStream%3E%0A++++++++++++%3CdestinationDataStreamElement%3Eproducts_name%3C%2FdestinationDataStreamElement%3E%0A++++++++++++%3CgroupNames%3E%3C%2FgroupNames%3E%0A++++++++%3C%2Fprompt%3E%0A>
         </additionalResource>
     </sqlQuery>
</freeMetaDataQuery>
