Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Business Intelligence with MicroStrategy Cookbook

You're reading from   Business Intelligence with MicroStrategy Cookbook Over 90 practical, hands-on recipes to help you build your MicroStrategy business intelligence project, including more than a 100 screencasts with this book and ebook

Arrow left icon
Product type Paperback
Published in Oct 2013
Publisher Packt
ISBN-13 9781782179757
Length 356 pages
Edition 1st Edition
Arrow right icon
Author (1):
Arrow left icon
Davide Moraschi Davide Moraschi
Author Profile Icon Davide Moraschi
Davide Moraschi
Arrow right icon
View More author details
Toc

Table of Contents (25) Chapters Close

Business Intelligence with MicroStrategy Cookbook
Credits
Foreword
About the Author
About the Reviewers
www.PacktPub.com
Preface
1. Getting Started with MicroStrategy 2. The First Steps in a MicroStrategy Project FREE CHAPTER 3. Schema Objects – Attributes 4. Objects – Facts and Metrics 5. Data Display and Manipulation – Reports 6. Data Analysis and Visualization – Graphs 7. Analysis on the Web – Documents and Dashboards 8. Dynamic Selection with Filters and Prompts 9. Mobile BI for Developers 10. Mobile BI for Users 11. Consolidations, Custom Groups, and Transformations 12. In-Memory Cubes and Visual Insight 13. MicroStrategy Express Solution to Exercises Where to Look for Information Cloudera Hadoop HP Vertica Index

Creating the metadata and configuring the Intelligence Server


The metadata consists of a series of tables that MicroStrategy uses to store information about projects and the objects that build up those projects. In one of the previous recipes, we created the empty metadata database and now we will start populating it.

Getting ready

You need to have completed the previous recipe to continue.

How to do it...

To create the metadata, do the following:

  1. You should already have the configuration wizard open in the background; if you closed it, you can find it in Start | All Programs | MicroStrategy. Click on Configuration Wizard to run it.

  2. In the first page of the wizard, the first option should already be selected, so click on Next.

  3. In this phase of the project, we're not interested in the history list or statistics, so we uncheck the corresponding checkboxes and leave just the first one checked. Then click on Next.

  4. Now we are telling the wizard where to look for the metadata database, you should have a list of all the system DSNs present in the machine, select the metadata DSN that we created before, click on Next and on Finish.

  5. The wizard starts creating and populating metadata tables. When the process is completed, click on Close to go back to the starting page of the wizard.

  6. The second option Configure Intelligent Server should be automatically selected, click on Next and again select the metadata DSN from the drop-down list and click on Next.

  7. When you're prompted for the username and password leave everything as default, the Administrator user still has no password, and click on Next.

    Note

    This Administrator user here has nothing to do with the operating system. It's the MicroStrategy metadata administrator.

  8. Watch the wizard as it tries to connect to the recently created metadata and when the Server Definitions page appears just hit Next and Next again, as we will use all the default settings.

  9. In the SSL Configuration page, leave the checkbox unchecked; click on Next and on Finish.

  10. The Intelligence Server is stopping and restarting with the new configuration. Once the process terminates, click on Close and then on Exit.

We're ready to start up the Desktop application.

How it works...

The Intelligence Server definition is stored in the metadata. The wizard populates the tables with default values such as the server port and the administrator password. The Intelligence Server service then, reads the metadata when starting up, to retrieve all this information. There can be only one active metadata at a time. You may have different versions of it, but only one in use. To switch from one metadata to another, you need to run the configuration wizard again.

There's more...

Needless to say, the backup of the metadata is very important. If you lose this database, you lose every project in it.

You could also create a metadata in an MS Access database, if you want. For small projects or demos, this helps moving it around just by copying the MDB file.

Note

You can watch screencasts of this operation at:

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image