Business Intelligence with MicroStrategy Cookbook -- Table of Contents -- Business Intelligence with MicroStrategy Cookbook -- Credits -- Foreword -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Getting Started with MicroStrategy -- Introduction -- Installing SQL Server 2012 Express LocalDB -- Getting ready -- How to do it... -- How it works... -- There's more... -- Installing SQL Server Native Client 11.0 -- Getting ready -- How to do it... -- How it works... -- There's more... -- Installing SQL Server 2012 Command Line Utilities -- Getting ready -- How to do it... -- There's more... -- Setting up the AdventureWorks DW sample database -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 1 -- Installing the .NET Framework 4.0 and the 4.0.2 update -- How to do it... -- How it works... -- Checking whether IIS is enabled and working -- Getting ready -- How to do it... -- How it works... -- There's more... -- Installing MicroStrategy Suite -- Getting ready -- How to do it... -- There's more... -- Registering the MicroStrategy License -- Getting ready -- How to do it... -- There's more.... -- Metadata and data warehouse -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating ODBC DSN for metadata and data warehouse -- Getting ready -- How to do it... -- How it works... -- There's more... -- Modifying the logon account for the Intelligence Server -- Getting ready -- How to do it... -- How it works... -- There's more...

Creating the metadata and configuring the Intelligence Server -- Getting ready -- How to do it... -- How it works... -- There's more... -- Opening the MicroStrategy Desktop application -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- 2. The First Steps in a MicroStrategy Project -- Introduction -- Creating an empty project -- Getting ready -- How to do it... -- How it works... -- There's more... -- Setting up a data warehouse connection and selecting tables -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 2 -- Exercise 3 -- Modifying a table structure -- Getting ready -- How to do it... -- How it works... -- Using logical tables to create custom views -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 4 -- Generating constants with SELECT statements -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- 3. Schema Objects - Attributes -- Introduction -- Attribute forms - ID and DESC -- Getting ready -- How to do it... -- How it works... -- There's more... -- Using functions in an attribute form -- Getting ready -- How to do it... -- How it works... -- There's more... -- Parent-child relationship I -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 5 -- Parent-child relationship II -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 6 -- Other attribute forms -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 7 -- Selecting which forms are displayed -- Getting ready -- How to do it... -- How it works... -- There's more... -- Building Data Explorer Hierarchies -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 8 -- Exercise 9 -- Exercise 10.

Creating an attribute-only report -- Getting ready -- How to do it... -- How it works... -- There's more... -- Parent-child relationship in a report -- Getting ready -- How to do it... -- How it works... -- There's more... -- Filters on attributes -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 11 -- See also -- 4. Objects - Facts and Metrics -- Introduction -- Creating a simple counter fact and metric -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 12 -- Exercise 13 -- Using SQL View to inspect SELECT statements -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 14 -- Understanding the GROUP BY clause -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 15 -- Adding more facts -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 16 -- Exercise 17 -- Exercise 18 -- Filters on metrics -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating ranking metrics -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 19 -- Grouping at a different level (level metrics) -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 20 -- Embedding filters inside metrics -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 21 -- Using Metric Join Type in reports -- Getting ready -- How to do it... -- How it works... -- There's more... -- More Info -- Creating a previous month metric (transformation) -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 22 -- See also -- 5. Data Display and Manipulation - Reports -- Introduction -- Going deeper into data with drill down -- Getting ready -- How to do it... -- How it works... -- There's more...

More Info -- Manipulating grids - Pivot and page-by -- Getting ready -- How to do it... -- How it works... -- There's more... -- Dynamically adding and removing objects in reports -- Getting ready -- How to do it... -- How it works... -- There's more... -- More Info -- The bottom line - customizing subtotals -- Getting ready -- How to do it... -- How it works... -- There's more... -- More Info -- Avoiding missteps - NULL values in facts -- Getting ready -- How to do it... -- How it works... -- There's more... -- How to sort data in grids -- Getting ready -- How to do it... -- How it works... -- There's more... -- Sorting NULLs -- Emphasizing numbers with conditional formatting -- Getting ready -- How to do it... -- How it works... -- There's more... -- Printing and exporting reports -- Getting ready -- How to do it... -- How it works... -- There's more... -- Restricting results with view filters -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 23 -- See also -- 6. Data Analysis and Visualization - Graphs -- Introduction -- Displaying both grid and graph in the same view -- Getting ready -- How to do it... -- How it works... -- There's more... -- More Info -- Drag-and-drop objects using drop zones -- Getting ready -- How to do it... -- How it works... -- There's more... -- Beautify your chart -- Getting ready -- How to do it... -- How it works... -- There's more... -- Display multiple metrics with dual axis charts -- Getting ready -- How to do it... -- How it works... -- There's more... -- Conditional formatting with thresholds -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 24 -- See also -- 7. Analysis on the Web - Documents and Dashboards -- Introduction -- Setting up MicroStrategy Web -- Getting ready -- How to do it... -- How it works... -- There's more... -- More Info.

Creating your first "Hello World" document -- Getting ready -- How to do it... -- How it works... -- There's more... -- Adding data to a document - the dataset -- Getting ready -- How to do it... -- How it works... -- There's more... -- Modifying the grouping in a document -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 25 -- Stepping up to dashboards -- Getting ready -- How to do it... -- How it works... -- There's more... -- Using the editable mode to fine-tune the design -- Getting ready -- How to do it... -- How it works... -- There's more... -- Adding interactivity with panels and selectors -- Getting ready -- How to do it... -- How it works... -- There's more... -- Embedding images, HTML, and links -- Getting ready -- How to do it... -- How it works... -- There's more... -- Switching to Adobe Flash mode -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- 8. Dynamic Selection with Filters and Prompts -- Introduction -- Restricting rows - compare an attribute to another attribute -- Getting ready -- How to do it... -- How it works... -- There's more... -- Exercise 26 -- Restricting rows - evaluate on moving dates -- Getting ready -- How to do it... -- How it works... -- There's more... -- More Info -- Exercise 27 -- Changing the level of a metric filter -- Getting ready -- How to do it... -- How it works... -- There's more... -- Adding interactivity to filters using prompts -- Getting ready -- How to do it... -- How it works... -- There's more... -- More Info -- Using prompts as object selectors -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- 9. Mobile BI for Developers -- Introduction -- Setting up the Mobile Server -- Getting ready -- How to do it... -- How it works... -- There's more... -- Setting up a mobile connection.

Getting ready.