tag:blogger.com,1999:blog-88792949088385001702023-11-16T06:08:35.909-08:00OBIEE tips and tricksUnknownnoreply@blogger.comBlogger27125tag:blogger.com,1999:blog-8879294908838500170.post-17020576250914848532016-08-14T07:37:00.000-07:002016-08-15T20:41:41.324-07:00Using Apache Drill as a JDBC data source in OBIEE 12c<a href="https://drill.apache.org/">Apache Drill</a> is an open-source SQL query engine for Big Data exploration. Robin Moffatt from Rittman Mead has written two excellent blog posts about Apache Drill:<br />
<ul>
<li><a href="http://www.rittmanmead.com/2016/08/an-introduction-to-apache-drill">Introduction to Apache Drill</a> </li>
<li><a href="http://www.rittmanmead.com/blog/2016/08/using-apache-drill-with-obiee-12c/">Using Apache Drill with OBIEE 12c</a></li>
</ul>
I will be experimenting with an approach based on a new feature of OBIEE 12c: the ability to have a JDBC/JNDI based data source in the repository; unfortunately documentation about this feature is limited. The goal of this post is to document the main steps for connecting to Apache Drill via the new JDBC/JNDI interface in OBIEE 12c. One of the advantages of JDBC over ODBC is that there is no need to install and configure client drivers a step that can be tricky especially in *nix systems.<br />
Following are the main steps to be completed for the JDBC/JNDI based data source configuration:<br />
<ul>
<li>Copy the Apache Drill JDBC library to the WebLogic class path </li>
<li>Create a JDNI data source in WebLogic </li>
<li>Load the Java Data source in the OBIEE Administration Tool </li>
<li>Create a database and connection pool for the new data source </li>
<li>Import the data source metadata and start building stuff!</li>
</ul>
Note that for this experiment, I will be using the <a href="https://www.mapr.com/products/mapr-sandbox-hadoop/download-sandbox-drill" target="_blank">MapR sandbox</a> already configured with Apache Drill among other tools.<br />
<h4>
Apache Drill JDBC library file</h4>
Once you download/unzip the <a href="https://drill.apache.org/download/" target="_blank">Apache Drill package</a> file, the JDBC library file to be copied is:<br />
<blockquote>
[Apache Drill]\jars\jdbc-driver\drill-jdbc-all-[version].jar</blockquote>
Copy the file to the OBIEE 12c domain directory, lib subfolder<br />
<blockquote>
[ORACLE_HOME]\user_projects\domains\bi\lib</blockquote>
and restart the managed server.<br />
Start Drill in cluster mode in the MapR sandbox<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRcEEPy2n59lK4OKQITzhwf5sJys2Za-486-9l9XzkYzIFmyl44E8SzUIFTfX3abX4JxY6R5Ohu3koEsn6gNNJT4R0CdFNYtO02-k40RXaUwMxUB__qiQnkpTj3fpMM1jVqTid7TfaYGU5/s1600-h/image%25255B3%25255D.png"><img alt="image" border="0" height="31" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTqRj6lE943uEIl50Axv-V4_Ob8ctaiBfrXFGntGQN8egl2EE2AN3p7iD7fRJyrz3U9ykq87qPvb4SyY6MyknJAweWonAHSBlFNKSQZaij2tRfwcsYKVHShq5lyLJAHGLoEslw-bjwKmlN//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="514" /></a><br />
<h4>
Create a data source in WebLogic</h4>
<ul>
<li>Log into the WebLogic console and create a new data source</li>
</ul>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLc_ef65FwM9bySiVcwiTBWCF1vRRbk4nvHWtMbBk22ZQOFNAv6upQcr8lkxwkVfJe0rwoc2s30iPsjwhgMEreJ2GsCYMbif58hiqdKr0ZYDshQoLzgxNz8kiuysVEVql0wSRRCLYFXr3I/s1600-h/image64.png"><img alt="image" border="0" height="247" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtZTG2I2FOl80vHkwR1dIyAWPsCRQZ-KYITXitooXXFV7bElWF23fF1uiwD31L88ku6mccfBiy1YHxNt9Qyl4VrHKhGKH262-nDPQYKjpEZNiQdZaU166cGlb-35T_Wq1YoQePGNlmIAzn//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="424" /></a><br />
Lock & Edit the configuration then create a new Data Source<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEid-z2jrpLYkmZS554LP1zGsbsXuJ2V9qlDYQG26TywqnibWLa0OuxQRjWFVdQ467hX_WDgggYmZcRmwqMFch9cpSKU5M1sBEc2MnfFDAceuxcFcy4PyVPuWVc300UyooKEnrBeRLt6du2q/s1600-h/image68.png"><img alt="image" border="0" height="203" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqY4Nor8VDcGptiSwXq6DllMo_eR2uclw0-SjNwUoPsWO5OE4hCMWIky44WhBX4lDvSNq0h9aDmlN_62WkubYPuOUBoIVSP1i_PEfJcBLsHfU-UUTIpUD9NfQUK1QDu_yfxpTPXuHrdIn7//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="424" /></a><br />
Specify a name for the new JDBC data source, a JNDI name, set the database type drop-down to “Other” then click Next/Next. In later steps, we will provide connection details for the database.<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjK2XoVOKqUEfiywPEA_R3gmBt1jy7S_hxwIaUQIGvwSxtNKrrzSJEhOZxVZIkFLgq9yJg9B9q8a3VgWtQHIqfQpYrLzn5xEydRA-UMdw8XkB_s4mjx5XVOVp15Pkh8kxh3zL63kHYoTMTk/s1600-h/image23.png"><img alt="image" border="0" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDkJMty9luPzV6CZDsHnQ_Og5AOS4f9VtEHc6bqFM67uCc5zJK4935LAH1BRQXklZLiuxjzZ-12aNcwaFyxA2YDW8jzJ_FgxXJJ9T0c1l-je8ZEWUS-IG8VDgXa1BJZ9HMNwL7GRsU_zv7//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="424" /></a><br />
Next<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLc81yzkjnKiPd6IQhYpFtGvitO126MJAyy-x4HGtadhyphenhyphenXdCCpo-MuOakyqNSFQSUkloJughnqWeyY27owZNeFpRYFjpctLMgPyiCc-TV0ecRhsyLpX5-snqIS56CjnlLYgxjxNcdAAlMl/s1600-h/image31.png"><img alt="image" border="0" height="389" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3TDTsz_rLMiFAd596qr93sWUagCfsOPC2ewKPhcTFzh5l9ythf3F1nUunp8273a0DdaYluKyhAzSKOVubF3BjFc97T4gIeDv4pQDoiqTZcCurVVOE3YAffspEwmdh4EdjAMSbZRVpCJSa//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="424" /></a><br />
Next<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjozFM2q2b2RyZXQAn-M8a2Efkr2mrUiXvk0vyprk7Szo28OMcL-uMLpmM86hJ37ds8j1i4NaplkJdXx9eE7q-KaH8lmUCpWeyaQSj2-lsToIheqfdafU1lZ83spHGHz2vvcGsg3QVYdInL/s1600-h/image35.png"><img alt="image" border="0" height="335" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMx5GDaxgENw_ltao2YLD-x6HjqNFsIGP977UDPJAAykYANNeLdYiBm4-7nETmAnbaldLeuEsDPrJx184axkfy-2_6yLjRqP3n-BBrdeZCNfySRqU0TQN2ueuAXR5By_4XwPwu3U_zAqp3//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="423" /></a><br />
Set the values for Driver Class Name field and the JDBC URL<br />
<strong>Driver Class Name</strong>: org.apache.drill.jdbc.Driver<br />
<strong>URL</strong>: jdbc:drill:zk=[hostname and port]/drill/cluster-id<br />
where [hostname and port] is the ZooKeeper quorum hostname and port (5181 in this example)<br />
to find out the cluster-id, take a look at the configuration file for running Apache Drill in cluster mode: drill-override.conf (see screenshot below). In my current setup, I am pointing to the MapR Apache Drill sandbox.<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2frqnW30yESJ2vuUV4PFCkKDozC7a5NW2hzj0blOw1ODTYwrmFP6uj0jXjvskB9Tj2Ar1zN2dRObu9ZRXacURNz-9wxNuhDd3A_RUGrwKfXSHbq9ym4LHy5_Se9kF1A5-9pD3Q7lumibr/s1600-h/image60.png"><img alt="image" border="0" height="135" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjm3Sc8FiHACW94JAhxt454ohyXl0tK8qv-0kms3PCda5vtBknH4evCu4HNQiwkwyQrF0MbDoM09oejjVimtQS6chhLufX0nsDruHivBQHvBQJPl0N5q_Srit8cc1G0FOC9Zkd6sdVko5SK//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="424" /></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi24CTqMGNM0BjqSfBOF6RpfSgALoNWXOwWAngIE2tLJx1Yck0zMjPia0Rf2_fGL2BUw92W_eYNDMFQ2CSBHybACNcfbx1g9nBJKPNQgWybMDZjCZxfaP4nFI9zj6YLEiOjTizCrizb4p6m/s1600-h/image39.png"><img alt="image" border="0" height="308" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIbcSnuBN0HszDyaxveERtj3WBicrz_73PN0DXOLHz3BN69vC1EEFiRmgAFoSHbwT7bo676mu2-tjaqKjU3BEsDvQ8t2-lJlnRBxwGYoEkIy_0zetiKslaBg6x5Lxc4UkccUlsh-rJgkuT//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="424" /></a><br />
Test the connection to Drill<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9QjlSHwJ0e9iXtn5XLpIflk1gbwXQpcGPRugRlJBvgeLKjfNZppO9xBbIzQQcPreesRX8oXaHtujDv1oPw4Xou79Pkz8LgcVThhw19iYsfL79bd_KYlMoMXeV7_3o-4SODim6noLoB5P4/s1600-h/image46.png"><img alt="image" border="0" height="127" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxZg5MAyJ2eShkFUEHDt53_XgL1T-Vu-TvisUeCeRG3UPB8arPStngZ-skm5G3arqjnsNr96LpW0bBtC_YiSK2RKO8waNR8UxbQtvJRCjKVqBARUGUb-rICNek9kBIMtBVdkdojab7gqdA//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="424" /></a><br />
Set the schema to connect to by default in the “System Properties” section<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXu_JVfUs-HykhHbyA2jsMkQZNfb2s2e2by4iLas-ZC0lGXwtvPxkjD5UiWMUO7QXfjJ9OjDyZjTwDPzRCL7YRMRDeoF-iIaxJgNGHPjO9v3YDF4EIntig0sYMX22_4elhek89e4sKrtMc/s1600-h/image52.png"><img alt="image" border="0" height="150" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7-L4f2ZoKfducTRpMwtMNLfXDRd5A_v718t_kuyh-b-s2x822VhOFx3RD6CTmWQEBxqXfrUIpVi8knjrhl7zny4eYgSmRWal10VJdTTiLIXikCfRFJ4jsNTYDxGgctbUihIfZaMLP_K3W//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="424" /></a><br />
Click Next then select the target to deploy the new JDBC data source to<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhR9SMBQfOfxHcCouCzot3LK5MyFmACifMP5ohYRtzkDnhY-z_4LcocKc-SOSC9gMHrj02tWAwI5H68yBpt_HlK6XdtG4gElAut9DjYCPKWVAdZ8oqn2Q75HCufciGOzYJTP7nbjWj-cYcz/s1600-h/image56.png"><img alt="image" border="0" height="338" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvrEfWE4zcWqnpxTuSZGj-TAXZZFS4lg5Pp_5LC6LJMwYHcdlWhPGhX81hel3_wLEt24vDg4UQHyXi99SQQhAeUAscYHcpBRQzYy-yhSbO8G70PPfX7gg6ctZchJkxgoHpNHv7i-mL_9o5//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="424" /></a><br />
Finish.<br />
<h4>
Load the Java Data source in the OBIEE Administration Tool</h4>
Open the OBIEE Administration online then select Load Java Datasources <br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyDXHJLJcFXDkQdm7KRoC5hOg0Hoor-IHiTdCfE2VzkGjI-4N1NpA37yXcVm0Nxicj8LqHi9-iwNSICSJXlC46uwPH-8DofdggYZTgesHFvkWUFVO2uuVhRQtshQUNQnzRR1N4bDKrfcNS/s1600-h/image76.png"><img alt="image" border="0" height="296" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNxVZ5Az9HSm-IW7tAtLkpLEo8eTGSv60jnbYK0U0XKPaeIEZnlGFjzzZPwC5ldixzkTtGsKqEhhI3AEkIyLxpfjB3F8w4jhqQtyePEESxOdIvtP2WvjZ5gSnyglVVeVwdjY5c2ncR87yf//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="424" /></a><br />
Specify the WebLogic hostname, the managed server port, user and password<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8eEV2wWr4VObFfnZq_6nL73hRk8e4r-j_kTKf_Bi5PTP_YyDOyRwOPRl_HQpkUYmSn68-ml26yaPicElY361UaocWxGob-i8aLHlicQtJIgS9-eoS027Xe37hmy8txZJ6m7XuBy-Tn84m/s1600-h/image803.png"><img alt="image[80]" border="0" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjjZy39ZciUYIb7ZdyYkw823Y0RvkVylU3_8gVTRfdOjGiT0lgDBZtrex8zzzUlfC5RULn7G3DE3_hxGIINemChXoN9KLLu0SchkBNu2NGsO3q_rSOTRpJ5pOb71LLMPvmxaraRW1bfkmR//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image[80]" width="424" /></a><br />
If the Java data source is loaded successfully<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhz2TaWMeJ2hK-41Q9tDaKy0FA58OVX5M1TrmaOhdAeMPutKpYANtOy3nSDe_NwgBS9lAFej6x-YAHe8t7HKngVBm1pH7lnrcMFdZWowFKExQwv679g3pHAtyHyCYzGlS1OT8G-E2FXJ-fz/s1600-h/image85.png"><img alt="image" border="0" height="164" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCuFXvT2tpSbizVSuQ7X4Ay9ldala9g07A5L1ebWM3aWZUX-y_bbXWeX_6_F_qu0VhhIta6hqdynVBoVgV3QhFGpnpHWTylMIBJBcar4hzqAfFvj1t1VaQSe3tny52qnOYvSpsRBp-xyS-//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="424" /></a><br />
<h4>
Create a database and connection pool for the new data source</h4>
Now that the JNDI data source has been successfully loaded into the Administration Tool, we can create a new database and a connection pool in the OBIEE physical layer.<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIws1Csa9e2vZG-4Ob0e-NgIaQVU3VEV89A8Qr4th_AVlXxMkQLYLiKXaalY60lgGjlFP2DKVr1RqfeLIj_Mi5ScmSLiZnEeZBibxRSWKLr2mcn-unexDbKhWH5kgVhdoCJOkyWdO7-tSY/s1600-h/image89.png"><img alt="image" border="0" height="432" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAKUT6bwAmi82r6zV19YxTY-uewiMeq1Wnv9nrSkvyjOR9-QxYGwkxe_lKakY7PWCp11UVa5W9NNtfdFryQH7kW72X4FeNLn3JSiS-IHHSpeyfrBsKvXMhiDmSv9ZOW6trLgO5xrCEktjT//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="424" /></a><br />
We now need to update of the database feature IDENTIFIER_QUOTE_CHAR from the default double quotation mark ( “ ) to a back tick ( `) as required by Apache Drill.<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOycZ7KKsyiVgn5ugfdvspmuA9xQK-N1483z7hCCKkPOg9qdqk1wW6Dx68SU6RP-53E1s3OmZCC_xlZoJIGFIm1bNMpdy7I6GL4b3EpO5w3h-GGOcMUrWR1eWmmvOazezhiBD_GPwnO1yh/s1600-h/image96.png"><img alt="image" border="0" height="439" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg42aMw3NGXr82CwmiJQ1c2vcSKUvkiit0ovGDkY6-NJMlrRm8xHmK8Oqp6kRNyPUDB9wdk8dwNp7IjVIwW6eLA3e3oO7LXmq0hW9hDOKIItZwzMflE1-YE5qQ9-Lawz6JYym5EsRT8HJp8//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="424" /></a><br />
Now the exciting part, let’s create a new connection pool:<br />
<ul>
<li>Call Interface: JDBC(JNDI) </li>
<li>Data source name: <a href="http://[hostname/">http://[Hostname</a> and Managed Server Port]/obiee/javads/[JNDI name] for example: <a href="http://localhost:9502/obiee/javads/jndi/drill/">http://localhost:9502/obiee/javads/jndi/drill/</a></li>
</ul>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlu-wSDT2yIJPWxYCURFRBZFGl8KTRRl9TPiOCIUR4TTDM0Sips9dElm47PZVu06SgXM6V0tyeIdXBInMIdU_tFotbJzHsgboWbUBGbTPWO9d8mtHmOag2WnSzHU8AB4ukBn5HLyryWV69/s1600-h/image100.png"><img alt="image" border="0" height="538" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrcXOYaBKUSWnCEnYr2tPDTGxU3AAErm7U6SMho-zYRIgRMUXkvRZO_KuARwhRruHsc0D5kXXGOZXOy9uhgPSR8dLYd6j1d4lXY7USQjnfj87ZgpEGtE-MkHSYzYcAOGCNwx7sbt_VV0VH//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="424" /></a><br />
One way to make that your data source is accessible is to open the URL in your web browser<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjU_FlSGlPN14IQ0Eqccnxlqt7vNJoeWVx1f38w9sCQomRM1X3y2DsoHKeMubilYjmyvIqv8zMnCtuFsE8ySSFZSjGUSv__ywDEpgdTv9pq5gGCZMssbjSUgpa7PW1ME07vZ2dAlk8mPJ3P/s1600-h/image119.png"><img alt="image" border="0" height="223" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhK1B1RzpywHRFWQgYbL-GYlTiPirZNU1-MBqUOT5XDIimgnMvmd58nqBbXRCJiENAUTVrfXOY21zGANqQFZdOqGLtY9AGwSGmGAmlJbpicJvLN9G2SoGexKKUeKd5ePO8OJSwq-mLr6k4R//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="542" /></a><br />
<h4>
Import the Drill data source Metadata</h4>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_GkQurGvUSqXDHieuJj8GSyKLjyoT6kon-WZV_6zxrdVyxp-W0QcfCw_RMSBVhCyqo97uKmWjUBNX25mik7FfWMH6fdH5Ild-5z7-fuf8WxJn7P1KiYTLXQxKWr8bfNRTwt9H_8BtefU4/s1600-h/SNAGHTML551da854.png"><img alt="SNAGHTML551da85" border="0" height="515" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJSFS-psuaAAkUnQvel9PcN5dVVR-yh3UgXCjegwzNBC3i2Vq5N2EYpsZDzR3Ch5nP4O8xNdk5hTrJVJ8Oh34eBEvZhmQ0HB5MGc5VV4Mwb6MzCO31f9wAbaOnfG5DsnLqmWRpR7h33goP//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="SNAGHTML551da85" width="618" /></a><br />
Next<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmXqaYaVP3AsjgLptShWwcV0hSrX2dQUABJl7l7KFusjDUdNM387wJbde_BoWvTsGLTHhcYZbAW3y2UMJu3co2iSxxkJpOGT1cYMDgN93ZuVOiv92vbVHhIW9sC1Ya0LXgxg0pNl6mT__d/s1600-h/SNAGHTML55599ee4.png"><img alt="SNAGHTML55599ee" border="0" height="517" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUhjBxsN26s-aXVwfbtYeBe7J70n1kBHFGVmHFIShMMmGlBRh44_2x6_j0hANI-z043vhTZo8Lk0UUlhTol5zhUNo3g3Cz-b8lroGIalVNnbcKQUCHHMTxKC8oE0hrCMhC7H8lydrvRXza//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="SNAGHTML55599ee" width="615" /></a><br />
The JNDI data source created in WebLogic points to the “hive” schema.<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAXNn_AUDmNms-6mbRjWGodE4vmfSmGEsoyYWXCn9gDGE0dbbI3ERaLtgmWM2n9QNpBHLwJMnxM1wk8LdH1IPlHKL0LJj-EILlCtRSYhQU6304Jvvtpo1slPjtryFLvl3h78Jot74OAZ2Q/s1600-h/image111.png"><img alt="image" border="0" height="515" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGqMNoJ1jbm9UV6GfFyxbFwTUngbebLfe3CxXsgAiFOIq2-QTHLkeLsBaObnyh3chtBEHiQbWdGaMdn7mxqjBO8yzIO1tZp9xX6Hm75kVj6EzZLSA5N_00gJWlYRTZP4CLvCEX4DIe-Kzb//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="700" /></a><br />
A new physical catalog “DRILL” is created along with a physical schema “hive.default”, the schema contains one table “orders”.<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmUyEKp-ssNEnUmZQnuov4sbOKFPW73G2snXx-_hCoG-4jGcCR1eWAnY8QKMNM4SoZrwgq0QV6ojhvu1Mhs9HVK9QH8EAKMmwZDdpdl9b4wWMEckNIMQO2r0MFn-Fbvuf7Wi5_47RQfGEq/s1600-h/image115.png"><img alt="image" border="0" height="108" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_W06N5vlZqZZrR5OgLhdaPv2NAKK5ABPi_rsHEsI9II2joTA5W1VuxLQAeJP13a9hVnbGzoh7bl_kh0fa2GayfQZwLfNBh5RdhZb0AVYnHtuFAbWLIk8EVYH4sPzIHwstl0_Pt-p70Her//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="424" /></a><br />
Let’s view the data<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWfvmGZxgdD2RqFKpyf8v4X8WLTmXtv_uy4NkSsCHq-cxGUeSmoxHNTuEpgM-8QsSz2w-lbpznFIbUiFCAGiZUxDF4BbBuN0VOvISzZUKnWbPlOHXZ25z0c_UwKy7ZjBPL6g9aCSXHwJBy/s1600-h/image127.png"><img alt="image" border="0" height="303" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSQxhYcRnJg-XZ_YPql3PQsP7-RW84frS3GD_YQTeBDBL2HtjTUfPslEMj4q4lHgUOSOS4pzu6lP8AEqSM0GLOWlj64CMMT_FbNHYInnkrJMzQfrWOHQvaIaThoRruyluQ5tZYJG2W8F4N//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="424" /></a><br />
Create a simple “Business Model” and analysis et voila!<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOldg7Nvy0l-ZbDye_8jsIuGvZT9eJS5IuFdPVk-oBAGc8S9xDP2G_FRe-2_i3a6jrtsN81ZElxIEOjE5U9Uyxb4DXEf7IU5sDMQxmtksrSoRQX4o-YjBSKRIVEQFq1-HxLpUs_LB04Ddy/s1600-h/image123.png"><img alt="image" border="0" height="348" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhR8eu5sMtRBAmvmSBmVDrlr1c3Zph2ppyu8OPog0Efh2yMVhkVa_4mZFYBFXrHsCK2-OGWOhfRybPrXDz1MKOsdTJCj9VVNyivxevmyNpIRcp7zAQEO2gLrydXTQzFxbWn8SPZxdcqXfH3//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="743" /></a><br />
Being able to import a JDBC data source into the OBIEE Administration Tool is a very powerful capability that will make it possible to import new types of data sources into OBIEE and perform analyses, I will be exploring new JDBC based data sources in the near future.<br />
Fiston<br />
a+Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-59996698939871771652015-10-23T21:51:00.000-07:002015-10-23T21:51:12.069-07:00OBIEE 12c is GA!<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8f93RxRYC4WP4VNuq-6lmrha4xnLfiZR1SXuwsTXRsV30HWWO4LuVhXNrxkjuuMatpMf8RwZTxlTmJTrBEpmVU8eNqLoMfrYY6mqWVkh75HqTrE5M9cjMHq1p6_kBxyjCJopvX_5ZmGOt/s1600/obiee.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="355" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8f93RxRYC4WP4VNuq-6lmrha4xnLfiZR1SXuwsTXRsV30HWWO4LuVhXNrxkjuuMatpMf8RwZTxlTmJTrBEpmVU8eNqLoMfrYY6mqWVkh75HqTrE5M9cjMHq1p6_kBxyjCJopvX_5ZmGOt/s640/obiee.jpg" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhu1bvsn-CNx5KxBpszb_I2O_cjb0c0BHh0TvJhRC7qml8cVCZ1n6KOINvbOigGfE7iyFtZ8Mbv1RzIss6c3OfRJzmJBnnumIABDM9XkLIjSzYwXHKbI_oh23XAP5qPmpq5h8sv-T8K3JsT/s1600/obiee1.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a></div>
<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhu1bvsn-CNx5KxBpszb_I2O_cjb0c0BHh0TvJhRC7qml8cVCZ1n6KOINvbOigGfE7iyFtZ8Mbv1RzIss6c3OfRJzmJBnnumIABDM9XkLIjSzYwXHKbI_oh23XAP5qPmpq5h8sv-T8K3JsT/s1600/obiee1.jpg" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img border="0" height="500" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhu1bvsn-CNx5KxBpszb_I2O_cjb0c0BHh0TvJhRC7qml8cVCZ1n6KOINvbOigGfE7iyFtZ8Mbv1RzIss6c3OfRJzmJBnnumIABDM9XkLIjSzYwXHKbI_oh23XAP5qPmpq5h8sv-T8K3JsT/s640/obiee1.jpg" width="640" /></a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-81043893251041732582013-11-11T09:32:00.000-08:002013-11-27T20:14:15.924-08:00Oracle Endeca Information Discovery (OEID) 3.1 quick install<span style="font-family: Tahoma;">As you may know, Oracle Endeca Information Discovery OEID was released November 7th, I decided to download the product and go through the installation. The great news is that the installation process has been greatly improved compared to OEID 3.0. With OEID 3.1, the overall installation can be scripted using an “orchestration script” to <u>install and configure</u></span> <br />
<blockquote>
<span style="font-family: Tahoma;">o Weblogic 10.3.6</span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">o Oracle ADF runtime 11.1.1.6</span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">o Endeca Server 7.6</span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">o Endeca Studio 3.1</span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">o Endeca Provisioning</span></blockquote>
<span style="font-family: Tahoma;">The purpose of this post is to document at a high level the steps while I am going through the installation using the provided orchestration script. My OS is Microsoft Windows Server 2008 R2. This post will cover the software staging, scripts modifications and install. A future post will cover the OEID Integrator installation and sample data load and new features.</span><br />
<span style="font-family: Tahoma;">The software package is available from Oracle Software Delivery Cloud. </span><br />
<span style="font-family: Tahoma;">1) Download the following media packages:</span> <br />
<blockquote>
<span style="font-family: Tahoma;">Oracle Endeca Server (7.6.0) media pack folder</span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">- V40519-01: Oracle Endeca Server (7.6) </span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">- V40521-01: Oracle Endeca Server (7.6) Sample data</span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">- V29856-01: Oracle Weblogic 10.3.6</span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">- V29673-01: Oracle ADF Runtime 11g Patch set 5</span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">Oracle Endeca Information Discovery Studio (3.1.0)</span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">- V40547</span> <br />
<span style="font-family: Tahoma;">You’ll notice also the media pack V40522-01 (IKM SQL to Endeca Server for integrating with ODI) which is pretty exciting.</span></blockquote>
<span style="font-family: Arial, Helvetica, sans-serif;">JDK version 6 is also a pre-requisite for the OEID 3.1 installation, I will be using JDK1.6.0_43.</span><br />
<span style="font-family: Tahoma;">2) Create a folder that will hold the installation scripts and the binary installation files, for example C:\stage</span> <br />
<span style="font-family: Tahoma;">3) Unzip V40547—> EID_3.1_Studio_InstallWin.zip—>eidOrch into c:\stage</span> <br />
<span style="font-family: Tahoma;">The eidOrch folder contains 2 subfolders:</span> <br />
<blockquote>
<span style="font-family: Tahoma;">- installers: actual software binaries for Endeca Studio and Endeca Provisioning</span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">- orchScripts: orchestration script for Endeca Studio and Endeca Provisoning</span></blockquote>
<span style="font-family: Tahoma;">4) Unzip V40519-01 into C:\stage to get </span> <br />
<blockquote>
<span style="font-family: Tahoma;">- endecaserver.zip </span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">- windows_OC.zip</span></blockquote>
<span style="font-family: Tahoma;">5) Unzip windows_OC.zip and move the resulting subfolder “windows” to</span> <br />
<span style="font-family: Tahoma;">C:\stage\eidOrch\orchScripts\</span> <br />
<span style="font-family: Tahoma;">6) Rename the folder that you just moved ES_windows_OC</span> <br />
<span style="font-family: Tahoma;">7) Move the endecaserver.zip file to c:\stage\eidOrch\installers</span> <br />
<span style="font-family: Tahoma;">8) Rename V29673-01 to ofm_appdev_generic_11.1.1.6.0_disk1_1of1.zip, that’s the name expected by the installation script and move it to C:\stage\eidOrch\installers. Note that you can download ofm_appdev_generic_11.1.1.6.0_disk1_1of1.zip from OTN.</span> <br />
<span style="font-family: Tahoma;">9) Unzip the V29856-01 media pack, this is the Weblogic 10.3.6 jar file and move it to c:\stage\eidOrch\installers</span> <br />
<span style="font-family: Tahoma;">10) Folder structure before installation</span><br />
<br />
<blockquote>
<span style="font-family: Tahoma;">C:\stage\eidOrch\Installers\</span></blockquote>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjosHWRhdA6lJNROm71yJxtcCETka-GbYW_rz-iEtbgezqVuvnmIdQaJf99S11nhtNWcJoi_h4K6buULI-_yQeXGT3bFKm3bkijrgSsBRiDKrUhrUS9o5SivdJApxEHMQVdsNW-7NTOZylg/s1600-h/image%25255B4%25255D.png"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt5qBQ4dH5pxCB710FSnAWYgj2iG6ZwIgrJcjew6VFLC709SA2JcAOhMd2RELWfWrWaf0kOQx6EipFYZo2NkroftXs0LadCSMLd0sqE4xXeBMksboizLmSr0bb61IwvnGkYS3ku3ZqpUZT/s1600-h/image%25255B67%25255D.png"><img alt="image" border="0" height="189" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6ANB2vPkt3wteLpxSih0znxDqYpxKsg8tLMtzgG0wWH_k4kPEdwq91XBML_XJiQx2g0BMcQTAqZaKOUq7ENszGKMFkKJIEF2ZLB4yMfePkCVl2JOVjmOMA9rHBh-HKhc5yqsrRm88fSrO//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="546" /></a><br />
<blockquote>
<span style="font-family: Tahoma;">C:\stage\eidOrch\orchScripts\</span></blockquote>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiO3ffyd-2mmjltRlGJNihXpxoPrWLHJG19bE6Mf0vMMG9uh5GhniBVBVetdbc68QGZ_xa8SujUU2NRb9bI2ov2yXb0zbHQkRUa1C-K0-nF0Tvh0D3vwfYaGhQqzsf4Xx5cIRGRHncOQfLL/s1600-h/image%25255B8%25255D.png"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2l_luMX3ER8-fFjhHZawXhCl9EdAqq9ruPHkWW0hexUKPvUBTJwicmVMSuzMiHjl-QR2puPy3Wmc0fbL9vymgfOBmMUdJPiglMsQ7TA6FKKeW2JepxYVhyf2HGW1B7BVL8amTtUvwgLH5/s1600-h/image%25255B68%25255D.png"><img alt="image" border="0" height="156" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQqGjSY106FZi7Cy8m_jnMBfvBK7oADPCp1EzgSOc8XroWl9vzZ-YHF9AcDO4ShbQFo2OmjTAZb07gQxflmZukp-7zE-xS65aYrjzOtlRgpzaQNzjar2XvKk4s1b5ntZcapPchb4TRrjc6//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="540" /></a><br />
<span style="font-family: Tahoma;">11) Run_EID_install.bat is the main script, it will call the following scripts</span> <br />
<blockquote>
<span style="font-family: Tahoma;">- eidOrch\orchScripts\ES_Windows_OC\run_endeca_server_install.bat (</span><span style="font-family: Tahoma;">Weblogic, ADF runtime, Endeca server installation)</span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">- eidOrch\orchScripts\Studio_windows_OC\run_endecastudio_install.batm(</span><span style="font-family: Tahoma;">Endeca studio installation)</span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">- eidOrch\orchScripts\PS_windows_OC\run_endecaprovisioning_install.bat (</span><span style="font-family: Tahoma;">Endeca Provisioning)</span></blockquote>
<span style="font-family: Tahoma;">The installations scripts will get the predefined configuration parameters from property files :</span> <br />
<blockquote>
<span style="font-family: Tahoma;">- eidOrch\orchScripts\config_EID_windows.prop</span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">- eidOrch\orchScripts\ES_Windows_OC\config_win.prop</span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">- eidOrch\orchScripts\Studio_windows_OC\config_Studio_win.prop</span></blockquote>
<blockquote>
<span style="font-family: Tahoma;">- eidOrch\orchScripts\PS_windows_OC\config_PS_win.prop</span></blockquote>
<span style="font-family: Tahoma;">Following are screenshots property files, note that JAVA_HOME, ORACLE_HOME and INSTALLER_LOCATION are the main parameters that have to be adjusted based on your local settings. </span><br />
<span style="font-family: Tahoma;">You also have the option to set additional parameters such as START_MODE, USE_SSL etc… One notable parameter for the Endeca_Server, Endeca_Studio and Endeca Provisioning product property files is INSTALL_MODE. This parameters specifies whether we’re performing an install only or an install followed by configuration. There are additional values to specify that there is an existing middleware installation. Refer to the documentation for more details. </span>Note that this install will be NON-SSL, if using SSL ports, there are additional setting to be changed on the property files.<br />
<span style="font-family: Tahoma;"><br /></span>
config_EID_windows.prop <br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijvXTz6VczL091r5Ca5c7yzUKSRPdOxOcF4_FIkDTrvLOzzlL7DUEjh2YlErmMeoe8fFX8TYn0Dgv1MX6-tqc7c_bvNCXSmL3TOrgcrPE6eL0cdJVO3IhlwLOfCShIRRhQ5-Rdv54qDdnN/s1600-h/image%25255B50%25255D.png"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxVCqBQ2tFoU9kXn7PW4ot75AgKxs4Dn7zGyrZlX1IWq4whwbu1odjVAMuSE0TZjOGW9voAE_TgbYs3gGln2rcfjKFL50vv-TKeJAxzLUswT5gbWv3Gw9ML0a0VisL47rglMvbfVuVOMH3/s1600-h/image%25255B58%25255D.png"><img alt="image" border="0" height="338" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_tvjLY4LKSV1BBZio42h5sY2XqvMxCDVN3Qj9b6xv7W0j6-NmISwH7IAT_exwew56AUwqOw7upF9AuQMPJFcClwWCY5dsyUKSJ6lsk_ANZjianUxIl5LeNYwfovEG0owj52uCLR3RPpGN//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="532" /></a><br />
config_win.prop<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRRxLrwP7vx-ARxedoGsRFzxeOU8NyZX7xWzj8bl0p4Y_E-U8j4xhVo_K1MBUfWNs8tvix7faF3-6QarZZSl-7gheGUVAlVgcBVkoP_LHEYWJEdCXVzZYNNQLE_YhwxhfMGIScInXcC22K/s1600-h/image%25255B47%25255D.png"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhq1Wt-0E3Jve0uGli-5vZFGJBqVaPaQXRVk6MmnLL443zJSzG3u_sW1Xfp4PLOA2WnwIdrGg512X3YvVYbWDY9pijxz9y_sDa6yt5wzzdeJGL36Ugojg4fo-I_Iay0RJWVUop8iWtVEFyy/s1600-h/image%25255B59%25255D.png"><img alt="image" border="0" height="285" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnaVwVUi8WrHYjobA2hX2wEQ4qoyE-dbu_7F9ZmFhSs_KV91rex0k_lyHqX-jxfQyufJyR88vEmVhNvKvxLgcCobsoaE3eHMy6Gom7hXO48-o5L-_PtHtwz7gtRUr96b0itwTpqQONlgY1//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="531" /></a><br />
config_Studio_win.prop<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYlxEHTGhLUVBgYkch8RlfaZCCv42MD_eMYYBsxYmYEbH3VnLx65fzAFTNpBN0xe-4i74ZQSAJDLcBAu9syKsQYEyS4gdHCOAweNty7GpQDUe6Wiknp4FQCCqyIxZhT8QQwApMg9XBdtMc/s1600-h/image%25255B48%25255D.png"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJ_9rgagBm4s41u4GF4PoU9Uu7O6oafOoN8v3KS2KI9YPZco1enrlCINip2T369paY7RmXrrz6G_XS4jEP3uTMUj0zQeF1gob_km08zIl1-2J9LUP89JYz5AM2MqEcGlQ6Pms89aATwsLp/s1600-h/image%25255B60%25255D.png"><img alt="image" border="0" height="354" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZa9I2UHMamRkVFEWUnxSh0UT6C-qWUNLgnB85APySKx8LkjAuN_sGUOJRvrvv-ghPK50I5Lw-8IMof6t1JnJxHFsfxV9l7xnFhyphenhyphen6fEnQuDOKON9BiuFQ-pWY5LZuJOiKz2z9jBJQvgMWf//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="525" /></a><br />
config_PS_win.prop<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikx3OFYdX0yRjrQNsbyGuQF9_ycoBdJXE2pdTzXX2YIAmb4Xt89ZIFJ85Fn-EKmwYwJaGtHI1zzr2hDM4t3UFJowzu7L-041E_2bpTiNKoUkvHYtvRcizR2XeLmYpIgRmFu6p8z-vzubiE/s1600-h/image%25255B49%25255D.png"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVGszyDSZZFe2Sr1G02qktki2oAYuByPeRDkHoW1MXzt9u76zcqdCSDCFADHWgsP5GxB3Zrmx2LUSYUtZc0rv94AMt52GsvNXFtYGo6zA0JHvJrknfFVAfutUbIp6UjjJFTh1Y4FslsrnZ/s1600-h/image%25255B61%25255D.png"><img alt="image" border="0" height="287" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXWKYQR6sPxfSMb7PCxXnfGcr5hMRrORelBRPcKo1M90sO93E8_6jnNENOm1Fkt6WOuWcHXgKpr-P-95EagjOCmVqidcHVDkf4IfCMS5oy8GtiW-IT4qqRFlG16pVQM10Ddt5IW4rrIGK2//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="519" /></a><br />
<span style="font-family: Tahoma;">Open a DOS command prompt as Administrator and cd into c:\oracle\eidOrch\orchScripts\</span> <br />
<span style="font-family: Tahoma;">Then launch the main orchestration script:</span> <br />
<span style="font-family: Tahoma;">run_EID_install config_EID_windows.prop --temp-directory c:\temp</span> <br />
<span style="font-family: Tahoma;">and watch the installation in progress. You will be prompted to enter parameters such Admin usernames/passwords (you can potentially modify the scripts to automate this step).</span><br />
<span style="font-family: Tahoma;"><b>Caution:</b></span><span style="color: red; font-family: Tahoma;"> </span> if you're using a disk drive (for the temporary directory) that is different from the one that holds your scripts, the installation script will fail. In my case I had to modify the installation scripts as follows: search for the line<br />
cd %TMPFOLDER%\bin<br />
enter a new line below it with<br />
C:<br />
This has to be done for run_endecaprovisioning_install.bat, run_endecastudio_install.bat and the endecaserver_install.bat<br />
<span style="color: red; font-family: Tahoma;"><br /></span>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgg-6C8H7_9DgF9gQGZnw9yWdOH_iqpYSgryInb38oSckHcmd_ETfbx81Lggq8EEmCHqMKVlOOW-zDNoPWBJK05Tdrqstu4QTlA4rys2ILTDlXg1NuKqxs5IhyphenhyphenzFKM8ZFe3JwdZamLmv3PO/s1600-h/image%25255B45%25255D.png"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1yIP4MFKVixVWXzYHKOuNeh4XjUuN1myc2eCCJpKdKRGhAoo-CCR11dH8FWbM5PrRV1fQb2aYfgaHVl7dFEc-ES1wyItcgllRnPHFdawc4wRa2zIogKofhJQXzDtpgy_ZAP0EeCfsAxgY/s1600-h/image%25255B62%25255D.png"><img alt="image" border="0" height="322" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtcBDgheiu5_tw8f5rpVMhlkzHsNWNQoWEqzrfvIvv5-Gn-EABbVGWDX9-MgoRm4E3RrYAt3_3vi1krg09Ui7mPQUfZjos9jkHRf73CTJCgwhgYHPQNGSmXSinv0Xn2bVITJFk-UzYNMbT//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="523" /></a> <br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwx1UQL7DLr9vMoJfllo7xMfyjr_T9A2WEnkGlZJJH0VNP-3lqtq3HaXtawrjBOmVjYxS9DiS8ecTS1tGHoY6XWTvL-SqlQrCl2IibnDS3Ph2vb4rxP7WUDRCO41nJiN9bwMUjMAJA80je/s1600-h/image%25255B44%25255D.png"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBA8hJu-p3DRVLSL3qY7G2FhidtsDULmwUoKKfNhw8hl6gigsi060ge3R-KYWDhub-AerOFhx0Dfx-wK4YrTt7nlBbc0kYWE3wXqGh7Ti8aIzpEEAGQajzQtpow6RlVDUdWSeCh45St1Gy/s1600-h/image%25255B63%25255D.png"><img alt="image" border="0" height="235" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi95MeX86Yj_C4VnyAsp6EQ7HYqST63TR1ysLFuVAKppCH6JNAXWgz6UiUjjuoXtkFhTUT583CAE65NEh5_NmzReppqAMWkKcUOQ3oc7JliRbft6H1VJNKrg1T7CmkB5MCDcUYA_rhI3wk8//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="526" /></a> <br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNm_aArTIAk68yJ4UMqGpj8J3D6ohw2DNNrHxrWocWXdyMwUc7B-LftjgJL5yedWjEZI7_4RK03cdKYnSvzVi9m_DhqBsm43sFqAY4r9C4dJ9jdXjFsH81kREly90-iDjHw2N9qOksMdDW/s1600-h/image%25255B46%25255D.png"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjs7-rlb3-AfNiVFAiVpqAHPx4OL8a6kp1rdEvy4SHY39UCxlyGO5NdM0GXmZY7M4hawBryBZi_Bzd8Igoj1_RcnSnkkHiOguLak5umWuBpUMf8kSf4BizJgtuYIxEtUxJEzjTg2iQG0IYM/s1600-h/image%25255B64%25255D.png"><img alt="image" border="0" height="202" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjap4ukRsCzmyXkgI20pRPSYl4CWNDU2v0RicVRg6ahU47BRTalocNnctqyhyphenhyphenkWP96aXQbw8luBICAW0AGZ71DkasZW2YHl_kkMcWw4GAMyPOJv4ozx8U_lx7Fn9Uqy7DYu3Rcua5EAL4NR//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="531" /></a> <br />
<span style="font-family: Tahoma;">At the end, you’ll have the Endeca Server, Endeca Studio, Endeca Provisioning fully installed/configured and up and running in no time! </span><br />
<span style="font-family: Tahoma;">A much smoother install process for OEID 3.1 indeed!</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">p.s OEID software is now available for download on </span><a href="http://www.oracle.com/technetwork/middleware/endeca/downloads/downloads-1544965.html" style="font-family: Arial, Helvetica, sans-serif;">OTN</a><br />
<span style="font-family: Tahoma;"><br /></span>
<span style="font-family: Tahoma;"><span style="color: red;">update</span>: Several users are experiencing an issue when they try to invoke web services to import da</span><span style="font-family: Arial, Helvetica, sans-serif;">ta <i>(OES-000169: Could not connect to Endeca Server at 10:7001)</i></span><span style="font-family: Tahoma;">. The work around is to make sure that the Windows hosts has an entry with IP address, machine name.domain </span><span style="font-family: Tahoma;">example:</span><br />
<span style="font-family: Tahoma;">192.168.56.1 endeca.demo.org endeca</span><br />
<span style="font-family: Tahoma;"><br /></span>
<span style="font-family: Tahoma;">a+</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Fiston</span><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-80940004862355894472013-02-04T20:30:00.001-08:002013-02-04T20:30:17.776-08:00Creating BIP Gantt Charts using JFreeChart (cont.)<span style="font-family: Arial;">In my previous post I showed the majors steps for creating a simple Gantt Chart in BI-Publisher using the JFreeCharts API. The purpose of this post is to provide the technical details of the implementation. </span> <br />
<span style="font-family: Arial;">We first need to download the following JAR files:</span> <br />
<span style="font-family: Arial;">· </span><a href="http://sourceforge.net/projects/jfreechart/files/"><span style="font-family: Arial;">jfreechart-1.0.4.jar</span></a> <br />
<span style="font-family: Arial;">· </span><a href="http://sourceforge.net/projects/jfreechart/files/"><span style="font-family: Arial;">jcommon-1.0.8.jar</span></a> <br />
<span style="font-family: Arial;">· </span><a href="http://www.java2s.com/Code/Jar/c/Downloadcommonscodec15jar.htm"><span style="font-family: Arial;">Commons-code-1.5.jar</span></a><br />
<span style="font-family: Arial;"> </span> <br />
<b><u><span style="font-family: Arial;">Extension code:</span></u></b> <br />
<span style="font-family: Arial;">Create a Jdeveloper generic application</span> <br />
<span style="font-family: Arial;">Application Name: GanttChart</span><br />
<span style="font-family: Arial;"> </span> <br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTTiMxT887knr_8du11CmjHW_IsuFZERCR9YF80kCZOwPYYz1g6rwrs3RK_gsnQYtaFqqdLgmc_aC5_6Z3aEnYKZPA317kFXmC3qlIhpE64MxiwBegOTpVEh8rdTxomyEujZ8DQB0Ettpl/s1600-h/g1%25255B4%25255D.jpg"><img align="left" alt="g1" border="0" height="349" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhh6j7cZmez_MtY7kOv8epvxfIx-WO6tsx72LWCnRehweEj7_tZ_QZQPUScSfHbLM-eJy85k3E-tVYWCe9YaLJ0YsPb_c2LxkdmeVMbq3iW3hztR83PVkNssQu2pVpjbMCqiA9UfZFMG5l4//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; float: left; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="g1" width="463" /></a> <br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">Click Next to create a project: </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">Project Name: bip </span><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWAFrNFPhJ3043RV7is6USH-6v4xOQhtHApZm1wYy-TKo5Jma849VKhUxJfO2SaudC83zvi91gMk41yWLIN-yywqtemE86Ben9eVIaJkjR5tBWU2s_QWTnk5JpBDROo5ynzUbwHHAD-yCG/s1600-h/g2%25255B7%25255D.jpg"><img alt="g2" border="0" height="280" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVOrHa4Z-0XwV1Lf6eRJoy1rGiKxozIqixqviVrLHjnUKrdArQpe24FPvwEIvT5tS1vB50fVPMrmDK0JreRMpK6Na3fmJgToBW2Z1nja0pVQmffh8yIwTX4NDXmz5q4Iip2O0vKkVTtCtw//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="g2" width="506" /></a> <br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">Add a new Java class to the bip project </span><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieL8vf7iPheR8O-QoQVu3XEE4VkaqLs-5CJwG1SpoMZbQPaKHJ9tyQ40_ClDGe-nqZeGhT9EYAt8whTfKRmtYF4FySojLD50p8OxUWMHSpZ2lzRgViosUiNzVjX3P_G7Hji51lioXaKqTp/s1600-h/g3%25255B3%25255D.jpg"><img alt="g3" border="0" height="346" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkxx4PUv5n4YcIvLItvRtILdctCq9LJAwqj1tJSwmISrUWFkFAYNkF6K4mfxd4sbWHk6STmKACQvnt0hQQoGQ4ciLIT1VBNR9aC61lYX1oNh34ZSOslPzAlIUIh-2VDWD43vdAnnlc-awO//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="g3" width="286" /></a> <br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">I’ve created a Java class that will be packaged as a jar file and copied to the Weblogic folder. The purpose of this file is to: </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">1) Read in the XML from the BI-Publisher data model: </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">2) Organize XML data in the format expected by the JFreeChart API </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">3) Plot the Gantt Chart using the API </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">4) Return the generated image </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">5) BI-Publisher renders the image on the report </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">Update the code in Jdeveloper with the following is the code listing: <u>this is a very crude code intended for testing only</u></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><u> </u></span> <br />
<span style="font-family: Arial; font-size: xx-small;">/* ======================================</span> <br />
<span style="font-family: Arial; font-size: xx-small;">* JFreeChart : a free Java chart library</span> <br />
<span style="font-family: Arial; font-size: xx-small;">* ======================================</span> <br />
<span style="font-family: Arial; font-size: xx-small;">*</span> <br />
<span style="font-family: Arial; font-size: xx-small;">* Project Info: http://www.jfree.org/jfreechart/index.html</span> <br />
<span style="font-family: Arial; font-size: xx-small;">* Project Lead: David Gilbert (david.gilbert@object-refinery.com);</span> <br />
<span style="font-family: Arial; font-size: xx-small;">*</span> <br />
<span style="font-family: Arial; font-size: xx-small;">* (C) Copyright 2000-2003, by Object Refinery Limited and Contributors.</span> <br />
<span style="font-family: Arial; font-size: xx-small;">*</span> <br />
<span style="font-family: Arial; font-size: xx-small;">* This library is free software; you can redistribute it and/or modify it under the terms</span> <br />
<span style="font-family: Arial; font-size: xx-small;">* of the GNU Lesser General Public License as published by the Free Software Foundation;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">* either version 2.1 of the License, or (at your option) any later version.</span> <br />
<span style="font-family: Arial; font-size: xx-small;">*</span> <br />
<span style="font-family: Arial; font-size: xx-small;">* This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">* without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.</span> <br />
<span style="font-family: Arial; font-size: xx-small;">* See the GNU Lesser General Public License for more details.</span> <br />
<span style="font-family: Arial; font-size: xx-small;">*</span> <br />
<span style="font-family: Arial; font-size: xx-small;">* You should have received a copy of the GNU Lesser General Public License along with this</span> <br />
<span style="font-family: Arial; font-size: xx-small;">* library; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330,</span> <br />
<span style="font-family: Arial; font-size: xx-small;">* Boston, MA 02111-1307, USA.</span> <br />
<span style="font-family: Arial; font-size: xx-small;">package oracle.bip.extensions;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import java.awt.image.BufferedImage;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import java.io.IOException;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import java.sql.SQLException;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import java.text.ParseException;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import java.text.SimpleDateFormat;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import java.util.ArrayList;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import java.util.Iterator;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import java.util.List;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import org.apache.commons.codec.binary.Base64;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import javax.sql.rowset.serial.SerialException;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import javax.xml.parsers.ParserConfigurationException;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import org.jfree.chart.ChartFactory;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import org.jfree.chart.ChartPanel;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import org.jfree.chart.ChartRenderingInfo;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import org.jfree.chart.ChartUtilities;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import org.jfree.chart.JFreeChart;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import org.jfree.chart.entity.StandardEntityCollection;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import org.jfree.data.category.IntervalCategoryDataset;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import org.jfree.data.gantt.Task;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import org.jfree.data.gantt.TaskSeries;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import org.jfree.data.gantt.TaskSeriesCollection;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import org.w3c.dom.Element;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import org.w3c.dom.Node;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import org.w3c.dom.NodeList;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">import org.xml.sax.SAXException;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">public class bipExt {</span> <br />
<span style="font-family: Arial; font-size: xx-small;">public static String createGantt(NodeList bipXML, String taskName,</span> <br />
<span style="font-family: Arial; font-size: xx-small;">String taskStartDate,</span> <br />
<span style="font-family: Arial; font-size: xx-small;">String taskEndDate, String title) throws IOException,</span> <br />
<span style="font-family: Arial; font-size: xx-small;">SerialException,</span> <br />
<span style="font-family: Arial; font-size: xx-small;">ParserConfigurationException, SQLException, SAXException,</span> <br />
<span style="font-family: Arial; font-size: xx-small;">ParseException, NullPointerException {</span> <br />
<span style="font-family: Arial; font-size: xx-small;">final TaskSeries s1 = new TaskSeries("GANTT");</span> <br />
<span style="font-family: Arial; font-size: xx-small;">//Read in the start dates, end dates, task names as lists</span> <br />
<span style="font-family: Arial; font-size: xx-small;">ArrayList<String> startDate = new ArrayList<String>();</span> <br />
<span style="font-family: Arial; font-size: xx-small;">ArrayList<String> endDate = new ArrayList<String>();</span> <br />
<span style="font-family: Arial; font-size: xx-small;">ArrayList<String> taskname = new ArrayList<String>();</span> <br />
<span style="font-family: Arial; font-size: xx-small;">// First parameter list is the list of task start dates</span> <br />
<span style="font-family: Arial; font-size: xx-small;">for (int i = 0; i < bipXML.getLength(); i++) {</span> <br />
<span style="font-family: Arial; font-size: xx-small;">Node node = bipXML.item(i);</span> <br />
<span style="font-family: Arial; font-size: xx-small;">if (node.getNodeType() == Node.ELEMENT_NODE) {</span> <br />
<span style="font-family: Arial; font-size: xx-small;">Element element = (Element)node;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">NodeList nodelist = element.getElementsByTagName(taskStartDate);</span> <br />
<span style="font-family: Arial; font-size: xx-small;">Element element1 = (Element)nodelist.item(0);</span> <br />
<span style="font-family: Arial; font-size: xx-small;">NodeList startDateNode = element1.getChildNodes();</span> <br />
<span style="font-family: Arial; font-size: xx-small;">String c1=startDateNode.item(0).getNodeValue().toString();</span> <br />
<span style="font-family: Arial; font-size: xx-small;">// Extract the canonical dates</span> <br />
<span style="font-family: Arial; font-size: xx-small;">startDate.add( c1.substring(0, 9));</span> <br />
<span style="font-family: Arial; font-size: xx-small;">}</span> <br />
<span style="font-family: Arial; font-size: xx-small;">}</span> <br />
<span style="font-family: Arial; font-size: xx-small;">// Second parameter list is the list of task end dates</span> <br />
<span style="font-family: Arial; font-size: xx-small;">for (int i = 0; i < bipXML.getLength(); i++) {</span> <br />
<span style="font-family: Arial; font-size: xx-small;">Node node = bipXML.item(i);</span> <br />
<span style="font-family: Arial; font-size: xx-small;">if (node.getNodeType() == Node.ELEMENT_NODE) {</span> <br />
<span style="font-family: Arial; font-size: xx-small;">Element element = (Element)node;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">NodeList nodelist = element.getElementsByTagName(taskEndDate);</span> <br />
<span style="font-family: Arial; font-size: xx-small;">Element element1 = (Element)nodelist.item(0);</span> <br />
<span style="font-family: Arial; font-size: xx-small;">NodeList endDateNode = element1.getChildNodes();</span> <br />
<span style="font-family: Arial; font-size: xx-small;">String c2=endDateNode.item(0).getNodeValue().toString();</span> <br />
<span style="font-family: Arial; font-size: xx-small;">// Extract the canonical dates</span> <br />
<span style="font-family: Arial; font-size: xx-small;">endDate.add(c2.substring(0, 9));</span> <br />
<span style="font-family: Arial; font-size: xx-small;">}</span> <br />
<span style="font-family: Arial; font-size: xx-small;">}</span> <br />
<span style="font-family: Arial; font-size: xx-small;">// First parameter list is the list of task labels</span> <br />
<span style="font-family: Arial; font-size: xx-small;">for (int i = 0; i < bipXML.getLength(); i++) {</span> <br />
<span style="font-family: Arial; font-size: xx-small;">Node node = bipXML.item(i);</span> <br />
<span style="font-family: Arial; font-size: xx-small;">if (node.getNodeType() == Node.ELEMENT_NODE) {</span> <br />
<span style="font-family: Arial; font-size: xx-small;">Element element = (Element)node;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">NodeList nodelist = element.getElementsByTagName(taskName);</span> <br />
<span style="font-family: Arial; font-size: xx-small;">Element element1 = (Element)nodelist.item(0);</span> <br />
<span style="font-family: Arial; font-size: xx-small;">NodeList labelNode = element1.getChildNodes();</span> <br />
<span style="font-family: Arial; font-size: xx-small;">String label = labelNode.item(0).getNodeValue();</span> <br />
<span style="font-family: Arial; font-size: xx-small;">taskname.add(label);</span> <br />
<span style="font-family: Arial; font-size: xx-small;">}</span> <br />
<span style="font-family: Arial; font-size: xx-small;">}</span> <br />
<span style="font-family: Arial; font-size: xx-small;">BufferedImage chartImage;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">bipExt gantt = new bipExt();</span> <br />
<span style="font-family: Arial; font-size: xx-small;">// Create the dataset expected by JFreeChart for the Gantt Chart Type</span> <br />
<span style="font-family: Arial; font-size: xx-small;">IntervalCategoryDataset dataset =</span> <br />
<span style="font-family: Arial; font-size: xx-small;">gantt.createDataset(startDate, endDate, taskname);</span> <br />
<span style="font-family: Arial; font-size: xx-small;">// Create the JFreeChart</span> <br />
<span style="font-family: Arial; font-size: xx-small;">final JFreeChart chart = ChartFactory.createGanttChart(</span> <br />
<span style="font-family: Arial; font-size: xx-small;">title,</span> <br />
<span style="font-family: Arial; font-size: xx-small;">"Task",</span> <br />
<span style="font-family: Arial; font-size: xx-small;">"Date",</span> <br />
<span style="font-family: Arial; font-size: xx-small;">dataset,</span> <br />
<span style="font-family: Arial; font-size: xx-small;">true,</span> <br />
<span style="font-family: Arial; font-size: xx-small;">true,</span> <br />
<span style="font-family: Arial; font-size: xx-small;">false</span> <br />
<span style="font-family: Arial; font-size: xx-small;">); </span> <br />
<span style="font-family: Arial; font-size: xx-small;">chart.setBackgroundPaint(new GradientPaint(0, 0, Color.white, 1000, 0, Color.blue));</span> <br />
<span style="font-family: Arial; font-size: xx-small;">// Render the Chart as an image</span> <br />
<span style="font-family: Arial; font-size: xx-small;">final ChartPanel chartPanel = new ChartPanel(chart);</span> <br />
<span style="font-family: Arial; font-size: xx-small;">int width=450;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">int height=270;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">chartPanel.setPreferredSize(new java.awt.Dimension(width, height));</span> <br />
<span style="font-family: Arial; font-size: xx-small;">ChartRenderingInfo info = null;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">info = new ChartRenderingInfo(new StandardEntityCollection());</span> <br />
<span style="font-family: Arial; font-size: xx-small;">chartImage = chart.createBufferedImage(550, 350, info);</span> <br />
<span style="font-family: Arial; font-size: xx-small;">byte[] buffered_image = ChartUtilities.encodeAsPNG(chartImage);</span> <br />
<span style="font-family: Arial; font-size: xx-small;">String image = new String(Base64.encodeBase64Chunked(buffered_image));</span> <br />
<span style="font-family: Arial; font-size: xx-small;">return image;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">}</span> <br />
<span style="font-family: Arial; font-size: xx-small;">public bipExt() {</span> <br />
<span style="font-family: Arial; font-size: xx-small;">}</span> <br />
<span style="font-family: Arial; font-size: xx-small;">public static IntervalCategoryDataset createDataset(List sdate,</span> <br />
<span style="font-family: Arial; font-size: xx-small;">List edate,</span> <br />
<span style="font-family: Arial; font-size: xx-small;">List taskName) throws ParseException {</span> <br />
<span style="font-family: Arial; font-size: xx-small;">Iterator iterator = sdate.iterator();</span> <br />
<span style="font-family: Arial; font-size: xx-small;">final TaskSeries s1 = new TaskSeries("Schedule");</span> <br />
<span style="font-family: Arial; font-size: xx-small;">for (int i = 0; i < sdate.size(); i++) {</span> <br />
<span style="font-family: Arial; font-size: xx-small;">String c1;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">String c2;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">c1=sdate.get(i).toString();</span> <br />
<span style="font-family: Arial; font-size: xx-small;">c2=edate.get(i).toString();</span> <br />
<span style="font-family: Arial; font-size: xx-small;">s1.add(new Task(taskName.get(i).toString(), new SimpleDateFormat("yyyy-MM-dd").parse(c1),</span> <br />
<span style="font-family: Arial; font-size: xx-small;">new SimpleDateFormat("yyyy-MM-dd").parse(c2)));</span> <br />
<span style="font-family: Arial; font-size: xx-small;">}</span> <br />
<span style="font-family: Arial; font-size: xx-small;">final TaskSeriesCollection collection = new TaskSeriesCollection();</span> <br />
<span style="font-family: Arial; font-size: xx-small;">collection.add(s1);</span> <br />
<span style="font-family: Arial; font-size: xx-small;">return collection;</span> <br />
<span style="font-family: Arial; font-size: xx-small;">}</span> <br />
<span style="font-family: Arial; font-size: xx-small;">}</span> <br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">Add the previous 3 jar files to the project </span><br />
<br />
<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwoJI0K7DfzdIr2k4K4QimghN5lUWzEtGtOpezc-nqrsb0Av39FTYKJXIj9RihvJlJ_iSRMbeApaj-UC3HFNnTXhu6LWlXLRHsiAiHzz50WtHUFj1YlZZHZaAW5uX5H0M5nQoISiNke5di/s1600-h/g5%25255B4%25255D.jpg"><img alt="g5" border="0" height="308" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKMlMyPakoeaNLZuJdaxeo75VKDDNhhtEFzPn6_Lp6oYhgl5j-6-el6OMq9lLJxd5TExjEOKYkGA3f2rWjbCF_bevS9yxnATrQs1qd2yEpmp1-6z8fWbGQARBmSxl4bisZpE9wL1NOxH8v//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="g5" width="430" /></a><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">And create the JAR Deployment file </span><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6cGNCnWhec16zhNG0N3JKIIcrAb377NWBn07O2T_DA8DaaQNC6LHwMbLE6FVNFKnKi3uNSjs6EGVQQchlXGnBWEafjL1EfaSfVnyWfv_2oqNuGV6uGbtZpAkxBpaVActakI0P7FUGAobs/s1600-h/g6%25255B3%25255D.jpg"><img alt="g6" border="0" height="236" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikTMRUXmFDsYwECQb91J5aMa0Zxn12ldV7ellEGnWTMNOTTNEdjaYbeqqV6DjhK5omRwbsyOI2VaqUrBpKyhoi0q77TTrWu-7hPo-rqzZvOc7Hu579VKvOguBfK_snNvZm6DTRR16ckqLK//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="g6" width="416" /></a> <br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">Once the JAR File is generated, copy it to the place where Weblogic server expects it </span><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpgGNE6VFAGN6bXCgB4ilvWwl_y6i46CSDbRxy-awktNPoyboxxa6GmiExiacdtfYs2P38AHgTIcTwoaOzj50Lr05AoixKZnB4csE1xh25DMmSPblkF269q7VcW3eG0K5bI7k2Vy7LliOR/s1600-h/g8%25255B3%25255D.jpg"><img alt="g8" border="0" height="222" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYXRVVN91bFzKIkDNWHZPCKqNfSLap2RmCV_TgAmu2Sui7dhQ0iQyIyVMi3x0_tWm4KenZLBLzyCbDTP8nHpYgQbKCrnwwy1WB-c4x-CqfCRNI_uwzWsWCeF8145xmQDqGItNLDbhQryUn//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="g8" width="406" /></a><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">Log into to BI Publisher and “Change the Disable external references” flag to “False”, it is “True” by default. </span><br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b><u>BI Publisher Report:</u></b></span> <br />
<span style="font-family: Arial,Helvetica,sans-serif;">Create the BI-Publisher data model. For this example, download the ACTIVITIES table from the <a href="http://technology.amis.nl/2007/05/07/creating-a-gantt-chart-in-sql/">amis</a> site and create a simple BIP SQL query: </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">select label,start_date,end_date from activities with the respective XML tag names: LABEL, START_DATE, END_DATE</span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"> </span> <br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpZsmlfAKAE1xW_vL5LQpK00kdxIFKWJNPIlotDVTsK3Y-wVz2tvu5AKdAN-AONw0liw5zll3KiBmqDtA40u77TtpKlKwIQarCNagbUGcFMjTTbDrsa4G15J0-YM-_mfJFBz76-A4i9VgC/s1600-h/g9%25255B3%25255D.jpg"><img alt="g9" border="0" height="169" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNSrkG1Tppk_-Zax1BoU9ZV9phC1CaXYJy2ZnIK_4kaiwOaSEm5IBGNkq-42kWsQCs4HpqUKT4lFNBA-sPddB6nXNcylufWd4Ew2tIeU-uoEbyC1zyYfUyYqq6VsRifgVf7hX0wkxIio3k//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="g9" width="407" /></a> <br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">Following is a sample XML data set from the data model </span><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXdOpRn7euTI1K7w3Yn7FjKFAF0w_BhTDh9eycv4l3wLAjEADr76OZQb_JDyglVDSNSLMVMua93oFrCryPxmiLvwULVxL9siA0BJ5jHrvj4SRE5O2qvYwMFr6ZAHWrqCKubbLcfsabQPme/s1600-h/g10%25255B3%25255D.jpg"><img alt="g10" border="0" height="369" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgq4BZEOD2UBK9pMZmQy3AxqpbUENMaXH8mOGkWpNdXT0BCkPDoaG9F4-LgoMnRcKvjQa0k_Q7lzYx5A118su-oS4yRkAQMwwEsLtOJ9nh2l4AUOoAK34E51Vx_y0pyNxMwRGkbf_P5S2CR//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="g10" width="380" /></a> <br />
<br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">Create an RTF template using BIP template builder with the following 3 form fields: </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>1) </b><b>Namespace:</b></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b> </b></span> <br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg38uVZuAMxPdjaZjsnUWyADSNEUyInAXQDQ2jueOoMnPFOb6EeFwPBHQtcz7wUox-Oaen7pShYdIsRCEb2WckWv1A5DmWkfut2754Ys9d-c0DOyhKxtSnwbrA3eSFgu3MQG1h_7uczxd7A/s1600-h/g11%25255B3%25255D.jpg"><img alt="g11" border="0" height="137" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2xHEH5WLTe6NyIS3oofkaZFvW09e1OyUlDyh23u6mXPyVAep_LfEBQXEK8jroQGQ88tte3RVV3ZN5mizAlyXU6wbywamzZ-CXVp6dI42SRv1J4SFlRX6SHtWRqXy2_CR05jLxUkE6ZFsm//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="g11" width="370" /></a> <br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>2) </b><b>Create Gantt:</b></span> <br />
<span style="font-family: Arial,Helvetica,sans-serif;">Call to the Java extension to pass in the XML data from BIP, the XML tag names and title, the result from the call is stored in a parameter called GanttIMG </span><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdsANkibcfTX4d5qFje8H8VEjLYJtMkdP51PuRxUwKHI0LiXH8mEzwDva9j92nZf8jDXpzygKERFe_6nT94kxHQWcVklULUD1efez7rh2pvDmI08H1SQviMrt18hNQnz0SySfLYDylEy-_/s1600-h/g15%25255B6%25255D.jpg"><img alt="g15" border="0" height="148" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWfgZlsX1zu9f01ZA93YjoKMHKPxaPR38zZ9nyQoSOPh_vyBOWY0gLeHRbrUepg7VKgF2-E31CcF4kVdY44i1TUPUDuKO4h9Ap-rDwWFVl7uUCllTxz7XH9w5-GKP40PM-TRF8qS_G2vwQ//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="g15" width="364" /></a> <br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;"><b>3) </b><b>Display Gantt:</b></span> <br />
<span style="font-family: Arial,Helvetica,sans-serif;">Display the image on the report </span><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPKuYVMil0cvT3FdNTWOWWjdua4C93AFmrCzs56u6yxV_mLeyFYh3Bh_caDFJ0rGtRk1fUnpGtuihhSOM5IYb75MOYRUj_XVz56UmQV0bSMzhsasnCjgh8DyeO8z8blMrYGlM8POJJLY1E/s1600-h/g13%25255B3%25255D.jpg"><img alt="g13" border="0" height="142" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGYQpmsdb7XuDcX0iWcHfnEyNw5aLXhyphenhyphenmQvD71Bp147h9zHMQ8scCQi0BbxOI_wLV5mK2UqgEqsxFyEm7Vuy8hsDCGVIgeSqBzF7jZeejjNIwW6sS_bMxi18jktl5pQ5ulpxkWjpJkq7_Q//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="g13" width="375" /></a> <br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">Create a new BIP report using this RTF template and the previous data model. </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">Run your report, if all goes well: ta-da! </span><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKTsKQAec0xkD-8xcb3ic3Xb3YE6SV8STJ9U58K46vQwYfkxzZE0PlnvCmo1UlGLMKYPb-8Myl1jqNqITIWij-JHe95OJKHQxKGr4995G7PD2ubdPfZFDbitDeJY9M74RaDL5nO-qbXrlj/s1600-h/g16%25255B3%25255D.jpg"><img alt="g16" border="0" height="338" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEin4e8NO0KowIuLJl4__HECTUqft_sMBhM5TiruwoVpeE4MSEyCZ93vPpJjlJZ3fT9JECNxD4LDncNbLby39WVrtWx6XaXnemFI57wramCrpCB5e9QFJ5RAHSUc_nP3VhpRbF97rwa0Yf_o//?imgmax=800" style="background-image: none; border-color: -moz-use-text-color; border-style: none; border-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="g16" width="407" /></a> <br />
<br />
<span style="font-family: Arial,Helvetica,sans-serif;">a+ </span><br />
<span style="font-family: Arial,Helvetica,sans-serif;">Fiston </span><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-4175271697525822912013-01-23T19:48:00.000-08:002013-01-23T19:48:12.786-08:00Creating BIP Gantt Charts using JFreeChart<span style="font-family: Verdana; font-size: small;">An overlooked feature of BI-Publisher is the ability to create custom extensions in Java in order to add capabilities beyond the out of the box features. Tim Dexter blogged about this </span><span style="font-size: small;"><a href="https://blogs.oracle.com/xmlpublisher/entry/bip_extensions"><span style="font-family: Verdana;">undocumented feature</span></a><span style="font-family: Verdana;"> several years ago. </span></span> <br />
<span style="font-family: Verdana; font-size: small;">Using this feature, I was able to integrate BI Publisher with </span><span style="font-size: small;"><a href="http://www.jfree.org/jfreechart/"><span style="font-family: Verdana;">JFreeChart</span></a><span style="font-family: Verdana;"> an Open Source plotting API in order to generate plots that are not provided by BI-Publisher such as the Gantt chart type. The main steps are as follows:</span></span> <br />
<span style="font-family: Verdana; font-size: small;">1) Create the BIP data model: as an example I used the sample Gantt data set from the </span><span style="font-size: small;"><a href="http://technology.amis.nl/2007/05/07/creating-a-gantt-chart-in-sql/"><span style="font-family: Verdana;">amis</span></a><span style="font-family: Verdana;"> website.</span></span> <br />
<span style="font-size: small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2SvA7vwAYNXSXMd-NGgEZK-Bsj5JrAh58yzb0XYUU8yVGIsd14EvvKkWAWU7VnziVFFF48zWGpxWaS-cgwpDsKQ-TsJHVWCONynoT5OsyleFV59dd4lW4Rj5dedbbizQVFaYjzv2Jtg3Y/s1600-h/image%25255B3%25255D.png"><span style="font-family: Verdana;"><img alt="image" border="0" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjX3YYq8l7vDAO1PmyDpggeO2L5ZKLQSzrP7J2Y5X84g5a8WJTP8sGlof8oUFYopCaMNUB0Rmmyv1qJA0mP9pYGSBUnsz7RIFj8AkQGdsilwfRHL59DmuzjQAXRXJxdLBY_opptSU8HeoV0//?imgmax=800" style="background-image: none; border-color: -moz-use-text-color; border-style: none; border-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="488" /></span></a></span> <br />
<br />
<span style="font-family: Verdana; font-size: small;">2) Create the BIP extension code in Java, I used Tim Dexter’s example as a starting point. I plan on sharing the custom code once I get a chance to clean it up. </span> <br />
<span style="font-family: Verdana; font-size: small;">Creating Gantt chart using JFreeChart is very straightforward and there are several examples on the web, other more sophisticated types of plots (box plots etc…) require more work. The only difficulty with JFreeChart is that it doesn’t support XML dataset as input, there are ways around that limitation</span> <br />
<span style="font-family: Verdana; font-size: small;">You’ll need the following JAR files available on the web:</span> <br />
<span style="font-family: Verdana; font-size: small;">· jfreechart-1.0.4.jar</span> <br />
<span style="font-family: Verdana; font-size: small;">· jcommon-1.0.8.jar</span> <br />
<span style="font-family: Verdana; font-size: small;">· Commons-code-1.5.jar</span> <br />
<span style="font-family: Verdana; font-size: small;">The resulting JAR file will have to be copied to the location expected by Weblogic, on my PC it is:</span> <br />
<span style="font-family: Verdana; font-size: small;">C:\fusion\user_projects\domains\bifoundation_domain\lib</span><br />
<span style="font-family: Verdana; font-size: small;"> </span><span style="font-size: small;"> </span><br />
<span style="font-size: small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisZnEFQJISMxwyb9y_995S7zqAQ8CmnUNmJ8EZ-bIcsAEbY_-T92RofEcdsDAkQx-j6YUGZaaRWSq9u8MoEBJ88vvwunfQ_ciVNoGtyZsz4b3XwVwCV6gL3X_QBDIQp-UAP7nFU3QndTb8/s1600-h/image%25255B11%25255D.png"><span style="font-family: Verdana;"><img alt="image" border="0" height="221" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_rKi8KEb-PGrbrtfgAlt_95QR30tXt2idNlC-dxQtpL5DVcM_BFW2Lh6jm7WBi_OQPkVM65ykAtnO7QkBQapQV2c4Cb-T0gCjMOxuSrBQrIAzz6Kul8uvNPXRb5cj0nSL3ZBLT_5ULg1o//?imgmax=800" style="background-image: none; border-color: -moz-use-text-color; border-style: none; border-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="525" /></span></a></span> <br />
<br />
<span style="font-family: Verdana; font-size: small;">3) Create the BIP template, I used Template builder to create an RTF template with 3 fields</span><br />
<span style="font-family: Verdana; font-size: small;"> </span><span style="font-size: small;"> </span><br />
<span style="font-size: small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZO3aq7G3pUVkGKSf44dg5zKFEZzNkzJED0eT26UdNmIDq7eXGtxdcczcq57K7hRznL-1FlKVWYwUVsHIvqK_h_bcIzHSdLhFJK7YGV_8zck_JGacFndbgZg5GVxq3MBHwPp41ofldR6W1/s1600-h/image%25255B20%25255D.png"><span style="font-family: Verdana;"><img alt="image" border="0" height="159" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjI4GcWkfYbr5tw9K1PYYoheE_iIP_aMaH2pwPgbq-xUrds2hbYRRVpMW8MjE2UFEi_UhQjVx6fpvLzEm7XubuzPbeVe1fvINcwpXmlkGW0KplBv4nmNzYdOK_skAJPNKGokWCs5H-qI5He//?imgmax=800" style="background-image: none; border-color: -moz-use-text-color; border-style: none; border-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="458" /></span></a></span> <br />
<br />
<span style="font-family: Verdana; font-size: small;"><b>Namespace:</b> </span> <br />
<span style="font-family: Verdana; font-size: small;"><b>Create Gantt Chart:</b> is the call to the custom Java code. My custom code call is:</span> <br />
<span style="font-family: Verdana; font-size: small;"></span> <br />
<span style="font-family: Verdana; font-size: small;">I am basically feeding the XML data from BI-Publisher to the JFREECHART API as well as the XML tags</span> <br />
<span style="font-family: Verdana; font-size: small;"><b>Display Gantt Chart: </b>renders the resulting image (Gantt Chart) from JFreeChart </span> <br />
<span style="font-family: Verdana; font-size: small;"><fo:instream-foreign-object content-type="image/jpg"> </fo:instream-foreign-object>;</span> <br />
<br />
<span style="font-family: Verdana; font-size: small;">5) Change the “Disable External References” flag to “FALSE” (it is TRUE by default) in BI-Publisher</span><br />
<span style="font-family: Verdana; font-size: small;"> </span><span style="font-size: small;"> </span><br />
<span style="font-size: small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjh0X6Jq54Ij8kw384CtxZNC-r4qameQJWJp6bJrwjy06DVRPjZkPsoTXdqV1WU3i6DMoKLT3hi6x1ez4KLZHoCsqVkWvgRqaCUBzAFhBf6_IR-fXu7ClTajgh5Ml0fVPrxkOd9zqrD4ZWf/s1600-h/image%25255B21%25255D.png"><span style="font-family: Verdana;"><img alt="image" border="0" height="288" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgT9HT_G4IamlutPIBy0od7EgLJxDSSqzogKg7yzo2AWOUADnOq3fYZOC0bemg-pMHs2YZ1gckPYENouWua_RbAXxqsfSxlc9aERQzPayKwpGTNvtgHi6cca41_kf07x6eVm1a3uEnfeQQp//?imgmax=800" style="background-image: none; border-color: -moz-use-text-color; border-style: none; border-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="420" /></span></a></span> <br />
<br />
<span style="font-family: Verdana; font-size: small;">6) Upload your RTF template, bounce the services and voila!</span><br />
<span style="font-family: Verdana; font-size: small;"> </span><span style="font-size: small;"> </span><br />
<span style="font-size: small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjm_SJkg0k45HOZgVg4oE47lZ1890VdADJdmxtbuSzUT7be-95r92N6n1GYHWcBwXuv3tJLCrq0nOrKcEv-Rx9c7JgpPNCYO3a-92NriqaRBhbOmf2TIQZVLjg74c-v0OXcZNCesbLL1fmw/s1600-h/image%25255B25%25255D.png"><span style="font-family: Verdana;"><img alt="image" border="0" height="351" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIQ-QEsuBRtwpvafSoBe0rPyEgJe9-WcXSL1mVBVW8YVRYpKALMYIcIhPvJss2t2KPS9VrxiroWnlgt7gRF8WQDg3NnFpXR3Kuqsr5LTg72zFH1yE1jqUiSOFRKFXZ7ntGbV92F1-Oitk-//?imgmax=800" style="background-image: none; border-color: -moz-use-text-color; border-style: none; border-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="408" /></span></a></span> <br />
<span style="font-family: Verdana; font-size: small;">Pretty basic but the look and feel of this can be greatly improved by tweaking the JFreeChart API.</span> <br />
<span style="font-family: Verdana; font-size: small;">a+</span> <br />
<span style="font-size: small;"> </span><span style="font-size: small;"> </span><span style="font-size: small;"> </span><span style="font-size: small;"> </span><span style="font-size: small;"> </span><span style="font-family: Verdana; font-size: small;">Fiston</span><br />
<span style="font-size: small;"> </span><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-38911373034252641182012-09-12T19:55:00.001-07:002012-09-12T19:55:48.356-07:00OBIEE to BIP trick<span style="font-family: Arial Narrow;">I am back to working with BI-Publisher after a hiatus of a few years and I am loving 11g: it is such a big jump from 10g! Today I needed to “remember” how to navigate from an “Answers” (or “Analysis” if you like the new terminology better) request to a BIP report while preserving the context: basically how to pass parameters. Following is how I went about it, hopefully it will be useful to some of you.</span><br />
<span style="font-family: Arial Narrow;">- First create a BIP report with a parameter, let’s call it P_DEPT. For illustration purposes we’ll use the HR schema to build a simple data model.</span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiN-6SfmQKIxtFyWYZhKF56HQW4_mUf96KVyKsp0uyAqfrufolCyD2m1SOZDQPSh0Nr260Zv-hRbwXrYr-iZEqT519OlGwQPjzA46eoSneAHURW_wqqfAVwHX81rcBpPEuK9mvQrl4JFbt5/s1600-h/pic1%25255B6%25255D.png"><span style="font-family: Arial Narrow;"><img alt="pic1" border="0" height="333" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3Ep2wmbJTjIh7UqLRgfSRbiCwLhGCWX1BWT6CbvVFWLfSo8xQlnMlVpkibDJN61INbTtOY4bGVRx071dgg5cmUiE3Jm12aS0CA0PLyEVggGEGL1q8cQ41o_tx9GZ42vNhhDjxfEyd-Uch//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: block; float: none; margin-left: auto; margin-right: auto; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="pic1" width="388" /></span></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmK208LkFEBvd9hMu5IBlOiPA4nJnNjfV_J_ArhaZa5E6-Fm92yyNbAidCklhXUkiRPILUouEZN1il1-Sw14jk6iAmca9645XA1aeH2sF9slBZQBymmfKVUcpbcp6WrTe-Sy_k9sWgkRSs/s1600-h/pic2%25255B4%25255D.png"><span style="font-family: Arial Narrow;"><img alt="pic2" border="0" height="184" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcQ-EIR34IcGXCoStu_ZR2Bp5aV-hhdhqH97x5nJ5onZOXMvRnxtLsbH9wcHUACX08IAady2ONULM_iZpnyIH_0ZCTKGuLOqnm7HDFMwWp4__6oq838fz7h8T0QpHopBI5MYtUKZMpPN_h//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: block; float: none; margin-left: auto; margin-right: auto; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="pic2" width="501" /></span></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2SK9Zetd2mUu4BO6-_YlLfnqcRgOSZuvaMAVNSCPPKLiVKtchBO7RCfuXffb8-ucZAWtqVzNAyr4qkGPjVhBTGRTT0MDr9QZBN8piXzOCpvzXTZxZ5XSDAtkO2rj8XPDLXzl9zRYxbVdZ/s1600-h/pic3%25255B4%25255D.png"><span style="font-family: Arial Narrow;"><img alt="pic3" border="0" height="244" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqg_7KTvYHRKW5XMJJn6S7W95K1CAnQ_PXfmWdWz5viTmBE7F_urNshqJkcVTr3m1octDTmw9x0nZaX6TaZTTYEHJ2GIsjoip7JRnyvByHTxCIDkMTSRwXweB6z8th4IPeUSGsTjD47G46//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: block; float: none; margin-left: auto; margin-right: auto; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="pic3" width="506" /></span></a><br />
<span style="font-family: Arial Narrow;">- Create a simple template to show a table with DEPARTMENT_NAME and DEPARTMENT_ID</span><br />
<span style="font-family: Arial Narrow;">- Navigate to the BIP report properties and enable the radio button “Allow Sharing Report Link”</span><br />
<span style="font-family: Arial Narrow;">- Run the report and get the Report Link by navigating to the “Shared Report Link”</span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQefdFyDsFXmGPPg7zCHzNeMiT_R0lbmlpsYHPyayTU0_M06sId8u2gXOalTgZyrrF9S5jpxEHAqh4n1kLYMIA9-pUvVuVSTJAGycnDr7tllYNR7bpHpVh6pYfymBpPe6Ows8EmQ8nFXLN/s1600-h/pic6%25255B8%25255D.png"><span style="font-family: Arial Narrow;"><img alt="pic6" border="0" height="276" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhyJm_uqKv9yrUmFFS6mNrHA3ZQSGV3Sa6ugsqP5_CMsJCchwf4yuc9pfNkHmrZIUIhpcQ3n3VGuw05wH-19uf1bznIkmgVXJI-eYtb8BxYnl9dDpkK9yZungsRT1JBM2GfqIQSdlaZcopt//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: block; float: none; margin-left: auto; margin-right: auto; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="pic6" width="254" /></span></a><br />
<br />
<span style="font-family: Arial Narrow;">- We’ve got an OBIEE Answers request with 2 fields: DEPARTMENT_NAME and DEPARTMENT_ID, clicking on a particular DEPARTMENT_ID should take us to the BIP report above filtered for the selected department.</span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhyNodYxZi9MUrehiKdiSzEsmyTZr_sNmW9k03dpvscyU29h0twwLHjsNC33P8TFVF8P4QL7OYI8N8sLno-0YhDY7FoLgzQjj6HK0kU155iKvLu8DQNdxA5w1_yyH_pUyZrmAlypK_fGduS/s1600-h/pic8%25255B4%25255D.png"><span style="font-family: Arial Narrow;"><img alt="pic8" border="0" height="268" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3U2gM66gjsIim8z1WtZUTq1beq_8inXKJ-sT9qHhEEk9lR1fLVI1csHEmYOzd6xCZmBA7Zw02fzhsGHDnAU4FLG2A9jhGrkMrGDBoKfsyKoDaOGPcqUhnmLxTZpR95oulxpqaj8DjMwU0//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: block; float: none; margin-left: auto; margin-right: auto; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="pic8" width="194" /></span></a><br />
<span style="font-family: Arial Narrow;">7) Now the trick: create an Action Link (Navigate to a Web Page) for the Department ID column value:</span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7lZdBj-DRzzYf2p3_vWPH_UkLxdKwLLF7uIJpjlg0jetptjDB-GSO-fngAQvHnGLmRBEtA_Tu6td90EBUiVaX95bDtFL3knd7gyeHVejzle0HVfi-OXDAigsbgPFaSwBcFLQF25sUACHI/s1600-h/pic9%25255B6%25255D.png"><span style="font-family: Arial Narrow;"><img alt="pic9" border="0" height="207" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4iHb_6_IV-84HV15nrRsZxI-D8cte9R5u5usTgtyMbsGAsGwBYRvizVyBZYmXcq_9xXw4MwaXuN8l_SdHkhKMP7D_fgIwbPema9VZrlt5Kq45Yy7EeK_PCUrqZvayq4Ozuz2U3IndaUc0//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: block; float: none; margin-left: auto; margin-right: auto; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="pic9" width="244" /></span></a><br />
<span style="font-family: Arial Narrow;">- Create a parameter P_DEPT (similar to the BIP report parameter name)</span><br />
<span style="font-family: Arial Narrow;"> Name: P_DEPT</span><br />
<span style="font-family: Arial Narrow;"> Value: “Column Value” then select “DEPARTMENT_ID”</span><br />
<span style="font-family: Arial Narrow;"> Hidden field: checked</span><br />
<span style="font-family: Arial Narrow;">- Modify the BIP “Shared Report Link” to pass in the P_DEPT parameter: The text "_paramsP_DEPT":"*" is changed to<b> "_paramsP_DEPT":@{P_DEPT}</b></span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7Mq1sQetIuIzglgtonwOXqlk_GrcIrJpJdJEqymzEYpqS7iP_GbCGTZPTU3wiWtQH32bympgI36sAp3SoR59oDIoj9KKaTq7q_bGpJ2xhu-_dj2ZGzqjOF4uDh0PkkubyGCAwLdncX_88/s1600-h/pic12%25255B3%25255D.png"><span style="font-family: Arial Narrow;"><img alt="pic12" border="0" height="185" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBZ5KIZWovtYv_m6CYXWTWpX1MVbINXpmU_x3BkwdauvRNCnrblr-tN6B6_24DYJShB2xHRhHg6M4xL4Ktt40LtHjSb_CEu7DZ1fQntZRDS7SXUqRpiPo7LG9g-rlGEsmHzYM0A_CNm3jD//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: block; float: none; margin-left: auto; margin-right: auto; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="pic12" width="280" /></span></a><br />
<span style="font-family: Arial Narrow;"></span><br />
<span style="font-family: Arial Narrow;">- Clicking on Department ID 70 takes us to the BIP report with the filter Department ID =70 applied.</span><br />
<span style="font-family: Arial Narrow;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgk6uPAgzkKOoTLt0ncB9En-ReI_7LrJcm8exiIE8K7qqsDr8OGmnzYHiZ23ztL12RnPPavoI_nt9mxhheFx31F-zAQeJ89IkyaE7cnjc7GjGezfmM7TyHe4TTVdHDWTA0H4sJoT4V_XZwy/s1600-h/pic13%25255B3%25255D.png"><img alt="pic13" border="0" height="166" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7uEqjFFSomT-7ng3YKxpm5jIHQbwV13jDXovtb8_ihrG42kg2Y0Bf0Q2pPJ5Dh8HsTD0vlllFa0It4PmX1a39R5XDFn8h_zg-XUQt-h6pQGL-ICy3ybWkj0wJcsaE2azpVT4DtHKbSTIo//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: block; float: none; margin-left: auto; margin-right: auto; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="pic13" width="328" /></a></span><br />
<br />
<br />
<span style="font-family: Arial Narrow;">Fiston </span><br />
<span style="font-family: Arial Narrow;">a+</span>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-88272460390827497662012-05-29T06:41:00.001-07:002012-05-29T06:41:56.298-07:00OBIEE reports to Webcenter Content (UCM)<br />
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;">I was asked by a customer to work on a POC to show how an
end-user can run an OBIEE 11g analysis and check it in automatically into Webcenter Content (UCM), this solution doesn't involve BPEL processes. In
case you’re not familiar, Webcenter content (WCC) is an enterprise grade content
management solution from Oracle. It is also extensible by using the many Java APIs that are available out of the box.</span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;">With the introduction of the action framework in OBIEE 11g there are endless possibilities to integrate OBIEE with other applications. For
this POC we leveraged the action framework to call a WCC API called
CHECKIN_UNIVERSAL via the RDIC
(Remote IntraDoc Client) a light weight communication protocol for the Content
server. I took the opportunity of the long Memorial Day week end to put something together. </span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;">A report can be checked into the content management solution either directy by calling the action or at the completion of an iBot/agent. Following are few screenshots to illustrate the functionality. </span><span style="font-family: Verdana, sans-serif;">When I get a chance I will document the step by step approach for the implementation.</span><span style="font-family: Verdana, sans-serif;"> </span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
</div>
<ul>
<li><span style="font-family: Verdana, sans-serif;">log into OBIEE and select the action "UCM"</span></li>
</ul>
<br />
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9BgHnyA_vLAzkUGYsn2D-g2bK0DfW59V3qiYBzQvfmAJ-XK3-AMYLEL92tyxQlal7iTFVCIY3ZQVX_TabsSvn6mPOutthPwzdg705QA-CUzGcMDQcWHUUXGpk3SqjqLkLPw2cXg7GgKa_/s1600/s1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9BgHnyA_vLAzkUGYsn2D-g2bK0DfW59V3qiYBzQvfmAJ-XK3-AMYLEL92tyxQlal7iTFVCIY3ZQVX_TabsSvn6mPOutthPwzdg705QA-CUzGcMDQcWHUUXGpk3SqjqLkLPw2cXg7GgKa_/s1600/s1.png" /></a></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
</div>
<ul>
<li><span style="font-family: Verdana, sans-serif;">Enter the parameters: Title, Document Type, The report to be checked into UCM </span></li>
</ul>
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwCUHCr84pgNtNV3VfcaEc9IPpJP4xUhuabAaxYsROW583bIncqf1iVqeI7uZLKuELFk-Z5cF4pGlw6UcD-XiQGEgeqyNEbGbMW7579eeA2006PQhC0CC1jfVDXHgsvci2h6l5nNltindx/s1600/s4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="140" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwCUHCr84pgNtNV3VfcaEc9IPpJP4xUhuabAaxYsROW583bIncqf1iVqeI7uZLKuELFk-Z5cF4pGlw6UcD-XiQGEgeqyNEbGbMW7579eeA2006PQhC0CC1jfVDXHgsvci2h6l5nNltindx/s320/s4.png" width="320" /></a></div>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Verdana, sans-serif;">Here are the parameters for the action</span></div>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhH5YWD8wUhbMCeHLy6cpyOOG9xE2laTsY1gmHzf6h_RkEkMBCcIdtTRIluKJzOWX65EToE36DWgxIpWtzTyvCKGYNJWjH1k21zWrZ8MVn0Lqgpks7oe4cyqDxbv36BdG8Q5kL-CTrio1Lz/s1600/s11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhH5YWD8wUhbMCeHLy6cpyOOG9xE2laTsY1gmHzf6h_RkEkMBCcIdtTRIluKJzOWX65EToE36DWgxIpWtzTyvCKGYNJWjH1k21zWrZ8MVn0Lqgpks7oe4cyqDxbv36BdG8Q5kL-CTrio1Lz/s640/s11.png" width="640" /></a></div>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Verdana, sans-serif;">Once the </span><span style="font-family: Verdana, sans-serif;">success message is displayed, the report is available in WCC. Log into WCC and do a search </span></div>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJUMxxI7WxvknNBZlw6B_FOgYeJWXE4qByBoHnvEWzLFMd3K445XxPi_B67YgpxgrqC6okcizNEAFe2e6XZZm4n725kwEr1-OIM4n26HwLVA6Cjib0lSnYve4K24lOIdZRuyX3QzN6fEnp/s1600/s9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="307" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJUMxxI7WxvknNBZlw6B_FOgYeJWXE4qByBoHnvEWzLFMd3K445XxPi_B67YgpxgrqC6okcizNEAFe2e6XZZm4n725kwEr1-OIM4n26HwLVA6Cjib0lSnYve4K24lOIdZRuyX3QzN6fEnp/s320/s9.png" width="320" /></a></div>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Verdana, sans-serif;">and voila, our report is checked in!</span></div>
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9_zS3wP9JPR7lShW2KMJdf3uKTnIVoqJnl_EiX7t0kfn-ZIMKI9zT60uoLEE3gNaMRybq-pVjE3Rj2Id4V3lE5m_JIN30axBS-O4xAD5L62usOuwQRMZxT3-F6bZrJXSS_6kwZPSQRK63/s1600/s6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="271" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9_zS3wP9JPR7lShW2KMJdf3uKTnIVoqJnl_EiX7t0kfn-ZIMKI9zT60uoLEE3gNaMRybq-pVjE3Rj2Id4V3lE5m_JIN30axBS-O4xAD5L62usOuwQRMZxT3-F6bZrJXSS_6kwZPSQRK63/s320/s6.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Verdana, sans-serif;">The action can also be invoked from an agent which is pretty cool</span></div>
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAEtjErHH8IZe3t1usajqogD48xNoD1KAmi8JajgOIG_XSAjCwyFqOipZE_fRdLg6pA_slZBZ3zQwuLfnP5qU-m4PHfmImLHCPDyCdY_XtY5EKsnZ9DRy3cb7SMjXCLuNB223zzS7ROBKe/s1600/s12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="264" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAEtjErHH8IZe3t1usajqogD48xNoD1KAmi8JajgOIG_XSAjCwyFqOipZE_fRdLg6pA_slZBZ3zQwuLfnP5qU-m4PHfmImLHCPDyCdY_XtY5EKsnZ9DRy3cb7SMjXCLuNB223zzS7ROBKe/s320/s12.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2HvI2Od2w-QgsvoxGk_pcfPt03I-a4GpNuMIaXnJlEVM7VqmJvzPU4hLNw7XDh3p78Tiy-KcnKKiQ6-0fkLEqAzDSq5WviPBJyBdmtjFBfbvlg92S4e9f_9EpsqVrz2QH5klwxFlBNrRO/s1600/s13.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="281" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2HvI2Od2w-QgsvoxGk_pcfPt03I-a4GpNuMIaXnJlEVM7VqmJvzPU4hLNw7XDh3p78Tiy-KcnKKiQ6-0fkLEqAzDSq5WviPBJyBdmtjFBfbvlg92S4e9f_9EpsqVrz2QH5klwxFlBNrRO/s400/s13.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
a+</div>
<div class="separator" style="clear: both; text-align: left;">
Fiston</div>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<br />
<div class="MsoNormal">
<o:p></o:p></div>Unknownnoreply@blogger.comNew York, NY, USA40.7143528 -74.005973140.5217853 -74.3218301 40.9069203 -73.690116100000012tag:blogger.com,1999:blog-8879294908838500170.post-12845326716278260732012-05-14T05:50:00.003-07:002012-05-14T06:37:32.602-07:00OBIEE 11.1.1.6.2 (patch 13884769)<span style="font-family: Verdana, sans-serif; font-size: x-small;">Patch 13884769 was released yesterday. </span><br />
<br />
<pre><span style="font-family: 'Courier New', Courier, monospace; font-size: xx-small;">Bugs Fixed By This Patch:
-------------------------------------------------------------------------------------------------------------------------------
13529697: METADATA DICTIONARY NOT PROPERLY GENERATED WITH HYPHENS IN NAMES
13902810: CAN'T CREATE EXPRESSIONS IN RPD WITH COLUMN FROM ESSBASE - INVALID EXPRESSION
13705487: HIERARCHY OBJECTS ARE MISSING AFTER MERGING RPDS
9665267: COMPARE RPD AND PATCH GENERATION
12977729: HIERARCHICAL COL DRILLING ON MORE THAN ONE PAGE OF RESULTS LOSES FOCUS ON DRILL
13688544: 'CASE WHEN' CHANGES TO 'CASEWHEN' IN XML AND CAUSES ERROR WHEN SET XML
13523548: ERROR OUT WHEN USING MULTIPLE DOUBLE COLUMNS IN SAVED FILTERS
13098323: AN ARITHMETIC OPERATION IS BEING CARRIED OUT ON A NON-NUMERIC TYPE
13350175: ADDING FILTER TO DIFFERENT LEVELS OF A HIERARCHY GETS IGNORED IN MDX
13511930: NEW COLUMN CREATED BASED ON TWO DIFFERENT DIMENSIONS RETURNS INCORRECT RESUTLS
13522060: RPD SESSION VARIABLE UNABLE TO IDENTIFY THE DYNAMIC SCHEMA NAMES FOR OLAP
13542805: BAD CACHE ENTRY BEING GENERATED
13626491: CONSISTENCY CHECK UPDATE FOR FACT JOINS DIRECTLY WITH A NON LEAF TABLE</span><span style="font-size: x-small;">
</span><span style="font-family: Times, 'Times New Roman', serif; font-size: xx-small;">
</span></pre>
<pre><span style="font-size: xx-small;">Additional patches are also needed: </span></pre>
<pre><span style="font-size: xx-small;">* 13932572</span></pre>
<pre><span style="font-size: xx-small;">* 13887566
* 13926409
* 13892934
* 13916045
* 13916045
* 13884769
* 13794002</span></pre>
<pre><span style="font-family: Verdana, sans-serif; font-size: x-small;">Following is a compilation of the bugs that I cam across for the related patches for reference, an </span></pre>
<pre><span style="font-family: Verdana, sans-serif; font-size: x-small;">"official" list will be published soon from Support.</span></pre>
<pre><span style="font-family: 'Courier New', Courier, monospace; font-size: xx-small;">--------------------------------------------------------------------------
Patch 13932572: Patch 11.1.1.6.2 Oracle Business Intelligence Installer
---------------------------------------------------------------------------
13560245: BIDOMAIN/CONFIG/JDBC NOT FOUND.
13504454: BLK - BIINSTANCE COPYCONFIG FAILURE ESSBASE MAXL LOGIN IS FAILING
13510938: NEED OFFICIAL WAY TO INVOKE _CONFIGURERPD
13628293: EMPTY PROCUREMENT DASHBOARD IN RC4
13565722: BLK: BI T2P PASTECONFIG ERRORED OUT WITH UNABLE TO PARSE JMS_WEBLOGIC_JNDI_URL
13589944: BI T2P - PASTECONFIG INSTANCE IS FAILING WITH JAVA.LANG.UNSATISFIEDLINKERROR
13619973: INCLUDE ESSSERVER HOST NAME IN THE MOVEPLAN
13683204: STRESS: FA: CRM ERROR RESPONSE[NQSERROR: 43082] ILLEGAL OPERATION ATTEMPTED CLOSED
13724975: RUP2 AIX HCM STARTERDB POSTCONFIGURE FAILED
13779029: BI T2P BI RPD PLUGIN OPERATION ERROR WHILE LOADING SHARED LIBRARIES LIBARICU23
13687239: RUP2_RC4 BI DOMAIN - BI ANALYTICS DATASOURCE TEST FAILS
13780076: USE BIPROV PROPERTIES FROM 13694505
13404296: BI PROVISIONING FACADE MUST TRIM RPD IN INSTANCE FOR SELECTED FA OFFERINGS
13485655: T2P ERROR MSG EXECUTING WLST SCRIPT APPEARS DURING BIINSTANCE PASTECONFIG
13896014: RPDTRIM INCORRECT PROPERTY BIPROV.BI-HOME.DIR IN BI-CONTENT.XML FILE
13896152: TRIMRPD NOT ABLE TO CREATE BIPROJECTS.TXT BASED ON FAOFFERING LIST BAD XPATH ERR
13896209: TRIMRPD RELATIVE BI ORACLE HOME LOCATION PASSED TO SCRIPTS DURING RPDTRIM
13898786: TRIMRPD PLEASE MASK THE RPD PASSWORD WHICH IS LOGGED DURING _TRIMRPDTARGET EXEC
13910554: MISSING CONNECTION PROPERTIES IN OBIEE RPD
13926479: TRIMRPD FOR WINDOWS THE PROPS FILE SHOULD INCLUDE FORWARD SLASH IN DIR PATHS
---------------------------------------------------------------------------------
Patch 13887566: Patch 11.1.1.6.2 Oracle Real Time Decisions
----------------------------------------------------------------------------------
13703826: RTD Causes Bi_Server1 To Start Takes Long Right After Upgrade To 11.1.1.6.0
13240778: Qa- Access- Ere- Rgrn- Error Accessing Lov Via Key; Can't Select Via Key
9157691: Server Need To Respond When The Timeout Expires, Not Wait Till End Of Request
13360752: Unable To Load All Extension Columns For Customer In Rtd Studio
13567294: Removed 1St Value In Rule Becomes Nan
13472560: Qa-Access-High Contrast Setting Appears Cluttered, Some Items Not Visible
13723256: Rup2- Error While Accessing Oracle Rtd After Rup2 Patching
13537093: Internal Server Error Shows When Click Print At Choice Group>Analysis>Quality
13779138: Rule Editor Does Not Display Date In Operand
13539353: Internal Error(Npe) For Entity Statistic
13780656: New Studio Help Files For 11.1.1.6.2
13795529: RTD Rule Editor Error-Cannot Move Focus To The Control
13408870: Qa-Sdconfig 3X Values Copied To 11G But Not Used There
13409526: Qa-Update Doc Copyrtddata_Readme.Txt For Stop Start 11G
13506987: Copyright Information Needs To Be Extended To 2012
13347251: Qa-Unable To See Ere In Dynamic Page In Safari Chrome
13805360: Attribute Translations Not Seen In Adf Rules Editor
13816544: Re Error When Selecting Double Without Decimal
-------------------------------------------------------------------------------------
Patch 13926409: Patch 11.1.1.6.2 Oracle Business Intelligence Publisher
---------------------------------------------------------------------------------
11906714: QA:TIMEZONE NOT IN SYNC IN JOB MANAGER - JOB HIISTORY
12312461: NLS: MB DATA GARBLED IN JOB HISTORY USING SQL SERVER
12645567: NLS: WRONG WEEK OF YEAR FOR ORACLE DATE FORMAT CONTAINING WW
12825409: INTERACTIVE VIEWER CONDITIONAL FORMATTING REPORT FAILS IN INTERACTIVE VIEWER
13028918: CPU Bug
13341249: BACKGROUND ON SCHEDULED REPORT DOES NOT PRINT
13371841: QA: ACTIONS DROPDOWN NOT SHOW CORRECT OPTION (NON ADMIN USERS)
13445281: NLSHOT: PREVIOUS 11G VERSION XLF FOR RTF TEMPLATE CAN'T WORK WELL ON 11.1.1.6
13449368: DTE FARM MAIN NIGHTLY: WEBPAGE ERROR WHEN EDIT DATA MODEL IN BIP
13473493: XMLP TRANSLATION ISSUE OF MILLION (ENG) TO MILLIONES (SPANISH)
---------------------------------------------------------------------------------
Patch 13884769: Patch 11.1.1.6.2 Oracle Business Intelligence
---------------------------------------------------------------------------------
10167311: ADD TEST CASES FOR MDSXUDML GENERATOR AND PARSER
10199188: CHARTS X AXIS LABEL IS BLURRED AT 45/60 ANGLE
10391144: WEIRD BEHAVIOUR OF FILE OPEN DIALOG ON WINDOWS 7 COMPUTER
10647655: COLUMN DATA FORMAT IS IGNORED ON WRITEBACK
11810127: ADMINTOOL TESTS FAIL: EXTERNALIZATION
12411977: TERADATA RANK() IS NOT ALLOWED IN THE SUBQUERY
12426993: CHECKIN CONSISTENCY CHECK IS DIFFERENT FROM ADMINTOOL CONSISTENCY CHECK
12543094: EXPOSE THE SERVER ONLY CONSISTENCY CHECK IN THE ADMINTOOL UI
12612904: TOTAL PICKS VALUE IN FIRST ROW AND GIVES NOT A NUMBER WHEN AVERAGING NULL
12658173: SUMMARY ADVISOR STATS CACHE FILE NEEDS TO BE MORE ROBUST
------------------------------------------------------------------------------------------------------
Patch 13892934: Patch 11.1.1.6.2 Oracle Business Intelligence ADF Components
-------------------------------------------------------------------------------------------------------
13365954: ERROR WHILE OVERWRITING AN ANALYSIS VIA BI COMPOSER
13597290: 11.1.1.7.0 ESSBASE DATA CONTROL CODE IS PRINTING UNWANTED DEBUG MESSAGES
13733098: REPORTS AND ANALYTICS, CANNOT SAVE NEWLY CREATED REPORT
13858848: BIADFCOMPS - ANALYSIS CREATED USING COMBINE UNION IS NOT EDITABLE IN BI COMPOSER
--------------------------------------------------------------------------------------------------------
Patch 13916045: Patch 11.1.1.6.2 Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
-----------------------------------------------------------------------------------------------------
13552700: ORACLE.ESSBASE.EPM.JAPI_TEMPLATE SHOULD SET REQRD EPM PROPS IN SETDOMAINENV.SH
13631427: DTE: ESSBASE CANNOT CONNECT TO BI - BIFNDNEPM TXN
13614676: CONFIGURE ESSBASE JAVAMAXOUTLINES FOR BI PLATFORM
13785544: INCORRECT ALIASES ARE DISPLAYED IN THE FINANCIAL REPORTING MEMBER SELECTOR IN THE FINANCIAL REPORTING STUDIO AND IN WORKSPACE.
13785522: FINANCIAL REPORTING REPORTS WITH ADVANCED MEMBER SELECTION DO NOT COMPLETE.
13769394: FINANCIAL REPORTING REPORT FAILS WITH UNKNOWN MEMBER USED IN QUERY ERROR.
13741981: SELECTING THE EXCEL ICON FOR FINANCIAL REPORTING REPORTS, THE PREVIEW USER POINT OF VIEW DIALOG IS NOT DISPLAYED IN FIREFOX.
13512669: XMLSTREAMREADEREXCEPTION DISPLAYED IN BI STARTUP LOGS.
13427006: THE FINANCIAL REPORTING BATCH NAME AND DUPLICATE EDIT PROPERTIES SHOULD BE IN VALID FORMAT.
13089241: FINANCIAL REPORTING MAKES MULTIPLE API CALLS TO WEBCAT WHEN SAVING AN OBJECT.
11652873: FINANCIAL REPORTING ANNOTATION VIEW PANE HAS PERMISSION ISSUES FOR ANNOTATION ON TEXT OBJECT.
9211682: FAILED TO REGISTER THE FINANCIAL REPORTING WEB SERVICE CONFIG MBEANS.
13475602: OFFSET MEMBER WILL NOT SHOW ON THE RIGHT HAND SIDE OF MEMBER SELECTOR
13710417: NLS: MEDIUM DATE FORMAT FOR FR-CA SHOULD BE YYYY-MM-DD
13710429: NLS: MEDIUM DATE FORMAT FOR FR-CA SHOULD BE YYYY-MM-DD AT FLTER DIALOG
13712484: NLS: NEED TO SUPPORT FRENCH_CANADA IN RUP4
13509268: FUSIONGL: CHANGE THE DEFAULTS IN THE ALLCOAITON WIZARD TEMPLATE
13771676: ALLOCATION MEMBERS SELECTOR IS NOT EXAPNDING FOR DIMENSIONS WITH BIG NUMBER OF MEMBERS
12530876: PERFORMANCE OF FINANCIAL REPORTING REPORTS QUERYING ESSBASE APPLICATIONS WITH A LARGE NUMBER OF DYNAMIC CALCULATIONS MAY BE SLOWER.
12404364: ESSBASE READ ONLY ACCESS INSUFFICIENT PRIVILEGE WITH PROMPT
13250047: REMOTE ADM CAN'T GET ALL MEMBERS IN LARGE GRAINED INTERFACE
13686023: IN FINANCIAL REPORTING REPORTS, CHILD MEMBERS BECOME INVISIBLE IF THE SECURITY FILTER IS SET TO META READ ON PARENT MEMBER.
12765822: DMS LOGS LOTS OF ERRORS WHEN ESSBASESERVER1 IS DOWN
13806230: NULLPTR EXCEPTION WITH REGISTRYUPDATELISTENER (BIFNDNEPM PREFLIGHT)
13802437: TRACKING BUG FOR 11.1.2.2.001 PUSH TO BI 11.1.1.6.2
13801537: TRACKING BUG FOR 11.1.2.2.001 PUSH TO BI 11.1.1.6.2
13801547: TRACKING BUG FOR 11.1.2.2.001 PUSH TO BI 11.1.1.6.2
13684571: INCREASE THE DEFAULT FOR JAVAMAXOUTLINES
10623654: THE DATE AND TIME IS NOT LOCALIZED IN FINANCIAL REPORTING SCHEDULED BATCHES DETAIL INFORMATION.
13861897: DURING THE LOGIN TIME THE ROLE OF THE GROUP BICONSUMERS IS NOT RETURNED BACK
13857776: ESSOTLDELETEOBJECT CRASHED DURING SMARTLIST TEST ON LINUX64 AND WINDOWS32
11735177: REHOSTING TOOL IS NOT TRANSFERRING PROPER USERNAME IN PARTITION DEFINITION
13826968: SMBUARDESS2.SH AND SMBUARDMXL2.SH CAUSED .XCP FILE INTERMITTENTLY ON HPUX64
13874086: Fix for backward compatabillity of getdatabaseinfo
13968116: RUP3 ST5 CDRM: ESS FAILS TO CONNECT TO ESSBASE
13967992: RUP3 ST3/ST5 CDRM: CANNOT CONNECT TO ESSBASE SERVER USING REGISTRY
13964528: RUP3ST5CDRM / PROJECTS: OLAP.SERVER.NETCONNECTRETRY ISSUE
13963796: RUP3 ST3C: ESS BASE SERVER IS DOWN LS BOUNCE
------------------------------------------------------------------------------------------------------
Patch 13794002: Patch 11.1.1.6.2 Oracle Business Intelligence Platform Client Installer
-----------------------------------------------------------------------------------------------
13794002 BISHIPHOME 11.1.1.6.2 CUMULATIVE PATCH 1</span><span style="font-family: Verdana, sans-serif; font-size: x-small;">
</span></pre>
<div>
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<pre><span style="font-family: Verdana, sans-serif; font-size: x-small;">
</span></pre>Unknownnoreply@blogger.comChicago, IL, USA41.8781136 -87.629798241.6889521 -87.94565519999999 42.067275099999996 -87.3139412tag:blogger.com,1999:blog-8879294908838500170.post-5095992252409447682012-04-30T12:07:00.005-07:002012-04-30T12:07:59.935-07:00Change Password (cont.)<span style="font-family: Verdana, sans-serif; font-size: x-small;">I just noticed an interesting screen in BI-Publisher 11g (11.1.1.6) while looking at the screenshots in</span><br />
<h1 class="content_title" style="font-weight: normal;">
<a class="content_action_button" href="http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bip/bip11g/gettingstarted11116/gs.htm" id="contentb" target="_blank"><span style="font-family: Verdana, sans-serif; font-size: x-small;">Getting Started with Oracle BI Publisher 11.1.1.6.0</span></a></h1>
<span style="font-family: Verdana, sans-serif; font-size: x-small; font-weight: normal;">Using the "My Account" link, OBIEE 11g end-users can change their passwords without having to go through the not-so elegant approach documented in my previous blog entries.</span><span style="font-family: Verdana, sans-serif; font-size: x-small; font-weight: normal;">I might have missed this feature in 11.1.1.5, I remember seeing a screenshot in the help link, but the "Password" tab was missing in the app.</span><span style="font-family: Verdana, sans-serif; font-size: x-small; font-weight: normal;"> </span><br />
<div class="content_title" style="font-weight: normal;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">- Log into BIP : http://HOST:PORT/xmlpserver/</span></div>
<div class="content_title">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">- Select My Account</span><b><span style="font-size: small;"><br /></span></b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrF60s-P4RkZsK3cnlevR0luwGjIahWUeXgEzfPiBFOONGFL6-m9qI8_T0Q1AdWP-8X68jB0H6ahDdBHTj6lue4oCCyZX-Qnp2NrBZocStPtzZPET4sn2UVs7idjQRy3yZaDYDg-rLiNno/s1600/cp1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrF60s-P4RkZsK3cnlevR0luwGjIahWUeXgEzfPiBFOONGFL6-m9qI8_T0Q1AdWP-8X68jB0H6ahDdBHTj6lue4oCCyZX-Qnp2NrBZocStPtzZPET4sn2UVs7idjQRy3yZaDYDg-rLiNno/s1600/cp1.jpg" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFZzpOOKv4_kviPcU0S1mR5EtJW74uFJX7Kof44OhDTdmdL-y_WDQ7qIkjhuq3Oq84PTvYBnJpC70YhleHL7MUdvSLpiUP7-aMHo6k4k3PS7qDTVigtOVJOzHZ7LoMdSQLdjTERVbHKlsQ/s1600/cp2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="177" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFZzpOOKv4_kviPcU0S1mR5EtJW74uFJX7Kof44OhDTdmdL-y_WDQ7qIkjhuq3Oq84PTvYBnJpC70YhleHL7MUdvSLpiUP7-aMHo6k4k3PS7qDTVigtOVJOzHZ7LoMdSQLdjTERVbHKlsQ/s320/cp2.jpg" width="320" /></a></div>
a+<br />
FistonUnknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-41265723740521459222012-04-06T19:58:00.001-07:002012-04-06T19:58:23.989-07:00Change Password (cont.)<span style="font-family: Verdana, sans-serif; font-size: x-small;">We’ve already compiled our application, we need now to expose the Change Password method via web services. </span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Right Click on your main class and select “Create Web Service”</span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgdm_aGhJ6jzUFnUlei6ZjRm07oqbFEjTvT-pMPjH5ju0EnQ_8-SqJxnRFdUPnnHSnxig9FYhiQvZGrPl7BmNfVrrbAdby5E-v-tvClBqNoZ3CkGSoidi1vLXFQGyxHzm18-DJ5cj5K3Ok/s1600-h/p4%25255B3%25255D.jpg"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><img alt="p4" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyIaOVwgNz_b4nlYVGXCEPPawAnLIEaeCwPPK7EDnUR7yguoF95wFBgKxszBe_iszplZ9aJBYzv3zbDBLUy7J1iTeb2dgLeXKdwhZEWZ3L-NRF8dMRVfju__extT2JVmfd7bmWFFAcOVZ_//?imgmax=800" style="display: inline;" title="p4" width="171" /></span></a><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Select the default</span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDq40KJCtXqO3owlD62C2mxMMziaTfdLFOPyRMSX0pXSR-T0NLhUDPPTn9IcQ_NpLP9yWGFJMbqy9P_31xrOxbc2qtCxozoO_RaVML2jPpLGxxy-3i0S3c41Tfb9u1Stiw5EeDApl4KHvG/s1600-h/p5%25255B3%25255D.jpg"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><img alt="p5" border="0" height="217" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjX3BGq6AlBCTKRkLw4b1zU7LKlkMU7gRQv6aDnMD0bSpz2YsfQhc1byO9QzGS9DC72QP_6JQgVwi_YOyWPDNffmqjGO6h4V3k_3mYKaeLS0p8YzXOb42hyfBO8PNDNHicLkNxBeJVqeG9J//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p5" width="288" /></span></a><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Click Next</span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXygvI6sC4AUOGdqi__xFCf2R9DXuzLfWLEA_zwvMg5pu6dJPXI9wNR0St2d9H0K6YGYVxjDKU2JLsL_GTMqCKoGs7oI1XVrM6oVMAGhebLcMhXveezbDnuHfQIZtVMHzPe_uOTDJTMEcH/s1600-h/p6%25255B2%25255D.jpg"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><img alt="p6" border="0" height="184" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivXReQyB9SQ68H-1zbJR6kEFSoK2dG_ZE-LnWIWXpz3fK32veU6kwGIGKBCXkKNxqYJzVhh37c7vMU6vuF7_dBpjClUAd67onV7xy132bnJqJZbXL0Bk2BUTCYWiJlr9bx8XuczC-Wb40w//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p6" width="244" /></span></a><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Click Next twice and make sure that the changePassword is selectable and select Finish.</span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5-KAb6FqvAPW599AUtBeWCUOW_B9x-cDyc0A-10ZeFSGTZ47QoMKhiIey8atHd781dhveVLgMwNUXCxF_Ppk8TJee36mnI264u1rhGVvVTm5wB-BTubJsVCcb-_ZfU9AhiRUVlKsFLrrK/s1600-h/p7%25255B2%25255D.jpg"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><img alt="p7" border="0" height="184" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUBFt_9pnTw1cFHTEu1Lh7NvepmecMY7JAws2hM8jBQ2-IPXMAxw3qvzlQg3eJiGcgfKGqJMsct6Ar5Dm0aG2OjRAbi5w-c0tiX6wAkaKaDt-kI_Q8gxqMYPriQ9RS96SzKfUuAc22XC94//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p7" width="244" /></span></a><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Let’s now deploy the web service to the Weblogic server.</span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Right Click on the project and click deploy –>Application Server</span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhn7KFnMrK3jEOIdm1Kf4xd_0LzrUmqab12vZc1_QUY7xk09huUc1CD_6UhcIwMWH37qJu6gin7j8uoDhQyTOLHJl4qENvY1axc6ZSJSV1L_j9LdAHXmYP2cC3kLcqXeJf-kl-wXntjbIKi/s1600-h/p8%25255B2%25255D.jpg"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><img alt="p8" border="0" height="184" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrkoYdLJLYhW07zT1wi_xiZd0PIuHoxQvf6iqLVeB86RjNy_nSK9N5si2pBJbOP3ks3wk_3e5rMVA3ojEmRV7mojjkRnd7KXFdBqZqvSKG5uxJUV12Elqr4KtWs0ju3M08egdVrRvtu5hS//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p8" width="244" /></span></a><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Click + to add a connection to the Weblogic server</span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVNgneTQIq41w353ALsoTwtGa2UVWtXGox8q_gmGKoQGnmFDTF7AwJuvdATLeyZtOTYTWfiYEmvU1iuedbnot29aJW2uHKSy0ogHgEsNILIzv2QrT8kGeREOLdKnk8ouO5buHkvOeTLm8r/s1600-h/p9%25255B2%25255D.jpg"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><img alt="p9" border="0" height="184" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPEWXWURlhJnKclU5a1z6HsUF4mFUdzVmclMZ0Tx6TD7W7zWcsmc5Mt7xHlLLIrOkJ53r-uJe4xhK6VfMxNsbLrxT-iG4pZelXGCIpmek0v5DIUDx1cA4uKGuvHH27EHDcHF64CA7pVdgN//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p9" width="244" /></span></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjm58WtKwbHuCdSe4C5mluWKPsyhRGiniCpqFSdW7QtXfC1X_HHIkEHtZu-spBtPYWzD2SKxi3239CFRMJ3H34gDVHZlsYTkaWbbzxEwYCRsi0xvoBHWTtlGloWH5C0yAGOaATPK5YWJRQT/s1600-h/p10%25255B2%25255D.jpg"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><img alt="p10" border="0" height="184" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOmarK-a2gO_UC_-0ieufTwp92cgWZA6MNEwYDAAAFmPSo_kx_izVGY5fMxE1GTtHVo8AJyPvzB5BMdRl4TJntAUt1QUBb2VJ5-OJTycewVUQKZsovacnaRJUKj6nK69RfzqBSti5lxocN//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p10" width="244" /></span></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTT4i3gI0tMYrSK5KXI4OxGe-fv4KIJJOkNFaLjei_veaHOzyp_C3GMCIDH7iWUaE3cyW3V136VwMT9Hgh316ooB4KdTwtwjg_iHNaWA35rYtke6vNaSuxQc_cFlLj7A3iDu9xFVuHN2Iz/s1600-h/p11%25255B2%25255D.jpg"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><img alt="p11" border="0" height="184" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkoF3SKVoIvXODf7fJ1BzqchpP1BGxvO0xIeMfs196AfYPjlIinuU9GEf6ci647mIXx8omTkRmMYojPJ3T7KGBjwnxgweznh4c8O7tGBh4ye7RB1u33ZDd24Tnw0SCmh88NGgPAG_GAX0K//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p11" width="244" /></span></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_q0s4rvucevmhl9LpfqZowqd6YKbFF3IZ55hBmEXXiJFK_N59r7OVKAN5hgdEZ7TEkNyBgdYFzsbNwHrJm5cxeRsaltzhRDF0di1cOG2Ro6XZxGfOizLGtL0gPpyXDKrOn83rez7kV4Ew/s1600-h/p12%25255B2%25255D.jpg"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><img alt="p12" border="0" height="184" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJPxKUg1js3E9sqe9lNiHCckmQnMTXp2E2D_lfpehemAbyH69wwdvjxYNnEF3Jggi0KORoF456bkIac4sWakXYoLLh1DDEl29OYLtWN4VSk2nfdkcAl8AYPyoaEQTtFxVxRopBm6Zhblli//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p12" width="244" /></span></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguaZBbve5AWdE7mTxSgYb5u3NC5_o8f-nIkcUy1KyQv2NcBt0Yz42Takp0EBructT0Qko3X6v7FxkEXvng4J3f9qeyRxwGAo4Qr9EGz3ZMsUHuWfaEes7g0yAqQtflNETIHjuAQHEwguHu/s1600-h/p13%25255B5%25255D.jpg"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><img alt="p13" border="0" height="184" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCoxvhYkoiK417cfT2Bx_ZhuidlwQwnQ73hD1SNbiiXUpW30y3UGRSaxehoCjtZnvyRFViso4VSbh21rTPTTae_p3jKBwQlEo46hv5qTicCmJo9xVXs56VG05zHL9Kt29oczVpN9kZS1u7//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p13" width="244" /></span></a><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Log into Weblogic em and make sure that your web service was deployed successfully (you can also look at the JDEV log)</span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5TQ92yt1cFq2CTogaocc5ZQkGO00k0E2g1nD-5l-zhxln0B1MLvQMCtj0hcU4K6rJLzy_MjSfbT3s0w-18cruq1AXvndx-suttshw0TSeqWN1JayjMMbCGAwxdrwm8Rf8V_TFbnuxjRDN/s1600-h/p14%25255B2%25255D.jpg"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><img alt="p14" border="0" height="54" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAAjjfS-E6EUtrpm_PwvUjMkVtqASZWJvY3WxinzIuqm9lRVGSxxUqBGLKAFhynLHKhyphenhyphendQb5guG3bIAEv3e0oDSyvrp-B6x9m_bZNkcmumsv_pLo1fLiJXRHG7MmKW3hVV_dI0CEZRRp_e//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p14" width="244" /></span></a><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Login to the OBIEE portal and create a new action “Invoke Web Service” </span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVU4ByiIcys_7p733MQwWgJzLC7GHAe6QNRhyMCPQKAcHMsuTbSz89le4gPuc_H8T-e8D04NjZbpWhA86iHX5rtwraMRv4OqyttVVxaB6rLXO21lk2-lh4WtRsh7ys7ayiS-nRP9miUpRW/s1600-h/p16%25255B2%25255D.jpg"><img alt="p16" border="0" height="244" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRGNja3Y-a2kv7s0HgXsuuzQz8pUodzkb4TqmuRMSu2woGPiBAqY5rBe3v9XrUwNH0g-dztKZdmc1b1Se93YzW9L33Ld76HR_B72Hi1jhlqUfSg0XFJzdqK4ds20qachMu_wu4LczxHTvE//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p16" width="233" /></a> </span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">And plug in the WSDL </span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnFiSNw4E_McPz6E-_b7XlDDV6bS-lJdzAU7fFY5xD3gc4x77-YCMEZrA6tzC2GSzF_C3kiY8qOVdE424PZ03aY5gNoqGm2BmKtCvZOG5DQShvF2pVp3NCr1XYpVgsSgLeVkq_3KqQ7yps/s1600-h/p17%25255B2%25255D.jpg"><img alt="p17" border="0" height="206" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjj39D35OJYwDfRU-F2DTgBbh4C3u0-bkb-QYZPOsPAfoTXx4cQqsGCHyaJ6-xAmtSZzx3eIt_0Pnh5Ccev04QyCbCsyfVpoR_V1iac55RfSnP-6f0PP7XN9WVDB6DswU_eFVqUUadRBSnn//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p17" width="244" /></a> </span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">and click open </span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjolQvhkFCMm30DdrSbnLe0DL-AHfKW4tyuT-BbdpDX5JcS4a5id5WhPdOIqOb7XDhpmscniqItOTXXSWLl48RjF7Me1YUkwx8f7XmXqZNcqMvMDYEzN8xQQa6-GXr6nGBlCUngBOOufFbf/s1600-h/p18%25255B2%25255D.jpg"><img alt="p18" border="0" height="229" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0Ju1d9n3Oejdv102a4c79U_gqGOPYbdZ_M2-dV3vfhLMG1MhaFTzxTcY7J5hNJ4M52PdxUcAcGr5w4Z1O73I4wQb5GEhNsEv5i78GWF6PbrtNz4zDOaOQhZkjxpx2rNV-u0Shj5or6GdL//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p18" width="244" /></a> </span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">This opens up a new dialog box, enter the following values for the prompts: </span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">· Username </span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">· Old Password </span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">· New Password </span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">-Confirm Password </span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">For the Username prompt value, select under the drop down “Session Variable”, type in USER and mark it as hidden. </span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEksPRLf6Y9sY3qjqf8F-F0XhvhoIxz1AZMGEjvQIwTcTG7BDm5OjG4RkDhzAx1UEI-IivIyDkRIcLnmd22pIHvDsNYVMDzFbTbsdBRxbVELXZXx5mobWhCfJU956Y4jZTo_yVmfe8MRuo/s1600-h/p19%25255B2%25255D.jpg"><img alt="p19" border="0" height="115" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhF7njybVSSPI2RgLwlgPLTy0jsYgPMoIyGv0tmS94JdxIP6F0H4L7gZIEyoEv6J37S62H417pV5NxbEe4fsqApQESXn4hvkqSZSyOGBVDrXxRiN-qrbOx2I3Dz71nEwuWhl4b988GM7w5Q//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p19" width="244" /></a> </span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Select the “Options” tab and personalize the messages </span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2BWMXe1ht-hshGgl1gRtWS4gOK2U5V4yoLWkp7wweamXd-U9Q47zEP4uKAmRH5BomDWzcyqaAeQ6-YgCU9z3a-RQb2ifnSo3nVpvwezqUFUZ4t2n2QzMW6huPkhwPa-NLxDBNC85qrbtK/s1600-h/p20%25255B2%25255D.jpg"><img alt="p20" border="0" height="152" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimJrt2Zs8HIp5wEw1u7TgzfhryS-T8WPpaLEKoVQa3m9__v42V47nmMzlakT53ozUjqZNq0-ClDuEAhAvjyAYmKo8k8AA-DaX5kmnICcLgllSvJ_6d3dtEUgpQ4u_n9lWvsCci5QwkCTNV//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p20" width="244" /></a> </span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Click on the “Action Results” tab and enter the parameters</span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpGZWb-MYWkU_d18dCjc3fmrh-HPD5BDpznPM9lwfbFsONChXPEielsrlLl4oxglo_SYmp_PIu4dYEuNxPo7cIoJexymHmwWwzohr5lq37AWVi2IyD9N-Cj25DtZaMsrWyywgPcgwz1NqE/s1600-h/p22%25255B2%25255D.jpg"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><img alt="p22" border="0" height="154" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGNw2bxpVFrVL-sjecf6SvpbjcSFeQTBoJyHbfL3LN509B4f_uttKlAOxhj4Lmh-j0C1iA2PVfyeMMgZWEUCAjTgxJt3e8Z5-JqSuQWMV7EvylAgnZmtX2E6q2PiuNRE1RlnUdJ4yxtjAL//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p22" width="244" /></span></a><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Save the action.</span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmq8RX2cw5TZPAaxxZRDJbbis2SEAuyZ6MF7KN8AdEC1x1_1cDnz0QJHZSlpEXao05KrG24JQNx9xv_dTyoKQKC9F-mGBznq3ncPeGw76kEX_wmdiR7JGKybEJluiGygsXsSOjU1TY2Li7/s1600-h/p23%25255B2%25255D.jpg"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><img alt="p23" border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFpCjw8k5u0X5fS-gRBBb_Qaj1EqVgMlZ5fn5hN2KxwRHHw-4wdcuSJL1pAkuwdJJOVEnI7NjACFqUy00LzEU7uTIFNie1RtpNRuUGXK335PT0Nm4jiHEy4ZFnXfUZ0zrRinM2OwaL4iFS//?imgmax=800" style="background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p23" width="244" /></span></a><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">You can test it by running the action</span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBuMRheuRSNrpMsCy1OSF5xKNbEziybf43wXwwYi3cyM3MxFIYb4_hULzVEOicBeyVEp3nxnvLi8o1Fb9AnTDYx-BUlQP7a3lyjtZsTTph5eRRuDR_iMC1-HU4k5lDU4eoEGmC1CPplXGJ/s1600-h/p24%25255B2%25255D.jpg"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><img alt="p24" border="0" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWe1Dqs6q3L9Of2YhcBdINtzibtG39JBtia-XUTssevUfNYxopiaVpbMIeqvJg4X7ZN2SAVkhpf6_of9WWzNIHiETdOHylGJjSSzTeEB0kIrwpYTWBESfAap2SevUBzNyk-QTzR4v_3v_J//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p24" width="244" /></span></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-m9MVAQY6UG4AYOMQG10oYd_LPbLUFNL0DYZsOCAJHg137lWuvSnyjZaOVeahLz00yvHuq5q2z3iFwm6W8FLTOC3kU796XstbskmjVO_Z_Nkr-fmG-hlAcHkuSv_cpB5H-NvNFBt2Tax3/s1600-h/p25%25255B2%25255D.jpg"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><img alt="p25" border="0" height="151" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKw-eQ4S2KXXvKtEy21MskdzBh6pcjZVxcXaczOPcCe20S8IskMHfjj1sekCiO2nSUUHJVOGYJhfXrCMzHu2y88s2A0tmHwxpBbT-YMkJnRLsJS7DECsbx4msrexLm1VZzI5sUZQ8V5KeV//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p25" width="244" /></span></a><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4UyNh_HWK3FkOQJ-LlzRmzo0cJpuepQpe6pAjNzfJiR60saLO2syt9UmI2ve8LTuTGpMRk26ce_jO6_iEGiMEItjw9nsgi0Y0PQ8d8RqokL62_0_GsBL2yqbVHjixQlbMIjEdwdFukc_w/s1600-h/p26%25255B2%25255D.jpg"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><img alt="p26" border="0" height="107" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiifB98gHefNsb9EO2cWDJH9BBZwbdRdEHKuhC4TBljegjeTaHcaQnAlIWaFbw09JWVvP9vN2UJBF_s9tNrtXZTl0PNQOEV6J5iOnztwR6drJskQvUkrNWa9QjqjQSF2oFRHmdehMlnOFOi//?imgmax=800" style="background-image: none; border-bottom: 0px; border-left: 0px; border-right: 0px; border-top: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="p26" width="244" /></span></a><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">a+</span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Fiston</span>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-28548900526123192702012-04-02T05:45:00.000-07:002012-04-02T05:45:01.740-07:00Calling bip runReport from job manager<span style="font-family: Verdana, sans-serif;"><span style="font-size: x-small;">Here is a quick experiment with Oracle job scheduler manager. As Venkat </span><a href="http://oraclebizint.wordpress.com/2007/12/17/oracle-bi-ee-101332-calling-java-scripts-and-java-classes-from-ibots/"><span style="font-size: x-small;">blogged </span></a><span style="font-size: x-small;">about long time ago, Oracle Job Manager can be used to call custom Java code. One customer of ours asked about using Job manager to run/schedule BI-Publisher reports? Why would you do that I asked? The final solution we ended up chosing used ADF pages and taskflows.</span></span><br />
<span style="font-size: x-small;"><span style="font-family: Verdana, sans-serif;">Privately, I decided to take the challenge and see how to go about implementing the requested functionality. I am taking the WS route and l</span><span style="font-family: Verdana, sans-serif;">uckily bip comes with several awesome web services, one of them is runReport.</span></span><span style="font-family: Verdana, sans-serif;"><br /></span><div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Create a new Jdeveloper generic application:</span><br />
</div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Application Name: jobManager</span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Package prefix: bip</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwxmdfpOZ8kiji2Fs7xjCm6CAcXyV9Ipfuyz0rRexnOHyvDFpJwuIxzFDpo4LB5jqqQdA23aougDUoVkaAaNk0JQgbw4qHLpt8D8coDsLOgNmsMJDkcaIntUbjeRMJK2CLR9IsfEcVYCac/s1600/pic1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwxmdfpOZ8kiji2Fs7xjCm6CAcXyV9Ipfuyz0rRexnOHyvDFpJwuIxzFDpo4LB5jqqQdA23aougDUoVkaAaNk0JQgbw4qHLpt8D8coDsLOgNmsMJDkcaIntUbjeRMJK2CLR9IsfEcVYCac/s320/pic1.png" width="320" /></a></div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Click Next and name your project</span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Project Name: bip </span></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNUVuloGYScjNotb7zaLio8YKU8BEzLpLHTR_0dYImAsv_Ak4ZPXEt9ntm9qPqXwqAaHUbqRqG75f1-Ijeyy7vP-2a3AHzCHveKUtWI12ZhGPveWKvUQ9YzKu5t5KzJ57pcoHXZeca7F8e/s1600/pic2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNUVuloGYScjNotb7zaLio8YKU8BEzLpLHTR_0dYImAsv_Ak4ZPXEt9ntm9qPqXwqAaHUbqRqG75f1-Ijeyy7vP-2a3AHzCHveKUtWI12ZhGPveWKvUQ9YzKu5t5KzJ57pcoHXZeca7F8e/s320/pic2.png" width="320" /></a></div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
<br /></div>
<div>
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Next, we’ll add a proxy web service for the BIP server</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0Z20l9ZOcSG5IEAaK6sz8ftwcBXVnq1z4Onbhs4dYP02fIYHVI4t1FIkS0Jk5XIxlSrpp1tn1mVY2yMXKAWEVbwdDvvn1xOEYWBtrheB48yu-KrryGzYv4lqEsXtL4V0Kr5nwa1K25sxG/s1600/pic3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0Z20l9ZOcSG5IEAaK6sz8ftwcBXVnq1z4Onbhs4dYP02fIYHVI4t1FIkS0Jk5XIxlSrpp1tn1mVY2yMXKAWEVbwdDvvn1xOEYWBtrheB48yu-KrryGzYv4lqEsXtL4V0Kr5nwa1K25sxG/s320/pic3.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Add a java class: callBIP</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJZIiCAqDn394tL76wvQUPq1Dz6HWdDfcTkg6oVrXyyaMhsq-Eg5RCtp3xTJVHt2fzL9f-ejkZQr6p7SZjX9nLaeSY-FMHJ2mLkE4qDrh3-7t2glBs7kDIVJigEit_XFAc047GaJNYsn1S/s1600/pic4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJZIiCAqDn394tL76wvQUPq1Dz6HWdDfcTkg6oVrXyyaMhsq-Eg5RCtp3xTJVHt2fzL9f-ejkZQr6p7SZjX9nLaeSY-FMHJ2mLkE4qDrh3-7t2glBs7kDIVJigEit_XFAc047GaJNYsn1S/s320/pic4.png" width="264" /></a></div>
<div class="MsoNormal">
<br /></div>
<br />
<div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">We need to add the 3 jars to the project in order to be able to run custom Java jobs.</span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Verdana, sans-serif;"><span style="font-size: x-small;"><span style="text-indent: -0.25in;"> - </span><span style="text-indent: -0.25in;">schedulerrpccalls.jar</span></span></span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Verdana, sans-serif;"><span style="font-size: x-small;"><span style="text-indent: -0.25in;"> - x</span><span style="text-indent: -0.25in;">docore.jar</span><br /><span style="text-indent: -0.25in;">- versioninfor.jar</span></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoTUBQFUlLYu_HbVuzUXtylNfltVKbmxEjR1zWVXpT8_8awkRcpOxmsbff1CuEmqcXaj5D-TBil3WUJdrTTbL3VS6V30HwNZvOcM624NsVeGMaPtjg0NUbIDA4fHDSPSGk4pM1qTE2fFxZ/s1600/pic5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="218" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoTUBQFUlLYu_HbVuzUXtylNfltVKbmxEjR1zWVXpT8_8awkRcpOxmsbff1CuEmqcXaj5D-TBil3WUJdrTTbL3VS6V30HwNZvOcM624NsVeGMaPtjg0NUbIDA4fHDSPSGk4pM1qTE2fFxZ/s320/pic5.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoListParagraph" style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">The code below will call the bip web services, pass in the report xdo absolute path to be run and save the output to the local drive .</span></div>
<div class="MsoListParagraph" style="text-align: left;">
</div>
<div class="MsoListParagraph" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; font-family: Verdana, sans-serif;">
<br /></div>
<div class="MsoListParagraph" style="font-family: Verdana, sans-serif;">
<br /></div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">package bip;</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">import com.oracle.xmlns.oxp.service.v2.AccessDeniedException_Exception;</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">import com.oracle.xmlns.oxp.service.v2.InvalidParametersException_Exception;</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">import com.oracle.xmlns.oxp.service.v2.OperationFailedException_Exception;</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">import com.oracle.xmlns.oxp.service.v2.ReportRequest;</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">import com.oracle.xmlns.oxp.service.v2.ReportResponse;</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">import com.oracle.xmlns.oxp.service.v2.ReportService;</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">import com.oracle.xmlns.oxp.service.v2.ReportService_Service;</span></div>
</div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">import com.siebel.analytics.scheduler.javahostrpccalls.SchedulerJavaExtension;</span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">import com.siebel.analytics.scheduler.javahostrpccalls.SchedulerJobException;</span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">import com.siebel.analytics.scheduler.javahostrpccalls.SchedulerJobInfo;</span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">import java.io.FileNotFoundException;</span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">import java.io.FileOutputStream;</span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">import java.io.IOException;</span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">public class callBIP implements SchedulerJavaExtension {</span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">public static String userID = "weblogic";</span></div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">public static String password = "welcome1";</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">private static ReportService_Service reportService_Service;</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> public void cancel() {</span></div>
</div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> }</span></div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> public void run(SchedulerJobInfo jobInfo) throws SchedulerJobException {</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> reportService_Service = new ReportService_Service();</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> ReportService reportService = reportService_Service.getV2ReportService();</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> try {</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">//Take the first paramater as the report xdo file and call the bip web service</span></div>
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> ReportResponse reportOutput =</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> callBIP.runBipReport(reportService, jobInfo.parameter(0));</span></div>
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: Courier New; font-size: xx-small;">//Save output to local drive</span></div>
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> String strFilePath = "C://temp//report.pdf";</span></div>
</div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> FileOutputStream out = new FileOutputStream(strFilePath);</span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> out.write(reportOutput.getReportBytes());</span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> out.close(); </span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> } catch (IOException e) {</span></div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> jobInfo.setMessage(e.getMessage());</span></div>
</div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> jobInfo.setStatus(2);</span></div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> } catch (InvalidParametersException_Exception e) {</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> jobInfo.setMessage(e.getMessage());</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> jobInfo.setStatus(2);</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> } catch (AccessDeniedException_Exception e) {</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> jobInfo.setMessage(e.getMessage());</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> jobInfo.setStatus(2);</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> } catch (OperationFailedException_Exception e) {</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> jobInfo.setMessage(e.getMessage());</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> jobInfo.setStatus(2);</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> }</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> }</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> public static ReportResponse runBipReport(ReportService reportService,</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> String reportName) throws InvalidParametersException_Exception,</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> AccessDeniedException_Exception,</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> OperationFailedException_Exception,</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> FileNotFoundException,</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> IOException {</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> ReportRequest req = new ReportRequest();</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> req.setAttributeLocale("en-US");</span></div>
</div>
<div class="MsoListParagraph">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> req.setAttributeFormat("pdf");</span></div>
</div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> req.setReportAbsolutePath(reportName);</span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> ReportResponse reportOutput = reportService.runReport(req, userID, password);</span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> return reportOutput;</span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> }</span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"> }</span></div>
<div class="MsoListParagraph">
<span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">}</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgi1xXriiMWqKC407AArrmdDtHiYXCwa2dCV6FrTO_FzY-synkHRr3kt3-dG1PYM3MVeeStXS5pkfCvxGKGronlTObsAQW3-1CY4HyzpqSFQlHPFvTGmxYp8BjPeDjDPjRG5oHjhWeNbbYC/s1600/pic6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="181" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgi1xXriiMWqKC407AArrmdDtHiYXCwa2dCV6FrTO_FzY-synkHRr3kt3-dG1PYM3MVeeStXS5pkfCvxGKGronlTObsAQW3-1CY4HyzpqSFQlHPFvTGmxYp8BjPeDjDPjRG5oHjhWeNbbYC/s320/pic6.png" width="320" /></a></div>
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<br /></div>
<div class="MsoListParagraph" style="text-align: left;">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Compile the code and deploy the JAR file to the javahost lib directory.</span></div>
</div>
<div class="MsoListParagraph" style="text-align: left;">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Change the javahost config.xml flag to enable custom java code processing by javahost.</span></div>
</div>
<div class="MsoListParagraph" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /><span style="font-size: x-small;"></span></span></div>
<div class="MsoListParagraph" style="text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Start Job Manager and enter the class name bip.callBIP, the class Path jar file: bipFile.jar. The report full xdo path is passed as a parameter in the parameters section</span></div>
<br />
<div class="MsoListParagraphCxSpFirst" style="text-align: left; text-indent: -0.25in;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><span style="text-indent: -0.25in;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRwd68lXtctfKsr76VwfbwSLIwufpH3WD-20h2PVpNyZIjPX93Cyjog1aY8rgk6PHlGEkvxpDtyaze9TI04D0t5o3E4o-ycRnvg9Nd4JuKHToSCWdaiComPLraYw1J6tl5rE0yMWxl4Bug/s1600/pic6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="181" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRwd68lXtctfKsr76VwfbwSLIwufpH3WD-20h2PVpNyZIjPX93Cyjog1aY8rgk6PHlGEkvxpDtyaze9TI04D0t5o3E4o-ycRnvg9Nd4JuKHToSCWdaiComPLraYw1J6tl5rE0yMWxl4Bug/s320/pic6.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Execute the job et voila</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6nUYifDrodGBuybDaBUcOXU8G__w1TCjXx-fHaI-H3oTYViDkoNUSYcZ1UP671nCmJHKIASEsD8QUCLF4yJreFK3n2EoP6r8qEsm0bOnx9gOnPnnVwUKNEHrtFcS73G5ir2QSrNBwqPhD/s1600/pic7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="59" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6nUYifDrodGBuybDaBUcOXU8G__w1TCjXx-fHaI-H3oTYViDkoNUSYcZ1UP671nCmJHKIASEsD8QUCLF4yJreFK3n2EoP6r8qEsm0bOnx9gOnPnnVwUKNEHrtFcS73G5ir2QSrNBwqPhD/s200/pic7.png" width="200" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Of course reports can be scheduled as well using this approach.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
a+</div>
<div class="separator" style="clear: both; text-align: left;">
Fiston</div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><span style="text-indent: -0.25in;"><br /></span></span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -0.25in;">
<span style="text-indent: -0.25in;"></span></div>
<div style="font-family: Verdana, sans-serif; text-align: left;">
<br /></div>
<br />
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -0.25in;">
</div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -0.25in;">
</div>
</div>
<div>
<div class="MsoNormal">
</div>
</div>Unknownnoreply@blogger.comChicago, IL, USA41.8781136 -87.629798241.6889521 -87.94565519999999 42.067275099999996 -87.3139412tag:blogger.com,1999:blog-8879294908838500170.post-4992052608635716452012-02-27T20:47:00.000-08:002012-02-27T20:47:34.507-08:00Playing with the Summary Advisor<br />
<span style="font-family: inherit;">The goal for this posting is to do a quick experiment with the new OBIEE 11.1.1.6 feature "</span>Summary Advisor" <span style="font-family: inherit;">based on what I had a chance to learn about it and to document the steps: For this I'll be using an "Exalyticless" setup with the following components</span><br />
<span style="font-family: inherit;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>11.1.1.6</span><br />
<span style="font-family: inherit;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>TimesTen </span><br />
<span style="font-family: inherit;">•<span class="Apple-tab-span" style="white-space: pre;"> </span>Oracle db</span><br />
<span style="font-family: inherit;">First there are few </span>required<span style="font-family: inherit;"> steps that have to be done in TimesTen, the OBIEE RPD and the Weblogic enterprise manager.</span><br />
<span style="font-family: inherit;"><b><u>TimesTen:</u></b></span><br />
<b><u><span style="font-size: x-small;"><a href="http://www.oracle.com/technetwork/database/timesten/downloads/index.html">Download</a> </span></u></b><br />
<b><u><a href="http://docs.oracle.com/cd/E21901_01/welcome.html"><span style="font-size: x-small;">Installation Guide</span></a></u></b><br />
<span style="font-family: inherit;">Once TimesTen is installed, create a new connection in SQL*Plus or SQL Developer. Once connected, create a new user that will be used by the Admin Tool to connect to TimesTen. </span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7wum1frk4qs9Tw9ZtU-1PiaCSoTXiY_BmL487s9nVFqCSGWLF22hcvHAGLNVxKI0ZY0HyZ3iDlcr31VvgV9fGL1q2bCgGKgGBNPq3pXSzLSGoQNpRA5KHqYw9odG8rggoAElz6aeAIGJg/s1600/SA1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="229" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7wum1frk4qs9Tw9ZtU-1PiaCSoTXiY_BmL487s9nVFqCSGWLF22hcvHAGLNVxKI0ZY0HyZ3iDlcr31VvgV9fGL1q2bCgGKgGBNPq3pXSzLSGoQNpRA5KHqYw9odG8rggoAElz6aeAIGJg/s320/SA1.jpg" width="320" /></a></div>
<div>
<div>
<span style="font-family: 'Courier New', Courier, monospace; font-size: x-small;"><br /></span></div>
<div>
<span style="font-family: 'Courier New', Courier, monospace; font-size: x-small;">create user bi11g identified by Admin123;</span></div>
<div>
<span style="font-family: 'Courier New', Courier, monospace; font-size: x-small;">grant create table to bi11g;</span></div>
<div>
<span style="font-family: 'Courier New', Courier, monospace; font-size: x-small;">grant select on SYS.OBJ$ to bi11g;</span></div>
<div>
<span style="font-family: 'Courier New', Courier, monospace; font-size: x-small;">grant create session to bi11g;</span></div>
</div>
<div>
<span style="font-family: 'Courier New', Courier, monospace; font-size: x-small;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiAzjJzRErBj4N30y9VlA5WD4PLNmXkYleeNGP2TBqX6gEtIYG9g6a1fPmA7S12nTOqdelggywElbroI73WBlsMm0n4N9GtD-1hscRmP-ekqgsQ8khkibkf2mvgK57SBJD9uJHd_eGEXFh/s1600/SA2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="154" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiAzjJzRErBj4N30y9VlA5WD4PLNmXkYleeNGP2TBqX6gEtIYG9g6a1fPmA7S12nTOqdelggywElbroI73WBlsMm0n4N9GtD-1hscRmP-ekqgsQ8khkibkf2mvgK57SBJD9uJHd_eGEXFh/s320/SA2.jpg" width="320" /></a></div>
<div>
<div>
<span style="font-family: inherit;">Create a new connection to SQL Developer for bi11g and a table BI_TABLE. BI_TABLE will be used to test the connection pool for the Summary Advisor </span></div>
<div>
<span style="font-family: 'Courier New', Courier, monospace; font-size: x-small;">Name: BI_TABLE1</span></div>
<div>
<span style="font-family: 'Courier New', Courier, monospace; font-size: x-small;">Column Name: COLUMN1 (VARCHAR2(4000))</span></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisCT3_psUw8qIlkg6uXlrQzBwT4A_Xd7E9BmOJ0Ung4rIpRFXqvFfnCx4MiSZ1HLxU8Lgi-nMrxdv4ncELoYWKTyJ8lyJXPd0b4BCC0ct8tXb7TXL644gHlDj1RKbh0qT_-vMTI7kKrrTP/s1600/SA3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="226" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisCT3_psUw8qIlkg6uXlrQzBwT4A_Xd7E9BmOJ0Ung4rIpRFXqvFfnCx4MiSZ1HLxU8Lgi-nMrxdv4ncELoYWKTyJ8lyJXPd0b4BCC0ct8tXb7TXL644gHlDj1RKbh0qT_-vMTI7kKrrTP/s320/SA3.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Add one row of data just for testing</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHP5J39K2-QVY8pxZw_-BGc0HggeY_bq4Im2rlc_I5QP7FAbMDpaD81Vdqs60bHFQOEdnln-WuCWpP934oNE5C8R5sB9s0-BSyZ77wH4Fnti8KrgG_5pLFLDqPtLO0FeFkIkqmAfia3xW4/s1600/SA4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="116" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHP5J39K2-QVY8pxZw_-BGc0HggeY_bq4Im2rlc_I5QP7FAbMDpaD81Vdqs60bHFQOEdnln-WuCWpP934oNE5C8R5sB9s0-BSyZ77wH4Fnti8KrgG_5pLFLDqPtLO0FeFkIkqmAfia3xW4/s320/SA4.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<b><u><span style="font-family: inherit;">OBIEE Admin Tool</span></u></b></div>
<div class="separator" style="clear: both; text-align: left;">
•<span class="Apple-tab-span" style="white-space: pre;"> </span>Log into the Admin Tool and create a connection pool to the TimesTen instance, this will be used by Summary Advisor as a target data store.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgM9kePe_T7ICO_WUr4No1Xusown4nTVIkV7wG5-HZNNyJDsbU7eTzwg1NcUIX1cEJNgaQmsbzR31zOdE3GzGJ7i_-R6RWSSYCujvxtr-q6jxr1qkM5YL_huGZcsokvr9gUeWPUUl4I2myS/s1600/SA11.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgM9kePe_T7ICO_WUr4No1Xusown4nTVIkV7wG5-HZNNyJDsbU7eTzwg1NcUIX1cEJNgaQmsbzR31zOdE3GzGJ7i_-R6RWSSYCujvxtr-q6jxr1qkM5YL_huGZcsokvr9gUeWPUUl4I2myS/s1600/SA11.jpg" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgiC2SbROhirm4UDuhwZRnXU_-L2qpUkuVNuiwVH-cciODRXbky6gPxfqEd1HSsLGrCmlUbBeMUCTdg-3QCFf6VDVHWCcT-VVBwPaNxWoHTUrZGdSLMeVXohT4CdS4deOq8ArnO4QPJw8A/s1600/SA7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="217" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgiC2SbROhirm4UDuhwZRnXU_-L2qpUkuVNuiwVH-cciODRXbky6gPxfqEd1HSsLGrCmlUbBeMUCTdg-3QCFf6VDVHWCcT-VVBwPaNxWoHTUrZGdSLMeVXohT4CdS4deOq8ArnO4QPJw8A/s320/SA7.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div>
<span style="font-family: inherit;"><br /></span></div>
<div>
•<span class="Apple-tab-span" style="white-space: pre;"> </span>Enable the COMPRESS_COLUMNS to cause the Summary Advisor to create aggregates in TimesTen using the Compressed Columns capability.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjV-GO136f5E52lwLMZY5KSHL7Xv2kTXSiIJ724-Y8ofw8u04-LyKHqtv840GLgWkgaH2TkO_4Ed8967Ptp3GtS3iaLCb1IU_z9Fns2bJQ1SyQnmtkLxNitD-L-clgGGYjh5PaVgAIVxGKa/s1600/SA8.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjV-GO136f5E52lwLMZY5KSHL7Xv2kTXSiIJ724-Y8ofw8u04-LyKHqtv840GLgWkgaH2TkO_4Ed8967Ptp3GtS3iaLCb1IU_z9Fns2bJQ1SyQnmtkLxNitD-L-clgGGYjh5PaVgAIVxGKa/s320/SA8.jpg" width="307" /></a></div>
<div>
<br /></div>
<div>
<div>
<b><u>WL Enterprise Manager</u></b></div>
<div>
<ul>
<li>Need to make sure that the Usage Tracking parameters and the Summary Advisor settings are set correctly. </li>
<li>Log into WL enterprise manager and navigate to the “System MBean Browser”</li>
</ul>
</div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh12SMg70HUx9pnV_IiUnpsX1NEHTxEBf9_9L04KHtuCt7SaK5bjTAvDgQvhy8lF9StkcXuBb10OMkiENtjT9gIMiXRpxBi0RsozYnSLuQ0z69twRoQbI-X5udc7KeU8_SYF-Z_O8NzqYlJ/s1600/Wl2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh12SMg70HUx9pnV_IiUnpsX1NEHTxEBf9_9L04KHtuCt7SaK5bjTAvDgQvhy8lF9StkcXuBb10OMkiENtjT9gIMiXRpxBi0RsozYnSLuQ0z69twRoQbI-X5udc7KeU8_SYF-Z_O8NzqYlJ/s320/Wl2.jpg" width="236" /></a></div>
<div>
<br /></div>
<div>
<ul>
<li>Navigate to the BIDomain.BIInstance.ServerConfiguration </li>
</ul>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1e9073_ZOWIFxNJp55t0iGIFP9vBtihf25GcRYU_JQ_3QO0ie0ttBUhTrYU1ShEqIV_PCdqDZHzEoM_1xK0rhyphenhyphenW_MY0YzF9I_uAZxfaRsIPcFhWfS7eAoimJjKwRUfsYaYS_80oWmqBDk/s1600/WL7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="88" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1e9073_ZOWIFxNJp55t0iGIFP9vBtihf25GcRYU_JQ_3QO0ie0ttBUhTrYU1ShEqIV_PCdqDZHzEoM_1xK0rhyphenhyphenW_MY0YzF9I_uAZxfaRsIPcFhWfS7eAoimJjKwRUfsYaYS_80oWmqBDk/s320/WL7.jpg" width="320" /></a></div>
<div>
<br /></div>
<div>
<div>
We need to make sure that the values are in sync with the repository settings.</div>
<div>
Now that we’re done with the settings, we can test our system without the Summary Advisor feature implemented; this will serve as a reference that will be used for comparison once the Summary Advisor is implemented. This will be the topic of a future posting.</div>
</div>
<div>
<br /></div>
<div>
a+</div>
<div>
Fiston</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-15399646247115364322012-02-27T08:58:00.000-08:002012-02-27T09:07:09.880-08:00Usage Tracking in OBIEE 11.1.1.6<span style="font-family: Arial, Helvetica, sans-serif;">In case you haven't noticed yet, Usage Tracking is now a system managed attribute in 11.1.1.6, you can no longer directly configure this using the NQSCONFIG.INI file. </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">To configure Usage Tracking, log into WL enterprise manager and </span><br />
<br />
<ul>
<li><span style="font-family: Arial, Helvetica, sans-serif;">Expand the WebLogic Domain and the bifoundation_domain .</span></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoTHAWw8hxe6Vm64bI6rxxWYQ6JvRHmXSpIhbf31bDPkEim8kR4VQ3QBW6YdqOk6mmGwYTmCgrib1vLko3P-kfwDnuX5RTe5aD7mxsPMa09SZibfoEWbw0jzPOafBMZA8c0Ot-b715y2xc/s1600/Wl1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="274" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoTHAWw8hxe6Vm64bI6rxxWYQ6JvRHmXSpIhbf31bDPkEim8kR4VQ3QBW6YdqOk6mmGwYTmCgrib1vLko3P-kfwDnuX5RTe5aD7mxsPMa09SZibfoEWbw0jzPOafBMZA8c0Ot-b715y2xc/s320/Wl1.jpg" width="320" /></a></div>
<div>
<br /></div>
<ul>
<li><span style="font-family: Arial, Helvetica, sans-serif;">Right-click on the Admin Server and select "System MBean Browser."</span></li>
</ul>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBisi108r_xC9muooj4IFVzpTH7cr9JtDJEVW69xXgRbSiCaAtbfyh9k5Z6UwNLfcmQKmN7oEWty2GDfUQBU7yHpQcLUe_F7kpu4_DyK6vxKH8rUd3fe3H9E4zqNY6jt0ogHENXe5t55sz/s1600/Wl2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBisi108r_xC9muooj4IFVzpTH7cr9JtDJEVW69xXgRbSiCaAtbfyh9k5Z6UwNLfcmQKmN7oEWty2GDfUQBU7yHpQcLUe_F7kpu4_DyK6vxKH8rUd3fe3H9E4zqNY6jt0ogHENXe5t55sz/s320/Wl2.jpg" width="233" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both;">
</div>
<ul>
<li><span style="font-family: Arial, Helvetica, sans-serif;">Navigate to the MBean in the following tree:</span></li>
<ul>
<li><span style="font-family: Arial, Helvetica, sans-serif;">Application Defined Mbeans</span></li>
<ul>
<li><span style="font-family: Arial, Helvetica, sans-serif;"> oracle.biee.admin</span></li>
<ul>
<li><span style="font-family: Arial, Helvetica, sans-serif;"> BIDomain.BIInstance.ServerConfiguration</span></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFdfBkSriZo1JYr3KySb9KnyU8c0HZ2cT4qe4sMNeL6YvbJh-l6H0Gw4FszvCidVot3uOTF2s5Fntung0JTxm0DSmI_6eKdN1x30nZNZsHJu3d2Mx_4daIWM3yK5tg5a9IswbKjR6Btu-2/s1600/WL4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFdfBkSriZo1JYr3KySb9KnyU8c0HZ2cT4qe4sMNeL6YvbJh-l6H0Gw4FszvCidVot3uOTF2s5Fntung0JTxm0DSmI_6eKdN1x30nZNZsHJu3d2Mx_4daIWM3yK5tg5a9IswbKjR6Btu-2/s320/WL4.jpg" width="304" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">List of configuration settings</span></div>
</ul>
</ul>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiV2S_4WKTMyHoYDowuebhRwYoGrZXADx25725Cj5B83gP39VdiVLapn0qnjrXExkOOTyR0uOg_6AjCa6O4jtohwVh14KIgOVYLKpV_DRTDF81z4FkE-zu3WXH9wFMn2PY__fl9PWvXTKQU/s1600/Wl6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="90" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiV2S_4WKTMyHoYDowuebhRwYoGrZXADx25725Cj5B83gP39VdiVLapn0qnjrXExkOOTyR0uOg_6AjCa6O4jtohwVh14KIgOVYLKpV_DRTDF81z4FkE-zu3WXH9wFMn2PY__fl9PWvXTKQU/s320/Wl6.jpg" width="320" /></a></div>
<div>
<br /></div>
a+<br />
<span style="font-family: Arial, Helvetica, sans-serif;">Fiston</span>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-55649280128914680092012-02-27T07:04:00.000-08:002012-02-27T10:16:18.391-08:00Box and Whiskers Plot using R and BIP<span style="font-family: Arial, Helvetica, sans-serif;"> I’ve just started experimenting with R in conjunction with BI-Publisher. R provides various statistical packages and plotting utilities and there are numerous resources on the web dedicated to it. The goal is to take a generate a plot using R and render it in BI-Publisher. The installation steps for R enterprise are covered in the<a href="http://docs.oracle.com/cd/E27988_01/doc/doc.112/e26499.pdfdocs.oracle.com/cd/E27988_01/doc/doc.112/e26499.pdf"> Oracle® R Enterprise User's Guide</a>, the main steps are: </span><br />
<br />
<ul>
<li><span style="font-family: Arial, Helvetica, sans-serif;">Install R: <a href="http://cran.r-project.org/bin/windows/base/">http://cran.r-project.org/bin/windows/base/</a></span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;">Download Oracle R Enterprise are available from <a href="http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/index.html">http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/index.html</a> </span></li>
<ul>
<li><span style="font-family: Arial, Helvetica, sans-serif;">ore-supporting-windows-1.0.zip, the supporting R packages </span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;">ore-windows-1.0.zip, the Oracle R Enterprise packages.</span></li>
</ul>
<li><span style="font-family: Arial, Helvetica, sans-serif;">Start R and install the packages, this can be done from the command line or using the R GUI</span></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidwCZNogkrWBkgnPYbY2V27LEhmjdAZJtHoawxvca33tp4J_GnGy01F8Kxv_dD1o6D__M4df35zTLUfRW2UqnLo9Tg9IFip3CMiRMu9Kb6GA-upotCPQWUbtpgduOhCZHIT7Rr9DVBtF28/s1600/R1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Arial, Helvetica, sans-serif; font-size: x-small;"><img border="0" height="155" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidwCZNogkrWBkgnPYbY2V27LEhmjdAZJtHoawxvca33tp4J_GnGy01F8Kxv_dD1o6D__M4df35zTLUfRW2UqnLo9Tg9IFip3CMiRMu9Kb6GA-upotCPQWUbtpgduOhCZHIT7Rr9DVBtF28/s320/R1.jpg" width="320" /></span></a></div>
<br />
<ul>
<li><span style="font-family: Arial, Helvetica, sans-serif;">Install the R server ((LINUX/UNIX)</span></li>
</ul>
<br />
<span style="font-family: Arial, Helvetica, sans-serif; font-size: x-small;">To connect to R enterprise from R client run the following:</span><br />
<span style="font-family: "Courier New", Courier, monospace;"><span style="font-size: x-small;">ore.connect(user = "<username>",sid = "<sid>",host = "<host>",password = "<password>",port = PORTNUMBER)</password></host></sid></username></span></span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"># Synchronize R with user's schema in Oracle</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;">ore.sync()</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"># Attach environment containing visible Oracle tables and views</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"># to the search path</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;">ore.attach()</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Modify (user, sid, host, password, and port) for the database where the R Server is installed</span><br />
<br />
<ul>
<li><span style="font-family: Arial, Helvetica, sans-serif;">Create the R script</span></li>
</ul>
<br />
<span style="font-family: Arial, Helvetica, sans-serif;">As an example, I’ll generate a<a href="http://en.wikipedia.org/wiki/Box_plot"> box and whiskers</a> plot using the ONTIME_S airline <a href="http://www.transtats.bts.gov/OT_Delay/OT_DelayCause1.asp">on-time performance data</a>. Box and whiskers plots are not available out of the box in BI-Publisher. The plot will use a subset of the dataset to focus on the DMV Airports: Reagan Airport (DCA), Dulles Airport (IAD) and Baltimore Washington airport (BWI) for 2007 and 2008.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">Below is the R script that generates the plot:</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"></span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;">f <-function(){</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"> ontime <- ONTIME_S</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"> delay <- ontime$ARRDELAY[ontime$DEST %in% c("BWI", "IAD", "DCA") & ontime$YEAR %in% c(2007,2008)]</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"> dest <- ontime$DEST[ontime$DEST %in% c("BWI", "IAD", "DCA") & ontime$YEAR %in% c(2007,2008)]</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"> dest <- reorder(dest, delay, FUN = median)</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"> bd <- split(delay, dest)</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"> res <- boxplot(bd, ylim=c(-50,60),col=c( "darkolivegreen","coral3","cornflowerblue"),main="Flight Delays by Airport", xlab="Airport", ylab="Delay (minutes)")</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;">}</span><br />
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;">f()</span><br />
<br />
<span style="font-family: Arial, Helvetica, sans-serif; font-size: x-small;"><br /></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEc4YndgMlQOBvoMog6Z4AVVs8ouEJyIFcSQZP6ZBtwOrx_S9FimcklESFO2RXLDAxVzpe3VqJwsmOykLvjucpnzPJOpcYpvWLWbDXY3pJOKnSwNlj1CtNZFzP6Co9VCkJ9gg7wP_ufaRj/s1600/BW.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="316" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEc4YndgMlQOBvoMog6Z4AVVs8ouEJyIFcSQZP6ZBtwOrx_S9FimcklESFO2RXLDAxVzpe3VqJwsmOykLvjucpnzPJOpcYpvWLWbDXY3pJOKnSwNlj1CtNZFzP6Co9VCkJ9gg7wP_ufaRj/s320/BW.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">The R script has to be modified a bit to "escape" the "&" sign (in red), if not <i>ontime</i> will be considered a prompted parameter. This script can be run using SQL*Plus.</span></div>
<div>
<span style="color: white; font-family: "Courier New", Courier, monospace; font-size: x-small;"> BEGIN</span></div>
<div>
<span style="color: white; font-family: "Courier New", Courier, monospace; font-size: x-small;">sys.rqScriptCreate('DMVAirports',</span></div>
<div>
<span style="color: white; font-family: "Courier New", Courier, monospace; font-size: x-small;">'f <-function(){</span></div>
<div>
<span style="color: white; font-family: "Courier New", Courier, monospace; font-size: x-small;"> ontime <- ONTIME_S</span></div>
<div>
<span style="color: white; font-family: "Courier New", Courier, monospace; font-size: x-small;"> delay <- ontime$ARRDELAY[ontime$DEST %in% c("BWI", "IAD", "DCA") <span style="background-color: red;">'||'&'||'</span> ontime$YEAR %in% c(2007,2008)]</span></div>
<div>
<span style="color: white; font-family: "Courier New", Courier, monospace; font-size: x-small;"> dest <- ontime$DEST[ontime$DEST %in% c("BWI", "IAD", "DCA") <span style="background-color: red;">'||'&'||' </span>ontime$YEAR %in% c(2007,2008)]</span></div>
<div>
<span style="color: white; font-family: "Courier New", Courier, monospace; font-size: x-small;"> dest <- reorder(dest, delay, FUN = median)</span></div>
<div>
<span style="color: white; font-family: "Courier New", Courier, monospace; font-size: x-small;"> bd <- split(delay, dest)</span></div>
<div>
<span style="color: white; font-family: "Courier New", Courier, monospace; font-size: x-small;"> res <- boxplot(bd, ylim=c(-50,60),col=c( "darkolivegreen","coral3","cornflowerblue"),main="Flight Delays by Airport", xlab="Airport", ylab="Delay (minutes)")</span></div>
<div>
<span style="color: white; font-family: "Courier New", Courier, monospace; font-size: x-small;">} ');</span></div>
<div>
<span style="color: white; font-family: "Courier New", Courier, monospace; font-size: x-small;">END;</span></div>
<div>
<span style="color: white; font-family: "Courier New", Courier, monospace; font-size: x-small;">/</span></div>
<div>
<span style="color: #222222; font-family: "Courier New";"><span style="font-size: 12px; line-height: 13px;"><br /></span></span></div>
<div>
<div class="MsoNormal" style="margin-bottom: 0in;">
</div>
<div class="MsoNormal" style="margin-bottom: 0pt;">
</div>
<ul>
<li><span style="line-height: 13px;"><span style="color: white; font-family: Arial, Helvetica, sans-serif;">Create a BI-Publisher data model using the following query:</span></span></li>
</ul>
<br />
<div class="MsoNormal" style="margin-bottom: 0pt;">
<span style="color: white; font-family: "Courier New";"><span style="font-size: 12px; line-height: 13px;"><br /></span></span></div>
<div class="MsoNormal" style="margin-bottom: 0pt;">
<span style="color: white; font-family: "Courier New", Courier, monospace; font-size: x-small;"><span style="line-height: 13px;">select value from table(rqEval(NULL,'XML','<b>DMVAirports</b>'))</span></span></div>
<div style="color: #222222; font-family: "Courier New"; font-size: 9pt; line-height: 115%;">
<br /></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5j_1xwNgVzGoJWg9DkKzZ67UqYPCAUACOheUxakEzcGqYJ5-eyY3reedDp8ioamaoIGjv0H0c7sy_S_TVIzY1I5i0NzLmJsnhACdcDpg6LKEmu2P2nFY8dynLpE6b1IrFExZGSDhW9Ruc/s1600/R2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="229" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5j_1xwNgVzGoJWg9DkKzZ67UqYPCAUACOheUxakEzcGqYJ5-eyY3reedDp8ioamaoIGjv0H0c7sy_S_TVIzY1I5i0NzLmJsnhACdcDpg6LKEmu2P2nFY8dynLpE6b1IrFExZGSDhW9Ruc/s320/R2.jpg" width="320" /></a></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">You can list all the available R functions in the database by running:</span></div>
<div>
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;">select name from sys.rq_scripts</span></div>
<div>
<span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"><br /></span></div>
<div>
<ul>
<li><span style="font-family: Arial, Helvetica, sans-serif;">Change the VALUE field from CLOB to XML</span></li>
</ul>
</div>
<div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbRKXfhrL3mdykF9uBtaXEjlQAUIvOQhVl2ATOI9AHo5RN15uET2yEL3ZkdxmucDdoXbIclODxSSoF74thdJ7ZMngRK79A6x4rY2l7uEEwgv2WLP_4yk1N1IqNtCclrw6VITGrjOG-UO70/s1600/R4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="153" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbRKXfhrL3mdykF9uBtaXEjlQAUIvOQhVl2ATOI9AHo5RN15uET2yEL3ZkdxmucDdoXbIclODxSSoF74thdJ7ZMngRK79A6x4rY2l7uEEwgv2WLP_4yk1N1IqNtCclrw6VITGrjOG-UO70/s320/R4.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<ul>
<li><span style="font-family: Arial, Helvetica, sans-serif;">Generate some sample XML</span></li>
</ul>
</div>
<div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhp81tzgbB-QLbE0LFE9dqGt8u8y9nDoH21yVc2Jep6RVh0GSO_u_psKILrE7QT6Ai6yLP6oOwVkdFUT_fYSczBMgHNkXDaFFgeQvjAyu1LKFXUxPWYpTJy7iCc8PKEl1do5tgIIv-Nx4P6/s1600/R3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="85" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhp81tzgbB-QLbE0LFE9dqGt8u8y9nDoH21yVc2Jep6RVh0GSO_u_psKILrE7QT6Ai6yLP6oOwVkdFUT_fYSczBMgHNkXDaFFgeQvjAyu1LKFXUxPWYpTJy7iCc8PKEl1do5tgIIv-Nx4P6/s320/R3.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<ul>
<li style="text-align: left;"><span style="font-family: Arial, Helvetica, sans-serif;">Create a new template using BI-Publisher Desktop and insert the field img with the following properties: </span></li>
</ul>
</div>
<div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdaPomtjPKuCO-IsPLg-JLt51B6PaNvgd3Hchi96h45kWxkqX6ryJtFpXGCPzFTjyZ62vsVgTS8O9GTfWHqeIq0NA3kyvVBvjxfo-DuF-TV_FCvwcQ4UdhUF3tXbqu_jtdDHa4iPkEwO7a/s1600/R6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdaPomtjPKuCO-IsPLg-JLt51B6PaNvgd3Hchi96h45kWxkqX6ryJtFpXGCPzFTjyZ62vsVgTS8O9GTfWHqeIq0NA3kyvVBvjxfo-DuF-TV_FCvwcQ4UdhUF3tXbqu_jtdDHa4iPkEwO7a/s320/R6.jpg" width="264" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOoW64jSr3S103S2eqwCsQ-uuTB5tPYOj-X0Ll0FEbx1EvfB2w6czdQpu35wOwxM0mRNUNWlBBNKNeyQi183IzP6wA46Smb9lV06c2UdC3wfIud-fyXM16vs1mqIMTWDp7a4NVmrAb8M0y/s1600/R8.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="188" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOoW64jSr3S103S2eqwCsQ-uuTB5tPYOj-X0Ll0FEbx1EvfB2w6czdQpu35wOwxM0mRNUNWlBBNKNeyQi183IzP6wA46Smb9lV06c2UdC3wfIud-fyXM16vs1mqIMTWDp7a4NVmrAb8M0y/s200/R8.jpg" width="200" /></a></div>
<div class="separator" style="clear: both;">
</div>
<br />
<div style="text-align: left;">
<div class="MsoNormal" style="margin-bottom: 0in;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<ul>
<li> Create a PDF output et voila!!!</li>
</ul>
<br />
<span style="font-family: Arial, sans-serif;"></span><br />
<div class="separator" style="clear: both; color: #222222; text-align: center;">
<span style="font-family: Arial, sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt0aqQtPRTylcUZm9AinYXmhrRprKSBBysfIk50YjHKKUzomOkh8fxKHnUXjo0_FmX2Vc1pxRkSswIHLpCDVHScvDgxGiZrze9jTK6J3bEu96KIZYAWgx-pbniZEzHBRHSSQReg3pAEAwm/s1600/R7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt0aqQtPRTylcUZm9AinYXmhrRprKSBBysfIk50YjHKKUzomOkh8fxKHnUXjo0_FmX2Vc1pxRkSswIHLpCDVHScvDgxGiZrze9jTK6J3bEu96KIZYAWgx-pbniZEzHBRHSSQReg3pAEAwm/s320/R7.jpg" width="251" /></a></span></div>
<span style="font-family: Arial, sans-serif;"></span><br />
<div class="separator" style="clear: both; text-align: left;">
<span style="color: white;">Too bad I live 10 mins from the airport with the worse performance!</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: white;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: white;">For more information, tutorials visit:</span></div>
<div class="separator" style="clear: both; color: #222222; text-align: left;">
<a href="http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/index.html">http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/index.html</a></div>
<div class="separator" style="clear: both; color: #222222; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; color: #222222; text-align: left;">
<span style="color: white;">a+</span></div>
<div class="separator" style="clear: both; color: #222222; text-align: left;">
<span style="color: white;">Fiston</span></div>
<div style="color: #222222;">
<span style="font-size: 12px; line-height: 13px;"><br /></span></div>
</div>
</div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-5719897836053807892012-02-21T11:43:00.004-08:002012-02-21T11:50:36.382-08:00OBIEE 11.1.1.6 new features/enhancements<br />
<br />
<span style="font-family: Arial, Helvetica, sans-serif;">New features/enhancements, good stuff</span><br />
<br />
<ul>
<li><span style="font-family: Arial, Helvetica, sans-serif;"><b>Auto-Complete Functionality for Prompts:</b> When enabled by the administrator, auto-complete suggests and highlights matching prompt values as the user types in the prompt selection field</span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;"><b>Optional Apply and Reset Buttons for Prompts:</b> You can show or hide a prompt's apply and reset buttons.</span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;"><b>Miscellaneous Prompts Enhancements: </b> The prompt Reset button now provides three reset options: Reset to last applied values, Reset to default values, and Clear All.</span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;"><b>Favorites:</b> You can now bookmark as favorites the catalog objects</span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;"><b>Customizable Global Header and Get Started: </b>The order of the links on the global header can now be customized, and links to external locations can be added to the global header. The Get Started... section of the home page can also be customized to meet the informational needs of the users</span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;"><b>Oracle BI Client Installer Option Added to the Home Page:</b> A link to the Oracle BI Client Installer has been added to the Download BI Desktop Tools option (just like it is for BI-Publisher Desktop)</span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;"><b>Integrated Full-Text Search Capabilities:</b> This method of searching allows the user to find objects by searching on their attributes such as author and column name</span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;"><b>Ability to Set Accessibility Mode in the Sign In Page:</b> Facilitates the use of a screen reader.</span></li>
<li><b><span style="font-family: Arial, Helvetica, sans-serif;">Enhancement to Oracle Scorecard and Strategy Management</span></b></li>
<li><b><span style="font-family: Arial, Helvetica, sans-serif;">Oracle Business Intelligence Mobile</span></b></li>
<li><b><span style="font-family: Arial, Helvetica, sans-serif;">Enhancements to Tables and Pivot Tables</span></b></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;"><b>Enhancements to Map Views:</b> You can now include non-BI layers on a map view</span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;"><b>Enhancements to Selections: </b>The ability to include selected members in hierarchy selections steps that are based on family relationships, the addition of Siblings of and Leaves of options in family relationships.</span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;"><b>Enhancements to Views:</b> The ability to rename views and compound layouts</span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;"><b>BI Composer Enhancements:</b> BI Composer is now available in regular mode as well accessibility </span>mode</li>
</ul>
<br />Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-65528773873457410382012-02-21T10:02:00.000-08:002012-02-21T10:02:16.244-08:00OBIEE 11.1.1.1.6 available for downloadI just learned that 11.1.1.6 is now available for download. Following are the major new features in the Administration Tool:<br />
<br />
<br />
<ul>
<li>Ability to Limit and Offset Rows Returned</li>
<li>Identify Query Candidates with Oracle BI Summary Advisor</li>
<li>Integrate the Administration Tool with a Third-Party Source Control Management System</li>
<li>Streamlined MUD Merge Process</li>
<li>Automated Repository Patching Process</li>
<li>Support for Aggregate Persistence in a Cluster</li>
<li>Ability to Print the Physical and Business Model Diagrams</li>
</ul>
<br />
No doubt that in the coming hours there will be a flurry of new postings dealing with new featuresUnknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-6780354439550703292011-05-05T18:26:00.001-07:002011-05-05T18:26:54.267-07:00Oracle Business Intelligence, v. 11.1.1.5.0 available for downloadhttp://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/biee-111150-393613.htmlUnknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-26275851209416270512010-03-30T09:17:00.000-07:002010-03-30T09:28:33.116-07:00Cookies in OBIEEI had a requirement to do some sort "hand-shaking" between OBIEE and APEX for security purposes: basically I had to read a session variable that was set by APEX then set a cookie using that session variable avlue. As many bloggers pointed it out a lot can be done using javascript in OBIEE. This posting gives a very simple example.<br />
<br />
First I set the values of apex_biee_key in the rpd using a simple query (in our set up this value is set by the apex application).<br />
<br />
Initialization block to populate apex_biee_key<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://3.bp.blogspot.com/_Nw7buz4M69c/S7Ig7BEJR7I/AAAAAAAAAaQ/xB4SRzW9YtE/s1600-h/3-30-2010+10-20-11+AM.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://3.bp.blogspot.com/_Nw7buz4M69c/S7Ig7BEJR7I/AAAAAAAAAaQ/xB4SRzW9YtE/s320/3-30-2010+10-20-11+AM.gif" width="215" /></a></div><br />
<a href="http://3.bp.blogspot.com/_Nw7buz4M69c/S7Ig7BEJR7I/AAAAAAAAAaQ/xB4SRzW9YtE/s1600-h/3-30-2010+10-20-11+AM.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a><br />
<div>Javascript for reading apex_biee_key session variable and setting a cookie with the same name: APEX_BIEE_KEY</div><div><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWBrdH47VsIw4ozKedYk7X-yIyxGi1eJ5rDjXMDAJNqZF73VlczrHrOPD42niwI6MbNCED4Z6f4boFDYSo8L3ZatJPGT6C37PJ88cuwUWt3cnx6I_UhuztY5YELraLs5lYb0CTt8Utj0-L/s1600-h/3-30-2010+12-26-08+PM.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="137" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWBrdH47VsIw4ozKedYk7X-yIyxGi1eJ5rDjXMDAJNqZF73VlczrHrOPD42niwI6MbNCED4Z6f4boFDYSo8L3ZatJPGT6C37PJ88cuwUWt3cnx6I_UhuztY5YELraLs5lYb0CTt8Utj0-L/s320/3-30-2010+12-26-08+PM.gif" width="320" /></a></div><br />
<div><a href="http://1.bp.blogspot.com/_Nw7buz4M69c/S7IhQbRkhFI/AAAAAAAAAaU/8AzbHYWiZkg/s1600-h/3-30-2010+10-47-20+AM.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a><br />
<br />
<br />
<div>Create an html report with the javascript code:</div><div class="separator" style="clear: both; text-align: center;"><a href="http://3.bp.blogspot.com/_Nw7buz4M69c/S7IhzeDEDhI/AAAAAAAAAaY/cGoTH2DuqdI/s1600-h/3-30-2010+10-33-38+AM.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="238" src="http://3.bp.blogspot.com/_Nw7buz4M69c/S7IhzeDEDhI/AAAAAAAAAaY/cGoTH2DuqdI/s320/3-30-2010+10-33-38+AM.gif" width="320" /></a></div><div><br />
</div><div><br />
<a name='more'></a><br />
</div><div>that's it your cookie is set</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEOseRSrK9kaVZbDHMz7ec-5XwATKJATpRO1pe9St1Vzyln1Hqra3kXrOrgHiCkOIXB_2xPBM8qH4e6j38C7gUHjsdeb-wcIXwGo7ty1ipsc6zeK5RlCwX47wyYDnqNb8CJeu2ddmfNN3m/s1600-h/3-30-2010+10-40-02+AM.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="153" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEOseRSrK9kaVZbDHMz7ec-5XwATKJATpRO1pe9St1Vzyln1Hqra3kXrOrgHiCkOIXB_2xPBM8qH4e6j38C7gUHjsdeb-wcIXwGo7ty1ipsc6zeK5RlCwX47wyYDnqNb8CJeu2ddmfNN3m/s320/3-30-2010+10-40-02+AM.gif" width="320" /></a></div><div>Fiston</div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-9543772595170668582009-07-07T14:56:00.000-07:002009-07-08T06:42:13.225-07:00html/css trick<div style="text-align: left;">I had an issue yesterday with a field that contained a concatenated type code (Type in this report) and a ROW_WID . The report is supposed to show the Type value only:CA instead of CA384639 for the Type field while maintaining the correct subtotal count.</div><div style="text-align: center;"><div style="text-align: left;"><div><span class="Apple-style-span" style="font-size:small;"><br /></span></div><p></p></div></div><div style="text-align: center;"><span class="Apple-style-span" style="font-size:small;"><br /></span></div><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhihA-2899omgcKeCZQo-Y-UEfCXW_OKqcSzDKdTG0NAxuJe-CCB-MKoIuR7Eg7IC_yRMZrA9368RbRWlpk7834j6ayJ3pOOQHJNqdnwZlBj_6tQI9IFqBWSkITNDp8IlzcOyexwgxGtEXX/s1600-h/clip_image002.jpg"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 216px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhihA-2899omgcKeCZQo-Y-UEfCXW_OKqcSzDKdTG0NAxuJe-CCB-MKoIuR7Eg7IC_yRMZrA9368RbRWlpk7834j6ayJ3pOOQHJNqdnwZlBj_6tQI9IFqBWSkITNDp8IlzcOyexwgxGtEXX/s400/clip_image002.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5356076889918461954" /></a><p class="PadderBetweenControlandBody"><span class="Apple-style-span" style="font-size:small;">Substring function to extract the first two letters as follows doesn’t work because the subtotal operation is performed AFTER the substring command is done</span></p><div> <p class="MsoNormal"><o:p><span class="Apple-style-span" style="font-size:small;"> </span></o:p></p> <img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPz6gN-tKJU09LPxZrHMt07n3YUm12mV-cbRwvuJpstT0muBnCdvQHXc2bzkEDNz_EXKwHxs_kiSv6nBSa2VyB9fIeEmJSmC83F-vRE3fF7D1sYm8DEqMP5AdKiw8H2VGdpqPmuJHaUlxs/s400/clip_image003.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5356077249072177826" style="display: block; margin-top: 0px; margin-right: auto; margin-bottom: 10px; margin-left: auto; text-align: center; cursor: pointer; width: 400px; height: 271px; " /><span class="Apple-style-span" style="font-size:small;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhihA-2899omgcKeCZQo-Y-UEfCXW_OKqcSzDKdTG0NAxuJe-CCB-MKoIuR7Eg7IC_yRMZrA9368RbRWlpk7834j6ayJ3pOOQHJNqdnwZlBj_6tQI9IFqBWSkITNDp8IlzcOyexwgxGtEXX/s1600-h/clip_image002.jpg"></a></span><span class="Apple-style-span" style="font-size:small;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhihA-2899omgcKeCZQo-Y-UEfCXW_OKqcSzDKdTG0NAxuJe-CCB-MKoIuR7Eg7IC_yRMZrA9368RbRWlpk7834j6ayJ3pOOQHJNqdnwZlBj_6tQI9IFqBWSkITNDp8IlzcOyexwgxGtEXX/s1600-h/clip_image002.jpg"></a></span><span class="Apple-style-span" style="font-size:small;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhihA-2899omgcKeCZQo-Y-UEfCXW_OKqcSzDKdTG0NAxuJe-CCB-MKoIuR7Eg7IC_yRMZrA9368RbRWlpk7834j6ayJ3pOOQHJNqdnwZlBj_6tQI9IFqBWSkITNDp8IlzcOyexwgxGtEXX/s1600-h/clip_image002.jpg"></a></span><p class="PadderBetweenControlandBody"><span><span class="Apple-style-span" style="font-size:small;">You get then for the first subtotal 1 instead of 2 because even though the aggregation is set to “count distinct” , it's counting 'CA'</span></span></p><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZ7H9Mb6Jzd4sC-I1CkBeudN8gR3GC67NBpPZErpzhfd3WvVWxZwit3OeYok5GAbl24tWBek7k14FzYGc6QN7BP5oS3fBEC9BBclWzS9uKhKMDdOCBusbAMtTg5EZz45UfoMF3Wa3kTaRa/s1600-h/clip_image004.jpg"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZ7H9Mb6Jzd4sC-I1CkBeudN8gR3GC67NBpPZErpzhfd3WvVWxZwit3OeYok5GAbl24tWBek7k14FzYGc6QN7BP5oS3fBEC9BBclWzS9uKhKMDdOCBusbAMtTg5EZz45UfoMF3Wa3kTaRa/s400/clip_image004.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5356078110989085154" style="display: block; margin-top: 0px; margin-right: auto; margin-bottom: 10px; margin-left: auto; text-align: center; cursor: pointer; width: 189px; height: 296px; " /></a><p class="PadderBetweenControlandBody"><span style="font-family:";"><span class="Apple-style-span" style="font-size:small;">The solution we used kind of a kludge but it worked): change the Type data type to “HTML” and using a CSS to hide the WID part, enter the following in the column formula:</span></span></p><p class="PadderBetweenControlandBody"></p><p class="PadderBetweenControlandBody"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEih08nmqhFUGopsF_D1foc4jg0ROLHb0leXPlUV4Oea9TEP1ex-sFrybV-hAt_5IKWdOtMAS8Zor6PPny1a9zuewZFxxSkaWjOae8ldISx0nePniuP8-blC9zF0aknOht7mX0OBROqI8fr4//"><br /><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEih08nmqhFUGopsF_D1foc4jg0ROLHb0leXPlUV4Oea9TEP1ex-sFrybV-hAt_5IKWdOtMAS8Zor6PPny1a9zuewZFxxSkaWjOae8ldISx0nePniuP8-blC9zF0aknOht7mX0OBROqI8fr4//" border="0" alt="" style="display: block; margin-top: 0px; margin-right: auto; margin-bottom: 10px; margin-left: auto; text-align: center; cursor: pointer; width: 600px; height: 100px; " /></a></p><p></p><p></p><p></p><p class="PadderBetweenControlandBody"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8atarEY-6ZkESNTvMLm_buWFKnAuxePzgMm1qR92kFcCsG4EMeLdWIMDpV8ClPCgcfZgbPAN_AOkVycIQjNMYwVxAgPtz6zhJ4Uzi8A99j1pzwTuXRuqixGz6_svSawoY3N8q8f95V8HJ/s1600-h/clip_image005.jpg"><br /><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8atarEY-6ZkESNTvMLm_buWFKnAuxePzgMm1qR92kFcCsG4EMeLdWIMDpV8ClPCgcfZgbPAN_AOkVycIQjNMYwVxAgPtz6zhJ4Uzi8A99j1pzwTuXRuqixGz6_svSawoY3N8q8f95V8HJ/s400/clip_image005.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5356078802111492610" style="display: block; margin-top: 0px; margin-right: auto; margin-bottom: 10px; margin-left: auto; text-align: center; cursor: pointer; width: 400px; height: 274px; " /></a></p><p class="PadderBetweenControlandBody"></p><p style="display:none"> is basically a CSS tag to hide text</p><p class="PadderBetweenControlandBody">And voila you get</p><p class="PadderBetweenControlandBody"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZM8-EGui7yu7JsoqacfUMia3MGwUfUPXcl_wIhk5n0rW7MFtA3Eyn7C4I1RrCMLgF36QoyFOEvopDBEFNz2730Q9zlh1YXKhrMhqh0vPJXm9Q7qpReC96Ao89myl8NRCFgVtgJQ1LrMKS/s1600-h/clip_image006.jpg"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZM8-EGui7yu7JsoqacfUMia3MGwUfUPXcl_wIhk5n0rW7MFtA3Eyn7C4I1RrCMLgF36QoyFOEvopDBEFNz2730Q9zlh1YXKhrMhqh0vPJXm9Q7qpReC96Ao89myl8NRCFgVtgJQ1LrMKS/s400/clip_image006.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5356079166164200994" style="display: block; margin-top: 0px; margin-right: auto; margin-bottom: 10px; margin-left: auto; text-align: center; cursor: pointer; width: 185px; height: 296px; " /></a></p><p class="PadderBetweenControlandBody"><br /></p><p class="PadderBetweenControlandBody"><br /></p><p class="PadderBetweenControlandBody"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZD8zm5skef7NcHOcEdJMTy7YlPoBv-GmkpNFISt8L6H6QNdQYw_vtIQplgsBTjZzkM2uN1cO6BRqs4HqkDkNKKmn10YnL1lbNlQMIQp9IPa39uADAMHgtcgzMuAMTUIzDrJgzRiCz4I0d//"><br /></a></p><div style="text-align: center;"><br /></div><p></p></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-83981274035465207112009-06-12T08:55:00.000-07:002009-06-12T09:19:05.423-07:00OBIEE and Google Chrome<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidhxTGEUdq3UQVUIXn2jGU78jfoRq7iVljfb3iRrrK1fTTj-zY4sjLkgmQOE8sBEj7dFijNPeABpI3RdOH02X00aXF2-3OX0pOh9lt4-EIqJ0oOKim8rfv85PiPmbJ0t22J-BdEAnB9dv8/s1600-h/image.GIF"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 379px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidhxTGEUdq3UQVUIXn2jGU78jfoRq7iVljfb3iRrrK1fTTj-zY4sjLkgmQOE8sBEj7dFijNPeABpI3RdOH02X00aXF2-3OX0pOh9lt4-EIqJ0oOKim8rfv85PiPmbJ0t22J-BdEAnB9dv8/s400/image.GIF" border="0" alt="" id="BLOGGER_PHOTO_ID_5346476291961036722" /></a><br />Answers used to not work correctly with Google Chrome however It looks like that issue has been fixed with the latest release Chrome 2.0.172.31. <div><br /><div><br /><div>Youpi!</div></div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-83046411707542076332009-04-30T08:42:00.000-07:002009-04-30T09:28:08.726-07:00OBIEE Plug-in for Oracle11g OLAP Option availableThe Oracle Business Intelligence Enterprise Edition (OBIEE) Plug-in for Analytic Workspace Manager (AWM) allows you to quickly create an OBIEE repository that will allow the OBIEE Server to query Oracle Database 11g OLAP cubes.<br />Instructions: <a href="http://www.oracle.com/technology/products/bi/olap/11g/awm_plugin/biee/awm_plugin_biee.html">Link </a><br />Download: <a href="http://www.oracle.com/technology/products/bi/olap/11g/awm_plugin/biee/obieeplugin.jar">Link</a><br />Video Demo:<a href="http://download.oracle.com/otndocs/products/warehouse/olap/videos/obiee_plug_in_for_awm/OBIEE_Plugin.html"> Link</a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-17286344594109199182009-04-28T08:26:00.000-07:002009-04-29T09:03:11.535-07:00Left navigation menu (part 2)<div><br /><br /><div>One thing I learned is that when using "link/image" section pointing to a dashboard, securing the dashboard will automatically secure the link e.g let's say user A doesn't have access to the "Security" dashboard then the section containing the link the "Security" dashboard won't be shown to the user. To illustrate this let's create one group for each dashboard</div><br /><br /><div>-HOME<br />-ADMINISTRATION<br />-MY_ACCOUNT<br />-REPORTS</div><br /><div>-SECURITY</div><br /><br /><div><br /></div><br /><br /><p><img id="BLOGGER_PHOTO_ID_5330141607643897122" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 279px; CURSOR: hand; HEIGHT: 243px; TEXT-ALIGN: center" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnTyDEi-gXjkWWG81ZrkxhN1NyhNnpWQ1qpHn2aP2-595keRKH1yemiH0eo-J0NioHvMiZJoSnHTs7wKWPcCsupxPaBqgRc-fMefrrKmAmPPon5CJu-vjoC3NsEfKwmUvr0qu-BQIK53j8/s400/group.gif" border="0" />And let's assign user_a to all the groups except SECURITY and let's assign user_b to all the groups. When user_a login they get the left navigation menu without SECURITY</p><br /><br /><p><img id="BLOGGER_PHOTO_ID_5330143293180415634" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 216px; CURSOR: hand; HEIGHT: 210px; TEXT-ALIGN: center" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg01pgNpRz9_SM2B44E3rwvYqdkj-_gnGHrhrziK_1i2dZQPAzxhHraYSQtFTSOvVLPbdgyRnR-yfR-yFNwDZezAkCODNm8sPaFm9TxcAizKbha6DxeICjlAE5txH9mHaHcFvqwOSG0xHYF/s400/user_a.gif" border="0" />While user_b</p><br /><p>gets all the links:</p><img id="BLOGGER_PHOTO_ID_5330143914460321650" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 213px; CURSOR: hand; HEIGHT: 222px; TEXT-ALIGN: center" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikeHLq9M2SHoTTZWYVi-FB7_nIqBUqgoFU0gbnGbtobClrRzEJ3XzseTZsqQgyNoyQdAUVofiIwNXtueQyRTqO9C1nlpgHhi-6e9TefRkpaLfJRpH46CRXkdMLwGKkF1cUHBsl6GaUAxqb/s400/user_b.gif" border="0" /><br /><p>This is nice, when creating a link to a dashboard using "link/image" one only need to secure the dashboard then the link is secured de facto.<br /><br /></p><br /><br /><div></div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-80429051630821740622009-04-27T12:08:00.000-07:002009-04-28T08:26:35.775-07:00Left navigation menu (part 1)I had a request from a customer to implement a left navigation menu and to disable top navigation links that comes out of the box. I would not recommend this for a large implementation or not at all even...<br />Turns out enabling navigation from the left hand side isn't too hard however securing the links can be tricky...The requirement was to have role based left navigation menu. For example the power user would see for example<br /><div>-Home</div><div>-Administration</div><div>-Manage my account</div><div>-Reports</div><div>-Security</div><div></div><div>and as an ordinary user</div><div>-Home</div><div>-Manage my account </div><div>and so on.</div><br /><br />Another requirement was to have 'widgets' with personalized contents on the "home" dashboard for each user. (I hope to cover this section in the near future)<br /><br /><br />Implementing this is straight forward using the OOT features of OBIEE by basically creating goups/dashboards and assigning users to groups and groups to dashboards.<br /><br />I am going to illustrate one way of achieving this using a left navigation menu:<br /><br /><br />Starting from an empty dashboard I created 5 sections on my dashboard corresponding to the links listed above (refer to screenshot)<br /><img id="BLOGGER_PHOTO_ID_5329461855168096914" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 400px; CURSOR: hand; HEIGHT: 336px; TEXT-ALIGN: center" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPUXmlRdROlO0izfz8WXLOYLUV2z3AGTRkEVY-PGWvXwCjeizSUMDZZnPzxPB5gPrlv4rxQTm14Zeyov-0vJ1ozWKeb6YGwJssLXJ_6NlTebQqyY0AHtPcvUeSlEemnN624q4TWHcQVWIs/s400/sections.JPG" border="0" /><br />Each section content is of the "link/image" type.<br /><br />I am going to create 5 dashboards for illustration: Home,Administration,Manage My Account, Reports, Security and wire each "link/image" to its corresponding Dashboard. For example for home<br /><br /><img id="BLOGGER_PHOTO_ID_5329463921448902850" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 400px; CURSOR: hand; HEIGHT: 193px; TEXT-ALIGN: center" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhuF9PqI9j_rD1tDNFGL5GjJP_KmruqclFb-slUjeauKxJwLA__JJ1BwcKB5-YpWoUthjx6aTvWu69ozqVBAbNceVwk8ai46lBw9HdML40kkm6Yl4FSSLrAMzonyO3YdKjVq6ikYfqUFUQ1/s400/home.JPG" border="0" /><br />Now we have all the links working.<br />I will cover next the security for the left navigation menu<br /><br /><img id="BLOGGER_PHOTO_ID_5329466815808763026" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 400px; CURSOR: hand; HEIGHT: 223px; TEXT-ALIGN: center" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRzHbzJ3j4fZqWOlR3u_thfuoRcDuadh34h8PCMcYfNFUxpN0bYDly4Tm6OfwGx0yf8L4_SBnIcU8hwZfYLABUw6N6SORnrX33zg5ObIjAdK1OgWzpgr8Oap9bZ7KrN5AN6h9tcUBaAUtz/s400/test+dashboard.GIF" border="0" /><br /><br /><br /><br /><br /><br /><br /><div></div><br /><br /><br /><br /><div></div><br /><br /><br /><br /><div></div><br /><br /><br /><br /><div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-5488890384253191562009-04-24T12:07:00.000-07:002009-04-24T12:36:06.588-07:00Add hyperlink to OBIEE Login Page<div><br /><br /><div><br /><br /><br /><div><a href="http://3.bp.blogspot.com/_Nw7buz4M69c/SfISb2VzkvI/AAAAAAAAAPo/8J6whTnlUc0/s1600-h/LinkNo.png"><img id="BLOGGER_PHOTO_ID_5328341578785460978" style="WIDTH: 320px; CURSOR: hand; HEIGHT: 267px" alt="" src="http://3.bp.blogspot.com/_Nw7buz4M69c/SfISb2VzkvI/AAAAAAAAAPo/8J6whTnlUc0/s320/LinkNo.png" border="0" /></a><br /><br /><br /></div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8mk0eHgJSo_osNsUhZDKZlm3Cpn4KIL0CftwtQf2qUfuKWNLuWbEg9Z3-U-R8nobvU6xBj9dbSTXY-lNTohCfk5FtQGAm8GhL9UidRZdXcsMiAr1f3RoAE4qCNbHLZP4PJRljCOmlmwCn/s1600-h/Link.png"></a><br /><div><br /><br /><br /></div><br /><div>I had a requirement to add a link to the OBIEE Login page. This hyperlink points to an app for resetting password in this particular case. Here is how it's done:</div><div>In the utilmessages.xml in</div><div>OracleBI\web\msgdb\l_en\messages</div><div>Locate the <webmessage name="kmsgNQuireLegalCopyright">tag</div>"kmsgNQuireLegalCopyright"<br /><div>add the link below the text as illustrated in the picture</div><img id="BLOGGER_PHOTO_ID_5328342991169472994" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 421px; CURSOR: hand; HEIGHT: 109px; TEXT-ALIGN: center" alt="" src="http://2.bp.blogspot.com/_Nw7buz4M69c/SfITuD4ZSeI/AAAAAAAAAP4/6Oduep4LFg0/s400/Wemessage.png" border="0" /><br /><div>Restart your BI server and Presentation server :<br /></div><img id="BLOGGER_PHOTO_ID_5328343445473792530" style="DISPLAY: block; MARGIN: 0px auto 10px; WIDTH: 400px; CURSOR: hand; HEIGHT: 361px; TEXT-ALIGN: center" alt="" src="http://2.bp.blogspot.com/_Nw7buz4M69c/SfIUIgS_EhI/AAAAAAAAAQA/fZaXCUInA1Y/s400/LinkYes.png" border="0" /><br /><br /><div></div><br /><div><br /></div><br /><p align="left"> </p><br /><div><br /></div><br /><div></div><br /><div><br /><br /> </div><div></div><br /><div><br /><br /><div><br /><br /></div><br /><br /><br /><div></div><br /><br /><br /><div><br /><br /><br /></div><br /><br /><br /><div></div></div></div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-8879294908838500170.post-25305856359565768962009-04-24T06:49:00.001-07:002009-04-24T07:16:45.830-07:00Remove OBIEE version from Login page<div>I had a requirement to remove the BIEE version from the login page. Following is how it was done, let me know if you have another approach for this.<br />Make a backup of logoncontrolmessages.xml located in<br />OracleBI\web\msgdb\messages<br />and locate and remove the second occurence of sawm:param insert="2" / </div><br /><div>as illustrated below</div><br /><div></div><br /><div></div><a href="http://4.bp.blogspot.com/_Nw7buz4M69c/SfHJkueOR9I/AAAAAAAAAPQ/v8TdKEe1sHU/s1600-h/biee_version.JPG"><img id="BLOGGER_PHOTO_ID_5328261466943277010" style="WIDTH: 388px; CURSOR: hand; HEIGHT: 195px" alt="" src="http://4.bp.blogspot.com/_Nw7buz4M69c/SfHJkueOR9I/AAAAAAAAAPQ/v8TdKEe1sHU/s320/biee_version.JPG" border="0" /></a><br /><div>Reboot your BI server and presentation service.</div><div>HTH</div>Unknownnoreply@blogger.com