All posts by Tiwari Ashish

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

Data Modelling questions


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

Goal Alignment queries:

  • What is the strategic goal of the organization that is being addressed by this particular activity?
  • What organizational mission/vision does it relate to?
  • Do we have a hypothesis as to how this initiative will eventually improve results / performance (i.e. a strategy map)?

Baseline queries:

  • What is the existing level of performance? Do we know or have the capability to know (monitoring capability)?
  • Are we collecting this data and storing it somewhere?
  • What are the statistical parameters of this data, e.g. how much random variation does it contain? Are we measuring this?

Cost and risk queries:

  • What is the existing cost of present operations?
  • How much will that increase when we go ahead with the initiative?
  • What is the risk that this cost will be exceeded or achieved? Have we performed a similar sensitivity analysis on this?
  • Is the money being spent on this preset initiative the best use of the funds, or is there a better alternative usage?
  • What is the risk that the initiative will fail? Has this assessment been included in the planning?

Customer and Stakeholder queries:

  • Have you listed all the communities of interest that have a stake in this present initiative?
  • Who are the kinds of customers/stakeholders who will benefit directly from this initiative? Who will benefit indirectly? What are the quantitative / qualitative benefits?
  • Is the specified initiative the best way to increase satisfaction for all kinds of customers, or is there a better way?
  • How will we know that the initiative benefits these customers?

Metrics related queries:

  • What metrics will be used to define the benefit?
  • Are these the best metrics? How do we know that?
  • How many metrics need to be tracked? If this is a large number (it usually is), what kind of system are you planning to use to track them?
  • Are the metrics standardized, so they can be benchmarked against performance in other organizations? What are the industry standard metrics available?

Measurement Methodology related queries:

  • How will the metrics be measured? What methods will be used, and how frequently will data be collected? Are there any industry standards for this?
  • Is this the best way to do the measurements? How do we know that?

Results related queries:

  • How can we demonstrate that this strategic initiative, and not something else, contributed to a change in results?
  • How much of the change was probably random?