 |
Clearing the Path to OLAP | 2006-10-13 01:00:15 |
Oracle |
| |
The OLAP option in Oracle9i Database Release 2 introduced analytic workspaces and the true integration of relational and multidimensional datatypes in the same database. Until now, the only way developers and DBAs could use the analytic workspaces was to construct them manually by using command-line API calls. But with the recent release of the Analytic Workspace Manager (AWM), one can now make better use of the multidimensional features in the OLAP option for the first time without having to perform complex command-line programming. This paper introduces Analytic Workspace Manager and steps through the creation of a multidimensional cube stored in the analytic workspace that can be viewed via Oracle Business Intelligence (BI) Beans, OracleAS Discoverer, or SQL.
|
| |
 |
Building BI Dashboards With Oracle Database 10g, Oracle Discoverer, and Oracle Portal | 2006-10-13 01:00:15 |
Oracle |
| |
Business Intelligence (BI) dashboards bring together reports and graphs from several data sources and present information to users in a simple-to-understand, unified manner. The demand for BI dashboards from the user community has therefore led to numerous new features and improvements in Oracle's business intelligence tools, and the simplified creation of BI dashboards is one of the key new features of Oracle Business Intelligence 10g. This paper explains the features of a BI dashboard, discusses the benefits to users, and steps through the creation of a dashboard with Oracle Database 10g; Oracle Business Intelligence Discoverer (Oracle Discoverer), a component of Oracle Business Intelligence 10g; and Oracle Portal.
|
| |
 |
Building Open-Standard Portlets for Location Information | 2006-10-13 01:00:15 |
Oracle |
| |
As integration technologies such as portals and intelligence data become critical pieces of the business infrastructure, being able to share the information used and the applications (portlets) build becomes utterly essential (if not legally required). Now a days people not only have all the ingredients needed for creating new applications that adhere to open standards but also have framework standards, such as OASIS Web Services for Remote Portlets (WSRP) and Java Specification Request 168 (JSR 168), that make it possible to integrate existing technologies and data into new applications.
|
| |
 |
Web Analytics Using Oracle Application Server Discoverer | 2006-10-13 01:00:15 |
Oracle |
| |
This paper will offer an overview of an alternative that is available to companies running Oracle Application Server 10g Enterprise Edition. Instead of investing in another expensive information silo, these companies can apply the reporting power and flexibility of the Oracle Application Server Discoverer query and analysis tool to information-rich web server log files to produce reports comparable to those available from standalone solutions.
|
| |
 |
Use Location Information in Enterprise Reporting | 2006-10-13 01:00:15 |
Oracle |
| |
Location information is everywhere; it can be found across all lines of business, all industries, and in virtually every organization and department in the world. Although location information is essential, it is seldom ultimately used to integrate data across the systems and provide actionable business intelligence to the organization. It's not widely known, but with current technology, it is indeed possible to use location not only as an address or a point on a map, but as a way to reveal trends based on market share, population concentration, or complex location-based interactions. This paper describes a technique for meeting that goal across all lines of business using the same enterprise reporting tools that are commonly used for relational data.
|
| |
 |
Oracle9i Business Intelligence Beans: Making the Move | 2006-10-13 01:00:15 |
Oracle |
| |
Before decision makers at all levels can quickly respond to changes in the business climate - the ultimate goal of business intelligence - businesses themselves need to analyze their own mechanisms and performance. But to do so, they have to examine the often overwhelming amount of information stored in databases. Of course, these analytical queries require the use of an OnLine Analytical Processing (OLAP) solution. Oracle customers have long used Oracle Express databases and the application platforms that go with them - Oracle Web Agent and Oracle Express Objects (OEO) - to meet their business intelligence needs. Oracle has now merged its relational database with the Express multidimensional database to create Oracle9i Database Release 2 with the OLAP Option.
|
| |
 |
Oracle Database 10g: Top Features for DBAs - Part 4: Data Warehousing and Integration Features | 2006-10-11 01:00:17 |
Oracle |
| |
This paper presents new features for more efficiently managing materialized views, Query Rewrite, Transportable Tablespace, and table partitions make the data warehouse an even more powerful, and less resource-intensive, asset. The paper presents Data Warehousing and Integration features of Oracle Database 10g such as Partition Change-Tracking Without MV Logs, Query Rewrite with Multiple MVs, Transportable Tablespace From Backup, Quick Partition Split for Partitioned Index-Organized Tables, LONG to LOB Conversion via Online Redef, Online Reorg of a Single Partition, and Partition-by-Partition Table Drop.
|
| |
 |
Why Business Intelligence Projects Fail to Deliver ROI. | 2006-10-20 06:14:53 |
SAS |
| |
Too many Business Intelligence (BI) projects fail to deliver on their promises. The Butler Group identifies the key drivers of success, showing how structured approaches can deliver sustainable ROI.
|
| |
 |
Sainsbury's: SAS® drives increased profit from direct marketing | 2006-10-06 01:00:14 |
SAS |
| |
With 11 million Nectar scheme members, Sainsbury's has transformed itself into a customer-centric retailer, building a new IT infrastructure and using SAS to optimise campaigns, build relationships and grow sales.
|
| |
 |
The SAS® Enterprise Intelligence Platform: An Overview | 2006-10-06 01:00:14 |
SAS |
| |
SAS has developed an integrated platform for delivering enterprise intelligence. The SAS integrated software suite leverages best practice and industry leading technologies, enabling organisations to reduce costs, manage risks and act proactively.
|
| |