Skip to Main Content
DB2 Cube Views: A Primer
book

DB2 Cube Views: A Primer

by Corinne Baragoin, Geetha Balasubramaniam, Bhuvaneshwari Chandrasekharan, Landon DelSordo, Jan B. Lillelund, Julie Maw, Annie Neroda, Paulo Pereira, Jo A. Ramos
September 2003
Beginner to intermediate content levelBeginner to intermediate
754 pages
18h 9m
English
IBM Redbooks
Content preview from DB2 Cube Views: A Primer
Chapter 14. Web services for DB2 Cube Views 625
򐂰 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.
Start your free trial

You might also like

Expert Cube Development with SSAS Multidimensional Models

Expert Cube Development with SSAS Multidimensional Models

Chris Webb, Alberto Ferrari, Marco Russo
Oracle Essbase & Oracle OLAP

Oracle Essbase & Oracle OLAP

Michael Schrader, Dan Vlamis, Mike Nader, Chris Claterbos, Dave Collins, Mitch Campbell, Floyd Conrad

Publisher Resources

ISBN: 0738499730Purchase book