tag:blogger.com,1999:blog-6767275433165822862024-03-05T14:04:15.237-08:00OBIEE10G & 11G Knowledge SharingUnknownnoreply@blogger.comBlogger21125tag:blogger.com,1999:blog-676727543316582286.post-10494466482594983602014-06-23T03:34:00.000-07:002014-06-23T03:37:35.168-07:00Stopping and Starting OBIEE Services in linux<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 style="text-align: center;">
Stopping and Starting OBIEE Services in linux</h2>
<div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">STOP OBIEE Services:</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
1. <strong style="font-style: inherit; line-height: 1.7;">Shutdown OPMN Components</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
Oracle Process Manager should be used to shutdown all system components.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
Go to> /u01/app/Middleware/instances/instance1/bin</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
cd /u01/app/Middleware/instances/instance1/bin</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
./opmnctl stopall</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<br /></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
2<strong style="font-style: inherit; line-height: 1.7;">.</strong><strong style="font-style: inherit; line-height: 1.7;">Shutdown Managed Server</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
Go to > /u01/app/Middleware/user_projects/domains/bifoundation_domain/bin</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
cd /u01/app/Middleware/user_projects/domains/bifoundation_domain/bin</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
./stopManagedWebLogic.sh bi_server1 t3://obie.new.com:7001 weblogic weblogic</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
Verify that the Managed Server has shut down completely with ps -ef | grep bi_server1.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
3. <strong style="font-style: inherit; line-height: 1.7;">Shutdown Node Manager</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
There should be a single Node Manager for the machine. Shut it down with the command below.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<br /></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
ps -ef | grep Node | grep nodemanager | grep -v grep | cut -c10-15</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
kill -9 ####</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
4<strong style="font-style: inherit; line-height: 1.7;">. </strong><strong style="font-style: inherit; line-height: 1.7;">Shutdown Admin Server</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
There should be a single Node Manager for the machine. Shut it down with the command below.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
Go to> /u01/app/Middleware/user_projects/domains/bifoundation_domain/bin</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
./stopWebLogic.sh weblogic weblogic t3://obie.new.com:7001</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
Verify that the Managed Server has shut down completely with ps -ef | grep AdminServer.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<br /></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">START OBIEE SERVICES:</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
1. <strong style="font-style: inherit; line-height: 1.7;">Start Admin Server</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
cd /u01pt/app/Middleware/user_projects/domains/bifoundation_domain/bin</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
weblogic ./startWebLogic.sh -Dweblogic.management.username= weblogic Dweblogic.management.password=weblogic</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
tail -f weblogic.out </div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">Weblogic.out is log file which logs the running status</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
After issuing the start command we tail the log until we see the message below, indicating that the server has started successfully.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<WebLogicServer> <BEA-000360> <Server started in RUNNING mode></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<br /></div>
<ol start="2" style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin: 0px 0px 0.825em 2.5em; padding: 0px;">
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;"><strong style="font-style: inherit; line-height: 1.7;">StartNode Manager</strong></li>
</ol>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
cd /u01/app/Middleware/wlserver_10.3/server/bin</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
nodemanager ./startNodeManager.sh > nodemanager.out &</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
tail -f nodemanager.out</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<br /></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
nodemanager.out is log file which logs the running status</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<br /></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
After issuing the start command we tail the log until we see the message below, indicating that the server has started successfully.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<Info> <Secure socket listener started on port ####></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<br /></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">3. Start Managed Server</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<br /></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
By default there should be one managed server, bi_server1 that we will start up. At this point you should start any other Managed Servers in this WebLogic domain.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
cd /u01/app/Middleware/wlserver_10.3/common/bin</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
./commEnv.sh</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
cd / u01/app/Middleware /user_projects/domains/bifoundation_domain/bin</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
./setDomainEnv.sh</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
weblogic ./startManagedWebLogic.sh bi_server1 t3://machine:7001 > bis1_startup.log &</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
tail weblogic.out</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<br /></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">Weblogic.out is log file which logs the running status</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
After issuing the start command we tail the log until we see the message below, indicating that the server has started successfully. Server started in RUNNING mode</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">4. Startup OPMN Components</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
Oracle Process Manager should be used to shutdown all system components.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
cd /u01/app/Middleware/instances/instance1/bin</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
./opmnctl startall</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
./opmnctl status</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<br /></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
Now you can login to console and verify the status of the running servers.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<br /></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
Hope it Helps !!</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
Thanks,</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
Shanmugha Bharathy G B</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23.799999237060547px; margin-bottom: 0.825em;">
<br /></div>
</div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-1764433517648270962014-03-21T03:06:00.000-07:002014-03-21T03:06:11.571-07:00Downgrading OBIEE RPD from 11.1.1.6 to 11.1.1.5 Version<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<b><span style="font-size: large;">"Downgrading OBIEE RPD from 11.1.1.6 to 11.1.1.5 Version"</span></b></div>
<div style="text-align: center;">
<br /></div>
<br />
<ul style="text-align: left;">
<li>Repository downgrade utility nqgenoldverrpd.exe is used to downgrade OBIEE RPD versions. </li>
<li>This utility was present in the 10.1.3.2.1 version of OBIEE but was removed in the later releases.</li>
</ul>
<u>Note:</u><br />
<br />
<ul style="text-align: left;">
<li>Using this Utility you cannot downgrade the RPD from 11g to 10g version. You can downgrade from one version to another 11g Versions.</li>
</ul>
<br />
Physical location of the nqgenoldverrpd.exe file will be<br />
1 ) If you are using Admin tool on your system , the directory path will be<br />
<br />
<BI_HOME>\bifoundation\server\bin<br />
<br />
2) If you are using Admin client, the directory path will be<br />
<br />
C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client11.1.1.6\oraclebi\orahome\bifoundation\server\bin<br />
<br />
<br />
Downgrading:<br />
<br />
1. Goto>StartMenu>All Programs>Oracle Business Intelligence Enterprise Edition<br />
2. Select BI Command Prompt<br />
3. Syntax for Downgrading<br />
nqgenoldverrpd [-P repository_password] -I input_repository_pathname –O <br />
output_repository_pathname -V version<br />
-P: your RPD password<br />
-I: Repository path and name<br />
-O: Repository path and new name of the rep you want to name for the downgraded version<br />
-V: To which version you want to downgrade.<br />
You can only generate repository of version 302 to 318 [ 318 being 11.1.1.6 Version].<br />
<br />
Downgrading Process:<br />
1. Copy the 11.1.1.6 RPD to a location you want to ( Here I copied the file to C drive)<br />
<br />
2. Now go to Run > Cmd and type the downgrade command as follows and hit enter<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJKV5xO3KhcoZObYo34WBl5G-2HNIM7kGffLnp_txQfdWCh0jI1BfDTuYkjD1I-bGXzYV7ojciX0xpjDYJXv9jndbID25EiC5QYGVEHoKJ8SGwm5vUj8775Xpg-MB0JGKR-4OmDCB4KxaN/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJKV5xO3KhcoZObYo34WBl5G-2HNIM7kGffLnp_txQfdWCh0jI1BfDTuYkjD1I-bGXzYV7ojciX0xpjDYJXv9jndbID25EiC5QYGVEHoKJ8SGwm5vUj8775Xpg-MB0JGKR-4OmDCB4KxaN/s1600/5.png" /></a></div>
<br />
<div>
3. After hitting Enter on successful downgrade completion you will get the below screen.</div>
<div>
<br /></div>
<img src="http://3.bp.blogspot.com/-MNr83zv3P2c/T_JB3xigtqI/AAAAAAAABZU/HYdNHpiScl0/s640/6.png" /><br />
<br />
Hope It Helps!!<br />
<br />
Thanks,<br />
Shanmugha Bharathy G B</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-53392957579586251092014-02-21T02:07:00.004-08:002014-02-21T02:07:57.976-08:00Custom Login pages,Images and Logos in OBIEE11G<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Arial, sans-serif; font-size: large;"><b><u>Custom Login pages,Images and Logos in OBIEE11G</u></b></span><br />
<span style="font-family: Arial, sans-serif; font-size: 14px;"><br /></span>
<span style="font-family: Arial, sans-serif; font-size: 14px;">1. Create a custom image in the standard size and keep in the following paths and restart the services .</span><br />
<span style="font-family: Arial, sans-serif; font-size: 14px;"><br /></span>
<br />
<div style="font-family: Arial, sans-serif; font-size: 14px;">
</div>
<ul style="text-align: left;">
<li>Drive:\Middleware\Oracle_BI1\bifoundation\web\app\res\sk_blafp\login</li>
<li>Drive:\Middleware\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\.appmergegen_1316154755380\analytics.ear\ukjjdc\res\sk_blafp\b_mozilla_4</li>
<li>Drive:\Middleware\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\.appmergegen_1316154755380\analytics.ear\ukjjdc\res\sk_blafp\login</li>
<li>Drive:\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\sk_blafp\b_mozilla_4</li>
<li>Drive:\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\sk_blafp\login</li>
</ul>
<div>
.appmergegen_1316154755380 this folder number may vary from from one server to another and if this folder is not present also dont worry let the image be replaced at rest of the folders and restart the services.</div>
<div>
<br /></div>
<div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2hemZHaY1PnmGA23laij9gXdtQ8Wos4oOA3B6ZxtuztV35HKwZcQE1Ou2vSiRpcNQ9DDFFqIpdZoj4EzoLvFhaTtOAlXqk-EYAeXEiQcxxzEzu7tVARp3BtwsYGfLPWLbxYAClXip4qLJ/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2hemZHaY1PnmGA23laij9gXdtQ8Wos4oOA3B6ZxtuztV35HKwZcQE1Ou2vSiRpcNQ9DDFFqIpdZoj4EzoLvFhaTtOAlXqk-EYAeXEiQcxxzEzu7tVARp3BtwsYGfLPWLbxYAClXip4qLJ/s1600/111.png" height="196" width="640" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<br />
<div>
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-62496367989579433562014-02-21T02:07:00.001-08:002014-02-21T02:07:21.347-08:00PATCH UPDATE (USERNAME/PASSWORD) ISSUE FACED FROM 11.1.1.6.0 TO 11.1.1.6.12<div dir="ltr" style="text-align: left;" trbidi="on">
PATCH UPDATE (USERNAME/PASSWORD) ISSUE FACED FROM 11.1.1.6.0 TO 11.1.1.6.12<br />
<br />
<br />
Hi,<br />
<br />
<br />
<ul style="text-align: left;">
<li>Recently we updated our OBIEE version from 11.1.1.6.0 to 11.1.1.6.12. </li>
<li>In 11.1.1.6.0 chrome was not working properly. Issues faced like catalog not opening and only loading symbol appears for long time.</li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsvnfM2kXDkxKkyp8B8c_3Ga4e1EabIG9RiQwfC2sXjVRJnU0oybGhkZSH_lVpk2fl3Hywzd983w6SO7f2ukwtF0tWnH0DcIpjTGi8-Zl69ANmUWm5Ycn0SD4yw9VqMRNrMhlkzXZkmbxa/s1600/11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsvnfM2kXDkxKkyp8B8c_3Ga4e1EabIG9RiQwfC2sXjVRJnU0oybGhkZSH_lVpk2fl3Hywzd983w6SO7f2ukwtF0tWnH0DcIpjTGi8-Zl69ANmUWm5Ycn0SD4yw9VqMRNrMhlkzXZkmbxa/s1600/11.png" height="209" width="640" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<ul style="text-align: left;">
<li>So we planned for patch update.</li>
<li>After patch update we dont find any issues which we faced earlier.</li>
<li>But during patch update automatically username and password has been changed by default.</li>
<li>For this we have to update username and password manually in two areas.</li>
<li>You will be getting Error cause : Error retrieving user/group data from Oracle BI Server's User Population API.</li>
<li>Solution :</li>
<li>Make sure have same password at the below</li>
<li>in Oracle Weblogic Server : Console / Home >Summary of Security Realms > myrealm > Users and Groups > BISystemUser</li>
<li>AND</li>
<li> in EM, weblogic domain > bifoundation_domain > Security > Credentials > oracle.bi.system -> system.user</li>
</ul>
<div>
Thanks,</div>
</div>
<div>
Shanmugha Bharathy G B</div>
<div>
Hope it Helps!</div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-43579064241479172322014-01-28T00:26:00.003-08:002014-01-28T00:26:51.119-08:00Custom Sign Out Text in OBIEE 11g<div dir="ltr" style="text-align: left;" trbidi="on">
<h2>
<span style="color: #1f497d;"><span style="font-size: 9px;"> </span></span></h2>
<h2>
<span style="color: #1f497d;"><span style="font-size: 9px;"><br /></span></span></h2>
<h2 style="text-align: left;">
<span style="color: #1f497d; font-size: x-large;"><u>Custom Sign Out Text in OBIEE 11g</u></span></h2>
<h2>
<ul style="text-align: left;">
<li><span style="color: #1f497d; font-size: small;">For Sign out text the changes to be done in productmessages.xml file.</span></li>
<li><span style="color: #1f497d; font-size: small;">D:\MiddlewareHome\Oracle_BI1\bifoundation\web\msgdb\l_en\messages </span></li>
<li><span style="color: #1f497d; font-size: small;">Search and replace FROM</span><span style="color: #1f497d; font-size: small;"> name="kmsgProductGeneral"><TEXT>ORACLE BUSINESS INTELLIGENCE</TEXT><HTML></span><span style="color: #1f497d; font-size: small;">ORACLE BUSINESS INTELLIGENCE</HTML></span></li>
<li><span style="color: #1f497d; font-size: small;">To your custom text as below </span><span style="color: #1f497d; font-size: small;">name="kmsgProductGeneral"><TEXT>SBL BUSINESS INTELLIGENCE</TEXT><HTML></span><span style="color: #1f497d; font-size: small;">SBL BUSINESS INTELLIGENCE</HTML></span></li>
<li><span style="color: #1f497d; font-size: small;">Text has been replaced in both the tags to display at sign page </span></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEdp8-mU5DmgTyt8aL7LdWOpqIVDClN5I3SSYJmReDuI1AzZYkWzCOJt12FIO8FhZlZb9FvkDTDJKh18TDvliV0f0K99x-inqeTRhqvNwGA_SHxP7dV9ozOeR2dZVHNi6RWYiZhNYM9e_x/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEdp8-mU5DmgTyt8aL7LdWOpqIVDClN5I3SSYJmReDuI1AzZYkWzCOJt12FIO8FhZlZb9FvkDTDJKh18TDvliV0f0K99x-inqeTRhqvNwGA_SHxP7dV9ozOeR2dZVHNi6RWYiZhNYM9e_x/s1600/111.png" /></a></div>
<div>
<span style="color: #1f497d; font-size: small;">Thanks,</span></div>
<div>
<span style="color: #1f497d; font-size: small;">Shanmugha Bharathy G B</span></div>
<div>
<span style="color: #1f497d; font-size: small;"><br /></span></div>
<div>
<span style="color: #1f497d; font-size: small;">Hope It Helps!!</span></div>
</h2>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-15641213647390964192014-01-28T00:15:00.002-08:002014-01-28T00:15:32.213-08:00Custom logo for Login and Home Page of OBIEE 11g<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 style="text-align: left;">
<span style="color: #1f497d;"><u><b>Custom logo for Login and Home Page of OBIEE 11g</b></u></span></h2>
<div class="MsoListParagraph" style="margin-left: 31.5pt; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #1f497d; text-indent: -0.25in;">1.<span style="font-size: 7pt;">
</span></span><span style="color: #1f497d; text-indent: -0.25in;">The changes of the
image are done in the below two folder paths.</span></div>
<div class="MsoListParagraph" style="margin-left: 31.5pt; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #1f497d;"><br /></span></div>
<div class="MsoListParagraph" style="margin-left: 31.5pt; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #1f497d;">Copy your image and paste in below mentioned two folders.</span></div>
<div class="MsoNormal" style="margin-left: 13.5pt;">
</div>
<ul style="text-align: left;">
<li><span style="color: #1f497d;">D:\MiddlewareHome\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\sk_blafp\b_mozilla_4\
oracle_logo.png</span></li>
<li><span style="color: #1f497d;">D:\MiddlewareHome\Oracle_BI1\bifoundation\web\app\res\sk_blafp\b_mozilla_4\
oracle_logo.png</span></li>
</ul>
<br />
<div class="MsoListParagraph" style="margin-left: 31.5pt; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]--><span style="color: #1f497d; mso-fareast-font-family: Calibri;">2.<span style="font-size: 7pt;">
</span></span><!--[endif]--><span style="color: #1f497d;">After the
replacement of the images cache from Administrative tool should be removed. <o:p></o:p></span></div>
<div class="MsoListParagraph" style="margin-left: 31.5pt;">
<span style="color: #1f497d;">Manage>cache>Edit>select
all>purge<o:p></o:p></span></div>
<div class="MsoListParagraph" style="margin-left: 31.5pt; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]--><span style="color: #1f497d; mso-fareast-font-family: Calibri;">3.<span style="font-size: 7pt;">
</span></span><!--[endif]--><span style="color: #1f497d;">Then go to
Presentation services and clear the cache and reload server metadata.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: 31.5pt;">
<span style="color: #1f497d;">Administration>Manage
Sessions>Cancel Running Request and Close all Cursors>back>Reload
files and Metadata.<o:p></o:p></span></div>
<div class="MsoListParagraph" style="margin-left: 31.5pt; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]--><span style="color: #1f497d; mso-fareast-font-family: Calibri;">4.<span style="font-size: 7pt;">
</span></span><!--[endif]--><span style="color: #1f497d;">Clear all browser
history and cache.<o:p></o:p></span></div>
<div class="MsoListParagraph" style="margin-left: 31.5pt; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #1f497d; text-indent: -0.25in;">5.<span style="font-size: 7pt;">
</span></span><span style="color: #1f497d; text-indent: -0.25in;">Size of logo has to
be w:119*h:25 and if the size changes image size conflicts. All the below
search bar, Advanced, Administration button etc.. all are integrated into a
single template, size and format are called in different css class file which
changing may conflict with many files resulting blank display sometimes.</span></div>
<div class="MsoListParagraph" style="margin-left: 31.5pt; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #1f497d; text-indent: -0.25in;"><br /></span></div>
<div class="MsoListParagraph" style="margin-left: 31.5pt; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #1f497d; text-indent: -0.25in;">Thanks,</span></div>
<div class="MsoListParagraph" style="margin-left: 31.5pt; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #1f497d; text-indent: -0.25in;">Shanmugha Bharathy G B</span></div>
<div class="MsoListParagraph" style="margin-left: 31.5pt; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #1f497d; text-indent: -0.25in;"><br /></span></div>
<div class="MsoListParagraph" style="margin-left: 31.5pt; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #1f497d; text-indent: -0.25in;">Hope It Helps!!</span></div>
</div>
Unknownnoreply@blogger.com8tag:blogger.com,1999:blog-676727543316582286.post-36754920918915358502014-01-02T04:02:00.003-08:002014-01-02T04:02:16.929-08:00Display TopN Revenue Every Year by Customer in Obiee11g<div dir="ltr" style="text-align: left;" trbidi="on">
<b><u>Display TopN Revenue Every Year by Customer in Obiee11g:</u></b><br />
<b><u><br /></u></b>
Hi All,<br />
<br />
I had a requirement to generate topN Constituents Revenue based on every year. In this blog i am going to explain how to display top 10 constituents revenue for 2012;2013 etc...<br />
<br />
1. Create a new analysis with your required columns<br />
Here i have used the following columns and the last column displays our business scenario.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguZMoNY00GKEugKiGNgJRkxvgBTRyQmDhGJKPYNNKDoPaBQr18_UPCfnmEbf73niX_e1oOZjX53SSmaSQC4y9bQlWUkBcizhYrHf1FoVrg-risSjeTB0PGT6ThLcZHlp2k7biC3-x8rQgD/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguZMoNY00GKEugKiGNgJRkxvgBTRyQmDhGJKPYNNKDoPaBQr18_UPCfnmEbf73niX_e1oOZjX53SSmaSQC4y9bQlWUkBcizhYrHf1FoVrg-risSjeTB0PGT6ThLcZHlp2k7biC3-x8rQgD/s1600/111.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
2. For Revenue By TopN column goto>edit formula> and select f(..) formula button, expand aggregate icon and select TOPN function which will look like below screenshot.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgabagIk3t-iWQ_1O80MACFXGnqcuefDKG2rISE71CB1hqC5R5p3G6hmeMZwnM4o2QfNo7UFxjgwxwBfoZuF3Xf1_9M_W2c8QyJh4dniL-aAWNmK_uyp71LNk1TANsGQuNOwSjPRNVdUvGP/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgabagIk3t-iWQ_1O80MACFXGnqcuefDKG2rISE71CB1hqC5R5p3G6hmeMZwnM4o2QfNo7UFxjgwxwBfoZuF3Xf1_9M_W2c8QyJh4dniL-aAWNmK_uyp71LNk1TANsGQuNOwSjPRNVdUvGP/s1600/111.png" height="170" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
3. Then select variable button >presentation variable and type COUNT as Variable Expression and Default Value as 10 like below screenshot.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXEcIxJ3rix_Iq5-OGk_33RkwkV9zXGJdIwuYalOOYIy11leyconqAPGLK_GWJT6MUG9lzZ8LUeYMxd9lABcFZzVMTnYCp14rpMKRTJ31PSKjfgkOiKAgpEHteM_0kDX3oEa3InjWOPRvZ/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXEcIxJ3rix_Iq5-OGk_33RkwkV9zXGJdIwuYalOOYIy11leyconqAPGLK_GWJT6MUG9lzZ8LUeYMxd9lABcFZzVMTnYCp14rpMKRTJ31PSKjfgkOiKAgpEHteM_0kDX3oEa3InjWOPRvZ/s1600/111.png" height="198" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
4. After entering all the values the edit formula value passing pane should look like below screenshot and select ascending to this column.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGt5xtGLsj_ADrWRd5v5jSPr1C-E5IZuP3ErO5zq5kxNICwYU00w_daOdbvFRn0qp4OQuECRqj4OGWES-Xg9suxcutcPaKQyZS5SatwFp5lWE0wK_E80Rkl8V4KxBsLJ2lBIu4UbjzvHWi/s1600/Untitled.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGt5xtGLsj_ADrWRd5v5jSPr1C-E5IZuP3ErO5zq5kxNICwYU00w_daOdbvFRn0qp4OQuECRqj4OGWES-Xg9suxcutcPaKQyZS5SatwFp5lWE0wK_E80Rkl8V4KxBsLJ2lBIu4UbjzvHWi/s1600/Untitled.png" height="157" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
5. Now we go to to create two prompts for our analysis.</div>
<div class="separator" style="clear: both;">
6. Select the “Prompts” tab and click on the ” + ” symbol to create a new prompt, select the “Column Prompt” -> “Time”.”Year”.</div>
<div class="separator" style="clear: both;">
7. Keep the default values and make sure these are checked: “Enable user to select multiple values”, “Enable user to type values”, “Require user input”.</div>
<div class="separator" style="clear: both;">
8. For the “Default selection” select “Specific Values” and use the ” + ” icon to open the “Select Values” window.</div>
<div class="separator" style="clear: both;">
9. In the “Select Value” window select 2013 and 2012 and move them to the “Selected” side and click the OK button.</div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
Refer and make sure the values are correct as per below screenshot:</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdiCTaM7-7kpujt5befVmWfz-0rLOCIZQUXT1Wy9VcPbFSsiXTPNZx4Pj7zibbLKhvVoYVJDVkN-mcoyisUNp4G_UuMxxnPWNT9YSgtJ4rC-aiPVL52KwZ9vH8snwc96iy0zRR7m-Sl30A/s1600/Untitled.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdiCTaM7-7kpujt5befVmWfz-0rLOCIZQUXT1Wy9VcPbFSsiXTPNZx4Pj7zibbLKhvVoYVJDVkN-mcoyisUNp4G_UuMxxnPWNT9YSgtJ4rC-aiPVL52KwZ9vH8snwc96iy0zRR7m-Sl30A/s1600/Untitled.png" height="400" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both;">
10. Create One More Prompt:</div>
<div class="separator" style="clear: both;">
</div>
<ul style="text-align: left;">
<li> Add one more prompt by select the ” + ” icon on the “Definition” window.</li>
<li>Select the “Variable Prompt”.</li>
<li>On the “New Prompt” window for “Prompt for” select “Presentation Variable” and on the side box enter “Count”.</li>
<li>For the “Label” enter “Number of Ranks”.</li>
<li>For the “User Input” select “Text Field”.</li>
<li>For the “Variable Data Type” select “Number”</li>
<li>Check the “Require user input” checkbox.</li>
<li>For the “Default selection” select “Specific Value” and enter “10″.</li>
<li>Then finally click the OK button.</li>
</ul>
<br />
<div class="separator" style="clear: both;">
make sure it is as below screenshot:</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjn4Ti5WZ6eo3XdHSJNhEmF7OpKI3_1vb2JCSA2UFfHyB1Oyrp2t3cS5gtds4Uye6lR82znnj8KXsbUuRoSuLNaY95JiXWdCqyQUNe4-VBuK6HrkX0wwWCSWd_-8G4_wKuQ9hTwYCab7Xdq/s1600/Untitled.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjn4Ti5WZ6eo3XdHSJNhEmF7OpKI3_1vb2JCSA2UFfHyB1Oyrp2t3cS5gtds4Uye6lR82znnj8KXsbUuRoSuLNaY95JiXWdCqyQUNe4-VBuK6HrkX0wwWCSWd_-8G4_wKuQ9hTwYCab7Xdq/s1600/Untitled.png" height="323" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
11. Once all done Save the analysis as TOPN Constituents Revenue By Year. </div>
<div class="separator" style="clear: both; text-align: left;">
12. The Result look like </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXNzdX5aEXmGzu_H9CV9ryKWWX9NGQ0Ky7vzYnemTtKKKwRXd42q6irlcG1DZ0FqjWNOMRv25XxylZXLRRoyNwN-awYr__J-VT2eQinuhupj79UdEoXhdN6LbnKlO01dUzepB7T0oSVRI4/s1600/Untitled.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXNzdX5aEXmGzu_H9CV9ryKWWX9NGQ0Ky7vzYnemTtKKKwRXd42q6irlcG1DZ0FqjWNOMRv25XxylZXLRRoyNwN-awYr__J-VT2eQinuhupj79UdEoXhdN6LbnKlO01dUzepB7T0oSVRI4/s1600/Untitled.png" height="155" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
13. Select ok and run the analysis.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg56WQ-0UyEPDsL6EbQc1B7mz7GL6jpcSQgSBoqdT9pSMw_V0ItIONSe28ZfFH5nR2_fUOgFuXNcBDgw3xpA5-7wU3_3n2O0tYNQic3NSZvVcc5k47CgYI1MEXJ1ANJO1PXzJQ05Y50DQhL/s1600/Untitled.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg56WQ-0UyEPDsL6EbQc1B7mz7GL6jpcSQgSBoqdT9pSMw_V0ItIONSe28ZfFH5nR2_fUOgFuXNcBDgw3xpA5-7wU3_3n2O0tYNQic3NSZvVcc5k47CgYI1MEXJ1ANJO1PXzJQ05Y50DQhL/s1600/Untitled.png" height="320" width="307" /></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="separator" style="clear: both; text-align: left;">
Hope it 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;">
Shanmugha Bharathy G B</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="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-77060091646911216342013-12-24T02:48:00.001-08:002013-12-24T02:49:08.401-08:00Global Unique Identifiers (GUIDs) in OBIEE 11g<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div>
<b><u>Global Unique Identifiers (GUIDs) in OBIEE:</u></b></div>
<div>
<b><u><br /></u></b></div>
<div>
What is GUIDs?</div>
<ul style="text-align: left;">
<li>In Oracle BI 11g, users are recognized by their Global Unique Identifiers (GUIDs), not by their names</li>
<li>GUIDs are identifiers that are completely unique for a given user</li>
<li>Using GUIDs to identify users provides a higher level of security because it ensures that data and metadata is uniquely secured for a specific user, independent of the user name</li>
</ul>
<div>
Example Scenario:</div>
<div>
<br /></div>
<div>
1.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5qoHIM4sZifTPBwSiuUokJClcAT90XSD-O8NY4HQVLSgWxE_bYYXrpENeIM91hT27ohEMyIS2dXlasXr3rFEpmsKhafm3eV_Np_Wo2ohor_eAflXzb1o_7irHMmP_r8OzNHoWynhTACGq/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5qoHIM4sZifTPBwSiuUokJClcAT90XSD-O8NY4HQVLSgWxE_bYYXrpENeIM91hT27ohEMyIS2dXlasXr3rFEpmsKhafm3eV_Np_Wo2ohor_eAflXzb1o_7irHMmP_r8OzNHoWynhTACGq/s1600/111.png" height="409" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
2.</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMkO-uH6zykyPfybTOOGicMP9abW6mRr_p97aCG1E3Z48U05eAVC3mH7R7uciAVV0AE0l1XgzTmeoZyJjXZTterMVtU6goWq9mPPorOodPfgH4vbvXfVBIkgMkoesJea9kvcRSivxRkTCq/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMkO-uH6zykyPfybTOOGicMP9abW6mRr_p97aCG1E3Z48U05eAVC3mH7R7uciAVV0AE0l1XgzTmeoZyJjXZTterMVtU6goWq9mPPorOodPfgH4vbvXfVBIkgMkoesJea9kvcRSivxRkTCq/s1600/111.png" height="410" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div>
3. </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoTnrCISEcsoP6c5rduZ1tThARpQxQxOycgecsdZe9xvub_VFYPE3H5QPGZvLSUI75TFHBVe4SNjmpxAYPLJbewCULJdZ3xEB4KQB0jJuFLilEABLojDdmhb_QEYdSSjrWrAVbZ3qKWXOE/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoTnrCISEcsoP6c5rduZ1tThARpQxQxOycgecsdZe9xvub_VFYPE3H5QPGZvLSUI75TFHBVe4SNjmpxAYPLJbewCULJdZ3xEB4KQB0jJuFLilEABLojDdmhb_QEYdSSjrWrAVbZ3qKWXOE/s1600/111.png" height="410" width="640" /></a></div>
<div>
4. </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjM6L3bbuYeq_PSvptS6Wg0kq20trJbIMBSexAQCm7RzArMoAbqxK6IFXVQq1BgC4jrolTPgJj81PL0h1JZtV1Jdv6ayvST33jjRV-qeO-HsBo1h22tz_3COVqa7TxuAYK_n0vvmt7HhVnM/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjM6L3bbuYeq_PSvptS6Wg0kq20trJbIMBSexAQCm7RzArMoAbqxK6IFXVQq1BgC4jrolTPgJj81PL0h1JZtV1Jdv6ayvST33jjRV-qeO-HsBo1h22tz_3COVqa7TxuAYK_n0vvmt7HhVnM/s1600/111.png" height="410" width="640" /></a></div>
<div>
5.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFIStsusjLX617d55eZ3ZzM6PUpA51cc6WhPaQF8TN6fPwD8Xi1OsD6ImtRh5QvYrqQvuCw4dyJCbsGHGAEQbM6MJQx0HvnGOhFHth5saYawukx1b5uzge9nWiKmoZeaKid9vEQvjRznNQ/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFIStsusjLX617d55eZ3ZzM6PUpA51cc6WhPaQF8TN6fPwD8Xi1OsD6ImtRh5QvYrqQvuCw4dyJCbsGHGAEQbM6MJQx0HvnGOhFHth5saYawukx1b5uzge9nWiKmoZeaKid9vEQvjRznNQ/s1600/111.png" height="410" width="640" /></a></div>
<div>
6. </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRTuiAUNlwMjd2LXYNn9icwCY95ycihGUU3T_iKd-bluNApZqLZoWlx1RykklrYQ3afxgLxBIZGF35k97ONPQn5wy5a8HqUkvUEaSLIfR8rM9MApxOl6ffEH1OqNN4M-eEqNGh9XULgSTZ/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRTuiAUNlwMjd2LXYNn9icwCY95ycihGUU3T_iKd-bluNApZqLZoWlx1RykklrYQ3afxgLxBIZGF35k97ONPQn5wy5a8HqUkvUEaSLIfR8rM9MApxOl6ffEH1OqNN4M-eEqNGh9XULgSTZ/s1600/111.png" height="434" width="640" /></a></div>
<div>
<b>Refreshing GUIDs</b></div>
<div>
<ul style="text-align: left;">
<li>The GUID feature is there to help secure your OBI environments – especially production.</li>
<li>There may however be times when GUIDs become out of sync in and you cannot log in as certain users:</li>
</ul>
<ol style="text-align: left;">
<li>Migrating from WebLogic Embedded LDAP to an alternative identity provider</li>
<li>Deleting users and then recreating them.</li>
<li>Migrating “Production” Presentation Catalog / RPD to the “Development” environment</li>
</ol>
<div>
<ul style="text-align: left;">
<li>In order to work around this, you can either:</li>
</ul>
<div>
<ol style="text-align: left;">
<li>Delete the offending users from the Presentation Catalog and log in again or</li>
<li>Refresh GUIDs (explained overleaf) </li>
</ol>
<b> Regenerating GUIDs :</b></div>
</div>
</div>
<div>
<ul style="text-align: left;">
<li>Open up the NQSConfig.ini file for editing:</li>
<li>[OBI Home]/config/OracleBIServerComponent/coreapplication_obis1/NQSConfig.ini</li>
<li>Set the following parameter within the [SERVER] section:</li>
<li>FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;</li>
<li>Save the file</li>
<li>Open up the instanceconfig.xml file for editing:</li>
<li>[OBI Home]/config/OracleBIPresentationServicesComponent/coreapplication_obips1/instanceconfig.xml</li>
<li>Add an “UpdateAccountGUIDs” entry to the <Catalog> section as follows:</li>
</ul>
<ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1"><br />
<ps:UpgradeAndExit>false</ps:UpgradeAndExit><br />
<ps:UpdateAccountGUIDs>UpdateAndExit</ps:UpdateAccountGUIDs><br />
</ps:Catalog></div>
<div>
<ul style="text-align: left;">
<li>Save the file</li>
<li>Restart Oracle BI System components:</li>
<li>$ORACLE_BASE/instances/instance1/bin/opmnctl stopall</li>
<li>$ORACLE_BASE/instances/instance1/bin/opmnctl startall</li>
</ul>
</div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOqc11rAn-rCEKy_NGZZEtPEx7ZrnYokDZee-YjzjdQf10-TLJ-T5A7Fvy2aFKw5A4xXTnkkzIJHdIEB-uFlwJGy4b_YQuYn2m57uJDTC2O-dRXa2qBxiD8v2CmLafbKEyGxCqbVaswOyq/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOqc11rAn-rCEKy_NGZZEtPEx7ZrnYokDZee-YjzjdQf10-TLJ-T5A7Fvy2aFKw5A4xXTnkkzIJHdIEB-uFlwJGy4b_YQuYn2m57uJDTC2O-dRXa2qBxiD8v2CmLafbKEyGxCqbVaswOyq/s1600/111.png" height="260" width="640" /></a></div>
<div>
<ul style="text-align: left;">
<li>To ensure your system is secure once again you must revert the configuration changes!</li>
<li>NQSConfig.ini : FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO;</li>
<li>Instanceconfig.xml : Remove entry for <ps:UpdateAccountGUIDs></li>
<li>Restart Processes : opmnctl stopall / startall</li>
</ul>
<div>
Hope It Helps!!</div>
</div>
<div>
<br /></div>
<div>
Thanks,</div>
<div>
Shanmugha Bharathy G B</div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-71210665813067885552013-12-20T07:15:00.000-08:002013-12-20T07:17:05.525-08:00Configuring Teradata Data Source for Oracle BI Under UNIX<div dir="ltr" style="text-align: left;" trbidi="on">
<u><b>Configuring Teradata Data Source for Oracle BI Under UNIX</b></u><br />
<br />
Operating System: UNIX only.<br />
Databases: Teradata only.<br />
<ul style="text-align: left;">
<li>This task is required if Teradata is to be configured as the only data source of the operationalapplication server.</li>
<li>Before beginning the following procedure, you must know the following information:</li>
<li>The default installation directory paths for Teradata on UNIX, as shown in the following table of Teradata installation default paths under UNIX.</li>
<li>The IP address of the Teradata server.</li>
<li>To configure Teradata as an application server data source</li>
<li>Log on as a separate telnet session.</li>
<li>Go to the directory OracleBI_HOME/setup.</li>
<li>Using vi or another text editor, open the odbc.ini file and add the following section to odbc.ini:</li>
</ul>
<br />
Data Source Name=<Name of the DSN><br />
Driver=<Teradata ODBC driver Path>/drivers/tdata.[$libsuffix]<br />
Description=NCR 3600 running Teradata V2R5.2r<br />
DBCName=<Teradata Server IP Address><br />
LastUser=<br />
Username=<br />
Password=<br />
Database=<br />
DefaultDatabase=<name of target database or user><br />
<br />
<b>NOTE: </b>The string [$libsuffix] represents the library suffix appropriate to the specific UNIX<br />
operating system you are using.<br />
<ul style="text-align: left;">
<li> For example, for Solaris or AIX, use libnqsodbc.so; for HP-UX,use libnqsodbc.sl.</li>
</ul>
<br />
<b>Example 1.</b> The following is true:<br />
<ul style="text-align: left;">
<li>Teradata server is running on IP 172.20.129.42</li>
<li>Teradata ODBC driver is installed at /usr/odbc</li>
<li>Therefore, for Example 1, add the following section to odbc.ini:</li>
</ul>
[Terav502]<br />
Driver=/usr/odbc/drivers/tdata.sl<br />
Description=NCR 3600 running Teradata V2R5.2<br />
DBCName=172.20.129.42<br />
LastUser=<br />
Username=<br />
Password=<br />
Database=<br />
DefaultDatabase=<name of target database or user><br />
<br />
<b>Example 2. </b>The following is true:<br />
<ul style="text-align: left;">
<li>Teradata server is running on IP 172.20.129.42</li>
<li>Teradata ODBC driver is installed on /usr/lpp/tdodbc</li>
</ul>
Therefore, for Example 2, add the following section to odbc.ini:<br />
<br />
[Terav502]<br />
Driver=usr/lpp/tdodbc/odbc/drivers/tdata.so<br />
Description=NCR 3600 running Teradata V2R5.2<br />
DBCName=172.20.129.42<br />
LastUser=<br />
Username=<br />
Password=<br />
Database=<br />
DefaultDatabase=<name of target database or user><br />
<br />
<b>NOTE:</b> The DefaultDatabase parameter may be left empty only if you have checked the entry<br />
Require fully qualified table names in the Repository Connection Pool for this Data Source.<br />
<ul style="text-align: left;">
<li>In the same file, in the section [ODBC Data Sources], add the following entry:Terav502=tdata.[$libsuffix]</li>
</ul>
<br />
<b>Example:</b> The new Teradata DSN is Terav502. Therefore, add the DSN entry to<br />
odbc.ini:<br />
<br />
[ODBC Data Sources]<br />
AnalyticsWeb=Oracle Business Intelligence Presentation Services<br />
SnowFlake=Oracle Business Intelligence Server<br />
AutoSnowFlake=Oracle Business Intelligence Server<br />
DimSnowFlake=Oracle Business Intelligence Server<br />
DimSnowFlake=Oracle Business Intelligence Server<br />
Star=Oracle Business Intelligence Server<br />
Terav502=tdata.[$libsuffix]<br />
<br />
<b>NOTE:</b> The string [$libsuffix] represents the library suffix appropriate to the specific UNIX<br />
operating system you are using. For example, for Solaris or AIX, use libnqsodbc.so; for HP-UX,<br />
use libnqsodbc.sl.<br />
<ul style="text-align: left;">
<li>Open up the user.sh script in the same directory and add the library path line to configure the Oracle BI data source, based on the operating system and shell.</li>
<li>Using the Oracle Business Intelligence Administration Tool, open the Repository and add the new DSN you created as the Connection Pool Data Source Name for the appropriate physicaldatabases.</li>
<li>In the example, add Terav502.</li>
<li>Start the Oracle BI Server or, if it is running, stop and restart it.</li>
</ul>
Hope it Helps!!<br />
<br />Thanks,<br />Shanmugha Bharathy G B<br />
<br />
<ul style="text-align: left;">
</ul>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-64330606192137518362013-12-19T04:31:00.001-08:002013-12-19T04:31:03.472-08:00Configuring Oracle Databases for the Oracle BI Server Under Windows<div dir="ltr" style="text-align: left;" trbidi="on">
<u><b>Configuring Oracle Databases for the Oracle BI Server Under Windows</b></u><br />
<br />
<b>Operating System:</b> Windows only.<br /><b>Databases:</b> Oracle only.<br />
<br />
<ul style="text-align: left;">
<li>If your native database is Oracle, the following conditions must be true:</li>
<li>The machine running Oracle BI Server must use the Oracle Call Interface (OCI) to connect to the database.</li>
<li>In the tnsnames.ora file, the Oracle database alias (the defined entry name) must match the Data Source Name used in the repository connection pools of all physical Oracle databases.</li>
<li>In the repository file, the Oracle database alias used in the connection pools must also be the same as the Data Source Name.</li>
<li>For example, in the following example of a tnsnames.ora entry, the corresponding Oracle</li>
<li>Business Intelligence repository connection pool Data Source Name is ITQA2.</li>
</ul>
ITQA2 =<br />(DESCRIPTION =<br />(ADDRESS_LIST =<br />(ADDRESS = (PROTOCOL = TCP)(HOST = ITQALAB2)(PORT = 1521))<br />(CONNECT_DATA =<br />(SERVICE_NAME = ITQALAB2.corp)<br />)<br />)<br />
<ul style="text-align: left;">
<li>The following procedure shows how to check repository connection pool settings against the Oracle tnsnames.ora settings.</li>
</ul>
<ul style="text-align: left;">
<li>To check that an Oracle database refers to the Oracle BI Server machine</li>
</ul>
<ul style="text-align: left;">
<li> Log on to the Server Administration Tool.</li>
<li>In the repository's Physical layer, double-click on the appropriate database cylinder icon. On the general tab, in the Data source definition Database field, select the appropriate Oracle database version from the drop down list. for your data source.</li>
<li>If the Connection Pool is not visible in the Physical layer, click on the (+) navigation control to<br />the left of the appropriate database cylinder icon to expand it.</li>
<li> Double-click the appropriate Connection Pool to open the Connection pool window.</li>
<li> In the Connection Pool window, check that the following is true:</li>
<li>The Call Interface field displays the appropriate value for the release of Oracle database being used.</li>
<li>The Data Source Name displays the Oracle database alias that you have defined in the<br />tnsnames.ora entry.</li>
<li>NOTE: This Data Source Name is not the DSN name defined in Settings > Control Panel > Data Sources (ODBC)..</li>
<li>In the Oracle folder, open the tnsnames.ora file.</li>
<li>Check that a valid entry name exists with the following characteristics:</li>
<li> Matches the Oracle BI repository's connection pool settings for the Data Source Name</li>
<li>Specifies the targeted Oracle physical database</li>
</ul>
Hope It Helps !!<br />
<br />
Thanks,<br />
Shanmugha Bharathy G B </div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-1371731525582923272013-12-18T05:11:00.000-08:002013-12-19T00:33:05.299-08:00Single Button for multiple Global Prompts in OBIEE 11g<div dir="ltr" style="text-align: left;" trbidi="on">
<b><u>Single Button for multiple Global Prompts in OBIEE 11g:</u></b><br />
Hi,<br />
<span style="background-color: white; color: #333333; font-family: Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif; font-size: 14px; line-height: 21px;"><br /></span>
<span style="background-color: white; color: #333333; font-family: Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif; font-size: 14px; line-height: 21px;">This requirement was faced by us and successfully implemented by my Lead. I am sharing since it would be useful for all..</span><br />
<ul style="text-align: left;">
<li>I have shared a simple example of submitting two prompts which may not make much sense because these two prompts can easily be combined into a single prompt and using standard Apply and Reset buttons provides same functionality. However, the real use case is on dashboard pages with say 10~15 complex prompts that need to be logically laid out and can’t be combined into single prompt. Also, complex prompts may have already been built and need to be reused.</li>
<li>In the below screenshot you can see with example how </li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhg641x_Xh69k0_3-pSBpmOXQUOqALavqFpucAjKYtH5gB1bY0XWGtyIrMDHSTk_OYyLN4L79848SNLgBMhjSMZC3y1Fad6kAYesK7Kpy6ecm6U87_nNYi2vGF42-00VcvHO1_gKEHhAsV0/s1600/111.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/AVvXsEhg641x_Xh69k0_3-pSBpmOXQUOqALavqFpucAjKYtH5gB1bY0XWGtyIrMDHSTk_OYyLN4L79848SNLgBMhjSMZC3y1Fad6kAYesK7Kpy6ecm6U87_nNYi2vGF42-00VcvHO1_gKEHhAsV0/s1600/111.png" height="149" width="640" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<ul style="text-align: left;">
<li><span style="background-color: white; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 18px;">Each prompt has an Apply and Reset button (more about disabling these buttons later) and the analysis runs separately for each prompt.As I said earlier, it is possible to combine these two simple prompts into one and in this case functionality will be same as the customization but we know it is not always possible to combine large number of prompts. Here is how this example </span><span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"> would look if we combine both prompts:</span></span></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9-ZSOfxUBCGckF3daTPotN87PCUz0znw5gI0QnyykWY_MKPo0GvMzbENpzvJB_zfry419c5VnH5Jer92e_1YfE-F-r8yVt1BMmp_aVzS2n77p07bmhGlz3HbpkN-quZHS9RZlZqd1axe3/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9-ZSOfxUBCGckF3daTPotN87PCUz0znw5gI0QnyykWY_MKPo0GvMzbENpzvJB_zfry419c5VnH5Jer92e_1YfE-F-r8yVt1BMmp_aVzS2n77p07bmhGlz3HbpkN-quZHS9RZlZqd1axe3/s1600/111.png" height="190" width="640" /></a></div>
</div>
<div>
<ul style="text-align: left;">
<li><span style="background-color: white; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 18px;"> Now add two text boxes as below:</span></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrsSjr27D8MmeyAsFFNuy56stzuJAECVL5s9zyLkuz63j-berrpGk-9DwkH7KeAQsnNp9I7pJBKIk9C0tAzzmgVVZ-wUR8ETXqMzHX7kH3pDhGDwzp0mdB_EqbFNPMtAs1VoOQpU03B_pV/s1600/111.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/AVvXsEjrsSjr27D8MmeyAsFFNuy56stzuJAECVL5s9zyLkuz63j-berrpGk-9DwkH7KeAQsnNp9I7pJBKIk9C0tAzzmgVVZ-wUR8ETXqMzHX7kH3pDhGDwzp0mdB_EqbFNPMtAs1VoOQpU03B_pV/s1600/111.png" height="196" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<ul style="text-align: left;">
<li><span style="background-color: white; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 18px;">Text 1 has code to hide all Apply buttons. You may be aware of other ways of hiding Apply buttons (check boxes on prompt and dropdown menu on page) but they make prompts execute immediately and we don’t want that behavior in this case. Also, this effects prompts that are placed below on page and this is the reason it needs to be on top.</span></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5aECVeP34Fdo80muGZ3PS6jQCdjiXMwZHh9_80ekOKqLvm9C7wqEALp4QE33nw_mqiueuJeJ4YHpU3c8Ct94WQee2BIBc8rHUuWEi4iVbT-u8udHx7TMcOEeeXFYsCPp-iwYnEAv68MjR/s1600/111.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/AVvXsEh5aECVeP34Fdo80muGZ3PS6jQCdjiXMwZHh9_80ekOKqLvm9C7wqEALp4QE33nw_mqiueuJeJ4YHpU3c8Ct94WQee2BIBc8rHUuWEi4iVbT-u8udHx7TMcOEeeXFYsCPp-iwYnEAv68MjR/s1600/111.png" height="300" width="400" /></a></div>
<div>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span></div>
</div>
<div>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span></div>
<div>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span></div>
<div>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span></div>
<div>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span></div>
<div>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span></div>
<div>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span></div>
<div>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span></div>
<div>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span></div>
<div>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span></div>
<div>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span></div>
<div>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span></div>
<div>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span></div>
<div>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span></div>
<div>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"></span></span><br />
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span>
<span style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 12px; line-height: 18px;"><br /></span></span></div>
<div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
<ul style="text-align: left;">
<li><span style="line-height: 1.5;">Text 2 has custom code for two buttons: one Resets ALL prompts and other is to APPLY ALL prompts. Don’t worry about reading all the code, I have the text below. Just make sure your text matches this. For example, ‘Contains HTML Markup’ should be checked and ‘Preview’ button is pressed, you should see two buttons.</span></li>
<li><span style="line-height: 1.5;">Please note that copy/paste can sometimes break keywords and code may not work right away. Correct any errors and use preview button to make sure there are no errors.</span></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFWNzdArpeWAmi0KhVL0RVkoBJoww4Go0yxGcCWnkWS5fdFdkfdp7SjNFVqZ5wS6GN_1gYinoUiRCHFfNkCZmCpflo_mny5fyZK5OLfxQqnyQNNm9spNen_4rtnirmgI7VKVns9gyl2PyY/s1600/111.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/AVvXsEhFWNzdArpeWAmi0KhVL0RVkoBJoww4Go0yxGcCWnkWS5fdFdkfdp7SjNFVqZ5wS6GN_1gYinoUiRCHFfNkCZmCpflo_mny5fyZK5OLfxQqnyQNNm9spNen_4rtnirmgI7VKVns9gyl2PyY/s1600/111.png" height="298" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
<DIV CLASS = “XUIPromptEntry minibuttonOn”><A HREF = “#” ONCLICK = “return PersonalizationEditor.removeDefaultSelection(false)”>Clear ALL Prompts</A></DIV></div>
<div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div align = “left”> <a onclick=”javascript:customCall();” href=”#”> Apply ALL Prompts</a><div/></div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
<script language=”JavaScript”> function customCall() {</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
try{ var aElm=PromptManager.getPromptManager().getAllPromptCollectionJSON();</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
for(var i = 0; i < aElm.length; i ++ )</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
{</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
{</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
for(var j = 0; j < aElm[i].promptSteps[0].prompts.length; j ++ )</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
{</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
var promptid = aElm[i].promptSteps[0].prompts[j].promptStreamID ;</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
var g = null;</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
var h = PromptManager.getPromptManager().getPromptCollectionInfoWithViewID(aElm[i].viewStatePath);</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
if(h)</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
{</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
try</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
{</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
var b = h.getAllPromptExprsArray();</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
if( ! h.verifyPromptValuesAndDisplayError(b))</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
{</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
return</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
}</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
g = PromptManager.buildPromptExprGivenExpr(“”, b)</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
}</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
catch(f)</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
{</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
alert(f);</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
return</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
}</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
}</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
PromptManager.submitPrompt(aElm[i].viewStatePath, true, “PromptFinish”, g)</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
}</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
}</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
}</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
}</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
catch(e) {alert(“Apply ALL Button Exception ” + e.description);</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
}</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
}</div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
</script></div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
<ul style="text-align: left;">
<li><span style="line-height: 1.5;">Reset buttons can be disabled using standard navigation:</span></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIKri73FSPg8wYMs25hG7e5DwdnndueplkYHGis8Z2jRTOIpYgrBY6ftubA1qoSQcIG1lfVYFC_T2H9kFlK881TbEjFERg1ahwJrubKCFobCuZyr6hjALofb_93rWYluTchN0ETTkiFtJO/s1600/111.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/AVvXsEgIKri73FSPg8wYMs25hG7e5DwdnndueplkYHGis8Z2jRTOIpYgrBY6ftubA1qoSQcIG1lfVYFC_T2H9kFlK881TbEjFERg1ahwJrubKCFobCuZyr6hjALofb_93rWYluTchN0ETTkiFtJO/s1600/111.png" height="182" width="400" /></a></div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
<br /></div>
<div style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 12px; line-height: 1.5; margin-bottom: 15px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
<ul style="text-align: left;">
<li><span style="line-height: 1.5;">When this dashboard is run, this how it will look:</span></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGWOtTpWkGcbmIEAKe6TN8tI5I-mB8TJG-CBGvvknT3z7XankKgG_w1gloMNhg_xzqggG36jgIrMPM6gtZyE5PQjg6L5jjMlx8Rb9gC0iDSKPpuygypuLzlTaQc0IhVQmXEBf4BrVeT5-Z/s1600/111.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/AVvXsEjGWOtTpWkGcbmIEAKe6TN8tI5I-mB8TJG-CBGvvknT3z7XankKgG_w1gloMNhg_xzqggG36jgIrMPM6gtZyE5PQjg6L5jjMlx8Rb9gC0iDSKPpuygypuLzlTaQc0IhVQmXEBf4BrVeT5-Z/s1600/111.png" height="153" width="640" /></a></div>
<div>
<ul style="text-align: left;">
<li><span style="line-height: 1.5;">Selecting values in each prompt should not change analysis unit Apply ALL Prompts button is pressed:</span></li>
</ul>
</div>
<div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivbT25N1aHDj_lQaPv51IPAhgRUrw2smF14liVJCNeUkuoiwgTUcsURMJt7T91KP9MKol-VILMASwp8EtpYINUSZrJBXySjzfPomaA8-JDwmZ9zExIeXU9UxXoCk7B6SbIaN85ETd7abow/s1600/111.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/AVvXsEivbT25N1aHDj_lQaPv51IPAhgRUrw2smF14liVJCNeUkuoiwgTUcsURMJt7T91KP9MKol-VILMASwp8EtpYINUSZrJBXySjzfPomaA8-JDwmZ9zExIeXU9UxXoCk7B6SbIaN85ETd7abow/s1600/111.png" height="176" width="640" /></a></div>
<div>
<br /></div>
</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<ul style="text-align: left;">
<li><span style="line-height: 1.5;">Once the button is pressed after selecting all prompts, you should see analysis filtered on all prompts:</span></li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaE00ecXS9AWDQKk-IU8G1S6w0W3xoG8q6Tda0NcDNE48Yw0tdeRPEhYRuvADUawN6dH1ElfIe69ZhyphenhyphenYbryhCig02QzQA2G2Uhyphenhyphen64hF0-HpeqUx_7LFm-6fHeX5NAA8rTxPc3KQr3RgONr/s1600/111.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/AVvXsEiaE00ecXS9AWDQKk-IU8G1S6w0W3xoG8q6Tda0NcDNE48Yw0tdeRPEhYRuvADUawN6dH1ElfIe69ZhyphenhyphenYbryhCig02QzQA2G2Uhyphenhyphen64hF0-HpeqUx_7LFm-6fHeX5NAA8rTxPc3KQr3RgONr/s1600/111.png" height="118" width="640" /></a></div>
<div>
<br /></div>
</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<ul style="text-align: left;">
<li><span style="line-height: 1.5;">If you wish to implement this on a page with numerous prompts, please try on a simple page with two prompts first.</span></li>
</ul>
<div>
Hope It Helps!!</div>
</div>
<div>
<br /></div>
<div>
Thanks,</div>
<div>
Shanmugha Bharathy G B</div>
</div>
</div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-43099737669414644382013-12-17T03:31:00.004-08:002013-12-17T03:36:52.096-08:00Single Prompt Switching Multiple Reports in OBIEE 11G using Presentation Variables<div dir="ltr" style="text-align: left;" trbidi="on">
<u><span style="font-family: Arial, Helvetica, sans-serif;">Single Prompt Switching Multiple Reports in OBIEE 11G using Presentation Variables:</span></u><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><u><br /></u>
</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">What is Dashboard Prompt?</span><br />
<ul style="text-align: left;">
<li><span style="background-color: white; font-family: Arial, Helvetica, sans-serif;">A prompt that is created at the dashboard level is called a dashboard prompt because the prompt is created outside of a specific dashboard and is stored in the catalog as an object, which can then be added to any dashboard or dashboard page that contains the columns that are specified in the prompt.</span></li>
<li><span style="background-color: white; font-family: Arial, Helvetica, sans-serif;"> A dashboard prompt can be a column prompt, variable prompt, image prompt, or currency prompt. </span></li>
<li><span style="background-color: white; font-family: Arial, Helvetica, sans-serif;">Dashboard prompts are reusable, because you can create one prompt and use it many times.</span></li>
<li><span style="background-color: white; font-family: Arial, Helvetica, sans-serif;"> When the prompt object is updated and saved, those updates are immediately displayed in all dashboards where the prompt is used. </span></li>
<li><span style="background-color: white; font-family: Arial, Helvetica, sans-serif;">A dashboard prompt is a specific kind of filter that, when created, saved, and applied to a dashboard or dashboard pages, can filter all or some of the analyses that are embedded in a dashboard or analyses that are embedded on the same dashboard page. </span></li>
<li><span style="background-color: white; font-family: Arial, Helvetica, sans-serif;">A dashboard prompt is interactive and will always be displayed on the dashboard page so that the user can prompt for different values without having to re-run the dashboard. </span></li>
<li><span style="background-color: white; font-family: Arial, Helvetica, sans-serif;">Users can create and save dashboard prompts to either a private folder or to a shared folder.</span></li>
</ul>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">In this blog i am going to share how a single prompt functions with Multiple reports using Variables. </span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;">I have used 4 reports which I want to switch using dashboard prompt which are MASSACHUSETTS , NEW YORK, CALIFORNIA and TEXAS . Here is an example along with the steps:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">1. Create a Dashboard Prompt with the intended reports as a data value (MASSACHUSETTS , NEW YORK, CALIFORNIA and TEXAS) to be selected.</span><br />
<span class="apple-style-span" style="font-family: Arial, Helvetica, sans-serif; line-height: 18px;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><span class="apple-style-span" style="line-height: 18px;">2. Click on New->Dashboard Prompt-></span><span style="background-color: white; line-height: 18px;">select any subject area. </span><i style="line-height: 18px;">Note:</i><span style="background-color: white; line-height: 18px;"> </span><span style="background-color: white; line-height: 18px;">It will not affect on our dashboard prompt as we have to create presentation variable of our choice.</span></span><br />
<span style="background-color: white; font-family: Arial, Helvetica, sans-serif; line-height: 18px;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-color: white; line-height: 18px;">3. Definition Pane for dashboard prompt will open. Now select</span><span style="background-color: white; line-height: 18px;"> </span><span style="line-height: 18px;">"Variable Prompt" </span><span style="background-color: white; line-height: 18px;">as below.</span></span></div>
<div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif; line-height: 18px;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: black; font-family: Arial, Helvetica, sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxPwdi4FWsqfwJAuMJkZZXvtL-QNq4J9RiIV5DCsOuq_Ly7-uNbmFDDua-zTMtsp-Q0O3A950bCU1xvPXk5haG-nHP7AGXxORsmjlNl8-Wl3Kcb7dLm99DEFfzP4STMjrmxQSQwqYUGKZV/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxPwdi4FWsqfwJAuMJkZZXvtL-QNq4J9RiIV5DCsOuq_Ly7-uNbmFDDua-zTMtsp-Q0O3A950bCU1xvPXk5haG-nHP7AGXxORsmjlNl8-Wl3Kcb7dLm99DEFfzP4STMjrmxQSQwqYUGKZV/s1600/111.png" height="154" width="640" /></a>4. <span style="line-height: 18px; text-align: left;">Now "New Prompt" dialogue will open. Create presentation variable as VARIABLE 1,label it as SELECT REPORT and select User Input as Choice List.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwhyCWY8mg-2e8g6S6YErwYStDLja7zX8L3L7M_O9Vl3qDUtESlh2Xghun_vjSo8qu6zdmRHrkif39drzRnagET59ek2CfttX7eJ3UTOq_KeNsibTqWPSgOwQE20fGuZDcOjq_rJurob0B/s1600/111.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwhyCWY8mg-2e8g6S6YErwYStDLja7zX8L3L7M_O9Vl3qDUtESlh2Xghun_vjSo8qu6zdmRHrkif39drzRnagET59ek2CfttX7eJ3UTOq_KeNsibTqWPSgOwQE20fGuZDcOjq_rJurob0B/s1600/111.png" height="325" width="400" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="line-height: 18px; text-align: left;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
</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/AVvXsEg5T7RIYPmjeaIUjny7Oh1Sb4USuitCBQj-UiZt200C85gGGv5asodDBJNITYWymKTKwM0JRHWoMjNJ42wlLCG1BoZJJGKH6L4_d_hG5swys5AR1-f1OuYcNQxAb1yxzUFohCk-Qa-RGcHX/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"></span></a></div>
<div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">5. In Choice list Values click on plus (Green Icon) sign; it will display "Enter New Value" dialogue. Now manually enter the names of the reports which you want to display in prompt. Here I will put my four report names which I want to display as a list in dashboard prompt which are MASSACHUSETTS , NEW YORK, CALIFORNIA and TEXAS as below :</span></div>
<div class="separator" style="clear: both; text-align: left;">
<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/AVvXsEiF-MRkixHr0q5Rh6fiiahMm1Hf-zbA96G8HItrp-8UGwoHrIkQNA3FsjH6B-pHlRKKd6vNR7K4osAs9JIKXBC_bodWYq4ZK_5rt1yAUsFJHK7XOh3CiKX4m0M1eLLJYOn8I3s9g63JbC5d/s1600/111.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiF-MRkixHr0q5Rh6fiiahMm1Hf-zbA96G8HItrp-8UGwoHrIkQNA3FsjH6B-pHlRKKd6vNR7K4osAs9JIKXBC_bodWYq4ZK_5rt1yAUsFJHK7XOh3CiKX4m0M1eLLJYOn8I3s9g63JbC5d/s1600/111.png" height="323" width="400" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">6. Now expand the Options. In "Default Selection" you can give any report name which you want to display by default on dashboard by selecting that report name as "Specific Custom Value". Here I have given "MASSACHUSETTS" as my default selection.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<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/AVvXsEjG-3nhLdlPPdLUANI1PzK08QbGejPsWaYKtvxw8Q14Kgj6jSwC79oF8HunqVnpVc-kOK1ZsDN9WWaxYKHrCepnp3Yn3_dgvE_qXcqvxtJtLgtFcXYT22H69xXqaP1rKBujv1h6cPD9N8Ro/s1600/111.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjG-3nhLdlPPdLUANI1PzK08QbGejPsWaYKtvxw8Q14Kgj6jSwC79oF8HunqVnpVc-kOK1ZsDN9WWaxYKHrCepnp3Yn3_dgvE_qXcqvxtJtLgtFcXYT22H69xXqaP1rKBujv1h6cPD9N8Ro/s1600/111.png" height="400" width="317" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: left;">
<span style="background-color: white; line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;">7. Now save your dashboard prompt. In this way our dashboard prompt is ready from selecting reports which will look like :</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhH_IsVvFEE5zNgfjMfc4BMCmUcpcWkJH0CyIIiM63NO71FihlrSRf-bt2maU01jj2BNmdXGsbuQEiqMkupgZ9BwYkUWtxQPr4m6EyZFlWGwSxRpEyokSNOBm3v1ufLOqa9olqB5LhKCj7f/s1600/111.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhH_IsVvFEE5zNgfjMfc4BMCmUcpcWkJH0CyIIiM63NO71FihlrSRf-bt2maU01jj2BNmdXGsbuQEiqMkupgZ9BwYkUWtxQPr4m6EyZFlWGwSxRpEyokSNOBm3v1ufLOqa9olqB5LhKCj7f/s1600/111.png" /></span></a></div>
<div class="separator" style="clear: both;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 18px;">8. Create reports which you want to display according to selected report name in dashboard prompt.</span></span></div>
<div class="separator" style="clear: both;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 18px;"><br /></span></span></div>
<div class="separator" style="clear: both;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 18px;">9. Now I will create four reports named MASSACHUSETTS , NEW YORK, CALIFORNIA and TEXAS and will apply some filters in theses individual reports which will allow me to show the intended report as per selection made in dashboard prompt. So let's create "MASSACHUSETTS" </span></span></div>
<div class="separator" style="clear: both;">
<span style="line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;">10. I am taking some columns in reports plus one dummy column. I have change the column formula of Dummy column as:</span></span></div>
<div class="separator" style="clear: both;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-color: white; line-height: 18px;"></span></span></div>
<div class="separator" style="clear: both;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 18px;">CASE '@{VARIABLE 1}' WHEN 'MASSACHUSETTS' THEN '1' ELSE '0' END</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJw866fayyDNif0tfgUajc7YEleHDx0cOsFms5GfktF6Jyd5ZIDXs7sYSIQicW936sRM0Ld7rQQDvScN-1QTewiKKjw0BTlpSZpIFQkwWp-5EcVJlv4PlZ7aeGbEYz2RZHtXLZW8uHChIv/s1600/111.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJw866fayyDNif0tfgUajc7YEleHDx0cOsFms5GfktF6Jyd5ZIDXs7sYSIQicW936sRM0Ld7rQQDvScN-1QTewiKKjw0BTlpSZpIFQkwWp-5EcVJlv4PlZ7aeGbEYz2RZHtXLZW8uHChIv/s1600/111.png" height="275" width="400" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="background-color: white; line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;">11. Now I have applied filter on Dummy Column as "is not equal to /is not in" '0'.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8iPUoxb_H3XQKzZ9wfHjLfMJlWRU1P8ydey1s2JuSF3ppAIeqHZwTqFMdJVXxWePDEuhsvnZnkaRpdMqdiFg_k-qTHWByn7QJ_TWGbP2sLfkW45lEJBzF475dMCDU1HwzXJOtcNpA82DR/s1600/111.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8iPUoxb_H3XQKzZ9wfHjLfMJlWRU1P8ydey1s2JuSF3ppAIeqHZwTqFMdJVXxWePDEuhsvnZnkaRpdMqdiFg_k-qTHWByn7QJ_TWGbP2sLfkW45lEJBzF475dMCDU1HwzXJOtcNpA82DR/s1600/111.png" height="175" width="400" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="background-color: white; line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="background-color: white; line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;">12. Repeat the same process for rest of the three reports New York, California and Texas</span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 18px;">CASE '@{VARIABLE 1}' WHEN 'NEW YORK' THEN '1' ELSE '0' END</span></span></div>
<div class="separator" style="clear: both;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 18px;">CASE '@{VARIABLE 1}' WHEN 'CALIFORNIA' THEN '1' ELSE '0' END</span></span></div>
<div>
<div class="separator" style="clear: both;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 18px;">CASE '@{VARIABLE 1}' WHEN 'TEXAS' THEN '1' ELSE '0' END</span></span></div>
</div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 18px;"> and </span></span></div>
<div>
<span style="background-color: white; line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;">apply filter on Dummy Column as "is not equal to /is not in" '0'.</span></span></div>
<div>
<span style="background-color: white; line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<div>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-color: white; line-height: 18px;">13.</span><span style="background-color: white; line-height: 18px;">Putting dashboard prompt and three reports in Dashboard by applying certain conditions on each sections in "Edit Dashboard".</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2IIVkv6h2SK50YqlQ0E0AyN_1vGB0UcECN81U0RuTfTMQviZX1ZmdNbWsXMqeNOSw5XA07aFfR3fcHRrk6aNPKWbr16C9tQ8Jq9bBnk9rdVRsRHB1ueFu69ZdZC6nWJrrkraGOF9w8RXD/s1600/111.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2IIVkv6h2SK50YqlQ0E0AyN_1vGB0UcECN81U0RuTfTMQviZX1ZmdNbWsXMqeNOSw5XA07aFfR3fcHRrk6aNPKWbr16C9tQ8Jq9bBnk9rdVRsRHB1ueFu69ZdZC6nWJrrkraGOF9w8RXD/s1600/111.png" height="244" width="640" /></span></a></div>
<div>
<span style="background-color: white; line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-color: white; line-height: 18px;"><i>Note:</i></span><span style="background-color: white; line-height: 18px;"> Put all the reports and dashboard prompt in separate sections as we have to apply the condition on section.</span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-color: white; line-height: 18px;">14. Now I am applying condition in section of </span><span style="background-color: white; line-height: 18px;">"MASSACHUSETTS"</span><span style="background-color: white; line-height: 18px;"> by clicking on </span><span style="background-color: white; line-height: 18px;">Properties > Condition > Section Condition</span><span style="background-color: white; line-height: 18px;"> as below :</span></span></div>
<div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsWFdjCY5YlFJGvE5ex8oFZ6-GxqSALT68ahk3xiO9biZET_gFu8WE3-DCtsoTk-mmVikniJ_QVvPvwBas7vtbvikeI06ADwFxPs_6pL1Sz533DfU7IF4pPCfN9mgCtRXTOys1rEDwtzSI/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsWFdjCY5YlFJGvE5ex8oFZ6-GxqSALT68ahk3xiO9biZET_gFu8WE3-DCtsoTk-mmVikniJ_QVvPvwBas7vtbvikeI06ADwFxPs_6pL1Sz533DfU7IF4pPCfN9mgCtRXTOys1rEDwtzSI/s1600/111.png" height="97" width="320" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;">15. Similarly follow the same for rest of the three reports. </span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-color: white; line-height: 18px;">16. </span><span style="background-color: white; line-height: 18px;"> Now sav</span><span style="background-color: white; line-height: 18px;">e your dashboard </span><span style="background-color: white; line-height: 18px;">page and run it. </span></span></div>
<div class="separator" style="clear: both;">
<span style="line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;">17. Here "MASSACHUSETTS"is my default report so it is visible on my dashboard by default. Now whatever options (report name) you will select from prompt those report will be shown. It is not necessary to show one default report; you can remove default selection from dashboard prompt. </span></span></div>
<div class="separator" style="clear: both;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both;">
<span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 18px;"><b><u>Output:</u></b></span></span></div>
<div class="separator" style="clear: both;">
<span style="line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjswVGYRU1QD8-lemaZkZXRrDpePTyDUS4u5h5ef8kfnVO90j2KaORUNkyQWXm5snB64ouLxUm5GJwpyaoRZQ0K02b8cpaOv9xuPEGSS1B1WWh5au0tdLCMJwJFNCySdWYtrUy4xpR2EPC8/s1600/111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjswVGYRU1QD8-lemaZkZXRrDpePTyDUS4u5h5ef8kfnVO90j2KaORUNkyQWXm5snB64ouLxUm5GJwpyaoRZQ0K02b8cpaOv9xuPEGSS1B1WWh5au0tdLCMJwJFNCySdWYtrUy4xpR2EPC8/s1600/111.png" height="138" width="640" /></span></a></div>
<div class="separator" style="clear: both;">
<span style="line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;">18. If you select the prompt value MASSACHUSETTS corresponding report will be viewed and the same applicable for NEW YORK, CALIFORNIA and TEXAS.</span></span></div>
<div class="separator" style="clear: both;">
<span style="line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<div class="separator" style="clear: both;">
<span style="line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;">Hope It Helps!!</span></span></div>
<div class="separator" style="clear: both;">
<span style="line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<div class="separator" style="clear: both;">
<span style="line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;">Thanks,</span></span></div>
<div class="separator" style="clear: both;">
<span style="line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;">Shanmugha Bharathy G B</span></span></div>
<div class="separator" style="clear: both;">
<span style="line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<div class="separator" style="clear: both;">
<span style="line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<div class="separator" style="clear: both;">
<span style="line-height: 18px;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<span style="font-family: Arial, Helvetica, sans-serif; line-height: 18px;"><br /></span></div>
<div>
<span style="color: #444444; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: x-small;"><span style="line-height: 18px;"><br /></span></span></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-17882389582985184332013-12-12T02:27:00.001-08:002013-12-12T02:57:23.304-08:00OBIEE 11G Browser Title Name To Your Custom Text <div dir="ltr" style="text-align: left;" trbidi="on">
<b><u>OBIEE 11G Browser Title Name To Your Custom Text :</u></b><br />
<br />
Our client had a requirement to change the Browser title to their Business Name. The procedure which i followed is explained below for your reference.<br />
<ul style="text-align: left;">
<li>Go to <Middleware_Home>\Oracle_BI1\bifoundation\web\msgdb\l_en\messages and Open productmessages.xml file. </li>
<li>Search for kmsgProductPortal attribute and change its value with your custom text.</li>
<li><div class="MsoNormal">
Example:</div>
<div class="MsoNormal">
<WebMessage name=”kmsgProductPortal”></div>
<div class="MsoNormal">
<TEXT>"YOUR CUSTOM TEXT"</TEXT></div>
<div class="MsoNormal">
</WebMessage></div>
<div class="MsoNormal">
<o:p> </o:p>save it and stop and start the Opmn to restart all OBIEE 11G
services. Once the services are up, you will see the changed browser title as
shown in below picture. In this example i have used SBL INTERACTIVE BI DASHBOARD as Custom title text.</div>
</li>
</ul>
<br />
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhI4aPZL8MKFpxZg2p8nCr0PR6fnihsAmTlmMmumtJ5e9DjFJj_IWNXNAIk6NcDI1G6dcpDvfFhKmqpizPe7d41TDdoDwG_3b_Ijy7tR36a7A0cRHEJousdODyO2Gi2R-Nx6B4y8M6E1NC2/s1600/Custom+browser+Title+name.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhI4aPZL8MKFpxZg2p8nCr0PR6fnihsAmTlmMmumtJ5e9DjFJj_IWNXNAIk6NcDI1G6dcpDvfFhKmqpizPe7d41TDdoDwG_3b_Ijy7tR36a7A0cRHEJousdODyO2Gi2R-Nx6B4y8M6E1NC2/s1600/Custom+browser+Title+name.png" /></a></div>
<br />
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Hope It Helps!!</div>
<div class="MsoNormal">
Thanks,</div>
<div class="MsoNormal">
Shanmugha Bharathy G B</div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-29255396047083124252013-12-11T01:41:00.003-08:002013-12-11T01:46:23.342-08:00How to Change/Reset forgotten Password in OBIEE 10G and 11G<div dir="ltr" style="text-align: left;" trbidi="on">
<div>
<u><b>Reset forgotten Password in OBIEE 10G and 11G:</b></u></div>
<div>
<u><b>OBIEE 10G:</b></u></div>
<div>
In OBIEE 10g, If you forgot the repository (RPD) password, we can easily rest with simple straight configuration change (AUTHENTICATION_TYPE = BYPASS_NQS) in NQSConfig.ini file.</div>
<div>
<div>
<ul style="text-align: left;">
<li>Open NQSConfig.INI file</li>
<li>Go to Security part and find AUTHENTICATION_TYPE = BYPASS_NQS;</li>
<li>Uncomment (remove #) this part.</li>
<li>Stop the BI Server service</li>
<li>Close Administration Tool, if opened. (Then only the changes are affecting to the Administration Tool)</li>
<li>Open Administration Tool, then rpd which needs password reset, in offline mode</li>
<li>Give any password, it accepts.</li>
<li>Now go to Manage > Security.</li>
<li>From here it’s the normal process how you change password.</li>
<li>Save the changes to rpd</li>
<li>Revert back the changes in NQSConfig.INI</li>
<li>Start BI Server and open rpd with new password.</li>
</ul>
<div>
<u><b>OBIEE 11G:</b></u></div>
</div>
In OBIEE 11g, you can get a password for an already deployed RPD. With the help of wlst Script, you can get the forgotten OBI Repository password that is deployed earlier.<br />
<br />
<ul style="text-align: left;">
<li>Login to weblogic EM (http://localhost:7001/em) and navigate to credentials store page.</li>
</ul>
<div>
<img alt="Credential Store" src="http://naveen78.files.wordpress.com/2013/06/credential-store.jpg?w=645&h=353" /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Expand the key map: oracle.bi.enterprise. This is the key map which stores all the repository passwords that are deployed.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_grQ_qjBLwB6132yOYgcNU2X4EhEFdzCL9KQC_6VpdOJVjrxo9F4-jpDVqta37PTUllUAUUodKi8sfj3j74LG5K_iGWaBLmWwjH4A7ZY0hTp7Fpi_KjT-GEeXcoZ8LwRCUPL_ddUD9oMB/s1600/1111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_grQ_qjBLwB6132yOYgcNU2X4EhEFdzCL9KQC_6VpdOJVjrxo9F4-jpDVqta37PTUllUAUUodKi8sfj3j74LG5K_iGWaBLmWwjH4A7ZY0hTp7Fpi_KjT-GEeXcoZ8LwRCUPL_ddUD9oMB/s1600/1111.png" /></a></div>
<div>
<br /></div>
<div>
<ul style="text-align: left;">
<li>I want to reset/change repository SampleAppLite, to get the password of “SampleAppLite_BI0003″ Repoitory,</li>
<li>Open Command Prompt</li>
<li>C:\Windows\system32>cd D:\OBIEE11g\oracle_common\common\bin</li>
<li>Run wlst Script: D:\OBIEE11g\oracle_common\common\bin>wlst.cmd</li>
<li>Connect to weblogic Domain with the command:</li>
<li>connect(“<weblogic_AdminUser>”,”<weblogic_AdminUser_Password?”,”<AdminServer_HostName>:<AdminServer_Portno>”)</li>
<li>E.g: wls:/offline> connect(“Administrator”,”welcome123″,”localhost:9704″)</li>
<li>Connecting to t3://localhost:9704 with userid Administrator …Successfully connected to managed Server ‘bi_server1′ that belongs to domain ‘bifoundation_domain’.</li>
<li>Run listCred() command to get the password of SampleAppLite_BI0003 repository wls:/bifoundation_domain/serverConfig>listCred(“oracle.bi.enterprise”,”repository.SampleAppLite_BI0003″)</li>
<li>Location Changed to domainRuntime tree.</li>
<li>[Name : tempvalue, Description : null, expiry Date : null] </li>
<li>PASSWORD:Admin123</li>
</ul>
<div>
Hope it Helps!!</div>
</div>
</div>
<div>
Thanks,</div>
<div>
Shanmugha Bharathy G B</div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-91387520690462680332013-12-09T02:00:00.001-08:002013-12-09T02:05:23.195-08:00OBIEE 10g to OBIEE 11g Upgradation<div dir="ltr" style="text-align: left;" trbidi="on">
<b><u>OBIEE 10g to OBIEE 11g Upgrade</u></b><br />
<b><u><br /></u></b>
Hi,<br />
<br />
Our client wanted their OBIEE application to be upgraded from OBIEE 10g to OBIEE 11g. For this up-gradation the steps which i have followed has been shared below.<br />
<br />
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="line-height: 20.0625px;"><u><b>Upgrade Assistant</b></u></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="line-height: 20.0625px;">Upgrade Assistant is the utility to upgrade OBIEE from 10g to 11g which has been installed by default and is located under Oracle fusion middleware home $ORACLE_FMW/bin.</span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="line-height: 20.0625px;"><br /></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="line-height: 20.0625px;"><b><u>Pre-Requisites:</u></b></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
</div>
<ul style="text-align: left;">
<li><span style="line-height: 20.0625px;">Start up all the OBIEE 11g related services (BI Services and Web logic Server) and check that you can log in to Enterprise Manager,WLS Admin Console and OBIEE Answers.</span></li>
<li><span style="line-height: 20.0625px;">Enterprise Manager : http://localhost:7001/em</span></li>
<li><span style="line-height: 20.0625px;">Web Logic Server Admin Console: http://localhost:7001/em console</span></li>
<li><span style="line-height: 20.0625px;">OBIEE Answers/Dashboard : http://localhost:9704/analytics </span></li>
<li><span style="line-height: 20.0625px;">All the relevant TNS names used in the 10g rpd connections are present in/Oracle_BI1/network/admin/tnsnames.ora file</span></li>
</ul>
<div>
<span style="line-height: 20.0625px;">Step 1:</span></div>
<div>
<ul style="text-align: left;">
<li><span style="line-height: 20.0625px;">Navigate to <OBIEE_MW_HOME>/Oracle_BI1/bin/ua.bat . This batch file is the Upgrade Assistant file which launches the upgrade wizard by double clicking on it.</span></li>
</ul>
</div>
<br />
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgS2_8fswpP1QUOvWMoC6iR5lPY7yIyD_n9z_OxjQwor44SKsAp0qEfnPEvtjCK8-ic3qQBI9lhbkI9CrH4B5Kf0dFamPoG7GaoGr99ruV92RfyT0xZl8N-oIaqbKxKkBbd_pQc17duhc-O/s1600/1111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgS2_8fswpP1QUOvWMoC6iR5lPY7yIyD_n9z_OxjQwor44SKsAp0qEfnPEvtjCK8-ic3qQBI9lhbkI9CrH4B5Kf0dFamPoG7GaoGr99ruV92RfyT0xZl8N-oIaqbKxKkBbd_pQc17duhc-O/s1600/1111.png" /></a></div>
<div>
Step 2:</div>
<div>
<ul style="text-align: left;">
<li>In this page select "Upgrade Oracle BI RPD and Presentation Catalog" radio button. Click NEXT</li>
</ul>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhW__zMgMaauJNl-4QKO-zMvKNxMI0fJ6CMTPqthdI793SAVmIP7122ogh5jDghYQMPegFIDfyhcVAEymLwTt56SX1Fb-BULEXukvBbqtrg2mIlSj0u2JWQiTxedZMie5GbYd0RQMZpIxdA/s1600/1111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhW__zMgMaauJNl-4QKO-zMvKNxMI0fJ6CMTPqthdI793SAVmIP7122ogh5jDghYQMPegFIDfyhcVAEymLwTt56SX1Fb-BULEXukvBbqtrg2mIlSj0u2JWQiTxedZMie5GbYd0RQMZpIxdA/s1600/1111.png" /></a></div>
<div class="separator" style="clear: both;">
Step 3:</div>
<div class="separator" style="clear: both;">
</div>
<ul style="text-align: left;">
<li>Here check the "Upgrade Repository (RPD)" checkbox.</li>
<li>Specify the location of the 10g RPD file.</li>
<li>Enter the Administrator credentials of the old 10g RPD file.</li>
<li>Specify the password for the upgraded 11g RPD and confirm it once again.</li>
</ul>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiInzc8AWGg_JFZknbSxY4MVSdpsgfVscUHhb5uWGhrIeypUrI2w41ixZGFcVc9a0pyWG-yv0uYdUbfD-5Yra8y5_qTnc-v8ZK7UlVVYwDWwgWdIy1oNOnTUe4jjAcqea30tAZxlm91bjnW/s1600/1111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiInzc8AWGg_JFZknbSxY4MVSdpsgfVscUHhb5uWGhrIeypUrI2w41ixZGFcVc9a0pyWG-yv0uYdUbfD-5Yra8y5_qTnc-v8ZK7UlVVYwDWwgWdIy1oNOnTUe4jjAcqea30tAZxlm91bjnW/s1600/1111.png" /></a></div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
Step 4:</div>
<div class="separator" style="clear: both;">
</div>
<ul style="text-align: left;">
<li>Specify the Weblogic Admin Console username and password. Port number is 7001 and Click Next..</li>
<li>During the examination process, Upgrade Assistant checks for the following:</li>
<li>The source directory exists.</li>
<li>The source directory is readable and contains a file for upgrade.</li>
<li>Under the Status column, the word succeeded should appear. If instead, the word failed appears, inspect the log file for details.</li>
</ul>
<br />
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiclWD8BnTEiKFroFIyUSdieQQenJpwA3RHbryvZB_bsaiujZtj5_w7eErJqzuyiYz7kb9GHSRRE0TcHquaatYX_aNRKb6CQ4MzvIArSfSIiiXWGs2jx0GJYKGg8HREuDAmaWNTNYhl-QMg/s1600/1111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiclWD8BnTEiKFroFIyUSdieQQenJpwA3RHbryvZB_bsaiujZtj5_w7eErJqzuyiYz7kb9GHSRRE0TcHquaatYX_aNRKb6CQ4MzvIArSfSIiiXWGs2jx0GJYKGg8HREuDAmaWNTNYhl-QMg/s1600/1111.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both;">
Step 5:</div>
<div class="separator" style="clear: both;">
</div>
<ul style="text-align: left;">
<li>Check the upgrade summary and click UPGRADE to start the upgrade process.</li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwJ38qXfA6OBiB4uQV9ykJJZCuTa1IBxhCrmy9fwwLoNK4oDYQg-JaNOc2-8AGJg5RpM1ZpAY4_feSfeiQ4T-k6yYOiomwx6HCtdXEEyjFgEY22TFxNrh96T_91T0eRZkX6rrY-r9SjD-a/s1600/1111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwJ38qXfA6OBiB4uQV9ykJJZCuTa1IBxhCrmy9fwwLoNK4oDYQg-JaNOc2-8AGJg5RpM1ZpAY4_feSfeiQ4T-k6yYOiomwx6HCtdXEEyjFgEY22TFxNrh96T_91T0eRZkX6rrY-r9SjD-a/s1600/1111.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<ul style="text-align: left;">
<li>Once you click Upgrade the process takes place till from Status in Progress changes to Success..</li>
</ul>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicgQ0JZkXw1Qir_i1I8FYIuPL5Vm0x0TXwXBy0MFd9a_LbiA7CCbbFPVgMcHFYZtoI1bWmvJF439YCPZdgcV0l3JS20dlJrQsrcPb71z4dAMaVDXE-NsG5CQZ99D_XthRIRgP24HiK7r0F/s1600/1111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicgQ0JZkXw1Qir_i1I8FYIuPL5Vm0x0TXwXBy0MFd9a_LbiA7CCbbFPVgMcHFYZtoI1bWmvJF439YCPZdgcV0l3JS20dlJrQsrcPb71z4dAMaVDXE-NsG5CQZ99D_XthRIRgP24HiK7r0F/s1600/1111.png" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div>
<br /></div>
<br />
<div>
Step 6:</div>
<div>
<div>
<ul style="text-align: left;">
<li>Once the upgrade process completes the process log output is available at <OBIEE_MW_HOME>\Oracle_BI1\upgrade\logs</li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5j8YrVoG_qyCuaBXi5ICemoKeInwdvMa2qDrBoktHmQU4tDE5yevCQoJcrOV5x1hjtVcRfbe0-VFQFYzEgI0wBLO1tZnvdWvXOJWgGKivAQ2gI8c8L0p-UfgGG3XNlZCjPT5v-m_WqUD-/s1600/1111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5j8YrVoG_qyCuaBXi5ICemoKeInwdvMa2qDrBoktHmQU4tDE5yevCQoJcrOV5x1hjtVcRfbe0-VFQFYzEgI0wBLO1tZnvdWvXOJWgGKivAQ2gI8c8L0p-UfgGG3XNlZCjPT5v-m_WqUD-/s1600/1111.png" /></a></div>
<div>
<br /></div>
</div>
<div>
<div>
<ul style="text-align: left;">
<li>The new rpd will be named as OldPaint_BI001.rpd and placed at the following path:<OBIEE_MW_HOME>\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository. </li>
<li>As part of upgrade, security is also upgraded from 10g to 11g. This includes the Users and Groups.</li>
<li>A 11G version of RPD and WebCat will automatically be placed in the right 11G directory and the NQSconfig,INI file will have a proper entry done. There is no need for any manual edition.</li>
</ul>
</div>
</div>
<div>
<div>
<br /></div>
<div>
There are a few little things we need to do to ensure our 11G environment is ready to run, These changes are typically done once after the upgrade:</div>
<div>
<br /></div>
<div>
Configure the Administrator user account in 11G:</div>
<div>
<br /></div>
<div>
Since 11G has a very different security management system, the Administrator account, which was managed in the Admin Tool in 10G will need to be configured in the weblogic to ensure access using this account. To do so, go to Weblogic console (under 'My realm') and edit the Administrator user by clicking on it:</div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbNSkKudwLtR7oX8Uj58ea58ImrgsVvTXDgiVXJE9olIMbC4CE-L2WYoqzqAM-iHjZi9za-WoA4KaJJRKIdy7WdEQFz3ojbktvGpKbpX-3c_P4Rizap4sQFPqki-0Ib6Ne8DscJWn34J3-/s1600/1111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbNSkKudwLtR7oX8Uj58ea58ImrgsVvTXDgiVXJE9olIMbC4CE-L2WYoqzqAM-iHjZi9za-WoA4KaJJRKIdy7WdEQFz3ojbktvGpKbpX-3c_P4Rizap4sQFPqki-0Ib6Ne8DscJWn34J3-/s1600/1111.png" /></a></div>
<div>
<br /></div>
</div>
<div class="separator" style="clear: both;">
<br /></div>
<div>
<div>
Give a new password:</div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBqj_kSoSOIeGE604zWrLrzlx8PcvDdfnGTBO-RN-UmPm3F62m1UZaLi4XmmwLI4gvQSUnvK4cACIR9fFiwbPzAX_t7Oiq4AbB4akkSk2mibRdFeW5T0sPfmwHkxw0-0JbCzxIeZHzGmEL/s1600/1111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBqj_kSoSOIeGE604zWrLrzlx8PcvDdfnGTBO-RN-UmPm3F62m1UZaLi4XmmwLI4gvQSUnvK4cACIR9fFiwbPzAX_t7Oiq4AbB4akkSk2mibRdFeW5T0sPfmwHkxw0-0JbCzxIeZHzGmEL/s1600/1111.png" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Release Configuration and restart all BI Services and test logging into Web Presentation using this new password. You will be able to log in as Administrator now..Now you have successfully upgraded OBIEE from 10g to 11g...</div>
<div>
<br /></div>
<div>
Hope it Helps!!</div>
<div>
Thanks,</div>
<div>
Shanmugha Bharathy G B</div>
<div>
<br /></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-20717306030188297962013-12-06T01:28:00.001-08:002013-12-06T01:28:20.080-08:00Exceeded Configured Maximum number of allowed Input Records in OBIEE 11G<div dir="ltr" style="text-align: left;" trbidi="on">
<b><u>Exceeded Configured Maximum number of allowed Input Records</u></b><br />
<b><u><br /></u></b>
<br />
<ul style="text-align: left;">
<li>Where you run a analysis which retrieves more number of records say for an example above 80000 the following error will pop up.</li>
</ul>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIwHOVuUsWGVkbH9UZ2szlkq1smpC4AU_G-1DZ65vgmo9coqpyALCdo4KkZD6JrdnNjEMi2Lm5AFCWEC6IZzELStDze1PVghx1zYnddvlAy6QWGbTuYOwd6eYrd6Nu3AKAccYbRLA-nIry/s1600/1111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIwHOVuUsWGVkbH9UZ2szlkq1smpC4AU_G-1DZ65vgmo9coqpyALCdo4KkZD6JrdnNjEMi2Lm5AFCWEC6IZzELStDze1PVghx1zYnddvlAy6QWGbTuYOwd6eYrd6Nu3AKAccYbRLA-nIry/s1600/1111.png" /></a></div>
<b><u><br /></u></b>
<br />
<ul style="text-align: left;">
<li>In OBIEE default number of rows processed when rendering a table view will be set to 65000. In such cases goto>em>Business Intelligence>Coreapplication>Capacity Management>Performance and select lock & edit configuration.</li>
<li>In the right pane you can see below screenshot and change from 65000 as per your requirement. In this example i have used 100000... and restart your services to take effect.</li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJY9t5kScPBWqRCsnWq3D5W_d9MIIpOZeqvsBoo-DINowC4Ng0p5trKvfhIkltm2lseVJUXJTJF2larHAS0BQHVo7qBTbRql1E8Vl7xMcdSEOnmOau6gs1YRX6jShT2FK7wxACIFrjOwV2/s1600/1111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJY9t5kScPBWqRCsnWq3D5W_d9MIIpOZeqvsBoo-DINowC4Ng0p5trKvfhIkltm2lseVJUXJTJF2larHAS0BQHVo7qBTbRql1E8Vl7xMcdSEOnmOau6gs1YRX6jShT2FK7wxACIFrjOwV2/s1600/1111.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<ul style="text-align: left;">
<li>This may impact your performance if more number of rows are set....</li>
</ul>
<div>
I got this error and i have explained how i fixed it...</div>
<div>
Hope it Helps!...</div>
<div>
<br /></div>
<div>
Thanks,</div>
<div>
Shanmugha Bharathy G B</div>
<div>
<br /></div>
<div>
<br /></div>
<br />
<div>
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-70668027026797429142013-12-05T02:45:00.000-08:002013-12-05T02:54:12.146-08:00Redirecting Home Page to Custom Page in OBIEE 11G<div dir="ltr" style="text-align: left;" trbidi="on">
<b><u>Redirecting Home Page to Custom Page in OBIEE 11G</u></b><br />
<div>
<b><u><br /></u></b></div>
<div>
Normally when you click HOME page in OBIEE it will redirect to the page as shown below.</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8cmAE4z8ePOy-KDgHNo8colpsQbRQ0mPRMjEPlfgK1kyrX85pbgY49rFO3m80pwRNWuJj2IzQYFvJDL9jh162r_nmGC-kEtT7EF6EAF-9jp5QkMhvNfnAPBmqYKDHHGdPd3KkUBSX-MsX/s1600/1111.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8cmAE4z8ePOy-KDgHNo8colpsQbRQ0mPRMjEPlfgK1kyrX85pbgY49rFO3m80pwRNWuJj2IzQYFvJDL9jh162r_nmGC-kEtT7EF6EAF-9jp5QkMhvNfnAPBmqYKDHHGdPd3KkUBSX-MsX/s1600/1111.png" height="265" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" dir="rtl" style="clear: both; text-align: left;">
<br /></div>
<div>
But clients wants their home page to be displayed when they click HOME button.<br />
All the HEADER icons displayed in OBIEE are based on a header file.<br />
For this </div>
<div>
1.Goto>\MiddlewareHome\Oracle_BI1\bifoundation\web\app\res\b_mozilla</div>
<div>
In this folder you will have a file naming HEADER.JS</div>
<div>
2. Open HEADER.JS file and search for "saw.header.NavBar.prototype.onHome=function(b,a){saw.header.openURL(saw.commandToURL("bieehome"),a)}" tag...</div>
<div>
3. Now replace the above tag with your customization link (in this example i have used google.com but you can use your own customization page like "saw.dll?Dashboard&portalPath="custom page link") saw.header.NavBar.prototype.onHome=function(){window.location.href="http://www.google.com </div>
<div>
4. Save the changes and bounce OBIEE.</div>
<div>
5. Sometimes it will not reflect and in those scenario you will also replace HEADER.JS file in below path \MiddlewareHome\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\b_mozilla</div>
<div>
under tmp folder to make changes perfect.</div>
<div>
6. Now you have successfully redirected OBIEE home page to your Custom page.</div>
<div>
<br /></div>
<div>
Hope it Helps!</div>
<div>
<br />
Thanks,</div>
<div>
Shanmugha Bharathy G B</div>
<div>
<br /></div>
<div>
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-91425272717132319372013-12-04T08:07:00.003-08:002013-12-04T08:07:15.660-08:00DATA WAREHOUSE BASICS<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">William H. Inmon</span> (born 1945) is an American computer scientist, recognized by many as the father of the data warehouse. Bill Inmon created the accepted definition of what a data warehouse is - a subject oriented, nonvolatile, integrated, time variant collection of data in support of management's decisions. Compared with the approach of the other pioneering architect of data warehousing, Ralph Kimball, Inmon's approach is often characterized as a top-down approach.<span id="cite_ref-1" style="bottom: 1ex; font-size: 10px; font-style: inherit; font-weight: inherit; height: 0px; line-height: 1; position: relative; vertical-align: baseline;"><a data-mce-href="http://en.wikipedia.org/wiki/Bill_Inmon#cite_note-1" href="http://en.wikipedia.org/wiki/Bill_Inmon#cite_note-1" style="color: #1b8be0; font-size: 14px; font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: none;"><br style="color: #222222; font-style: inherit; font-weight: inherit; line-height: 1.7;" /></a></span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Ralph Kimball (Born 1944) is an author on the subject of data warehousing and business intelligence. He is widely regarded as one of the original architects of data warehousing and is known for long-term convictions that data warehouses must be designed to be understandable and fast. His methodology, also known as dimensional modeling or the Kimball methodology, has become the de facto standard in the area of decision support.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">DATA WAREHOUSE CONCEPTS</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
A fundamental concept of a data warehouse is the distinction between <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">data </span>and <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">information</span>. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Data </span>is composed of observable and recordable facts that are often found in operational or transactional systems. At Rutgers, these systems include the registrar’s data on students (widely known as the SRDB), human resource and payroll databases, course scheduling data, and data on financial aid. In a data warehouse environment, <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">data </span>only comes to have value to end-users when it is organized and presented as <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">information</span>. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Information </span>is an integrated collection of facts and is used as the basis for decisionmaking. For example, an academic unit needs to have diachronic information about its extent of instructional output of its different faculty members to gauge if it is becoming more or less reliant on part-time faculty.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">DATA WAREHOUSE DEFINITIONS</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
The data warehouse is that portion of an overall Architected Data Environment that serves as the single integrated source of data for processing information. The data warehouse has specific characteristics that include the following:</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">Subject-Oriented:</strong> Information is presented according to specific subjects or areas of interest, not simply as computer files. Data is manipulated to provide information about a particular subject. For example, the SRDB is not simply made accessible to end-users, but is provided structure and organized according to the specific needs.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">Integrated:</strong> A single source of information for and about understanding multiple areas of interest. The data warehouse provides one-stop shopping and contains information about a variety of subjects. Thus the OIRAP data warehouse has information on students, faculty and staff, instructional workload, and student outcomes.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">Non-Volatile</strong><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">: </span>Stable information that doesn’t change each time an operational process is executed.Information is consistent regardless of when the warehouse is accessed.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">Time-Variant:</strong> Containing a history of the subject, as well as current information. Historical information is an important component of a data warehouse.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">Accessible:</strong> The primary purpose of a data warehouse is to provide readily accessible information to end-users.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">Process-Oriented: </strong>It is important to view data warehousing as a process for delivery of information. The maintenance of a data warehouse is ongoing and iterative in nature.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;"><strong style="font-style: inherit; line-height: 1.7;">Other Definitions</strong></span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">Data Warehouse:</strong> A data structure that is optimized for distribution. It collects and stores integrated sets of historical data from multiple operational systems and feeds them to one or more data marts. It may also provide end-user access to support enterprise views of data.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">Data Mart: </strong>A data structure that is optimized for access. It is designed to facilitate end-user analysis of data. It typically supports a single, analytic application used by a distinct set of workers.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">Staging Area:</strong> Any data store that is designed primarily to receive data into a warehousing environment.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">Operational Data Store: </strong>A collection of data that addresses operational needs of various operational units. <i style="font-weight: inherit; line-height: 1.7;">It is not a component of a data warehousing architecture, but a solution to operational needs.</i></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">OLAP (On-Line Analytical Processing):</strong> A method by which multidimensional analysis occurs.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">Multidimensional Analysis:</strong> The ability to manipulate information by a variety of relevant categories or “dimensions” to facilitate analysis and understanding of the underlying data. It is also sometimes referred to as “drilling-down”, “drilling-across” and “slicing and dicing”</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">Star Schema:</strong> A means of aggregating data based on a set of known dimensions. It stores data multidimensionally in a two dimensional Relational Database Management System (RDBMS), such as Oracle.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">Snowflake Schema: </strong>An extension of the star schema by means of applying additional dimensions to the dimensions of a star schema in a relational environment.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">What is datawarehouse?</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;"></strong>Datawarehouse is a</div>
<ul style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; list-style: square; margin: 0px 0px 0.825em 2.5em; padding: 0px;">
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Subject-oriented-Data warehouses are designed to help you analyze data. For example, to learn more about your company's sales data, you can build a warehouse that concentrates on sales. Using this warehouse, you can answer questions like "Who was our best customer for this item last year?" This ability to define a data warehouse by subject matter, sales in this case, makes the data warehouse subject oriented.</li>
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Non-volatile-Once entered into the warehouse, data should not change. This is logical because the purpose of a warehouse is to enable you to analyze what has occurred.</li>
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Integrated-Integration is closely related to subject orientation. Data warehouses must put data from disparate sources into a consistent format. They must resolve such problems as naming conflicts and inconsistencies among units of measure. When they achieve this, they are said to be integrated.</li>
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Time-varient-In order to discover trends in business, analysts need large amounts of data. This is very much in contrast to online transaction processing (OLTP) systems, where performance requirements demand that historical data be moved to an archive. A data warehouse's focus on change over time is what is meant by the term time variant.</li>
</ul>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
database system.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">What are the steps involved in loading a datawarehouse?</strong><br />
There are 3 steps in datawarehousing,</div>
<ul style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; list-style: square; margin: 0px 0px 0.825em 2.5em; padding: 0px;">
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;">data-extraction from the OLTP system</li>
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Apply the required transformations on the data</li>
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Load the data into datawarehouse</li>
</ul>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">What is fact table?</strong><br />
Fact table is a table, which is having the multiple foreign keys of the dimension tables and measures.Fact table is also called as child table having dimension codes and facts/measures.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">What is dimension table?</strong><br />
Dimension table is a table,which is having the descriptive information of an entity.This is also called as master table having the primary key.Always the data flow from dimension table to fact table.<br />
<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />
<strong style="font-style: inherit; line-height: 1.7;">What is data-modelling?</strong><br />
The process of storing and retrieving the data from datawarehouse is called as data-modelling.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />
<strong style="font-style: inherit; line-height: 1.7;">What is star schema and snow-flake schema?What is the difference between those?</strong><br />
Star is one fact and many dimensions where as Snowflake design is one fact and many dimensions and dimensions can have additional dim relations.No.of joins in the snow-flake schema is more compare to star schema.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">Difference between OLTP and OLAP systems?</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
OLTP(Online transactional process)<br />
Dynamic data<br />
volatile<br />
Normalised data<br />
Efficient for data storing<br />
OLAP(Online Analytical process)<br />
90%static,10%Dynamic data<br />
Non-volatile<br />
De-normalised data<br />
Efficient for data retrieving</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">What are different types of dimensions?</strong></div>
<ul style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; list-style: square; margin: 0px 0px 0.825em 2.5em; padding: 0px;">
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;">confirmed dimension</li>
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;">slowly changing dimension</li>
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;">rapidly changing dimension</li>
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;">De-generated dimension</li>
</ul>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />
<strong style="font-style: inherit; line-height: 1.7;">What are different types of fact tables?</strong></div>
<ul style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; list-style: square; margin: 0px 0px 0.825em 2.5em; padding: 0px;">
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Additive fact table</li>
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;">semi-additive fact table</li>
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Non-additive or fact-less fact table</li>
</ul>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">What is Federated Query?</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
A query is fired across multiple sources is called as federated query.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
like</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
select cust_first_name,revenue from customers,sales</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
customers->SQL,sales->DB2 data sources</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Hope it Helps!</div>
</div>
Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-676727543316582286.post-73024996373822175692013-12-04T08:06:00.003-08:002013-12-04T08:06:32.184-08:00MIGRATING OBIEE 11G FROM TEST TO PRODUCTION<div dir="ltr" style="text-align: left;" trbidi="on">
<ul style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; list-style: square; margin: 0px 0px 0.825em 2.5em; padding: 0px;">
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;"><span data-mce-style="font-style: normal;" style="font-weight: inherit; line-height: 1.7;"><span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;">Repository Backup</span></span></li>
</ul>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"></span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">1. </span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Goto Startup Menu>Oracle Business Intelligence Enterprise Edition>Administration</span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">2. </span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">File>Open>Online</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">3. Enter the Repository Password and Administrator Password.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
4. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">File>Copy As>Repository</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
5. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"> </span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Save Copy as to appropirate folder.</span></div>
<ul style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; list-style: square; margin: 0px 0px 0.825em 2.5em; padding: 0px;">
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;"><span data-mce-style="font-style: normal;" style="font-weight: inherit; line-height: 1.7;"><span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;">ODBC NEW DATASOURCE CREATION</span></span><span data-mce-style="font-style: normal;" style="font-weight: inherit; line-height: 1.7;"> </span></li>
</ul>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span data-mce-style="font-style: normal;" style="font-weight: inherit; line-height: 1.7;">1. </span><span data-mce-style="font-style: normal;" style="font-weight: inherit; line-height: 1.7;"> </span><span data-mce-style="font-style: normal;" style="font-weight: inherit; line-height: 1.7;">Goto Startup menu>Run>enter odbc> select Mircrosoft ODBC Administrator.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<a data-mce-href="http://sblbharathy.files.wordpress.com/2013/12/11113.png" href="http://sblbharathy.files.wordpress.com/2013/12/11113.png" style="color: #1b8be0; font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: none;"><img alt="Image" class="size-full wp-image" data-mce-src="http://sblbharathy.files.wordpress.com/2013/12/11113.png?w=401" src="http://sblbharathy.files.wordpress.com/2013/12/11113.png?w=401" id="i-43" style="border: 1px solid rgb(221, 221, 221); color: #222222; cursor: default; font-style: inherit; font-weight: inherit; height: auto; line-height: 1.7; margin-top: 0.4em; max-width: 100%; padding: 6px;" /></a></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
2.<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"> </span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Select System DSN>Add>Select Oracle BI Server and click finish.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
3. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"> </span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Enter the name of the Datasource and enter the server name as screenshot below and select next.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<a data-mce-href="http://sblbharathy.files.wordpress.com/2013/12/11116.png" href="http://sblbharathy.files.wordpress.com/2013/12/11116.png" style="color: #1b8be0; font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: none;"><img alt="Image" class="size-full wp-image" data-mce-src="http://sblbharathy.files.wordpress.com/2013/12/11116.png?w=621" src="http://sblbharathy.files.wordpress.com/2013/12/11116.png?w=621" id="i-46" style="border: 1px solid rgb(221, 221, 221); color: #222222; cursor: default; font-style: inherit; font-weight: inherit; height: auto; line-height: 1.7; margin-top: 0.4em; max-width: 100%; padding: 6px;" /></a></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
4. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"> </span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Enter Oracle BI Server login ID and password and select next.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<a data-mce-href="http://sblbharathy.files.wordpress.com/2013/12/11117.png" href="http://sblbharathy.files.wordpress.com/2013/12/11117.png" style="color: #1b8be0; font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: none;"><img alt="Image" class="size-full wp-image" data-mce-src="http://sblbharathy.files.wordpress.com/2013/12/11117.png?w=621" src="http://sblbharathy.files.wordpress.com/2013/12/11117.png?w=621" id="i-47" style="border: 1px solid rgb(221, 221, 221); color: #222222; cursor: default; font-style: inherit; font-weight: inherit; height: auto; line-height: 1.7; margin-top: 0.4em; max-width: 100%; padding: 6px;" /></a></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
5. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"> </span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Select Finish and your new datasource will be created..</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
6. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"> </span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">New tnsname.ora file should be replaced in following path “MiddlewareHome\oracle_common\network\ADMIN” with old tnsname.ora file backup.</span></div>
<div align="center" style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"><span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;">OBIEE ADMINISTRATIVE TOOL CONNCETION POOL PROPERTIES</span></span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">1. Goto>Startup menu>Oracle Business Intelligence Enterprise Edition>Administration.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
2. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Goto>File>Open>Offline>Browse for RPD.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
3. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Enter repository password to open.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
4. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Double click the database icon present in Physical layer.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
5. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Delete the old Database name (TESTDB) and Enter new Database name(PRDDB).</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<a data-mce-href="http://sblbharathy.files.wordpress.com/2013/12/11118.png" href="http://sblbharathy.files.wordpress.com/2013/12/11118.png" style="color: #1b8be0; font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: none;"><img alt="Image" class="size-full wp-image" data-mce-src="http://sblbharathy.files.wordpress.com/2013/12/11118.png?w=412" src="http://sblbharathy.files.wordpress.com/2013/12/11118.png?w=412" id="i-48" style="border: 1px solid rgb(221, 221, 221); color: #222222; cursor: default; font-style: inherit; font-weight: inherit; height: auto; line-height: 1.7; margin-top: 0.4em; max-width: 100%; padding: 6px;" /></a></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
6. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Select Connection Pool and select edit button.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
7. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Change old datasource name to new datasource name.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
8. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"> </span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">After changing the Datasource name save the changes and check for Global Consistency.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
9. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Once Global Consistency check is completed select ok.</span></div>
<ul style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; list-style: square; margin: 0px 0px 0.825em 2.5em; padding: 0px;">
<li style="font-style: inherit; font-weight: inherit; line-height: 1.7;"><span data-mce-style="font-style: normal;" style="font-weight: inherit; line-height: 1.7;"><span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;">CATALOG MIGRATION FROM TEST TO PRODUCTION ENVIRONEMENT</span></span><span data-mce-style="font-style: normal;" style="font-weight: inherit; line-height: 1.7;"> </span></li>
</ul>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">1. </span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Test catalog folder present in /u01/app/Middleware/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/SampleAppLite/” (folder naming SampleAppLite) from OBIE.TEST environment should be replaced in OBIE.PRD environment ”u01/app/Middleware/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/SampleAppLite/” with SampleAppLite backup in OBIE.PRD</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"></span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">2. </span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Once the catalog folder is moved go to </span><a data-mce-href="http://byss.advansdrm.com:7001/em" href="http://byss.advansdrm.com:7001/em" style="color: #1b8be0; font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: none;"><span style="color: #222222; font-style: inherit; font-weight: inherit; line-height: 1.7;">http://OBIE.PRD.com:7001/em</span></a><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"> enter username and password.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">3. In left pane Expand Business Intelligence and select coreapplication.</span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Business Intelligence>Coreapplication>delployment>repository</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
4. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Select Lock & Edit Configuration option and once done select close.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
5. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"> </span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Browse>Upload saved repository file and enter repository password and click apply button. </span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
6. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"> </span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Once apply button is selected Default RPD name will changed to new one.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
7. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Once the name has changed select activate changes.<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Restart all BI services.</span></span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
8. <span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"> </span><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;">Login to </span><a data-mce-href="http://byss.advansdrm.com:9704/analytics" href="http://byss.advansdrm.com:9704/analytics" style="color: #1b8be0; font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: none;"><span style="color: #222222; font-style: inherit; font-weight: inherit; line-height: 1.7;">http://OBIE.PRD.com:9704/analytics</span></a><span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"> and now catalog has been migrated from test to production environment.</span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
NOTE: In some cases user based security configuration wont be applied in above process so we have to logon to enterprise manager>weblogic domain>security>credentials>oracle.bi.system>system.user>edit>change password and restart all the BI servies.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Hope it Helps...</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Thanks,</div>
<br />
<div>
</div>
<br />
<div style="-webkit-text-stroke-width: 0px; color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 23px; margin-bottom: 0.825em; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<div style="margin: 0px;">
Shanmugha Bharathy G B</div>
</div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-2203309508949455422013-12-04T08:04:00.002-08:002013-12-04T08:04:59.379-08:00Oracle BI 11g Architecture Components Descriptions<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"><span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;">Over all BI Domain:</span></span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Overall system is called “Oracle BI Domain” . This comprises of Java components deployed into J2EE containers , non java system components and required configuration files, metadata, repositories, and infrastructure. Oracle Enterprise Manager(OEM) acts as “Fusion Middleware Control” which together with Weblogic Admin Console are the basic backbone,the powerhouse and the Admin Activity controller for the entire domain .</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"><span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;">Weblogic Server Domain:</span></span> The logical domain consists of Admin server and Managed server .It comprises mainly with all the Java modules to trigger the java services .A peer handshaking has been done between WLSD and Oracle BI Instance.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"><span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;">Administration Server:</span></span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
A JEE container that runs in a dedicated Java virtual machine that contains Java components for administering the system .It typically trigger the start,stop kind of admin activity for his peer Manager server processes.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"><span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;">Managed Server:</span></span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
A JEE container that runs in a dedicated Java virtual machine that provides the run-time environment for the Java-based services and applications within the system.The services comprises of BI plugin , Security , publisher ,SOA ,BI Office services etc .</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"><span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;">Node Manager:</span></span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Node Manager provides process management services for the Administration Server and Managed Server processes.Its a separate java utility runs to trigger the auto start , stop , restart activities for distributed Managed server.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"><span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;">Oracle Process Manager and Notification Server(OPMN):</span></span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
It is monitored , managed and controlled by Fusion Middleware Controller(OFMW). It is also used for distributed process start/stop/restart i.e maintains the Oracle Business Intelligence system component processes.Also used for performance collection using Dynamic Monitoring System (DMS) .</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"><span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;">Oracle Weblogic Server (Console):</span></span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
It is the replacement of Oracle 10g R3 middle tier cluster topology based on Oracle Container for Java (OC4J) . It is a Java EE application server that supports the deployment of Oracle Business Intelligence Java components and primarily host the java component services inside Managed server .</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle WebLogic Server Administration Console access has been provided by Fusion Middleware Control.Oracle WebLogic Server Administration Console enables to monitor and manage a WebLogic Server domain. Its capabilities include the following:</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Monitoring health and performance of JEE servers</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Configuring WebLogic domains</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Stopping and starting JEE servers</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Viewing JEE server logs</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"><span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;">Fusion Middleware Control:</span></span></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Fusion Middleware Control is a browser-based tool and the recommended method for monitoring, managing, and configuring Oracle Business Intelligence components.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Fusion Middleware Control is used principally for managing the system components of a BI domain and provides support for the following:</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Starting, stopping, and restarting all system components (BI Server,BI Presentation Server) and Managed Servers</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Configuring preferences and defaults</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Scaling out of system components</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Managing performance and monitoring system metrics(DMS-Dynamic Monitoring System)</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Performing diagnostics and logging (ODL-Oracle Diagnostic Logging)</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Fusion Middleware Control also provides access to Oracle WebLogic Server Administration Console, where you monitor and manage Oracle Business Intelligence Java components.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
To be very precise OFMW contains to components ..i.e. Java Components managed by Weblogic Server and System components managed by Oracle Process Manager and Notification (OPMN) and this includes below as well including BI components :</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle HTTP Server</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle Web Cache</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle Internet Directory</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle Virtual Directory</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle Forms Services</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle Reports</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle Business Intelligence Discoverer</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"><span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;">OFMW Environment:</span></span> Oracle Fusion Middleware environment contains Oracle WebLogic Server domain (including Administration Server, two Managed Servers) , an Oracle instance and Metadata repository .</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"><span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;">Java components</span></span>: Deployed as one or more Java EE applications:</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Administrative Components — Enterprise Management applications and JMX MBeans for managing all configuration and run-time settings for Oracle Business Intelligence.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle BI Publisher — This component provides an enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents to employees, customers, and suppliers.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle BI Office — This component provides the integration between Oracle Business Intelligence and Microsoft Office products.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle BI Action Services — This component provides the dedicated Web services that are required by the Action Framework and that enable an administrator to manually configure which Web service directories can be browsed by users when they create actions.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle Real-Time Decisions (Oracle RTD) — This component provides enterprise analytics software solutions that enable companies to make better decisions in real-time at key, high-value points in operational business processes.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle BI Security Services — This component provides dedicated Web services that enable the integration of the Oracle BI Server with the Oracle Fusion Middleware security platform i.e JPS (Java Platform Security) , CSF (Credential Store Framework) and users and groups managed by BI LDAP security.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle BI SOA Services — This component provides dedicated Web services for objects in the Oracle BI Presentation Catalog, to invoke analyses, agents, and conditions. They make it easy to invoke Oracle Business Intelligence functionality from Business Process Execution Language (BPEL) processes.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle BI Plugin — A JEE application that routes HTTP and SOAP requests to Oracle BI Presentation Services.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<span style="font-style: inherit; font-weight: inherit; line-height: 1.7;"><span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;">System components</span></span>: Deployed as non-JEE components, such as processes and services written in C++ and J2SE:</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle BI Server — This component provides the query and data access capabilities at the heart of Oracle Business Intelligence and provides services for accessing and managing the enterprise semantic model (stored in a file with a .RPD extension).</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle BI Presentation Services — This component provides the framework and interface for the presentation of business intelligence data to Web clients. It maintains an Oracle BI Presentation Catalog service on the file system for the customization of this presentation framework.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle BI Scheduler — This component provides extensible scheduling for analyses to be delivered to users at specified times. (Oracle BI Publisher has its own scheduler)</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle BI JavaHost — This component provides component services that enable Oracle BI Presentation Services to support various components such as Java tasks for Oracle BI Scheduler, Oracle BI Publisher, and graph generation.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Oracle BI Cluster Controller — This components distributes requests to the BI Server, ensuring requests are evenly load-balanced across all BI Server process instances in the BI domain.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Thanks,</div>
<br />
<div>
</div>
<br />
<div style="-webkit-text-stroke-width: 0px; color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 23px; margin-bottom: 0.825em; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<div style="margin: 0px;">
Shanmugha Bharathy G B</div>
</div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-676727543316582286.post-31588429302763458992013-12-04T05:53:00.002-08:002013-12-04T05:53:43.109-08:00Customizing "No Data View" in 11g<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;"><span data-mce-style="text-decoration: underline;" style="font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: underline;">Alerting Users to No Data in the Results of Analyses:</span></strong><br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />When the results of an analysis return no data, the following default message is displayed to users:<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />No Results<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />The specified criteria didn't result in any data.<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />This is often caused by applying filters and/or selections that are too<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />restrictive or that contain incorrect values.<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />Please check your Analysis Filters and try again.<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />The filters currently being applied are shown below.<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" /><br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />Rather than display the default message, you can create a customized message to alert users. This allows you to provide your own explanation as to why the analysis returned no data.<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" /><br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />To create a custom message to alert users to no data in the results of an analysis:<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" /><br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />1. Edit the analysis to which you want to add a custom message.<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />2. Click the "Analysis editor: Results tab".<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />3. Click the Analysis Properties toolbar button. The "Analysis Properties dialog" is displayed.<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />4. In the No Results Settings box, select Display Custom Message.<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />5. In the Header field, enter the text of the header for the custom message.<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />6. In the Message field, enter the explanatory text.<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />7. Click OK.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
No Results feature in OBIEE helps users to customize the default message.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Below is the default message received, when the report contains restrictive filters or no data in it.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
You can customize the default message as per your requirements.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">1. Create Simple Report</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
On the Criteria Tab, click on Properties and select ‘Display Custom Message’<br style="font-style: inherit; font-weight: inherit; line-height: 1.7;" />Type the header & custom message in the message box and click ok..</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<a data-mce-href="http://sblbharathy.files.wordpress.com/2013/12/11111.png" href="http://sblbharathy.files.wordpress.com/2013/12/11111.png" style="color: #1b8be0; font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: none;"><img alt="Image" class="size-full wp-image" data-mce-src="http://sblbharathy.files.wordpress.com/2013/12/11111.png?w=650" id="i-39" src="http://sblbharathy.files.wordpress.com/2013/12/11111.png?w=650" style="border: 1px solid rgb(221, 221, 221); color: #222222; cursor: default; font-style: inherit; font-weight: inherit; height: auto; line-height: 1.7; margin-top: 0.4em; max-width: 100%; padding: 6px;" /></a></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<strong style="font-style: inherit; line-height: 1.7;">2. Check the Result</strong></div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
Select the prompts to run the report.</div>
<div style="color: #222222; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 23px; margin-bottom: 0.825em;">
<a data-mce-href="http://sblbharathy.files.wordpress.com/2013/12/11112.png" href="http://sblbharathy.files.wordpress.com/2013/12/11112.png" style="color: #1b8be0; font-style: inherit; font-weight: inherit; line-height: 1.7; text-decoration: none;"><img alt="Image" class="size-full wp-image" data-mce-src="http://sblbharathy.files.wordpress.com/2013/12/11112.png?w=650" id="i-41" src="http://sblbharathy.files.wordpress.com/2013/12/11112.png?w=650" style="border: 1px solid rgb(221, 221, 221); color: #222222; cursor: default; font-style: inherit; font-weight: inherit; height: auto; line-height: 1.7; margin-top: 0.4em; max-width: 100%; padding: 6px;" /></a></div>
<div>
<br /></div>
</div>
Unknownnoreply@blogger.com1