range - MDX How to add bands to grouped fact table -

I am trying to create an income band on my fact table.

Factsheet table containing

date, tran type, date, amount

  01/01/2015 TRAN1 ID01 5000 01/02/2015 TRAN1 ID02 13000 01/03/2015 TRAN2 ID01500  

Advisory has linked back to DIIFFF, this table contains a parent child hierarchy of a parent. There are two levels, advisory and advisory group

  ADVKEY PARENTKEY ---------------- ID01 ID03 ID02 ID03 ID03 NULL  

I want to be able to group on AdvKey or AdvGrpKey and the income is the amount allocated to the band (income).

So when I group on the advisor, each advisor is applied to an income bands, i.e. 0-10k, 10-50k, 50-100 q, even when the group is changed at the group level .

  ID01 5300 0-10000 ID02 13000 10000-20000  

or by consulting group if

  id 03 18300 10000- 20000  

In SQL, I can group with the key, then add a column and case statement to allocate an entire amount to a band.

There are about 2 million rows of facts.

The income is generated from the advisors and the advisory group, so it will change over time.

I do not think there is no way to link back to the fact table in any way to do this with one dimension because this group is done at run time.

---

Now I have something that works 20000')) {[Solution]. [Volume], measures Columns on [Calc zodiac]}, Zero ([dim IFA description]. [Parent key]. [Advisory group [] [Measure] [line] Lines [earnings and email from quebe] [/ code> < P> When I add more bands, then instead of going to be a heavier IIF, is it possible to create a dimension with categories and it is possible to add the flying keys like this? Or will there be no benefit.

< / Div>