Keys and Levels in MicroStrategy


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
Administration, Architect, MicroStrategy, ,

Table keys are the lowest level attributes in their respective hierarchies that are present in the logical table.

Fact entry levels are the lowest attribute levels at which a fact exists. The fact entry levels correspond to the lowest-level table key attributes for all the tables that define the fact.

A fact is only extended if a join does not exist between a fact table and the attribute to which the fact will extend to, i.e. the fact does not exist at the level of that attribute.

MicroStrategy SQL Generation Engine is sensitive to differences between its internal state and the states of metadata objects, there is a risk of SQL generation failures if schema modifications take place during normal user activity. In general, it is not recommended to perform schema updates during periods of normal or high usage. Schema changes should normally be reserved for periods of little to no user activity.

3rd Compnay to purchase MicroStrategy in India


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
MicroStrategy Inc

There are just two companies  that use MicroStrategy. Wipro ePeripherals (Not Wipro Software) and Ashok Layland. Wipro license is of 7.2 and it is expired and they are not sure to purchase latest version of MicroStrategy. ALL is still using MicroStrategy.

Now Pentaloon Retail is the latest purchaser of MicroStrategy and Mudra Garment is an unconfirmed buyer. I’ll update the information as and when available.

What’s new in next version of MicroStrategy 9.0 (Orion)


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
MicroStrategy 9
  1. Connect to two different warehouse in same report but Free form SQL report won’t be having this feature.
  2. RS document not to lose derived metric or object prompt in the included report.
  3. Track object changes by user name, from which machine, IP address, etc. (change audit)
  4. Drilling in RS document. A new mode for RS document to accomplish this feature.
  5. Drill to multiple objects.
  6. ACL control in web but not so well as in desktop.
  7. Prompt and filter creation in web.
  8. In web, when drilled to a template, prompt in template will be executed. Currently, it happens only in Desktop.
  9. I-Server metadata and NCS metadata will be part of same database.
  10. Intelligent cube can be controlled by end user.
  11. On-fly custom group creation feature called Derived Element.
  12. **Monitor** cache, projects, cluster, jobs, user connection, and similarly. These users can’t edit, modify or create.
  13. Rules creation “what to do” when History List is full.
  14. Explicit RS Document **caching** not just containing reports

MicroStrategy Business Objects Cognos comparision


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
MicroStrategy

Single Metadata – Object definition is stored in a database (called metadata), How easy is changes to be integrated made from one interface to another.

64 Bit support – 32 bit system can’t address more than 4 GB of system space. All non-Windows OS are available in 64 bit for ages. Windows also got it in June 2005, but BI vendor should be able to support 64 bit OS.Scalability – Any calculation performed in database is the best and fast and let very small load on the BI architecture. But not all BI vendors let it happen.

Reusable Objects – Make once use zillion times.Objects Version Control – Ability to have different version of same (schema) objects.

WYSIWYG – Look and feel of what you created and finally how it looks.Security – Object, User security.

Personalization – Single report but show different output to different users.

Manual fine-tuning SQL – Easily making changes to generated SQL.Ease of SQL Generation – Make Schema object and system and forget about the right SQL generation.

MS Office integration – Run report directly from Word, Excel or Powerpoint.

(There is some bug with HTML parser on Blogger.com. Please scroll down for the comparison table. Do write into your comments. I’d update/add more information accordingly)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  MicroStrategy Business Objects Cognos
Single Metadata Yes No No
64 Bit support Very Good Good Good
Scalability Excellent Good Very Good
Reusable bjects Excellent Good Good
Objects Version Control Very Bad Excellent Very Good
WYSIWYG Very Good Very Good Very Good
Security Very Good Good Very Good
Personalization Very Good Good Bad
Manual fine-tuning SQL Good Excellent Excellent
Ease of SQL generation Excellent Very Good Very Good
MS Office integration Very Good Bad Good
Learning Curve Bad Very Good Very Good
Number of Clients 10000 42000 23000
Number of Employees 2000 NA 3500
Cost of License $$$$$ $$ $$$
Support Cost $$$$$ $$$ $$$
Average Pay (USD)## 83000 78000 79000
Job Security Good Excellent Very Good
Cost of License $$$$$ $$ $$$
Support Cost $$$$$ $$$ $$$

## – indeed.com