Submitted by Mark Rittman on Wed, 2005-08-10 01:00
In this article, Mark explains how the SQL MODEL clause can be used to generate rather complex financial statements.
Submitted by Mark Rittman on Fri, 2005-07-29 01:00
One of the most powerful features of the multidimensional engine behind analytic workspaces is the ability to create formulas. Formulas, or "calculated measures" as they're referred to in AWM10g, are measures that are derived from other measures. Using AWM, you can create simple formulas that reference other measures in a cube, allowing you for example to create a "margin" measure derived from sales and costs measures. If you're an old Express hand though, you'll know that this simple type of formulas is just the tip of the iceberg, and what you often used to end up doing was creating for example a three dimensional formula based on measures from four and five dimensional variables, rolling up unneeded dimensions and pulling in variables held in what would now be referred to as "cubes".
Submitted by Mark Rittman on Wed, 2004-06-02 01:00
Submitted by Mark Rittman on Mon, 2004-03-29 00:00
With the recent release of Oracle Database 10g, OTN have recently been running a series of articles by Arup Nanda entitled "Oracle Database 10g: The Top 20 Features for DBAs".
With this in mind, I thought it worth putting something similar but this time focusing on those features that apply to Data Warehousing and Business Intelligence. So here's my Top 10...