John Minkjan kicks of Day I of the RittmanMead BI Forum. He’s subject is Oracle BI EE on mobile devices. Very appropriate to the discussion last night during Oracle’s Keynote. Mobile is hot and the audience is very eager to see Oracle BI EE in action on Mobile Devices (Ipad / Galaxy Tab). Before going to the demonstration, John shows us a lot of things you should bare in mind when developing mobile applications. I will not go into the XXX-details or better DDDD.
Oracle BI EE on mobile is not only about nice and fancy dashboards but also about:
- Type (Wifi, Bluetooth, Cellular)
- Content Control
- Operating System
You have to think about dashboards which are firstly built for a laptop/desktop. Now you should redesign to fit the dashboard into the device. You could use some kind of landing page to navigate to the different dashboards, depending on where you are coming from.
Next up is Adam Bloom. Adam is opening the lid on Oracle BI 11g security. He has a lot to open!! First he shows us the architecture of a Weblogic deployment. The best thing is try to use the Fusion Middleware (FMW) Security. Although 10g Security via Init Blocks is supported you should make a choice between the two. Another thing is you should stick to whatever is certified, because of the limitations of the Oracle Platform Security Services (OPSS).
Adam also demystified some of the GUID issues. There are some issues when you login with the weblogic-user in different RPD’s. When you set the following parameter; FMW_UPDATE_ROLE_AND_USER_REF_GUIDS in the NQSConfig-file to ‘YES’, the problem is solved. You refresh the GUID’s only when you are moving the indentity stores to a new server. Also when a RPD hasn’t been used on a server yet.
Unfortunately this topic is so new and so complex, some other subjects could not be covered. We shortly addressed configuration and logging but according to Adam; “There are no bugs, only bad configuration”.
On to Andreas Nobbmann, who is going to; “Script for a Jester’s tear” referring to a song of Marillion. Andreas is scripting fanatic and he warns us not to exaggerate the scripting. Scripting could make your life easier and can be used for;
- repeating tasks
- starting / stopping / status
Downside of scripting is the lack of logging.
Andreas cover various elements of scripting:
If it comes to migrating security check here.
After lunch, Mike Brooks did his ‘Warts and All’-presentation about his real-life experiences when implementing Oracle BI 11g. It turns out that a major release like Oracle 11g is, is not that easy. Not even for experienced people like Mike, supported by the RittmanMead guys. Over at Play.com, they tried to do a one week POC. Based on advice and documentation plans could be made, but due to later experiences the had to switch plans every once and a while.
Implementing the BI part of Oracle BI 11g is no rocket science, but the Weblogic Server is a whole new ballgame. That needs additional skills and training.
Now follows a panel discussion about the following subject; “Was it worth the wait”, My personal opinion is; Yes!! Of course we have been waiting very long and of coures not everything is running as smoothly as we would like it to. On the other hand, the product looks fantastic and it gives us a lot of new opportunities, both technically as well as functionally. I guess we should focus on the good things and let Oracle work on the rest to improve the product.
A few highlights of the discussion;
- focus on security issues instead of improved BI capabilities
- sexy Front-end
- early access, release dates
- data lineage
- charting like BI Publisher
- Oracle OLAP vs Essbase
- Essbase (Front-end Yes!!, Back-end No!!)
Was it worth the wait or was worth the technical change? In the end, I guess it was a cautious yes.
Michael Wilcke finished the day with a presentation about why the Oracle BI Server is the ultimate choice for a BICC. BI is a circular process which never stops. When BI stops it is finished. Michael features on two subjects;
- Business versus IT
- Process and Organization
There is ‘always’ tension between business and IT. The Oracle BI Server offers the ability to separate these two (logical sql versus physical sql). This way you can de-couple the Front-end from the Back-end.
Requirement engineering can be done via prototyping in Excel and de-coupling. The requirement process is all about understanding the user instead of believing you know what he/she wants. You should define, establish and review. Top-down DWH vs. Bottom-up DWH.
In the end it turned out that Michael did a great job. He was elected by the audience as the Best Speaker. Therefor Mr. Wilcke went home with the most prestigious Brighton #biforum Best Speaker Award. Congratulations Michael.
It was a very interesting day. I think the speakers of this day have taken this event to a higher level (again!)