To add to the 1st reply above :
1) You should know the syntax of MDX also how does it work.
2) What are the functions in MDX ?
3) You should also know how the cube is modeled which your querying ? What are the hierarchies, attributes, relationships ?
For more info, check out : www.mdxquery.com
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQLPlease visit... ApplyBI