book

Business Intelligence with MicroStrategy Cookbook

Name: Business Intelligence with MicroStrategy Cookbook
Author: Davide Moraschi
ISBN: 9781782179757

by Davide Moraschi

October 2013

Intermediate to advanced

356 pages

English

Packt Publishing

Read now

Unlock full access

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 moreWhy Subscribe?Free Access for Packt account holdersInstant 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 codeErrataPiracyQuestions
1. Getting Started with MicroStrategy
Introduction
Installing SQL Server 2012 Express LocalDB
Getting readyHow to do it...How it works...There's more...
Installing SQL Server Native Client 11.0
Getting readyHow to do it...How it works...There's more...
Installing SQL Server 2012 Command Line Utilities
Getting readyHow to do it...There's more...
Setting up the AdventureWorks DW sample database
Getting readyHow 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 readyHow to do it...How it works...There's more...
Installing MicroStrategy Suite
Getting readyHow to do it...There's more...
Registering the MicroStrategy License
Getting readyHow to do it...There's more....
Metadata and data warehouse
Getting readyHow to do it...How it works...There's more...
Creating ODBC DSN for metadata and data warehouse
Getting readyHow to do it...How it works...There's more...
Modifying the logon account for the Intelligence Server
Getting readyHow to do it...How it works...There's more...
Creating the metadata and configuring the Intelligence Server
Getting readyHow to do it...How it works...There's more...
Opening the MicroStrategy Desktop application
Getting readyHow 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 readyHow to do it...How it works...There's more...
Setting up a data warehouse connection and selecting tables
Getting readyHow to do it...How it works...There's more...Exercise 2Exercise 3
Modifying a table structure
Getting readyHow to do it...How it works...
Using logical tables to create custom views
Getting readyHow to do it...How it works...There's more...Exercise 4
Generating constants with SELECT statements
Getting readyHow to do it...How it works...There's more...See also
3. Schema Objects – Attributes
Introduction
Attribute forms – ID and DESC
Getting readyHow to do it...How it works...There's more...
Using functions in an attribute form
Getting readyHow to do it...How it works...There's more...
Parent-child relationship I
Getting readyHow to do it...How it works...There's more...Exercise 5
Parent-child relationship II
Getting readyHow to do it...How it works...There's more...Exercise 6
Other attribute forms
Getting readyHow to do it...How it works...There's more...Exercise 7
Selecting which forms are displayed
Getting readyHow to do it...How it works...There's more...
Building Data Explorer Hierarchies
Getting readyHow to do it...How it works...There's more...Exercise 8Exercise 9Exercise 10
Creating an attribute-only report
Getting readyHow to do it...How it works...There's more...
Parent-child relationship in a report
Getting readyHow to do it...How it works...There's more...
Filters on attributes
Getting readyHow to do it...How it works...There's more...Exercise 11See also
4. Objects – Facts and Metrics
Introduction
Creating a simple counter fact and metric
Getting readyHow to do it...How it works...There's more...Exercise 12Exercise 13
Using SQL View to inspect SELECT statements
Getting readyHow to do it...How it works...There's more...Exercise 14
Understanding the GROUP BY clause
Getting readyHow to do it...How it works...There's more...Exercise 15
Adding more facts
Getting readyHow to do it...How it works...There's more...Exercise 16Exercise 17Exercise 18
Filters on metrics
Getting readyHow to do it...How it works...There's more...
Creating ranking metrics
Getting readyHow to do it...How it works...There's more...Exercise 19
Grouping at a different level (level metrics)
Getting readyHow to do it...How it works...There's more...Exercise 20
Embedding filters inside metrics
Getting readyHow to do it...How it works...There's more...Exercise 21
Using Metric Join Type in reports
Getting readyHow to do it...How it works...There's more...More Info
Creating a previous month metric (transformation)
Getting readyHow to do it...How it works...There's more...Exercise 22See also
5. Data Display and Manipulation – Reports
Introduction
Going deeper into data with drill down
Getting readyHow to do it...How it works...There's more...More Info
Manipulating grids – Pivot and page-by
Getting readyHow to do it...How it works...There's more...
Dynamically adding and removing objects in reports
Getting readyHow to do it...How it works...There's more...More Info
The bottom line – customizing subtotals
Getting readyHow to do it...How it works...There's more...More Info
Avoiding missteps – NULL values in facts
Getting readyHow to do it...How it works...There's more...
How to sort data in grids
Getting readyHow to do it...How it works...There's more...Sorting NULLs
Emphasizing numbers with conditional formatting
Getting readyHow to do it...How it works...There's more...
Printing and exporting reports
Getting readyHow to do it...How it works...There's more...
Restricting results with view filters
Getting readyHow to do it...How it works...There's more...Exercise 23See also
6. Data Analysis and Visualization – Graphs
Introduction
Displaying both grid and graph in the same view
Getting readyHow to do it...How it works...There's more...More Info
Drag-and-drop objects using drop zones
Getting readyHow to do it...How it works...There's more...
Beautify your chart
Getting readyHow to do it...How it works...There's more...
Display multiple metrics with dual axis charts
Getting readyHow to do it...How it works...There's more...
Conditional formatting with thresholds
Getting readyHow to do it...How it works...There's more...Exercise 24See also
7. Analysis on the Web – Documents and Dashboards
Introduction
Setting up MicroStrategy Web
Getting readyHow to do it...How it works...There's more...More Info
Creating your first "Hello World" document
Getting readyHow to do it...How it works...There's more...
Adding data to a document – the dataset
Getting readyHow to do it...How it works...There's more...
Modifying the grouping in a document
Getting readyHow to do it...How it works...There's more...Exercise 25
Stepping up to dashboards
Getting readyHow to do it...How it works...There's more...
Using the editable mode to fine-tune the design
Getting readyHow to do it...How it works...There's more...
Adding interactivity with panels and selectors
Getting readyHow to do it...How it works...There's more...
Embedding images, HTML, and links
Getting readyHow to do it...How it works...There's more...
Switching to Adobe Flash mode
Getting readyHow 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 readyHow to do it...How it works...There's more...Exercise 26
Restricting rows – evaluate on moving dates
Getting readyHow to do it...How it works...There's more...More InfoExercise 27
Changing the level of a metric filter
Getting readyHow to do it...How it works...There's more...
Adding interactivity to filters using prompts
Getting readyHow to do it...How it works...There's more...More Info
Using prompts as object selectors
Getting readyHow to do it...How it works...There's more...See also
9. Mobile BI for Developers
Introduction
Setting up the Mobile Server
Getting readyHow to do it...How it works...There's more...
Setting up a mobile connection
Getting readyHow to do it...How it works...There's more...
Installing and configuring the mobile client
Getting readyHow to do it...How it works...There's more...More Info
Adapting content to the iPad screen
Getting readyHow to do it...How it works...There's more...Exercise 28
Using mobile views in documents
Getting readyHow to do it...How it works...There's more...Exercise 29
Adding panels to mobile documents
Getting readyHow to do it...How it works...There's more...
Creating panel selectors
Getting readyHow to do it...How it works...There's more...
Adding details with pop-up windows
Getting readyHow to do it...How it works...There's more...
Linking from one document to another
Getting readyHow to do it...How it works...There's more...See also
10. Mobile BI for Users
Introduction
Answering prompts in reports or documents
Getting readyHow to do it...How it works...There's more...
Sorting, drilling, and paging
Getting readyHow to do it...How it works...There's more...
Adding notes and sharing
Getting readyHow to do it...How it works...There's more...
When things go wrong
Getting readyHow to do it...How it works...There's more...See also
11. Consolidations, Custom Groups, and Transformations
Introduction
Creating virtual attributes with consolidations
Getting readyHow to do it...How it works...There's more...More InfoExercise 30
Aggregating results with custom groups
Getting readyHow to do it...How it works...There's more...More InfoExercise 31
Creating bands on metrics (custom groups banding)
Getting readyHow to do it...How it works...There's more...Exercise 32
Month-to-date and year-to-date transformations
Getting readyHow to do it...How it works...There's more...Exercise 32See also
12. In-Memory Cubes and Visual Insight
Introduction
Creating a cube from an existing report
Getting readyHow to do it...How it works...There's more...
Building a new cube
Getting readyHow to do it...How it works...There's more...
Scheduling data refresh
Getting readyHow to do it...How it works...There's more...
Creating reports and documents based on a cube
Getting readyHow to do it...How it works...There's more...
Exploring data with Visual Insight
Getting readyHow to do it...How it works...There's more...
Using the network visualization
Getting readyHow to do it...How it works...There's more...Exercise 34See also
13. MicroStrategy Express
Introduction
Creating an Express account
Getting readyHow to do it…How it works…There's more…
Importing Excel data
Getting readyHow to do it…How it works…There's more…
Using filters
Getting readyHow to do it…How it works…There's more…
Importing cross-tabbed data
Getting readyHow to do it…How it works…There's more…
Connecting to a RDBMS
Getting readyHow to do it…How it works…There's more…Exercise 35
Refreshing dashboard data
Getting readyHow to do it…How it works…There's more…
Sharing a dashboard by e-mail
Getting readyHow to do it…How it works…There's more…Sharing from the free accountSee also
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
B. Where to Look for Information
Online resources
Blogs
Books
C. Cloudera Hadoop
Introduction
Connecting to a Hadoop database
Getting readyHow to do it...How it works...There's more...See also
D. HP Vertica
Introduction
Connecting to a Vertica database
Getting readyHow to do it...How it works...There's more...See also
Index

Content preview from Business Intelligence with MicroStrategy Cookbook

Installing SQL Server Native Client 11.0

After installing the SQL engine, we need to load the last version of the client in order to access the local instance.

Getting ready

You need to have completed the previous recipe to continue.

How to do it...

Here's how to run the installation, in a command prompt window:

Install SQL Server Native Client 11.0 by running:
```
C:\install\sqlncli.msi
```
Leave the default components selected for installation and click on Next until the end. As before, give the user account control permission to continue.

How it works...

We are forced to install this version of the client, as previous native clients are not able to connect to the LocalDB engine.

There's more...

Check successful outcome by clicking on Start | Administrative ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Mastering Business Intelligence with MicroStrategy

Publisher Resources

ISBN: 9781782179757Other

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills