<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 15 (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:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
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.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:black;
font-weight:normal;
font-style:normal;}
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:black;
font-weight:normal;
font-style:normal;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:black;
font-weight:normal;
font-style:normal;}
.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;}
/* List Definitions */
@list l0
{mso-list-id:399403778;
mso-list-type:hybrid;
mso-list-template-ids:-699076322 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></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="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:black">Update:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">Here is some additional technical information:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">This is the same ‘Shared AD’ used for authentication to the @oregon.gov enterprise email system and the enterprise data backup CommVault portal.”</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:black">Aaron Wallace<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Sr. Datamart Business Analyst<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> WALLACE Aaron * DAS <Aaron.WALLACE@oregon.gov> <br>
<b>Sent:</b> Monday, September 28, 2020 2:32 PM<br>
<b>To:</b> WALLACE Aaron * DAS <Aaron.WALLACE@oregon.gov><br>
<b>Cc:</b> HUNTER Aaron <aaron.hunter@state.or.us>; adam.shelton@deq.state.or.us; MEDINA Alex Y * OSMB <Alex.Y.MEDINA@oregon.gov>; Alexandrea.N.NIETO@state.or.us; amanda.marble@pers.state.or.us; Amber.R.Forster@state.or.us; BOYER A <aboyer@oda.state.or.us>;
andria.otjen@state.or.us; SIFUENTEZ Angie <Angie.SIFUENTEZ@state.or.us>; HIGLEY Anna * REA <Anna.HIGLEY@oregon.gov>; MARLIN Joy <joy.marlin@state.or.us>; HOLTRY Barbara <barbara.holtry@state.or.us>; BSEAMAN@puc.state.or.us; benjamin.dangelo@pers.state.or.us;
BROWN Beth * HCS <Beth.BROWN@oregon.gov>; HENSON Brian <brian.henson@state.or.us>; RELPHORDE Bridgett <Bridgett.Relphorde@oregonlegislature.gov>; SHRIVER Bruce <bruce.shriver@state.or.us>; bryan.l.nollen@ojd.state.or.us; YANT Caleb * HCS <Caleb.YANT@oregon.gov>;
BOVETT Carol <carol.bovett@state.or.us>; BRANDT Carol A <carol.a.brandt@state.or.us>; Watson Cathy * OLCC <Cathy.Watson@oregon.gov>; MCMICHAEL Christina * BIZ <Christina.McMichael@oregon.gov>; BUI Christopher C * DAS <Christopher.C.BUI@oregon.gov>; STOCKSTILL
Cindy * OPRD <Cindy.Stockstill@oregon.gov>; JOHNSON Dacia <Dacia.Johnson@state.or.us>; V.Dale.Bond@state.or.us; MCCULLOCH Darcy <darcy.mcculloch@state.or.us>; MCKAY David D * ODOE <David.D.McKay@oregon.gov>; david.t.moon@ojd.state.or.us; CRISCOLA Dean R *
OED <Dean.R.CRISCOLA@oregon.gov>; Debora.A.Nearman@oregon.gov; WILLIAMS Karen A * DAS <Karen.A.WILLIAMS@oregon.gov>; deborah.l.martin@doj.state.or.us; dbaugh@odf.state.or.us; JOHNSON Dexter <Dexter.Johnson@oregonlegislature.gov>; COATES Diane M <Diane.M.Coates@oregonlegislature.gov>;
HAOLE-VALENZUELA Donna K. <Donna.K.Haole-Valenzuela@state.or.us>; SHEPARD Duke <duke.shepard@state.or.us>; BALL Dustin * DAS <Dustin.BALL@oregon.gov>; KARAYEL Caty E * REA <Caty.e.KARAYEL@oregon.gov>; OVCHINIKOV Elena * DCBS <Elena.Ovchinikov@oregon.gov>;
ethel.gallares@deq.state.or.us; FLORES Fabiola * DAS <Fabiola.FLORES@oregon.gov>; STEVENS Gail AB <gail.ab.stevens@state.or.us>; geneva.f.degner@state.or.us; Imee.R.Anderson@state.or.us; Jack.H.Ogami@doc.state.or.us; REED James * ODF <james.reed@oregon.gov>;
SPENCER James J <James.J.Spencer@state.or.us>; ADAMS JASON B <Jason.B.Adams@state.or.us>; ROBINSON Jason * DAS <Jason.ROBINSON@oregon.gov>; Cameron Jeffery M <JEFFERY.M.CAMERON@dhsoha.state.or.us>; HENDERSON Jeffrey S <jeffrey.s.henderson@state.or.us>; KIDNEY
Jeffrey A * OED <Jeffrey.A.KIDNEY@oregon.gov>; Jennifer.N.Jones@ojd.state.or.us; Jenny.Carson-Phillips@opds.state.or.us; WILFONG Jenny * BIZ <Jenny.Wilfong@oregon.gov>; Jill.Reece@oya.state.or.us; BONAWITZ Joe S * III <Joe.S.BONAWITZ@state.or.us>; john.etherington2@state.or.us;
MACIAS Jose * DOR <Jose.MACIAS@oregon.gov>; FLAGER Joseph * ODF <Joseph.FLAGER@oregon.gov>; SWEET Joshua <Joshua.Sweet@oregonlegislature.gov>; Julie Fetsch <julie.a.fetsch@opds.state.or.us>; Julie.A.Sparks@state.or.us; katie.r.steinback@ojd.state.or.us; JONES
Kellie * ODF <Kellie.JONES@oregon.gov>; ROCCO Ken G <Ken.G.Rocco@oregonlegislature.gov>; Kenneth.D.PARSONS@odot.state.or.us; kevin.r.herburger@state.or.us; krista.j.campbell@ode.state.or.us; OLSON Krista * DOR <Krista.OLSON@oregon.gov>; MILLER Kristie - ODE
<kristie.miller@state.or.us>; lhenders@oda.state.or.us; BYERLY Laurie <Laurie.Byerly@oregonlegislature.gov>; HULLINGER Lee <lee.hullinger@state.or.us>; GRAY Lillie - ODE <lillie.gray@state.or.us>; SNYDER Lisa J * WRD <Lisa.J.Snyder@oregon.gov>; lora.carson@oya.state.or.us;
HERRING Marcia <marcia.herring@state.or.us>; maria.f.young@doj.state.or.us; SHERWOOD Marilyn - ODE <marilyn.sherwood@state.or.us>; RILEY Matthew * DAS <Matthew.RILEY@oregon.gov>; HICKAM Michael * SOS <Michael.HICKAM@oregon.gov>; MORIN Michelle * ODF <Michelle.MORIN@oregon.gov>;
SMITH Mike T * OED <Mike.T.SMITH@oregon.gov>; KOTLYARENKO Milya S <milya.kotlyarenko@state.or.us>; FERNANDEZ Mini D * DAS <Mini.D.Fernandez@oregon.gov>; AGLIETTI Miriha * ODOE <Miriha.Aglietti@oregon.gov>; mishelle.k.sumption@state.or.us; SUTTER Natalie D
<Natalie.D.Sutter@state.or.us>; LEWIS Nicole M * DOR <Nicole.M.LEWIS@oregon.gov>; olga.fokina@omb.oregon.gov; POPE Pat <pat.pope@state.or.us>; RINCK Peggy * OPRD <Peggy.Rinck@oregon.gov>; Pete.Senser@mil.state.os.us; rachel.graham@oregon.gov; SMITH Rachel
<rachel.smith@state.or.us>; RODAMAKER Ramona R. <Ramona.R.Rodamaker@state.or.us>; BASL Randy <randy.basl@state.or.us>; Rebecca.A.PARKER@state.or.us; CAMPBELL Rick * ODF <Rick.CAMPBELL@oregon.gov>; CRAGER Rick - ODE <rick.crager@state.or.us>; BEALL Robert <Robert.E.BEALL@state.or.us>;
JASON Ruby <ruby.jason@state.or.us>; CHEN Ru-Hwa * DAS <Ru-Hwa.CHEN@oregon.gov>; ryan.n.hawes@state.or.us; BOEDIGHEIMER Shari L <Shari.L.BOEDIGHEIMER@state.or.us>; DETTWYLERGWIN Sonja <sonja.dettwylergwin@state.or.us>; THOMSON Star <Star.C.Thomson@state.or.us>;
Steven.R.GALLANT@odot.state.or.us; sue.nunley@doj.state.or.us; Susan.L.Oliveira@mil.state.or.us; TAYLOR Susan A <Susan.A.Taylor@state.or.us>; FURNISH Teresa L * SOS <Teresa.L.FURNISH@oregon.gov>; BONEBRAKE Terry D <terry.d.bonebrake@state.or.us>; thomas.y.poon@state.or.us;
FLORES Tomas - ODE <tomas.flores@state.or.us>; traci.cooper2@state.or.us; HAGE Trisha * WRD <Trisha.Hage@oregon.gov>; VIDAL Trudy * DAS <Trudy.Vidal@oregon.gov>; NGUYEN Tuyet-Mai T * BIZ <Tuyet-Mai.T.Nguyen@oregon.gov>; tyna.moriarty@oya.state.or.us; ENGELSON
Alyssa * DAS <Alyssa.ENGELSON@oregon.gov>; datamart-news@omls.oregon.gov<br>
<b>Subject:</b> ASO (new query tool update)<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:black">Dear Agency Security Officers,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">Back in July, I sent an email letting you know about the upcoming new query tool called ‘OBIEE’ or ‘OB1’. This application is here to replace Hyperion as the State’s main query tool.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">OBIEE went live in August 2020. We are continuing to complete our rollout process which allows identified agencies to start using the product. This rollout spans a four month period.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">The OBIEE application has been set up with a new type of security access. Users are input on a ‘Shared Active Directory’ or ‘Shared AD’. A user must be included in the Shared AD, prior to obtaining security access
to the product. This access is a <i>critical</i> piece of the process to fully set up your Datamart users with OBIEE access.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">The Datamart team asks that <i>all ASO</i> confirm with your IT department and determine what the status is of your agency and being included in the Shared AD. If your agency is currently not set up in the Shared
AD, then your IT department will need to work with Dewayne Weaver’s unit (DAS DCS) to obtain proper access.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">Thanks for your patience and understanding with this new process.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Aaron Wallace<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Sr. Datamart Business Analyst<o:p></o:p></span></p>
<div style="border:none;border-bottom:solid windowtext 1.5pt;padding:0in 0in 1.0pt 0in">
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><b>From:</b> WALLACE Aaron * DAS <<a href="mailto:Aaron.WALLACE@oregon.gov">Aaron.WALLACE@oregon.gov</a>>
<br>
<b>Sent:</b> Tuesday, July 14, 2020 2:30 PM<br>
<b>Subject:</b> Agency Security Officers (query tool)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Agency Security Officers,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The Datamart team has been hard at work to implement a new business Intelligence query tool to replace Hyperion. We are officially going live with the Oracle Business Intelligence Enterprise Edition (OBIEE or OB1) application on 8/01/2020.
I want to make sure you are aware of the new security process. It is documented on both the
<a href="https://www.oregon.gov/das/Financial/AcctgSys/Pages/datamart.aspx">Datamart</a> and
<a href="https://www.oregon.gov/das/Financial/Acctng/Pages/Syst-security.aspx">SARS</a> System Security websites.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The rollout process will be slow as we plan to roll out only a few agencies and then add more on a monthly basis (Datamart news list email coming soon).<o:p></o:p></p>
<p class="MsoNormal"><span style="color:black">Here is the breakdown of agency rollout the Datamart team has approved.
<o:p></o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo2"><![if !supportLists]><span style="color:black"><span style="mso-list:Ignore">1.<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:black">Agy 107, 123, 440, & 629: Starting 8/01/20<o:p></o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo2"><![if !supportLists]><span style="color:black"><span style="mso-list:Ignore">2.<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:black">Agy 100 – 291: Starting 9/01/20<o:p></o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo2"><![if !supportLists]><span style="mso-list:Ignore">3.<span style="font:7.0pt "Times New Roman"">
</span></span><![endif]><span style="color:black">Agy 292 – 471: Starting 10/01/20</span><o:p></o:p></p>
<p class="MsoListParagraph" style="text-indent:-.25in;mso-list:l0 level1 lfo2"><![if !supportLists]><span style="color:black"><span style="mso-list:Ignore">4.<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:black">Agy 472 – 999: Starting 11/01/20<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">To clarify, there are two new OBIEE documents on the sites. One is the overall security process created for ASO’s and the other is an OBIEE security request (Excel) document required by System Security. Please
review these documents as soon as possible. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="background:yellow;mso-highlight:yellow">This new tool is web based and a user log in with a ‘Shared AD’ type of access. Each agency has a ‘Shared AD’ team that may need to be contacted in order for the user to be fully set
up. Please review who is the Shared AD team contact for your agency.</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Please alert the new users that training is required once they obtain access. There will be training classes coming soon. In addition, we are working on an iLearn training, which should come out soon as well.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks for your patience and understanding,<o:p></o:p></p>
<p class="MsoNormal">Aaron Wallace<o:p></o:p></p>
<p class="MsoNormal">Sr. Datamart Business Analyst<o:p></o:p></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>