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!

Register Log in
  • Congratulations strongm 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

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.

Similar threads

juanvg1972
  • Locked
  • Question
Problems linking dimension tables and fact tables in SSAS cube
Replies
0
Views
140
juanvg1972
juanvg1972
edvmat
  • Locked
  • Question
Error in the conversion sql query
Replies
2
Views
211
edvmat
edvmat
burakcan
  • Locked
  • Question
How to hide unwanted dimension values in SSAS cube
Replies
1
Views
263
Motlatjo
Motlatjo
burakcan
  • Locked
  • Question
How to rounding up to next integer value In MDX
Replies
0
Views
171
burakcan
burakcan
jbluedelta
  • Locked
  • Question
OLAP over HTTP and 503 error and connection time out
Replies
0
Views
171
jbluedelta
jbluedelta

Part and Inventory Search

Sponsor

Back
Top