MDX FAQ

List of articles in category MDX FAQ
Title	Created Date	Author
Q: I have measure in my cube that shows duration on some event in seconds. How can I convert numeric result to string in the format hh:mm:ss?	2010-03-10	Written by Vidas Matelis
Q: How in MDX can I override formating for all calculated measures in one measure group?	2009-12-03	Written by Vidas Matelis
How to calculate YTD monthly average and compare it over several years for the same selected month	2008-07-14	Written by Thomas Ivarsson
MDX query for the count of customers for whom the earliest sale in the selected time period (2002 and 2003) occurred in a particular Product Category	2008-06-12	Written by Deepak Puri
How do I find the bottom 10 customers with the lowest sales in 2003 that were not null?	2008-05-30	Written by Thomas Ivarsson
How do I create a Rolling 12 Months Accumulated Sum that can show a trend without seasonal variations	2008-05-30	Written by Thomas Ivarsson
How do I group dimension members dynamically in MDX?	2008-05-29	Written by Thomas Ivarsson
How do I check for the top level in a dimension to avoid division by an nonexsting parent(-1.#INF)	2008-05-26	Written by Thomas Ivarsson
How do I check for division by zero and null to avoid -1.#INF in cells	2008-05-26	Written by Thomas Ivarsson
In an MDX query how can I get the top 3 sales years based on the order quantity?	2008-04-04	Written by Vidas Matelis

Page 1 of 6