I have 2 tables,
- holds a value (fact)
- holds a multiplier
now i need to multiply the fact (table 1) with the multiplier from table 2, where the value from table 1 is between a to and from value on table 2
is there a way to do this with MDX, if so an example would be appriciated.
View Complete Post