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

Opening the MicroStrategy Desktop application


The platform is all set. We now have a brand new MicroStrategy Server up and running, but we don't have any projects yet.

This may be a good time to save your work and store a backup of the Windows machine, just in case. If you are running a virtual environment, a snapshot of the VM would be perfect.

The MicroStrategy Desktop application is the development tool to generate projects, objects, reports, and so on. It is also used to explore and manage the objects that reside in the metadata. From now on, we'll spend the major part of our time in this IDE.

It's not difficult to get used to the interface as it is fairly simple, much like the Windows Explorer you have folders on the left and details on the right.

Getting ready

You need to have completed the previous recipe to continue.

How to do it...

Let's open the Desktop application:

  1. Go to Start | All Programs | MicroStrategy | Desktop and click on the Desktop icon.

  2. Double-click on the line named MicroStrategy Analytics Modules, which was created by the setup and you'll be prompted for the metadata credentials; remember? The user is Administrator with no password.

  3. The first time you connect, a message will remind you that no project is there, click on OK. We'll create one in a moment.

  4. When you enter the MicroStrategy Analytics Modules (we call this a project source) for the first time, you'll be watching a window like the one in the following screen capture:

  5. Unfold the Administration folder and click on User Manger on the left pane. Then double-click on Everyone on the right pane. You will see there is only a user in this group.

  6. Double-click on the Administrator user icon to open the User Editor.

  7. Here, you can manage all the details of a user such as full name, login, password, or permission to see projects and which features the user has access to. There are two text fields for password with asterisks, type a new password here and confirm. Then close the editor by clicking on OK.

  8. Exit the Desktop application and open it again. This time you will be prompted for credentials to enter the MicroStrategy Analytics Modules, type Administrator and the password you just created.

How it works...

At the top-most level of the folder tree in MicroStrategy Desktop application there are the project sources, think of them as a shortcut to the Metadata. A project source is just a way for MicroStrategy to know where the Intelligence Server is running and how to connect to it.

The Administration folder is where all the administrative tasks are performed in the Desktop application, and you can see this because you've entered the application with an admin account.

There's more...

There are two types of project source, two-tiers (Direct) and three-tiers (Intelligence Server). Two-tiered project sources connect directly to the metadata database, while three-tiered first connect to an Intelligence Server, which in turn connects to the metadata.

Now that the administrative account is secured, if you forget this password, all of your work will be lost. Ouch! Really? Yes, exactly, please remember: there is no way known to humans to recover a metadata lost password. Only MicroStrategy Support can do this: I never dared to ask them to, so please take my work and be sure not to forget it.

Note

You can watch a screencast of this operation at:

See also

  • The Creating an empty project recipe in Chapter 2, The First Steps in a MicroStrategy Project

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