Business Intelligence with MicroStrategy Cookbook

Connecting to a Vertica database

Introduction

Appendix D. HP Vertica

Connecting to a Hadoop database

Introduction

Appendix C. Cloudera Hadoop

Books

Blogs

Online resources

Appendix B. Where to Look for Information

Exercise 35

Exercise 34

Exercise 33

Exercise 32

Exercise 31

Exercise 30

Exercise 29

Exercise 28

Exercise 27

Exercise 26

Exercise 25

Exercise 24

Exercise 23

Exercise 22

Exercise 21

Exercise 20

Exercise 19

Exercise 18

Exercise 17

Exercise 16

Exercise 15

Exercise 14

Exercise 13

Exercise 12

Exercise 11

Exercise 10

Exercise 9

Exercise 8

Exercise 7

Exercise 6

Exercise 5

Exercise 4

Exercise 3

Exercise 2

Exercise 1

Appendix A. Solution to Exercises

Sharing a dashboard by e-mail

Refreshing dashboard data

Connecting to a RDBMS

Importing cross-tabbed data

Using filters

Importing Excel data

Creating an Express account

Introduction

Chapter 13. MicroStrategy Express

Using the network visualization

Exploring data with Visual Insight

Creating reports and documents based on a cube

Scheduling data refresh

Building a new cube

Creating a cube from an existing report

Introduction

Chapter 12. In-Memory Cubes and Visual Insight

Month-to-date and year-to-date transformations

Creating bands on metrics (custom groups banding)

Aggregating results with custom groups

Creating virtual attributes with consolidations

Introduction

Chapter 11. Consolidations Custom Groups and Transformations

When things go wrong

Adding notes and sharing

Sorting drilling and paging

Answering prompts in reports or documents

Introduction

Chapter 10. Mobile BI for Users

Linking from one document to another

Adding details with pop-up windows

Creating panel selectors

Adding panels to mobile documents

Using mobile views in documents

Adapting content to the iPad screen

Installing and configuring the mobile client

Setting up a mobile connection

Setting up the Mobile Server

Introduction

Chapter 9. Mobile BI for Developers

Using prompts as object selectors

Adding interactivity to filters using prompts

Changing the level of a metric filter

Restricting rows – evaluate on moving dates

Restricting rows – compare an attribute to another attribute

Introduction

Chapter 8. Dynamic Selection with Filters and Prompts

Switching to Adobe Flash mode

Embedding images HTML and links

Adding interactivity with panels and selectors

Using the editable mode to fine-tune the design

Stepping up to dashboards

Modifying the grouping in a document

Adding data to a document – the dataset

Creating your first "Hello World" document

Setting up MicroStrategy Web

Introduction

Chapter 7. Analysis on the Web – Documents and Dashboards

Conditional formatting with thresholds

Display multiple metrics with dual axis charts

Beautify your chart

Drag-and-drop objects using drop zones

Displaying both grid and graph in the same view

Introduction

Chapter 6. Data Analysis and Visualization – Graphs

Restricting results with view filters

Printing and exporting reports

Emphasizing numbers with conditional formatting

How to sort data in grids

Avoiding missteps – NULL values in facts

The bottom line – customizing subtotals

Dynamically adding and removing objects in reports

Manipulating grids – Pivot and page-by

Going deeper into data with drill down

Introduction

Chapter 5. Data Display and Manipulation – Reports

Creating a previous month metric (transformation)

Using Metric Join Type in reports

Embedding filters inside metrics

Grouping at a different level (level metrics)

Creating ranking metrics

Filters on metrics

Adding more facts

Understanding the GROUP BY clause

Using SQL View to inspect SELECT statements

Creating a simple counter fact and metric

Introduction

Chapter 4. Objects – Facts and Metrics

Filters on attributes

Parent-child relationship in a report

Creating an attribute-only report

Building Data Explorer Hierarchies

Selecting which forms are displayed

Other attribute forms

Parent-child relationship II

Parent-child relationship I

Using functions in an attribute form

Attribute forms – ID and DESC

Introduction

Chapter 3. Schema Objects – Attributes

Generating constants with SELECT statements

Using logical tables to create custom views

Modifying a table structure

Setting up a data warehouse connection and selecting tables

Creating an empty project

Introduction

Chapter 2. The First Steps in a MicroStrategy Project

Opening the MicroStrategy Desktop application

Creating the metadata and configuring the Intelligence Server

Modifying the logon account for the Intelligence Server

Creating ODBC DSN for metadata and data warehouse

Metadata and data warehouse

Registering the MicroStrategy License

Installing MicroStrategy Suite

Checking whether IIS is enabled and working

Installing the .NET Framework 4.0 and the 4.0.2 update

Setting up the AdventureWorks DW sample database

Installing SQL Server 2012 Command Line Utilities

Installing SQL Server Native Client 11.0

Installing SQL Server 2012 Express LocalDB

Introduction

Chapter 1. Getting Started with MicroStrategy

Preface

www.PacktPub.com

About the Reviewers

About the Author

Foreword

Credits

版权信息

封面

封面

版权信息

Credits

Foreword

About the Author

About the Reviewers

www.PacktPub.com

Preface

Chapter 1. Getting Started with MicroStrategy

Introduction

Installing SQL Server 2012 Express LocalDB

Installing SQL Server Native Client 11.0

Installing SQL Server 2012 Command Line Utilities

Setting up the AdventureWorks DW sample database

Installing the .NET Framework 4.0 and the 4.0.2 update

Checking whether IIS is enabled and working

Installing MicroStrategy Suite

Registering the MicroStrategy License

Metadata and data warehouse

Creating ODBC DSN for metadata and data warehouse

Modifying the logon account for the Intelligence Server

Creating the metadata and configuring the Intelligence Server

Opening the MicroStrategy Desktop application

Chapter 2. The First Steps in a MicroStrategy Project

Introduction

Creating an empty project

Setting up a data warehouse connection and selecting tables

Modifying a table structure

Using logical tables to create custom views

Generating constants with SELECT statements

Chapter 3. Schema Objects – Attributes

Introduction

Attribute forms – ID and DESC

Using functions in an attribute form

Parent-child relationship I

Parent-child relationship II

Other attribute forms

Selecting which forms are displayed

Building Data Explorer Hierarchies

Creating an attribute-only report

Parent-child relationship in a report

Filters on attributes

Chapter 4. Objects – Facts and Metrics

Introduction

Creating a simple counter fact and metric

Using SQL View to inspect SELECT statements

Understanding the GROUP BY clause

Adding more facts

Filters on metrics

Creating ranking metrics

Grouping at a different level (level metrics)

Embedding filters inside metrics

Using Metric Join Type in reports

Creating a previous month metric (transformation)

Chapter 5. Data Display and Manipulation – Reports

Introduction

Going deeper into data with drill down

Manipulating grids – Pivot and page-by

Dynamically adding and removing objects in reports

The bottom line – customizing subtotals

Avoiding missteps – NULL values in facts

How to sort data in grids

Emphasizing numbers with conditional formatting

Printing and exporting reports

Restricting results with view filters

Chapter 6. Data Analysis and Visualization – Graphs

Introduction

Displaying both grid and graph in the same view

Drag-and-drop objects using drop zones

Beautify your chart

Display multiple metrics with dual axis charts

Conditional formatting with thresholds

Chapter 7. Analysis on the Web – Documents and Dashboards

Introduction

Setting up MicroStrategy Web

Creating your first "Hello World" document

Adding data to a document – the dataset

Modifying the grouping in a document

Stepping up to dashboards

Using the editable mode to fine-tune the design

Adding interactivity with panels and selectors

Embedding images HTML and links

Switching to Adobe Flash mode

Chapter 8. Dynamic Selection with Filters and Prompts

Introduction

Restricting rows – compare an attribute to another attribute

Restricting rows – evaluate on moving dates

Changing the level of a metric filter

Adding interactivity to filters using prompts

Using prompts as object selectors

Chapter 9. Mobile BI for Developers

Introduction

Setting up the Mobile Server

Setting up a mobile connection

Installing and configuring the mobile client

Adapting content to the iPad screen

Using mobile views in documents

Adding panels to mobile documents

Creating panel selectors

Adding details with pop-up windows

Linking from one document to another

Chapter 10. Mobile BI for Users

Introduction

Answering prompts in reports or documents

Sorting drilling and paging

Adding notes and sharing

When things go wrong

Chapter 11. Consolidations Custom Groups and Transformations

Introduction

Creating virtual attributes with consolidations

Aggregating results with custom groups

Creating bands on metrics (custom groups banding)

Month-to-date and year-to-date transformations

Chapter 12. In-Memory Cubes and Visual Insight

Introduction

Creating a cube from an existing report

Building a new cube

Scheduling data refresh

Creating reports and documents based on a cube

Exploring data with Visual Insight

Using the network visualization

Chapter 13. MicroStrategy Express

Introduction

Creating an Express account

Importing Excel data

Using filters

Importing cross-tabbed data

Connecting to a RDBMS

Refreshing dashboard data

Sharing a dashboard by e-mail

Appendix A. Solution to Exercises

Exercise 1

Exercise 2

Exercise 3

Exercise 4

Exercise 5

Exercise 6

Exercise 7

Exercise 8

Exercise 9

Exercise 10

Exercise 11

Exercise 12

Exercise 13

Exercise 14

Exercise 15

Exercise 16

Exercise 17

Exercise 18

Exercise 19

Exercise 20

Exercise 21

Exercise 22

Exercise 23

Exercise 24

Exercise 25

Exercise 26

Exercise 27

Exercise 28

Exercise 29

Exercise 30

Exercise 31

Exercise 32

Exercise 33

Exercise 34

Exercise 35

Appendix B. Where to Look for Information

Online resources

Blogs

Books

Appendix C. Cloudera Hadoop

Introduction

Connecting to a Hadoop database

Appendix D. HP Vertica

Introduction

Connecting to a Vertica database