How do 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)
MDX – How do you calculate monthly average of one year, optionally including empty months?
Categorias:Functions
Comentários (0)
Trackbacks (0)
Deixe um comentário
Trackback