Instant MDX Queries for SQL Server 2012 -- Instant MDX Queries for SQL Server 2012 -- Credits -- About the Author -- About the Reviewers -- www.packtpub.com -- Support files, eBooks, discount offers and more -- packtlib.packtpub.com -- Why Subscribe? -- Free Access for Packt account holders -- 1. Instant MDX Queries for SQL Server 2012 -- So, what is MDX for SQL Server 2012? -- Installation -- Step 1 - identify which edition to use -- The Developer edition -- The Evaluation edition -- 32-bit or 64-bit -- Step 2 - review the requirements -- Step 3 - downloading the SQL Server 2012 trial edition -- Step 4 - installing the SQL Server 2012 -- Step 5 - installing the Data Warehouse -- Step 6 - installing the multidimensional models -- And that's it -- Quick start - writing your first MDX query -- Step 1 - open the SQL Server Management Studio and connect to the cube -- Step 2 - SELECT -- Axes -- Tuples -- Sets -- Step 3 - FROM -- Step 4 - WHERE -- Step 5 - comments -- Step 6 - your first MDX query -- Top 4 features you'll want to know about -- Using functions -- Basic keywords and functions -- It's all in the family -- Can you spare the time? -- Using Calculated Members and Named Sets -- Calculated Members -- Named Sets -- Calculations -- The calculation tab -- Add a new Calculated Member -- Add a new Named Set -- Writing for SSRS -- Create a Report Project -- Create a new report -- Create a data source -- Create a dataset -- Create a table -- The Months parameter -- DMVs -- People and places you should get to know -- Official Sites -- Articles and Tutorials -- Blogs -- Twitter.