The definitive MicroStrategy blog
MicroStrategy 9
Field Report
Jun 21st
Last week I’ve attended a Free BI Class organized by MicroStrategy in Toronto, to see what’s new.
The presentation was really well planned – a mix of the usual sales pitch and a nice hands on web and desktop exercises.
Some new (at least to me) things that they’ve been working on are a great looking app for iPhone and some new geographic widgets, so heads up BigDataLabs. The app comes as no surprise, now that Apple no longer supports Flash. It takes advantage of the iPhone controls, including the G-sensor.
As a side note, there was a SAS training on the same floor as the Free BI Class, and the participants seemed to have a lot of fun in there, judging by their laughter. Our MSTR sales guy came with an awesome explanation – “Probably someone said it can be deployed in three months” 
Metadata Browser v2.0
Feb 10th
While the merge with Object Tracking Tool is still in development, I am proud to introduce the new and improved version of Metadata Browser, which you can download here: MBsetupV2.0.exe
Improved Documentation Tool
New properties are now retrieved for common object types:
- Metrics: dimensionality, condition, transformation, smart (yes/no)
- Attributes: form, lookup table, child & parent relations
- Filters: expression
- Prompts: item list
Change Journal Tools
This new function only works with MicroStrategy version 9.0 or higher and it either shows the Change Journal entries for a single object or for all the objects in a particular folder.
God Mode
If you have admin rights you can connect using “God Mode” and thus gain access to hidden system files. An interesting use (found during the test phase) is to navigate to System Objects\Columns and make dependency searches directly on Columns.
This is a read only application. Using it won’t cause any changes to your Metadata.
Application(s) is provided “as is” and MicroStrategy101 and individual application author(s) disclaim all warranties, whether express or implied, with respect to all provided items, including all warranties of merchantability, fitness for a particular purpose, accuracy, systems integration, title, satisfactory quality and non-infringement. MicroStrategy101 and individual application author(s) do not warrant that use of the provided items or any portion thereof will be uninterrupted or error-free, or that the provided items or any portion thereof will meet any need or requirement of licensee.
MSTR 9.0.1 (Release 2) and it’s New Features
Feb 5th
MicroStrategy 9 Release 2 (9.0.1 products) is now available on the download site.
What are the new features in MSTR 9 R2 (9.0.1)
1) Jump Start Project
2) MicroStrategy Health Center
1) JUMP-START PROJECT
What is the Jump-Start Project?
Jump-Start is a complete MicroStrategy project that comes with 7 dashboards and 30 reports and all the underlying metrics, filters, attributes, and dimensions. All you have to do is add data and rewire. It was designed with one purpose in mind – to help you develop a complete MicroStrategy Project FAST!
How does Jump-Start Work?
MicroStrategy’s Jump-Start Project provides the standard building blocks of any project, attributes and facts, and uses those objects to create application objects such as metrics, filters, reports, enterprise documents, and dashboards. Because a specific project has yet to be defined, all of these objects use generic names as placeholders. You redefine/rewire the attributes and facts so that they work off your data tables, and due to the object oriented design of MicroStrategy, the data will be cascaded into the pre-built reports and dashboards automatically. With all this work prebuilt, the Jump-Start project delivers a complete BI project in a matter of a few hours
Manuals are available in MicroStrategy site.
2) MicroStrategy Health Center
MicroStrategy Health Center allows users to prevent, diagnose and fix problems in a MicroStrategy system. It detects known problems and provides an immediate solution to many of them.
Health Center can email a system administrator if it encounters a problem with the system. In cases where Health Center cannot fix a problem immediately, it enables users to bundle relevant system information, such as log files, into a diagnostic package and transmit the package to MicroStrategy Technical Support for review and troubleshooting.
- MicroStrategy Health Center can only operate on MicroStrategy 9.0.1.
- By default, MicroStrategy Health Center is installed and turned off (not configured). To start configuring MicroStrategy Health Center, please see the tech note below:
- TN32554 How to Configure a MicroStrategy Health Center System
- If MicroStrategy Health Center is already configured, to learn more about what common tasks can be carried out, please see the tech note below:
- TN32552 How to use MicroStrategy Health Center Console
- For a List a Current System Checks:
- TN32551 A List of System Checks for MicroStrategy Health Center
- MicroStrategy is constantly extending the functionality of Health Center by developing new system checks and information collectors, and refining existing ones. To keep the Health Center System up to date:
- TN32553 How to keep the Health Center System up to date
Source: MicroStrategy’s Technical Email
Solution for not able to add tables in Warehouse Catalog
Dec 18th
Issue: Not able to add tables/views to the Schema in Warehouse Catalog
Error: ‘Error adding Table(s) to the schema. This key is already associated with an element of this collection’
Solution in MSTR 9:
1) Open ‘Architect’,
2) Right click the table <table name>
3) Add to the project
4) once its added, Right table in Left Pane and update structure
5) Save and close (it will ask for Update Schema, so do the same
6) Now open Warehouse Catalog
7) you can see the table/view added to schema
Recent Comments