tag:blogger.com,1999:blog-39168321759535415182024-03-13T10:11:06.377-07:00Oracle Business Intelligence (OBIEE)Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.comBlogger168125tag:blogger.com,1999:blog-3916832175953541518.post-52125663993557797612012-07-28T17:15:00.000-07:002012-07-28T17:15:21.915-07:00BI Apps - Financials - Cost Accounting / Supply chain - Inventory AnalyticsHello world,<br />
<br />
Its been a while, but here I am again....I have been working on cost accounting with financials and supply chain inventory modules past month, and wanted to write a blog post explaining about the various metrics/customizations I have been implementing within this module. This post will cover the functional as well as technical topics related to cost accounting in BI Apps. The topics I am going to cover in this post are as follows:<br />
<br />
1) Introduction to cost accounting.<br />
2) Out of the box model from BI Apps.<br />
3) Customizations (RPD and ETL)<br />
<br />
<b>Introduction to Cost Accounting:</b><br />
<br />
I want to start off introducing what cost accounting means and how reporting against costs is useful to the business. Any manufacturing industry that makes products and sells to customers needs reporting on their products, costs and inventory. <br />
<br />
To be continued.....Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com1tag:blogger.com,1999:blog-3916832175953541518.post-7255489243274343812012-07-02T18:31:00.000-07:002012-07-02T18:31:10.327-07:00OBIEE 11.1.1.6.2 BP1 ( Bundle Patch - 1 ) ReleasedRittman mead's blog article below lists all the new features introduced in OBIEE by oracle in the BP1 patch. Here is the <a href="http://www.rittmanmead.com/2012/07/obiee-11-1-1-6-2-bp1-new-features-oracle-bi-mobile-hd-and-patching-upgrade-considerations/">link</a> to the article and highlights of the BP1. <br />
<br />
Regarding the upgrades, if you are still on 10g, it is recommended that you install 11.1.1.6 and apply this patch for a stable environment. <br />
<br />
<br />
<div style="border: 0px; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 18px; margin-bottom: 15px; padding: 0px; text-align: left;"><a href="http://docs.oracle.com/cd/E23943_01/bi.1111/e10540/whatsnew.htm#CHDIDDGJ" style="border: 0px; color: black; font-weight: bold; margin: 0px; outline: 0px; padding: 0px;">Oracle BI Administrator / Oracle BI Server new features with OBIEE 11.1.1.6.2 BP1</a></div><ul style="border: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 12px; margin: 0px 0px 15px 20px; padding: 0px; text-align: left;"><li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">Improved Method to Achieve Nested Folders</li>
<li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">Ability to Control Presentation Layer Object Visibility</li>
<li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">Ability to Check for Modeling Problems that Affect Aggregate Persistence</li>
<li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">Improvements to the Aggregate Creation and Deletion Process</li>
<li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">Using XML Files to Automate Physical to Logical Mapping for ADF Data Sources</li>
</ul><div style="border: 0px; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 18px; margin-bottom: 15px; padding: 0px; text-align: left;"><a href="http://docs.oracle.com/cd/E23943_01/bi.1111/e10544/whatsnew.htm#CHDEGFAC" style="border: 0px; color: black; font-weight: bold; margin: 0px; outline: 0px; padding: 0px;">Oracle BI Presentation Server new features with OBIEE 11.1.1.6.2 BP1</a></div><ul style="border: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 12px; margin: 0px 0px 15px 20px; padding: 0px; text-align: left;"><li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">Trellis Charts, Microcharts, Sparklines and Line formats for MapViewer views</li>
<li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">Scorecard improvements (reordering of objects in the initiatives pane and strategy panel)</li>
<li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">Ability to create smart watch lists</li>
<li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">Support for write-back of manually entered targets for KPIs into Essbase</li>
</ul><div style="border: 0px; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 18px; margin-bottom: 15px; padding: 0px; text-align: left;"><a href="http://docs.oracle.com/cd/E23943_01/bi.1111/e10539/a_whatsnew.htm#CJADIAGF" style="border: 0px; color: black; font-weight: bold; margin: 0px; outline: 0px; padding: 0px;">Installation new features with OBIEE 11.1.1.6.2 BP1</a></div><ul style="border: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 12px; margin: 0px 0px 15px 20px; padding: 0px; text-align: left;"><li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">Installation of BI Composer using a script, rather than manual configuration of JEE libraries etc</li>
</ul><div style="border: 0px; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 18px; margin-bottom: 15px; padding: 0px; text-align: left;"><a href="http://docs.oracle.com/cd/E23943_01/bi.1111/e25318/whatsnew.htm#CHDCBFFH" style="border: 0px; color: black; font-weight: bold; margin: 0px; outline: 0px; padding: 0px;">Oracle BI Mobile new features with OBIEE 11.1.1.6.2 BP1</a></div><ul style="border: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 12px; margin: 0px 0px 15px 20px; padding: 0px; text-align: left;"><li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">New homepage with coverflow-style display of dashboards, as well as recent and favourite objects</li>
<li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">IOS-native controls</li>
<li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">Catalog navigation</li>
<li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">Support for IOS multi-tasking, with the app retaining the state when you switch out of it</li>
<li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">Ability to launch the app via a URL pointing to a particular catalog object</li>
<li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">Graph interactivity, support for the new trellis view, search and interactive scorecards</li>
<li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">Print analyses and other catalog objects via wireless printing</li>
<li style="border: 0px; color: #333333; line-height: 18px; margin: 0px 0px 3px; padding: 0px;">Offline storage of content with the ability to refresh on-demand</li>
</ul><div style="text-align: left;"><span style="color: #333333; font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 12px; line-height: 18px;">Until Next Time ... :)</span></span></div>Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-82601225409448467122012-06-17T17:08:00.001-07:002012-06-17T17:08:56.757-07:00Moving Report Links in the DashboardSo, if you wanted to move the reports link to a custom position in the dashboard, you can achieve that by placing the following code in a narrative view where ever needed. Below is the code:<br />
<br />
<br />
<br />
<style>.ResultlinksCell { background-color: Red; border-top: white; border-left: Black;<br />
position:relative;<br />
top:-150px;<br />
left:-350px;<br />
}</style><br />
<br />
Until Next Time... :)<br />Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-50439701315663204382012-04-17T06:43:00.002-07:002012-04-17T06:43:27.909-07:00How to deliver an agent on first day of the month?Create a request.<br />
<br />
Select (*) from TABLE where (select next_day(trunc(sysdate,'month'),'mon') from dual) = sysdate<br />
<br />
This will return null except for when its first day of the month.<br />
<br />
Set an ibot as as condition of this, to only run when the report shows data. <br />
<br />
<br />
Until Next Time... :)<br />Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-54524927574362854012012-03-17T17:12:00.003-07:002012-03-17T17:14:47.055-07:00OBIEE 11g: ImpersonationImpersonation is probably the best way to troubleshoot production issues. Below are the things that needs to be done in order for an Aministrator to be able to impersonate as any user from the system:<br />
<br />
1) Application policies for BI Administrator role needs to be modified around to add two new permissions:<br />
<span style="font-size: small;"> a) </span><span style="font-family: arial,helvetica,sans-serif; font-size: small;">oracle.bi.server.impersonateUser</span><span style="font-size: small;"><b><span style="font-family: arial,helvetica,sans-serif;"> </span></b></span><br />
<span style="font-family: arial,helvetica,sans-serif; font-size: small;"> b) oracle.bi.server.queryUserPopulation</span><br />
<br />
<br />
<img alt="" height="129" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABFoAAADmCAIAAABqG3bZAAAgAElEQVR4nO2d4Yo0y5Ge5572Io3BGIN3rd31er1e2+tjW16b9S0M6IfA12DpCI6QQAghCf2zfwwM/WVmvPFmZlVlVs1zeBh6qjMjI96I6szoOV/325//+T/74Gc/+/n7//m/AA5UCwAAAADclJ/97Od/+tOfvv/++x9++OHt3/zFP/+AAy74UC0AAAAAcFO+aYf+8i//xQcccMGHagEAAACAm/JNO/Rv//pffsABF3yoFgAAAAC4Kd+0Q3/7N//qAw644HN4tbz92V8tDwrWQg0cqxV6wuFQeF+cj+SmKaYG4BZ80w79+7/91x/QDoHPA9oh82V90sm3P/urTy4O8Aw3zjsM7bZ9viq2m2/DidgwkGsC35+izLYN4csWXpdEJ71u9O5ZZ8ju+/Clkg435Zt26D/83V98cFk79Pb2tlwCmOQB7dA1625yxNnEjYWJeJJXpmPbOg81z26HvhRn53H5O2umD1+8DOAWfNMO/ce//9EH/gH37eW/4koxJpqujfvX/c6KHuxYmtVSvCVWvG7Wb5i9XhHD9BKOzcKZ4qcYXy/9OiVat5gVPdYWmmJGsQxM1/kqZKntiOXSMeabx131c7hiafp6K6EZ4Kn3S+2eHuZURVcVaWe2qsDl9VYPdsKk8PzCSxVzSjSKTlfCIcu9xtirm7PQWLWkc51hAKv4ph36h//81x90tUP146LfGG6HuqAdWkVdLc3TQLQLvlcvlGLbi65E5w/TJb2i6Xm6N0Qb+YDnaSy90x2D6enET6WQN1J7oWLOY3/RgtQ9racjqSOaKaOZBSeKgQRdU4Fdkc6Eo6dH48UACs8sPF/brjFmmQ2/evh+Rro56XAQN6CeArAt37RD3/2Xv/ngwHYouvj6R6T68euU5h+gCjv142iY82vhLWjMdqgYEO3Kr1OKYbWFpsGZI0vTjWbUvTtxHbXwPN3k0iup/WKnTM9J9YPI23mHI7VXKSb81EccUcAiOu2S8ETfL3qJKJXOuuZ47cw+Fbi83pphijKox1N4Ot7mA6f89JioVLoC1MbNuur1UBRJWg/mdH8VgCV80w791+/+3Qcz/7Pcx8X6sWiWojF1ZxJdr4c1+5nIYPEsvVAXve2QswfXF5uI/a9pU7vU5UYal3ApmpWG5l8R9nuvRGcIEa/YLwccXq6YGCZy2lS1psu94fvFcU/I2KuAr6Sz1sUVmD4rhDr2DjVDELK8ukrhmYV0yJVoxdThNBG6Kno9LMwOpDKdqJMCsAnftEP//b/93Qen/nXowHYo7cE+f33t2dJ2aHlW7sUF7VC685k2u6aMGRE+pxGZOgwftpwwHfFThYsxk6dDMf4axSLHes8iERfcL8LI8D015udMgs6uwPSuvP4OfTNaFyELhae9msngfBn3TqwH9L4EmXXYJLKWTjTtA6zlm3boH//H339wVDv0Vv3XnDLWDr0uEXniTBfPgoP/UQr1s68D6o2/GJM+pa+8Ze+Mfo6pr9e/fhoRgdTGm9YcC9GVaPsXBpvbkhijzxDmWo59/8rFijle1ZUQ2Wly2f0SZdORcSAvzcGOVksqMNX/mnqr7WibTiopPFOxOl86Fj+VuhodEURhO4VkFrNTLa8qmWXm2AdYyDft0P/8x//0wYHtUD342HZIDIse0w4dy1O/pUq/gvs7ARyr/CZEBx3olW4ftnUMNmeych5feI8PEB7AN+3QP/2vf/jgqA/abvYt9ayxdqhY9/NKc92mk7XD9VxI+YLtkHjbEs4WfxNoh46SbhP29Ap2putPK9rO8lii0MwYxfgNowOo+aYd+t//9N0HTz3gwhlQLQAAAABwU2iHYBaqBQAAAABuCu0QzEK1AAAAAMBNoR2CWagWAAAAALgptEMwy+HVwr+8BGrgWK2u/9fe0Xgy+zWhSjcUvNea84EKywMHGIN2CGZ5QDs08KnZA076n9JzdrCHuHHe+Wa3PbXrE5aWuDcw5qiDY+/4VQI+9dtR7vIpXlTpGZKKV6Ql7dBdpAOooR2CWR7QDl2z7ianlk3cWJiIJ3llOsb77k/l2e3QGas447eVcVUItEPweGiHYJZmtRRvXBUvps2vJnj79ruum8P0Eo7NwpnipxhfL/06JVq3mBU91haaYkaxDEzX+Spkqe2I5dIx5vvBXfVzuGJp+noroRngqfdL7Z4e1lzFCbAYFimfhiw836pclxdnPdhMJVV6RpWm8o55KHTrKtqjcp3OdYYBbAXtEMxSV0tzd3FOEtFFsQeIFX2X9Iqm5+mG0bQ55nkaS+90x2BTLrFc14qp2gsVcx77ixak7mk9HUkd0cxUDoTcvNIb8kA2rynXaHVnxQNv52i8GECVplcGqtRPRNcYMWssTB9x++gpAPeCdghmMduhYkC00b5/u/G8ffseVWGhaXDmFNJ0oxl1735ZRy08jza/sc2yab84cqVHn/pB5O28w5HaqxQTfjZPP04Bi+i0S8ITfb/oJbSMZoC+8ukNO7lu/eCkcq2fvbg4m2GKmqnHU6UHVmnzgVOrqYeRbl1B6RSn2TSn+6sA7APtEMzS2w4522p9sYnYpZxtcsaNNC7hktjOdWhj5yetTHpFHKSieMUmOuDwcsXEMJHT6CQ3dj4Tlp37xXFPyOgHaCrvFOHMuvWDk8o1fVaoeuztbIYgZHl1lSpN54osdCW390pz6a7s6Cx0CZJOB7gLtEMwywXtUL3ZpIO7tklz8xs7uDSd1xd9P7vOTzPng/qBPqiZh7PUjlbpGsUix/yqnjkFHnK/CCPOPTWsqnOu0ssNZ/Psck1v4etv5zejdRGyUKVdlaBDmF+9qySGq6gr1+lE0z7AhtAOwSz+RynUz74OqPfyYkz6lL7ylr3Z+Tmmvl7/+mlEBFIbb1pzLERXok1aGGzuVWKM3unNtRz7/pWLFXO8qishstPksvslymYqozbruKq9Te8OIeySck2TdU1x1nZS2dMkUqUDVZo67HjoXDHrKrVg5vrVbbNIHPsAu0E7BLM8tVr0y7q/PcCxym9CdDCCU3Xeh20dgydxuzK7ncMAH9AOwSxPrRbxsh69WQgXiL8JtENLdN6EPb2Cx9D1l5yj1jIXFeO5L+C+0A7BLFQLAAAAANwU2iGYhWoBAAAAgJtCOwSzUC0AAAAAcFNoh2AWqgUAAAAAbgrtEMxyeLXwzzGBGjhWK/Q8SkmAM+AuvlJJ2Flq82N7D1+ddghmeUA7NPCp2QNO+h/dc3awh7hx3v69237W9bFLS9wbGLMkEOfD6091z3fgq/HU4/hdPvqMu/gMByBVUu9rS6Re9SVXtEMwywPaoWvW3WRX3sSNhYl4klemY5s4v/wcs9wBuJhnt0MbuspdfBfmS452COAbmtVSvOVQ1Hfz+wo+r4hhegnHZuFM8VOMr5d+nRKtW8yKHmsLTTGjWAam63wVstR2xHLpGK1SM8zrFUvT11sJzQBPvV9q96KqHnbDybL/60Dl9C4h6kREqm8K0+HUfloSYqKeG3l+XlLmq6hpqiunvWHqZEWkSwvLYpguEnPMjP7mgKMKpmsJUTAi0tdEO0lvOpzaT0siqoTLPJlX3ndAYKoUzXWGOdAOwSx1tRR3xXt1h9fP6ovNl490Rd8lvaLpeXoPN22OeZ7G0jvdMdiUSyzXtWKq9kLFnMf+ogWpe1pPR1JHtC6VZmSvg+rV0AzTka75bJcbURV1OdxbsQOyr7qdo9WdFQ+5eaN8mQnlLuYuNh0+5C6+0pNI5DOkNhGvRXrKIdAOwSxmO1QMiDaS929fOF6H1RaaBo96lR9+6RdT6nCankevJgOvPpH9Yo8U6kWv1JG38w5Haq9STPjZ3L2cAhbRaZeEJ/p+0Us4KqWyp1XkxzWQuOiKlq5+tsuN5gPnVkoD157rrJk+1BE1c3pgUpwqmllOxF7/KoYJMSNmqt1cLl3CkSvV3ylOM675gjGlq5/tcqP5wLmD0sC1502byz05Q2pNalbPdYY50A7BLL3tkPPyWl9sIu7tpk3tUpcbaVzCJefF4qjdxdxs0gzWD0S8My+XTUHWKiaGiZw2Va3pcm/4fjHd81XSsvcaPCRxOpW+A11u6JvikCup/gOZTT0/6nZOn20uMVwDYnUzBCHLq6vcxf6z3MWO/jt4cp7UAsesOX0S2iGY5YJ2qH6xSAcPvKQe+Lrc9DmNyNRhzA0zTEf8VOFizLDDwsMrFYsc86tav2RfcL/4RwHfjQNln7QQvT6ct7s7N8V5V3qztuR2Tl/irn+5ezNalzShEdzF3MVdV3TsZ3tSO3Oq1ALHrDl9EtohmMX/KIX62dcB9V5VjEmf0lfesjfzPsfU1+tfP42IQGrjTWuOhehK9CIrDDZfPsQY/UptruXY969crJjjVV0JkZ0ml90vUTb1mDHZ01ssiqu3crQP0RKiKvz6SWX006HljarRKTwt2qufpg8D9oerSEvq++ynXgcrSFMmXNWCCAv+mDH9hSc6ruGCEU46Djih+UmvSy71yqzG1IFTPemdOCm1pmnWnJiO8aEdglmeWi36TvPvWDhW+U2INrb78oAQHqBSr/1ts7atY88G2XdQaZ8sLPfkVAdoh2Avnlot4k6L3uyBC8TfBNqhL4X/TufF9vfM2p5efQVQXouz5138PE8iB17/EOR4KMYfHh3tEMxCtQAAAADATaEdglmoFgAAAAC4KbRDMAvVAgAAAAA3hXYIZqFaAAAAAOCm0A7BLIdXyw7/EhHWQg0cq9VRejb/aezZi8J9+YLFSdmbH7uKULAVtEMwywPaoYFPzR77DKjln/dyoBvnHXR22ya7PglniXsDY45Kjbh3dtDq+i+vuCyuUz9kaa3+ty5O5xsazOu9W9Imr1GrvjcGYAbaIZjlAe3QNetucnzZxI2FiXiSV6ZjD3sDHp7dDh211t3/OuSb2qoAaIfgjtAOwSzNainepipeH5sfIf95RQzTSzg2C2eKn2J8vfTrlGjdYlb0WFtoihnFMjBd56uQpbYjlkvHmCeYrvo5XLE0fb2V0Azw1Puldi+q6lQ331VHk2K6cGarKl1ek/VgJ0yK85Di1FE7BSnCiYyk9d+VuFq9rvC7KiSd6wwDOBvaIZilrpZoo6rnNl83xet1dCU6W5gu6RVNz9M9INqBBjxPY+md7hh0tmEzlUJesa+vUsx57C9akLqn9XQkdUSbCeqoRBySxGuqNFr9KCnM6dF4MYDiHMtIROpMWpBdTgr33lo9STT+qPCFGubc3iUAToJ2CGYx26FiQLTjvn/7Wly8xBcWmgZnNr+mG82oB7aQZjhNz9NdML2S2i+2xvQMVD8QW/Kkw5HaqxQTfqaHj6iARXTaJeGJvl/0EsO66WJIndT3lz/34iqtn73+Lm7O1cPMaumqnC9YnDrqVHntqnCy695Jx4vKScN31DCn+6sAnArtEMzS2w45+2t9sYl44W7a1C51uZHGJVwS5x4dmn9F2O+9ovf1ZrxiXxxweLliYpjIaVPVmi73hu8X070B3UQx9C4673D94KQqTZ/tkmLmLjZDELK8ukpxatkHnOnNlHbSdy8dL17BtH1TjYHpAAuhHYJZLmiH0pds02bXlDEjwuc0IlOH4YPUzFGjfqBPbF17v7CjVbpGscgxv6pnjoOH3C/+cW1MyUMSMe9M/eDwKk3v3Ovv4rfRv1E01yqgOIXnztym8jO6RVN6wxm2nxoZng6wENohmMX/KIX62dcB9aZejEmf0lfesnc9P8fU1+tfP42IQGrjTWuOhehKtJUKg83tR4xJ93VnLce+f+VixRyv6kqI7DS57H6JspmGIApeFIPwJIrU13NJlaY5uqYmazvaZhosxekXp45aK1/nWjgZJdfxJw3HKbm0NkTsZmmZSwCcDe0QzPLUatGv1P4rPhyr/CaIo9JN2SqErZy5hWPPBtkfCWmFfaAdglmeWi3ilXrg/TM4SvxNoB36Os5s7tVXAOU34fUPQc5fF8V4cgpbQTsEs1AtAAAAAHBTaIdgFqoFAAAAAG4K7RDMQrUAAAAAwE2hHYJZqBYAAAAAuCm0QzDL4dXCv7AEagBV4RY8taieFJf5OahPChmgF9ohmOUB7dDAp2YPOOl/Gs/ZwR7ixnlfK7Hbrtz1SUo7s7nzT/2ikss+UKsu1OjrcSLftM2ZjPSuuyQ1flxds7q+wOekME3jOyQFYAm0QzDLA9qha9bd5DNGN3FjYSKe5NVXC+GOXNkOiSuvDVLkW2pwbEzvuqtSMxDXWF7mRw44QDsEIKAdglma1VK/Jfn+8lLb/AqC13c0o2F6Ccdm4UzxU4yvl36dEq1bzIoeawtNMaNYBqbrfBWy1HbEcukYrVIzzOsVS9PXWwnNALU+URZMOyJlwnLhRn1riGzuU1HL66ce7IQ5UEjN1AjPo4RG1vyi0ikYSKW4YsouAtQ1L2q16UOUzbHK6YpI58iZ6A8DeBi0QzBLXS3NPdg5pkQX9TYfrei7pFc0Pfd339fHY56nsfROdww25RLLda2Yqr1QMeexv2hBr7XI7Ug6P2Xp7aDv4gHBr6koke4r77g0cb2JaBbSW+scHDnTDF/IKNweGJzq0DXGL9fauFMbaa2aNaxvovRFJtV5Jkdm3gEeCe0QzGK2Q8WA6Dj4/u1Lf7G7FxaaBmeOOE03mlEP7MHNcKIzzbDnQmpxZhLqpQcCsdmPORypvUox4ac+SIkCTnOULtS8KXTJ6Vujmd/oisjObhW1vH4iYfWwsULSBWAWUno9LSphrfnAKZX0BhFjel1qJqu+Ho1PK0qLmTqTMpYjnXeAZ0M7BLP0tkPpq7z/2i12vqZN7VKXG2lcwiV9dBOhjR3OtDLpFX0gaMYrtuEBh5crJoY5B6nCQ+fc5h/LUg9rI9EwnV9TGT+idMWjKip9trmEL4V/x5khCFleXe0tJC2+Tmua68hIb9IPuaLjijQcSErqmK4Wv65MkSdz5OgG8FRoh2CWC9qh9Aho2uyaMmZE+JxGZOowfDhzwnTETxUuxkyeJsX4axSLHBs72TjR+cey5gNt1ixU/54aFvzsikrvsuvvuLfRk3dzrYL0Fcy8Yg4WReWbGlO790rqz1hSzHvEKT9nZCryZI6iTAF8BWiHYBb/oxTqZ18H1AeFYkz6lL7ylr0R+Dmmvl7/+mlEBFIbb1pzLERXoj1YGGzudmJMeiBw1nLs+1cuVszxqq6EyE4TXasiC5EbOuroYpS1SDQ/9iUVFdX8xfVT20mzo4NNqyjy07wS2fSLqmknuiJ81neEL3vqT29SIlebNfya96hyCgcGIhJmo2Jw0gTwRaAdglmeWi3Obsrmcb3ymxAdpx6pQNfJch+2dQwOhCwjJsA8tEMwy1OrRWwMA2/XwVHib8JXaIf8P0osd/UuXm1L8ZelSfWOtaaX2MSfuyROjH+SLAC90A7BLFQLAAAAANwU2iGYhWoBAAAAgJtCOwSzUC0AAAAAcFNoh2AWqgUAAAAAbgrtEMxyeLXwDzqBGhjWDem+Ahdn+cq6umMB39Hn5XLd9DNa4KnQDsEsD2iHBj41e8DJTT7X6MAPjzpDpeFZ1yi2m2+rdHvqd5jc5bO2VuX6wHUjUyd9DN1l9icjHf5yobto9d6z4W57A8LzoB2CWR7QDl2z7ibHrE3cWJiIJ3l1Lw/3h3Zo7VonLXfla/tlpi5uUw+Xi3YItoJ2CGZpVkvxrlXx8tf8xoPPK2KYXsKxWThT/BTj66Vfp0TrFrOix9pCU8woloHpOl+FLLUdsVw6RqvUDPN6xdL09VZCM0CtT5SFyEhdxkL5fbK/PNf1YCfMo5LuB65r9YK68vPSG0JX1sbKOLWQ6tAcH4kZrSiy0CVO/Xi5Vl2lns51hgFMQjsEs9TVUr9Miw3mvXq906/1zSvNFX2X0t3F8Tx9iW/aHPM8jaV3umMw3ZL9VAp5xUFklWLOY3/Rgl5rkdv1LFG322Z/ea4jtc10TCbdfKnxlfRz4deVuW5X7popMMugN+9jZdkVYHqzmDdRb1AbaqVT7E8BOBvaIZjFbIeKAdHJ4P3bF+jXYbWFpsGZY1PTjWbUvWeaOmrhebojpldS+8X+J9RL9/g6nEmHI7VXKSb81GcIUcBpjtKFmjeFltH0c2H2l+e6GWYxUsviJ134KVb0lzuvrqIKMddyJqZlMJz3sbLsCjC6WZrjdUnrRevUb6KVI50z0R8GMAntEMzS2w6Z26T/ItscHG29wqUuN9K4hEvOXnLIZuYok17Re3wzXn2y6XV4uWJimMhpU9UaU/8oCwMqOX6uyv7yXDfD9NMxlvT0xSTyPNLH13asruavpMN6i2RGz8NX7K2izzoZcGNDrUwH0ommfYBDoB2CWS5oh9Kt2rTZNWXMiPC5dyebOXn4avsGm3u84/yww8LDKxWLHOs9Q0TMnLSaD0RQw+Kcnf00iuvvjrfRvwMclfRU8F4lj6qr+SvpsN6ba0bPs8WcFMR/dq1WEU6KzekA50E7BLP4H6VQP/s6oD58FGPSp/SVt+zd2c8x9fX6108jIpDaeNOaYyG6Em2rwmBzdxFj0j3eWcux71+5WDHHq7oSIjtNdK2KLEQFlhabvlOuz764TVbdHSIjOgvDSW8+27SsBTm7rqIMRrKbIRSl5WTNLOPXbPohRGL2VkW04ufPZiBOfRYBrtVK4KQ4mpiOATgE2iGY5anVol+I/Rd0OFb5TYjOIpsrsK222zr2JB4j8tmBPEaou2v1pETA5tAOwSxPrRbxQhy9qQYXiL8JtEOP9+p5PEbnkwLx/9xxIy7W6vUPQY6YYvzDEgGbQzsEs1AtAAAAAHBTaIdgFqoFAAAAAG4K7RDMQrUAAAAAwE2hHYJZqBYAAAAAuCm0QzDL4dXCP6AEaqBLEOTqVRLFuuQC5AJ4NrRDMMsD2qGBE9KAk11f1HBqsIe4cd63Rux2pOj6oKT5tQau76ZYU8A0lsucWe7DvP9PXW5DV3sL5kaKAcAntEMwywPaoWvW3eREuIkbCxOxs1e97dDOir26t0/V3b0dWiIX0A4BPBvaIZilWS3NL72uv9C6OV4M00s4Ngtnip9ifL3065Ro3WJW9FhbaIoZxTIwXeerkKW2I5ZLx2iVmmFer1iavt5KENH5QpnK7CBgPdipnAElI4mEM10Tfd20fV+uSPnUSC24n/00kIcpE2lV/NQ2iyicygSAfaAdglnqamluVNG2+l5tHtFuFy0Rrei7pFc0PU+PWXo/7vI8jaV3umMwPZT4qRTyiuPXKsWcx/6iBWl0Qhadi30ELIxEt7OuNEdJjanVZIrNlOmF0mQ5Rfv6IC0wP4qHKdN8UC/UdWM61QgAW0E7BLOY7VAxoDgO1tP1Wae42Dxi+i5pN5pRO8fEps+O53rr7TpqRPaL/V6oJ04MUSImHY7UXqWY8FMfzkQBi+jSx5EbuvYWCtisnGJkU8xeJaPY61VSO6YIzo3T9MeRKxLN0dzPvkhEM4rnKRP9FDHqghyoUgBYC+0QzNLbDulno4tNom0ysqld6nIjjUu41HUy6PVcBD52pXY7Oh9Ezk86vFwxMUzktKlqjXDGjFrnYgcBm5UjbOoDrlBSZy1avWti6liqs1Bb6Kk1SddysuMk95HKRD99TbSfALA/tEMwywXtUPPQqQeLTXFsC++Kq+lzGpGpw/DZ1D+paFedY8fw2aJ5ktD1c7ZikWN+VY+dVh0LOhdpmV1fcs3DbvNcO6Cko210F5gTh2Vxcjd2h0brmtkfu/2foYw/oOvG7K1SAFgO7RDM4n+UQv3s64D6nPRWve+rn9JX3oy35KPl6l8/jYhAauNNa46F6Ep0AhAGo/07GhOdhwoFtB3Hvn/lYsUcr+pKiOw0xa+dEWbruc1c6NpbVXIiuqjSfCUjiepVHFNRUEIoXdim2mml+Ul0st8MrXnlecoIC5HZyGYaHQDsDO0QzPLUatG7mn+ogmOV34T6iLncpZsqeRe+uJgi/C+uDGoAPADaIZjlqdXibP/sfNeLvwlL2qHXt+HTv5bsr+Fafa7Rs9elPUGZQ4QCgG2hHYJZqBYAAAAAuCm0QzAL1QIAAAAAN4V2CGahWgAAAADgptAOwSxUCwAAAADcFNohmOXwauFfowI1MCAIom3FwIdPPjWDT40LAB4D7RDM8oB26JqDyyafoXSUG+cd0Hc7PF35+VfiK1lup9v1iK+XWeJMrw/bZnBe1W1DAwB4px2CeR7QDl2z7iYHtU3cWJiInb2iHZpUb5/yfmo7tMoCAMB50A7BLM1qqb8X/P1lR6zfaH+94nzzd3MJx2bhTPFTjK+Xfp0SrVvMih5rC00xo1gGput8FbLUdsRy6RitUjPM6xVL09dbCSI6X6h6ld4bRwsY6aNdWpuperBTogMp08I2nXEmLsygvlI8bmbKcXtAVQCAC6AdglnqaokOi/Xc5olBbLfRlegUZbqkVzQ9T08/0QFiwPM0lt7pjsGmXGK5rhVTtRcq5jz2Fy1IoxOyOGr0ThnWZ4dMFUai1w1d0k7KHIUPScc1GTwqU6IwnLgAAFZBOwSzmO1QMeCteruxniKOIMXF5hHTd0m70YzaOYU0fXY812firoNIZL84LQn19NmxGc6kw5HaqxQTfjZPnE4Bi+jSx3pueuh0XE1zGnm1vLaj7IhhAymLhK1XGUvHxRnU06MsCJHTuxgAYCtoh2CW3nYo3f7NM8H7yzavj2WmS11upHEJl8xjrn9A1EdGrUx6RZwdo3jFiXDA4eWKiWEip01Va4QzZtTpugNTIudTrzapbbP8REnrlPmqHpKOszM48PopxHTcBgDYCtohmOWCdkjsuOYG33vwai43dlYTJ2bHwoFHRidMR/xU4WLM5BlXjL9Gscgxv6r1QdBZsfcU3rWcacSvjVWZKq6kNkVJ957do1Um03FNBgdeP7vSPSYpAMBl0A7BLP5HKdTPvg6ojy9v1dux+il95dtqC88AABmwSURBVM14Sz5arv7104gIpDbetOZYiK5EZxdhMDqpRGP02dFcy7HvX7lYMceruhIiO03xa2eE2Sh32v8uV/37KCqSJZmq7WibaaF20VzFMbVJBlODdUQ6O8VTA5ICAFwD7RDM8tRq0fu3f9aBY5XfhLRZ2pZJVznsLueMDG7uMwDAqdAOwSxPrRb9fnw6Bk4SfxOWtEOv7+ubf8Sopxx+mN4/WcsTMZOCCzJ4gVzLUwYAIKAdglmoFgAAAAC4KbRDMAvVAgAAAAA3hXYIZqFaAAAAAOCm0A7BLFQLAAAAANwU2iGY5fBq4d/dAjXQJQhy9SrZ+2EGh49czo1cBQA4G9ohmOUB7dCpJ6TXKYd8MNR8sJd9PtXw97cs1EcrdrZv4qtmxPXdFGsKmMZymTO9PtyiHRp7RVqYCACAfaAdglke0A5ds+4mJ8JN3FiYiJ296m2Hdlbs1b19qu6p7dCwFAAAQDsEszSrpf5G8/eX3bd+o/31ihiml3BsFs4UP8X4eunXKdG6xazosbbQFDOKZWC6zlchS21HLJeO0So1w7xesTR9vZUgovOFMpXZQcB6sFM5A0pGEglnnIl+GXfddI6rkedRRlIjzcIAAPji0A7BLHW1RIfFem7zaBLt99ES0Yq+S3pF0/P0mNW0OeZ5GkvvdMdgeizzUynkjdReqJjz2F+0II1OyKJzsY+A9XldRFE/8JXUmFpNptgcqVfs0ty8H8XrGADAF4d2CGYx26FiQHEcrKfrs05xsXnE9F3SbjSjdo6JTZ8dz+dP3qn94mgl1NOH1GY4kw5Haq9STPipj6eigEV06ePIDV17CwVsVk4xsilmr5JR7PUqqR0noZEs4vYR6zZvpWi5pphOLkSYAABfFtohmKW3HdLPRhebRAeFyKZ2qcuNNC7hknnM9U+i6al95oo4pEbxiqPngMPLFRPDRE6bqtYIZ8yodS52ELBZOcJm2kJESuqsRat3Tew1nsbiZEHorO13hQkA8GWhHYJZLmiHmodOPVgcC8wpY0aEz2lEpg7DZ9PeU50ORB+8zINvakerdI1ikWN+VetDp7OiPu6P1d5lAhZXUpui0nqP7ye1Q/pKbxLTnI7duc7qtEMAAO+0QzCP/1EK9bOvA+pz0lv1vq9+Sl95M96Sj5arf/00IgKpjTetORaiK9EZSBiMTkXRGH1INddy7PtXLlbM8aquhMhOU/zaGWG2ntvMha69VSUnoosqzVcykqhexTFVix/9ajqsF02zkFagmVzTHwCArwPtEMzy1GpJzy7pGDhD+U3oOulu4iQslHfDXGzoEgDAEmiHYJanVos4K4j3a+Fs8TdhSTv0+ueI9K8l+2u4Vp+B8TMKR39Pm/nD16RWy/MFALAJtEMwC9UCAAAAADeFdghmoVoAAAAA4KbQDsEsVAsAAAAA3BTaIZiFagEAAACAm0I7BLMcXi38G1+gBroEQa5eJS/+ULjhjwhfLtc+bgAAnAftEMzygHbomhPSwk+ROsMN85tbTrK8SrGzfYvs6+u7KdYUMI3lMmd6fXhYOzT22nVqUgAA1kI7BLM8oB26Zt1NToSbuLEwETt71dsO7azYq3v7VB3t0K09AQA4A9ohmKVZLc3vUxdflP56xfk+9eYSjs3CmeKnGF8v/TolWreYFT3WFppiRrEMTNf5KmSp7Yjl0jFapWaY1yuWpq+3EkR0vlCmMjsIWA92KmdAyUgi4YwzMZWlNi5GpqGlSe8SPMpdaqRZQgAAj4R2CGapqyU6LNZzm0eTaBePlohW9F3SK5qep8esps0xz9NYeqc7BtPDlp9KIW+k9kLFnMf+ogVpdEIWnYt9BKxP4SKK+oGvpMbUaiDFjsNpQp0xvuBpus2yT50BAHgAtEMwi9kOFQOK42A9XZ91iovNI6bvknajGbVzTGz67Hg+f/JO7RcHJqGePvM1w5l0OFJ7lWLCT33oFAUsoksfR27o2lsoYLNyipFNMXuVjGKvV0nt+CJEP6ORdYzprdeMyBE8kt3JmhAEAOBh0A7BLL3tkH42utgk2v4jm9qlLjfSuIRLXSee+bOpVia9Ig6pUbzi6Dng8HLFxDCR06aqNcIZM2qdix0EbFaOsKkP7kJJnbVo9a6JkSkntElhnXyJjGhVuwQBAHgYtEMwywXtUPPQqQeLzd6cMmZE+JxGZOowfDZ1wnTEd45TvafA6Fet0jWKRY75VZ2eawdWd3KRltn1Jdc8xDfP6wNKOtpGd4E50RHWWXRAWCf7Y/e4s26v8gAAN4J2CGbxP0qhfvZ1QH1Oeqve99VP6Stvxlvy0XL1r59GRCC18aY1x0J0JTrZCIPRWScaow+p5lqOff/KxYo5XtWVENlpil87I8zWc5u50LW3quREdFGl+UpGEtWrOKZq8YXCkdp1aFpYM+k6X2mtmmXQnA4A8Dxoh2CWp1aLPgH4hyo4VvlNSJulHdjTK7gdFBIAPJuPduinP/3pj3/8Y9ohGOGp1SJOAOJdWDhb/E1Y0g69/t0g/WvJ/hqu1Wdg/C2COsOB5SIAAJzKRzv04x//+Be/+AXtEIxAtQAAAADATfloh370ox/98Y9/pB2CEagWAAAAALgpn+3QH/7wB9ohGIFqAQAAAICbQjsEs1AtAAAAAHBTaIdglsOrhX+5C9SAKcikUOjcJZTz2Qzzqyy0QD0AwNeEdghmeUA7NPCp2QNObvIBVke5YX5zy0mWVyl2tm+9bc9kFnaTupZ9E1cPbIdOTcf8hw3uXBIAACdBOwSzPKAdumbdTc52m7ixMBE7e0U79OrbPrX6jHboGgsAALeDdghmaVZL81vSxdefv15xviW9uYRjs3Cm+CnG10u/TonWLWZFj7WFpphRLAPTdb4KWWo7Yrl0jFapGeb1iqXp660EEZ0vlBiQqqELeBPZ68FmOL36a2GbzqSzzkiHiKuYGGlirjKmGADAfaEdglnqaokOi/Xc5iGjvljPTY+qzgBx1tGriyniJNG0OeZ5GkvvdMdgUy6xXNeKqdoLFXMe+4sWpNEJWdIxXWo3py8v1Gi8GNCrv0ZU+8Xp0L75mpgvbgAAXwfaIZjFbIeKAcVxsJ6uTy3FxeYR03dJu9GM2jnwNX12PJ8/eaf2i4OpUC89WtXhTDocqb1KMeFnLU6hTFTAIrr0cTrXyaazxPJCjaQWwwb0j4StV0ntnJoO7VukVX09XWVALgCAW0M7BLP0tkP62ehik+aBoF7FdKnLjTQu4ZJ5zPXPlOYBa+yKPlo14xWHyAGHlysmhomcNlWtEc6YUR8VrFkGl8luHuWd+tT6+6qmL0qnpmNgCVNDsQQAwFeAdghmuaAdah469eD0nGGeX8fiavqcRmTqMHnAck692tVU4WLM5LFYjL9Gscgxv6r1+dJZ8ZDDsRlsWpzXF+rb6F9CHP19VVM7J9Xe8BJNTdJVeuUCALg7tEMwi/9RCvWzrwPqE89b9Q6ufkpfeTPeko+Wq3/9NCICqY03rTkWoivNU5o2GB2AojHp0cpZy7HvX7lYMceruhIiO03xa2eE2abn2pn0XhOJXiV7bUfbTKuui+YqTioPT4eziqmJs8qYXAAAt4Z2CGZ5arXoY4F5PILDld+EtFm6L0+KBXoh+wDwBaEdglmeWi363dl0DJwk/iYsaYde/wgw/HePuyu/XNULsrBkrfcvmX0AgHfaIZiHagEAAACAm0I7BLNQLQAAAABwU2iHYBaqBQAAAABuCu0QzEK1AAAAAMBNoR2CWQ6vFv45L1ADXYIgV6+SvYotVHhyaWoDACCFdghmeUA7NHBCGnDyso+HusYNZ/rwV74s1EcrtuqjvfT13RRrCpjGcpkzAz6cV+1dDj/jhgIA2A3aIZjlAe3QNetuciLcxI2FidjZq952aGfFXt3bp+pu/dch2iEAgDOgHYJZmtVSf2n6+8uuXL/RHn2lung/vl7CsVk4U/wU4+ulX6dE6xazosfaQlPMKJaB6TpfhSy1HbFcOkar1AzzesXS9PVWgojOF8pUZgcB68FO5QwoGUkknDEnOvntKiftZL2iLo80tDHpAAC+CLRDMEtdLdFhsZ7b3L/ri9HxTq/ou6RXND1Pj1lNm2Oep7H0TncMNuUSy3WtmKq9UDHnsb9oQRqdkEXnYh8BCyPR7awrzVFSY2rVFVRq2U9ir3GdFB0OAAC8QjsEs5jtUDHgrXrjs54izjrFxeYR03dJu9GM2jkmNn12PJ8/eaf2i+OsUE8fUpvhTDocqb1KMeFnLU6hTFTAIrr0ceSGeRpeUnKRaGLYgJJR7PUqqR1RlloTs5xMxYRx7ZIOBwAAXqEdgll626F0FzfPK+8vx7h68PBpxnQjjUu4ZB5z/ZNoemqfuSIOqVG84ug54PByxcQwkdOmqjXCGTNqnYsdBGxWjrApKk0rqbMWre6n29HELCdTsVQ0LVSXGwAAXxbaIZjlgnaoeejUg4dPM9GsrriaPqcRmToMn02dMB3xnWOfefBN7WiVrlEscsyvan0YdVbUx/2x2rtMwOJKalNUWu+xfqt2SCex1zjtEADAUdAOwSz+RynUz74OqM9Jb9X7vvopfeXNeEs+Wq7+9dOICKQ23rTmWIiuRCcwYbB5MBJj9CHVXMux71+5WDHHq7oSIjtN8WtnhNl6bjMXuvZWlZyILqo0X8lIonoVx1QU70C1p877gps6iwIDAIAC2iGY5anVkh5f0jFwhvKbkDZLO7CnV3AxlAEAgIZ2CGZ5arWIM0T6diycJ/4mLGmHXv9i4PzBYblK1yfF12dg/BIn55dbnhcAgM2hHYJZqBYAAAAAuCm0QzAL1QIAAAAAN4V2CGahWgAAAADgptAOwSxUCwAAAADcFNohmOXwauHf/gI10CUIcvUq2aUY8h4lOwqv1RkAImiHYJYHtEPXnJAu/gCrs90wv7nlJMurFFv1OWD6+m6KNQVMY7nMmV4fzMHNYQuD3aoqDmmHnqfwGc5vlXeAu0A7BLM8oB26Zt1NToSbuLEwETt7NfZNmnsq9urePlXHX4cWyo7CFwT+ZcUEmIF2CGZpVkvz69KjL1MvrohhegnHZuFM8VOMr5d+nRKtW8yKHmsLTTGjWAam63wVstR2xHLpGK1SM8zrFUvT11sJIjpfKFOZHQSsBzuVM6BkJJFwxplo6nbULaCdj2KJcpQaaY7UtdEsV2cWCjdFa67iJCKKbuxOAfjK0A7BLHW1NLcN8apdPBXtPdES0Yq+S3pF0/PmutqHYc/TWHqnOwbTI4KfSiGvODatUsx57C9akEYnZNG52EfA+pwnoqgf+EpqTK3GUuxfTG+B6LqfBfMOFfd4b+r95KKwGDx2k6ZxAUAK7RDMYrZDxYDiOFhP12ed4mI9eOyE13SjGbVzVmj67HgebeQDG39kv9h6hXrRjh55O+9wpPYqxYSf+vgiClhElz6O3NC1t1DAZuUUI5ti9ioZxV6vktpxEhqVxKSAheeOsJG8TnbSqB3Pmw+Eq19ZYfN+T29SUcMDtwnAF4d2CGbpbYf0s9HFJuZea7rU5UYal3Cpa5+e3PhTZdIr0YlHxFs4P+nwcsXEMJHT6CSkj1zOY+FGnYsdBGxWjrCpj5tCSZ21aPWuiWlJNMXsEtDJi3BAq5euNZZ6/eKQOv91FBYrdt2kzV+7fACAV2iHYJYL2qHmoVMP1vuoM2XMiPA5jcjUYfhsOnYuMQ+pwvlhh4WHVyoWOeZXde8Z1FndyUVaZteXnDgIOpXWe86LVkntDLxiHHULOFkeu5ejdUWdzL846OR+NYVNJ/1XyPQFEwAcaIdgFv+jFOpnXwfU56S36n1f/ZS+UiwqzNbX618/jYhAauNNa46F6Eq0HwuD0fYZjdEnHnMtx75/5WLFHK/qSojsNMWvnRFm67nNXOjaW1VyIrqo0nwlI4nqVRxTtfhaqOiOcDTRDgidRS2JpZ066fJcxBsl98sq3FyxXiu9p6I7Yuw2Afji0A7BLE+tFr2p+IcqOFb5TajPLstduqmS8KWgJlEYYENoh2CWp1aL2FTEe4dwtvibsKQden03PXpv+EYartVnYPxWzt8RFH62wgD3hXYIZqFaAAAAAOCm0A7BLFQLAAAAANwU2iGYhWoBAAAAgJtCOwSzUC0AAAAAcFNoh2CWw6uFfwwK1MCxWqEnHA6F9zDMj0slp/BIaIdglge0QwOfmj3g5CafaHSUG+cdhnbbbjf/NKqxRGwYyDWB70/0lTW7cbvC21DJrg+HPNt/fx/cUEmASWiHYJYHtEPXrLvJEWcTNxYm4klemY5t6zzUPLsdAl8f2iGAy6Adglma1VJ/hfb7y2to/Ub76xUxTC/h2CycKX6K8fXSr1OidYtZ0WNtoSlmFMvAdJ2vQpbajlguHWO+edxVP4crlqavtxKaAZ56v9Tu6WFOVXRVkXZmqwpcXm/1YCdMCs8pPF1OXWXpuD1QOUKrsfoZzn461xkGcBdoh2CWulqapwHn2BFdjDY2vaLvkl7R9DzdS6KNfMDzNJbe6Y7B9HTip1LIK05LqxRzHvuLFqTuaT0dSR3RTBnNLDhRDCTomgrsinQmHD09Gi8GUHhdUTi6zefRTKKjlV9+zfAF4obSUwAeA+0QzGK2Q8WAaFd+//Y1/XVYbaFpcObI0nSjGXXvTlxHLTz398h0343sF/t6ek6qH0Tezjscqb1KMeFn82zkFLCITrskPNH3i14iSqWzrjleO7NPBS6vt2aYogzq8RSeiFeXkw4trbQ06alBU3B/li6AeqI53V8F4BbQDsEsve2QswfXF5uIDaBpU7vU5UYal3BJnI10aP4VYb/3inl6aP56iMPLFRPDRE6bqtZ0uTd8vzjuCRl7FfCVdNa6uALTZ4VQx96hZghClldXKTxfN9OT+TLw67Ae7DvZlZqB6QAPgHYIZrmgHUp3PtNm15QxI8LnNCJTh+HDlhOmI36qcDFm8nQoxl+jWOSYX9UzR8ZD7hdhZPieGvNzJkFnV2B6V15/h74Zp20hC4Un9El1czyZLIOxQAac9LM/MB3gAdAOwSz+RynUz74OqDf+Ykz6lL7ylr0z+jmmvl7/+mlEBFIbb1pzLERXol1TGIx29GiMPj2Yazn2/SsXK+Z4VVdCZKfJZfdLlE1HxoG8NAc7Wi2pwFT/a+qttqNtOqmk8IqyaV7vLcuxGm5KahbSmFxp9osbyploLgFwFz7bod///ve0QzDCU6tFv+L7Owccq/wmREcu6JVuH7Z1DC6A7KMVfGU+2qHvvvvuF7/4Be0QjPDUahGv+APvw8FR4m8C7dBR0m3Cnl7BZTy7AF7/EOT85VCMf7ZQ8GX5aId+8pOffPfdd7RDMALVAgAAAAA35aMd+v7773/44QfaIRiBagEAAACAm0I7BLNQLQAAAABwU2iHYBaqBQAAAABuCu0QzHJ4tfAvNYEaOFYr9ITDofC2YqHU5uesUgywM7RDMMsD2qGBT80ecNL/VJ+zgz3EjfMOQ7vtml2fyLTEvYExGwZyTeD7c5cP8vqyhSfCWbgvRNMvqCW+sAgeAO0QzPKAduiadTc54mzixsJEPMkr07FtnYeaZ7dDD+OQdugQuZx26FQRqAe4NbRDMEuzWprfk21+r7YYppdwbBbOFD/F+Hrp1ynRusWs6LG20BQzimVgus5XIUttRyyXjjHfPO6qn8MVS9PXWwnNAE+9X2r39DCnKrqqSDuzVQUur7d6sBMmhZcWXu1Pr7Uos46RyYjMGkvrxLQ/UzbpXGcYwMXQDsEsdbU0X6mjzek92FGam0R0xd+lmi7pFU3P0y0h2vYGPE9j6Z3uGEz3cj+VQl5xiFmlmPPYX7QgdU/r6UjqiGbKaGbBiWIgQddUYFekM+Ho6dF4MYDCO6TwhlfvqpDeiLquzFszEXeingKwG7RDMIvZDhUDol35/dsN43VYbaFpcObI0nSjGXXvTlxHLTyPNqeBzSyyX+zH6TmpfhB5O+9wpPYqxYSf+kwjClhEp10Snuj7RS8RpdJZ1xyvndmnApfXWzNMUQb1eApvIF6nFJurR5qYEdXqjVVUWidj9RkpWS/hTPSHAVwM7RDM0tsOOXtwfbGJ2P+aNrVLXW6kcQmXnL3nqM0sVSa9Ursd7eiR85MOL1dMDDNPMK8epmcj4d7w/eK4J2TsVcBX0lnr4gpMnxVCHXuHmiEIWV5dpfB6MzWwuihC7cmMn72l3ns7mO6lE037AEugHYJZLmiH0p3PtNk1ZcyI8DmNyNRh+LDl783a1VThYszk6VCMv0axyDG/qmeOjIfcL8LI8D015udMgs6uwPSuvP4OfTNaFyELhWc6c8jqvkS9Lyz+lfkYdc2YS5vTAfbhsx365S9/STsEI/gfpVA/+zqg3viLMelT+spb9s7o55j6ev3rpxERSG28ac2xEF2Jtn9hsLkbiTHREadQQNtx7PtXLlbM8aquhMhOk8vulyibjowDeWkOdrRaUoGp/tfUW21H23RSSeGlETnpGFDJLz+nQpwai/wRmqf+RO69mjUnpmMAlvDZDv3617+mHYIRnlot+oXb3wDgWOU3QRy5oEu6fdjWMTic4VwvKZLHVOZjAoHn8dkO/eY3v6EdghGeWi3ihVu8cQhni78JtENHSbcJe3oFJ0E75C9dMDyeWwx25rMd+u1vf0s7BCNQLQAAAABwUz7bod/97ne0QzAC1QIAAAAAN+WzHfr973//9rOf/RwAAAAAAODr8NEO/epXv6IdAgAAAACAL8rb/+M//uM//uM//uM//uM//uM//vuS//1/zho4Ko2skHQAAAAASUVORK5CYII=" width="640" /><span style="font-family: arial,helvetica,sans-serif; font-size: x-small;"> </span><br />
<br />
<span style="font-family: arial,helvetica,sans-serif; font-size: small;"> 2) The privileges under manage privileges in Administration menu should be given to BIAdministrator/Presentation Server Administrator role.</span><br />
<span style="font-family: arial,helvetica,sans-serif; font-size: x-small;"><br /></span><br />
<br />
<br />
<img alt="" height="43" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAvcAAAAzCAIAAACc+7BnAAAI8UlEQVR4nO2dW5Kkug5FmVOPtueUEzpfnI8Tl+u0pG1hjHnkWkF0gJFlSUlZu6ju6uWfbz6fzwoAAADwfBZUDgAAALwSVA4AAAC8E1QOwJNY/vy9OoSRvCydIfxUTX4q2fvwU2Vvq5xlWZZlmRFKgR3UUblzAe7D8ufvdlQjkXHkR6+SH8/vdB17os33uOeOGjYDmMm1NdlbkIN1m5PscPLR9sUw87F8wTYyhLuoHHeJSseIqIQlwB1w90exm/RtT90hjbJ0p4jpe5ucPT+4887kwpoc/AQ7mJbsWAZqsuHTO5Z7+jYyhIbK2RSDeL+iLzMGlf/miDhxJwJcTkeHrqaU3wLa83KK+/195ceeR2aZS5tL1JAygUUc7OhRFlF4drmo7FFed65JNNF9PPSlG+ScZPVzm8+i48nP+3Tj1wWJnkBt767lVkM/z9Vd/WHZmnQUszn3CLtVjlYnVm001Ux5qxJD1iATFSoHboi790W7XnSyenuBHW82A9etCEZ0rGhutEE3AxP7WrKGuqpiUV0fNxHh6lY1KS2b2YlorbHr8Lxk7fQjGTWn7LLP5JL5FJIZiSettHziNiKegQ7Gq5zqr8i473UaMXnySAfD38uBm9Pc9MXdgduT3mjKy3I7TjY84UHPLY13NTl3dV1VN+xkfUTZRcVKJ1fVxJ1ikxKBRQlGi56UbGXTDDKZha2Gu2LyKXLztbk0Q7I+k0/a2vqAms+zsG9+puWlrp4bjF3iIErlLIY1oXL8ZfZoHa1yMlEB3I1kN6p2seZOumt7KpeIQspMF3d1jmLftB6Ez8h/NNIMO1kfXfZ8DPNrIsJwO5MIMlrLbc/Cz8FktfPKJvMxdXTiXR7cpZtPTvTg6SXesY2M0joNlfNlulPl9Omh8pbrLRMVwN3o69BnbE/CLDo/onKifHXArtt8Rz/Sz4RBRuXctiZ6ijVIfuhNlRPZHExW57L3A9WRDPHgRp5s9smQonXfsY10s1vl/HdS/QWa7svSuXvLDqJy4Iks3sv2xXyzEl0uwbdlu7Ynu6J1qKN1I8/vs2KuG5v1malh0titklufZtnvXxNr5hYhejx0kDq7scnqkWYpms9AlLW9m3+u7OrJkJI5roZm8fXzXN2149Fz0sw3//Von9Vu+K2AAHBHRu1xb2JsTW5e4ZuHB08BlQMwg/LbGg4ODg6O5HF070XlAAAAwCtB5QAAAMA7QeUAAADAO3FUDgAAAMALsCpnWdcLDwAAAIAx3E3loIQAAABgDErlXP3PxzoPpBUAAACsqJxnHgAAANAGlfPcAwAAABSonOce8Iss7/q19y9LZwg/VZOfShYuIfW3jy8XLlbHXKtyluVyiYPKeRjlM1qNRMaRH71KfjzfYDpakc33uOeOGjYDmMm1NdlbkIN1OyNZgA4a73JuKHFQOaicJ7J8/4+7drAy7lM53SGNsnSniOl7O7o9PyjgZnJhTQ5+gh2ckSxAB1mVUw3a8VJ5VCPClbjUDpMeNsSIHa/sXYPSibiM1tL+3cu1VlfwJDo6dDWl/M7YnpdTKuPKZ+QkMstc2lyiJpcJLOJgR4+yiMKzy0Vlj/K6c02iie7joS/dIM9IFqCDHSrHPam0SDRip9vLaLq1j2zK5VxhEb2DqcatCmkauMb2pNu/p5bgSUQ91bWMTrbzyEa0Z7uc7T1RMKJjRXOb3VcH7JKsoa6qWLQpSnTZq5Fb1aS0bGYnorXGrsOTkgXo4BSVUx7Wxk5pKpimw+puKRGab1bccatXhLKxq1Rme0WM8Fkc8CSam764O1Dl6NZVXpZNMdnwhAc9tzTWHd2ej1U5fa3dxn+3mrhTbFIisChBoXKGJwvQwbnvcsQrmcz0/Ih17ooJV7K449ErFjtuXXWoHOE/WuXqJwf2ke/QumU2262235aIQspMF3d1jqLJWQ/CZ+Q/GmmGnayPLns+hvk1EWG46kQEGa1l/YgI165kATqY9BMrs3WfonK2u1pMBKKhLV9WT/24L2aqW0mVI/yjcp5OX4c+Q+UIs+j8iMqJ8tUBu27zHT0zV3TxIyrntjXRU6xB8kNvqpzIppkswBCy/5J8jVVOaVa9TXGFyC7jyqYaiTyUEqH6uY/7Iscdd3+EVI24d5sqJxNY5LM44En8/7Eudvzycht0L6vpfSrHrmgd6mjdyDM6oznXjc36zNQwaexWya1Ps+z3r4k1c4sQPR46SJ1dd7IAQzj6WwGTZjMPowZ6juhlz50OgDdDw7OMrQkVhl8AlYPKgRlc/4XBwfGc4+qvV3gPVuV8tnt//nYfV36BXC0+UDkAAAC3QKmcOQFwoHIAAADO4HKVs5duNXC5KEHlAAAATMVROfD5fD6f5fYHAAAAKB73LgcAAAAgBSoHAAAA3gkqBwAAAN4JKgcAAADeCSoHAAAA3smbVc6y8M+tAabyU7+19qeSBXgobZXzv/8z8uQ4vlcRi+aD6fbw/V9p7qZj1vwVYTL2t9eLX2Z/w191nwxpV8D5muwtyMG6nZEsAFwCKqff/yjQKL9A2RHLpq4t74Mbvzbr8+lKnLzP7inNwIavAgATaKicrQFbCVLeEpcZg82//fPIcn0eXM3h2lRx7o28mjVzRZjPwY4evfOo3G4jdrnqbjSxtG/GH82141FS9jxTk2hilWAUjCjFeckCwCXsVjmuOnEvbUu2l65xsqMLD9FaGQ+r1D2bB33XrtIMbPKKMJlIl1gzd251rke0gVAzext/tEr+XUimJqVlMzsRrTWOpNUZyQLAJYxXOSXbSGXgxBEs5DqMVqzuWtWS8WCjysTgRq4r4zJ/RZjDkXc5SZXT19pLqeEqhs1YK5Kq8bv2zbyi1SOz6m1K5DlKUKic4ckCwCUolbMY1oTK8Zf5brS271YNezuJlEd03jcSBZ+JwZplChUxf0WYw9kqZztvvuwR73IyMSQbv/WQyas5Vwcv0te5RO9yBiYLAJfQUDlfpjtVzi49lFEYGY1ytsrJa698Za5dEeaQ7+hadjS7+BGVo9/l6PibP8TJ5BWtrqdYg77XWvnAmskCwE34F/rxYULxFWOnAAAAAElFTkSuQmCC" width="640" /><br />
<br />
<br />
<span style="font-family: arial,helvetica,sans-serif; font-size: small;">After making the above changes, the syntax for the URL is:</span><br />
<span style="font-family: arial,helvetica,sans-serif; font-size: small;"><br /></span><br />
<span style="font-family: arial,helvetica,sans-serif; font-size: small;">https://localhost:7001/analytics/saw.dll?Logon&NQUser=AdministratorUsername&NQPassword=AdministratorPassword&Impersonate=Usernameofthepersonthatyouaretryingtoimpersonate</span><br />
<span style="font-family: arial,helvetica,sans-serif; font-size: small;"><br /></span><br />
<span style="font-family: arial,helvetica,sans-serif; font-size: small;">Until Next Post.. :)</span><br />
<span style="font-family: arial,helvetica,sans-serif; font-size: x-small;"><br /></span>Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-5136216691385480262011-09-22T07:11:00.001-07:002011-09-22T07:11:29.433-07:00How to Display total number of pages / Page number in OBIEE?If you are trying to display total number of pages in a report, Add the below formula in the column of the report and hide that column in the report. <br />
<br />
FX = sum(count(1))/25<br />
<br />
You can then reference the column in the narrative view like this: "Total pages in the report are @5" and out put may be "Total Pages in the report are 30".<br />
<br />
Or<br />
<br />
You can also use something like the below:<br />
<br />
To calculate them use fi:<br />
CEILING(CAST(RCOUNT("FactColumn In the Report (Sum All)") as DOUBLE)/ 25) for the page number<br />
CEILING(CAST(COUNT("FactColumn In the Report (Sum All)") as DOUBLE)/ 25) for the total pages<br />
<br />
Put the above formula in the column and reference it in the narrative view like I mentioned in the previous example.<br />
<br />
Until Next Post... :)Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-76543590725108077542011-09-20T06:10:00.001-07:002011-09-20T06:10:32.110-07:00exprformulautils.cpp Error After Upgrading from OBIEE 11.1.1.3.0 to OBIEE 11.1.1.5.0Have you upgraded from 11.1.1.3.0 to 11.1.1.5.0 ? If yes, there is a know bug out there and a patch is also readily available in oracle support. This should fix your .cpp error after upgrading.<br />
<br />
11G; ASSERTION; BUSINESS INTELLIGENCE; FAILURE; INTELLIGENCE; OBIEE; UPGRADE FROM 11.1.1.3.0; UPGRADE TO 11.1.1.5.0<br />
<br />
Also, please refer to the following doc in oracle support :NOTE:1328704.1 - OBIEE 11g: Error: "Error Codes: OAMP2OPY:ACIOA5LN Assertion failure: isXsiTypeSqlExpression(rExpr) at line 67 of /scratch/.../webreport/exprformulautils.cpp" When Running Reports<br />
<br />
Until Next Post... :)Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com6tag:blogger.com,1999:blog-3916832175953541518.post-1982077076906247542011-09-20T06:02:00.000-07:002011-09-20T06:02:12.720-07:00How to hard code a label name above column name in OBIEE?<br />
Two changes are required to hard code a label above the column name in the report:<br />
<br />
1) Edit the column properties in the criteria and select the custom headings option, and provide the folder name ( label in your case that you want to hardcode and show up above the column name ) and column name.<br />
2) After creating your analysis, go to the table properties, and make sure you select the option ( As Seperate Rows ) for Display Folder & Column Headings.<br />
<br />
P.S: This is only possible in the table view of the reports.<br />
<br />
Until Next Post... :)<br />
Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-38475848112313540392011-09-13T12:26:00.000-07:002011-09-13T12:26:07.991-07:00HardenXSS in OBIEE<a href="http://gerardnico.com/wiki/dat/obiee/hardenxss">Click here to read</a><br />
<br />
Until Next Post.... :)Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com2tag:blogger.com,1999:blog-3916832175953541518.post-91895810722353844902011-09-13T11:01:00.001-07:002011-09-13T11:01:19.878-07:00How to create a report out of two databases in OBIEE?You have 2 options:<br />
1) RPD level: bring those 2 tables to BMM layer into one Business model
and then put them in the same catalog in presentation layer.<br />
2) Answers level: Use combine with similar request and create the report.<br />
<br />
Until Next Post... :)Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-42970471245083953882011-09-13T10:39:00.000-07:002011-09-13T10:40:00.561-07:00How to hide a dashboard dynamically in OBIEE?Below are few thoughts / solutions on how to hide a dashboard dynamically based on day of the week etc:<br />
<br />
1) This will work with the help of JavaScript and Conditional Section
Guided Navigation. You need to create a table with FLG col, with 2
values 'Y' & 'N'. When dashboard is visible..FLG value will be 'Y'
and when you want to hide then 'N'. You need to schedule an ibot to
change the flag value dynamically at scheduled time.<br />
<br />
2) Guided navigation. Create a report which return no rows on the day you
want to hide it. on the dashboard page use this a source to show the
other report (section properties).<br />
<br />
3) I think you could hide it dynamically by swapping out the .atr files which control the dashboard permissions.<br />
<br />
You would need to do the following...<br />
<br />
1. Create the dashboard<br />
2. Copy the .atr file somewhere else temporarily<br />
3. Change the dashboard permissions so it is not visible<br />
4. Again copy the .atr file somewhere else temporarily<br />
5. Write a script that swaps these files over depending on the day of the week<br />
6. Schedule the script to run using cron job or windows scheduler<br /><div>
<br /></div>
<div>
Until Next Post... :)</div>
Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-46511205208376865712011-09-13T10:24:00.000-07:002011-09-13T10:24:47.544-07:00How and where to upload documents/PDFs' to OBIEE 11g dashboard?<div>
1) Make sure the drive is shared where OBIEE is installed.</div>
<div>
2) Upload the necessary documents in the following location: ( C:\OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\res )</div>
<div>
3) Place the following code in a text object and make sure to check the box (Mark as HTML) - (<a href="res/pptName.ppt">TextToDisplay</a>)</div>
<div>
4) Restart BI and presentation services.</div>
<div>
<br /></div>
<div>
Until Next Post... :)</div>
<div>
<br /></div>
Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-90290223123797318342011-09-13T10:20:00.001-07:002011-09-13T10:20:32.659-07:00REPORT_AGGREGATE function not working after upgrading to OBIEE 11g?Apply the Patch 12391045 and that should resolve the Error.<br />
"Function REPORT_AGGREGATE requires at least one measure column in its first argument Error"<br />
<br />
Until Next Post... :)Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-43116977946697073272011-09-09T09:24:00.001-07:002011-09-09T09:24:51.513-07:00Work around for supressing null values in a pivot table viewRefer to the link below. You cant really suppress nulls in the pivot view but a work around is posted in the link below:<br />
<br />
<a class="jive-link-external" href="http://bischool.wordpress.com/2010/08/10/obiee-cross-tab-with-missing-cells-data-in-database-or-suppressing-null-values-in-obiee-pivot/">http://bischool.wordpress.com/2010/08/10/obiee-cross-tab-with-missing-cells-data-in-database-or-suppressing-null-values-in-obiee-pivot/</a><br />
<br />
Until Next Post... :)Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-48423262973724212862011-09-09T09:09:00.000-07:002011-09-09T09:09:30.592-07:00Changing the default views during creation of new analysisCame through this great article on how to replace the default table and title view that appears when creating a new analysis.<br />
<br />
<a href="http://changing%20default%20views%20of%20compound%20layout/">Link </a><br />
<br />
Until Next Post... :)Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-80367696286113123262011-09-01T08:11:00.000-07:002011-09-01T08:11:53.514-07:00Migration of OBIEE 11g Logo from dev to prod<br />
<div align="left" dir="ltr">
<span style="font-family: Arial; font-size: x-small;"><span class="480140215-01092011"><span style="font-size: x-small;"><span style="color: blue;">cp
/interface/i_wwya/PWWYA3/outgoing/oracle_logo.png
/pwwya3/oraclebi/mwh/Oracle_BI1/bifoundation/web/app/res/sk_blafp/b_mozilla_4<br />cp
/interface/i_wwya/PWWYA3/outgoing/oracle_logo.png
/pwwya3/oraclebi/mwh/Oracle_BI1/bifoundation/web/app/res/sk_blafp/login<br />cp
/interface/i_wwya/PWWYA3/outgoing/oracle_logo.png
/pwwya3/oraclebi/mwh/user_projects/domains/bi_pwwya3/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/sk_blafp/b_mozilla_4/oracle_logo.png<br />cp
/interface/i_wwya/PWWYA3/outgoing/oracle_logo.png
/pwwya3/oraclebi/mwh/user_projects/domains/bi_pwwya3/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/sk_blafp/login/oracle_logo.png</span><span style="color: blue;"></span></span></span></span></div>
<div align="left" dir="ltr">
<span style="font-family: Arial; font-size: x-small;"><span class="480140215-01092011"><span style="font-size: x-small;"><span style="color: blue;">The bi_server will
also need to be restarted for the change to take
effect.</span></span></span></span></div>
<div align="left" dir="ltr">
<span style="font-family: Arial; font-size: x-small;"><span class="480140215-01092011"><span style="font-size: x-small;"><span style="color: blue;"><br />Until Next Post... :)</span></span></span></span></div>
<br /><br />
<br />Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-67304240850607520012011-09-01T07:51:00.000-07:002011-09-01T07:51:37.894-07:00OBIEE Stragg Function<a href="http://obiee101.blogspot.com/2008/08/obiee-children-of-level-converting-rows.html">Link to tutorial</a><br />
<br />
Until Next Post... :)Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-21879254044913183842011-09-01T05:45:00.000-07:002011-09-01T05:45:02.396-07:00Growing size of Chart with data in OBIEEThis functionality is not available in OBIEE. The size of char is static, and it cannot increase or decrease based on the amount of data that is being used in that view.<br />
<br />
Until Next Post... :)Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-73577818699711753792011-08-29T12:08:00.000-07:002011-08-29T12:08:48.147-07:00How to Configure Oracle DAC for the first time?After installing DAC software, click on start > Programs > Oracle DAC > Client.<br />
<br />
The Dac software screen appears, click on configure to create a connection the the database. Fill in the following details:<br />
<br />
1) Give the connection name<br />
2) Select the driver type (OCI(THIN))<br />
3) Give the TNS Name of the Oracle Database<br />
4) Create a connection file (.con extension ).<br />
5) Test connection. Click on Save, then Finish.<br />
<br />
After creating a connection by following the steps above, select the newly created connection and provide an Admin username, password and click next. If DBA gives table space, go ahead and create tables that are required by the DAC software. <br />
<br />
This process should setup everything that gets you started with oracle DAC.<br />
<br />
Until Next Post... :)<br />
<br />
Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-81376601708186665272011-08-29T08:48:00.000-07:002011-08-29T08:48:13.674-07:00Embed a Watermark to all the export of the reports in OBIEE<a href="http://www.obieetalk.com/oracle-bi-ee-11g-%E2%80%93-action-framework-%E2%80%93-java-ejb%E2%80%99s-and-pdf-watermarks">Link to tutorial</a><br />
<br />
Until Next Post... :)Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-74023760762354368542011-08-29T08:39:00.001-07:002011-08-29T08:39:39.873-07:00Display custom message when reports returns no data in OBIEE<span class="Apple-style-span" style="background-color: white; font-family: tahoma, verdana, sans-serif;">Go to your Results tab, and then click on the icon that says "Edit Analysis Properties" and select "Display Custom Message" from the "No Results Setting" drop down.</span><br />
<span class="Apple-style-span" style="background-color: white; font-family: tahoma, verdana, sans-serif;"><br />
</span><br />
<span class="Apple-style-span" style="background-color: white; font-family: tahoma, verdana, sans-serif;">Until Next Post... :)</span>Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-39796311527771878372011-08-29T07:51:00.001-07:002011-08-29T07:51:43.905-07:00Maximum characters to be displayed in a column<span class="Apple-style-span" style="background-color: #f2f2f2; font-family: tahoma, verdana, sans-serif;">Depends upon datatype of col defined in DB.<br />
VARCHAR can store up to 2000 bytes of characters while VARCHAR2 can store up to 4000 bytes of characters.<br />
So, max 4000</span><br />
<span class="Apple-style-span" style="background-color: #f2f2f2; font-family: tahoma, verdana, sans-serif;"><br />
</span><br />
<span class="Apple-style-span" style="background-color: #f2f2f2; font-family: tahoma, verdana, sans-serif;">Until Next Post... :)</span>Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-48962355680189255082011-08-29T07:48:00.003-07:002011-08-29T07:48:56.350-07:00Caching in OBIEE A-Z Tutorial<span class="Apple-style-span" style="background-color: white; font-family: tahoma, verdana, sans-serif;">Here is list of my research that corresponds to the Caching issue in OBISE1 well its similar to OBIEE atleast in this aspect,this list pretty much covers caching that can occur different levels.I would suggest to start one by one and see how caching is corresponding in the Dashboard and please do contact me if you need further help </span><br />
<div style="color: black; font-family: tahoma, verdana, sans-serif;">A.Cache Management<br />
<br />
For this release of the OBIEE, if you run an initial or incremental load without first<br />
clearing the query cache, it is possible that reports that you run after the load process will reuse the cache that existed prior to the load process. This can result in inconsistencies between reports. There are several alternatives to mitigate this situation,<br />
such as:<br />
• Configure the query cache to expire daily.<br />
• Clear the cache tables manually as needed; for example, after you complete a load process.<br />
• Schedule the system to clear the cache tables at the same frequency as the<br />
incremental load process.<br />
To clear cached queries:<br />
1. Open the Oracle BI Administration Tool in online mode.<br />
2. Click Manage, Cache to access the Cache Manager page and select all cache entries.<br />
3. Click Action, Refresh.<br />
To disable the cache:<br />
1. Locate this configuration file: <root<br />
directory>\OracleBI\server\Config\NQSConfig.INI.<br />
2. In the Query Result Cache Section, change the [ CACHE ] setting from ENABLE =YES; to ENABLE = NO;.<br />
3. Save the NQSConfig.INI configuration file and restart the Oracle BI Server service.<br />
See: Oracle Business Intelligence Server Administration Guide, "Query Caching in the OracleBI Server" chapter for more information on query caching in OBIEE., </div><div style="color: black; font-family: tahoma, verdana, sans-serif;">B. After running an Answers report, check the SQL NQQUERY.log (on Windows, usually located in, :\OracleBI\Server\log\)<br />
TIP:<br />
Turn off caching in the NSQConfig.ini (and restart the server service) or at the physical table level in the .rpd, to ensure you get the un-cached results, and can therefore see the SQL being generated each run, or drill down in Answers.</div><div style="color: black; font-family: tahoma, verdana, sans-serif;">C.Found this in documentation(if using OBISE1,for OBIEE refer to OBIEE documentation on CACHING)<br />
<a class="jive-link-external" href="http://download-west.oracle.com/docs/cd/B40078_02/doc/bi.1013/b31770.pdf" style="color: black; text-decoration: underline;">http://download-west.oracle.com/docs/cd/B40078_02/doc/bi.1013/b31770.pdf</a><br />
all about caching in OBISE1 </div><div style="color: black; font-family: tahoma, verdana, sans-serif;"><br />
But important thing to note is that Caching occurs at different levels<br />
Server (NQSConfig file ,look for ENABLE parameter)<br />
Administration(if you click on the TOOL in the MENU bar ,there you would some options related to OBJECT in the physical layer )<br />
OBIEE Dashboard Query level (in answers when making the ad-hoc query ,there is a check box which can checked or unchecked depending on whats desired in terms of caching).<br />
<br />
This is to the best of my Knowledge but please free to add some more details if you feel If I missed something.<br />
<br />
Four logs to check are as follows<br />
NQServer.log<br />
NQQuery.log<br />
NQSAdminTool.log<br />
NQScheduler.log </div><div style="color: black; font-family: tahoma, verdana, sans-serif;">I hope this covers some ground as to Caching in OBISE1/OBIEE<br />
<br />
Until Next Post... :)</div>Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com1tag:blogger.com,1999:blog-3916832175953541518.post-84345423899233704102011-08-29T06:56:00.000-07:002011-08-29T07:49:11.670-07:00Limitations / Restrictions on Pivot table views in OBIEE<span class="Apple-style-span" style="font-family: tahoma, verdana, sans-serif; font-size: x-small;"></span><br />
<span class="Apple-style-span" style="font-family: tahoma, verdana, sans-serif;">Another interview question here: Some of the limitations with solutions are listed below: </span><br />
<span class="Apple-style-span" style="font-family: tahoma, verdana, sans-serif;"><br />
</span><br />
<span class="Apple-style-span" style="font-family: tahoma, verdana, sans-serif;">1) Pivot View doesn't support Write Back</span><br />
<span class="Apple-style-span" style="font-family: tahoma, verdana, sans-serif;">2) Based on the Dim Hierarchy (Ragged) it might require to forcefully set the aggregation rule which is actually not required in Table View</span><br />
<span class="Apple-style-span" style="font-family: tahoma, verdana, sans-serif;">3) Some limitations with the Chart Pivot Results Vs Chart View</span><br />
<span class="Apple-style-span" style="font-family: tahoma, verdana, sans-serif;">4) View Display Error - Governor limit exceeded in cube generation (Maximum data records exceeded). This error comes up if the pivot tries to return more number of rows then the default limit set for it.</span><br />
<span class="Apple-style-span" style="font-family: tahoma, verdana, sans-serif;">5) Pivot views return all the rows at once.If the number of rows are huge pivot view reports are bad for performance</span><br />
<span class="Apple-style-span" style="font-family: tahoma, verdana, sans-serif;">6) Presentation Services might be taking more time to display the results( as pivoting does in memory calculations). This will have impact if you have a significant number pivot views for the reports.If the same layout is achievable in table layout, switching from pivot view to table view would improve performance</span><br />
<span class="Apple-style-span" style="font-family: tahoma, verdana, sans-serif;">7) There is a default internal limit which should be enough in most of the reporting scenarios. However, to increase the limit following tags can be edited in instaceconfig.xml file.</span><br />
<span class="Apple-style-span" style="font-family: tahoma, verdana, sans-serif;"><br />
</span><br />
<span class="Apple-style-span" style="font-family: tahoma, verdana, sans-serif;">< CubeMaxRecords >50000< /CubeMaxRecords ></span><br />
<span class="Apple-style-span" style="font-family: tahoma, verdana, sans-serif;">< CubeMaxPopulatedCells >150000< /CubeMaxPopulatedCells ></span><br />
<span class="Apple-style-span" style="font-family: tahoma, verdana, sans-serif;"><br />
</span><br />
<span class="Apple-style-span" style="font-family: tahoma, verdana, sans-serif;">Until Next Post... :)</span><br />
<br />
Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0tag:blogger.com,1999:blog-3916832175953541518.post-44599749780768321752011-08-29T06:13:00.000-07:002011-08-29T06:13:40.562-07:00Moving reports and other objects from one folder to another in OBIEE 11gMost common issue faced by developers in today's world with 11g is not being able to move their objects from folder to folder or instance to instance. This can be done easily by doing the archive/unarchive procedure.<br />
<br />
<a href="http://itsourteamwork.wordpress.com/2010/08/26/obiee-11g-archive-unarchive-a-powerful-way-to-export-and-import-the-objects/">Link to tutorial </a><br />
<br />
Until Next Post... :)Oracle Business Intelligence (OBIEE)http://www.blogger.com/profile/13388278899418030932noreply@blogger.com0