<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="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 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:sans-serif;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</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=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Good Morning,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>A fellow Datamart user is trying to use Excel to connect to
the Datamart and is having some issues. If anyone has knowledge that they can
share on this topic please respond! Any information we get will be shared with
all.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>See below! Thanks and have a great day!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=sans-serif><span
style='font-size:11.0pt;font-family:sans-serif;color:blue'>“I was
wondering if anyone out there had set up an .odc file (this is the Excel
equivalent to an .oce file) to connect in to the datamart that included the
nifty custom joins that comes with the .oce for Hyperion queries?”</span></font><font
size=2 color=blue face=Arial><span style='font-size:11.0pt;font-family:Arial;
color:blue'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><b><font size=2 color=purple face="Times New Roman"><span
style='font-size:10.0pt;color:purple;font-weight:bold'>Linda Flicker</span></font><o:p></o:p></b></p>
<p class=MsoNormal><b><font size=2 color=purple face="Times New Roman"><span
style='font-size:10.0pt;color:purple;font-weight:bold'>Sr. Datamart Business
Analyst</span></font><o:p></o:p></b></p>
<p class=MsoNormal><b><font size=2 color=purple face="Times New Roman"><span
style='font-size:10.0pt;color:purple;font-weight:bold'>State Controller's
Division-SARS</span></font><o:p></o:p></b></p>
<p class=MsoNormal><b><font size=2 color=purple face="Times New Roman"><span
style='font-size:10.0pt;color:purple;font-weight:bold'>(503) 373-7277 Ext. 281</span></font><o:p></o:p></b></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>