One of the best ways to understand the BI EE repository design is to start designing the Business Model Layer for a single Physical table. Any person who is new to BI EE will always start with testing the repository for a single physical table. This is where BI EE can be quite confusing for [...]
On November 10, Microsoft announced the latest Oslo shift: Oslo's three main remaining components are going to be be renamed "SQL Server Modeling" and be folded into some future release of Microsoft's database. by Mary Jo Foley
Continuing the article we began in "Faster & Stronger MySQL", this article covers adding additional servers, and application changes in our quest to make our database faster, stronger, bigger and better.
Having concluded our discussion of Reporting Services in SQL Server 2005 Express Edition, we now begin an examination of Full Text Indexing and Search.
If you’ve been keeping an eye on our progress this year, you’ll probably be aware that 2009 has been a very exciting year for us. We’ve opened an office in the USA, and earlier in the year Adrian Ward and Daniel Bosman from Majendi, and Venkat J from India, joined us to strengthen our presence [...]
ODTUG Kaleidoscope, the Oracle Developer Tools User Group annual conference which next year is running in Washington DC, has a call for papers that closes on November 10th. This year, I’m the content lead for the BI, DW and Hyperion Reporting track and together with the rest of the committee, we’re trying to pull together [...]
If you’ve been to any of the Oracle BI Applications roadmap presentations, you may well have seen a slide that sets out “Oracle’s Integrated Analytic Solution”, which looks like this: (from Oracle Business Intelligence Applications Roadmap, Oracle Open World 2009) Now we all know about the ERP Analytics (Oracle BI Applications running against Oracle EBS, Peoplesoft and [...]...
John Paredes recently sent over a review copy of a book he’s just had published, entited “The Multidimensional Modeling Toolkit: Making Your Business Intelligence Applications Smart with Oracle OLAP” (ISBN: 978-0-9817753-0-2, OLAP World Press). Interestingly, it’s a book written about Oracle OLAP (which is itself rare) but unlike the recent Oracle Press book on OLAP [...]
The final day of PASS offered insights into configuration management, how it helps with Disaster Recovery and Consolidation, and a glimpse in the direction that Microsoft is heading with SQL Server 10.5.
SQL Azure is very similar to traditional SQL Server and now supports many standard TSQL commands. This article demonstrates the use of TSQL commands to create SQL Azure objects.
One of the issues that people often face while using BI EE is the lack of control on Multi-Select prompts. One cannot set Multi-Select prompts to a presentation variable & similarly one cannot display the multi-selected values in a report (only filter view supports the display of all the selected values). The most common requirement [...]
I’m currently over in Finland, waiting to travel back after the OUGF Autumn Conference in Helsinki. Together with Dan Morgan, Piet de Visser and Joze Senegacnik we were providing the English-Language track, and thanks again to Heli from the user group for inviting us all over. The event started on the Wednesday evening for us, with [...]
Testers of Microsoft's SQL Azure service experienced a three-plus hour unplanned outage this week -- just a couple of weeks before Microsoft is set to remove the beta tag from its Azure cloud service. by Mary Jo Foley