latest price from fact table

[bittmapp]

I have a fact table with

prod_id
upd_date
price

i want to create a metric that will return the price for the product for the latest upd_date.

do i have to add a column to the table that indicates current price?

any ideas would be appreciated.

thanks,

bitt

 

[entaroadun]

Create a Price metric with dimensionality set to ReportLevel S/S and Update Date S/Ending(fact).

This will be slow! You should add a column.