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!

Average number of days between purchases

Status
Not open for further replies.
pabloj

pabloj

Technical User
Jul 4, 2002
183
IT
Hi, I have a cube similar to Foodmart with 3 dimensions (Time, Invoice, Customer, Product) and I need to calculate the average number of days between two invoices for the same customer.
Could anyone suggest an MDX solution (calculated measure?) or shall I compute that outside of the cube and load it as an attribute of each customer and include it in virtual dimension?
Thanks in advance for any help

Stick to your guns
 
Status
Not open for further replies.

Similar threads

JP_Quinn
  • Locked
  • Question
Adding New Column to Dimension Table, Used in Other Cubes, Must I Update the Models of Other Cubes?
Replies
0
Views
197
JP_Quinn
JP_Quinn
victordba
  • Locked
  • Question
Wrong sorting order of Date dimension in Excel.
Replies
2
Views
122
victordba
victordba
Recce
  • Locked
  • Question
Is it possible to change the colour of the folders ?
Replies
0
Views
60
Recce
Recce
Pavel1234
  • Locked
  • Question
Sum of column instead of row
Replies
1
Views
51
MDXer
MDXer
eo
  • Locked
  • Question
No relationships between measures and dimensions - do I have any contr
Replies
1
Views
45
RiverGuy
RiverGuy

Part and Inventory Search

Sponsor

Back
Top