The last three years have been hard work. Working on a very challenging project, whilst writing the OBIEE 11g book, kept me busy to say the least.
We recently went live with a huge HR Analytics 11g implementation, which went very well and is actively used by hundreds of users on a daily basis, but it did highlighted the strengths and weaknesses of the 11g version. Oracle support were kept very busy, and the one thing I learnt was to have an active patching strategy. Although ‘patch’ is a loose term when the patch is 3Gb in size.
Anyway, it’s live and so it’s time to find the next project. So, if you have a project that needs a senior OBIEE expert, please get in touch (email@example.com). I have high level security clearance and can travel any distance.
And now, this weeks blogs and tweets….
Videos such as TDE Demo for Oracle Advanced Security (Oracle Database 12c)
This blog by M & S Consulting says, “The Oracle BI Presentation Services caching could be an issue with high volume and large queries. A solution may be to limit the amount that can be cached.”
They say that one way of working around this would be to limit the caching parameters in the BI Presentation Services by modifying the instanceconfig.xml file
They then give detailed instructions of how to do this.
This blog by DataWarehouse Concepts, says that before 11g, there was no option to make an index visible or invisible. We can check on an indexes visibility by checking the visibility column from the data dictionary view DBA_INDEXES.
The blog then tells us both how to create invisible indexes and also discusses why we need Invisible Indexes.
In this post by Boris Dahav, he discusses creating specific type of prompt for periods after reading another blog post (OBIEE 11g – Advanced Prompts for Financial and Other Data such as ‘Last Year’, Last Month’ or ‘Last 6 Month’) The first part of his blog is about fixed periods (Last Year and Last Month) and in the second part adding Custom Dates option.
This blog by Gokhan Atil gives us 6 tips on how to do this. Then he talks us through what to do If the configuration step fails. He says that you can find configuration logs in Oracle Inventory installation logs and posted a link to an OTN video.
Paul Cannon posts this 3 Sixty Analytics blog as he has recently been asked how to set the background of a chart in BI Publisher to a gradient colour when using the Word Template builder. This blog goes through the whole process, step by step.
Join the LinkedIn group for OBIEE News and Discussions.
Follow Addidici on Twitter for daily OBIEE updates and news.