Tuesday, March 17, 2009

MDX : MDX Tutorial , MDX Query , MDX Script , How to in MDX, MDX Select Query

I'm reading: MDX : MDX Tutorial , MDX Query , MDX Script , How to in MDX, MDX Select QueryTweet this !
I have seen developers searching for a last minute MDX query / script to create a calculated member on the cube. Many start in an organized fashion with a start from some simple MDX tutorial, and learning tuples, namedsets, axis, MDX Select Query Syntax etc... But still after that, many queries remain unsolved, and the real answer comes after a hands-on experience of some real-time project when one really starts applying functions, tweaking or nesting queries and parameters.

Any material found in MDX should be treasured. By far I have just seen 3-4 books on SSAS flavor of MDX. Below are the links to code-snippets which are FAQ's or used frequently while either querying the cube or creating calculated members on the cube.

Hope this helps all the last minute MDX requirements of those developers who don't have time to spend in learning all the syntax, structure and theory behing MDX syntax just to solve a little query or requirement on a cube in production or last-minute patch.
















Download MDX Tutorial - Code Snippets of Various FAQ Queries (PDF)



Download MDX Tutorial - Code Snippets of Error Handling (PDF)







Download MDX Tutorial - Cope Snippets SCOPE statement (PDF)

  1. MDX - How do you get Last month in the time dimension


  2. MDX - Query example that returns list of months from start of year up to specified month


  3. MDX - Query to show the first day of the last date month in the cube


  4. How in the report can I order date dimension members in descending order?


  5. MDX - query to get the last Month loaded into a cube


  6. MDX - Query to get the first month of the last year loaded into a cube


  7. MDX - How do you write query that uses execution date/time ( NOW() ) as a parameter?


  8. MDX - Query to get latest months and previous years same months data


  9. MDX - Query to show year level data for all years except last one, and month level data for last year


  10. MDX - How to create calculated member for AVG sales over last 3 years based on NOW()?


  11. MDX - How do I calculate sales for 12 Month to date?


  12. MDX - How can I get Last (Previous) Year to Date (YTD) values?


  13. MDX - Query to get count of months with sales amount > 0 in defined period


  14. MDX - How do you calculate monthly average of one year, optionally including empty months?


  15. MDX - How do you calculate monthly average of one year, optionally including empty months?

Download MDX Tutorial - Code Snippets for Time Dimension (PDF)



Content Host / Courtsey : SSAS-Info

1 comment:

Anonymous said...

Gracias por este magnífico post. Admirando el tiempo y el esfuerzo que puso en su blog y la información detallada que usted ofrece.

Related Posts with Thumbnails