<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.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.EmailStyle18
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:black;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Calibri",sans-serif;}
@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="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:black">Datamart & OBIEE users,<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">As you may or may not be aware, we have two ‘Repository’ that use information from the DAS Datamart. One is accessed by using the Hyperion application and the other is through OBIEE. The Repository is a great tool
to help share standard reports with users on a statewide level. By using this feature through the years, agencies have been able to save valuable time and effort by not duplicating work.
<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 and SARS are hard at work recreating as many of the Hyperion repository files as possible, to include in the new OBIEE repository. This process does take time, so we appreciate your patience.
<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">I would like to invite you to view/use some of the new finalized OBIEE repository files. You can find the files in the following ‘Catalog’ directory of OBIEE:
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">/Shared Folders/Repository/Final <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">Current files: (Please contact Datamart Support for any potential file issues.)<o:p></o:p></span></p>
<p class="MsoNormal"><u><span style="color:black">DAFR 6610 & 6620</span></u><span style="color:black"> – This file opens to a Dashboard that contains all DAFR6610 and 6620 files.<o:p></o:p></span></p>
<p class="MsoNormal"><u><span style="color:black">SEFA Reports 2021</span></u><span style="color:black"> – This file opens to a Dashboard that contains all the SEFA related reports.
<o:p></o:p></span></p>
<p class="MsoNormal"><u><span style="color:black">SFMS – Trial Balance</span></u><span style="color:black"> – This file uses an Analysis to display debit and credit balances in a Trial Balance model, using the GL Detail table.
<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"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">If you are interested in creating an OBIEE Repository file, please let Datamart support know. In addition, please review the following Hyperion repository document on the Datamart website (<a href="https://www.oregon.gov/das/Financial/AcctgSys/Pages/datamart.aspx#reports">https://www.oregon.gov/das/Financial/AcctgSys/Pages/datamart.aspx#reports</a>)
<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">Thank you for your patience and understanding with the recreation of these files.<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>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>