<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)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><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;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle19
{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;}
/* List Definitions */
@list l0
{mso-list-id:734817246;
mso-list-type:hybrid;
mso-list-template-ids:1394391824 -492154854 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.25in;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:1.75in;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.25in;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.75in;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:3.25in;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:3.75in;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:4.25in;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:4.75in;
text-indent:-9.0pt;}
@list l1
{mso-list-id:1998486381;
mso-list-template-ids:-1717265848;}
@list l1:level1
{mso-level-start-at:2;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l2
{mso-list-id:2003773709;
mso-list-template-ids:1035239176;}
@list l2:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1029" />
</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" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:black">Here are a few additional tips for OBIEE/Datamart.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoListParagraph" style="color:black;margin-left:.25in;mso-list:l0 level1 lfo3">
When creating formula, in OBIEE, make sure to check the ‘Aggregation rule’. Normally, OBIEE will automatically select an appropriate option; however, it is best practice to verify the rule and change as needed. For example, anytime the formula will be a dollar
type figure, you should set it to ‘sum’, even if it is automatically set to ‘default’ by OBIEE.
<o:p></o:p></li><ol style="margin-top:0in" start="1" type="a">
<li class="MsoListParagraph" style="color:black;margin-left:.25in;mso-list:l0 level2 lfo3">
Aggregation rules have a big effect on the totals of table/pivot views. <o:p></o:p></li></ol>
</ol>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<ol style="margin-top:0in" start="2" type="1">
<li class="MsoListParagraph" style="color:black;margin-left:.25in;mso-list:l0 level1 lfo3">
Along with the standard ‘Agency’ and ‘Date’ filters, it is highly recommended to add a ‘GL Acct’ filter to your queries. If you do not, you could be pulling both sides of a transaction. Due to the great summing function in OBIEE, having both sides of a transaction
could provide you with very little data as the data could offset. <br>
<br>
<o:p></o:p></li><li class="MsoListParagraph" style="color:black;margin-left:.25in;mso-list:l0 level1 lfo3">
If you run into ‘error’ messages in OBIEE, please, initially try to close your browser. Then reopen and relog into OBIEE. This can help fix some issues that have occurred.
<o:p></o:p></li><ol style="margin-top:0in" start="1" type="a">
<li class="MsoListParagraph" style="color:black;margin-left:.25in;mso-list:l0 level2 lfo3">
When sending ‘error’ message info to Datamart support, please include a screen shot of the error along with the file name and directory.<br>
<br>
<o:p></o:p></li></ol>
<li class="MsoListParagraph" style="color:black;margin-left:.25in;mso-list:l0 level1 lfo3">
If your goal is to obtain a percentage of a field within a Pivot, you can use the ‘duplicate layer’ function.<o:p></o:p></li><ol style="margin-top:0in" start="1" type="a">
<li class="MsoListParagraph" style="color:black;margin-left:.25in;mso-list:l0 level2 lfo3">
Go into ‘edit’ mode of the ‘Pivot’ view. Next, duplicate the ‘measures’ field (ex. ‘number of hours’). On the new field, use the wheel icon and select the ‘show data as’ and ‘percent of’ and then whatever option you desire. If you want a value to show percent
of the ‘column’, then select it. If you want it to show as a ‘layer’, such as of ‘Employee name’ (field hidden in below example) then select it. This is a very easy feature and can be used in many ways.
<o:p></o:p></li></ol>
</ol>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoListParagraph" style="margin-left:.75in"><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter" />
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0" />
<v:f eqn="sum @0 1 0" />
<v:f eqn="sum 0 0 @1" />
<v:f eqn="prod @2 1 2" />
<v:f eqn="prod @3 21600 pixelWidth" />
<v:f eqn="prod @3 21600 pixelHeight" />
<v:f eqn="sum @0 0 1" />
<v:f eqn="prod @6 1 2" />
<v:f eqn="prod @7 21600 pixelWidth" />
<v:f eqn="sum @8 21600 0" />
<v:f eqn="prod @7 21600 pixelHeight" />
<v:f eqn="sum @10 21600 0" />
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect" />
<o:lock v:ext="edit" aspectratio="t" />
</v:shapetype><v:shape id="Picture_x0020_1" o:spid="_x0000_s1028" type="#_x0000_t75" style='position:absolute;left:0;text-align:left;margin-left:235.8pt;margin-top:20.4pt;width:71.65pt;height:20.3pt;z-index:251659264;visibility:visible;mso-wrap-style:square;mso-width-percent:0;mso-height-percent:0;mso-wrap-distance-left:9pt;mso-wrap-distance-top:0;mso-wrap-distance-right:9pt;mso-wrap-distance-bottom:0;mso-position-horizontal:absolute;mso-position-horizontal-relative:text;mso-position-vertical:absolute;mso-position-vertical-relative:text;mso-width-percent:0;mso-height-percent:0;mso-width-relative:page;mso-height-relative:page'>
<v:imagedata src="cid:image003.png@01D84D9B.2DC56350" o:title="" />
<o:lock v:ext="edit" aspectratio="f" />
</v:shape><![endif]--><![if !vml]><span style="mso-ignore:vglayout;position:absolute;z-index:251659264;left:0px;margin-left:314px;margin-top:28px;width:96px;height:27px"><img width="96" height="27" style="width:1.0in;height:.2812in" src="cid:image005.png@01D8A593.19042FF0" v:shapes="Picture_x0020_1"></span><![endif]>OBIEE
duplicated layers: <img width="188" height="56" style="width:1.9583in;height:.5833in" id="Picture_x0020_22" src="cid:image006.jpg@01D8A593.19042FF0"><span style="color:black"><o:p></o:p></span></p>
<p class="MsoListParagraph" style="margin-left:.75in"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoListParagraph" style="margin-left:.75in"><!--[if gte vml 1]><v:shape id="Picture_x0020_7" o:spid="_x0000_s1027" type="#_x0000_t75" style='position:absolute;left:0;text-align:left;margin-left:285.95pt;margin-top:132.45pt;width:19.35pt;height:10.6pt;z-index:251663360;visibility:visible;mso-wrap-style:square;mso-width-percent:0;mso-height-percent:0;mso-wrap-distance-left:9pt;mso-wrap-distance-top:0;mso-wrap-distance-right:9pt;mso-wrap-distance-bottom:0;mso-position-horizontal:absolute;mso-position-horizontal-relative:text;mso-position-vertical:absolute;mso-position-vertical-relative:text;mso-width-percent:0;mso-height-percent:0;mso-width-relative:page;mso-height-relative:page'>
<v:imagedata src="cid:image003.png@01D84D9B.2DC56350" o:title="" />
<o:lock v:ext="edit" aspectratio="f" />
</v:shape><![endif]--><![if !vml]><span style="mso-ignore:vglayout;position:absolute;z-index:251663360;left:0px;margin-left:381px;margin-top:176px;width:26px;height:14px"><img width="26" height="14" style="width:.2708in;height:.1458in" src="cid:image011.png@01D8A593.19042FF0" v:shapes="Picture_x0020_7"></span><![endif]><!--[if gte vml 1]><v:shape id="Picture_x0020_6" o:spid="_x0000_s1026" type="#_x0000_t75" style='position:absolute;left:0;text-align:left;margin-left:146.05pt;margin-top:130.05pt;width:21.35pt;height:11.25pt;z-index:251661312;visibility:visible;mso-wrap-style:square;mso-width-percent:0;mso-height-percent:0;mso-wrap-distance-left:9pt;mso-wrap-distance-top:0;mso-wrap-distance-right:9pt;mso-wrap-distance-bottom:0;mso-position-horizontal:absolute;mso-position-horizontal-relative:text;mso-position-vertical:absolute;mso-position-vertical-relative:text;mso-width-percent:0;mso-height-percent:0;mso-width-relative:page;mso-height-relative:page'>
<v:imagedata src="cid:image003.png@01D84D9B.2DC56350" o:title="" />
<o:lock v:ext="edit" aspectratio="f" />
</v:shape><![endif]--><![if !vml]><span style="mso-ignore:vglayout;position:absolute;z-index:251661312;left:0px;margin-left:195px;margin-top:173px;width:28px;height:15px"><img width="28" height="15" style="width:.2916in;height:.1562in" src="cid:image012.png@01D8A593.19042FF0" v:shapes="Picture_x0020_6"></span><![endif]>By
Layer: <img width="103" height="236" style="width:1.0729in;height:2.4583in" id="Picture_x0020_4" src="cid:image004.png@01D84DC6.13E5F2D0"> By column:
<img width="98" height="232" style="width:1.0208in;height:2.4166in" id="Picture_x0020_5" src="cid:image010.png@01D84DC6.B605B3C0"><br>
<br>
<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">Please remember to always include the file name and directory for all issues related to OBIEE. This will allow for a quicker review process.<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,<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>