Hello,
I've a trouble with range value in olap.

I try to explain my problem whit this example:
I'm in using a cube ("Sell") from a table with this measure:

Name Sold_Unit Market Market_Share
-------------------------------------------------
Paolo 10 50 20%
Pippo 5 50 10%
Pluto 30 240 12,5%

(Other dimension let me filter on Product or Time)

In another SQL table I've a function that map the Market_share (in
range) in a Bonus value:

Mkt_Share_Min Mkt_Share_Max Bonus
--------------------------------------
0 10 0
11 13,4 80
13,5 25 100
25 999 120

Is there a way to insert in the cube 'Sell' a measure with the 'bonus'
value?
I'll wish obtain a cube like this

Name Sold_Unit Market Market_Share Bonus
--------------------------------------------------------------
Paolo 10 50 20% 100
Pippo 5 50 10% 0
Pluto 30 240 12,5% 80

I'm thinking to use a UDF that call a sql-query, but I don know how to
do


Thank's to all
Stefano

You can create a view joining the tables with a clause such as:

on market_share between mkt_share_min and mkt_share_max

HTH,

Brian
www.geocities.com/brianaltmann/olap.html

"Stefano" wrote: