Hi

I was wondering, if it possible to join a calculated measure with returns an integer to a dimension ?

Basically what I am trying to achieve to have a Range dimension,
say
RangeId Description
1 < $50,000
2 $50,000.01 - $100,000

Assuming that I have a calculated measure, that does an iif on a measure(InvestmentValue) to that returns an integer (which is the rangeId), is it possible to join it to the RangeId of the Range Dimension ?

I do not want to put the RangeId against the row of each fact table because it become static and does not reflect the current value in the cell.


Any pointers, as to how to achieve this are most welcome.
Thanks
Deanne




************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

The easiest way to create such a dimension is to create a SQL view that
contains a calculated column with the ranges your are interested in. If you
don't have permisions to create a view in the database, you can place a SQL
case statement (with syntax appropriate for the data source) in the Member
Key Column and Member Name Column properties for the level.

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Deanne D'Souza" <deanne_d (AT) telstra (DOT) com> wrote

is it possible to join it to the RangeId of the Range Dimension ?