tag:blogger.com,1999:blog-44373464820044390162024-03-19T04:51:25.084-07:00BI Concepts and OBIEERene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-4437346482004439016.post-35293978052037442302014-05-13T14:27:00.001-07:002014-05-13T14:27:50.573-07:00Progress on TRCWorking late...
Today we finished the installation of Translational Research Center 3.0.1 in The Netherlands. Wow. It's a huge patchset.
Why didn't Oracle call it 3.1 ;-)
But, what's fixed now is, amongst other things, the VPD configuration. Now only the data is shown to the right users if they have the correct authorisation.
Also, the loader for Complete Genomics NGS data works.
Another big leap forward: because of a reference visit tomorrow we loaded the Glioblastoma dataset from The Cancer Genome Atlas. For these patients, also DNA Sequence variants, RNA expression data as well as Copy Number Variation data is loaded. What a great analyses can be done now !
Currently, we're working on some custom BI dashboards for deeper Cohort analyses... Looks promising !Rene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.com0tag:blogger.com,1999:blog-4437346482004439016.post-20711069610547683852013-12-10T02:12:00.000-08:002013-12-10T02:14:35.415-08:00It's been a while...It's been a bit quiet lately. Not because of lack of interest, on the contrary. I've been very busy.
From a BI perspective, lots of things have changed. I focused more on the back-end side of things (database, ODI etc) and also had some time with other vendor's tools. Let's leave it at that... :-)
But first and foremost: I've been playing around with Oracle TRC. Translational Research Center. It's a platform based on Oracle Software (Database, Weblogic, ODI and OBI) that supports researchers and doctors in diagnosing patients. It offers the possibility of combining clinical data with genomic data. Which is of course very useful and necessary when you want to aim for personalized treatments. There is nothing more personal than an individual's DNA.
Version 3.0 is out, so I'm figuring out what has changed. In the coming weeks, I'll be installing and configuring TRC at a customer's site and post progress here !
Regards,
RenéRene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.com0tag:blogger.com,1999:blog-4437346482004439016.post-1811908861036105222012-05-16T13:27:00.000-07:002012-05-16T13:27:18.922-07:00Rittman Mead BI Forum Atlanta, GAToday is my first day at the Rittman Mead BI Forum in Atlanta, GA. <br>
My 'Ignite-style' presentation on Groups, Roles and Issues went pretty well. I think... :-) <br>
Great sessions, great insight from Oracle Corp and listening to Stewart Bryson (@stewartbryson) is always a good thing to do !Rene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.com0tag:blogger.com,1999:blog-4437346482004439016.post-48918944702502183982012-03-09T12:52:00.000-08:002012-03-09T12:53:02.124-08:00Rittman Mead BI Forum 2012This years BI forum (#biforum) is open for registration!<br>
<br>
All information on topics, speakers and locations can be found here:<br>
http://www.rittmanmead.com/biforum2012/<br>
<br>
Direct registration links for Brighton and Atlanta respectively are here:<br>
<a href="http://www.regonline.co.uk/rittmanmeadbiforumbrighton2012uk">Booking form for UK BI Forum Event (Brighton, May 8th – 11th 2012)</a><br>
<a href="http://www.regonline.com/rittmanmeadbiforumbrighton2012us">Booking form for US BI Forum Event (Atlanta GA, May 15th – 18th 2012)</a><br>
<br>
My session abount Groups, Roles and Issues is scheduled for the Atlanta edition of the BI Forum 2012Rene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.com0tag:blogger.com,1999:blog-4437346482004439016.post-43515043412506895442012-02-27T11:23:00.000-08:002012-02-27T11:23:36.685-08:00Adding new columns to existing viewsIn OBI 11.1.1.6, columns that are added afterwards to an analysis with existing (table-)views are automatically added to these views. </br>
This is the default behavior, where in 11.1.1.5, existing views needed to be edited to include the new columns. </br>
</br>
This can be changed under the Analysis Properties button:
</br>
</br>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZwFmGQwIJkgZwF2cfNieWuyvHHOIO78Ep4vjlhJm6u8v91AheRH4qq8TvuMPFH_I7yXtuNYePX90HTm0WFHo5h6j_pZpbMpjIiMqZJ6jcQuISn-slZQGl26Z2TGUZmDbr7TCEFdPrS2g/s1600/Analysis+properties+add+new+columns+button.bmp" imageanchor="1" style="margin-left:1em; margin-right:1em"><img border="0" height="189" width="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZwFmGQwIJkgZwF2cfNieWuyvHHOIO78Ep4vjlhJm6u8v91AheRH4qq8TvuMPFH_I7yXtuNYePX90HTm0WFHo5h6j_pZpbMpjIiMqZJ6jcQuISn-slZQGl26Z2TGUZmDbr7TCEFdPrS2g/s400/Analysis+properties+add+new+columns+button.bmp" /></a></div>
</br>
Navigate to the Data tab and toggle between the top two options:</br>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhuzmuAuJwJat_Rhf7EduBNgIDoyT6q80uuja8Jj0gOjrAk-04oeDJh5-EFuLAiDoyIx1-anQwQV6EUuelKceJPk63_dWlVyiE3TXWXVRfbU5YYOaoU9IVpbPEQPQ3sCYZtKf1TmDEU_FM/s1600/Analysis+properties+add+new+columns.bmp" imageanchor="1" style="margin-left:1em; margin-right:1em"><img border="0" height="216" width="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhuzmuAuJwJat_Rhf7EduBNgIDoyT6q80uuja8Jj0gOjrAk-04oeDJh5-EFuLAiDoyIx1-anQwQV6EUuelKceJPk63_dWlVyiE3TXWXVRfbU5YYOaoU9IVpbPEQPQ3sCYZtKf1TmDEU_FM/s400/Analysis+properties+add+new+columns.bmp" /></a></div>
</br>
The first option is the default: new columns are automatically added to existing views.</br>
The second option is the options as we know from the 11.1.1.5 release.</br></br>
Kind regards!</br>
RenéRene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.com0tag:blogger.com,1999:blog-4437346482004439016.post-26730484978880471092012-02-24T07:53:00.001-08:002012-02-24T07:54:54.312-08:00Renaming Views in OBIEE 11.1.1.6Up until version 11.1.1.6, it was not possible to provide custom names for views.<br>
Now we can ! :<br>
Press the red-bracketed button and rename the view !<br>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVduX0iiz6AMh4Qze1IY_4J5UXDvl954VeOcianCVWDYYqQBP84WDpRHhaPmnE1GaEqIhX-R6RVzBihjGQGA_SxsPhZObknw7IyaFz50VQpKg_yvoaAGakRwio5aZU4nf2eo0L8b0MIwg/s1600/rename+view+button.bmp" imageanchor="1" style="margin-left:1em; margin-right:1em"><img border="0" height="199" width="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVduX0iiz6AMh4Qze1IY_4J5UXDvl954VeOcianCVWDYYqQBP84WDpRHhaPmnE1GaEqIhX-R6RVzBihjGQGA_SxsPhZObknw7IyaFz50VQpKg_yvoaAGakRwio5aZU4nf2eo0L8b0MIwg/s400/rename+view+button.bmp" /></a></div>Rene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.com0tag:blogger.com,1999:blog-4437346482004439016.post-66242672138685591282012-02-24T07:25:00.000-08:002012-02-24T07:36:53.927-08:00First attempt installing OBIEE 11.1.1.6Oracle released the 11.1.1.6 version of Oracle Business Intelligence Suite just this week.
Although on a skiing holiday, I could not resist the urge to download it and install it.
The Repository Creation Untility is still there. Please be sure to use the 11.1.1.6 version of the RCU as well !
After kicking off the installer and choosing the Simple Install option, everything is done for you. It's smooth as silk.
Unfortunately, the Internal Server Error page is still shown right after the initial startup. But F5-ing after a while shows the well-known login screen.
Curious as I am, I wanted to check out the Sample Application. But unfortunately, I ended up with this error message:
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLFBN6Zx2FZ45_b6Af7hv44TrFc_xqNWSbjzjnN3p3s8ipqsdi__CgoA8-7z5WWVEMZ0iMWxL6aX60xcuQccyEL_s_AGOu3lMLz3OqB2k4xUTuOGW1o-Qj4tFxb1sD4aJ2Lyf4hnPUiY8/s1600/JSON+error.bmp" imageanchor="1" style="clear:left; float:left;margin-right:1em; margin-bottom:1em"><img border="0" height="171" width="230" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLFBN6Zx2FZ45_b6Af7hv44TrFc_xqNWSbjzjnN3p3s8ipqsdi__CgoA8-7z5WWVEMZ0iMWxL6aX60xcuQccyEL_s_AGOu3lMLz3OqB2k4xUTuOGW1o-Qj4tFxb1sD4aJ2Lyf4hnPUiY8/s320/JSON+error.bmp" /></a></div>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
It has probably nothing to do with OBIEE: I'm looking into my browsersettings...
<br>
René<br>
<br>
<br>
<b>Update:</b> <br>
Clearing my browsersettings solved the issue !Rene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.com0tag:blogger.com,1999:blog-4437346482004439016.post-41211708259874339182011-12-01T04:55:00.000-08:002011-12-12T22:38:00.827-08:00Update on strange security behaviour<b>An update, as promised...</b><br><br>Over and over again, this issue is reproducable.<br>So get rid of underscores and numbers in Application Roles' names and your life will be much more pleasant !<br>Thanks to everyone in my team (@bifacts, @bvdh80, Cindy and Marcel) for your valuable input in resolving this issue !<br><br>
<b>Dear followers,</b> <br><br>Things seem to go pretty well now.<br><br><br>It looks as if the underscores and numbers in the Application Roles' names cause these kinds of problems.<br>After having removed the numbers and underscores from the roles' names the error hasn't occurred anymore.<br>It's a pity that the documentation does not mention this restriction or naming convention.<br><br>Still testing though... I'll keep you informed.<br>RenéRene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.com0tag:blogger.com,1999:blog-4437346482004439016.post-91397581543812861212011-11-30T05:12:00.001-08:002011-12-01T05:49:20.424-08:00strange security behaviour<b>Dear community,</b><br><br>
I'm writing this because I am facing a serious issue in OBI 11g (11.1.1.5) and I can't seem to pinpoint the exact problem.
I hope you can share your thoughts with me in order to come up with a solution.
The situation is as follows:
There seems to be a mismatch between the Application Roles assigned to a user and the way they are translated onto the ACL's in the webcatalog.
I use Weblogic's default Authenticator. Users sit in a group and for every group, there is a corresponding Application Role. <br>
For instance:
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggOrjr7ZugqN_h9dvCJoj_vT9T7MCL2uiwXnQSCeRvA0bJIO8tzEoQNsXObAsjU2ZqNdAQZ1SERmS3xnF8bdeqbBr7g8tUuFUgu12maQAgZtcqCpnc0y4ZXhstp8Sqg4n5MX1z-vTb-PA/s1600/screen1.bmp" imageanchor="1" style="clear:left; float:left;margin-right:1em; margin-bottom:1em"><img border="0" height="314" width="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggOrjr7ZugqN_h9dvCJoj_vT9T7MCL2uiwXnQSCeRvA0bJIO8tzEoQNsXObAsjU2ZqNdAQZ1SERmS3xnF8bdeqbBr7g8tUuFUgu12maQAgZtcqCpnc0y4ZXhstp8Sqg4n5MX1z-vTb-PA/s320/screen1.bmp" /></a></div>
There are also A_P020 group and role and a A_P030 group and role. The Group-to-Role mapping is always 1:1.
<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMKzJ-zDEe4pkW3elcNhYCUKyCXN5HQoxLTJQjD8Ynobr6tbMPfwiKnQybOmamNV8Z328BrDc2iqkxhjiRzg_AHOVRJjvIx9kvcxyFbBzVOY8SQvZGghdWZ9r0l9VutbvVx8qBx2Znvxc/s1600/screen2.bmp" imageanchor="1" style="clear:left; float:left;margin-right:0em; margin-bottom:1em"><img border="0" height="163" width="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMKzJ-zDEe4pkW3elcNhYCUKyCXN5HQoxLTJQjD8Ynobr6tbMPfwiKnQybOmamNV8Z328BrDc2iqkxhjiRzg_AHOVRJjvIx9kvcxyFbBzVOY8SQvZGghdWZ9r0l9VutbvVx8qBx2Znvxc/s320/screen2.bmp" /></a></div>
In the catalog, access to objects is configured using Application Roles. <br>
For instance: access to the P010 Dashboard is limited to users who are member of the A_P010 group (and as a consequence have the A_P010 application role assigned).<br><br>
Now, what happens is this: a user who is assigned the A_P010 group and the A_P020 group sees the P010 and P020 Dashboards.<br>
When I assign him membership to the A_P030 group too, he only sees the P010 dashboard....<br><br>
This is reproducable behavior.<br><br>
resyncing the GUID's didn't solve the problem.<br>
In fact, when I move the webcatalog to a complete fresh installation of OBI 11.1.1.5 and create a new user and assign him the roles as described above, the same behavior occurs.<br><br>
I'm lost...<br><br>
The session information (under My Account) shows the correct application roles. It's the mapping onto the ACL's in the webcatalog that seems to be wrong.<br><br>
Any input would be very much appreciated !<br><br>
Kind regards,<br>
RenéRene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.com0tag:blogger.com,1999:blog-4437346482004439016.post-69248472029458662792011-09-15T09:53:00.000-07:002011-09-15T10:16:02.185-07:00OBIEE 11.1.1.3 and 11.1.1.5: different approach to AGO functionHi again.<br /><br />After spending some time on the Time Hierarchy in 11.1.1.5 I found it useful to mention that it now is possible to use the AGO function in the BMM layer whilst the underlying logical facttable has multiple sources on different grains. <br />What I mean is the following:<br /><br />Let's say in your logical fact table there is a logical measure column called AMOUNT_SOLD. This column maps to two different columns in the physical layer: 1 comes from a table with a day-grain, the other comes from a table with a month-grain. (In cases where you only have a limited set of day-based data and an infinite set of month-based data, this will occur...)<br /><br />In your BMM layer, the logical fact table has 2 sources: the DAY-based table and the MONTH-based table. When you specify the content correctly for both LTS's, (map them to the corresponding levels in your logical Calendar hierarchy), drilling down on a dashboard from year via quarter to month level causes OBI to query the physical MONTH-based table. Drilling down to the day-detail level, OBI queries the physical DAY-based table. That is, if the logical table for your calendar has a seperate logical source for the DAY level, next to a logical source for the month level and up.<br /><br />So far, so good.<br />But, in order to use time-series calculations you would want to use the AGO function in the BMM layer. Something like AGO("Measure","Calendar Level",1).<br />This does not work in 11.1.1.3, since the logical table for the Calendar has multiple logical sources. (because of the double-source nature of the AMOUNT_SOLD measure)...<br />Creating a single logical source for the Calendar table does not solve the issue, because now, you're limited to the lowest level of the calendar. Meaning that you wil always query the DAY-based physical table...<br /><br />In 11.1.1.5 you can combine both.<br />You CAN use a single logical table source for your calendar and still have 2 physical sources for your AMOUNT_SOLD measure. Specify the correct Calendar level for both individual logical table sources and it works !<br /><br /><br />Kind regards,<br />RenéRene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.com0tag:blogger.com,1999:blog-4437346482004439016.post-28133056819012970552011-09-14T12:55:00.000-07:002011-09-14T13:02:41.103-07:00store non-OBIEE objects in the catalogThanks to John Minkjan (obiee101.blogspot.com) I was able to disclose (and secure) non-OBIEE content on a dashboard. <br /><br />Using the regular Upload functionality you can easily upload a (for instance) PDF file into the Shared Folders of the webcatalog.<br /><br />The awkward thing is, that if you put a link on your dashboard and use the Browse button to navigate to the particular folder, you don't see the PDF file since it is not an OBIEE object.<br /><br />A workaround for this is to create a (dummy) analysis and store it in the same folder as the PDF. Then, as described above, put a link on your dashboard and navigate to the dummy analysis. As a final step, (since you now have the path to the folder where the PDF resides) replace the name of the OBIEE analysis with the PDF's name.<br />There you go ! Now you can have a link on your dashboard to non-OBIEE objects and use your security model on it !<br /><br />Kind regards,<br />RenéRene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.com0tag:blogger.com,1999:blog-4437346482004439016.post-37313029820336934832011-08-10T22:33:00.000-07:002011-08-10T22:34:04.586-07:00Upgrade OBI 11.1.1.3 to 11.1.1.5 findingsWell,<div>Upgrading OBI 11.1.1.3 to 11.1.1.5 is quite... ehm... challenging.</div><div>My first advice would be: perform a complete fresh installation of Weblogic 10.3.5 and OBI 11.1.1.5. (A so-called Out-Of-Place upgrade). An in-place upgrade is a LOT OF WORK and involves a lot of manual steps and scripting.</div><div>
<br /></div><div>But, even the Out-Of-Place upgrade comes with challenges.</div><div>First of all, the installation is fine. (Although I tried to install this right after the release of the latest version of Java (7) and I didn't manage to get this up and running so I switched back to using 6u26.)</div><div>The migration of the security realm, setting up the Application Roles, everything is fine.</div><div>There is actually no need of upgrading the rpd file. Just point Weblogic to the correct file and it works.</div><div>
<br /></div><div>But the WebCat is a different story...</div><div>
<br /></div><div>In the 11.1.1.5 version of instanceconfig.xml there is this entry in the <catalog> section that says: change the upgradeandexit "false" value to "true"</catalog></div><div>
<br /></div><div>The documentation does not mention this entry. It mentions the previous syntax, which is something like ps:catalog etc. /ps:catalog </div><div>
<br /></div><div>Setting its value to true and restarting the presentation server should (I believe) perform an upgrade of the webcatalog. </div><div>
<br /></div><div>(BTW: the install doc of the 11.1.1.5 SampleApp also doesn't mention the 11.1.1.5 tag, but the 11.1.1.3 tag)</div><div>
<br /></div><div>What I did find is loss of functionality. So the 11.1.1.3 version and the post-upgrade 11.1.1.5 version of the same dashboards act differently.</div><div>For instance: Graphs that have conditional formatting no longer animate. And also ALL our gauges lost their footer. because after the upgrade the @1 reference in the footer had changed after the upgrade to @0.</div><div>
<br /></div><div>What else went wrong ? I'm still investigating. I'll keep you posted.</div><div>
<br /></div><div>Kind regards,</div><div>René</div><div>
<br /></div>Rene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.com0tag:blogger.com,1999:blog-4437346482004439016.post-40521955879276640992011-06-23T00:14:00.000-07:002011-06-23T00:17:14.217-07:00OBIEE Catalog and Application RolesHi !<br />When adding Application Roles as members to other Application Roles, the Presentation Server only 'sees' the ultimate parent of that hierarchy. So If you have an Application Role called 'Analyst' and there are other Application Roles member of this 'Analyst' Role, only the 'Analyst' role is known to the presentation server and also to the Catalog !<br />So remember this when setting access privileges on catalog objects !<br /><br />RenéRene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.com0tag:blogger.com,1999:blog-4437346482004439016.post-49766501948857260302011-06-22T05:25:00.001-07:002011-06-22T07:47:33.530-07:00OBI BIPLATFORM schema and Database 11 user profilesToday I encountered the situation that after having changed the BIPLATFORM password in de 11g database and in WLS Enterprise Manager, the account locks every x seconds.<br />To make a long story short: the bipublisher jdbc connection and the RTD jdbc connection also use the BIPLATFORM schema.<br />So you need to reconfigure those as well.<br /><br />Oracle Database 11g uses user-profiles. One of the options is password expiration.<br />So make note that if you hit such a situation, don't overlook the jdbc connections !<br /><br />RenéRene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.com1tag:blogger.com,1999:blog-4437346482004439016.post-51387974849865157022010-02-25T09:20:00.000-08:002010-02-25T09:40:44.676-08:00Real-Time BI... dus...Real-Time Business Intelligence.<br />Iedereen heeft het erover. Ik vind het maar vreemd.<br />Volgens mij kan het niet zo zijn dat een individuele transactie een significante impact heeft op de strategie van een organisatie.<br />Dat je behoefte hebt aan up-to-date data, OK. maar dan wel op mijn verzoek. Want een analyse op een wisselende dataset is onwenselijk.Rene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.com0tag:blogger.com,1999:blog-4437346482004439016.post-16642279763745776722010-02-25T08:56:00.000-08:002010-02-25T09:00:51.678-08:00BI en EAVandaag is een bijzondere dag: ik ben in London samen met Emiel van Bockel.<br /><br />Emiel oreert op het UKOUG over Enterprise Architecture en Business Intelligence. Alhoewel ik het verhaal op zich al ken is het verrassend en verhelderend om te zien hoe een zaal BI professionals hierop reageert. Opmerkelijk is et dat en volgende spreker in het eerste uur van zijn presentatie al 6 keer verwijst naar Emiel zijn verhaal.<br /><br />Wil je weten waar Emiel het over heeft gehad ? Hou <a href="http://www.bifacts.com/">http://www.bifacts.com/</a> in de gaten !Rene Kuipershttp://www.blogger.com/profile/06056242851974266935noreply@blogger.com0