tag:blogger.com,1999:blog-77514474420263773252024-03-13T11:37:10.602+01:00Oracle Business Intelligence OBIEE 101A collection of OBIEE / OBISE stuff from 101 till 404. I just put the things here I run into.John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.comBlogger504125tag:blogger.com,1999:blog-7751447442026377325.post-21348281079154895622013-03-07T16:25:00.000+01:002013-03-07T16:25:10.408+01:00OBIEE This is the end?
<span style="font-family: Calibri;">…..not really, but ….<o:p></o:p></span><br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<o:p><span style="font-family: Calibri;"> </span></o:p><span style="font-family: Calibri;">As most of you might have notice my activity’s in the OBIEE
community have been minimal during the last year or so. </span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">How come? </span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">I have accepted a new challenge in becoming the team
lead for Microsoft BI at Ciber in the Netherlands . </span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">This means I have little to none time left for OBIEE
blogging.<span style="mso-spacerun: yes;"> </span>And thinks like visiting the
Rittman-Mead conference in Brighton this year are sadly also out of the
question.</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">I will be closing the possibility of adding comments /
question on this blog because I don’t have any time left to filter out the
spam. </span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">I hope to pick my OBIEE and other blogging activities up in the future but for
now:</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">Good luck and hope to see you again!<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">Till Next Time<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">John<o:p></o:p></span></div>
John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com0tag:blogger.com,1999:blog-7751447442026377325.post-69891942319642232232013-01-28T22:47:00.000+01:002013-01-28T22:47:04.263+01:00We are back!OBIEE101 has been restored! Thanks to <span class="gD" name="Nitecruzr - Blogger Top Contributor via Blogger">Nitecruzr for pushing the right buttons at google!</span><br />
<span class="gD" name="Nitecruzr - Blogger Top Contributor via Blogger"><br /></span>
<span class="gD" name="Nitecruzr - Blogger Top Contributor via Blogger">Till Next Time</span>John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com0tag:blogger.com,1999:blog-7751447442026377325.post-65532647773766858692013-01-24T19:03:00.000+01:002013-01-24T19:03:08.220+01:00OBIEE 101 is downWe know about the problem, I'm trying to contact google to get it resolved!<br />
<br />
See you SoonJohn Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com0tag:blogger.com,1999:blog-7751447442026377325.post-16280125405435838522012-05-06T11:48:00.000+02:002012-05-06T11:48:18.348+02:00OBIEE en JDev in the same FWM homeDon't do it, it screws up your OBIEE weblogic instance.........<br />
<br />
(especially when you are preparing for the Brighton 2012 BI congress.......) <br />
<br />
8-(<br />
<br />
Till Next TimeJohn Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com3tag:blogger.com,1999:blog-7751447442026377325.post-76408924194542754532012-04-23T10:16:00.000+02:002012-04-23T10:16:00.500+02:00OBIEE install avoid RTD license problems<p>If you are not going to use RTD (Real Time Decisions) uncheck the box during installation:</p> <p><a href="http://lh6.ggpht.com/-J5rnlN1_ASE/T5EbUJeAKcI/AAAAAAAAENE/MOaiQ7OQEsM/s1600-h/image%25255B2%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-MavcxC6D1rE/T5EbU3wAM3I/AAAAAAAAENI/b_HWS0hI1BQ/image_thumb.png?imgmax=800" width="244" height="85" /></a></p> <p>This avoids extremely difficult discussions with Oracle over the license fee.</p> <p>Till Next Time</p> John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com1tag:blogger.com,1999:blog-7751447442026377325.post-71808090149913477142012-04-20T09:44:00.001+02:002012-04-20T11:14:09.622+02:00OBIEE 11116 repository on MS-SQL I<p>We had to do a POC on some MS-SQL data. Instead of bringing an extra Oracle DB we used an existing MS-SQL instance.</p> <p>1. Create a repository database:</p> <p>We called ours “Repositories” <img style="border-bottom-style: none; border-left-style: none; border-top-style: none; border-right-style: none" class="wlEmoticon wlEmoticon-winkingsmile" alt="Winking smile" src="http://lh3.ggpht.com/-ppEAhXpYkw8/T5ETrrP_eKI/AAAAAAAAEKc/FIzHoF7lJls/wlEmoticon-winkingsmile%25255B2%25255D.png?imgmax=800" /></p> <p><a href="http://lh3.ggpht.com/-1_wp-GVaiUE/T5ETsR2wtvI/AAAAAAAAEKk/tX3-hs9Z0eY/s1600-h/image%25255B3%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-aIIdGFMfAXo/T5ETtF3U33I/AAAAAAAAEKo/BMr9paocVFw/image_thumb%25255B1%25255D.png?imgmax=800" width="225" height="178" /></a></p> <p>2. Enable case-sensitive collation </p> <blockquote> <p>ALTER DATABASE Repositories COLLATE Latin1_General_CS_AS</p> </blockquote> <p>3. Enable Row versioning</p> <blockquote> <p>ALTER DATABASE Repositories SET READ_COMMITTED_SNAPSHOT ON</p> </blockquote> <p> </p> <a name='more'></a> <p>4. Allow TCP/IP access to the database:</p> <p><a href="http://lh3.ggpht.com/-ERJdrtCfoaY/T5ETuhtzh1I/AAAAAAAAEK0/iyTBhJ54S50/s1600-h/image%25255B6%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/-kEFwwVhwD_8/T5ETvT4sMbI/AAAAAAAAEK4/m_AZAeuVrJk/image_thumb%25255B2%25255D.png?imgmax=800" width="244" height="111" /></a></p> <p>(Bounce the service if you changed it!)</p> <p>4b. If you have a firewall running check if the ms-sql port is open (1433 for a default instance)</p> <p>5. Create a user (fi: REP_OWN)</p> <p><a href="http://lh5.ggpht.com/-jxTF7kLl790/T5ETwAvPfII/AAAAAAAAELA/aJ62L4_qcrs/s1600-h/image%25255B9%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/-Ye1eGO9p6FY/T5ETwzcaOFI/AAAAAAAAELI/sfHq0tD8l-I/image_thumb%25255B3%25255D.png?imgmax=800" width="244" height="82" /></a></p> <p>6. make  the default database repositories:</p> <p><a href="http://lh6.ggpht.com/-mmxpfp-ZfuE/T5ETx60J_yI/AAAAAAAAELM/R0uD1c1oa0I/s1600-h/image%25255B12%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/-muJfucY0aqE/T5ETyVwhR6I/AAAAAAAAELc/HfHi62Hl3Lk/image_thumb%25255B4%25255D.png?imgmax=800" width="244" height="55" /></a></p> <p>7. Set the public and sysadmin role:</p> <p><a href="http://lh5.ggpht.com/-lBRJdBB7UnI/T5ETzi8htiI/AAAAAAAAELg/DMzWl_Ea9Vo/s1600-h/image%25255B15%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-DcUsmqYIfG0/T5ET0Y0aI3I/AAAAAAAAELs/GGtrH1YYFlk/image_thumb%25255B5%25255D.png?imgmax=800" width="244" height="229" /></a></p> <p>Now we can start with the actual repository:</p> <p>8. Download and unzip de RCU. </p> <p>9. Start the RCU.bat (..\rcuHome\BIN)</p> <p>10. On the database connection details page:</p> <p><a href="http://lh5.ggpht.com/-kq92j4p36SI/T5ET1F53ixI/AAAAAAAAELw/PWbOiix1npY/s1600-h/image%25255B19%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-vXopP1dOGvQ/T5ET2LCjA0I/AAAAAAAAEL4/kq2rPvEfiYs/image_thumb%25255B7%25255D.png?imgmax=800" width="438" height="226" /></a></p> <p>11. Select the BI components:</p> <p><a href="http://lh5.ggpht.com/-3Sy_YB3ptbE/T5ET2ydoqNI/AAAAAAAAEMA/z3kp_RDDIj0/s1600-h/image%25255B22%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-ycmI-Bin6xA/T5ET39x8hhI/AAAAAAAAEMM/Dq1c52B2pZA/image_thumb%25255B8%25255D.png?imgmax=800" width="244" height="119" /></a></p> <p>12. Enter the passwords</p> <p><a href="http://lh3.ggpht.com/-7Eft8odDolA/T5ET5DF9SJI/AAAAAAAAEMQ/89X2ksqyKYs/s1600-h/image%25255B25%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/-GMh2ijgXUvA/T5ET58Em7hI/AAAAAAAAEMY/S_oHBj8VbNo/image_thumb%25255B9%25255D.png?imgmax=800" width="244" height="90" /></a></p> <p>13. Succes:</p> <p><a href="http://lh6.ggpht.com/-OyGNWCgLd44/T5ET6qta2-I/AAAAAAAAEMg/-zoJiSEn4ic/s1600-h/image%25255B28%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/-F172uEOFzQM/T5ET7t5YB2I/AAAAAAAAEMo/HE1qZyxr2zk/image_thumb%25255B10%25255D.png?imgmax=800" width="244" height="116" /></a></p> <p><a href="http://lh3.ggpht.com/-bCS3aHhRBhw/T5ET8ZLQcII/AAAAAAAAEM0/z6GJrQKuF_8/s1600-h/image%25255B31%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-8CfFjimFqx8/T5ET9ZLSjeI/AAAAAAAAEM4/zQxL2gsISfc/image_thumb%25255B11%25255D.png?imgmax=800" width="244" height="233" /></a></p> <p>14. You can disable the REP_OWN account, the RCU has create dedicated logins:</p> <p><a href="http://lh6.ggpht.com/-2ARqFlPOzlU/T5Eo3E_EmVI/AAAAAAAAENU/IShfS5vtAk4/s1600-h/image%25255B2%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-QlAiARuhwKE/T5Eo35Q9CkI/AAAAAAAAENY/bXIXDd2HO7I/image_thumb.png?imgmax=800" width="244" height="180" /></a></p> <p>Till Next Time</p> John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com0tag:blogger.com,1999:blog-7751447442026377325.post-26603455571990553082012-03-20T10:24:00.001+01:002012-03-20T22:58:38.798+01:00See you in Brighton !Want to know if the White Stork really brings the babies? See me and many others speak at the Rittman Mead BI-Forum <a href="http://www.rittmanmead.com/biforum2012">http://www.rittmanmead.com/biforum2012</a><br />
<br />
See you in Brighton!John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com0tag:blogger.com,1999:blog-7751447442026377325.post-36928269423819463662012-02-27T13:13:00.001+01:002012-02-27T13:13:18.523+01:00OBIEE 11.1.1.6 upgrade guideUpgrade guide is found here:<br />
<br />
http://docs.oracle.com/cd/E23943_01/bi.1111/e16452/bi_plan.htm#BABECJJH<br />
<br />
Pretty much a standard weblogic upgrade. <br />
<br />
Till Next TimeJohn Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com0tag:blogger.com,1999:blog-7751447442026377325.post-33830262799966069712012-02-24T09:55:00.002+01:002012-02-24T09:55:45.252+01:00250 Followers !Recently follower number 250 has joined this blog! Thanks everybody for all the great feedback!<br />
<br />
Regards JohnJohn Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com8tag:blogger.com,1999:blog-7751447442026377325.post-80459245798568477802012-02-22T15:22:00.000+01:002012-02-22T15:22:18.397+01:00OBIEE 11.1.1.6 is out!If you have missed it:<br />
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html ==> 11.1.1.6.0 is out<br />
See the nice new features:<br />
http://docs.oracle.com/cd/E23943_01/bi.1111/e10540/whatsnew.htm#CJAEEGJH <br />
<br />
Till Next TimeJohn Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com1tag:blogger.com,1999:blog-7751447442026377325.post-74246230761053230302012-02-20T20:46:00.000+01:002012-02-20T20:46:24.834+01:00OBIEE in hebrewBoris has set up an OBIEE blog in hebrew: http://obiee.co.il/.<br />
Translatesd : http://translate.google.com/translate?sl=iw&tl=en&js=n&prev=_t&hl=en&ie=UTF-8&layout=2&eotf=1&u=http://iloug.org.il/BI/ <br />
<br />
For those of you who also have a non english OBIEE blog feel free to sent me a link and I will gladly advertise it here.<br />
<br />
Till Next TimeJohn Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com0tag:blogger.com,1999:blog-7751447442026377325.post-30669514008176292322012-02-12T21:41:00.001+01:002012-02-12T21:41:58.185+01:00OBIEE11g FireFox 10 problems<p>For those of you having problems with the new FireFox 10 client. Michal Novy posted a solution on <a href="http://www.artofbi.com/index.php/2012/02/firefox-10-not-compatible-with-oracle-bi-11-1-1-5/">Christians</a> Blog:</p> <blockquote> <p>Hi, I found the way how to do a workaround: <br />1. type "about:config" into an address bar <br />2. right click anywhere and choose New / String <br />3. name it "general.useragent.override" <br />4. put the value "Mozilla/5.0 (Windows; Windows NT 6.1; rv:10.0) Gecko/20100101 Firefox/9.0" <br />5. refresh OBIEE login screen <br />Then it works without any problems! </p> </blockquote> <p>Seems that Oracle is already working on some patches: see patch # 13564003 released by Oracle Support which repairs this limitation. </p> <p>Till Next Time</p> John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com5tag:blogger.com,1999:blog-7751447442026377325.post-61285601529806767832012-01-27T08:39:00.001+01:002012-01-27T08:39:04.940+01:00VMWARE connection problems<p>I noticed when connection a vmware to certain networks the network doesn’t like a loopback adapter running on the vmware. Although you will get a valid IP it can’t connect to anything…. </p> <p>Disabling the loopback did the trick.</p> <p>Till Next Time</p> John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com1tag:blogger.com,1999:blog-7751447442026377325.post-23830796235164927052012-01-27T08:37:00.001+01:002012-01-27T08:37:26.246+01:00OBIEE101 I’m still around ;-)<p>Thanks everybody for the interest in my whereabouts. </p> <p>Yep, I'm still around. Just very very busy on a huge OWB migration. </p> <p>Hope to be back soon we some OBIEE stuff.</p> <p>Till Next Time</p> John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com2tag:blogger.com,1999:blog-7751447442026377325.post-14251430177906082832011-12-26T16:18:00.000+01:002011-12-26T16:18:00.764+01:00BIP Quartz tables<p>On a 11g BIP only install you can use the QUARTZ scheduler. The scheduler is fed from the XMLP_SCHED_JOB table from the repository. It will seed either the QRTZ_SIMPLE_TRIGGERS (one off jobs) or QRTZ_CRON_TRIGGERS (repeating jobs). This will feed the QRTZ_TRIGGERS table which controls the next execution time. The actual job is in the QRTZ_JOB_DETAILS table. </p> <p><a href="http://lh6.ggpht.com/-1PwemISPZGY/TvScJhArlKI/AAAAAAAAEIc/HJwRZdJpLtA/s1600-h/image%25255B6%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-5nFqsvBodPk/TvScKDoIR-I/AAAAAAAAEIg/cgNske7n5K8/image_thumb%25255B2%25255D.png?imgmax=800" width="440" height="293" /></a></p> <p>You can inject jobs directly into these tables. Remember that all DateTimes are in QUARTZ_TICKS calculated back to GMT time. A ms-sql conversion function DateTime to Ticks can be foud <a href="https://sites.google.com/site/obiee101files/files/CREATEFUNCTION%5BBIPSC%5D.%5BDt_qt%5D.sql?attredirects=0&d=1">here</a>. From Ticks to DateTime is this <a href="https://sites.google.com/site/obiee101files/files/CREATEFUNCTION%5BBIPSC%5D.%5BQt_dt%5D.sql?attredirects=0&d=1">one</a>.</p> <p>Till Next Time</p> John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com1tag:blogger.com,1999:blog-7751447442026377325.post-1675881259609822422011-12-23T15:51:00.001+01:002011-12-23T15:51:25.332+01:00BIP11g Users and Roles<p>Did some work on a 11g BI publisher only install recently. Opposite to OBIEE11g you can still add users directly into BIP. Be sure to give them the right roles and sync it with your weblogic security realm.</p> <p>Till Next Time</p> John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com1tag:blogger.com,1999:blog-7751447442026377325.post-75409024199824194702011-12-19T20:07:00.000+01:002011-12-19T20:07:00.072+01:00OBIEE11g / BIP Quartz Scheduler<p>Seems that Oracle is using there own standard for the Date Time format in the BIP quartz scheduler. They are not using standard ticks (starting on 1-jan-0001) but a milliseconds count starting on 1-jan-1970. So 1-Jan-2012 = 1325376000000. IE: a whole day is 86400000 ticks.</p> <p>Till Next Time</p> John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com1tag:blogger.com,1999:blog-7751447442026377325.post-9722092974806343232011-12-16T20:05:00.000+01:002011-12-16T20:05:00.636+01:00OBIEE10g Auto Suggest Prompt<p>A client asked me if I could create an auto suggest prompt for him. (ie: Google Style Prompt). Basically he wanted an edit box prompt which would fill an suggestion box which he could tab trough to make the right selection.</p> <p>Since this isn’t a standard 10g functionality I wrote some JavaScript to make it happen. But I didn’t reinvent the wheel <img style="border-bottom-style: none; border-left-style: none; border-top-style: none; border-right-style: none" class="wlEmoticon wlEmoticon-winkingsmile" alt="Knipogende emoticon" src="http://lh3.ggpht.com/-Z5Olyy0fao4/Tuc_o_uwHpI/AAAAAAAAEHg/VU-O18qQ0uw/wlEmoticon-winkingsmile%25255B2%25255D.png?imgmax=800" /> ! The people at <a href="http://jqueryui.com/">jQuery</a> already did the bases, I simple adapted it for usage in OBIEE 10g.</p> <p>1. Download the jQuery UI package <a href="http://jqueryui.com/download">here</a>. Install it in your b_mozilla directory’s (or other webserver dirs you use).</p> <p>2. Download the jQuerySetup from <a href="https://sites.google.com/site/obiee101files/files/ObieeJQuerySetup.txt?attredirects=0&d=1">here</a>.</p> <p>3. Add the setup script to a textbox on your dashboard page:</p> <p><a href="http://lh5.ggpht.com/-04EJLCbKCW0/Tuc_pejYELI/AAAAAAAAEHk/DSNN6kyPCnA/s1600-h/image%25255B2%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-urKB4DV0hjg/Tuc_qIbJzBI/AAAAAAAAEHs/py7p07BsQzM/image_thumb.png?imgmax=800" width="244" height="74" /></a></p> <p>Alter files locations if needed, don’t forget the Contains HTML Markup checkbox.</p> <p>4. Add a dropdown prompt to your dashboard page.</p> <p><a href="http://lh6.ggpht.com/-u7__-fMeCSU/Tuc_qj_Ic1I/AAAAAAAAEH0/Vsrxvt2e4ls/s1600-h/image%25255B5%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-UI-IEihIazU/Tuc_rmQX6fI/AAAAAAAAEH8/gfowSElN0Cw/image_thumb%25255B1%25255D.png?imgmax=800" width="244" height="33" /></a></p> <p>5. Create a javascript file in your b_mozilla directory’s called: autocomplete.js</p> <blockquote> <p>function SetAutoComplete(PromptColumn){ <br />    var domNode = document; <br />    var tagName = '*'; <br />    var tags = domNode.getElementsByTagName(tagName); <br />    var y ="";            <br />    for(i=0; i<tags.length; i++){ <br />    <br />    if (tags[i].className  == 'GFPFilter') { <br />        if (tags[i].getAttribute('gfpbuilder').indexOf(PromptColumn) != -1) <br />        {    <br />            y = tags[i].getAttribute('sid')            <br />        };</p> <p>        $( <br />        function() <br />        { <br />                $( "#"+y ).combobox();            <br />        }); <br />        };    <br />    }; <br />};</p> </blockquote> <p>6. <strong>After</strong> the dropdown prompt add a textbox with:</p> <blockquote> <p><script src="res/b_mozilla/autocomplete.js" language="javascript"> </script> <br /><script language="javascript">  <br />    SetAutoComplete('C1  Cust Name'); <br /></script></p> </blockquote> <p>7. Add your report and run the dashboard:</p> <p><a href="http://lh5.ggpht.com/-oc1BLQ4lj4s/Tuc_sFuN2wI/AAAAAAAAEIE/eP9d4Q8E0ns/s1600-h/image%25255B8%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-1_rIw-QBLgY/Tuc_sy9yPmI/AAAAAAAAEIM/NHoPsdulw5I/image_thumb%25255B2%25255D.png?imgmax=800" width="244" height="166" /></a></p> <p>Till Next Time</p> John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com11tag:blogger.com,1999:blog-7751447442026377325.post-65479787087103922132011-12-13T12:47:00.001+01:002011-12-13T12:47:54.723+01:00OBIEE10g AutoRunPrompt<p>A client asked me if I could create an auto run prompt for him. Basically he wanted an edit box prompt which would updated his report after each character has been typed. Since this isn’t a standard 10g functionality I wrote some JavaScript to make it happen. It uses the onkeyup event to fire the GFPDoFilters filter event.</p> <p>The script can be downloaded here: <a href="https://sites.google.com/site/obiee101files/files/COBIEEJS.js?attredirects=0&d=1">download COBIEEJS</a>.</p> <p>Copy the file to your b_mozilla directory’s (or other webserver dirs you use)</p> <p>How to use it?</p> <p>1. Add an edit box style prompt to your dashboard:</p> <p><a href="http://lh6.ggpht.com/---U_mBQab2M/Tuc7U-jvNFI/AAAAAAAAEGg/ACvc3pSC9YI/s1600-h/image%25255B3%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-h_5JMXi1OZY/Tuc7VTLRBHI/AAAAAAAAEGk/MCgYPL72ORk/image_thumb%25255B1%25255D.png?imgmax=800" width="342" height="45" /></a></p> <p>2. Add a textbox with:</p> <blockquote> <p><script src="res/b_mozilla/cobieejs.js" language="javascript"> </script> <br /><script language="javascript">  <br />  AutoRunPrompt('C1  Cust Name'); <br /></script></p> </blockquote> <p><a href="http://lh6.ggpht.com/-2lsIvLhu_mM/Tuc7WRPt9rI/AAAAAAAAEGs/fHRnWtjxdp4/s1600-h/image%25255B6%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-TVPbqztvrOA/Tuc7XGb1obI/AAAAAAAAEG4/uwwgERnPJqE/image_thumb%25255B2%25255D.png?imgmax=800" width="244" height="77" /></a></p> <p>don’t forget the Contains HTML Markup checkbox</p> <p>3. Add your prompted report:</p> <p><a href="http://lh3.ggpht.com/-7UGKWcjWOjY/Tuc7XwgsupI/AAAAAAAAEG8/vVHDFOuSoIA/s1600-h/image%25255B9%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/-bpl43RS6Fn0/Tuc7Y0GYKxI/AAAAAAAAEHE/v7M3sh5tios/image_thumb%25255B3%25255D.png?imgmax=800" width="244" height="38" /></a></p> <p>Run the dashboard:</p> <p><a href="http://lh5.ggpht.com/-s6uONhBZIfE/Tuc7ZHtJEGI/AAAAAAAAEHQ/ZqA3XEygI9Q/s1600-h/image%25255B12%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-TB2Rx3LC9Zw/Tuc7Z_ZyQ4I/AAAAAAAAEHY/Y2ENUJmgULA/image_thumb%25255B4%25255D.png?imgmax=800" width="243" height="244" /></a></p> <p>Till Next Time</p> John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com0tag:blogger.com,1999:blog-7751447442026377325.post-40601270496393771802011-10-24T20:00:00.000+02:002011-10-24T20:00:01.915+02:00OBIEE11g SampleApp OID doesn’t start<p>Yep, I did again :-(. </p> <p>After playing around with the new sampleapp107 I managed to crash the VM. After a reboot the OID refused to start up. It seemed that because there was still an active status record in the ODS schema, the OPMN couldn’t find anything to start.</p> <p>Solution: truncate the "ODS"."ODS_PROCESS_STATUS" and  "ODS"."ODS_GUARDIAN" tables in your database repository. </p> <p>(Not sure if the "ODS"."ODS_GUARDIAN"  is really necessary…. Please correct me if I’m wrong)</p> <p>Till Next Time</p> John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com1tag:blogger.com,1999:blog-7751447442026377325.post-38499838158491680692011-10-21T20:00:00.000+02:002011-10-21T20:00:00.716+02:00OBIEE11g Aggregate At<p>One of the new feature of 11g is the AGGREGATE AT function. It uses the <strong><u>hierarchical level</u></strong> to pin the the aggregate. Problem is you can’t select a hierarchy level in the formula editor, so you have to some old school typing:</p> <p><a href="http://lh3.ggpht.com/-N-ca0HznAco/To1gHgsTfgI/AAAAAAAAEEA/oz_rNazm9TA/s1600-h/image%25255B3%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-ZD5T_Hx5XeU/To1gIMfEQcI/AAAAAAAAEEE/UOGwUxxrzcg/image_thumb%25255B1%25255D.png?imgmax=800" width="453" height="88" /></a> </p> <p>Example:</p> <p><a href="http://lh5.ggpht.com/-j909z8HgQfw/To1gIWimZeI/AAAAAAAAEEI/aQ5kN96zd50/s1600-h/image%25255B11%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-d1LTHjBv8rs/To1gIyb9-XI/AAAAAAAAEEM/w0x9etChaVg/image_thumb%25255B5%25255D.png?imgmax=800" width="440" height="135" /></a></p> <p>Only month 1 to 6 are selected.</p> <p>Just like the BY statement you can do multiple levels from <strong><u>different</u></strong> Hierarchies:</p> <p><a href="http://lh4.ggpht.com/-F3xgW8K2vmo/To1gJUXVqZI/AAAAAAAAEEQ/bwdPFFNkbEA/s1600-h/image%25255B7%25255D.png"><img style="background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/-xgD1efvFIfU/To1gJ9mv9NI/AAAAAAAAEEU/Yn5xeypQwCs/image_thumb%25255B3%25255D.png?imgmax=800" width="449" height="82" /></a></p> <p>Till Next Time </p> John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com1tag:blogger.com,1999:blog-7751447442026377325.post-83812988381426600462011-10-18T20:10:00.000+02:002011-10-21T13:52:22.669+02:00OBIEE11g Golden Rules: Catalog Management<p>First of al the original inspiration for these “Golden Rules” Series are based on the “<a href="http://www.peakindicators.com/index.php/knowledge-base/96-20-golden-rules-for-the-obiee-11g-rpd">20 GOLDEN RULES FOR REPOSITORY DESIGN</a>” from the people at Peak Indicators. Kudos to them.</p> <p>The series contains:</p> <ul> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-rpd-physical.html">RPD-Physical Layer</a> </li> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-rpd-business.html">RPD-Business Model Layer</a> </li> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-rpd-presentation.html">RPD-Presentation Layer</a></li> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-report-building.html">Report Building</a></li> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-dashboard.html">Dashboard Building</a> </li> <li>Catalog Management </li> </ul> <p>The “rules” is this article are somewhat in random order</p> <p>This is always a “work in progress” and please feel free to make any suggestions!</p> <h5>Catalog management</h5> <p>- use a transport folder.</p> <p><a href="http://lh4.ggpht.com/-Cmzu8__XG5A/TpK4nNgRuZI/AAAAAAAAEEY/hkS1nJZnrTA/s1600-h/image%25255B3%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/-WRV5tfQ1SCY/TpK4nk-79BI/AAAAAAAAEEc/5N3_ToGLMic/image_thumb%25255B1%25255D.png?imgmax=800" width="472" height="62" /></a>Don’t allow all developers to place everything in all shared folders. Have them place it first in “transport” folder. Assign a “librarian” for the shared folder who will check everything and place it in the correct shared folder.</p> <p>- Add Metadata to the folders:</p> <p><a href="http://lh6.ggpht.com/-Hv7kmUIVIW8/TpK4n98cf4I/AAAAAAAAEEg/fAO6W07KXBA/s1600-h/image%25255B6%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-rEYf-acQncI/TpK4oXImTsI/AAAAAAAAEEk/sp12GAC-Z24/image_thumb%25255B2%25255D.png?imgmax=800" width="244" height="106" /></a></p> <p>This makes them better searchable.</p> <p>- Add structure to the portal:</p> <p>There are a number of different ways that a portal could be structure to improve efficiency to business users. For instance:</p> <ul> <li>Reports could be stored by subject area, such as 'finance', 'sales', 'supply chain' </li> <li>Reports could be stored in a 'daily', 'weekly', 'monthly' directory structure depending on how often they have been designed to be refreshed. </li> <li>Reports could be stored by perspective: <ul> <li><strong>Financial</strong> — Groups objectives, initiatives, and KPIs that relate to or support the monetary or economic health and development of your organization. </li> <li><strong>Customer</strong> — Groups objectives, initiatives, and KPIs that pertain to or support your client base. </li> <li><strong>Internal Process</strong> — Groups objectives, initiatives, and KPIs that categorize and support your corporate internal policies and procedures. </li> <li><strong>Learning and Growth</strong> — Groups objectives, initiatives, and KPIs that relate to or support employee training and advancement. </li> </ul> </li> <li>A combination of the above. </li> </ul> <p>Till Next Time</p> John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com0tag:blogger.com,1999:blog-7751447442026377325.post-31476718782812808232011-10-15T09:07:00.000+02:002011-10-21T13:49:17.366+02:00OBIEE11g Golden Rules: Dashboard Building<p>First of al the original inspiration for these “Golden Rules” Series are based on the “<a href="http://www.peakindicators.com/index.php/knowledge-base/96-20-golden-rules-for-the-obiee-11g-rpd">20 GOLDEN RULES FOR REPOSITORY DESIGN</a>” from the people at Peak Indicators. Kudos to them. I just added my own observations.</p> <p>The series contains:</p> <ul> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-rpd-physical.html">RPD-Physical Layer</a> </li> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-rpd-business.html">RPD-Business Model Layer</a></li> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-rpd-presentation.html">RPD-Presentation Layer</a> </li> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-report-building.html">Report Building</a> </li> <li>Dashboard Building </li> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-catalog.html">Catalog management</a></li> </ul> <p>The “rules” is this article are somewhat in random order</p> <p>This is really a work in progress, will be updated soon! (Bit pressed for Time <img style="border-bottom-style: none; border-left-style: none; border-top-style: none; border-right-style: none" class="wlEmoticon wlEmoticon-winkingsmile" alt="Knipogende emoticon" src="http://lh5.ggpht.com/-48UYP7xqK_U/TqFb9T7uNnI/AAAAAAAAEE4/x1IH3dqFakQ/wlEmoticon-winkingsmile%25255B2%25255D.png?imgmax=800" />  )</p> <p>Dashboard Design</p> <p><strong>- Don’t crowd the dashboard</strong></p> <p>Divide your report over several pages! Check why a user really needs 25 pages…..</p> <p><strong>- Avoid scrolling</strong></p> <p>Remember that your developers screen is often bigger then the user screen</p> <p><strong>- Check for screen size</strong></p> <p>If the user has only a 1024 * 768, then make your own resolution the same!</p> <p>- Check for mobile</p> <p>- Animation</p> <p>- Colours</p> <p>Before you start using non standard colours have a look a some colour theory: <a title="http://en.wikipedia.org/wiki/Color" href="http://en.wikipedia.org/wiki/Color">http://en.wikipedia.org/wiki/Color</a>, not every colour combination does well…..</p> <p>This is always a “work in progress” and please feel free to make any suggestions!</p> <p>Till Next Time!</p> John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com5tag:blogger.com,1999:blog-7751447442026377325.post-24604372369131876452011-10-12T20:21:00.000+02:002011-10-21T13:55:20.763+02:00OBIEE11g Golden Rules: Report Building<p>First of al the original inspiration for these “Golden Rules” Series are based on the “<a href="http://www.peakindicators.com/index.php/knowledge-base/96-20-golden-rules-for-the-obiee-11g-rpd">20 GOLDEN RULES FOR REPOSITORY DESIGN</a>” from the people at Peak Indicators. Kudos to them.</p> <p>The series contains:</p> <ul> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-rpd-physical.html">RPD-Physical Layer</a> </li> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-rpd-business.html">RPD-Business Model Layer</a> </li> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-rpd-presentation.html">RPD-Presentation Layer</a> </li> <li>Report Building </li> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-dashboard.html">Dashboard Building</a> </li> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-catalog.html">Catalog Management</a> </li> </ul> <p>The “rules” is this article are somewhat in random order.</p> <p>- <strong>First column: TIME/CALENDAR</strong></p> <p>The first column you select for your report should always a column from your time or calendar dimension. Time is often the most consistent aggregation splitter. And most database use partitioning along a time-line.</p> <p><a href="http://lh5.ggpht.com/-F95gQ4pfY5U/To1Sginl_FI/AAAAAAAAEDY/I_VXL8zICdw/s1600-h/image2.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/-VtUz1KqyFbA/To1ShIJ5lbI/AAAAAAAAEDc/d0M7ppB9FjA/image_thumb.png?imgmax=800" width="233" height="128" /></a></p> <p><strong>- Dimension Order:</strong></p> <p>Try to maintain the same order of the dimension across all reports build on a single presentation layer. That way the use of aggregate tables and or query rewrite can be optimally provisioned.</p> <p><strong>- Move Complex Logic to the rpd:</strong></p> <p>If you have made a nice “fancy” formula which you probably need to use in a couple of reports, consider moving it to the rpd. That way you only have to maintain it in one place.</p> <p><strong>- Less is more 1!</strong></p> <p>If the user is only interested in the “bad” records, then only show hem/her the “bad” records. To make the user scroll trough hundreds of records looking for the ones you flagged with conditional formatting isn’t very efficient. </p> <p><a href="http://lh4.ggpht.com/-5OP6ZWI6MSg/To1Shhrkm1I/AAAAAAAAEDg/txpRw2nkpPw/s1600-h/image%25255B7%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-yhs8DiNOFdc/To1SiLJ7OJI/AAAAAAAAEDk/5mooBbEa9fE/image_thumb%25255B3%25255D.png?imgmax=800" width="216" height="178" /></a><a href="http://lh5.ggpht.com/-Ov3htxpWA7E/To1Siu6lrTI/AAAAAAAAEDo/Je7teCQtkzQ/s1600-h/image%25255B8%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/-S8tf4bR8ueE/To1SjN1GVxI/AAAAAAAAEDs/_xhD6QnBXKM/image_thumb%25255B4%25255D.png?imgmax=800" width="206" height="178" /></a></p> <p><strong>- Less is more 2!</strong></p> <p>If a report generates more then a hundred records, changes are big that the user is going to do “download to excel”. Check with the user if he needs the report in this form. Consider using different deliver methods (agents / Bip).</p> <p><strong>- Less is more 3!</strong></p> <p>If on opening the report the user already has to scroll or navigate to other pages try opening the report on a “higher”  level.</p> <p><strong>- Avoid multidimensionality on graphs:</strong></p> <p>If the human eye and brain need to pick up more then 1 dimension on graph it’s easily fooled.</p> <p><a href="http://lh4.ggpht.com/-Ax4Ny54aDqs/To1SjRjFzAI/AAAAAAAAEDw/5WMCux1F0M8/s1600-h/image%25255B11%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/-YycW1FjzyJo/To1Sjx_SOsI/AAAAAAAAED0/Lk1VwO_CibE/image_thumb%25255B5%25255D.png?imgmax=800" width="244" height="114" /></a></p> <p><strong>- Check graph for “lost” data</strong></p> <p><a href="http://lh4.ggpht.com/-OFJNwq1-Hxc/To1SkYbR1LI/AAAAAAAAED4/CZk1iCHVQt0/s1600-h/image%25255B15%25255D.png"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-5yrKNU2kV3U/To1Skr7ZBvI/AAAAAAAAED8/VLTnJ2A72b4/image_thumb%25255B7%25255D.png?imgmax=800" width="463" height="138" /></a></p> <p>2011 Paid amount is not visible…..</p> <p><strong>- Make sure the description is always entered:</strong></p> <p>A good description must be readable for a “<a href="http://en.wikipedia.org/wiki/Newbie">noob</a>”.See: <a title="http://obiee101.blogspot.com/2011/09/obiee-mandatory-description-field.html" href="http://obiee101.blogspot.com/2011/09/obiee-mandatory-description-field.html">http://obiee101.blogspot.com/2011/09/obiee-mandatory-description-field.html</a></p> <p><strong>- Give the report a sell by date!</strong></p> <p>Go back to the user every 6 to 9 months to see if the report still is required in it’s current version.</p> <p>This is always a “work in progress” and please feel free to make any suggestions!</p> <p>Till Next Time</p> John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com3tag:blogger.com,1999:blog-7751447442026377325.post-62894922643074926502011-10-09T20:00:00.000+02:002011-10-09T20:29:31.415+02:00OBIEE11g Golden Rules: RPD-Presentation Layer<p>First of al the original inspiration for these “Golden Rules” Series are based on the “<a href="http://www.peakindicators.com/index.php/knowledge-base/96-20-golden-rules-for-the-obiee-11g-rpd">20 GOLDEN RULES FOR REPOSITORY DESIGN</a>” from the people at Peak Indicators. Kudos to them.</p> <p>The series contains:</p> <ul> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-rpd-physical.html">RPD-Physical Layer</a> </li> <li><a href="http://obiee101.blogspot.com/2011/10/obiee11g-golden-rules-rpd-business.html">RPD-Business Model Layer</a> </li> <li>RPD-Presentation Layer </li> <li>Report Building </li> <li>Dashboard Building </li> </ul> <p>The “rules” is this article are somewhat in random order</p> <p>This is always a “work in progress” and please feel free to make any suggestions!</p> <h3>Presentation Layer </h3> - Common dimension <br /> <p>When you have multiple Subject Areas, list the common dimensions in the same order  across all the Subject Areas </p> <p><a href="http://lh4.ggpht.com/-ViZlPEurY3A/To1Hf-SH3xI/AAAAAAAAECo/EoHoVVBeq_Y/s1600-h/image%25255B2%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh3.ggpht.com/-sQx3NERB-rQ/To1HgWMkIhI/AAAAAAAAECs/bjad2epljpk/image_thumb.png?imgmax=800" width="153" height="58" /></a><a href="http://lh6.ggpht.com/-QpfnXD7zPqE/To1Hg8GBYlI/AAAAAAAAECw/Pe1wP5UnNDQ/s1600-h/image%25255B5%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh4.ggpht.com/-Nz1uEYtfvHY/To1HhKwuUwI/AAAAAAAAEC0/Dt-0Yq3BNyY/image_thumb%25255B1%25255D.png?imgmax=800" width="164" height="65" /></a></p> <p>- Time dimension first:</p> <p>Since the time/calendar dimension is often the main aggregator make it the first in your presentation layer list. </p> <p>- No prefixes:</p> <p>Presentation Table names within each Subject Area must not begin with “Dim – “ or “Fact –“ or “Fact Compound –“. So remove these prefixes if they are present after creating the Subject Area by dragging Logical Tables directly from the Business Model.</p> <p>- Identify your facts:</p> <p>The Presentation Table containing your facts should be listed right at the bottom, and the Presentation Table name should contain words like “Measures” or “Facts”</p> <p><a href="http://lh3.ggpht.com/-0a5RYPPtngA/To1HhqYjgeI/AAAAAAAAEC4/y8yOrTzkPpQ/s1600-h/image%25255B8%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-acHQS9LBHYY/To1Hh_V5gBI/AAAAAAAAEC8/K8ig2R5w_7k/image_thumb%25255B2%25255D.png?imgmax=800" width="187" height="90" /></a></p> <p>- Ensure logical relationship:</p> <p>There should be absolutely no possibility whatsoever of a user selecting objects from a Subject Area that have no logical relationship. So, if there are any objects within the same Subject Area that cannot co-exist in the same report, then your Subject Area design is incorrect!</p> <p>- Split over multiple subject area:</p> <p>Within OBIEE11g report can be build using multiple presentation layers based on the same business layer:</p> <p><a href="http://lh5.ggpht.com/-YAypXtr0Ti0/To1HiR9CUGI/AAAAAAAAEDA/ZGe71kt-CeM/s1600-h/image%25255B11%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh5.ggpht.com/-uB85QjerAx4/To1Hiv81j5I/AAAAAAAAEDE/cnOMYBa_NwY/image_thumb%25255B3%25255D.png?imgmax=800" width="244" height="145" /></a> Consider splitting your presentation layer in “sub” areas.</p> <p>- Dimension Column Order:</p> <p>Try to have the column in the same order as your hierarchy: Year > Quarter > Month > Week > Date or Business Line > Brand > Product </p> <p>- Special characters:</p> <p>Special HTML characters {< > / } should be avoided in the object names. Not ever browser can render them correctly.</p> <p>- Metadata dictionary</p> <p>Have a well maintained metadata dictionary in place:</p> <p><a href="http://lh4.ggpht.com/-OPdOyKs2sso/To1HjGnWy6I/AAAAAAAAEDI/8QcuKERscHE/s1600-h/image%25255B14%25255D.png"><img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="image" border="0" alt="image" src="http://lh6.ggpht.com/-mAQYONCgYq0/To1HjtvGxhI/AAAAAAAAEDM/aZ3Szz6i0Rk/image_thumb%25255B4%25255D.png?imgmax=800" width="79" height="67" /></a></p> <p>Remember in OBIEE11G you have to redeploy the metadata dictionary after each RPD deployment</p> <p>Till Next Time</p> John Minkjanhttp://www.blogger.com/profile/08228393663535024706noreply@blogger.com2