Datediff in OLAP - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Datediff in OLAP


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!

Thanks

Pavel

Sign In or Register to comment.