provide me information about mdx

Question

hi every one 

can any body provide  any links to study MDX Expression i am new to SSAS

Thanks in advance

Sunil Yoganna

 

 

Answer 1

Hi Sunil,

Learning MDX is about more using it in your cubes & reports. For a start 

http://msdn.microsoft.com/en-us/library/ms145506(SQL.90).aspx

Best way is to build test cube and use SQL Profiler and observe the MDX that are send to Analysis server.

you can also use MDX Studio that gives you parse result for your query.MSDN is the best place to sart.

Regard

Avinob

---

We can't help everyone, but everyone can help someone. Ronald Reagan

Answer 2

Thanks Avinod

For giving the link to learn  MDX Expression if their is any other  information let me know

 

Thanks& Regard's

Sunil Yoganna

Answer 3

Here you go

http://www.fing.edu.uy/inco/grupos/csi/esp/Cursos/cursos_act/2005/DAP_SistDW/Material/2-SDW-Laboratorio1-2005.pdf

http://www.databasejournal.com/features/mssql/article.php/10894_1495511_3/MDX-at-First-Glance-Introduction-to-SQL-Server-MDX-Essentials.htm

http://msdn.microsoft.com/en-us/library/aa239637(VS.60).aspx

 

Hope it helps :)

Avi

---

We can't help everyone, but everyone can help someone. Ronald Reagan

Answer 4

MDX is totally different from the traditional T-SQL. I would suggest you buying a book from the beginning:

http://social.technet.microsoft.com/Forums/en-US/sqlanalysisservices/thread/3f3a0457-e8b4-4d50-acc9-98d38309e127

You can choose one book in above link, and then follow the book step by step.

 

Hope this helps,

Raymond

Answer 5

thanks Raymond

i will fallow the link

Regard's

Sunil Yoganna