ASO - Some Facts on the Bits Used Statistics

ASO -  Some Facts on the Bits Used Statistics

If look at the properties tab on a ASO database , in the statistics tab you will find something called bit used for each dimension

So what does this signifies ?

ASO uses a bitmap mask to represent each stored member in the dimension as shown below .

BitMask	Member
000	Original Price
001	Price Paid
010	Returns
011	Units
100	Transactions

Thinking this through ASO will have to increase the number of bits  when we add new members to a hierarchy .

As shown below we added three new members Amount , Sales , price under the parent “Measures” , ASO stills shows number of bits as 3 - it did not increase the number of bits.

Hmmm… Its because ASO can still represent the new members with the existing number of bits.

BitMask	Member
000	Original Price
001	Price Paid
010	Returns
011	Units
100	Transactions
101	Amount
110	Sales
111	Price

Lets add one more member Market_Sales .  Now Essbase will have to add one more bit to represent the additional member .  Hence in the statistics tab it shows 4 bit used for the dimension measure

BitMask	Member
000	Original Price
001	Price Paid
010	Returns
011	Units
100	Transactions
101	Amount
110	Sales
111	Price
1000	Market_sales