Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective owners.
Copyright © 2006, 2008 Oracle. All rights reserved.
Sept 08
Customer Feature - Oss Council - control their municipality more efficiently
Why use Summary Management and Cube Materialized Views
DBA Tip - What values should I use for the 11g Cost Based Aggregation Method setting?
July 08
Customer Feature - Large Oracle OLAP Solutions- E.ON, BNP Paribas, Circle K Sunkus, Gallup, one of the world's biggest telecoms.
What's great about AWM 11g?
DBA Tip - How do you ensure you have enough memory for good OLAP performance? Update on using 10.2 AWs and 11g.
Apr 08
Customer Feature - Auchan, Russia - Hypermarket chain understand product positioning and increase sales by using Oracle OLAP and Oracle Portal.
Why use Oracle OLAP?
How do you create OLAP Calculations?
DBA Tip - Using 10.2 AWs and 11g
Feb 08
Partner Feature - Micros - enhance their Opera Enterprise Solution for retail industry to include Oracle OLAP and OBI EE in Opera Business Intelligence
Partner Feature - Bissantz - extend core product DeltaMaster to leverage Oracle OLAP and implement at customer site
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; they have implemented new BI applications, central to which is Oracle OLAP, to understand power demand, revenues and margins. There's over 1TB of data in the AW.
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 , Oracle OLAP and a SQL Web based query tool on Fujitsu's powerful Primequest server they gain information 8 times faster on more than 10 million data points than their previous relational only solution.
What should I consider for OLAP Sizing?
DBA Tip - Parameters for OLAP sizing and tuning
Jan 07
Customer Feature - BNP Paribas, one of the worlds largest banks 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 locations.
Key AWM 10.2.0.3 Features - Sparsity Advisor and AWM Plugin SDK
DBA Tip -Implementing RAC with OLAP
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.
OLAP data in an AW can be accessed by simple SQL.. simple example of using olap_table
DBA Tip - ADDM and AWR use
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.
Differences betwwen AWM 10g and OWB 10g R2
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.
Save time creating custom calculations using Excel sample utility
DBA Tip - RAC performance tuning
Mar 06
Customer Feature - Altana Pharma created its Value Cockpit Executive Scorecard solution to analyse KPIs using arcplan dynaSight and Oracle OLAP.
Best performance for incremental update in 10.2
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.who have 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 implemented OLAP with a custom written OLAP API Java front end. They performed detailed analysis of their customer base, such as types of customer activity and network use as well as revenue information.
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?
July 05
Customer Feature - BizzEnergy migrated an Oracle Express application to provide fast, competitive online quotes to customers
DBA Tip - How do I run a SQL trace?
DBA Tip - How can I trace the OLAP DML that is run during the load?
May 05
Customer Feature - Leviton Manufacturing use Oracle OLAP, OWB and Oracle BI to allow aggressive pricing and effective sales
DBA Tip - How to improve load time
DBA Tip - How to Count Distinct in OLAP
Other Newsletter Features:
Verizon Information Services use ROLAP and MOLAP solution
Control AW Size Trick
Camaieu implement OLAP and Business Objects
How is DBMS Flashback useful for managing AWs?
University of Bern implement AITG Web Reporter built with Oracle OLAP
Bookmark
