Instant MDX Queries for SQL Server 2012. (2013)

• Record Type: Book
• Other Names: Emond, Nicholas
• Contents: Cover; Copyright; Credits; About the Author; About the Reviewers; www.packtpub.com; packtlib.packtpub.com; Table of Contents; 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 queryStep 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 sparse 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 sourceCreate a dataset; Create a table; The Months parameter; DMVs; People and places you should get to know; Official Sites; Articles and Tutorials; Blogs; Twitter.
• Publisher Details: Place of publication not identified : Packt Publishing
• Publication Date: 2013
• Extent: 1 online resource
• Subjects: 005.758; COMPUTERS -- Enterprise Applications -- Business Intelligence Tools; Client/server computing; Client/server computing; COMPUTERS -- Programming -- Microsoft; Electronic books
• Languages: English
• ISBNs: 1299832423; 9781299832428; 9781782178071; 1782178074; 9781782178064; 1782178066
• Notes: Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.