tag:blogger.com,1999:blog-91824424865366720822024-03-21T15:23:16.136-04:00The Big Data - Business Intelligence by Sandeep Venutesthttp://www.blogger.com/profile/14999529395242178412noreply@blogger.comBlogger176125tag:blogger.com,1999:blog-9182442486536672082.post-31670214935112530132018-04-27T16:27:00.000-04:002018-04-27T16:27:36.917-04:00CSS IMAGE ANIMATION -ON CLICK POP UP<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi944layUe8xErEGGn8xkfw46eb29_PakBdVvtIJgtdxF0ZU2VbwQ5cc467zH5rGqk1vSW7vCs4hKjr6MDK3rdfzAOw_AMGCBiMIYdiydhIuamFhNsKfCQcojDQzO5FD5K0Cjo022_pv9E/s1600/OBIEE_IMAGE_SANDEEP.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="553" data-original-width="600" height="294" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi944layUe8xErEGGn8xkfw46eb29_PakBdVvtIJgtdxF0ZU2VbwQ5cc467zH5rGqk1vSW7vCs4hKjr6MDK3rdfzAOw_AMGCBiMIYdiydhIuamFhNsKfCQcojDQzO5FD5K0Cjo022_pv9E/s320/OBIEE_IMAGE_SANDEEP.gif" width="320" /></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/AVvXsEhtTiM_8CwLib5TpEf1yKdYy5ozSqBRqwIITrqeqwvZcSqsxAVvWLBpkz7YxLpMXfx6gGKedpzyZDzsgPsPZcNQ_LRSEKu8ToSYRXgxY3ehS_WuUzVLfg42caBCUei8GzZdJSUo4SnE70w/s1600/image_popup.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="866" data-original-width="934" height="296" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtTiM_8CwLib5TpEf1yKdYy5ozSqBRqwIITrqeqwvZcSqsxAVvWLBpkz7YxLpMXfx6gGKedpzyZDzsgPsPZcNQ_LRSEKu8ToSYRXgxY3ehS_WuUzVLfg42caBCUei8GzZdJSUo4SnE70w/s320/image_popup.png" width="320" /></a></div>
<br />
<br />
<br />
<br />
<!DOCTYPE html><br />
<html><br />
<head><br />
<style><br />
#myImg {<br />
border-radius: 5px;<br />
cursor: pointer;<br />
transition: 0.3s;<br />
}<br />
<br />
#myImg:hover {opacity: 0.7;}<br />
<br />
/* The Modal (background) */<br />
.modal {<br />
display: none; /* Hidden by default */<br />
position: fixed; /* Stay in place */<br />
z-index: 1; /* Sit on top */<br />
padding-top: 100px; /* Location of the box */<br />
left: 0;<br />
top: 0;<br />
width: 100%; /* Full width */<br />
height: 100%; /* Full height */<br />
overflow: auto; /* Enable scroll if needed */<br />
<br />
<br />
}<br />
<br />
/* Modal Content (image) */<br />
.modal-content {<br />
margin: auto;<br />
display: block;<br />
width: 80%;<br />
max-width: 700px;<br />
}<br />
<br />
/* Caption of Modal Image */<br />
#caption {<br />
margin: auto;<br />
display: block;<br />
width: 80%;<br />
max-width: 700px;<br />
text-align: center;<br />
color: #ccc;<br />
padding: 10px 0;<br />
height: 150px;<br />
}<br />
<br />
/* Add Animation */<br />
.modal-content, #caption { <br />
-webkit-animation-name: zoom;<br />
-webkit-animation-duration: 0.6s;<br />
animation-name: zoom;<br />
animation-duration: 0.6s;<br />
}<br />
<br />
@-webkit-keyframes zoom {<br />
from {-webkit-transform:scale(0)}<br />
to {-webkit-transform:scale(1)}<br />
}<br />
<br />
@keyframes zoom {<br />
from {transform:scale(0)}<br />
to {transform:scale(1)}<br />
}<br />
<br />
/* The Close Button */<br />
.close {<br />
<br />
top: 200px;<br />
right: 100px;<br />
left: 500px;<br />
color: #000000;<br />
font-size: 200px;<br />
font-weight: bold;<br />
transition: 0.3s;<br />
}<br />
<br />
.close:hover,<br />
.close:focus {<br />
color: #bbb;<br />
text-decoration: none;<br />
cursor: pointer;<br />
}<br />
<br />
/* 100% Image Width on Smaller Screens */<br />
@media only screen and (max-width: 700px){<br />
.modal-content {<br />
width: 100%;<br />
}<br />
}<br />
</style><br />
</head><br />
<body><br />
<br />
<br />
<img id="myImg" src="http://i64.tinypic.com/207145l.jpg" alt="US Regions" width="300" height="200"><br />
<br />
<!-- The Modal --><br />
<div id="myModal" class="modal"><br />
<span class="close">&times;</span><br />
<img class="modal-content" id="img01"><br />
<div id="caption"></div><br />
</div><br />
<br />
<script><br />
// Get the modal<br />
var modal = document.getElementById('myModal');<br />
<br />
<br />
var img = document.getElementById('myImg');<br />
var modalImg = document.getElementById("img01");<br />
var captionText = document.getElementById("caption");<br />
img.onclick = function(){<br />
modal.style.display = "block";<br />
modalImg.src = this.src;<br />
captionText.innerHTML = this.alt;<br />
}<br />
<br />
<br />
var span = document.getElementsByClassName("close")[0];<br />
<br />
<br />
span.onclick = function() {<br />
modal.style.display = "none";<br />
}<br />
</script><br />
<br />
</body><br />
</html><br />
<div>
<br /></div>
<div>
<br /></div>
</div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-43005614566691981092018-01-23T09:07:00.000-05:002018-01-23T09:09:58.719-05:00Business Days in Current Month [Excluding Sat Sun]<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
You can use the following SQL to get the number of working days (not including sat and sun) of the current month<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4Lq3CTQm-ausdDE1icxmjswUy4bvudlRhbiQjkcopZTx18jaAFKQqSKEQxCkoZ9eNbE78OnQXlaSLMqjSbWBD9slgxPGWsiegYm74_216Gwrfwm_9H-22K1hm9QwJ25v17ESz8EYZznM/s1600/calendar.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="300" data-original-width="400" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4Lq3CTQm-ausdDE1icxmjswUy4bvudlRhbiQjkcopZTx18jaAFKQqSKEQxCkoZ9eNbE78OnQXlaSLMqjSbWBD9slgxPGWsiegYm74_216Gwrfwm_9H-22K1hm9QwJ25v17ESz8EYZznM/s320/calendar.jpg" width="320" /></a></div>
<br />
<br />
<div>
<table align="left" cellpadding="0" cellspacing="0" hspace="0" vspace="0">
<tbody>
<tr>
<td align="left" style="padding-bottom: 0in; padding-left: 9.0pt; padding-right: 9.0pt; padding-top: 0in;" valign="top"><div class="MsoNormal">
<i>SELECT COUNT(TRUNC(SYSDATE,'MM') +(LEVEL-1)) AS BUSINESS_DAYS_IN_MT</i></div>
<div class="MsoNormal">
<i><br /></i></div>
<div class="MsoNormal">
<i>FROM DUAL</i></div>
<div class="MsoNormal">
<i><br /></i></div>
<div class="MsoNormal">
<i>WHERE TO_CHAR(TRUNC(SYSDATE,'MM') +(LEVEL-1),'D') NOT IN (1,7)</i></div>
<div class="MsoNormal">
<i><br /></i></div>
<div class="MsoNormal">
<i>CONNECT BY LEVEL <=LAST_DAY(SYSDATE)- TRUNC(SYSDATE,'MM') + 1</i><br />
<i><br /></i>
<i><br /></i>
<i>Add this as a REPOSITORY VARIABLE and can be use in the reports for calculations</i></div>
</td></tr>
</tbody></table>
</div>
</div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-46041984848061085912018-01-14T11:55:00.002-05:002018-01-14T11:55:59.126-05:00Heat Map using Google API - OBIEE 11G,12C.<div dir="ltr" style="text-align: left;" trbidi="on">
Hi All,<br />
<br />
Wanted to share the steps that you can do to create a dynamic heat map to mark Geo coordinates on google map. The heat map colors can be configured to be dynamic.<br />
<br />
This Example shown below uses latitude and longitudes and and Google API<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqYWHmRL-ByftICR8ogoZ_z5HOLg4Z6eTf0fAagtUrY8UiC-IcVyrMtfGMUW6CyQFYprwdHdzbRG9Q58zAHwBX4yFxQfEPkf_O3NnLeAX3yldLJODBueHnevjV-TOQBtWsY6oVeGIyU4M/s1600/3.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="547" data-original-width="771" height="283" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqYWHmRL-ByftICR8ogoZ_z5HOLg4Z6eTf0fAagtUrY8UiC-IcVyrMtfGMUW6CyQFYprwdHdzbRG9Q58zAHwBX4yFxQfEPkf_O3NnLeAX3yldLJODBueHnevjV-TOQBtWsY6oVeGIyU4M/s400/3.PNG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<br />
<br />
Step 1 :<br />
<br />
Create a report analysis to have Latitude and Longitudes as shown below.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEha6U8VgEJXW0h9L7A5spYsyWwkKegAmAI8koNEhkQQVXlci3dOBsohrsLLgA0P_U5pciI-dZ280syRY0r3FRhvuqrNYRgEynj-KD4UvunV_q4lw4yFr8IjYYRNkUaNfjSXG4dKDC2NEz4/s1600/1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="183" data-original-width="599" height="97" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEha6U8VgEJXW0h9L7A5spYsyWwkKegAmAI8koNEhkQQVXlci3dOBsohrsLLgA0P_U5pciI-dZ280syRY0r3FRhvuqrNYRgEynj-KD4UvunV_q4lw4yFr8IjYYRNkUaNfjSXG4dKDC2NEz4/s320/1.PNG" width="320" /></a></div>
<br />
Note: The order of the column needs to be noted as that would be used in the data array .<br />
<br />
Step 2 : Get a google maps API key<br />
<br />
You need to get a Google Map API key for yourself. Use the below link to get one<br />
<br />
<a href="https://developers.google.com/maps/documentation/javascript/get-api-key">https://developers.google.com/maps/documentation/javascript/get-api-key</a><br />
<br />
<br />
Step 3 : Create Static view with the map html code and then use a narrative view to call the data array.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpJGIM5xByA6nlehxyYyMv7NS6NRLyjViShWiBmdgGEqCsUmOMzdkthh5Mjj9_fa3INohTnAvunSxIXI35xuXdOXB4r0ufeiDb9D1NuewDnpt7DkDOr1A5fmqwh4gdEMYyA6yPWc86hKY/s1600/4.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="483" data-original-width="818" height="235" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpJGIM5xByA6nlehxyYyMv7NS6NRLyjViShWiBmdgGEqCsUmOMzdkthh5Mjj9_fa3INohTnAvunSxIXI35xuXdOXB4r0ufeiDb9D1NuewDnpt7DkDOr1A5fmqwh4gdEMYyA6yPWc86hKY/s400/4.PNG" width="400" /></a></div>
<br />
<br />
Static code is as below:<br />
<br />
<i><span style="color: red;"><DIV id=map style="width:750px;height:500px;padding:10px;border:0px solid grey;"></DIV></span></i><br />
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;"><script src="http://maps.google.com/maps/api/js?key=<span style="background-color: yellow;">YOURKEYHERE</span>"></script></span></i><br />
<i><span style="color: red;"><script src='/mapviewer/jslib/v2/oraclemapsv2.js'></script></span></i><br />
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;"><script></span></i><br />
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;">function addPoints(darray,layer){</span></i><br />
<i><span style="color: red;"> /*lat,long,estb,metric*/</span></i><br />
<i><span style="color: red;"> for (i=0;i<darray.length; i++){</span></i><br />
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;"> <span style="white-space: pre;"> </span>var fid = i;</span></i><br />
<i><span style="color: red;"> <span style="white-space: pre;"> </span>var mpoint = new OM.geometry.Point(darray[i][1], darray[i][0],8307);</span></i><br />
<i><span style="color: red;"> <span style="white-space: pre;"> </span>var f_attr = {attributes :{"_LABEL_":darray[i][2], "Sales":darray[i][3]+""}};</span></i><br />
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;"> <span style="white-space: pre;"> </span>var feature = new OM.Feature(fid,mpoint,f_attr); </span></i><br />
<i><span style="color: red;"> <span style="white-space: pre;"> </span>layer.addFeature(feature);</span></i><br />
<i><span style="color: red;"> <span style="white-space: pre;"> </span>}</span></i><br />
<i><span style="color: red;">}</span></i><br />
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;">function renderHeatMap(darray){</span></i><br />
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;"> var baseURL= "http://"+document.location.host+"/mapviewer";</span></i><br />
<i><span style="color: red;"> var map = new OM.Map(document.getElementById('map'), {mapviewerURL: baseURL}) ;</span></i><br />
<i><span style="color: red;"> map.addLayer(new OM.layer.ElocationTileLayer("background")) ; </span></i><br />
<i><span style="color: red;"> </span></i><br />
<i><span style="color: red;"> var colors = ["#C6DBEF","#6BAED6","#008fff","#00abff","#00d5ff","#00ffff","#00ff7f","#00ff00","#7fff00","#ffff00","#ffd500","#ffab00","#ff7f00","#ff5600","#ff2b00", "#ff0000", "#A50F15"];</span></i><br />
<i><span style="color: red;"> var config = {</span></i><br />
<i><span style="color: red;"> spotlightRadius:25,</span></i><br />
<i><span style="color: red;"> lengthUnit:'pixel',</span></i><br />
<i><span style="color: red;"> colorStops: colors,</span></i><br />
<i><span style="color: red;"> opacity:0.65, </span></i><br />
<i><span style="color: red;"> sampleFactor: 4 </span></i><br />
<i><span style="color: red;"> };</span></i><br />
<i><span style="color: red;"> var style = new OM.style.HeatMap(config);</span></i><br />
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;">var tileLayer = new OM.layer.GoogleTileLayer(</span></i><br />
<i><span style="color: red;"> "baseMap",</span></i><br />
<i><span style="color: red;"> {</span></i><br />
<i><span style="color: red;"> mapTypeList:"OM.layer.GoogleTileLayer.TYPE_ROAD;OM.layer.GoogleTileLayer.TYPE_SATELLITE; OM.layer.GoogleTileLayer.TYPE_SHADED",</span></i><br />
<i><span style="color: red;"> mapTypeVisible:true,</span></i><br />
<i><span style="color: red;"> libURL:"http://maps.google.com/maps/api/js?key=AIzaSyDb7pXGVGqsVz9yVyZ86fwi-3PU5_faqMU"</span></i><br />
<i><span style="color: red;"> });</span></i><br />
<i><span style="color: red;"> map.addLayer(tileLayer);</span></i><br />
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;"> var heatLayer = new OM.layer.VectorLayer("heatlayer",{</span></i><br />
<i><span style="color: red;"> def:</span></i><br />
<i><span style="color: red;"> {</span></i><br />
<i><span style="color: red;"> type: OM.layer.VectorLayer.TYPE_LOCAL</span></i><br />
<i><span style="color: red;"> },</span></i><br />
<i><span style="color: red;"> renderingStyle :style</span></i><br />
<i><span style="color: red;"><span style="white-space: pre;"> </span> //styleAttributes:["METRIC"]</span></i><br />
<i><span style="color: red;"> });</span></i><br />
<i><span style="color: red;"> addPoints(darray,heatLayer);</span></i><br />
<i><span style="color: red;"> map.addLayer(heatLayer);</span></i><br />
<i><span style="color: red;"> </span></i><br />
<i><span style="color: red;"> var marker = new OM.style.Marker({src: "/mapviewer/icons/BALL_sel.png", width:7, height:7}); </span></i><br />
<i><span style="color: red;"> var pLayer = new OM.layer.VectorLayer("pointlayer",{</span></i><br />
<i><span style="color: red;"> def:</span></i><br />
<i><span style="color: red;"> {</span></i><br />
<i><span style="color: red;"> type: OM.layer.VectorLayer.TYPE_LOCAL</span></i><br />
<i><span style="color: red;"> },</span></i><br />
<i><span style="color: red;"> renderingStyle : marker</span></i><br />
<i><span style="color: red;"> });</span></i><br />
<i><span style="color: red;"> addPoints(darray,pLayer);</span></i><br />
<i><span style="color: red;"> map.addLayer(pLayer);</span></i><br />
<i><span style="color: red;"> //pLayer.setVisible(true);</span></i><br />
<i><span style="color: red;"> if ('@{pLayer_flag}'=='No') pLayer.setVisible(false);</span></i><br />
<i><span style="color: red;"> map.addMapDecoration(new OM.control.NavigationPanelBar({ style:1 }));</span></i><br />
<i><span style="color: red;"> var mpoint = new OM.geometry.Point(-100.295335,40.44399,8307);</span></i><br />
<i><span style="color: red;"> map.setMapCenter(mpoint);</span></i><br />
<i><span style="color: red;"> map.setMapZoomLevel(3) ; </span></i><br />
<i><span style="color: red;"> var copyright = new OM.control.CopyRight({</span></i><br />
<i><span style="color: red;"> anchorPosition:3,</span></i><br />
<i><span style="color: red;"> textValue:"©2014 Google Map data ©2013 USA",</span></i><br />
<i><span style="color: red;"> fontSize:9,</span></i><br />
<i><span style="color: red;"> fontFamily:"Tahoma",</span></i><br />
<i><span style="color: red;"> fontColor:"black"</span></i><br />
<i><span style="color: red;"> }); </span></i><br />
<i><span style="color: red;"> map.addMapDecoration(copyright); </span></i><br />
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;"> map.init();</span></i><br />
<i><span style="color: red;">}</span></i><br />
<i><span style="color: red;"></script></span></i><br />
<br />
<br />
Step 4 : Add a Narrative view<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRV6-q5UlioIU_pDKeeaiMm3mQJWwcE8QrEX8Wsx1q0nAz0gYh2SNnu1gczGYCp_DFH8meC6tcbqVxt-15a8zqNQspVSuopKc1QSMNClq5Qg7px49k_PwiL5499CHx-YngbrgzYjvNpaE/s1600/5.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="368" data-original-width="755" height="193" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRV6-q5UlioIU_pDKeeaiMm3mQJWwcE8QrEX8Wsx1q0nAz0gYh2SNnu1gczGYCp_DFH8meC6tcbqVxt-15a8zqNQspVSuopKc1QSMNClq5Qg7px49k_PwiL5499CHx-YngbrgzYjvNpaE/s400/5.PNG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<b><u>Prefix:</u></b></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both;">
<span style="color: blue;"><script></span></div>
<div class="separator" style="clear: both;">
<span style="color: blue;">var darray= [];</span></div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
<b><u>Narrative: </u></b></div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
<span style="color: blue;">darray.push([@1,@2,"@3",@4]);</span></div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
<b><u>Postfix</u></b></div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
<span style="color: blue;">renderHeatMap(darray);</span></div>
<div class="separator" style="clear: both;">
<span style="color: blue;"></script></span></div>
<div class="separator" style="clear: both;">
<span style="color: blue;"><br /></span></div>
<div class="separator" style="clear: both;">
Add the static text and the narrative view to the compound layout as shown below</div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
This completes the steps, if you dont see the maps in the result view then click the PREVIEW option to check the maps.</div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0oUQoFvhAVyg_Hr6WMI8YIVt5TyPXiANtNxmvvr9qlVWb7Vhklz2pC8Vd4Nt-mlbnd0Sh72eq3H8PphG3D64jD-WaqxdB9_670Q0qyJZsPtQV9s-jhYSWJsNChe2bK00vXOprCtifKwo/s1600/2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="534" data-original-width="771" height="276" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0oUQoFvhAVyg_Hr6WMI8YIVt5TyPXiANtNxmvvr9qlVWb7Vhklz2pC8Vd4Nt-mlbnd0Sh72eq3H8PphG3D64jD-WaqxdB9_670Q0qyJZsPtQV9s-jhYSWJsNChe2bK00vXOprCtifKwo/s400/2.PNG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Thanks, if you have any question then post your questions here.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
<br /></div>
<br /></div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-28288672254737659162017-07-20T11:45:00.001-04:002017-07-20T11:45:44.974-04:00OBIEE Prompt for BIP Report - Passing Multiple Values along with Passing All Values<div dir="ltr" style="text-align: left;" trbidi="on">
For the OBIEE prompts to be used for BIP reports and to pass (All Column Values) and also multi select you can use the following SQL in the datamodel<br />
<br />
In this, you can lease the prompts defaulted to 'Null' or blank and the variable will pass this null values to the BIP report and will return all the available results<br />
<br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkQMAZR5HjhKJoUTm3x7BKimBTFfMKJBlXt1Ahjlq4Wq2KZDvz1XkomSums4Mvl7PBstmZk29VEqJZ7ly9_YNl22-ktssPkES6R4dxZ5IY_LLm8JOCI2Lsu4Jm4X_3s8junCj3DZS5-wQ/s1600/bip+prompt.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="444" data-original-width="932" height="152" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkQMAZR5HjhKJoUTm3x7BKimBTFfMKJBlXt1Ahjlq4Wq2KZDvz1XkomSums4Mvl7PBstmZk29VEqJZ7ly9_YNl22-ktssPkES6R4dxZ5IY_LLm8JOCI2Lsu4Jm4X_3s8junCj3DZS5-wQ/s320/bip+prompt.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3dfKl5K4Ptif3JxxgLEw0g924GuSJIWlO8hMKcflBP-Y_8WMKkACVd4LUgnxf1IgTq2HqWqPqey5jyY769ugY5q-2qNm7tUVFseJPFuGqWZpQDACnEtM9RJYx9M1jSwaDy_pDGVYrF-Q/s1600/DASHBAORED.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="478" data-original-width="534" height="286" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3dfKl5K4Ptif3JxxgLEw0g924GuSJIWlO8hMKcflBP-Y_8WMKkACVd4LUgnxf1IgTq2HqWqPqey5jyY769ugY5q-2qNm7tUVFseJPFuGqWZpQDACnEtM9RJYx9M1jSwaDy_pDGVYrF-Q/s320/DASHBAORED.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5EU5wS9Hus7LzMOP9P2B5M_LrCniYOerFg49yqh2Rd93PKmKoGQvryLeZFpuRIYI0u3HoPbWpIgvN6WWGJnifW1Q-BICLB8xFb85n0WwNwebuNWV4_9AVzwIPijWQ4i6K6RWWvMZT9Yg/s1600/Datamodel.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="542" data-original-width="859" height="201" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5EU5wS9Hus7LzMOP9P2B5M_LrCniYOerFg49yqh2Rd93PKmKoGQvryLeZFpuRIYI0u3HoPbWpIgvN6WWGJnifW1Q-BICLB8xFb85n0WwNwebuNWV4_9AVzwIPijWQ4i6K6RWWvMZT9Yg/s320/Datamodel.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSLtUhtERanZrstsbOHfI2uLd0Q8czNIKK3W_yPrqHDRUIxxUDEQVf3PtkDXfZEkzLxggoE_HcNm2PR_aqlRB8ePhmAaKbcLcmCtUJto3qAJd6hDGKVbQWCp0dmMqtyzfXQpRMUrlwV5c/s1600/Multi+Select.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="433" data-original-width="505" height="273" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSLtUhtERanZrstsbOHfI2uLd0Q8czNIKK3W_yPrqHDRUIxxUDEQVf3PtkDXfZEkzLxggoE_HcNm2PR_aqlRB8ePhmAaKbcLcmCtUJto3qAJd6hDGKVbQWCp0dmMqtyzfXQpRMUrlwV5c/s320/Multi+Select.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;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="text-align: left;">Hope this help some of you folks..</span></div>
<br /></div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-23169768811853435772017-03-06T13:59:00.000-05:002017-03-06T13:59:01.018-05:00Display Previous N period in MON-YY format<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
SELECT TO_CHAR(ADD_MONTHS(SYSDATE, -level), 'MON-YY') AS Previous_Period<br />
FROM dual<br />
CONNECT BY LEVEL < 5<br />
order by (TO_CHAR(ADD_MONTHS(SYSDATE, -level), 'YYYYMM')) desc<br />
<div>
<br /></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8tpkxuvzT1Cn9FwWuEaOzUp_yoMz4ijLBk1CjTW3r00K_LA-0xKdM9_P9rE0QmsYZ-Bp9WNbm4pa_h3qZUfSWJPSQ1PCTwJshqalMQFK3rnhMjPisPQy-3MeUWC3fWz1R_8-jzSuL0P8/s1600/Previous+Periods+BIP.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="256" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8tpkxuvzT1Cn9FwWuEaOzUp_yoMz4ijLBk1CjTW3r00K_LA-0xKdM9_P9rE0QmsYZ-Bp9WNbm4pa_h3qZUfSWJPSQ1PCTwJshqalMQFK3rnhMjPisPQy-3MeUWC3fWz1R_8-jzSuL0P8/s640/Previous+Periods+BIP.PNG" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5oclASMcwHok_acRZAnHe8gqmS7Cu4mRCZA2z998jp9-6b-cSPF8iUPWVYQmTXF7zmLJlpEor2t6xls4WKowYY73Qv4sEho5yf8EN-WHCZ2Hom9l6ev9Yp1NH9-0ynklWKKsXjY-Tghw/s1600/Results.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="278" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5oclASMcwHok_acRZAnHe8gqmS7Cu4mRCZA2z998jp9-6b-cSPF8iUPWVYQmTXF7zmLJlpEor2t6xls4WKowYY73Qv4sEho5yf8EN-WHCZ2Hom9l6ev9Yp1NH9-0ynklWKKsXjY-Tghw/s640/Results.PNG" width="640" /></a></div>
<div>
<br /></div>
</div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-84041573006234994372016-08-12T17:15:00.001-04:002016-08-12T17:17:21.044-04:00Informatica MDM - A brief Introduction<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/AVvXsEgWycB5M_nknOs5314kwGn_ku98Dt68oeSsha48sp_7HBRER5jw5pIcN6NIOg1663yfU00gj58RF-DCM9ri0jzeNA8f8p1ju_lhVsLxez0jR1LNwbO2n_pkcJ9AWkBHakrLDE7mMaWVOeE/s1600/MDM-logo-final-NEW-545x675.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="370" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWycB5M_nknOs5314kwGn_ku98Dt68oeSsha48sp_7HBRER5jw5pIcN6NIOg1663yfU00gj58RF-DCM9ri0jzeNA8f8p1ju_lhVsLxez0jR1LNwbO2n_pkcJ9AWkBHakrLDE7mMaWVOeE/s400/MDM-logo-final-NEW-545x675.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;">
<br /></div>
<span style="background-color: white; color: #222222; font-family: "roboto" , sans-serif; font-size: 35px; line-height: 45.5px;"><a href="https://mdmlive.blogspot.com/2016/08/what-is-tokenization-process.html" target="_blank">Tokenization process in Informatica MDM?</a></span><br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<span style="background-color: white; color: #222222; font-family: "roboto" , sans-serif; font-size: 35px; line-height: 45.5px;"><br /></span>
<span style="background-color: white; color: #222222; font-family: "roboto" , sans-serif; font-size: 35px; line-height: 45.5px;"><a href="https://mdmlive.blogspot.com/2016/08/how-to-create-basic-mapping-in.html" target="_blank">How to create a basic Mapping in Informatica MDM?</a></span><br />
<br />
<br />
<span style="background-color: white; color: #222222; font-family: "roboto" , sans-serif; font-size: 35px; line-height: 45.5px;"><a href="https://mdmlive.blogspot.com/2016/08/how-to-unmerge-records-in-informatica.html" target="_blank">How to Unmerge records in Informatica MDM?</a></span><br />
<span style="background-color: white; color: #222222; font-family: "roboto" , sans-serif; font-size: 35px; line-height: 45.5px;"><br /></span>
<span style="background-color: white; color: #222222; font-family: "roboto" , sans-serif; font-size: 35px; line-height: 45.5px;"><br /></span>
<span style="background-color: white; color: #222222; font-family: "roboto" , sans-serif; font-size: 35px; line-height: 45.5px;"><br /></span>testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-50009375472825196422016-05-09T12:24:00.000-04:002016-05-09T12:24:01.937-04:00Real Time Data warehousing or Low latency Data modelling <div dir="ltr" style="text-align: left;" trbidi="on">
<br /></div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-35610466534757630212016-05-09T12:10:00.002-04:002016-05-09T15:28:30.266-04:00How to handle Early Arriving Facts and Late Dimension in ODI<div dir="ltr" style="text-align: left;" trbidi="on">
Hi All, I read an article in the Oracle Blogs about implementing the early arriving facts or late dimensions and this is a re creation of that in my local server.<br />
<br />
This is the idea.<br />
<br />
In certain cases the fact record will be available but there will not any details of the respective dimensions (Dimension ROW_WID will be null).<br />
<br />
In this case we will use a database function to create a row_wid for the dimension and use that to populate the dimension row_wid.<br />
<br />
Once the customer details are available in the source application the dimension detailed are filled up via type 2 or type 1 load.<br />
<br />
Alright so here is how it is done.<br />
<br />
<br />
<br />
<u><b>Step 1 : Create a default value table :</b></u><br />
<br />
<span style="color: red;">CREATE TABLE "W_DEFAULT_VALUES"</span><br />
<span style="color: red;"> (</span><br />
<span style="color: red;"> "UNKNOWN_CD" VARCHAR2(20 BYTE),</span><br />
<span style="color: red;"> "UNKNOWN_DESC" VARCHAR2(50 BYTE),</span><br />
<span style="color: red;"> "TYPE_2_CURRENT_FLG" NUMBER,</span><br />
<span style="color: red;"> "TYPE_2_END_DT" DATE</span><br />
<span style="color: red;"> );</span><br />
<span style="color: red;"><br /></span>
<span style="color: red;">REM INSERTING into W_DEFAULT_VALUES</span><br />
<span style="color: red;">Insert into W_DEFAULT_VALUES (UNKNOWN_CD,UNKNOWN_DESC,TYPE_2_CURRENT_FLG,TYPE_2_END_DT) values ('NA','Not Applicable',1,to_date('01-01-2400 00:00:00','MM-DD-YYYY HH24:MI:SS'));</span><br />
<div>
<br /></div>
<br />
<b><u>Step 2: Create a db function </u></b><br />
<br />
To create the Warehouse for Surrogate key for the missing dimension by taking in the Natural key of the dimension. This function needs to be triggered only when a late arriving dimension is detected.<br />
<br />
PS: I have used the function from the Oracle blog that was available online.<br />
-------------------------------------------------------------------------------<br />
<i><span style="color: red;">create or replace</span></i><br />
<i><span style="color: red;">PACKAGE LATE_DIMS</span></i><br />
<i><span style="color: red;">AS</span></i><br />
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;">FUNCTION D_CUSTOMER_DIM( IN_CUSTOMER_ID IN NUMBER )</span></i><br />
<i><span style="color: red;"> RETURN NUMBER;</span></i><br />
<i><span style="color: red;"> </span></i><br />
<i><span style="color: red;">FUNCTION D_PRODUCT_DIM( IN_PRODUCT_ID IN VARCHAR2 )</span></i><br />
<i><span style="color: red;"> RETURN NUMBER;</span></i><br />
<i><span style="color: red;"> </span></i><br />
<i><span style="color: red;">END LATE_DIMS;</span></i><br />
<i><span style="color: red;">/</span></i><br />
<i><span style="color: red;">-------------------------------------------------------------------------------</span></i><br />
<i><span style="color: red;">create or replace</span></i><br />
<i><span style="color: red;">PACKAGE BODY LATE_DIMS AS</span></i><br />
<i><span style="color: red;">FUNCTION D_CUSTOMER_DIM(IN_CUSTOMER_ID IN NUMBER )RETURN NUMBER</span></i><br />
<i><span style="color: red;">AS</span></i><br />
<i><span style="color: red;"> C_WAREHOUSE_ID NUMBER;</span></i><br />
<i><span style="color: red;">BEGIN</span></i><br />
<i><span style="color: red;"> C_WAREHOUSE_ID := SEQ_W_CUSTOMER_D.nextval;</span></i><br />
<i><span style="color: red;"> INSERT INTO W_CUSTOMER_D</span></i><br />
<i><span style="color: red;"> (</span></i><br />
<i><span style="color: red;"> ROW_WID,</span></i><br />
<i><span style="color: red;"> CUST_ID,</span></i><br />
<i><span style="color: red;"> CUST_TYPE,</span></i><br />
<i><span style="color: red;"> CUST_NAME,</span></i><br />
<i><span style="color: red;"> ADDRESS,</span></i><br />
<i><span style="color: red;"> CITY,</span></i><br />
<i><span style="color: red;"> STATE,</span></i><br />
<i><span style="color: red;"> START_DT,</span></i><br />
<i><span style="color: red;"> END_DT,</span></i><br />
<i><span style="color: red;"> CURRENT_FLAG,</span></i><br />
<i><span style="color: red;"> CREATED_DT,</span></i><br />
<i><span style="color: red;"> UPDATED_DT</span></i><br />
<i><span style="color: red;"> )</span></i><br />
<i><span style="color: red;"> SELECT C_WAREHOUSE_ID,</span></i><br />
<i><span style="color: red;"> IN_CUSTOMER_ID,</span></i><br />
<i><span style="color: red;"> UNKNOWN_DESC,</span></i><br />
<i><span style="color: red;"> UNKNOWN_DESC,</span></i><br />
<i><span style="color: red;"> UNKNOWN_DESC,</span></i><br />
<i><span style="color: red;"> UNKNOWN_DESC,</span></i><br />
<i><span style="color: red;"> UNKNOWN_CD,</span></i><br />
<i><span style="color: red;"> SYSDATE,</span></i><br />
<i><span style="color: red;"> TYPE_2_END_DT,</span></i><br />
<i><span style="color: red;"> TYPE_2_CURRENT_FLG,</span></i><br />
<i><span style="color: red;"> SYSDATE,</span></i><br />
<i><span style="color: red;"> SYSDATE</span></i><br />
<i><span style="color: red;"> FROM W_DEFAULT_VALUES;</span></i><br />
<i><span style="color: red;"> RETURN C_WAREHOUSE_ID;</span></i><br />
<i><span style="color: red;">EXCEPTION</span></i><br />
<i><span style="color: red;">WHEN OTHERS THEN</span></i><br />
<i><span style="color: red;"> IF SQLCODE='-00001' THEN</span></i><br />
<i><span style="color: red;"> DBMS_OUTPUT.PUT_LINE('-00001 -WARNING- '||SQLCODE||SQLERRM);</span></i><br />
<i><span style="color: red;"> SELECT ROW_WID</span></i><br />
<i><span style="color: red;"> INTO C_WAREHOUSE_ID</span></i><br />
<i><span style="color: red;"> FROM W_CUSTOMER_D</span></i><br />
<i><span style="color: red;"> WHERE CUST_ID = IN_CUSTOMER_ID</span></i><br />
<i><span style="color: red;"> AND CURRENT_FLAG='1';</span></i><br />
<i><span style="color: red;"> ELSE</span></i><br />
<i><span style="color: red;"> RAISE_APPLICATION_ERROR(-20001,'-ERROR- '||SQLCODE||SQLERRM);</span></i><br />
<i><span style="color: red;"> END IF;</span></i><br />
<i><span style="color: red;"> RETURN C_WAREHOUSE_ID;</span></i><br />
<i><span style="color: red;">END D_CUSTOMER_DIM;</span></i><br />
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;"><br /></span></i>
<i><span style="color: red;">FUNCTION D_PRODUCT_DIM(</span></i><br />
<i><span style="color: red;"> IN_PRODUCT_ID IN VARCHAR2 )</span></i><br />
<i><span style="color: red;"> RETURN NUMBER</span></i><br />
<i><span style="color: red;">AS</span></i><br />
<i><span style="color: red;"> C_WAREHOUSE_ID NUMBER;</span></i><br />
<i><span style="color: red;">BEGIN</span></i><br />
<i><span style="color: red;"> C_WAREHOUSE_ID := SEQ_W_PRODUCT_D.nextval;</span></i><br />
<i><span style="color: red;"> INSERT</span></i><br />
<i><span style="color: red;"> INTO W_PRODUCT_D</span></i><br />
<i><span style="color: red;"> (</span></i><br />
<i><span style="color: red;"> ROW_WID,</span></i><br />
<i><span style="color: red;"> PROD_ID,</span></i><br />
<i><span style="color: red;"> PROD_LINE,</span></i><br />
<i><span style="color: red;"> PROD_DESC,</span></i><br />
<i><span style="color: red;"> CREATED_DT,</span></i><br />
<i><span style="color: red;"> UPDATED_DT</span></i><br />
<i><span style="color: red;"> )</span></i><br />
<i><span style="color: red;"> SELECT C_WAREHOUSE_ID,</span></i><br />
<i><span style="color: red;"> IN_PRODUCT_ID,</span></i><br />
<i><span style="color: red;"> UNKNOWN_CD,</span></i><br />
<i><span style="color: red;"> UNKNOWN_DESC,</span></i><br />
<i><span style="color: red;"> SYSDATE,</span></i><br />
<i><span style="color: red;"> SYSDATE</span></i><br />
<i><span style="color: red;"> FROM W_DEFAULT_VALUES;</span></i><br />
<i><span style="color: red;"> RETURN C_WAREHOUSE_ID;</span></i><br />
<i><span style="color: red;">EXCEPTION</span></i><br />
<i><span style="color: red;">WHEN OTHERS THEN</span></i><br />
<i><span style="color: red;"> IF SQLCODE='-00001' THEN</span></i><br />
<i><span style="color: red;"> DBMS_OUTPUT.PUT_LINE('-00001 -WARNING- '||SQLCODE||SQLERRM);</span></i><br />
<i><span style="color: red;"> SELECT ROW_WID</span></i><br />
<i><span style="color: red;"> INTO C_WAREHOUSE_ID</span></i><br />
<i><span style="color: red;"> FROM W_PRODUCT_D</span></i><br />
<i><span style="color: red;"> WHERE PROD_ID = IN_PRODUCT_ID;</span></i><br />
<i><span style="color: red;"> ELSE</span></i><br />
<i><span style="color: red;"> RAISE_APPLICATION_ERROR(-20001,'-ERROR- '||SQLCODE||SQLERRM);</span></i><br />
<i><span style="color: red;"> END IF;</span></i><br />
<i><span style="color: red;"> RETURN C_WAREHOUSE_ID;</span></i><br />
<i><span style="color: red;">END D_PRODUCT_DIM;</span></i><br />
<i><span style="color: red;">END LATE_DIMS;</span></i><br />
<i><span style="color: red;">/</span></i><br />
<br />
<b><u>Step 3: Create SEQUENCE ODI and DB</u></b><br />
<br />
CREATE SEQUENCE "SEQ_W_CUSTOMER_D" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 106 NOCACHE NOORDER NOCYCLE ;<br />
<br />
CREATE SEQUENCE "SEQ_W_PRODUCT_D" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 68 NOCACHE NOORDER NOCYCLE ;<br />
<br />
CREATE SEQUENCE "SEQ_W_STATUS_D" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 38 NOCACHE NOORDER NOCYCLE ;<br />
<br />
<div>
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: 14px;">Sequences created :</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNtCaakyqIZvU3SlQH6prlZuIUmzP8mhSyYJ3RW5NPzUCTRS7p1UiHxeb8VAZ4REBWmuDxFnnU-Yzr-E3rnL3JF0okc2mJTzkJ7mKDiA9aZ5Z7ILANfIHqoJP7yZmZ8bjjO85Gj4_zzGU/s1600/2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNtCaakyqIZvU3SlQH6prlZuIUmzP8mhSyYJ3RW5NPzUCTRS7p1UiHxeb8VAZ4REBWmuDxFnnU-Yzr-E3rnL3JF0okc2mJTzkJ7mKDiA9aZ5Z7ILANfIHqoJP7yZmZ8bjjO85Gj4_zzGU/s1600/2.JPG" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<b><u>Step 4: Create Dimension Interfaces: </u></b></div>
<div>
<br /></div>
<div>
In this we are using customer and product dimensions as example and interfaces are created to populate the dimensions and the fact table. </div>
<div>
<br /></div>
<div>
I am not mentioning the steps to create interfaces in SCD TYPE 2 here.</div>
<div>
<br /></div>
<div>
<h4 style="color: #313131; font-family: Arial, Helvetica, sans-serif; font-size: 16px; line-height: 1; margin: 3px 0px 1px; padding: 5px;">
<b>Dimension Interfaces</b></h4>
<ul style="color: #313131; font-family: Arial, Helvetica, sans-serif; font-size: 13px; margin: 0px; padding: 0px 0px 25px;">
<li style="font-size: 14px; margin: 0px 0px 5px 20px; padding: 0px; word-wrap: break-word;">Warehouse.W_CUSTOMER_D (Type 2)</li>
<li style="font-size: 14px; margin: 0px 0px 5px 20px; padding: 0px; word-wrap: break-word;">Warehouse.W_PRODUCT_D (Type 1)</li>
</ul>
<div>
<h4 style="color: #313131; font-family: Arial, Helvetica, sans-serif; font-size: 16px; line-height: 1; margin: 3px 0px 1px; padding: 5px;">
<b>Fact Interface</b></h4>
<ul style="color: #313131; font-family: Arial, Helvetica, sans-serif; font-size: 13px; margin: 0px; padding: 0px 0px 25px;">
<li style="font-size: 14px; margin: 0px 0px 5px 20px; padding: 0px; word-wrap: break-word;">Warehouse.W_ORDERS_F</li>
</ul>
<div>
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px;">Interfaces Created : Customer - SCD TYPE 2 and product SCD TYPE 1</span></div>
</div>
</div>
<div>
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: 14px;"><br /></span></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: 14px;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiN0h2PbEPNesTnXnu3iSoSvXp_eGrFGglrxjEzYJTg__n_Z6Lf9Au2YvAke_s190uhzvpwcty2Xxv027k7gKa_zaKl57j-ZRGJPUZd1RzZbt0IlF9fjePGYCvjShDE7ngLw41YflR1iSc/s1600/1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="150" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiN0h2PbEPNesTnXnu3iSoSvXp_eGrFGglrxjEzYJTg__n_Z6Lf9Au2YvAke_s190uhzvpwcty2Xxv027k7gKa_zaKl57j-ZRGJPUZd1RzZbt0IlF9fjePGYCvjShDE7ngLw41YflR1iSc/s320/1.JPG" width="320" /></a></span></span></div>
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: 14px;">
</span></span></div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaPiYaqCVCB71FlbU4-fGkQGduz1Qs2wejGJf3m-RYQHdFgb3LfyZEl2mJjuM0bXb3wDbuIDzzQ5hU-afLCX06FnVBQ4LKVN-fSyMF4mbdLgj8ZbLzyroN3Jv6j3RqxkQ326yRgTKh52w/s1600/3.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="288" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaPiYaqCVCB71FlbU4-fGkQGduz1Qs2wejGJf3m-RYQHdFgb3LfyZEl2mJjuM0bXb3wDbuIDzzQ5hU-afLCX06FnVBQ4LKVN-fSyMF4mbdLgj8ZbLzyroN3Jv6j3RqxkQ326yRgTKh52w/s320/3.JPG" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnE9cEn-p7gBrdbs28nLDX-7iiSuh9SRBG6U2ra82ryYIh_Pm3R00p4QxJxsEJo7aGUgYecKAR66ealPAw6vwcvR-UtlsvfYSq_KLNY3h-tYbyl5uP44_H9sxyerSUUWIOs7SpT1sxows/s1600/4.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="293" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnE9cEn-p7gBrdbs28nLDX-7iiSuh9SRBG6U2ra82ryYIh_Pm3R00p4QxJxsEJo7aGUgYecKAR66ealPAw6vwcvR-UtlsvfYSq_KLNY3h-tYbyl5uP44_H9sxyerSUUWIOs7SpT1sxows/s320/4.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;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Step 6 : Create user functions to invoke the database function earlier created</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/AVvXsEgyDr332tbDjqezvj6XjW1ahiEYIxz7-_qjHKvq1D4creQ74pGDtcc5edztdv2iPxmrQJZnrU0wTUC_zPzGZk5mbbLCn_ewvJQqhcRms_rRp2W540VnxeEv3_i8alKGIZFgsJueHM_r8RA/s1600/6.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="134" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyDr332tbDjqezvj6XjW1ahiEYIxz7-_qjHKvq1D4creQ74pGDtcc5edztdv2iPxmrQJZnrU0wTUC_zPzGZk5mbbLCn_ewvJQqhcRms_rRp2W540VnxeEv3_i8alKGIZFgsJueHM_r8RA/s320/6.JPG" width="320" /></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/AVvXsEjMefMhACTm3slyX9ciw2wIMSqq8VJ98XBgUkMLpIHIgeD7ueaZZ217vBdDEln2fzJ4taeiEJisMk_NbWx_Jt75oFRBasX-lkaAnMASmZ9X7C6tW7XVMvs33HnjXdsKEZLeBINSEeMt-lw/s1600/5.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="193" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMefMhACTm3slyX9ciw2wIMSqq8VJ98XBgUkMLpIHIgeD7ueaZZ217vBdDEln2fzJ4taeiEJisMk_NbWx_Jt75oFRBasX-lkaAnMASmZ9X7C6tW7XVMvs33HnjXdsKEZLeBINSEeMt-lw/s320/5.JPG" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both;">
<span style="color: red;">CASE</span></div>
<div class="separator" style="clear: both;">
<span style="color: red;"> WHEN $(SurrogateKey) IS NULL THEN LATE_DIMS.D_PRODUCT_DIM($(NaturalKey))</span></div>
<div class="separator" style="clear: both;">
<span style="color: red;"> ELSE $(SurrogateKey)</span></div>
<div class="separator" style="clear: both;">
<span style="color: red;">END</span></div>
<br />
Create the similar function for LATE_CUSTOMER<br />
<br />
Step 6 : Create Fact Interface<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiv9w76-I7yn0D7jVVF3tt_0uKtzVpYL1d3B4y3iWGVGfUjG0m8wm6nSGQvEIFvW9SNL3rcqkbeBdE0CTUIaW1D1WYYDTbKxwwZTHV7U3dOOPTiMgDBjntC90xhR0OzrC9bc-r8bLRfNXY/s1600/7.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="140" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiv9w76-I7yn0D7jVVF3tt_0uKtzVpYL1d3B4y3iWGVGfUjG0m8wm6nSGQvEIFvW9SNL3rcqkbeBdE0CTUIaW1D1WYYDTbKxwwZTHV7U3dOOPTiMgDBjntC90xhR0OzrC9bc-r8bLRfNXY/s320/7.JPG" width="320" /></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/AVvXsEjSD2V4xKyJqiDIfnN3sSL6jKJCHY8xkkP0-QoFyISBmD88RbZwg-C80HD_Os9YTPVHnU6kxiKXKgdc-o78y4IgTIEmZOepCqP-E10ozj1eoL97cRPV9QLQ703XImk_gPH-U3BKDI4ZGOI/s1600/8.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="146" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSD2V4xKyJqiDIfnN3sSL6jKJCHY8xkkP0-QoFyISBmD88RbZwg-C80HD_Os9YTPVHnU6kxiKXKgdc-o78y4IgTIEmZOepCqP-E10ozj1eoL97cRPV9QLQ703XImk_gPH-U3BKDI4ZGOI/s320/8.JPG" width="320" /></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/AVvXsEggmxNI_JtpH20CGxhL3yLRrw4Smp1ilyBhGPW3M7FkR6Gk9EmgwkuXGL27pCAeUfKgnKqdBKfvPVdb3wH2_hUiKEfHJaybeSjn14DZqfKCRPH264aEX_lVViki_i9YoVZWj3g7NRicnZY/s1600/9.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="171" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggmxNI_JtpH20CGxhL3yLRrw4Smp1ilyBhGPW3M7FkR6Gk9EmgwkuXGL27pCAeUfKgnKqdBKfvPVdb3wH2_hUiKEfHJaybeSjn14DZqfKCRPH264aEX_lVViki_i9YoVZWj3g7NRicnZY/s320/9.JPG" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
Step 7 : Customize IKM incremental Update for the custom functions<br />
<br />
This modification is needed because in the incremental update there is a step 'Sub- select Inline View' which will fail because our package have DML statements that are not allowed inside a select statement.<br />
<br />
We do not what to use this step, hence we have to modify the IKM Oracle Incremental KM<br />
<br />
Create a duplicate of the incremental update KM as shown below<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8sZi_ZPgbTFocwqxMny6QRYYa972vDwVkwswX3EZWrU5ukvG1lP6lw1cARrUwHbOXv1ptZJpqWy_l5VKm5yys6K5hfoq0sKLT4r1PNkELkZQXYcJ5ZJz6CwMIVjWgbqgn0YXw74yyQpc/s1600/10.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="191" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8sZi_ZPgbTFocwqxMny6QRYYa972vDwVkwswX3EZWrU5ukvG1lP6lw1cARrUwHbOXv1ptZJpqWy_l5VKm5yys6K5hfoq0sKLT4r1PNkELkZQXYcJ5ZJz6CwMIVjWgbqgn0YXw74yyQpc/s320/10.JPG" width="320" /></a></div>
<br />
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 1.4;">To properly manage this restriction, we are going to create a new</span><span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 1.4;"> </span><i style="color: #313131; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 1.4;">KM option</i><span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 1.4;"> </span><span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 1.4;">in the</span><span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 1.4;"> </span><b style="color: #313131; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 1.4;"><i>IKM Oracle Incremental Update</i></b><span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 1.4;"> </span><span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 1.4;">that will allow us to only execute step </span><span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 1.4;"> </span><b style="color: #313131; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 1.4;"><i>“sub-select inline view”</i></b><span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 1.4;"> </span><span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 1.4;"> if the KM</span><i style="color: #313131; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 1.4;"> </i><span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 1.4;">option is set to “True”. By default, the option will be set to “True”, but for the</span><span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 1.4;"> </span><i style="color: #313131; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 1.4;">Orders Fact</i><span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 1.4;"> </span><span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 1.4;">interface, the option will be set to “false”.</span><br />
<div style="color: #313131; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1px; padding: 5px;">
Create a new option in the KM called “INLINE_VIEW” of type “Check Box” with a default value of “True” as illustrated</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEho96GgK1hIzWks7G_a_nGHhRRyrz0kFj6ZpBBZ0FgM3afOtWSEWN4yq3ITSjxwmbSCBMRCC0A-mSzZWuhSueaobBc5kf70pITd4sr1qD8CL_YtT4zSVL9EmMGdT8SEb-S6nWD2Kvw-nnM/s1600/11.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEho96GgK1hIzWks7G_a_nGHhRRyrz0kFj6ZpBBZ0FgM3afOtWSEWN4yq3ITSjxwmbSCBMRCC0A-mSzZWuhSueaobBc5kf70pITd4sr1qD8CL_YtT4zSVL9EmMGdT8SEb-S6nWD2Kvw-nnM/s320/11.JPG" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 19.6px; text-align: left;">Save your new KM Option. Select the “Details” tab of the KM, and open the “Sub-Select Inline view” step as shown in Figure </span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 19.6px; text-align: left;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMc0yvYF1OozvxZHqrFxJ2ezTN60_NE9U_o0J5j4e8nqw7J5QcSy9qUUE8PgGpGakysWzJY_71S7_WsfEwfkD9VKEEmBWnHqccNg0qyuR97vBoH0BlZGylNe0lxVItbg0Ig-HEAXKlCJ4/s1600/11A.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="189" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMc0yvYF1OozvxZHqrFxJ2ezTN60_NE9U_o0J5j4e8nqw7J5QcSy9qUUE8PgGpGakysWzJY_71S7_WsfEwfkD9VKEEmBWnHqccNg0qyuR97vBoH0BlZGylNe0lxVItbg0Ig-HEAXKlCJ4/s320/11A.JPG" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 19.6px; text-align: left;"><br /></span></div>
<div class="separator" style="clear: both; text-align: justify;">
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 19.6px; text-align: left;">Unselect the “Always Execute” option and only check the “INLINE_VIEW” option. This mean that the step will only be executed if INLINE _VIEW option is set to “True” (which by default, this is how we implemented the option). The idea is that the behavior of the KM will not change. </span></div>
<div class="separator" style="clear: both; text-align: justify;">
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 19.6px; text-align: left;"><br /></span></div>
<div class="separator" style="clear: both; text-align: justify;">
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 19.6px; text-align: left;">But for our Orders fact interface we are going to set this option to “false”.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 19.6px; text-align: left;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoadZokD0JSqtMur-9KcQ37aEbRPzleevM5vm61QKSEwV3Yyu27hnHRNUMOo_orXKATRUu_4YRqfzt1p3tV-K-rVsazcjBBd-SiRUJA3rN2SwR_Xgclvel6gGh9083ccu2GETYJDJEe5M/s1600/12.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="172" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoadZokD0JSqtMur-9KcQ37aEbRPzleevM5vm61QKSEwV3Yyu27hnHRNUMOo_orXKATRUu_4YRqfzt1p3tV-K-rVsazcjBBd-SiRUJA3rN2SwR_Xgclvel6gGh9083ccu2GETYJDJEe5M/s320/12.JPG" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 19.6px; text-align: left;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 19.6px; text-align: left;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: 14px; line-height: 19.6px;">Step 8 : Update the fact interface with selecting the new IKM and changing the INLINE_vIEW to FALSE and save the interface</span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: 14px; line-height: 19.6px;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjH6fRPSB1Pkh-jpdEorznOkC4Edv6ZDtCx6XGR-PsyGgw1f4nwKEMMqBnZr6VAxhh41pLuZaiAH0_sQDCKluwmQf-DFq0tMBY47-TSNN-eJQF9OcryI8-t7BihqA-f3d-KpME0L0nbsAA/s1600/13.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="244" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjH6fRPSB1Pkh-jpdEorznOkC4Edv6ZDtCx6XGR-PsyGgw1f4nwKEMMqBnZr6VAxhh41pLuZaiAH0_sQDCKluwmQf-DFq0tMBY47-TSNN-eJQF9OcryI8-t7BihqA-f3d-KpME0L0nbsAA/s320/13.JPG" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: 14px; line-height: 19.6px;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: 14px; line-height: 19.6px;">Step 9 : We are now complete with the setup and now to test if out late arriving dimensions is going to work.</span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: 14px; line-height: 19.6px;"><br /></span></span></div>
<div style="color: #313131; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1px; padding: 5px;">
Insert a data in the source table and leave the dimension table as is.</div>
<div style="color: #313131; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1px; padding: 5px;">
<br /></div>
<div style="color: #313131; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1px; padding: 5px;">
Run the fact interface and see that the new record is available in the FACT TABLE and the customer wid is populated with the value returned by our PL SQL function. </div>
<div style="color: #313131; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1px; padding: 5px;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgigv02QUPxO58NeAuwA5MPgQm6yQQppTsh9U1312Gq0VBOIe56o0wXrXUXIry4JikNHT2RXSmfZuSMIkCIY8dk1rj9FpMLqiDejBPBtpKBFlrW7IGvAGUimtvVFOqQYAWnUCQAThEhZpc/s1600/15.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="193" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgigv02QUPxO58NeAuwA5MPgQm6yQQppTsh9U1312Gq0VBOIe56o0wXrXUXIry4JikNHT2RXSmfZuSMIkCIY8dk1rj9FpMLqiDejBPBtpKBFlrW7IGvAGUimtvVFOqQYAWnUCQAThEhZpc/s320/15.JPG" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Check the customer dimension table </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/AVvXsEjLB9Xiby9OD0Urxs5X2wGvcFr75Dk8b_b9roXms0lGbhiEi_txAU8CEZcvR0vBeKnSdXn9mKx8BVtvYdOIU6alCUVGXLddwdtnrUUudDTgDwylDGHolmGMBKzJ8IIItOY9tKktZgOJ-kg/s1600/16.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="135" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLB9Xiby9OD0Urxs5X2wGvcFr75Dk8b_b9roXms0lGbhiEi_txAU8CEZcvR0vBeKnSdXn9mKx8BVtvYdOIU6alCUVGXLddwdtnrUUudDTgDwylDGHolmGMBKzJ8IIItOY9tKktZgOJ-kg/s320/16.JPG" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div style="color: #313131; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1px; padding: 5px;">
<br /></div>
Check the source table<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_Bm3bf7GQPEO0W7Qfv2ySiKhYU9BnBYCdHTmATe2pBGbRcy7wZwgJjbNjLXjaG5X9xmrpW7hAF8d7byVfho74z1udIOcxfT8Ptq4uoFvSlMxJf-jrrkenKhXoiceXX7FuvuaNZ10pzoo/s1600/17.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="145" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_Bm3bf7GQPEO0W7Qfv2ySiKhYU9BnBYCdHTmATe2pBGbRcy7wZwgJjbNjLXjaG5X9xmrpW7hAF8d7byVfho74z1udIOcxfT8Ptq4uoFvSlMxJf-jrrkenKhXoiceXX7FuvuaNZ10pzoo/s320/17.JPG" width="320" /></a></div>
<br />
<br />
<br />
Now our early fact and late dimension records are both available in the fact table.<br />
<br />
Reference : <a href="http://www.ateam-oracle.com/" target="_blank">Oracle Blog </a><br />
<br />
Thanks,<br />
Sandeep</div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-14379758027000903072016-05-08T02:15:00.003-04:002016-05-09T14:35:57.982-04:00Early Arriving Facts or Late Arriving Dimensions <div dir="ltr" style="text-align: left;" trbidi="on">
<h3 style="text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: 14px; font-weight: normal; line-height: 19.6px;"><u>Early Arriving Fact Also known as Late Arriving Dimensions.</u></span></span></h3>
<h3 style="text-align: left;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; font-weight: normal; line-height: 19.6px;">An early arriving fact takes place when the activity measurement arrives at the data warehouse without its full context. In other words, the statuses of the dimensions attached to the activity measurement are ambiguous or unknown for some period of time.</span></h3>
<div>
<span style="color: #313131; font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; font-weight: normal; line-height: 19.6px;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfefHPvAvPPhyphenhypheni1_56WaGO5aw1W8JqP544F7Dp2Om17OG0yW_E7cRMg4HQFuWoxEZSk14aRrlQAa97AyFHCxU4OVimCjZixHOc6KeXFxVymBH_dr-kILfZGbe871Tt_tsh8_YPHxpFH8w/s1600/LAte.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="361" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfefHPvAvPPhyphenhypheni1_56WaGO5aw1W8JqP544F7Dp2Om17OG0yW_E7cRMg4HQFuWoxEZSk14aRrlQAa97AyFHCxU4OVimCjZixHOc6KeXFxVymBH_dr-kILfZGbe871Tt_tsh8_YPHxpFH8w/s640/LAte.png" width="640" /></a></div>
<h3 style="text-align: left;">
</h3>
<h3 style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1px; padding: 5px;">
<span style="font-weight: normal;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 19.6px;">An early arriving fact is also known as a </span><span style="line-height: 19.6px;">late arriving dimension</span><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 19.6px;"> because the dimensional member will arrive </span><em style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 19.6px;">after</em><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 14px; line-height: 19.6px;"> the activity measurement</span></span></h3>
<h3 style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1px; padding: 5px;">
<span style="font-weight: normal;">In Extract-Transform-Load (ETL) terminology, an early arriving fact is when the ETL process performs a look up of a surrogate key in a dimension table using the natural key of a fact table, and no value is returned because the dimension record doesn’t exist yet.</span></h3>
<div>
<span style="font-weight: normal;"><br /></span></div>
<div>
<span style="font-weight: normal;"><br /></span></div>
<div>
<h2 style="text-align: left;">
<a href="http://www.sandeepvenu.com/2016/05/how-to-handle-early-arriving-facts-and.html" target="_blank">Steps to Implement Early Arriving Fact in ODI</a></h2>
</div>
</div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-86973953069479834032016-05-08T01:57:00.003-04:002016-05-08T18:19:38.058-04:00How to Implement CDC in ODI 11g<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
Changed Data Capture (CDC) allows Oracle Data Integrator to track changes in source data caused by other applications. When running integration interfaces, thanks to CDC, Oracle Data Integrator can avoid processing unchanged data in the flow.</div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
Reducing the source data flow to only changed data is useful in many contexts, such as data synchronization and replication. It is essential when setting up an event-oriented architecture for integration. In such an architecture, applications make changes in the data ("Customer Deletion", "New Purchase Order") during a business process. These changes are captured by Oracle Data Integrator and transformed into events that are propagated throughout the information system</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
Steps to Implement CDC</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<ol style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.6; list-style-position: outside; margin: 0px 0px 1.25rem 5px; padding: 8px 0px 8px 10px;">
<li style="box-sizing: border-box; margin: 8px 0px; padding: 0px;"><div style="box-sizing: border-box; font-family: inherit; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
In the <span class="bold" style="box-sizing: border-box; font-weight: bold;">Models</span> tree in the Designer Navigator, select the model that you want to journalize.</div>
</li>
<li style="box-sizing: border-box; margin: 8px 0px; padding: 0px;"><div style="box-sizing: border-box; font-family: inherit; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
Double-click this model to edit it.</div>
</li>
<li style="box-sizing: border-box; margin: 8px 0px; padding: 0px;"><div style="box-sizing: border-box; font-family: inherit; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
In the <span class="bold" style="box-sizing: border-box; font-weight: bold;">Journalizing</span> tab, select the journalizing mode you want to use: <span class="bold" style="box-sizing: border-box; font-weight: bold;">Consistent Set</span> or <span class="bold" style="box-sizing: border-box; font-weight: bold;">Simple</span>.</div>
</li>
<li style="box-sizing: border-box; margin: 8px 0px; padding: 0px;"><div style="box-sizing: border-box; font-family: inherit; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
Select the Journalizing Knowledge Module (JKM) you want to use for this model. Only Knowledge Modules suitable for the data model's technology and journalizing mode, and that have been previously imported into at least one of your projects will appear in the list.</div>
</li>
<li style="box-sizing: border-box; margin: 8px 0px; padding: 0px;"><div style="box-sizing: border-box; font-family: inherit; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
Set the <span class="bold" style="box-sizing: border-box; font-weight: bold;">Options</span> for this KM.</div>
</li>
</ol>
<div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2DSVmPpwFk5Yg-8DioMfFcyt04VO06JQgPCon-q3wcM_zk-2EmLRbMZ84_PhkYh-zGTrBUmPcgeV9B_AefmRelQFb8PZo-8c_UghYML43fj72IbRxPG5KdpJMCJGGDxsp_bCFqMAYsP0/s1600/CDC5.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="378" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2DSVmPpwFk5Yg-8DioMfFcyt04VO06JQgPCon-q3wcM_zk-2EmLRbMZ84_PhkYh-zGTrBUmPcgeV9B_AefmRelQFb8PZo-8c_UghYML43fj72IbRxPG5KdpJMCJGGDxsp_bCFqMAYsP0/s640/CDC5.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
In the source table that needs to be setup for CDC select the table > Select Change Capture > Add to CDC</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
To add or remove datastores for the CDC:</div>
<ol style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.6; list-style-position: outside; margin: 0px 0px 1.25rem 5px; padding: 8px 0px 8px 10px;">
<li style="box-sizing: border-box; margin: 8px 0px; padding: 0px;"><div style="box-sizing: border-box; font-family: inherit; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
Right-click the model, sub-model or datastore that you want to add to/remove from the CDC in the <span class="bold" style="box-sizing: border-box; font-weight: bold;">Model</span> tree in the Designer Navigator.</div>
</li>
<li style="box-sizing: border-box; margin: 8px 0px; padding: 0px;"><div style="box-sizing: border-box; font-family: inherit; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
Right-click then select <span class="bold" style="box-sizing: border-box; font-weight: bold;">Changed Data Capture</span> > <span class="bold" style="box-sizing: border-box; font-weight: bold;">Add to CDC</span> or <span class="bold" style="box-sizing: border-box; font-weight: bold;">Changed Data Capture</span> > <span class="bold" style="box-sizing: border-box; font-weight: bold;">Remove from CDC</span> to add to the CDC or remove from the CDC the selected datastore, or all datastores in the selected model/sub-model.</div>
</li>
<li style="box-sizing: border-box; margin: 8px 0px; padding: 0px;"><div class="subhead2" style="box-sizing: border-box; font-size: 15.4px; font-weight: bold; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 10px 0px 0px; text-rendering: optimizeLegibility;">
Add or remove subscribers:</div>
<div style="box-sizing: border-box; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
Each subscriber consumes in a separate thread changes that occur on individual datastores for Simple Journalizing or on a model for Consistent Set Journalizing. Adding or removing a subscriber registers it to the CDC infrastructure in order to trap changes for it.</div>
<div style="box-sizing: border-box; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
To add subscribers:</div>
<ol style="box-sizing: border-box; line-height: 1.6; list-style-position: outside; margin: 0px 0px 1.25rem 5px; padding: 8px 0px 8px 10px;">
<li style="box-sizing: border-box; margin: 8px 0px; padding: 0px;"><div style="box-sizing: border-box; font-family: inherit; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
In the <span class="bold" style="box-sizing: border-box; font-weight: bold;">Models</span> tree in the Designer Navigator, select the journalized data model if using Consistent Set Journalizing or select a data model or an individual datastore if using Simple Journalizing.</div>
</li>
<li style="box-sizing: border-box; margin: 8px 0px; padding: 0px;"><div style="box-sizing: border-box; font-family: inherit; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
Right-click, then select <span class="bold" style="box-sizing: border-box; font-weight: bold;">Changed Data Capture</span> > <span class="bold" style="box-sizing: border-box; font-weight: bold;">Subscriber</span> > <span class="bold" style="box-sizing: border-box; font-weight: bold;">Subscribe</span>. A window appears which lets you select your subscribers.</div>
</li>
<li style="box-sizing: border-box; margin: 8px 0px; padding: 0px;"><div style="box-sizing: border-box; font-family: inherit; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
Type a <span class="bold" style="box-sizing: border-box; font-weight: bold;">Subscriber</span> name, then click the <span class="bold" style="box-sizing: border-box; font-weight: bold;">Add Subscriber</span> button. Repeat the operation for each subscriber you want to add.</div>
</li>
</ol>
</li>
</ol>
<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/AVvXsEg8Tj1ZfLhSMB90VrGPHN3z6s0H0W3I8nB9SW7j0WIB45JwRfYM_CFvZxvPTS4Yw-LcKigzB90AdQkFWOGyaX3iah5temqOx3-w8trx-CaAuqiHgxG6OAP_o69G2UgI-FcBzlgtvidKQuI/s1600/cdc.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="448" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8Tj1ZfLhSMB90VrGPHN3z6s0H0W3I8nB9SW7j0WIB45JwRfYM_CFvZxvPTS4Yw-LcKigzB90AdQkFWOGyaX3iah5temqOx3-w8trx-CaAuqiHgxG6OAP_o69G2UgI-FcBzlgtvidKQuI/s640/cdc.png" width="640" /></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/AVvXsEjGVwqlgp0-15ddv-yeoYlH-obm07QMPM9Dz7R8Ocit5pijD85nWWlgxAzfuHR-EmAE5zLFFvr1LD3i2ZUx0y-_sJKEm_kETr9XKx9-6j_2fyqOgF1JEsg_PAE7GZjMbbNwVZJOVBxjX-k/s1600/CDC2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="330" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGVwqlgp0-15ddv-yeoYlH-obm07QMPM9Dz7R8Ocit5pijD85nWWlgxAzfuHR-EmAE5zLFFvr1LD3i2ZUx0y-_sJKEm_kETr9XKx9-6j_2fyqOgF1JEsg_PAE7GZjMbbNwVZJOVBxjX-k/s640/CDC2.JPG" width="640" /></a></div>
<br />
<span style="background-color: white; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 19.6px;">The table added to CDC should now have a marker icon. The journal icon represents a small clock. It should be yellow, indicating that the journal infrastructure is not yet in place.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixphJZoOIUIrwVswWgqL5zL3SqzxMcr-A5BH09oddVx_JF05Dsxb2IHG7stHj2XnafsYXseJkqYbynmFBxNeDSjE8rjgvXAKIEoIVGZSzwp1_nqvxIsJxDmmY7AW9Or8-M7pVQEUG3lZU/s1600/CDC3.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="373" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixphJZoOIUIrwVswWgqL5zL3SqzxMcr-A5BH09oddVx_JF05Dsxb2IHG7stHj2XnafsYXseJkqYbynmFBxNeDSjE8rjgvXAKIEoIVGZSzwp1_nqvxIsJxDmmY7AW9Or8-M7pVQEUG3lZU/s400/CDC3.JPG" width="400" /></a></div>
<br />
<span style="background-color: white; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 21px;">It is possible to add datastores to the CDC after the journal creation phase. In this case, the journals should be re-started.</span><br />
<div style="box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
<span style="background-color: white;">If a datastore with journals running is removed from the CDC in simple mode, the journals should be stopped for this individual datastore. If a datastore is removed from CDC in Consistent Set mode, the journals should be restarted for the model (Journalizing information is preserved for the other datastores).</span></div>
<div style="box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
<span style="background-color: white; font-size: 15.4px; font-weight: bold; line-height: 1.4;">Set the datastores order (consistent set journalizing only):</span></div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
You only need to arrange the datastores in order when using consistent set journalizing. You should arrange the datastores in the consistent set in an order which preserves referential integrity when using their changed data. For example, if an ORDER table has references imported from an ORDER_LINE datastore (i.e. ORDER_LINE has a foreign key constraint that references ORDER), and both are added to the CDC, the ORDER datastore should come before ORDER_LINE. If the PRODUCT datastore has references imported from both ORDER and ORDER_LINE (i.e. both ORDER and ORDER_LINE have foreign key constraints to the PRODUCT table), its order should be lower still.</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="subhead2" style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 15.4px; font-weight: bold; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 10px 0px 0px; text-rendering: optimizeLegibility;">
Start/Drop the journals:</div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
Starting the journals creates the CDC infrastructure if it does not exist yet. It also validates the addition, removal and order changes for journalized datastores.</div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
Dropping the journals deletes the entire journalizing infrastructure.</div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
Now to see if the data changes are captured, open the data for the table and change some values as shown below</div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUIXyTGMm0xEsbeztU2yh3NOPxPwiNU8mrkQK-dC1MPN2MUjWLq6xxU1KFWG4CWZFvhQrCXzGb4nuTaitA9EqwlnfZZs_Cg5mgUl07fHXcC-bkJE7Xq5Svoi8A6twPuUpR4ycfNOxjc78/s1600/cdc+data+change.JPG" imageanchor="1" style="font-family: 'Times New Roman'; font-size: medium; line-height: normal; margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="172" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUIXyTGMm0xEsbeztU2yh3NOPxPwiNU8mrkQK-dC1MPN2MUjWLq6xxU1KFWG4CWZFvhQrCXzGb4nuTaitA9EqwlnfZZs_Cg5mgUl07fHXcC-bkJE7Xq5Svoi8A6twPuUpR4ycfNOxjc78/s640/cdc+data+change.JPG" width="640" /></a></div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
<br /></div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
To see the change journal, select the change capture and journal data. Here you can see that the changes to the table is captured. </div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGkQkuAZVIS7B8NjPBR-MEcjtD5lTXD7J-9_A1vrdoYbnnTOcjiNU-9T0uHlLeBy885CVKlquGjAOjN9Nn7IhzxCKgllnr8Moxy4Wj9rAqrTtuQ8pbt2dejIn-O18VGQ-H99RT01fPuQk/s1600/cdc7.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="468" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGkQkuAZVIS7B8NjPBR-MEcjtD5lTXD7J-9_A1vrdoYbnnTOcjiNU-9T0uHlLeBy885CVKlquGjAOjN9Nn7IhzxCKgllnr8Moxy4Wj9rAqrTtuQ8pbt2dejIn-O18VGQ-H99RT01fPuQk/s640/cdc7.JPG" width="640" /></a></div>
<br />
<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/AVvXsEgUIXyTGMm0xEsbeztU2yh3NOPxPwiNU8mrkQK-dC1MPN2MUjWLq6xxU1KFWG4CWZFvhQrCXzGb4nuTaitA9EqwlnfZZs_Cg5mgUl07fHXcC-bkJE7Xq5Svoi8A6twPuUpR4ycfNOxjc78/s1600/cdc+data+change.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="172" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUIXyTGMm0xEsbeztU2yh3NOPxPwiNU8mrkQK-dC1MPN2MUjWLq6xxU1KFWG4CWZFvhQrCXzGb4nuTaitA9EqwlnfZZs_Cg5mgUl07fHXcC-bkJE7Xq5Svoi8A6twPuUpR4ycfNOxjc78/s640/cdc+data+change.JPG" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxu3Vieu0uEogynVjk8GzFaiFvkqFJrDTKjR-Ujiq7DyNO5zAvDWw88-Hch7CGaXAQ-K4pd1QoJaI5rGfdiMLXXmcMMTAy2Db8myOElvdr-UOMlsosrYanakI-_nKZ7XwOMiR1R6XY-Vs/s1600/CDC+result.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="150" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxu3Vieu0uEogynVjk8GzFaiFvkqFJrDTKjR-Ujiq7DyNO5zAvDWw88-Hch7CGaXAQ-K4pd1QoJaI5rGfdiMLXXmcMMTAy2Db8myOElvdr-UOMlsosrYanakI-_nKZ7XwOMiR1R6XY-Vs/s640/CDC+result.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
More articles for CDC is to be followed</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Thanks,</div>
<div class="separator" style="clear: both; text-align: left;">
Sandeep</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
</div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-74339408996843132852016-05-08T01:57:00.000-04:002016-05-08T02:18:52.832-04:00Change Data Capture in ODI<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-align: justify; text-rendering: optimizeLegibility;">
Changed Data Capture (CDC) allows Oracle Data Integrator to track changes in source data caused by other applications. When running integration interfaces, thanks to CDC, Oracle Data Integrator can avoid processing unchanged data in the flow.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqg9TC-l9fA91Gx6krz5csXeKod5aSPcwmZa_SYPLdIkL5E-VXFoxuYeb50etCDf6xvUXbXQqWU7FJc0URVoluZtREP9dlcnUMwiSkHQ5XDeDWO0lai0hqdi4BbUkDKAc_AVBd2R1ddLc/s1600/CDC.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqg9TC-l9fA91Gx6krz5csXeKod5aSPcwmZa_SYPLdIkL5E-VXFoxuYeb50etCDf6xvUXbXQqWU7FJc0URVoluZtREP9dlcnUMwiSkHQ5XDeDWO0lai0hqdi4BbUkDKAc_AVBd2R1ddLc/s640/CDC.jpg" width="640" /></a></div>
<br /></div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-align: justify; text-rendering: optimizeLegibility;">
Reducing the source data flow to only changed data is useful in many contexts, such as data synchronization and replication. It is essential when setting up an event-oriented architecture for integration. In such an architecture, applications make changes in the data ("Customer Deletion", "New Purchase Order") during a business process. These changes are captured by Oracle Data Integrator and transformed into events that are propagated throughout the information system.</div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-align: justify; text-rendering: optimizeLegibility;">
Changed Data Capture is performed by journalizing models. Journalizing a model consists of setting up the infrastructure to capture the changes (inserts, updates and deletes) made to the records of this model's datastores</div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
Oracle Data Integrator supports two journalizing modes:</div>
<ul style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.6; list-style-position: outside; margin: 0px 0px 1.25rem 5px; padding: 8px 0px 8px 10px;">
<li style="box-sizing: border-box; margin: 8px 0px; padding: 0px;"><div style="box-sizing: border-box; font-family: inherit; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
<span class="bold" style="box-sizing: border-box; font-weight: bold;">Simple Journalizing</span> tracks changes in individual datastores in a model.</div>
</li>
<li style="box-sizing: border-box; margin: 8px 0px; padding: 0px;"><div style="box-sizing: border-box; font-family: inherit; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
<span class="bold" style="box-sizing: border-box; font-weight: bold;">Consistent Set Journalizing</span> tracks changes to a group of the model's datastores, taking into account the referential integrity between these datastores. The group of datastores journalized in this mode is called a <span class="bold" style="box-sizing: border-box; font-weight: bold;">Consistent Set</span>.</div>
</li>
</ul>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-align: justify; text-rendering: optimizeLegibility;">
<br /></div>
</div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-1409007979381433852016-04-04T14:39:00.000-04:002016-10-07T17:17:40.543-04:00ODI - Using ODI user function with Interface or Package<div dir="ltr" style="text-align: left;" trbidi="on">
Hi,<br />
<br />
It is very common to use ODI user functions during the transformation and the below steps explains how a user function can be created and used with ODI 11g<br />
<br />
In this example we will be converting the values of the status column to new values as shown below<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcEs50kqVLUsAPz9vaen2P7AZ8oG2tu5r1CTEtQ1ogR-meljc_082MGvG3VJQfgqcSbIjnOQygpRteV0qBOC7KJt4eKnqw-t8q9BEWbniR8_iiG0oIa4F-rp8LGeIbtlJGB86x3wAMzQo/s1600/1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="393" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcEs50kqVLUsAPz9vaen2P7AZ8oG2tu5r1CTEtQ1ogR-meljc_082MGvG3VJQfgqcSbIjnOQygpRteV0qBOC7KJt4eKnqw-t8q9BEWbniR8_iiG0oIa4F-rp8LGeIbtlJGB86x3wAMzQo/s400/1.JPG" width="400" /></a></div>
Target Conversion<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEii66nztfwgSidzSbRovMgjcyhk4o_PlE1icVlGauNpL1kKo1xzbpDP5lSGejXt613t3JTulrqSHB-KK1xgSI2XdjmxpgTnsD1j0w37q9z9i4HKHDR2iW3cjtV1cAo_VV3etbsf97hK_Qc/s1600/2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="215" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEii66nztfwgSidzSbRovMgjcyhk4o_PlE1icVlGauNpL1kKo1xzbpDP5lSGejXt613t3JTulrqSHB-KK1xgSI2XdjmxpgTnsD1j0w37q9z9i4HKHDR2iW3cjtV1cAo_VV3etbsf97hK_Qc/s400/2.JPG" width="400" /></a></div>
<br />
Create a new function from the Designer tab > Projects > Your project > User functions<br />
<br />
The name of the function is StatusCONVERT and the Group name is Conversion<br />
<br />
Navigate to the implementation tab and click on the + sign as shown below<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjExeYUBh_nMVFCb_G6TYMvb8MrZ_drCTIX3hwr5G_SZYhN4oByhpsaMzz-qfDdC-Ym8eNqryVEtH5nR3inxrYK8vz6T-7VnWAC5Xx9t-kkUQxbnmCzVO1bj_W7txMPR59onUosYZmHwg4/s1600/3.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="154" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjExeYUBh_nMVFCb_G6TYMvb8MrZ_drCTIX3hwr5G_SZYhN4oByhpsaMzz-qfDdC-Ym8eNqryVEtH5nR3inxrYK8vz6T-7VnWAC5Xx9t-kkUQxbnmCzVO1bj_W7txMPR59onUosYZmHwg4/s320/3.JPG" width="320" /></a></div>
<br />
<br />
Add the conversion statement as shown below and select Hypersonic SQL and Oracle as shown below<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDL7Pec1n34CqUomK_KFsOArgZR95OCuV4jN3W5ROzQmUBAeur3T4Hyjjke4npVY98c2igqTFOFIpf1ZncAcHGCzMwLT2SZWLYvkIUvNDI0ytccCqedqtRX267QTNan8DO1-DsidDX5iQ/s1600/4.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="227" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDL7Pec1n34CqUomK_KFsOArgZR95OCuV4jN3W5ROzQmUBAeur3T4Hyjjke4npVY98c2igqTFOFIpf1ZncAcHGCzMwLT2SZWLYvkIUvNDI0ytccCqedqtRX267QTNan8DO1-DsidDX5iQ/s400/4.JPG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Create the interface and complete the source to target mapping as shown below. </div>
<div class="separator" style="clear: both; text-align: left;">
From the mapping screen, select the status column on the target table and user the property inspector to add the function as shown below</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-NJu2yaxuGene_6qRS4ks1Onrny7S8UOi6d_-9epm570uI_GZI-nWWoOEjywl8y0C9BYh1bkVtHbEvuHX2JulS7cMGAjxn7myCC2bLp7w-eQ-GQ3KxB98ph37dfP7bNq1DGZWishGS4M/s1600/5.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="231" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-NJu2yaxuGene_6qRS4ks1Onrny7S8UOi6d_-9epm570uI_GZI-nWWoOEjywl8y0C9BYh1bkVtHbEvuHX2JulS7cMGAjxn7myCC2bLp7w-eQ-GQ3KxB98ph37dfP7bNq1DGZWishGS4M/s400/5.JPG" width="400" /></a></div>
<br />
<br />
From the project function select the StatusCONVERT function that we created in the first step<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7VcJWmPShe0rUUj1Fpt-_CNYfNtaqqGIiv_tl4CHTjNI14EE1pN7UFX1kJIbcEywA99ENal4xvaE5NDhuaw_t-ZUcUZnRuf-ofZ-cPbDkEAcB2nXeIHR3MT6h7AX0I8j7aBC1tDa-Tds/s1600/6.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="323" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7VcJWmPShe0rUUj1Fpt-_CNYfNtaqqGIiv_tl4CHTjNI14EE1pN7UFX1kJIbcEywA99ENal4xvaE5NDhuaw_t-ZUcUZnRuf-ofZ-cPbDkEAcB2nXeIHR3MT6h7AX0I8j7aBC1tDa-Tds/s400/6.JPG" width="400" /></a></div>
<br />
<br />
Complete the flow configuration and execute the interface<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFKADMTzJDfVSjV_2NBftM3BS4KvbXE2moNue7VYuH-aTJxxCEkMnNuz4madUAcqa-QZ2EztSEuUelY6sBEto3y02CaXp9pK33CkTZQqm1tOurCdr9n2qKnQArNJ4i4qZhNpTi-h6Mz5s/s1600/7.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="295" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFKADMTzJDfVSjV_2NBftM3BS4KvbXE2moNue7VYuH-aTJxxCEkMnNuz4madUAcqa-QZ2EztSEuUelY6sBEto3y02CaXp9pK33CkTZQqm1tOurCdr9n2qKnQArNJ4i4qZhNpTi-h6Mz5s/s400/7.JPG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
After the interface is executed successfully you can see that the target table have used our conversion function and the values are changed.</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfJAhfefkkovwOv9Kzsir12p_z7bsyJFV63aJl9KmGQDF36EWMElb9qUACnEEgj1OTmYn3n0ltq7puDEv68b9nNhnif9OfAVI2tpLl81XyV9ebK9P_NTxwbiBOjxPteUnO64fzeCqjMUs/s1600/8.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="365" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfJAhfefkkovwOv9Kzsir12p_z7bsyJFV63aJl9KmGQDF36EWMElb9qUACnEEgj1OTmYn3n0ltq7puDEv68b9nNhnif9OfAVI2tpLl81XyV9ebK9P_NTxwbiBOjxPteUnO64fzeCqjMUs/s400/8.JPG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Hope this helps</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Thanks,</div>
<div class="separator" style="clear: both; text-align: left;">
Sandeep</div>
<br />
<br /></div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-66781819741640430172016-03-30T15:09:00.001-04:002016-10-07T17:17:52.627-04:00ODI- NATIVE SEQUENCE Generator<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Hi ,<br />
<br />
For using Native Sequence generation in ODI interface, you can follow the below steps.<br />
<br />
<br />
CREATE TARGET TABLE<br />
<br />
CREATE TABLE "TARGET"."SEQUENCE_TRIAL"<br />
(<span class="Apple-tab-span" style="white-space: pre;"> </span>"FAMILY_ID" NUMBER,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>"EMP_NAME" VARCHAR2(255 CHAR)<br />
)<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEiAeZPGa2udAmykTy99URDmupga39-N7-FFLfDZKt49__PWAjK3N9cK8XOchG475lJzMM_RbM2BDPN6w0I7OyRIItow-5l_6be4Mq2_QECFWgn-lu1xK0xr5OU6YNk7wxEFo6pPbTjcU/s1600/2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="128" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEiAeZPGa2udAmykTy99URDmupga39-N7-FFLfDZKt49__PWAjK3N9cK8XOchG475lJzMM_RbM2BDPN6w0I7OyRIItow-5l_6be4Mq2_QECFWgn-lu1xK0xr5OU6YNk7wxEFo6pPbTjcU/s320/2.JPG" width="320" /></a><br />
<br />
<br />
<br />
CREATE SEQ_FAMILY in the TARGET schema<br />
<br />
<span style="color: red;">CREATE SEQUENCE SEQ_FAMILY INCREMENT BY 1 MAXVALUE 99999999999999999 MINVALUE 1 CACHE 20;</span><br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqNpVVxnSX5C5BR79qNr-k-Qsvh7UkahdhwF_wniGg2QnCE2krXr6-F64sp0obibwW-D_xCyI7LDWzs916-cbEbO3kchRFdOlc0cGR46wkKdhw20XHTDUi8PDxYucnjVL2T0H2Uelhr8s/s1600/1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="610" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqNpVVxnSX5C5BR79qNr-k-Qsvh7UkahdhwF_wniGg2QnCE2krXr6-F64sp0obibwW-D_xCyI7LDWzs916-cbEbO3kchRFdOlc0cGR46wkKdhw20XHTDUi8PDxYucnjVL2T0H2Uelhr8s/s640/1.JPG" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Import the table into the target model using the selective reverse engineering.</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8QiT62lN8688jhm8TYUFOGCpyqwJUB3C30KIJlNZPfsXkV0p7WZx5oR7kB9Zf2UC1ooL-sT5KDDxGLfRWJGJw4Z-eTtB_qdc-IEhyphenhyphen1MTzSSlfwmLoNyA_CcT1OzHhTYE85r_ow3ddtO4/s1600/3.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="379" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8QiT62lN8688jhm8TYUFOGCpyqwJUB3C30KIJlNZPfsXkV0p7WZx5oR7kB9Zf2UC1ooL-sT5KDDxGLfRWJGJw4Z-eTtB_qdc-IEhyphenhyphen1MTzSSlfwmLoNyA_CcT1OzHhTYE85r_ow3ddtO4/s640/3.JPG" width="640" /></a></div>
<br />
<br />
Once the target table is imported to the model, create the interface and map the EMP_NAME to the NAME column from the source as shown below<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5bxGamD6kgLHQX0YkqwiEzpVNnhBQoiu8YkRHE8BhmnVuWNbxh99KdWaE56AQhr1zbQCcSGc4Z_in_XvhlDhWHZyaUSO9sb8uzoBLiipVul9aVTKG8lDHZ6bK007HhczuSxrNznTm3og/s1600/4.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="314" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5bxGamD6kgLHQX0YkqwiEzpVNnhBQoiu8YkRHE8BhmnVuWNbxh99KdWaE56AQhr1zbQCcSGc4Z_in_XvhlDhWHZyaUSO9sb8uzoBLiipVul9aVTKG8lDHZ6bK007HhczuSxrNznTm3og/s640/4.JPG" width="640" /></a></div>
<br />
<br />
Create the Sequence:<br />
<br />
From the designer tab , projects, click on sequences and create a new sequence SEQ_FAMILY_ID as shown below<br />
<br />
Select Native Sequence and select the TARGET schema and use the search utility as shown below to browse our SEQ_FAMILY that was created in the first step<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkSz10zQUvGV7kziZpLNRYzB3cxNyVcXFzZL9Z3wTXgKe4P9rpI24peCjr8DvisjvGDf9uhW7s5ZEtoKPfJEKCE4SWK_YOzVqF0sljcKL2m_LiLFPKh17aS7arPFYjCJDxsDN-gxPntVk/s1600/5.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="306" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkSz10zQUvGV7kziZpLNRYzB3cxNyVcXFzZL9Z3wTXgKe4P9rpI24peCjr8DvisjvGDf9uhW7s5ZEtoKPfJEKCE4SWK_YOzVqF0sljcKL2m_LiLFPKh17aS7arPFYjCJDxsDN-gxPntVk/s640/5.JPG" width="640" /></a></div>
<br />
<br />
Open the interface and navigate to the MAPPING tab and use the property selector to select the FAMILY_ID column from the target table as shown below.<br />
<br />
User the Expression builder to add the SEQUENCE as shown below, click apply and OK.<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgF0WBfsZgWYmw-AU6TU504brqAexr7251YykDWrx6op0p-XT0oRFEnk06e5fULSqEZ2FZvSdWyvuaX26To3DpiBS5ppNFvBdxckihuaWAPOO6E1ewHTPpJqwGEtP7f5wMIZgDlyzWClqI/s1600/6.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="324" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgF0WBfsZgWYmw-AU6TU504brqAexr7251YykDWrx6op0p-XT0oRFEnk06e5fULSqEZ2FZvSdWyvuaX26To3DpiBS5ppNFvBdxckihuaWAPOO6E1ewHTPpJqwGEtP7f5wMIZgDlyzWClqI/s640/6.JPG" width="640" /></a></div>
<br />
<br />
Make sure you have specified the KEY as shown below in the new sequence column.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmI1blTB1JQeelJkOYYLaMiJJszTzFCRRXbY3iVDJYpcjQYKfHKH2s3AqI-T8KxD5wdAi4pzRDTAT941LlPHlhNUuqMMHRj9sHRU56fqdhRgwKBGdEhEiEzMJbmjTvFVnDqK6ybFgB7g8/s1600/7.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="310" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmI1blTB1JQeelJkOYYLaMiJJszTzFCRRXbY3iVDJYpcjQYKfHKH2s3AqI-T8KxD5wdAi4pzRDTAT941LlPHlhNUuqMMHRj9sHRU56fqdhRgwKBGdEhEiEzMJbmjTvFVnDqK6ybFgB7g8/s640/7.JPG" width="640" /></a></div>
<br />
<br />
Select the IKM as shown below and enable FLOW CONTROL = TRUE<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizxtZLPO4tFqOtnyloGIEMrEhRoMGza1bkCTAfXe39CGlKPwcmHvF0hMH0t1jgpqzyydF-IxyW2Unmdauzas4w6d7k6RGL0Jqy1nWjv6XaqSvtpTOB7u-ntMZSQnSesGUZdmr3xTa3c3o/s1600/8.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="510" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizxtZLPO4tFqOtnyloGIEMrEhRoMGza1bkCTAfXe39CGlKPwcmHvF0hMH0t1jgpqzyydF-IxyW2Unmdauzas4w6d7k6RGL0Jqy1nWjv6XaqSvtpTOB7u-ntMZSQnSesGUZdmr3xTa3c3o/s640/8.JPG" width="640" /></a></div>
<br />
<br />
Verify the target table and execute the interface.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEtChnUy7VctAep7flN5qHR9rgTpBCK3LYowDdHyBtzz69ay8Yy1I7zfxUQt5ThyphenhyphenpHTmnP23JefD3r1mSecr3M7t8MPE6Drzf6OkDKxrq40oEBhBxk4OSpCByfGukSNlrQSFZ-ACsJuBA/s1600/9.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="368" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEtChnUy7VctAep7flN5qHR9rgTpBCK3LYowDdHyBtzz69ay8Yy1I7zfxUQt5ThyphenhyphenpHTmnP23JefD3r1mSecr3M7t8MPE6Drzf6OkDKxrq40oEBhBxk4OSpCByfGukSNlrQSFZ-ACsJuBA/s640/9.JPG" width="640" /></a></div>
<br />
<br />
The target table is now populated with the NATIVE SEQUENCE as shown below.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitXdfXFFNV4Izb07uOYqhdu3Sh22WkwUVsODZarAbNqKRQXRGOxUd39Vu8GuIVjj-L_2FO1a-hkURjuzkvTaZUztfcGcwZQeYoM6mFXVE8KPuFqt_0fJJzPOnJiLsQT2YIp-KEm8jJSHk/s1600/10.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="574" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitXdfXFFNV4Izb07uOYqhdu3Sh22WkwUVsODZarAbNqKRQXRGOxUd39Vu8GuIVjj-L_2FO1a-hkURjuzkvTaZUztfcGcwZQeYoM6mFXVE8KPuFqt_0fJJzPOnJiLsQT2YIp-KEm8jJSHk/s640/10.JPG" width="640" /></a></div>
<br />
<br />
Thanks<br />
<br />
Sandeep</div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-12464849518106058032016-03-30T13:17:00.003-04:002016-10-07T17:18:06.853-04:00ODI- Slowly Changing Dimension [SCD TYPE 2]<div dir="ltr" style="text-align: left;" trbidi="on">
The below steps shows how SCD 2 is configured in ODI 11g<br />
<br />
Pre requisites :<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhV-rEs5ybfTqR9F3RYPgZbEUBo5NKCuDeh-jxPKsI8-JAJH9uvVXloUrEaZGGVdjMdPPLF_X3MBVZMAeSf1e91yd9FO0yejQ8B4xvZZ-XNjjvAKLsU6-QQ4D2YB1u8QwuKyJaRZG35LTI/s1600/odi-logo2-12c-fusion-middleware.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="512" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhV-rEs5ybfTqR9F3RYPgZbEUBo5NKCuDeh-jxPKsI8-JAJH9uvVXloUrEaZGGVdjMdPPLF_X3MBVZMAeSf1e91yd9FO0yejQ8B4xvZZ-XNjjvAKLsU6-QQ4D2YB1u8QwuKyJaRZG35LTI/s640/odi-logo2-12c-fusion-middleware.png" width="640" /></a></div>
<br />
<br />
ODI installed and configured with Topology for source and target is created.<br />
If not please check the steps to create the SOURCE and TARGET here.<br />
<br />
<br />
<b>Create the source and target model in ODI designer tab and map the model to respective Logical schema.</b><br />
<div>
</div>
<br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUkoYDoCBF4vGOEPFFMOmcDhDK6lls-EQVXQ9PPVYiQPlwH118BTOjf9whmqk6Y5JRosZz1Joa94kmyKmjbunCG5INgvqg89s60O5UhpECNwFRk6lDNSDVFsotf6Rea2QZycGN9RfhGLk/s1600/1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUkoYDoCBF4vGOEPFFMOmcDhDK6lls-EQVXQ9PPVYiQPlwH118BTOjf9whmqk6Y5JRosZz1Joa94kmyKmjbunCG5INgvqg89s60O5UhpECNwFRk6lDNSDVFsotf6Rea2QZycGN9RfhGLk/s640/1.JPG" width="604" /></a></div>
<br />
<br />
<br />
<b>Create the MODELS [SOURCE and TARGET]</b><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhi_3uoa9RgO2WKa8y4nHbL62UnFwsy2s5CcRZaxOsVn79lEwEAYHtXWeG8d6EoGVp6Gq4o2Ypo-EPk_62cEL6zbG10CLSOwwUUfb8XBMjbM0Ms_l1UxC4gtlQW5lhPb3w-5-TEdGkQbYY/s1600/3.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="302" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhi_3uoa9RgO2WKa8y4nHbL62UnFwsy2s5CcRZaxOsVn79lEwEAYHtXWeG8d6EoGVp6Gq4o2Ypo-EPk_62cEL6zbG10CLSOwwUUfb8XBMjbM0Ms_l1UxC4gtlQW5lhPb3w-5-TEdGkQbYY/s640/3.JPG" width="640" /></a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiADtq2BGQoy_fWFWxjO9sVYyQ3UJEyx09VeM5H-Dlnuyt_IUbpKFCxvQ_2QJnVu6pkNAr3G90trHrPt5z93AkUrEfEsbCoThldAH8V3r9pa0UcFCymxmGEuebsxPmJB03QgWMQLHAfxMs/s1600/2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="242" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiADtq2BGQoy_fWFWxjO9sVYyQ3UJEyx09VeM5H-Dlnuyt_IUbpKFCxvQ_2QJnVu6pkNAr3G90trHrPt5z93AkUrEfEsbCoThldAH8V3r9pa0UcFCymxmGEuebsxPmJB03QgWMQLHAfxMs/s640/2.JPG" width="640" /></a></div>
<br />
<br />
<br />
<b>Reverse Engineer the SOURCE and TARGET tables from the designer tab.</b><br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxbuWs4CL5R1kq43l88PAWtrxw-gOPAR47egUVG8UXY0Wcrppg7vQacBBOYhMDPcO2P3B-OmztErrNEBQaqnC5nxkq-AyBI8A8_8YPvvyRNaI5wHvb1ZC7fynBq15h0OO-dSES_wnrrZw/s1600/4.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="364" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxbuWs4CL5R1kq43l88PAWtrxw-gOPAR47egUVG8UXY0Wcrppg7vQacBBOYhMDPcO2P3B-OmztErrNEBQaqnC5nxkq-AyBI8A8_8YPvvyRNaI5wHvb1ZC7fynBq15h0OO-dSES_wnrrZw/s640/4.JPG" width="640" /></a></div>
<br />
<br />
<br />
<b>Create the SOURCE table in the source database</b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjI9ZRoFUv_GZlw78jwpN_2ZnEBoRPN3L65FuIHNqCBQ_hfBt6KfFvGj1abdslMvsbYGgFghFCYg5p2VJ68XOHZsod4pPwstTPDl70xmMFGhzr2O0btUFa2qDQu0BknWsG7FcNw9n_JAEc/s1600/5.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="410" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjI9ZRoFUv_GZlw78jwpN_2ZnEBoRPN3L65FuIHNqCBQ_hfBt6KfFvGj1abdslMvsbYGgFghFCYg5p2VJ68XOHZsod4pPwstTPDl70xmMFGhzr2O0btUFa2qDQu0BknWsG7FcNw9n_JAEc/s640/5.JPG" width="640" /></a></div>
<br />
<br />
<b>Create the target table in the TARGET schema, it should contain START_DATE, END_DATE & ACTIVE FLAG column for SCD 2</b><br />
<br />
<br />
Create the TARGET table :<br />
<br />
<br />
CREATE TABLE "TARGET"."CUSTOMERS_SCD2"<br />
(<span class="Apple-tab-span" style="white-space: pre;"> </span>"CUST_KEY" NUMBER,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>"NAME" VARCHAR2(255 CHAR),<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>"TYPE_KEY" VARCHAR2(255 CHAR),<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>"FST_CONTACT_DT" DATE,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>"SEGMENT_KEY" NUMBER,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>"INCOME_LVL" VARCHAR2(255 CHAR),<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>"STATUS_KEY" VARCHAR2(255 CHAR),<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>"LST_ORDER_DT" DATE,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>"ADDRESS_KEY" NUMBER,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>"MARITAL_ST" VARCHAR2(20 BYTE),<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>"PREV_MARITAL_ST" VARCHAR2(20 BYTE),<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>"PREV_MARITAL_ST_DT" DATE,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>"BIRTH_DT" DATE,<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>"CRDT_RATE" NUMBER(*,0),<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><span style="color: red;">"START_DATE" DATE, </span><br />
<span style="color: red;"><span class="Apple-tab-span" style="white-space: pre;"> </span>"END_DATE" DATE, </span><br />
<span style="color: red;"><span class="Apple-tab-span" style="white-space: pre;"> </span>"ACTIVE_FLAG" VARCHAR2(1 BYTE)</span><br />
)<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHVdFhNFzFHQYnLeSOFDWNy3yWnaos-t4kaaHGGqPrszM_0Wc375TQdw5xsSxU_bwzxXa3KwjJyhCaLaOZW8cLigfNCVcx_LDfhqyzoUGeMQAm1gSz1kgr_U66zbxieAzQSOkARv-WVto/s1600/6.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="466" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHVdFhNFzFHQYnLeSOFDWNy3yWnaos-t4kaaHGGqPrszM_0Wc375TQdw5xsSxU_bwzxXa3KwjJyhCaLaOZW8cLigfNCVcx_LDfhqyzoUGeMQAm1gSz1kgr_U66zbxieAzQSOkARv-WVto/s640/6.JPG" width="640" /></a></div>
<br />
<br />
<b>Create an INTERFACE from the designer tab and map the SOURCE to target columns and map the SCD2 TYPE columns as below</b><br />
<br />
START_DATE - SYSDATE<br />
END_DATE - SYSDATE<br />
ACTIVE_FLAG - '1'<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtMH0NG2UEJO9YE46PDEzV9hdiFPCfbkIRNRFYlQibKfNo08_tlb8YzOgZmiYAyfZbkhdwNBSWLeKfAkeWfiLu3aFVBiht-FeWu_Ee9KWY76tnZolzo5mTVaPd5qR8vL3Gynh4kIVyrms/s1600/7.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="380" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtMH0NG2UEJO9YE46PDEzV9hdiFPCfbkIRNRFYlQibKfNo08_tlb8YzOgZmiYAyfZbkhdwNBSWLeKfAkeWfiLu3aFVBiht-FeWu_Ee9KWY76tnZolzo5mTVaPd5qR8vL3Gynh4kIVyrms/s640/7.JPG" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDDlHsOL02OX3nPor8FQXPRtwL8xhRGRdy-PbRPGUVVTf_ouWJfuGDMsvFcJRgbRwUioi8Yt8fIDuILzCxjBswryqHZoHuudDL36ywWwGLZDLX3wJrIpVp8wRSlq6MyHY4iwnEI48T9ew/s1600/8.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="282" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDDlHsOL02OX3nPor8FQXPRtwL8xhRGRdy-PbRPGUVVTf_ouWJfuGDMsvFcJRgbRwUioi8Yt8fIDuILzCxjBswryqHZoHuudDL36ywWwGLZDLX3wJrIpVp8wRSlq6MyHY4iwnEI48T9ew/s640/8.JPG" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrF3Ak-1BAqCqWg921P5pYvX4ulrtiNaoTnCKL5BLqmw7FyMX2T1p9glcsDHQDlbYtGyKf_UnULcT5a91NSH_b_KiTQ2EdfAOKjVV_zOaODoAU13sY3XxsWFC4YL8Vzx9WrLKETsb1u0g/s1600/9.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="406" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrF3Ak-1BAqCqWg921P5pYvX4ulrtiNaoTnCKL5BLqmw7FyMX2T1p9glcsDHQDlbYtGyKf_UnULcT5a91NSH_b_KiTQ2EdfAOKjVV_zOaODoAU13sY3XxsWFC4YL8Vzx9WrLKETsb1u0g/s640/9.JPG" width="640" /></a></div>
<br />
<br />
<b>Configure SCD type 2 For the target table</b><br />
<br />
Navigate to the target model from the designer tab and open the target table and change the OLAP type as 'Slowly Changing Dimension' as shown below<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg44cS8avDZPaRN4sbBzCpyYN0FgYmtJOnK6y9CckXOUG2qp4NkdyWyE1sqBE48TW67G6oydNvSxLf93X7urf87uZVce8XfMfjRyhtzz80hXa_tlpeql-yCG1Bu0CvMW6xi3PvU4kPhBrY/s1600/10.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg44cS8avDZPaRN4sbBzCpyYN0FgYmtJOnK6y9CckXOUG2qp4NkdyWyE1sqBE48TW67G6oydNvSxLf93X7urf87uZVce8XfMfjRyhtzz80hXa_tlpeql-yCG1Bu0CvMW6xi3PvU4kPhBrY/s640/10.JPG" width="640" /></a></div>
<br />
<b>Open the column in the target table and in the description tab, change the 'Slowly changing dimension behavior' field as shown below</b><br />
<br />
The Key column should be mapped as Natural key. (if the surrogate key is not available in target)<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQnn49A4kstOEQ7ZOcOm1NqiGgDAmzeEUEDRWNesRxkzuGq6Pyuf1vFfzFz3y7G-NYFGeCDFgz_dR6SKVaEcQcFoYwMzMwlJRoX-Jps8gYUjc0F42dAweVzIYTyymi8hVMySMjTACBkUI/s1600/11.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="424" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQnn49A4kstOEQ7ZOcOm1NqiGgDAmzeEUEDRWNesRxkzuGq6Pyuf1vFfzFz3y7G-NYFGeCDFgz_dR6SKVaEcQcFoYwMzMwlJRoX-Jps8gYUjc0F42dAweVzIYTyymi8hVMySMjTACBkUI/s640/11.JPG" width="640" /></a></div>
<br />
<br />
<br />
<b>For the column for which the SCD TYPE 2 is to be configured, change the behavior to 'Add Row on Change' </b><br />
<br />
For the other columns change the behavior to 'Overwrite on Change'<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYTfq7BS4qxBn0r-4fnKlBB8Eh7ZWucawGcy_6sKUyHXQ9oZ385PeMyDY3H_b6bRiKOftboTMKkfI1Hf4_n_vpwbVOJqOs-bY1guktt0qWI4EvOWqAFKkd_nxTOguzcqeghwUuq8r8wlM/s1600/12.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="450" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYTfq7BS4qxBn0r-4fnKlBB8Eh7ZWucawGcy_6sKUyHXQ9oZ385PeMyDY3H_b6bRiKOftboTMKkfI1Hf4_n_vpwbVOJqOs-bY1guktt0qWI4EvOWqAFKkd_nxTOguzcqeghwUuq8r8wlM/s640/12.JPG" width="640" /></a></div>
<br />
<br />
<br />
<br />
<b>For the ACTIVE FLAG column, change the behavior to 'Current Record Flag'</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMZswqJNnZ0XdPnuN8tbDMQNdX8aLvM0mZ8HuCfAQ02_Y3OvLi0-OdLpS66DlmgKKV_aiDUIAzKIfr2gfWpwgHjxGvz8AxgIRD-nRl_OSWw7SMRXKPQ5wo1iqZtmC8JtkdTB8T3scu7SM/s1600/13.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="338" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMZswqJNnZ0XdPnuN8tbDMQNdX8aLvM0mZ8HuCfAQ02_Y3OvLi0-OdLpS66DlmgKKV_aiDUIAzKIfr2gfWpwgHjxGvz8AxgIRD-nRl_OSWw7SMRXKPQ5wo1iqZtmC8JtkdTB8T3scu7SM/s640/13.JPG" width="640" /></a></div>
<br />
<br />
<br />
<b>For END_DATE change the behavior as ENDING TIMESTAMP as shown below</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOFRsH0eDAvpPUd4gb_MeZnbgME2wWsFQBfRtnqJl_nVWDnQg54-rQvv0lU9duhipvSNIzrMlP5ZUL7YlO-yseAsn_6tVMI4L9oOowmdNbtfUI4tFtDzwo3fEj0KLbYvc7GDYOCjG-EBs/s1600/14.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="332" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOFRsH0eDAvpPUd4gb_MeZnbgME2wWsFQBfRtnqJl_nVWDnQg54-rQvv0lU9duhipvSNIzrMlP5ZUL7YlO-yseAsn_6tVMI4L9oOowmdNbtfUI4tFtDzwo3fEj0KLbYvc7GDYOCjG-EBs/s640/14.JPG" width="640" /></a></div>
<br />
<b><br /></b>
<b>For START_DATE column change the behavior as STARTING TIMESTAMP</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMPoFdn7WLkE9eePDvCuhvIVaJoh2EBijvwBSSr0i7oWtuvUl8Vbhan3U07h8r0NGZcfzryVonnVJjm2cF93gVZBA-29nTy_-agNOCPnRc6OE-Pu8EM_HF7N4Nr5b6GrhA9v8e_6qI09s/s1600/15.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="298" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMPoFdn7WLkE9eePDvCuhvIVaJoh2EBijvwBSSr0i7oWtuvUl8Vbhan3U07h8r0NGZcfzryVonnVJjm2cF93gVZBA-29nTy_-agNOCPnRc6OE-Pu8EM_HF7N4Nr5b6GrhA9v8e_6qI09s/s640/15.JPG" width="640" /></a></div>
<br />
<br />
<b>Open the interface and in the flow tab change the IKM to IKM Oracle Slowly changing Dimension. Also change the flow control to false. </b><br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipt_60yu9JqLlJDe5vdzr0PjFdxuy3NEQy6561hzWWFEOSjc4G9pN7631xyJbvRHE50z2U3-6ujAJTgp3LsVN-7QNX1jLQqMeTqUvnjIjnz4pTmxttONyRV47Jwz14WWoZWKwQacVDAGg/s1600/17.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipt_60yu9JqLlJDe5vdzr0PjFdxuy3NEQy6561hzWWFEOSjc4G9pN7631xyJbvRHE50z2U3-6ujAJTgp3LsVN-7QNX1jLQqMeTqUvnjIjnz4pTmxttONyRV47Jwz14WWoZWKwQacVDAGg/s640/17.JPG" width="640" /></a></div>
<br />
<br />
<br />
<b>Verify the data in the source table and in this example we will try to update the NAME of one record which is shown below</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_MCyZvOeXv8NVI-CKTinRnqvu6iNSEXBdOm1qYcocBrfBVJ65MbfgOqqSeD7XSor34jcPDieLIdFViNjg21qY7zQZpmkFeNMr4K72XGOaaOXTKFmnzSsSaSINtb644OJ5TBJ88o8Ufwk/s1600/18.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="396" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_MCyZvOeXv8NVI-CKTinRnqvu6iNSEXBdOm1qYcocBrfBVJ65MbfgOqqSeD7XSor34jcPDieLIdFViNjg21qY7zQZpmkFeNMr4K72XGOaaOXTKFmnzSsSaSINtb644OJ5TBJ88o8Ufwk/s640/18.JPG" width="640" /></a></div>
<br />
<br />
Verify that the target table is empty<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaYRIhJOKzNiEd-dBIbp46AJoe-mWU4X521Ex_VdE0Eh5bRn3QOI3mUBSXANSaOiyWNMKoQtawBqrq0Ed7ER_Pv6K39WE9rsIuhWC2yenl_fKsyiDZ7RVMNTFEfHEx3KocSyrijfOzHEM/s1600/19.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="354" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaYRIhJOKzNiEd-dBIbp46AJoe-mWU4X521Ex_VdE0Eh5bRn3QOI3mUBSXANSaOiyWNMKoQtawBqrq0Ed7ER_Pv6K39WE9rsIuhWC2yenl_fKsyiDZ7RVMNTFEfHEx3KocSyrijfOzHEM/s640/19.JPG" width="640" /></a></div>
<br />
<br />
<b>Execute the interface from the designer tab</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVZ7u-i5eaU9lwwVJurCUnYBx0JyeDuS177Jw9B5KwuBFOpA8uy57IkznT9Kvy1Rm4aRco5PWCabunqf76WO9UtsRwlfSDQwpozNSc951XAYUAAha28wh9uKESS0GoxQgBXsTdIcTnG_c/s1600/20.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="488" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVZ7u-i5eaU9lwwVJurCUnYBx0JyeDuS177Jw9B5KwuBFOpA8uy57IkznT9Kvy1Rm4aRco5PWCabunqf76WO9UtsRwlfSDQwpozNSc951XAYUAAha28wh9uKESS0GoxQgBXsTdIcTnG_c/s640/20.JPG" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbQ1Os6g_4WbCB82mHpF2Eiqxu8ZdEGrmmswCFvejPjmZC-HPwncQaI9rplbrl1-kBu7iUCAuY-1HebNAnLYV2S99uMp4ZxWe3ZLRsIO3wNLQn4fWuQu8ZSzvNJUnPBu52-AeYW5HzAFE/s1600/21.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="546" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbQ1Os6g_4WbCB82mHpF2Eiqxu8ZdEGrmmswCFvejPjmZC-HPwncQaI9rplbrl1-kBu7iUCAuY-1HebNAnLYV2S99uMp4ZxWe3ZLRsIO3wNLQn4fWuQu8ZSzvNJUnPBu52-AeYW5HzAFE/s640/21.JPG" width="640" /></a></div>
<br />
<br />
<b>The target table is now populated with the source data</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEogkcspoGZVpcygpvrVPQOlzmU1nhp3yXTfGeTKRilkEf5xFYTKfHKITqeOn1No4SEMIBI34ukxEar9D2QyWzmLZjMCm-G00eE2uGLjeUzOQw939SzlCNEyiUPpFwRsuxaeUYZP4Arz8/s1600/22.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="426" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEogkcspoGZVpcygpvrVPQOlzmU1nhp3yXTfGeTKRilkEf5xFYTKfHKITqeOn1No4SEMIBI34ukxEar9D2QyWzmLZjMCm-G00eE2uGLjeUzOQw939SzlCNEyiUPpFwRsuxaeUYZP4Arz8/s640/22.JPG" width="640" /></a></div>
<br />
<b>Now in the source data set, change the NAME of the first record to a different name as shown below and execute the interface again.</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1t05Kl5-Qi6Gp_C1-7RDR5Jts2xUyTx4lFLAQ2AYihOFKI-_ne6-tagRWeTuTQKIuvYOtUMarYUZTl_IkH1U1_Ey5XH1Jrj4I-qVtBaHX1VjhvMmIP20lBGsVuyLQgMYndnKyYNa1LzM/s1600/23.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="322" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1t05Kl5-Qi6Gp_C1-7RDR5Jts2xUyTx4lFLAQ2AYihOFKI-_ne6-tagRWeTuTQKIuvYOtUMarYUZTl_IkH1U1_Ey5XH1Jrj4I-qVtBaHX1VjhvMmIP20lBGsVuyLQgMYndnKyYNa1LzM/s640/23.JPG" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZwYkOvLpIx-cLS9ngETpdDRBBC8ShRtQNCuvucjWV0MwdXyB0vNttOdWYbUyaSxw9NEOf2CFf_Qgz7TXWef6ip10BJL37sJbHyQOpYq6-SM43jiYA0aJu-T7rfD7PNxRTR2ZdZYIHMeA/s1600/24.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZwYkOvLpIx-cLS9ngETpdDRBBC8ShRtQNCuvucjWV0MwdXyB0vNttOdWYbUyaSxw9NEOf2CFf_Qgz7TXWef6ip10BJL37sJbHyQOpYq6-SM43jiYA0aJu-T7rfD7PNxRTR2ZdZYIHMeA/s640/24.JPG" width="612" /></a></div>
<br />
<br />
<b>Verify the target data and now the new record with changed name is available in the target table and the ACTIVE FLAG is set to 1 for this row and the old record is changed to 0 </b>.<br />
<br />
The start and end date in the target table is also updated as shown below.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitrM-DqpUfuOEEvE0rz4SJz-shtBZOLIHdZYs5W4Q-eocZCiUcjk9tWQSTfsXTmQZH-V5DMQsfenC61g2-Hy3wLpjcHfC_rq4dUCpDabVN6nIRoaVM9VjZOtLLfIUm16KHJxuv9moZRQU/s1600/25.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="278" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitrM-DqpUfuOEEvE0rz4SJz-shtBZOLIHdZYs5W4Q-eocZCiUcjk9tWQSTfsXTmQZH-V5DMQsfenC61g2-Hy3wLpjcHfC_rq4dUCpDabVN6nIRoaVM9VjZOtLLfIUm16KHJxuv9moZRQU/s640/25.JPG" width="640" /></a></div>
<br />
<br />
<br />
Now the SCD TYPE 2 configuration is complete<br />
<br />
Thanks,<br />
Sandeep<br />
<br />
<br /></div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-42996327092786526812016-03-11T09:22:00.002-05:002016-03-11T09:22:35.413-05:00Finally the Truth !! :)<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAKLEv4lYecwVSehs2XzfyFrb1atpa80QskPpkTTrlI9IfEDSw19RVcjV_wR9dqJiy3X_aTwOrdK5Dof2AfAjfzMM0ezdYIR1d732FTffvXcemOErwX_rPRZ1kebT5CIqloQOgHSI9CXU/s1600/No+Cloud.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAKLEv4lYecwVSehs2XzfyFrb1atpa80QskPpkTTrlI9IfEDSw19RVcjV_wR9dqJiy3X_aTwOrdK5Dof2AfAjfzMM0ezdYIR1d732FTffvXcemOErwX_rPRZ1kebT5CIqloQOgHSI9CXU/s640/No+Cloud.jpg" width="640" /></a></div>
<br /></div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-3912661356305413012016-02-05T17:51:00.001-05:002016-02-05T17:51:14.977-05:00ORA-01732: data manipulation operation not legal on this view <div dir="ltr" style="text-align: left;" trbidi="on">
To resolve this error:<br />
<br />
Set the below parameter in session level connected as SYS as SYSDBA:<br />
<br /> ALTER SESSION SET "_simple_view_merging"=TRUE scope=both<br />
<br />
and execute the SQL<br />
<br />
Thanks,<br />
Sandeep</div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-30557694321446008812015-10-07T10:16:00.000-04:002015-10-07T10:28:09.972-04:00How to hide Home link in OBIEE banner<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal" style="margin-left: .25in;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6TMAfMiLY9NFv4imlnNCtzstyI79BkYttQtj86ylWtwTM51FJbMvZV6WA44E3TZ-B9JSp4wT2N-C-2YCbAIZ_iFbyxZbP97UaBtc2RMEk92H67iCxasyUgKuWDYpSuPL8mBOgS0joBl0/s1600/tricks.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6TMAfMiLY9NFv4imlnNCtzstyI79BkYttQtj86ylWtwTM51FJbMvZV6WA44E3TZ-B9JSp4wT2N-C-2YCbAIZ_iFbyxZbP97UaBtc2RMEk92H67iCxasyUgKuWDYpSuPL8mBOgS0joBl0/s640/tricks.jpg" width="514" /></a></div>
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;"><br /></span></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;"><br /></span></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">During
the development scenario, you might need to restrict access to the home link
for the users. <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">By
disabling the privileges to access the home link will cause login issues and
the users will not able to see the dashboards.<o:p></o:p></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/AVvXsEjE-6GaA3VXp_19Sae9RuZlKi7MTtxwOA5h0j6Q4dXO4Kae38F2r4EXRj2_VkWNLDJkq5UNBTD1DxaqoIU7Rez0nMOMY0RyUlYkOw5yeA6YzUi83D-YUwIblw1O3hpatZ7lHA1vJGgxvBk/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="273" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjE-6GaA3VXp_19Sae9RuZlKi7MTtxwOA5h0j6Q4dXO4Kae38F2r4EXRj2_VkWNLDJkq5UNBTD1DxaqoIU7Rez0nMOMY0RyUlYkOw5yeA6YzUi83D-YUwIblw1O3hpatZ7lHA1vJGgxvBk/s400/2.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></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/AVvXsEjzs5s3aU_v8OJgto8u_UzW0qmu5x6unV3b0Y0v3iK-o5ZW8Dxdy5SYTP4wiOXlq4KEmMwplimiddKkL_kslPfQRxsnITXlNF2YQngL_ZOKyOVEjQgW_d2Y0brDSn2-I-NlFkO1BM3F-Fg/s1600/1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzs5s3aU_v8OJgto8u_UzW0qmu5x6unV3b0Y0v3iK-o5ZW8Dxdy5SYTP4wiOXlq4KEmMwplimiddKkL_kslPfQRxsnITXlNF2YQngL_ZOKyOVEjQgW_d2Y0brDSn2-I-NlFkO1BM3F-Fg/s400/1.PNG" width="400" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">This
is because the default login will be pointing to the home page ‘/analytics/saw.dll?BIEEHome’.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">So
we can hide this link on the obiee banner so that it does not appear to the user.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">For
this navigate to<o:p></o:p></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/AVvXsEjn5N52brmu5QxHMXD_LKtNYwfXTLn_O9JeVZmoEG4WsPrafzzzeUCe03LeCmhoOWKSHxeCfhzvi88dmT8cdfEtfEOPWx4Fji8ZmV1I___b2ogSl7rTAgW5eRNYHriNIolYKBs0HOjlXA8/s1600/5.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="245" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjn5N52brmu5QxHMXD_LKtNYwfXTLn_O9JeVZmoEG4WsPrafzzzeUCe03LeCmhoOWKSHxeCfhzvi88dmT8cdfEtfEOPWx4Fji8ZmV1I___b2ogSl7rTAgW5eRNYHriNIolYKBs0HOjlXA8/s400/5.PNG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">D:\Oracle\Oracle_BI1\bifoundation\web\msgdb\l_en\messages\uicmsgs<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">And
find the saw.header.xml file (take a backup)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">Open
the file in a text editor and look for the ‘kmsgHeaderHome’ tag<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: 3.0pt;">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVnaPSJbWkEpUrdLQPsNXeChVLG8HOy8OgxY1uasV3i-7J54wsFUA8ADbwrw_4uZmBSuhXCS8onbNPMaXikGCWtfhRzs1E35dkp9T-z4yI3iDI7JowyH8vBogeOzwU-C5DVCQyQ30pqJw/s1600/4.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVnaPSJbWkEpUrdLQPsNXeChVLG8HOy8OgxY1uasV3i-7J54wsFUA8ADbwrw_4uZmBSuhXCS8onbNPMaXikGCWtfhRzs1E35dkp9T-z4yI3iDI7JowyH8vBogeOzwU-C5DVCQyQ30pqJw/s400/4.PNG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">Delete
the ‘Home’ from the text tag<o:p></o:p></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/AVvXsEhQJqfYVcnMLlha9yKMAuP7BJa__c6vEQAbwnwfXBMSpztXzcPStESlt-qp5s5zV5bziNf_oolSU3jGwSHoli7ocoNC0Xyhr8kxk4s1UVu-pM7wbpjqUXpoxq__MrO10nvBirkMH0923ec/s1600/3.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="242" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQJqfYVcnMLlha9yKMAuP7BJa__c6vEQAbwnwfXBMSpztXzcPStESlt-qp5s5zV5bziNf_oolSU3jGwSHoli7ocoNC0Xyhr8kxk4s1UVu-pM7wbpjqUXpoxq__MrO10nvBirkMH0923ec/s400/3.PNG" width="400" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">Save
the file.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">If
you have a custom skin or custom template then follows the steps below<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">Navigate
to your custom analyticsRes deployment folder location and navigate to the path
as shown below<o:p></o:p></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/AVvXsEg8AjvgNbzol5Sjj8A-roklnF671AcHJjSdh1x58dBFBZ8uVp2VRsP3utkWrfxodsIo5EeyvXqzht4ULjwNmmNB8G_OcIakvm6oAU5DnWHe0MNmCS9AWXK4ywuFq93VbhiLDf0T27Ab5pk/s1600/6.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="147" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8AjvgNbzol5Sjj8A-roklnF671AcHJjSdh1x58dBFBZ8uVp2VRsP3utkWrfxodsIo5EeyvXqzht4ULjwNmmNB8G_OcIakvm6oAU5DnWHe0MNmCS9AWXK4ywuFq93VbhiLDf0T27Ab5pk/s400/6.PNG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">Copy
the saw.header.xml file from Oracle_BI home location to this location.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">And
make the editing of the tags here.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">Do
not edit it in the home directory as it would impact other instances (<a href="http://obieelive.blogspot.com/2015/09/how-to-create-multiple-obiee-instances.html" target="_blank">Multiple instances of obiee</a>) on the same machine.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">Restart
the presentation services<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">And
navigate to the browser.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">Refresh
the browser using ‘Ctrl + F5’ and the home button should be hidden now.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<br />
<div class="MsoNormal" style="margin-left: .25in;">
<span style="font-family: "Arial Unicode MS","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-bidi-font-size: 11.0pt;">To
unhide the home button replace the saw.header file with the original copy and
restart the services.</span></div>
<br />
<br />
<br />
Thanks,<br />
Sandeep<br />
<br />
<o:p></o:p></div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-84805724671553464032015-10-06T10:23:00.000-04:002015-10-06T10:28:05.918-04:00Amazon Space Needle Business Intelligence<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" itemprop="headline" style="background-color: white; box-sizing: border-box; color: #231f1e; font-family: Roboto, sans-serif; line-height: 1.2; margin: 0px 0px 15px; text-align: center;">
<span style="font-size: small; font-weight: normal;"><u>Amazon Web Services set to debut new business intelligence tool, code-named</u></span></h1>
<h1 class="entry-title" itemprop="headline" style="background-color: white; box-sizing: border-box; color: #231f1e; font-family: Roboto, sans-serif; line-height: 1.2; margin: 0px 0px 15px; text-align: center;">
<span style="font-size: small; font-weight: normal;"><u> ‘Space Needle</u></span></h1>
<div>
<span style="font-size: small; font-weight: normal;"><u><br /></u></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNGV6oVYFFECtHn0y9lYkWfEJkpMzHnQJQnG1QPy6eTo3jim9bnGLsobUCaHOtiozHqW_UeAmMSFFtKPaB_jWMIXgeutt22HrMz5zHazKrR0EEt0aIIta4HimgO_W3Xdd_YTdvGoJ1I7w/s1600/amazon.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNGV6oVYFFECtHn0y9lYkWfEJkpMzHnQJQnG1QPy6eTo3jim9bnGLsobUCaHOtiozHqW_UeAmMSFFtKPaB_jWMIXgeutt22HrMz5zHazKrR0EEt0aIIta4HimgO_W3Xdd_YTdvGoJ1I7w/s400/amazon.jpg" width="400" /></a></div>
<div>
<span style="font-size: small; font-weight: normal;"><u><br /></u></span></div>
<div style="text-align: left;">
<span style="font-family: Georgia, Times New Roman, serif;">Amazon is all set to take a bite at the huge business intelligence industry with the release this week of a new tool — code-named Space Needle.</span><br />
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="font-family: Georgia, Times New Roman, serif;">Space Needle Business Intelligence tool could help Amazon Web Services expand its user base beyond technical workers, targeting potential business managers and marketers who use data to make better decisions about their companies’ products and services.</span><br />
<div>
<br /></div>
</div>
<div style="text-align: left;">
<span style="background-color: white; color: #231f1e; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; line-height: 26px;"><br /></span></div>
</div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-12036221410642128462015-10-01T09:28:00.001-04:002015-10-01T09:32:24.885-04:00How to Fix [nQSError: 43126] Authentication failed: invalid user/password<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background: rgb(255, 255, 255); border: none; color: #666666; font-family: Arial, Verdana, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 20px; margin-top: 13px; outline: none; padding: 0px; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRjvoTbna6PFNtzuewfH-XzotdIKA5qKkI6W1X702VsshOj32QrbQGkKGzhWjbmkT6W252WtjEZaMb8znYSFQ5GNcq705izgwfDlOXojEMPYAMVGrEtSJaxx6gDniuvceTc7PTL2CtA90/s1600/43126.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="188" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRjvoTbna6PFNtzuewfH-XzotdIKA5qKkI6W1X702VsshOj32QrbQGkKGzhWjbmkT6W252WtjEZaMb8znYSFQ5GNcq705izgwfDlOXojEMPYAMVGrEtSJaxx6gDniuvceTc7PTL2CtA90/s400/43126.png" width="400" /></a></div>
<br /></div>
<div style="background: rgb(255, 255, 255); border: none; color: #666666; font-family: Arial, Verdana, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 20px; margin-top: 13px; outline: none; padding: 0px; vertical-align: baseline;">
RESOLUTION:</div>
<ul style="background: rgb(255, 255, 255); border: none; color: #666666; font-family: Arial, Verdana, sans-serif; font-size: 14px; line-height: 24px; margin: 0px 0px 20px 2.5em; outline: none; padding: 0px; vertical-align: baseline;">
<li style="background: transparent; border: none; margin: 0px; outline: none; padding: 0px; vertical-align: baseline;">Connect to WebLogic Server (WLS) Console -> Deployments. Ensure that all deployed components are in ‘Active’ state.</li>
<li style="background: transparent; border: none; margin: 0px; outline: none; padding: 0px; vertical-align: baseline;">Use the command prompt to verify the opmn status, as the EM console will not always reflect the correct status.</li>
<li style="background: transparent; border: none; margin: 0px; outline: none; padding: 0px; vertical-align: baseline;">If any of the components is in ‘Prepared’ state, select that application and then click on “start servicing all requests”.</li>
<li style="background: transparent; border: none; margin: 0px; outline: none; padding: 0px; vertical-align: baseline;">Restart BI Server and Presentation Services</li>
</ul>
<div style="background: rgb(255, 255, 255); border: none; color: #666666; font-family: Arial, Verdana, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 20px; margin-top: 13px; outline: none; padding: 0px; vertical-align: baseline;">
If this does not resolve the issue please follow the steps below:</div>
<ul style="background: rgb(255, 255, 255); border: none; color: #666666; font-family: Arial, Verdana, sans-serif; font-size: 14px; line-height: 24px; margin: 0px 0px 20px 2.5em; outline: none; padding: 0px; vertical-align: baseline;">
<li style="background: transparent; border: none; margin: 0px; outline: none; padding: 0px; vertical-align: baseline;">In some cases, the following additional step might be needed to resolve the issue.</li>
<li style="background: transparent; border: none; margin: 0px; outline: none; padding: 0px; vertical-align: baseline;">Access the Enterprise Manager Fusion Middleware control:http://<host.domain>:port/em</li>
<li style="background: transparent; border: none; margin: 0px; outline: none; padding: 0px; vertical-align: baseline;">Navigate to Business Intelligence -> coreapplication</li>
<li style="background: transparent; border: none; margin: 0px; outline: none; padding: 0px; vertical-align: baseline;">‘Capacity Management’ tab -> ‘Scalability’ sub-tab</li>
<li style="background: transparent; border: none; margin: 0px; outline: none; padding: 0px; vertical-align: baseline;">Click on ‘Lock and Edit Configuration’ button</li>
<li style="background: transparent; border: none; margin: 0px; outline: none; padding: 0px; vertical-align: baseline;">Enter the IP address in the ‘Listen Address’ field</li>
<li style="background: transparent; border: none; margin: 0px; outline: none; padding: 0px; vertical-align: baseline;">Click on ‘Activate Changes’ followed by ‘Release Configuration’ buttons.</li>
</ul>
<div style="background: rgb(255, 255, 255); border: none; color: #666666; font-family: Arial, Verdana, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 20px; margin-top: 13px; outline: none; padding: 0px; vertical-align: baseline;">
Restart BI Server and Presentation Services</div>
<div style="background: rgb(255, 255, 255); border: none; color: #666666; font-family: Arial, Verdana, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 20px; margin-top: 13px; outline: none; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background: rgb(255, 255, 255); border: none; color: #666666; font-family: Arial, Verdana, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 20px; margin-top: 13px; outline: none; padding: 0px; vertical-align: baseline;">
thanks,</div>
<div style="background: rgb(255, 255, 255); border: none; color: #666666; font-family: Arial, Verdana, sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 20px; margin-top: 13px; outline: none; padding: 0px; vertical-align: baseline;">
Sandeep</div>
</div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-14373890650565725782015-09-30T15:41:00.000-04:002015-09-30T15:47:09.663-04:00How To Change the OBI System Component Ports via Mbean<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRlztegUEeIBxLKqYm7VluKgTLF4kM687wps1HUCexdRMoTIggIZwdEPv22IFPc4I8LQtt79-mPnuQbZgWDxJrtFVwTZLQLwBzwGURfwGEiSKrL6lCXskaMxZgiqhtOqSYRYmtUW1Hebc/s1600/how+to.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRlztegUEeIBxLKqYm7VluKgTLF4kM687wps1HUCexdRMoTIggIZwdEPv22IFPc4I8LQtt79-mPnuQbZgWDxJrtFVwTZLQLwBzwGURfwGEiSKrL6lCXskaMxZgiqhtOqSYRYmtUW1Hebc/s640/how+to.png" width="640" /></a></div>
<br />
<br />
If you need to change the port of any obiee component then the steps are as below</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Navigate to EM and expand the Weblogic domain folder > Bi
foundation_domin > b_server<o:p></o:p></div>
<div class="separator" style="clear: both;">
</div>
<div class="MsoNormal">
Right click on bi_server1 and open Application Defined MBeans<o:p></o:p></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/AVvXsEjMhKdmwJ2B_0_WRW8UJdMJegcWREq_Hb_h5_R3s7D-22e66cUYEdUvUYKKLceVE0jD_IT0QcJ4XAIdztoyd3ensuS74Fg6833SmYPIat87a8fRBbClpm-ow9_Iy4_0J_1STutVoOWxMus/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="367" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMhKdmwJ2B_0_WRW8UJdMJegcWREq_Hb_h5_R3s7D-22e66cUYEdUvUYKKLceVE0jD_IT0QcJ4XAIdztoyd3ensuS74Fg6833SmYPIat87a8fRBbClpm-ow9_Iy4_0J_1STutVoOWxMus/s400/1.png" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieiiUISPlV_rXa_wW6DqKOyQuxXnnAOoH6EUu6o_pLytc4rrD52AavReUpZUapnPRNpzFPRYW9Kv9ie61ZCBriNUS3curoPRvERHznwBn7ozr27_3syC3-UWH8oeaGSVgww9yHPJgFT70/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieiiUISPlV_rXa_wW6DqKOyQuxXnnAOoH6EUu6o_pLytc4rrD52AavReUpZUapnPRNpzFPRYW9Kv9ie61ZCBriNUS3curoPRvERHznwBn7ozr27_3syC3-UWH8oeaGSVgww9yHPJgFT70/s400/2.png" width="366" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjWsmOwbbyLN4yajLDpOMMTJkrSNBUrrI4cZqS5Dr495sL0AoWjh5_uJok0vthymMwCxelWaqp5iMuDrTFbjeX8QBw2h7YQew0Pw_FtapdY6RHXkKurYlnaymOu1WwsHGfn6a_4afQ8Gw/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjWsmOwbbyLN4yajLDpOMMTJkrSNBUrrI4cZqS5Dr495sL0AoWjh5_uJok0vthymMwCxelWaqp5iMuDrTFbjeX8QBw2h7YQew0Pw_FtapdY6RHXkKurYlnaymOu1WwsHGfn6a_4afQ8Gw/s400/3.png" width="371" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Expand 'Application Defined MBeans' folder' > oracle.biee.admin >
Domain: bifoundation_domain > BIDomain<o:p></o:p></div>
<div class="separator" style="clear: both;">
</div>
<div class="MsoNormal">
> and select
the first BIDomain mbean<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<br />
<div class="MsoNormal">
<br /></div>
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYsPrfelgRErmj3i4y37QmI-vVXQtz_jo9-BJMQ7lI7KGQwiEn2F-GAie3d8plKpk95JJGfXREypppCF9snM1K7m02N0UTlJnU3VdPd6viC-XbnTJ5hH7KKsbSNDhvdwiOd2-v8ZwxBL8/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYsPrfelgRErmj3i4y37QmI-vVXQtz_jo9-BJMQ7lI7KGQwiEn2F-GAie3d8plKpk95JJGfXREypppCF9snM1K7m02N0UTlJnU3VdPd6viC-XbnTJ5hH7KKsbSNDhvdwiOd2-v8ZwxBL8/s400/4.png" width="395" /></a></div>
<br />
Note: it could be the second, depending upon your version, but it will have an 'Operations' tab<br />
<br />
<br />
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Clck the 'lock' link<o:p></o:p></div>
<br />
<div class="MsoNormal">
Click the 'Invoke'
button<o:p></o:p></div>
<br />
<br />
<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/AVvXsEjL8yFcO7aWRHyMFYR_aMLThke2vRcniNNVfAwC3T6AUAWlQb_0CqawydOinF99UexyuDLphHysGVkQ5WqYVWsSo_vB3RlLRGrkufKnq1cnMQBD6MvTDmPeAl7VdA3hk80KzvhopXRC54M/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="298" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjL8yFcO7aWRHyMFYR_aMLThke2vRcniNNVfAwC3T6AUAWlQb_0CqawydOinF99UexyuDLphHysGVkQ5WqYVWsSo_vB3RlLRGrkufKnq1cnMQBD6MvTDmPeAl7VdA3hk80KzvhopXRC54M/s400/5.png" width="400" /></a></div>
<br />
<br />
<div class="MsoNormal">
<span style="color: #333333; mso-bidi-font-family: Arial;"><b>Change
the port values for the desired System Components</b><o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Continuing on from the steps above, next, navigate within the same MBean tree to<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
expand BIDomain.BIInstanceDeployment.BIComponent<o:p></o:p></div>
<br />
<div class="MsoNormal">
Under this folder
/ directory, you will see an MBean for each BI System component (single server
or cluster)<o:p></o:p></div>
<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhistJF1x_xq_W3twDNNdhK6_g0AXXtazyLODDoRKBLhWfffDOeeHIPbVNHm-tLLAzagISuIoNfIxrAhRnn9bOlgD6GctjcTl1d8Z5F-VGWosTTyuSPOXffT_6zevOUAErQrzWWjCsgtf8/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="387" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhistJF1x_xq_W3twDNNdhK6_g0AXXtazyLODDoRKBLhWfffDOeeHIPbVNHm-tLLAzagISuIoNfIxrAhRnn9bOlgD6GctjcTl1d8Z5F-VGWosTTyuSPOXffT_6zevOUAErQrzWWjCsgtf8/s400/6.png" width="400" /></a><br />
<br />
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Change the Port value (and / or Monitory Port if applicable) for each
System Component. Keep in mind, the port<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
values have to fall within the port range<o:p></o:p></div>
<br />
<div class="MsoNormal">
Click the 'Apply'
button after each change<o:p></o:p></div>
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnrAdPs5jQNJ6uOS0-X1R6cRfmvpwj7bYUa6kW9FkDOGbWhPvV8H2CgQ2KYzryuFDPqE0tSdAVAr7-IcwaOWluNyiWJzGgNP3WgLGvDUx-9_hhfTYZS1jmj5SfjEN5vkuai3I8E_MHBoY/s1600/7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="211" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnrAdPs5jQNJ6uOS0-X1R6cRfmvpwj7bYUa6kW9FkDOGbWhPvV8H2CgQ2KYzryuFDPqE0tSdAVAr7-IcwaOWluNyiWJzGgNP3WgLGvDUx-9_hhfTYZS1jmj5SfjEN5vkuai3I8E_MHBoY/s400/7.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;">
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: #333333; mso-bidi-font-family: Arial;"><b>Commit the changes</b><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: #333333; mso-bidi-font-family: Arial;"><br /></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: #333333; mso-bidi-font-family: Arial;"><br /></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
When the changes are complete, then you must 'commit' the
changes and unlock the domain<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Navigate back to 'Application Defined MBeans' folder' >
oracle.biee.admin > Domain: bifoundation_domain ><o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
BIDomain > and select the BIDomain mbean<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Click on the 'operation' tab<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Click on the first 'commit' link<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
Click
on the 'Invoke' button</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></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/AVvXsEj7ObDu2Wl_BMFMiFogr2WWC7kU4-OO9p7EvTmovQeVoMUcrfOG8NPSE8pqzfeEN54r2Zl7X-sccUOIChRL-EMk-Z4ZoCP3bou0Icv7Nfn2xulv3GU5TPtc-dldPu0NyU-VqMFxoXc-tEc/s1600/8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="188" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7ObDu2Wl_BMFMiFogr2WWC7kU4-OO9p7EvTmovQeVoMUcrfOG8NPSE8pqzfeEN54r2Zl7X-sccUOIChRL-EMk-Z4ZoCP3bou0Icv7Nfn2xulv3GU5TPtc-dldPu0NyU-VqMFxoXc-tEc/s400/8.png" width="400" /></a></div>
<br /></div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-37302916513718674102015-09-10T11:25:00.000-04:002015-09-10T11:25:43.839-04:00How to Add Custom Links in OBIEE header / Presentation Services<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
For custom links, you can specify various attributes, including the following</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGDi0xuIkd-essm0pWVEJQT_g_Dwopcm_iWwfL12VKoKpMt6jtD9KCD9H7AEQn0UrG89Pk03qSzAzkfdP6ZabN6Be2tJ_2Y4ALfPt27ueHfH5vqE9fN446y_bCBhl_Q-Wm8MyWHT_6ALU/s1600/Capture.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="67" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGDi0xuIkd-essm0pWVEJQT_g_Dwopcm_iWwfL12VKoKpMt6jtD9KCD9H7AEQn0UrG89Pk03qSzAzkfdP6ZabN6Be2tJ_2Y4ALfPt27ueHfH5vqE9fN446y_bCBhl_Q-Wm8MyWHT_6ALU/s640/Capture.PNG" width="640" /></a></div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
<br /></div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 1.4; margin-bottom: 1.25rem; max-width: 90em; padding: 0px; text-rendering: optimizeLegibility;">
</div>
<ol style="text-align: left;">
<li><span style="line-height: 19.6px;">The text for the link (either a static string or a message name to use for localization).</span></li>
<li><span style="line-height: 19.6px;">A URL to access.</span></li>
<li><span style="line-height: 19.6px;">Whether the page from the URL replaces the current page or opens in a new tab or window that you can name.</span></li>
<li><span style="line-height: 19.6px;">The relative ordering of links in the header.</span></li>
<li><span style="line-height: 19.6px;">An optional icon to use with the link.</span></li>
</ol>
<div>
<br /></div>
<div>
To set the custom link in the Global header the following steps needs to be done</div>
<br />
<div>
<ol style="text-align: left;">
<li><span style="color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 19.6px;">Update the customlinks.xml File"</span></li>
<li><span style="color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 19.6px;">Add the CustomLinks Element"</span></li>
<li><span style="color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 19.6px;">Setting the Custom Links Privilege"</span></li>
</ol>
<div>
<span style="color: #222222; font-family: Helvetica Neue, Neue Helvetica, Arial, sans-serif;"><span style="font-size: 14px; line-height: 19.6px;"><br /></span></span></div>
</div>
<div>
<span style="color: #222222; font-family: Helvetica Neue, Neue Helvetica, Arial, sans-serif;"><span style="font-size: 14px; line-height: 19.6px;"><b>Step 1 - Open the customlinks.xml file from the following location</b></span></span></div>
<div>
<span style="color: #222222; font-family: Helvetica Neue, Neue Helvetica, Arial, sans-serif;"><span style="font-size: 14px; line-height: 19.6px;"><br /></span></span></div>
<div>
<span class="italic" style="background-color: white; box-sizing: border-box; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; font-style: italic; line-height: 19.6px;">ORACLE_INSTANCE</span><span style="background-color: white; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 19.6px;">\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips</span></div>
<div>
<span style="background-color: white; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 19.6px;"><br /></span></div>
<div>
<span style="background-color: white; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 19.6px;">And change the file as shown below</span></div>
<div>
<span style="background-color: white; color: #222222; font-family: 'Helvetica Neue', 'Neue Helvetica', Arial, sans-serif; font-size: 14px; line-height: 19.6px;"><br /></span></div>
<div>
<span style="background-color: white;"><span style="font-family: Helvetica Neue, Neue Helvetica, Arial, sans-serif;"></span></span><br />
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<span style="background-color: white;"><span style="font-family: Helvetica Neue, Neue Helvetica, Arial, sans-serif;"><?xml version="1.0" encoding="ASCII"?></span></span></div>
<span style="background-color: white;"><span style="font-family: Helvetica Neue, Neue Helvetica, Arial, sans-serif;">
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<customLinks xmlns="com.siebel.analytics.web/customlinks/v1"></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<link id="l1" name="OTN" description="OTN open in new window" src="http://www.oracle.com" target="blank" ></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<locations></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<location name="header"/></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
</locations></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
</link></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<br /></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<link id="l2" name="Google Search" description="Google open in named window" src="http://www.google.com/" target="google" iconSmall="common/info_ena.png" ></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<locations></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<location name="header" insertBefore="advanced"/></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
</locations></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
</link></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<br /></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<link id="l3" name="Yahoo" description="Yahoo" src="http://www.yahoo.com" target="yahoo" iconLarge="common/helptopics_lg_qualifier.png"></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<locations></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<location name="getstarted"/></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
</locations></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
</link></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<br /></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<link id="l5" name="Gmail" description="gmail" src="http://www.gmail.com" target="blank" iconLarge="common/gmail.png" ></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<locations></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<location name="getstarted"/></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<location name="header" insertBefore="catalog"/></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
</locations></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
</link></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
</customLinks></div>
<div style="color: blue; font-size: 14px; line-height: 19.6px;">
<br /></div>
<div style="font-size: 14px; line-height: 19.6px;">
<br /></div>
<div style="font-size: 14px; line-height: 19.6px;">
<b>Step 2 <span style="color: #222222; line-height: 19.6px;">To add the CustomLinks element in instance config file</span></b></div>
<div style="font-size: 14px; line-height: 19.6px;">
<span style="color: #222222; line-height: 19.6px;"><br /></span></div>
<div style="font-size: 14px; line-height: 19.6px;">
<span style="color: #222222; line-height: 19.6px;">Open the instanceconfig.xml file and add the following tag anywhere inside the </ServerInstance> tag</span></div>
<div style="font-size: 14px; line-height: 19.6px;">
<span style="color: #222222; line-height: 19.6px;"><br /></span></div>
<div style="font-size: 14px; line-height: 19.6px;">
<span style="color: #222222; line-height: 19.6px;"><br /></span></div>
<div>
<div>
<span style="font-size: 14px; line-height: 19.6px;"><span style="color: blue;"><CustomLinks></span></span></div>
<div>
<span style="color: blue;"><span style="font-size: 14px; line-height: 19.6px;"> <Enabled>false</Enabled></span><span style="font-size: 14px; line-height: 19.6px;"> <filePath></span><span class="italic" style="box-sizing: border-box; font-size: 14px; font-style: italic; line-height: 19.6px;">ORACLE_INSTANCE</span><span style="font-size: 14px; line-height: 19.6px;">\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips</span><span style="font-size: 14px; line-height: 19.6px;">\customlinks.xml</filePath></span></span></div>
<div>
<span style="font-size: 14px; line-height: 19.6px;"><span style="color: blue;"></CustomLinks></span></span></div>
<div style="color: #222222; font-size: 14px; line-height: 19.6px;">
<br /></div>
</div>
<div style="color: #222222; font-size: 14px; line-height: 19.6px;">
<b>Step 3 Privileges</b></div>
<div style="color: #222222; font-size: 14px; line-height: 19.6px;">
<br /></div>
<div style="color: #222222; font-size: 14px; line-height: 19.6px;">
<span style="line-height: 19.6px;">If you want users to see the customizations that you have made, then you must ensure that the Custom Links privilege is assigned to the BI Consumer role, which occurs by default. You cannot assign this privilege to individual users, groups, or roles other than BI Consumer</span></div>
<div style="color: #222222; font-size: 14px; line-height: 19.6px;">
<span style="line-height: 19.6px;"><br /></span></div>
<div style="color: #222222; font-size: 14px; line-height: 19.6px;">
<span style="line-height: 19.6px;"><a href="http://docs.oracle.com/cd/E23943_01/bi.1111/e10541/answersconfigset.htm#BIESG1728" target="_blank">Oracle doc</a> </span></div>
<div style="color: #222222; font-size: 14px; line-height: 19.6px;">
<span style="line-height: 19.6px;"><br /></span></div>
<div style="color: #222222; font-size: 14px; line-height: 19.6px;">
<span style="line-height: 19.6px;">Thanks,</span></div>
<div style="color: #222222; font-size: 14px; line-height: 19.6px;">
<span style="line-height: 19.6px;">Sandeep</span></div>
<div style="color: #222222; font-size: 14px; line-height: 19.6px;">
<br /></div>
</span></span></div>
</div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-62843719363741825002015-09-04T13:21:00.001-04:002015-09-04T15:54:03.661-04:00How to create Multiple OBIEE instances on the same Server Machine<div dir="ltr" style="text-align: left;" trbidi="on">
<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/AVvXsEjeCOMbGzpDks_4UVTTyzzQGgDxG8IxUldqTWC4eZrb3-emaAzLT8J2y8oJ3RXuzTF17hM4iP8t_3xe37k40yXJS6u0DawxvCxIrat65-3nBmh5u3rHGclMrrDt3zlSSpcPWk-QfpAyS1Y/s1600/how+to.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeCOMbGzpDks_4UVTTyzzQGgDxG8IxUldqTWC4eZrb3-emaAzLT8J2y8oJ3RXuzTF17hM4iP8t_3xe37k40yXJS6u0DawxvCxIrat65-3nBmh5u3rHGclMrrDt3zlSSpcPWk-QfpAyS1Y/s640/how+to.png" width="640" /></a></div>
<br />
<br />
<div style="text-align: justify;">
Following are the steps to create a new OBIEE instance on an existing obiee instance . This new instance will behave completely independently environment and will be having an enterprise manager and manged sever for its own.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
This new instance INSTANCE 2 can have complete customization and will not be impacting the existing INSTANCE 1 </div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
RCU Creation : The new instance will need a new BIPLATFORM AND MDS schema and install this using the RCU utilitlity.</div>
<ol style="text-align: left;"><ol>
<li>for MS SQL server run the following script before the RCU creation </li>
</ol>
</ol>
<br />
<span style="color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">ALTER database <DATABASENAME>SET READ_COMMITTED_SNAPSHOT ON</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> <o:p></o:p></span><br />
<span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"><br /></span>
<span style="color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">ALTER DATABASE </span><span style="color: green; font-family: 'Segoe UI', sans-serif; font-size: 13.3333px;"><DATABASENAME> </span><span style="color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">COLLATE LATIN1_GENERAL_CS_AS <o:p></o:p></span><br />
<span style="color: green; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;"><br /></span>
<br />
<span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">DECLARE</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> @collate </span><span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">sysname</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"><br />
</span><span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">SELECT</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> @collate </span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">=</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> </span><span style="color: magenta; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">convert</span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">(</span><span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">sysname</span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">,</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> </span><span style="color: magenta; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">serverproperty</span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">(</span><span style="color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">'COLLATION'</span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">))</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"><br />
</span><span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">IF</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> </span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">(</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> </span><span style="color: magenta; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">charindex</span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">(</span><span style="color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">N'_CI'</span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">,</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> @collate</span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">)</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> </span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">></span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> 0 </span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">)</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"><br />
</span><span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">BEGIN</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"><br />
</span><span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">select</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> @collate </span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">=</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> </span><span style="color: magenta; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">replace</span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">(</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;">@collate</span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">,</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> </span><span style="color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">N'_CI'</span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">,</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> </span><span style="color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">N'_CS'</span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">)</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"><br />
</span><span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">exec</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> </span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">(</span><span style="color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">'ALTER
database </span><span style="color: green; font-family: 'Segoe UI', sans-serif; font-size: 13.3333px;"><DATABASENAME></span><span style="color: red; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">COLLATE '</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> </span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">+</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"> @collate</span><span style="color: grey; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">)</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"><br />
</span><span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">END</span><span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"><br />
</span><span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">GO</span><br />
<span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;"><br /></span>
<span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqQ0E0ztKXYzLh9s3srxqIvS8_m1hPpcY5zY2P0gOs0yD8XUSlNBJeQt2_VOu4_EI-_ML-8pzIgU_QEbCrPLJ1UKBGTHXbx1vqRXrLKSh3CA1UbUyU7Kndk4WmB9FmTdlka3nXH4dvxgA/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqQ0E0ztKXYzLh9s3srxqIvS8_m1hPpcY5zY2P0gOs0yD8XUSlNBJeQt2_VOu4_EI-_ML-8pzIgU_QEbCrPLJ1UKBGTHXbx1vqRXrLKSh3CA1UbUyU7Kndk4WmB9FmTdlka3nXH4dvxgA/s1600/1.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLeeAPJTL4aBRwKRmfdnn8MAfFooxk4XWw1IllDwTcLF_HmU64HdPmRbHiRANdh_EO1CB-4c-SqPUxk83AHqp6_KZl1rNwyJd98ZJv0i1xpV4Cyx1KXNjSczaCtGcsIg5vtOASM4bT3PI/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLeeAPJTL4aBRwKRmfdnn8MAfFooxk4XWw1IllDwTcLF_HmU64HdPmRbHiRANdh_EO1CB-4c-SqPUxk83AHqp6_KZl1rNwyJd98ZJv0i1xpV4Cyx1KXNjSczaCtGcsIg5vtOASM4bT3PI/s1600/2.png" /></a></div>
<br />
<br />
<br />
<br />
Configuring the new INSTANCE 2<br />
<br />
Navigate to ORACLEBI1\BIN<br />
<br />
run CONFIG.BAT<br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMGP0ZVlb1x-0s4UXHFOruaXM2qIf05ngKW3j8t76A-Axn6RYVlW0wvrCXfu0RvpWo7zuefUTVUFiXhS0gFeLnyNm9J-cbpsKFJKPYUdAL2OrDuuzv7ZMxc8rRK49O838VlWYBkHEHl_s/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMGP0ZVlb1x-0s4UXHFOruaXM2qIf05ngKW3j8t76A-Axn6RYVlW0wvrCXfu0RvpWo7zuefUTVUFiXhS0gFeLnyNm9J-cbpsKFJKPYUdAL2OrDuuzv7ZMxc8rRK49O838VlWYBkHEHl_s/s1600/3.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC9xxiFta8cGVz9nwcyk4T3jPKtD-VQt0kxAhhyphenhyphengr9CAqWkXm87oH0HxB5-KByEV7KIGDGc1NzeZRb1c9fTBOgBcE_55vZaH9VocFt_PS2YPlfS5M1RdMCjcbKsktrtDUa2OVfbLbsYzY/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC9xxiFta8cGVz9nwcyk4T3jPKtD-VQt0kxAhhyphenhyphengr9CAqWkXm87oH0HxB5-KByEV7KIGDGc1NzeZRb1c9fTBOgBcE_55vZaH9VocFt_PS2YPlfS5M1RdMCjcbKsktrtDUa2OVfbLbsYzY/s1600/4.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizhihOGfHCmA7zQ8FkoE41J1ltvM9FLDGjq6g5_LT_R0J824RKu_iUKF9jCYWfR6jM7t7bQQwXY4w5CYJUqu6A6LYnpWz8r4b68nIsLjRH7S6IS8h3pDWD5zFdp123Okfy5OBo4ugg8U0/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizhihOGfHCmA7zQ8FkoE41J1ltvM9FLDGjq6g5_LT_R0J824RKu_iUKF9jCYWfR6jM7t7bQQwXY4w5CYJUqu6A6LYnpWz8r4b68nIsLjRH7S6IS8h3pDWD5zFdp123Okfy5OBo4ugg8U0/s1600/5.png" /></a></div>
<br />
<br />
Enter a new domain new which is different from the existing bifoundation_domin<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZDSAkvhrwKCl_tM_r_UJznLZ-lpr6NI5uoURFs5PGQ3MNRbeCl3UwAQ0azuHgwf3qEFQCfQ_q41xboZdO-rTJBLNh_Ck5Dakkavn9mb4uVtRWistevs7fvFF8iPihSnFhA8Sv9SrL-HA/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZDSAkvhrwKCl_tM_r_UJznLZ-lpr6NI5uoURFs5PGQ3MNRbeCl3UwAQ0azuHgwf3qEFQCfQ_q41xboZdO-rTJBLNh_Ck5Dakkavn9mb4uVtRWistevs7fvFF8iPihSnFhA8Sv9SrL-HA/s1600/6.png" /></a></div>
<br />
<br />
<b>Set the parameters as below</b><br />
<br />
Middle ware home : Current middle ware home<br />
Oracle Home : Current Oracle Home (this will be the shared binaries for both the instances)<br />
Weblogic Server Home : Current weblogic server home<br />
<br />
Domain Home : The new domain that was created<br />
<br />
Instance Name : Give a new name for the instance (instance_QA, instace_TEST) ETC.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXIu0JCAAFrhL7rPTS8zhzChUzDU0NP-gtPU1gIBzXIeuDcgfejvx78uKLvI6_IvnvwOt6-DghFQveprQXtDRTujTvyAyKi7QeOLabfH47RKmb-VbEOxHOSXHwPnknX9T75tHIKo4AcHg/s1600/7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXIu0JCAAFrhL7rPTS8zhzChUzDU0NP-gtPU1gIBzXIeuDcgfejvx78uKLvI6_IvnvwOt6-DghFQveprQXtDRTujTvyAyKi7QeOLabfH47RKmb-VbEOxHOSXHwPnknX9T75tHIKo4AcHg/s1600/7.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEja-KnGe0LgEUhuYdCY4S3EXo78Gbxl77-jK8NSWcb30rwBgmWn5ovC_LWwigwiKjaOLP-GuU-y2lvj2yzaiTfixSKv__vTwtg0jyTmapyVg4bLpcmJn2LD9RecSmchJGc50kwtxTidjT4/s1600/8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEja-KnGe0LgEUhuYdCY4S3EXo78Gbxl77-jK8NSWcb30rwBgmWn5ovC_LWwigwiKjaOLP-GuU-y2lvj2yzaiTfixSKv__vTwtg0jyTmapyVg4bLpcmJn2LD9RecSmchJGc50kwtxTidjT4/s1600/8.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<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/AVvXsEhj68qxvBqbhqxhfqINrge0WVJ7S7oFBqTuiSrJEJg9lAiUws3AEkLRaM-gIFuazx2P-vMxrJTP-kvgbEs4kdklR3b2DbGlp4MvhPvO3-LctqP5lSoA8OJfxmayy0xufGJmUoxgY0rTUjU/s1600/9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhj68qxvBqbhqxhfqINrge0WVJ7S7oFBqTuiSrJEJg9lAiUws3AEkLRaM-gIFuazx2P-vMxrJTP-kvgbEs4kdklR3b2DbGlp4MvhPvO3-LctqP5lSoA8OJfxmayy0xufGJmUoxgY0rTUjU/s1600/9.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEu7NTwVeKjcVzXjcYsUsEUsAoBK0klg5pwt6jVvyl6Iv0fj_bpcMQoji_Z0gcwZw2e1BikSN086RGUdhQHiceLyddW1Q_2Dl1lrlUxtyju-scoJbJn16KEB3NhoY-Bda0OvzreY42Zis/s1600/10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEu7NTwVeKjcVzXjcYsUsEUsAoBK0klg5pwt6jVvyl6Iv0fj_bpcMQoji_Z0gcwZw2e1BikSN086RGUdhQHiceLyddW1Q_2Dl1lrlUxtyju-scoJbJn16KEB3NhoY-Bda0OvzreY42Zis/s1600/10.png" /></a></div>
<span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;"><br /></span>
<span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZta1CvuG_JQzDwhj3ctoDFZWnb-BEI9Q81FBkIgnDuc3LzJFI2-XNR3V5mT09RjoylkuZcD4V56xZFSIYur1fAuw57-bqlvkIcqRrz9RK_4Y8-IjGzXgFk08LRKr1QC9cI59pVopMwOI/s1600/12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZta1CvuG_JQzDwhj3ctoDFZWnb-BEI9Q81FBkIgnDuc3LzJFI2-XNR3V5mT09RjoylkuZcD4V56xZFSIYur1fAuw57-bqlvkIcqRrz9RK_4Y8-IjGzXgFk08LRKr1QC9cI59pVopMwOI/s1600/12.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdEkXm4EziIopMWD_QrbuEKmxfISf-f0pKQ2Kjq9OWNY0YqaZHkxl6X4IMkW_JKU15y8jO0zgJxievg8M-5g5gREPqH7Nx5N5txrbfWl9fag36Cl4RQ3LxsPnQbph9o2ALxvYxturoH3M/s1600/13.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdEkXm4EziIopMWD_QrbuEKmxfISf-f0pKQ2Kjq9OWNY0YqaZHkxl6X4IMkW_JKU15y8jO0zgJxievg8M-5g5gREPqH7Nx5N5txrbfWl9fag36Cl4RQ3LxsPnQbph9o2ALxvYxturoH3M/s1600/13.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigHlKjQEjzXbHAMxyHuhmilZf03Nm5sPlTsxfUMS6eFrhGlqEyq1bvjhEmVB962TyZgM_U_OcM6ewqxm4Q5a4ujV1AmMbHnstz3mTboVYUlMUC7PIMHUUePsiN5xD52VpJUa0EKNobBIo/s1600/14.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigHlKjQEjzXbHAMxyHuhmilZf03Nm5sPlTsxfUMS6eFrhGlqEyq1bvjhEmVB962TyZgM_U_OcM6ewqxm4Q5a4ujV1AmMbHnstz3mTboVYUlMUC7PIMHUUePsiN5xD52VpJUa0EKNobBIo/s1600/14.png" /></a></div>
<br />
<span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;"><br /></span>
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhX3RTLynn7IL8cfarLcOSZLAKUiWxCmAQD5e1AKzSl0lD4WtL2ePxeZ80_VQb-nXVlcACv4cJwOIq3Ghe2hjySD-yvYf8tauXEROri9fFcwsCa_FydLK3j5Luy7COUGeBxLvm71HJ3SsA/s1600/15.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/AVvXsEhX3RTLynn7IL8cfarLcOSZLAKUiWxCmAQD5e1AKzSl0lD4WtL2ePxeZ80_VQb-nXVlcACv4cJwOIq3Ghe2hjySD-yvYf8tauXEROri9fFcwsCa_FydLK3j5Luy7COUGeBxLvm71HJ3SsA/s1600/15.png" /></a>Now the new instance is created and can be used completely Independent from the instance 1<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8le1sFfsIgfOjz-ks3NHAEUvDQcCar_GgCxmVTk13ROgfyeyBP80RlW9f9mXCKjbmgqatFvwqgVcyA1MVUvVvG1XdaeV6E3c4gD0RSAywkxjPqC1QW3EpdaE1VortVhtOHZAnfMwbFAI/s1600/a.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8le1sFfsIgfOjz-ks3NHAEUvDQcCar_GgCxmVTk13ROgfyeyBP80RlW9f9mXCKjbmgqatFvwqgVcyA1MVUvVvG1XdaeV6E3c4gD0RSAywkxjPqC1QW3EpdaE1VortVhtOHZAnfMwbFAI/s1600/a.PNG" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSeCNLmctl92Y3_njlONd9GErIALLOVIIco9JOCC0CTSP4hcWDL27y-PIs5aTMkw7D2bvT-5H4Dtio9EqvfY2LSAU97-YKz8hmyF8jHZ4EgmU4RIWw_X7g_JTiJEn-yEY37_D4D0r577Y/s1600/b.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSeCNLmctl92Y3_njlONd9GErIALLOVIIco9JOCC0CTSP4hcWDL27y-PIs5aTMkw7D2bvT-5H4Dtio9EqvfY2LSAU97-YKz8hmyF8jHZ4EgmU4RIWw_X7g_JTiJEn-yEY37_D4D0r577Y/s1600/b.PNG" /></a></div>
<br />
<br />
<br />
<br />
<span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;"><br /></span>
<span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;"><br /></span>
<span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">Thanks ,</span><br />
<span style="color: blue; font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">Sandeep</span></div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-17617647995123367412015-07-09T12:55:00.000-04:002015-07-09T12:55:37.279-04:00OBIEE 11.1.1.9.0 Sample App 506 and new Features<div dir="ltr" style="text-align: left;" trbidi="on">
Hi Everyone,<br />
<br />
The sample app 506 for OBIEE 11.1.1.9.0 is available for download and the detailed features of the package is available here<br />
<br />
<a href="http://www.oracle.com/technetwork/topics/virtualization/whatsnew/506whatsnew1-2592803.pdf">http://www.oracle.com/technetwork/topics/virtualization/whatsnew/506whatsnew1-2592803.pdf</a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/gj5K5k6Kx4s/0.jpg" src="https://www.youtube.com/embed/gj5K5k6Kx4s?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
Sample App 506 details are as below<br />
<br />
<br />
<ol style="text-align: left;">
<li>Oracle Enterprise Linux 6.5 x64 </li>
<li>OBIEE 11.1.1.9 GA two distinct OBIEE instances, Essbase 11.1.2.4,
updated BIMAD </li>
<li>Oracle MapViewer 11.1.1.9.1 </li>
<li>Oracle BICS Data Sync v1 </li>
<li>Oracle Database 12c IMDB 12.1.0.2, PDB Install, AWM 12.1.0.2a,
APEX 4.2.6 & ORDS 2.0.1, ODM, Oracle Spatial and Graph </li>
<li>ORE 1.4.1 & R-3.1.1 </li>
<li>ENDECA 3.1, Server 7.6.1,Studio 3.1, Provisioning Services </li>
<li>Cloudera CDH 5.1.2, Oracle BigData SQL, Oracle BigData Connectors </li>
<li>Plug and Play Companions : EPM 11.1.2.3, BIApps Demos </li>
<li>Utils : Start scripts, MapBuilder, SQLDev 4.1</li>
</ol>
<div>
Sandeep</div>
<div>
<br /></div>
</div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-30666489706223801422015-06-01T15:53:00.000-04:002015-06-01T15:56:28.356-04:00Edge Browser Is Faster than Chrome<div dir="ltr" style="text-align: left;" trbidi="on">
<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/AVvXsEgoUEaecM9xnYhPhVsJNGtZW9eXRXNDsKNSWMK2UgP53CIUhiDjvTJrchnSX22-W2Lg1g8heqQjrWfAc-uzTFV2W61xC387mgqQjmtGSE8ql1YqOU75SUcknVEkD8Z58BWwMNaJHL8kRc8/s1600/browser_logos_2015.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="422" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoUEaecM9xnYhPhVsJNGtZW9eXRXNDsKNSWMK2UgP53CIUhiDjvTJrchnSX22-W2Lg1g8heqQjrWfAc-uzTFV2W61xC387mgqQjmtGSE8ql1YqOU75SUcknVEkD8Z58BWwMNaJHL8kRc8/s640/browser_logos_2015.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></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/AVvXsEh1fM1xw5D4QczKbp4dDJdoLO-d96Xy6RwSJUWOZLnNMS8fFsO7xzBMWCjLTlPDtlHNkW3Y_jH8_oMj4WL_t4-MYHqAMFBMQwj1jS54qc8jiowQjy2W896w0NXrTKMuYwx4uSZGcdIg1UQ/s1600/edge.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1fM1xw5D4QczKbp4dDJdoLO-d96Xy6RwSJUWOZLnNMS8fFsO7xzBMWCjLTlPDtlHNkW3Y_jH8_oMj4WL_t4-MYHqAMFBMQwj1jS54qc8jiowQjy2W896w0NXrTKMuYwx4uSZGcdIg1UQ/s1600/edge.png" /></a></div>
<br />
<div class="mgbot_20" style="letter-spacing: -0.100000001490116px; line-height: 21px; margin-bottom: 20px !important; padding: 0px; text-align: justify;">
<span style="font-family: Arial, Helvetica, sans-serif;">Microsoft used JetStream and Octane 2.0 benchmarks to show that Edge is faster than Internet Explorer, <a href="http://www.softpedia.com/get/Internet/Browsers/Google-Chrome.shtml" style="color: #002873; cursor: pointer;" target="_blank"><span style="font-weight: 700;">Google Chrome</span></a>, and <a href="http://www.softpedia.com/get/Internet/Browsers/Mozilla-Firefox-Final.shtml" style="color: #002873; cursor: pointer;" target="_blank"><span style="font-weight: 700;">Mozilla Firefox</span></a>. Interestingly, both JetStream and Octane were designed by Microsoft rivals, namely Apple and Google, respectively, so the software giant might have a point when trying to prove that Edge really is a fast app.</span></div>
<div class="mgbot_20" style="letter-spacing: -0.100000001490116px; line-height: 21px; margin-bottom: 20px !important; padding: 0px; text-align: justify;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTBUuyUbxenKQ_-yFdWeHAYdBDO4SxWw9E_VKWKTdz5DKh1fErg_620oe0MwJadKpAwZwZgqTpZLo9E69Q-e9aGDj1cz8rNVv_GJnK0HR6bUZkq9SKoC2gwdqINTT9U5cnDtRdLc0Nmn0/s1600/edge3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="356" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTBUuyUbxenKQ_-yFdWeHAYdBDO4SxWw9E_VKWKTdz5DKh1fErg_620oe0MwJadKpAwZwZgqTpZLo9E69Q-e9aGDj1cz8rNVv_GJnK0HR6bUZkq9SKoC2gwdqINTT9U5cnDtRdLc0Nmn0/s640/edge3.jpg" width="640" /></a></div>
<div class="mgbot_20" style="letter-spacing: -0.100000001490116px; line-height: 21px; margin-bottom: 20px !important; padding: 0px;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="mgbot_20" style="letter-spacing: -0.100000001490116px; line-height: 21px; margin-bottom: 20px !important; padding: 0px; text-align: justify;">
<span style="font-family: Arial, Helvetica, sans-serif;">Octane 2.0 is a benchmark that measures the performance of the JavaScript engine and includes a series of tests that can be performed not only on PCs but also on smartphones and tablets. Workloads and execution profiles of real web applications are measured by Octane, with its developers saying that its goal “is to be a proxy for JavaScript applications.”</span></div>
<div class="mgbot_20" style="letter-spacing: -0.100000001490116px; line-height: 21px; margin-bottom: 20px !important; padding: 0px; text-align: justify;">
<span style="font-family: Arial, Helvetica, sans-serif;">JetStream, on the other hand, includes a variety of benchmarks, such as SunSpider 1.0.2 and Octane 2 JavaScript and covers both classical performance improvements and real-world examples.</span></div>
<div class="mgbot_20" style="letter-spacing: -0.100000001490116px; line-height: 21px; margin-bottom: 20px !important; padding: 0px; text-align: justify;">
<span style="font-family: Arial, Helvetica, sans-serif;">As you can see, Microsoft Edge topped competition in both of them and Microsoft says that improvements that will be implemented in the coming months, as development of the new browser advances, will make it even faster.</span></div>
</div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0tag:blogger.com,1999:blog-9182442486536672082.post-45648118452248824052015-06-01T15:44:00.002-04:002015-06-30T11:54:39.632-04:00Windows 10 on July 29<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVbG8KUm5XzNB543ELR4QXZBOyxZKzFtQzTWIjHIL8NB5BJrxytLyHZnGele4AW3FtNi1HG9tdlt2bYMeslaUqwwEUGBCmOdtT3oA2OIK1VCDApZD6RwKDWAoa0lCj_mHjqMtw9459-lE/s1600/10.1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVbG8KUm5XzNB543ELR4QXZBOyxZKzFtQzTWIjHIL8NB5BJrxytLyHZnGele4AW3FtNi1HG9tdlt2bYMeslaUqwwEUGBCmOdtT3oA2OIK1VCDApZD6RwKDWAoa0lCj_mHjqMtw9459-lE/s640/10.1.jpg" width="640" /></a></div>
<span style="background-color: white; color: #444444; font-family: Helvetica, Arial, sans-serif; font-size: 16.5px; line-height: 28.0499992370605px;"><br /></span>
<span style="background-color: white; color: #444444; font-family: Helvetica, Arial, sans-serif; font-size: 16.5px; line-height: 28.0499992370605px;">Microsoft announced today that it will be </span><a href="http://www.theverge.com/2015/6/1/8511287/microsoft-windows-10-release-date-july" sl-processed="1" style="background: rgb(255, 255, 255); box-sizing: border-box; color: #fa4b2a; font-family: Helvetica, Arial, sans-serif; font-size: 16.5px; line-height: 28.0499992370605px; text-decoration: none;">launching Windows 10 on July 29th</a><span style="background-color: white; color: #444444; font-family: Helvetica, Arial, sans-serif; font-size: 16.5px; line-height: 28.0499992370605px;">, encouraging Windows 7 and 8.1 users to reserve their free upgrade with a notification in their task bar. However, while the company has been busy </span><a href="https://www.youtube.com/watch?v=3ngnzY5xtI8" sl-processed="1" style="background: rgb(255, 255, 255); box-sizing: border-box; color: #fa4b2a; font-family: Helvetica, Arial, sans-serif; font-size: 16.5px; line-height: 28.0499992370605px; text-decoration: none;" target="_blank">highlighting all the shiny new features</a><span style="background-color: white; color: #444444; font-family: Helvetica, Arial, sans-serif; font-size: 16.5px; line-height: 28.0499992370605px;"> in the upcoming OS, it's been a bit quieter when it comes to spelling out the </span><a href="https://www.microsoft.com/en-us/windows/windows-10-specifications" sl-processed="1" style="background: rgb(255, 255, 255); box-sizing: border-box; color: #fa4b2a; font-family: Helvetica, Arial, sans-serif; font-size: 16.5px; line-height: 28.0499992370605px; text-decoration: none;" target="_blank">limitations</a><span style="background-color: white; color: #444444; font-family: Helvetica, Arial, sans-serif; font-size: 16.5px; line-height: 28.0499992370605px;"> — including making updates automatic for Windows 10 Home users.</span><br />
<span style="background-color: white; color: #444444; font-family: Helvetica, Arial, sans-serif; font-size: 16.5px; line-height: 28.0499992370605px;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1Y_rP13cIBodA5r7DtZzT0Y18naI4CPvQoozvWjeOw-JWXpz9-8T7vz_cMrO2WErkA1euIk0csK-cQ3gE_2YB6P49R59bXGZ0_PQGC-itlSCgZEu_UTToVcjjwUZtyFrGAmf1CU-DnGo/s1600/10.3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1Y_rP13cIBodA5r7DtZzT0Y18naI4CPvQoozvWjeOw-JWXpz9-8T7vz_cMrO2WErkA1euIk0csK-cQ3gE_2YB6P49R59bXGZ0_PQGC-itlSCgZEu_UTToVcjjwUZtyFrGAmf1CU-DnGo/s640/10.3.png" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxd_XArcWa5pEDgyk6MQrYsgm-d-YRdEnsy86higlZA6NX69wfqkadM-EJ6jTYdYshwOo69Uw61SGN-eOrFMWsuPmTvW4DHQvHkkPrdAuaomOJTtsjYpTyiRoyCpsqbQWGqxC7JDQBDMc/s1600/10.4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxd_XArcWa5pEDgyk6MQrYsgm-d-YRdEnsy86higlZA6NX69wfqkadM-EJ6jTYdYshwOo69Uw61SGN-eOrFMWsuPmTvW4DHQvHkkPrdAuaomOJTtsjYpTyiRoyCpsqbQWGqxC7JDQBDMc/s640/10.4.jpg" width="640" /></a></div>
<span style="background-color: white; color: #444444; font-family: Helvetica, Arial, sans-serif; font-size: 16.5px; line-height: 28.0499992370605px;"><br /></span></div>
testhttp://www.blogger.com/profile/14999529395242178412noreply@blogger.com0