[Datamart-News] ASO (new query tool update)

[WALLACE Aaron * DAS]

Update:

Here is some additional technical information:
This is the same 'Shared AD' used for authentication to the @oregon.gov enterprise email system and the enterprise data backup CommVault portal."

Aaron Wallace
Sr. Datamart Business Analyst

From: WALLACE Aaron * DAS <Aaron.WALLACE at oregon.gov>
Sent: Monday, September 28, 2020 2:32 PM
To: WALLACE Aaron * DAS <Aaron.WALLACE at oregon.gov>
Cc: HUNTER Aaron <aaron.hunter at state.or.us>; adam.shelton at deq.state.or.us; MEDINA Alex Y * OSMB <Alex.Y.MEDINA at oregon.gov>; Alexandrea.N.NIETO at state.or.us; amanda.marble at pers.state.or.us; Amber.R.Forster at state.or.us; BOYER A <aboyer at oda.state.or.us>; andria.otjen at state.or.us; SIFUENTEZ Angie <Angie.SIFUENTEZ at state.or.us>; HIGLEY Anna * REA <Anna.HIGLEY at oregon.gov>; MARLIN Joy <joy.marlin at state.or.us>; HOLTRY Barbara <barbara.holtry at state.or.us>; BSEAMAN at puc.state.or.us; benjamin.dangelo at pers.state.or.us; BROWN Beth * HCS <Beth.BROWN at oregon.gov>; HENSON Brian <brian.henson at state.or.us>; RELPHORDE Bridgett <Bridgett.Relphorde at oregonlegislature.gov>; SHRIVER Bruce <bruce.shriver at state.or.us>; bryan.l.nollen at ojd.state.or.us; YANT Caleb * HCS <Caleb.YANT at oregon.gov>; BOVETT Carol <carol.bovett at state.or.us>; BRANDT Carol A <carol.a.brandt at state.or.us>; Watson Cathy * OLCC <Cathy.Watson at oregon.gov>; MCMICHAEL Christina * BIZ <Christina.McMichael at oregon.gov>; BUI Christopher C * DAS <Christopher.C.BUI at oregon.gov>; STOCKSTILL Cindy * OPRD <Cindy.Stockstill at oregon.gov>; JOHNSON Dacia <Dacia.Johnson at state.or.us>; V.Dale.Bond at state.or.us; MCCULLOCH Darcy <darcy.mcculloch at state.or.us>; MCKAY David D * ODOE <David.D.McKay at oregon.gov>; david.t.moon at ojd.state.or.us; CRISCOLA Dean R * OED <Dean.R.CRISCOLA at oregon.gov>; Debora.A.Nearman at oregon.gov; WILLIAMS Karen A * DAS <Karen.A.WILLIAMS at oregon.gov>; deborah.l.martin at doj.state.or.us; dbaugh at odf.state.or.us; JOHNSON Dexter <Dexter.Johnson at oregonlegislature.gov>; COATES Diane M <Diane.M.Coates at oregonlegislature.gov>; HAOLE-VALENZUELA Donna K. <Donna.K.Haole-Valenzuela at state.or.us>; SHEPARD Duke <duke.shepard at state.or.us>; BALL Dustin * DAS <Dustin.BALL at oregon.gov>; KARAYEL Caty E * REA <Caty.e.KARAYEL at oregon.gov>; OVCHINIKOV Elena * DCBS <Elena.Ovchinikov at oregon.gov>; ethel.gallares at deq.state.or.us; FLORES Fabiola * DAS <Fabiola.FLORES at oregon.gov>; STEVENS Gail AB <gail.ab.stevens at state.or.us>; geneva.f.degner at state.or.us; Imee.R.Anderson at state.or.us; Jack.H.Ogami at doc.state.or.us; REED James * ODF <james.reed at oregon.gov>; SPENCER James J <James.J.Spencer at state.or.us>; ADAMS JASON B <Jason.B.Adams at state.or.us>; ROBINSON Jason * DAS <Jason.ROBINSON at oregon.gov>; Cameron Jeffery M <JEFFERY.M.CAMERON at dhsoha.state.or.us>; HENDERSON Jeffrey S <jeffrey.s.henderson at state.or.us>; KIDNEY Jeffrey A * OED <Jeffrey.A.KIDNEY at oregon.gov>; Jennifer.N.Jones at ojd.state.or.us; Jenny.Carson-Phillips at opds.state.or.us; WILFONG Jenny * BIZ <Jenny.Wilfong at oregon.gov>; Jill.Reece at oya.state.or.us; BONAWITZ Joe S * III <Joe.S.BONAWITZ at state.or.us>; john.etherington2 at state.or.us; MACIAS Jose * DOR <Jose.MACIAS at oregon.gov>; FLAGER Joseph * ODF <Joseph.FLAGER at oregon.gov>; SWEET Joshua <Joshua.Sweet at oregonlegislature.gov>; Julie Fetsch <julie.a.fetsch at opds.state.or.us>; Julie.A.Sparks at state.or.us; katie.r.steinback at ojd.state.or.us; JONES Kellie * ODF <Kellie.JONES at oregon.gov>; ROCCO Ken G <Ken.G.Rocco at oregonlegislature.gov>; Kenneth.D.PARSONS at odot.state.or.us; kevin.r.herburger at state.or.us; krista.j.campbell at ode.state.or.us; OLSON Krista * DOR <Krista.OLSON at oregon.gov>; MILLER Kristie - ODE <kristie.miller at state.or.us>; lhenders at oda.state.or.us; BYERLY Laurie <Laurie.Byerly at oregonlegislature.gov>; HULLINGER Lee <lee.hullinger at state.or.us>; GRAY Lillie - ODE <lillie.gray at state.or.us>; SNYDER Lisa J * WRD <Lisa.J.Snyder at oregon.gov>; lora.carson at oya.state.or.us; HERRING Marcia <marcia.herring at state.or.us>; maria.f.young at doj.state.or.us; SHERWOOD Marilyn - ODE <marilyn.sherwood at state.or.us>; RILEY Matthew * DAS <Matthew.RILEY at oregon.gov>; HICKAM Michael * SOS <Michael.HICKAM at oregon.gov>; MORIN Michelle * ODF <Michelle.MORIN at oregon.gov>; SMITH Mike T * OED <Mike.T.SMITH at oregon.gov>; KOTLYARENKO Milya S <milya.kotlyarenko at state.or.us>; FERNANDEZ Mini D * DAS <Mini.D.Fernandez at oregon.gov>; AGLIETTI Miriha * ODOE <Miriha.Aglietti at oregon.gov>; mishelle.k.sumption at state.or.us; SUTTER Natalie D <Natalie.D.Sutter at state.or.us>; LEWIS Nicole M * DOR <Nicole.M.LEWIS at oregon.gov>; olga.fokina at omb.oregon.gov; POPE Pat <pat.pope at state.or.us>; RINCK Peggy * OPRD <Peggy.Rinck at oregon.gov>; Pete.Senser at mil.state.os.us; rachel.graham at oregon.gov; SMITH Rachel <rachel.smith at state.or.us>; RODAMAKER Ramona R. <Ramona.R.Rodamaker at state.or.us>; BASL Randy <randy.basl at state.or.us>; Rebecca.A.PARKER at state.or.us; CAMPBELL Rick * ODF <Rick.CAMPBELL at oregon.gov>; CRAGER Rick - ODE <rick.crager at state.or.us>; BEALL Robert <Robert.E.BEALL at state.or.us>; JASON Ruby <ruby.jason at state.or.us>; CHEN Ru-Hwa * DAS <Ru-Hwa.CHEN at oregon.gov>; ryan.n.hawes at state.or.us; BOEDIGHEIMER Shari L <Shari.L.BOEDIGHEIMER at state.or.us>; DETTWYLERGWIN Sonja <sonja.dettwylergwin at state.or.us>; THOMSON Star <Star.C.Thomson at state.or.us>; Steven.R.GALLANT at odot.state.or.us; sue.nunley at doj.state.or.us; Susan.L.Oliveira at mil.state.or.us; TAYLOR Susan A <Susan.A.Taylor at state.or.us>; FURNISH Teresa L * SOS <Teresa.L.FURNISH at oregon.gov>; BONEBRAKE Terry D <terry.d.bonebrake at state.or.us>; thomas.y.poon at state.or.us; FLORES Tomas - ODE <tomas.flores at state.or.us>; traci.cooper2 at state.or.us; HAGE Trisha * WRD <Trisha.Hage at oregon.gov>; VIDAL Trudy * DAS <Trudy.Vidal at oregon.gov>; NGUYEN Tuyet-Mai T * BIZ <Tuyet-Mai.T.Nguyen at oregon.gov>; tyna.moriarty at oya.state.or.us; ENGELSON Alyssa * DAS <Alyssa.ENGELSON at oregon.gov>; datamart-news at omls.oregon.gov
Subject: ASO (new query tool update)

Dear Agency Security Officers,

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.

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.

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 critical piece of the process to fully set up your Datamart users with OBIEE access.

The Datamart team asks that all ASO 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.

Thanks for your patience and understanding with this new process.
Aaron Wallace
Sr. Datamart Business Analyst

From: WALLACE Aaron * DAS <Aaron.WALLACE at oregon.gov<mailto:Aaron.WALLACE at oregon.gov>>
Sent: Tuesday, July 14, 2020 2:30 PM
Subject: Agency Security Officers (query tool)

Agency Security Officers,

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 Datamart<https://www.oregon.gov/das/Financial/AcctgSys/Pages/datamart.aspx> and SARS<https://www.oregon.gov/das/Financial/Acctng/Pages/Syst-security.aspx> System Security websites.

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).
Here is the breakdown of agency rollout the Datamart team has approved.

1.       Agy 107, 123, 440, & 629: Starting 8/01/20

2.       Agy 100 - 291: Starting 9/01/20

3.       Agy 292 - 471: Starting 10/01/20

4.       Agy 472 - 999: Starting 11/01/20

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.

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.

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.

Thanks for your patience and understanding,
Aaron Wallace
Sr. Datamart Business Analyst


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20200929/dace6acc/attachment.html>