Regular features in each newsletter are:

• Partner/Customer Feature
  
• Product Management Oracle OLAP Update
• Oracle OLAP DBA Corner
• Downloads and Links the the latest software versions and related patches
• Education and Assistance
• Oracle OLAP DBA Tip
• Events
• News and Press

To subscribe to the Oracle OLAP Newsletter click here, or see the link at the top of each newsletter:

Jul 08
Customer feature - Scalability and Performance of Large Data Sets using Oracle OLAP
Product Management Oracle OLAP Update
Oracle OLAP Skills Corner - What is great about AWM11g
DBA Tip - How do you ensure that OLAP has enough memory to perform well?
DBA Tip - An update on using 10.2 AWs in 11g



Apr 08
Customer feature - Read How Auchan Hypermarkets improve Sales and increase profitability using Oracle OLAP
Product Management Oracle OLAP Update
Oracle OLAP Skills Corner - Why Oracle OLAP?
Oracle OLAP Skills Corner - How do you create the kind of calculations that only OLAP can do so well?
DBA Tip - How do you set up an 11g database in 10.2 mode, and why would you want to?

Feb 08
Partner Feature - Micros Opera Business Intelligence
Partner Feature - Bissantz DeltaMaster
Which reporting tools can I use with Oracle OLAP?
DBA Tip - Using cube Materialized Views to get a performance boost?

Dec 07
Customer Feature - E.ON is the world's largest investor-owned energy service provider with presence in European and US markets.
How can the Oracle OLAP option be used as a Summary Management tool in 11g?
DBA Tip - My initial connection time using the BI Standard Edition to OLAP seems very slow. Why is this, and what can I do about it?

Sept 07
Customer Feature - SAS Scandanavian Airlines has implemented a new Financial Business Intelligence platform. They use Oracle Database 10g with OLAP, RAC and OWB. For querying, they use Oracle Application Express as well as Discoverer and Spreadsheet Add In. 350 users access the Budget and Planning application and the predefined reports.
Oracle Database 11g extends the capability of OLAP 10g by improving its scalability, ease of security, simplicity and its use as a transparent Summary Management tool.
DBA Tip - Does AW tablespace size or growth seem to be a problem? What can you do?

Apr 07
Customer Feature - Circle K Sunkus operates a 30 Terabyte Data Warehouse. Running Oracle Database 10g on Fujitsu's powerful Primequest server, they have more than 10 million data points processed daily by the Data Warehouse, to be available for analysis through Oracle OLAP and a SQL Web based query tool
OLAP Sizing - What should I consider?

Jan 07
Customer Feature - BNP Paribas, one of the worlds largest banks by market capitalisation, has implemented a near real-time OLAP daily time-series data and analysis solution. This solution stores over 3 billion data values within multiple OLAP cubes across several geographical location
Key AWM Features - Sparsity Advisor and AWM Plugin SDK

Oct 06
Customer Feature - Ford, in Genk, Belgium are using their Oracle OLAP to save costs in a unique way by monitoring and controlling energy consumption. Energy for the automotive plant is costly and Ford receives high penalties when they use too much. Data from energy meters is pumped to Oracle OLAP allowing administrators to watch, control and predict energy use in multiple departments.
DBA Tip - OLAP data in an AW can be accessed by simple SQL

July 06
Customer Feature - RIAS, an insurer to a specialized market have implemented the complete OracleBI stack. They rely on the solution to improve marketing campaigns and enable their growth by providing an excellent customer experience and good value products.
Customer Feature - PriceMinster are a unique online retailer in France, who have implemented an Oracle OLAP 10g and OWB 10g business intelligence strategy for their Marketing group. It's allowed them to make better business decisions, such as how best to recruit new customers.
DBA Tip - In order to achieve the best load and aggregate performance for your Oracle OLAP cubes, you should logically partition your AW and physically partition your relational tables

May 06
Customer Feature - Audax implemented a new integrated ad-hoc and OLAP query and analysis environment using Business Objects and Oracle OLAP technology. The solution provides more comprehensive analysis of detailed information, as well as 'great' ad hoc query performance of relational and OLAP data within the single environment. The single solution enables easier and more consistent Business Intelligence for Audax Board Members and several hundred external end users. They state they save $100,000 in licence and maintenance costs anually.
DBA Tip - A general performance tips

Mar 06
Customer Feature - Altana Pharma created its Value Cockpit Executive Scorecard solution to expose and analyze business dependencies between business units and KPIs, and show the impact on operational and business objectives. Value Cockpit collaboratively establishes a link among 40 members of management, and includes email features enabling executives to contact managers directly
DBA Tip - How to kill database sessions, including OLAP sessions

Jan 06
Partner Update - AITG AG, arcplan, SolStonePlus and Vlamis are primary Business Intelligence solution vendors and integrators. They are Oracle Partners, i.e. they are part of the Oracle Partner Network. They've either implemented their own 'OLAP' products or custom solutions at various customer sites around the world.
BDA Tip - The tip we feature this month is a summary of how to implement AW Security.

Nov 05
Customer Feature - Tianjin Mobile have implemented OLAP with a custom written OLAP API Java front end. They perform detailed analysis of their customer base, such as types of customer activity and network use as well as revenue information. They have large data volumes and a huge customer base, resulting in large scale modeling requirements.
DBA Tip - How should I partition the AW?
DBA Tip - How can I relationally partition my AW?
DBA Tip - How can I distribute partitioned LOBs across tablespaces?

Sept 05
Customer Feature - The Gallup Organization are developing a generic OLAP application that can be easily remodeled and extended for various customers with different end user needs. The first of these applications is a healthcare offering which analyzes hospital quality. This solution is currently in production at a few sites and will be rolled out to 200 different customers by early next year. They expect up to 6000 concurrent users globally.
DBA Tip - How to improve AW performance at query time
DBA Tip - How to improve AW performance at load time
DBA Tip - How can I monitor what is happening during my AWM load?
DBA Tip - How can I trace the OLAP DML that is run during the load?