I have a table that feeds a dimension. It has Columns:
Defaults, Level1, Level2, Level3, GLAccountID

There are 3 possible values for Defaults (All Accounts, FFO Defaults, NOI Defaults)
Each default has the same Level1, Level2 values.
The Level 3 values apply to some some of the defaults and not others.
AccountID is the GL account.
So, consequently, some GLAccountID's fall under some defaults and not others.


Structure Looks something like:

-All Accounts (Defaults)
- Adjusted Net Operating Income (Level 1)
- Adjustments (numerator) (Level 2)
- Bad Debt (Level 3)
- 69200
- 76911
- Corporate/Entity Taxes (Level 3)
- 88010
- 88020
- Net Operating Income (Level 2)
- Operating Expenses (Level 3)
- 70111
- 70112
- 70113
- Adjusted Real Estate (Level 1)
- Adjustments (Denominator) (Level 2)
- Deferred Leasing Costs (Level 3)
-Some Account Numbers
- Deferred Rent (Level 3)
-Some Account Numbers
- Investment in Unconsol. JV (Level 3)
-Some Account Numbers
- Land Held for Development (Level 3)
-Some Account Numbers
- Gross Operating Real Estate (Level 2)
- Building and Improvements (Level 3)
-Some Account Numbers
- Land and Land Improvements (Level 3)
-Some Account Number


-NOI Accounts (Defaults)
- Adjusted Net Operating Income (Level 1)
- Adjustments (numerator) (Level 2)
- Bad Debt (Level 3)
- 69200
- 76911
- Net Operating Income (Level 2)
- Operating Expenses (Level 3)
- 70111
- 70112
- 70113
- Adjusted Real Estate (Level 1)
- Adjustments (Denominator) (Level 2)
- Deferred Rent (Level 3)
-Some Account Numbers
- Investment in Unconsol. JV (Level 3)
-Some Account Numbers
- Land Held for Development (Level 3)
-Some Account Numbers
- Gross Operating Real Estate (Level 2)
- Building and Improvements (Level 3)
-Some Account Numbers


-FFO Accounts (Defaults)
- Adjusted Net Operating Income (Level 1)
- Adjustments (numerator) (Level 2)
- Corporate/Entity Taxes (Level 3)
- 88010
- 88020
- Net Operating Income (Level 2)
- Operating Expenses (Level 3)
- 70111
- 70112
- 70113
- Adjusted Real Estate (Level 1)
- Adjustments (Denominator) (Level 2)
- Deferred Leasing Costs (Level 3)
-Some Account Numbers
- Investment in Unconsol. JV (Level 3)
-Some Account Numbers
- Gross Operating Real Estate (Level 2)
- Land and Land Improvements (Level 3)
-Some Account Number
I can get the dimension to build as long as I use Defaults and GLAccountID as the logical Key to the table
This table joins to the fact table on DimensionTable.GlAccountID = FactTable.AccountID
This functionality worked fine in AS2000

Here is the issue.
When I process the cube, all the values are the same from the top to Level 3 It is only when I get to the GLAccountID, that I actually see a value.


Adjusted Net Operating Income Adjustments (Numerator) Bad Debt 69200
76911 ($6,679.55)
78010 $0.28
78020
Total $4,732,139.26
Corporate/Entity Taxes 88010
88020
88021
96010
Total $4,732,139.26
Depreciation and Amortization - LTC 92030 ($351,029.45)
94010 ($63,651.28)
94020 $0.00
Total $4,732,139.26
Exchange Rate Gain (Loss) $4,732,139.26
G&A Capitalized $4,732,139.26
Gain (Loss) on Sale $4,732,139.26
General and Administrative $4,732,139.26
Interest $4,732,139.26
Joint Venture $4,732,139.26
Straight Line Adjustment $4,732,139.26
Termination Fee Income $4,732,139.26
Total $4,732,139.26
Net Operating Income Operating Expense $4,732,139.26
Operating Revenue $4,732,139.26
Other Income and Expense $4,732,139.26
Total $4,732,139.26
Total $4,732,139.26