Oracle BI EE 10.1.3.4.1 – Do we always need AGO and ToDate functions for Time Series Analysis?

Wednesday, June 9th, 2010 by Venkatakrishnan J

In my last blog post, i basically showed how we can do multi-dimension OLAP aware reporting by altering the physical data-warehouse model. Along similar lines, one other common thing that i have found recently in many implementations is the extensive use of AGO and ToDate functions. AGO and ToDate are probably one of the most [...]

Oracle BI EE 10.1.3.4.1 – Do we need measures in a Fact Table?

Monday, May 31st, 2010 by Venkatakrishnan J

I know this blog title can be classified as a deviation from my more conventional ones but i have been planning on writing this for a while now, so hopefully this should be of some interest to everyone. As we start working with BI EE more and more, we get to know what its good [...]

Suncoast Oracle Users Group, May 27, 2010

Monday, May 17th, 2010 by Stewart Bryson

I’m honored and excited to be speaking at the Suncoast Oracle Users Group (SOUG) monthly meeting on May 27th, 2010, at the PricewaterhouseCoopers facility at 3109 W. Martin Luther King Blvd., Tampa, FL 33607. Much appreciation to the Oracle Nerd Chet Justice for recruiting me to speak at this event. As I’m still very much [...]

Oracle BI EE 10.1.3.4.1 – Number of Members in a Level & Aggregate Navigation

Tuesday, April 20th, 2010 by Venkatakrishnan J

One of the less known/less used capabilities of BI EE is the ability to switch between Aggregate tables based on the number of members in a level. For example, lets consider the screenshot shown below In most cases, we will not have the necessity to alter the number shown above. But there are cases(especially in [...]

Oracle EPM 11.1.1.3 & Oracle OLAP 11g – Reporting on Oracle OLAP using Essbase Excel Add-in/Smartview – XOLAP

Monday, April 19th, 2010 by Venkatakrishnan J

This is the week of Colloborate 2010 conference. Mark, myself, Pete and Stewart were scheduled to present this year but due to the European Airspace closure, myself and Pete haven’t been able to actually travel this year. Its a real shame as we all really looked forward to this conference in Vegas. The topic that [...]

Website Design & Build: tymedia.co.uk