Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Datediff in OLAP

Status
Not open for further replies.

Pavel1234

Programmer
Jan 26, 2010
3
CZ

Hi,
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top