Database Reference
In-Depth Information
Figure 7.6 DBAG v11.1.2.1, Chap. 62, p. 935. (From Oracle Essbase Administration Services. With permission.)
Children of Digital Cameras/Camcorders = 5 + log(3) = 7
Children of Handhelds/PDAs = 5 + log(3) = 7
Children of Portable Audio = 5 + log(2) = 6
Televisions, Home Audio/Video = 3 + log(2) = 4
Children of Televisions = 4 + log(5) = 7
Children of Home Audio/Video = 4 + log(4) = 6
Computers and Peripherals = 3 + log(1) = 3 **
Systems, Displays, CD/DVD drives = 3 + log(3) = 5
Children of Systems = 5 + log(2) = 6
High End Merchandise = 1 bit
Flat Panel, HDTV, Stored Member = 1 + log(3) = 3 bits
member Computers and Peripherals has the same number of bits (3) as its
parent other [DBAg 6] .
The maximum bits used by any level 0 children in the Products dimension is
7 (Children of Digital Cameras and Children of televisions). Therefore, Products
uses 7 bits, which is less than the dimension size limit of 64 bits.
Note: referencing marks have been added as [DBAg #] for use later in this chapter.
Note: references to the log(x) function should be assumed to mean the log-Base2(x)
or log(x,2).
7.4.2.1 Bitmap Construction Summary: For a Dimension with a Single Stored Hierarchy using
the information from the DBAg, we can deconstruct how a bitmap is calculated for a
dimension with a single Stored hierarchy. For each set of level-0 siblings in the hierarchy,
calculate recursively up the hierarchy the number of bits per sibling family as:
Log(SiblingCount) + Log(SiblingCount(Parent))
Search WWH ::




Custom Search