<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;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 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;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle24
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle25
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">The Datamart team has scheduled additional Datamart/Hyperion training. Please review the information below.
<br>
<br>
<i><u>Datamart & Hyperion: Back to Basics</u></i> (8 CPE Hours) (**Beginning level course)<br>
<b>September 19, 2013 (Thursday)<o:p></o:p></b></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><i><u><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Datamart & Hyperion: A Cut Above</span></u></i><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">
(8 CPE Hours) (**Intermediate level course)<br>
<b>September 25, 2013 (Wednesday)<o:p></o:p></b></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">These training courses are currently offered
<b><i>free of charge</i></b>. <o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Please visit
<b><i>iLearnOregon</i></b> to sign up for these trainings: <a href="https://ilearn.oregon.gov" target="_blank">
<span style="color:black">https://ilearn.oregon.gov</span></a>. Seating is limited and will not last long, so make sure to sign up as soon as possible. We will continue offering the beginning and intermediate courses in the future, on a periodic basis, so do
not be discouraged if you miss these dates. <o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">The trainings will occur at the
<b><i>General Services Building</i></b> in the <b><i>DAS Computer Lab</i></b>, located in the
<b><i>Mt Hood room</i></b> at <b>1225 Ferry St SE, Salem, OR 97301. </b>Please, be aware that Parking at DAS east is mainly metered with a four-hour limit.<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><i><u><span style="font-family:"Arial","sans-serif";color:black">Datamart & Hyperion: Back to Basics:<br>
</span></u></i></b><u><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Objectives:
<br>
Learn the basics about</span></u><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">:<o:p></o:p></span></p>
<p class="MsoListParagraph" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:.25in;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:Symbol;color:black">·</span><span style="font-size:7.0pt;color:black">
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">The Datamart, Datamart table information, the Repository, and how to set up an OCE<br>
</span><span style="font-size:10.0pt;font-family:Symbol;color:black">·</span><span style="font-size:7.0pt;color:black">
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Hyperion/Brio – how to build and run queries, as well as, alter and analyze results<br>
</span><span style="font-size:10.0pt;font-family:Symbol;color:black">·</span><span style="font-size:7.0pt;color:black">
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Hyperion tables, joins, filters, formatting, and sorting<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><u><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Prerequisites:
<o:p></o:p></span></u></p>
<p class="MsoListParagraph" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:.25in;margin-bottom:.0001pt">
<span style="font-size:10.0pt;font-family:Symbol;color:black">·</span><span style="font-size:7.0pt;color:black">
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">The training manual for this class must be printed (Double sided) prior to attending.</span><span style="color:black">
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"><a href="http://oregon.gov/DAS/EGS/FBS/Pages/datamart.aspx#Datamart_Training"><span style="color:black">http://oregon.gov/DAS/EGS/FBS/Pages/datamart.aspx#Datamart_Training</span></a><br>
</span><span style="font-size:10.0pt;font-family:Symbol;color:black">·</span><span style="font-size:7.0pt;color:black">
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Attendees must have current Datamart Security access with a valid password, prior to attending this course.<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><i><u><span style="font-family:"Arial","sans-serif";color:black">Datamart & Hyperion: A Cut Above:</span></u></i></b><b><i><u><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"><br>
</span></u></i></b><u><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Objectives:
<br>
Learn advanced information about:<o:p></o:p></span></u></p>
<p class="MsoListParagraph" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;text-indent:-.25in">
<span style="font-size:10.0pt;font-family:Symbol;color:black">·</span><span style="font-size:7.0pt;font-family:"Verdana","sans-serif";color:black">
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">The Datamart, How to build complex queries, Pivots, Reports, Computed items, and Dashboards<o:p></o:p></span></p>
<p class="MsoListParagraph" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;text-indent:-.25in">
<span style="font-size:10.0pt;font-family:Symbol;color:black">·</span><span style="font-size:7.0pt;font-family:"Verdana","sans-serif";color:black">
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">This training course includes up-to-date information on the latest Brio/Hyperion application called “Hyperion Interactive Reporting Studio”.<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><u><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Prerequisites</span></u><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">:
For the intermediate class to be beneficial the attendee must have the ability to set-up simple queries, which are taught in the beginning class. This class begins with complex queries.<o:p></o:p></span></p>
<p class="MsoListParagraph" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;text-indent:-.25in">
<span style="font-size:10.0pt;font-family:Symbol;color:black">·</span><span style="font-size:7.0pt;font-family:"Verdana","sans-serif";color:black">
</span><i><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Basic knowledge of the Hyperion application is
<b>required</b></span></i><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">.<o:p></o:p></span></p>
<p class="MsoListParagraph" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;text-indent:-.25in">
<span style="font-size:10.0pt;font-family:Symbol;color:black">·</span><span style="font-size:7.0pt;font-family:"Verdana","sans-serif";color:black">
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">The training manual for this class must be printed (Double sided), prior to attending.
<a href="http://oregon.gov/DAS/EGS/FBS/Pages/datamart.aspx#Datamart_Training" target="_blank">
http://oregon.gov/DAS/EGS/FBS/Pages/datamart.aspx#Datamart_Training</a><o:p></o:p></span></p>
<p class="MsoListParagraph" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;text-indent:-.25in">
<span style="font-size:10.0pt;font-family:Symbol;color:black">·</span><span style="font-size:7.0pt;font-family:"Verdana","sans-serif";color:black">
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Attendees must have current Datamart Security access with a valid password, prior to attending this course.<o:p></o:p></span></p>
<p class="MsoListParagraph" style="mso-margin-top-alt:0in;margin-right:0in;margin-bottom:12.0pt;margin-left:.25in">
<span style="font-size:10.0pt;font-family:Symbol;color:black">·</span><span style="font-size:7.0pt;font-family:"Verdana","sans-serif";color:black">
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Completion of the ‘Datamart & Hyperion: Back to Basics’ course is
<i>preferred</i>.<o:p></o:p></span></p>
<pre><span style="font-family:"Arial","sans-serif";color:black"><br>Registration for this event will be coordinated through <b><i>iLearnOregon</i></b> using the link provided above. You will need an active iLearnOregon account to complete the registration process. If you do not already have an iLearnOregon account, you can find information on how to create an account on the main login page for iLearnOregon. Once you have logged-in you will find a link for "How to Register For A Course" in the left navigation panel under "iLearnOregon Help Center." <o:p></o:p></span></pre>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Aaron Wallace<br>
<i>Sr. Datamart Business Analyst</i></span><span style="color:black"><o:p></o:p></span></p>
</div>
</body>
</html>