I don't think this is possible, but wanted to through it out and see if
anyone has any ideas...

I have a Olapdatabase of purchase transactions. I want to be able to define
an "Threshhold Amount" dimension with 4 values - $0, $100, $1000, and $10000
such that, by selecting one of these values, the result set is based upon
only those transactions with a transaction amount GREATER than the selected
threshhold value.

I can't seem to figure out how to do this... don't think its possible, but
I'm a greenhorn, and so I pose the question...

My thanks for any and all help.
Jim

actually there is no feature to do this directly in the cube or dimension.

The easy way is to create a table with your range of value and added a
column in your fact table with the range of value.

in sql server:
case when amount = 0 then 0 when amount < 100 then 1 .......

and the new dimension table :
ID Value
0 0$ and less
1 0-100$
2 100$-1000$
........

I hope the new version will provide an easy way to do this.

"Jim Fox" <jimf (AT) imxinc (DOT) com> a écrit dans le message de
news:eb6zEs1PDHA.2248 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.493 / Virus Database: 292 - Release Date: 2003-06-25