Dear all,

Do we need write custom program to do this - two-phase OLAP?

Two-phase OLAP is the term I coin to express the situation when a
discretized measure of one cube is used as a new dimension in another
cube of the same analsysi (i.e., other dimensions exist in both cubes)

For example, the marketing user wants to do sales analysis by an "order
size" (the dollar amount of a purchase order) dimension, which itself
is a measure. The problem is, we can't previously know which product or
product category, which period of time, etc. the user will analyze
against, therefore, we can't create the cube to fulfill this kinds of
needs.

Of course, we can run a two-layer SQL to get the result, but this will
count on IT, not OLAP.

Any comments are highly appreciated.