- Business Intelligence with MicroStrategy Cookbook
- Davide Moraschi
- 380字
- 2021-07-23 15:32:00
Creating an empty project
The first step in a MicroStrategy BI application is creating an empty project. An Intelligence Server can host many projects. Projects can be copied from one Intelligence Server to another. Think of a project as a way to keep all the related objects together. A project must have at least one connection to get data from the data warehouse.
Getting ready
You need to have completed the previous chapter to continue.
How to do it...
In this first recipe we'll create a project:
- Open Start | All Programs | MicroStrategy | Desktop menu and click on the Desktop icon.
- Log in with
Administratorand the corresponding password and right-click on the topmost folder named MicroStrategy Analytics Modules. - From the context menu that appears, select Create New Project....
- In the Project Creation Assistant, click on Create project.
- Type a name in the first textbox, for example,
COOKBOOKand click on OK. We accept all the defaults for now. Once the wizard terminates creating the project, you're back to the Project Creation Assistant. - Click on OK and then on OK again when the information message appears.
- Double-click on the project icon and look at the folders that are contained in it. You will see that there is one named Schema Objects and another one named My Personal Objects.
- Expand the Schema Objects folder and click on Tables. Our journey starts here.
How it works...
A project is nothing more than rows in a table of the metadata. If you're curious, you can have a look at the metadata database with sqlcmd, the main table is called DSSMDOBJINFO. Be careful not to tamper with it, you may lose a little more than one hour of work.
There's more...
If you're not happy with the project name, you may change it with the F2 key just like renaming a file or a folder.
Just out of curiosity, if you want to see more behind-the-scene objects, you can click on the Tools | Desktop Preferences menu and select the Browsing category in the Desktop Preferences dialog.
Check the Display hidden objects box, this will show more folders that were not visible before, such as the profiles or the project templates.
- 金融科技（FinTech）發展的國際經驗和中國政策取向（中國金融四十人論壇書系）
- 新形勢下中國投入產出核算的變革與實踐
- 基于價值增值的治理導向型內部審計研究
- VMware vCloud Director Essentials
- 中國特色社會主義國家審計制度研究
- Learning Informatica PowerCenter 9.x
- 企業能源審計與節能規劃
- 非線性經濟關系的建模
- 陜西國家統計調查專題研究集萃（2006—2015）
- 財務建模與綜合估值：數據研磨、模型校準、動態估值
- OAuth 2.0 Identity and Access Management Patterns
- 中國政府統計問題研究
- 審計全流程實操從入門到精通
- Programming Microsoft Dynamics NAV（Fifth Edition）
- 企業并購審查中的相關市場界定：理論與案例