Category Archives: OBIEE Training

I hope I’m not preaching to the preachers, but to me it’s obvious that some Linux skills are a must for OBIEE consultants. As well as virtual machines (at least virtual box), serious networking skills, and Fusion middleware stack knowledge.

I suggest starting with Sample images and getting Oracle Linux skills through some tutorials.

Sometimes thoughts materialize – in this case, I was thinking – wouldn’t it be great if Oracle provided a configured instance of OBIEE 11G – with everything pre-configured so that it’d be easy to get evaluate it quickly without going through the pains of learning new application server (Weblogic) and installation steps.

It seems as I was heard. I’m grateful to several people making me aware of the new app:

It’s been awfully quite and peaceful lately in the OBIEE environment. I think everyone is busy, which is a great thing – it means people are making money. I actually remember that the most active times are the ones when there’s slow amount of work. I quickly run through the list of the OBIEE blogs I usually attend to – and most (most – not all) of the posts are dated back in March. Myself, I’ve not had much time to blog – too busy on the project as well as developing network relationships. I apologize if I couldn’t answer one of your questions in the comments – I hope you were able to resolve the issue.

On another topic – OBIEE google’s group is doing well and growing strong (although the goal isn’t the numbers, but the quality). The quality of topics is amazing, as well as insight provided. I am starting to think that it would be advantageous to hide the material from public view (in order to encourage registrations and discourage lurkers).

I wonder how many people are doing beta testing of OBIEE 11g (and can’t tell due to NDA). I’ve already advised the client that many issues we’re battling would be solved in the new version, however, it doesn’t mean that the “fix” is right around the corner.

If you’re in the UK in late May and eager to improve your OBIEE skills, do some networking, and meet top experts in the field – I suggest you attend The Rittman Mead BI Forum. Kurt Wolff will be present (expert on all OBIEE-related topics, who worked on OBIEE’s grandfather product) for a very advanced session , where some of the topics will include:

Data modeling topics will include fact tables with different grains, solving complex security requirements, inputting user choices into formulas (for example, calculating a discounted price) without using variables, ragged hierarchies, using dynamically named physical tables, the use of specialized tables to avoid errors at query time or when setting prompts, preserving dimension values, calculations that require inner and outer joins among multiple tables, modeling a near real-time transaction environment, modeling a multi-tenant architecture.

Not using AGO and TODATE functions – I don’t know why anyone would like to avoid using AGO and TODATE functions for time-series analysis. The only two options are: non-Oracle DB which doesn’t support complex PARTITION BY queries or someone doesn’t want to create time dimension.