Measures: XML elements for each of the measures are represented under a
cube facts element, all at the same level (without nesting).
For example, In Sales cube, the measures under
SALES
FACT include Profit,
TRXN_SALE_AMT
,
TRXN_COST_AMT
,
CURRENT_POINT_BAL
,
MAIN_TENDER_AMT
, and so on, all at the same level, even though there
are measures which are derived from other measures. Example,
Profit
is
derived from
TRXN_SALE_AMT
and
TRXN_COST_AMT.
There are also other attributes associated with each of the elements. For
example, Business Name is an attribute for each of the elements in the XML
document ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.