It's the MicroStrategy metadata administrator. 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. The Intelligence Server is stopping and restarting with the new configuration. Once the process terminates, click on Close and then on Exit. 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. 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. 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.
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. 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. 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:.
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. Double-click on the Administrator user icon to open the User Editor. 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.
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.
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 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. 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.
Davide Moraschi is a Business Intelligence contractor and trainer. Born in Italy and married to a Japanese woman, he now lives in what is probably the hottest city in Europe, Seville. He can be reached at [email protected]. About this book Business intelligence is becoming more important by the day, with cloud offerings and mobile devices gaining wider acceptance and achieving better market penetration.
Publication date: October Publisher Packt. Pages ISBN Chapter 1. Getting Started with MicroStrategy. Note The operating system installation is outside the scope of this book; nevertheless, it is of vital importance that the machine where you will be doing the exercises is correctly configured and loaded with everything we will need.
Getting ready. How to do it MSI Copy. How it works There's more Through this book, you will develop the ability to think along the right lines and use more than one tool to perform analysis depending on the needs of your business. We start off by preparing you for data analytics. We then move on to teach you a range of techniques to fetch important information from various databases, which can be used to optimize your business. The book aims to provide a full end-to-end solution for an environment setup that can help you make informed business decisions and deliver efficient and automated BI solutions to any company.
It is a complete guide for implementing Business intelligence with the help of the most powerful tools like D3. Style and approach Packed with real-world examples, this pragmatic guide helps you polish your data and make informed decisions for your business. We cover both business and data analysis perspectives, blending theory and practical hands-on work so that you perceive data as a business asset. To this end, their work is structured into three parts.
As a key characteristic of the book, most of the topics are presented and illustrated using application tools. Specifically, a case study based on the well-known Northwind database illustrates how the concepts presented in the book can be implemented using Microsoft Analysis Services and Pentaho Business Analytics. All chapters are summarized using review questions and exercises to support comprehensive student learning. Overall, students, practitioners and researchers alike will find this book the most comprehensive reference work on data warehouses, with key topics described in a clear and educational style.
It turns data into reports for making and executing key organization decisions. It takes you from setting up and configuring MicroStrategy to security and administration. Register for intelligejce account and access leading-edge content on emerging technologies. It is a very solid reference book, however. App Inventor for Android. View our Cookie Policy. Whether you are a database developer, data analyst, or a business user, Business Intelligence with MicroStrategy Cookbook will get you up to speed with one of the most powerful BI platforms on the market with the smallest possible investment of time and money.
It also includes a number of videos warning: In order to derive maximum benefit for business, SAP must be understood well. Are you sure you want to claim this product using a token? Enter the code below and hit Verify. This book uses step-by-step instructions to teach you everything from the very inteelligence to the more advanced topics.
In the User Manual, they need to cover only implementation specific points. Data Warehouse and Query Language for Hadoop. Android Studio Application Development. Restricting rows — compare an attribute to another attribute.
Across platforms and various technologies. The videos are good, but compared to videos accompanying other BI books, audio and call-outs are lacking. Creating the metadata and configuring the Intelligence Server. What you will learn from this book Install a complete MicroStrategy server including a web interface Create a project and connect to a data warehouse Build reports, graphs, documents, dashboards, and interactive visualizations Configure and use MicroStrategy on mobile devices Add values to the data with month to date and year to date analyses Use In-Memory technology for instant results and data discovery Analyze data in the cloud with MicroStrategy Cloud Express Approach Written in a cookbook style, this book will teach you through the use of recipes with examples and illustrations.
Business Intelligence with MicroStrategy Cookbook covers the full cycle of a BI project with the MicroStrategy platform, from setting up the software to using dashboards in the cloud and on mobile devices. You do not need to be an SQL master to read this book, yet knowledge of some concepts like foreign keys and many-to-many relationships is assumed.
Modifying the logon account for the Intelligence Server. Written in a cookbook style, this book will teach you through the use intelliyence recipes with examples and illustrations. Your display name should be at least 2 characters long.
Get fast, free shipping with Amazon Prime. Business Intelligence with MicroStrategy Cookbook. Fast paced, concentrated introductions showing the quickest way to put the tool to work in the real world. Microstratrgy Android Application Development.
While the book accurately provides step-by-step instructions, what I missed are the concepts and best practices. Davide Moraschi is a Business Intelligence contractor and trainer.
0コメント