MDX

Using the MDX language.

Testing queries

It can be useful to test MDX queries against a known good data set. In this way, you can better isolate whether the error is due to the data, the query or even a bug in the OLAP/display engine.

The FoodMart schema and database is used across the industry for demonstrations and testing. Mondrian has its own variant. Set up the schema files and data set to start using it.

If you're seeing problems in your results, try and re-create the issue with the FoodMart schema. It can also come in handy if you don't have access to the source data.

Number format

The number format used by Mondrian is the same as used by Visual Basic. You can find a guide to the syntax here.

Resources

• Analysis Services Cheat Sheets