I have following cube structure:
Dimensions: Item(item name), Date(year,month,date)
Measure: OnInventoryFrom(first date since was Item on warehouse)
What I need is to calculate number of days that is Item in warehouse till now(year,month,date). I need this as a new calcutaled member.
I am quite newbie in OLAP, so any help will be great!