Guide to Oracle 11g and Database Migration
Oracle Database 11g includes more features for self-management and automation, which makes it easier for customers to cost-effectively manage their data. Download this Internet.com eBook for an overview of some of the new features in 11g and for an overview of the issues you need to consider as you prepare for a database migration.
»
Innovate Faster with Oracle Database 11g
Read this in-depth analysis of 56 customers, which shows significant differences between the value software vendors Oracle and SAP deliver to midsize companies.
»
Oracle Business Intelligence Standard Edition One
Find out how Newport Beach, CA-based Mobilitie is shaking up the telecom industry by leveraging technology to provide an entirely different financial model for deploying, upgrading, and owning wireless and wireline network assets.
»
Business Intelligence and Enterprise Performance Management: Trends for Emerging Businesses
Quickly implementing an ERP software solution can be of tremendous benefit; however, companies often struggle to balance the benefits of reducing implementation time and cost with the risks of an accelerated deployment. Read this white paper to learn about easy-to-follow best practices for achieving a successful accelerated implementation.
»
December 15, 2003 Introduction to MSSQL Server 2000 Analysis Services: Using Calculated Cells in Analysis Services , Part II By William Pearson
About the Series ...
This
is the eighteenth article of the series, Introduction to MSSQL Server
2000 Analysis Services. As I stated in the first article, Creating Our First Cube, the primary focus of this series
is an introduction to the practical creation and manipulation of
multidimensional OLAP cubes. The series is designed to provide hands-on
application of the fundamentals of MS SQL Server 2000 Analysis Services ("MSAS"),
with each installment progressively adding features and techniques designed to
meet specific real - world needs. For more information on the series, as well
as the hardware / software requirements to prepare for the exercises we
will undertake, please see my initial article, Creating Our First Cube.
Note: Service Pack 3 updates are assumed for MSSQL
Server 2000, MSSQL Server 2000 Analysis Services, and the related Books
Online and Samples.
Introduction
In
this article, we will extend the exploration of calculated cells that we
began in our last session,
Using
Calculated Cells in Analysis Services, Part I.In
Part I we learned that calculated cells offer functionality previously
reserved for calculated members, custom members, and custom rollup formulas
(all of which we have explored in previous articles) to a specific range of
cells-or even to a single cell. We will revisit the construction of
a calculated cell, touching upon another means of creating one: through an MDX
query.
In this lesson, we will do the following:
Overview the
creation of calculated cells from the perspective of an MDX query
Discuss two
approaches to the creation of a calculated cell via an MDX query
Discuss the
ramifications of the two approaches, within the context of scope assigned by
each
Practice
creation of a calculated cell using the WITH clause in an MDX query
Parallel the methods
within the MDX query to mirror the actions we performed in Using Calculated Cells in Analysis
Services, PartI within the Analysis Services
Manager and associated subcomponents, including:
creation of a
calculated cell;
formatting of
calculated cell contents;
manipulation
of other cell properties, such as FORE COLOR and BACK COLOR, to
enable exception highlighting.
Add databasejournal.com to your favorites Add databasejournal.com to your browser search box IE 7 | Firefox 2.0 | Firefox 1.5.xReceive news via our XML/RSS feed
IE 7
Firefox 2.0
