I'm trying to find sample MDX code to build a non-additive OLAP cube. I have a
data file that contains all non-additive measures. The input file
contains the distinct value for each cell in the cube. There is no
requirement to perform additional addition on the measures. These are
risk related measures and therefore they can not simply be summed.
The Sample Data I'm trying to create a cube for:
region lob MSA MtM VaR
Latin America International Business Gr Austin $315,011 $2,784
Latin America International Business Gr Minneapolis $263,107 $420
Latin America International Business Gr SanDiego $258,906 $200
North America Business Capital Group Austin $96,656 $1,014
North America Business Capital Group Minneapolis $41,467 $0
North America Business Capital Group SanDiego $178,640 $0
North America Investor Capital Group Austin $71,891 $0
North America Investor Capital Group Minneapolis $72,508 $148
North America Investor Capital Group SanDiego $61,539 $309
North America Residential Capital Group Austin $194,205 $678
North America Residential Capital Group SanDiego $286,057 $1,428
Pacifc Rim Investor Capital Group Austin $377,204 $1,457
Pacifc Rim Investor Capital Group Minneapolis $437,153 $333
Pacifc Rim Investor Capital Group SanDiego $220,665 $4,516
Latin America International Business Gr + $837,023 $2,864
North America Business Capital Group + $316,763 $1,014
North America Investor Capital Group + $205,938 $369
North America Residential Capital Group + $480,261 $1,798
Pacifc Rim Investor Capital Group + $1,035,022 $4,840
Latin America + + $837,023 $2,864
North America + + $1,002,962 $2,784
Pacifc Rim + + $1,035,022 $4,840
+ + + $2,875,008 $9,748
I tried this code (on a different sample data set) - the code works ok
for a measure like inventory. The code that works for inventory is:
(<<root.Sum of inventory>>, ClosingPeriod(<<Time.Time.MONTH>>))
However, this code keys off of the closing period that is defined as a
time interval. I can't seem to get this to work for my sample data.
Any thoughts??? |
