OLAP & MDX

[javapenguin]

---

Does anyone here knows about OLAP & MDX?

[cold_fusion]

I know but I don't use.
Normal SQL here.

[javapenguin]

I know but I don't use.
Normal SQL here.

Can you recommend some site where I can learn? Or what books?

[cold_fusion]

Can you recommend some site where I can learn? Or what books?

Here: http://www.fing.edu.uy/inco/grupos/c...orio1-2005.pdf

[javapenguin]

Thanks cold_fusion, how come you just use SQL? Is it a waste of time if I learn MDX? What are the things MDX can do and SQL cannot do or vice versa?

[cold_fusion]

MDX is more powerful than sql. afaik, gamay ra ang software nga gasupport ani. but i think mssql have. easier ang iyang pagquery.
i don't use it kay wala pa koy apps nga need ani. as of now, sql can do all my reqmnts and daghan open src available.

[silent-kill]

mdx managed direct X?. onsa mana siya bro?.

[cold_fusion]

Multidimensional Expressions Query. Query language for OLAP (online analytical processing). Which returns results in multi-dimension unlike 2 dimensions for SQL.

It is mainly an enhancement to SQL.

Here is a good link that explains this http://en.wikipedia.org/wiki/Multidi...al_Expressions

[silent-kill]

aw ic thx bro.

[javapenguin]

Have you tried a java based OLAP engine called Mondrian?