<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>If you were unable to join me at the OSFA conference this year and view the ‘Derivable query’ presentation, you are still in luck. We have provided you an opportunity to download the ‘Derivable Query Conversion Notes’, in pdf form, from our website. Derivable queries are a topic discussed in the new intermediate Datamart training and a brief introduction to this query building method was presented at OSFA this year.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><a href="http://egov.oregon.gov/DAS/SCD/SARS/datamart.shtml#Datamart_Training">http://egov.oregon.gov/DAS/SCD/SARS/datamart.shtml#Datamart_Training</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>This pdf was a handout during the OSFA training. It describes how to alter a current standard built query and turn it into a derived query. The instructions allow a user to keep their original pivots, tables, reports, and charts intact, while updating a query to run as a derived query.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>If you have any questions, please email the Datamart team at <a href="mailto:Datamart.Support@state.or.us">Datamart.Support@state.or.us</a>.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks,<o:p></o:p></p><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Aaron Wallace<o:p></o:p></span></p><p class=MsoNormal><i><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Sr. Datamart Business Analyst<o:p></o:p></span></i></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Department of Administrative Services<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:8.0pt;font-family:"Arial","sans-serif"'>Data Classification: Level 1 - Published<o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p></div></body></html>