Monthly Archives: January 2010

Free Reporting Suite has changed fate of MicroStrategy


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

I receive a lot of emails from all over the world who wish to learn MicroStrategy and some long lost friends have come asking about learning MicroStrategy. Also the curiosity of learning MicroStrategy have increased in some two quarter. This is based on my emails I receive, comments received on the blog,  my MicroStrategy forum, forum on Orkut and some other communities too. 6 months back big number of Fortune 100 companies were going down and MicroStrategy 9 seemed to have not big bang for MicroStrategy, Inc. But the FRT has simply changed the way MicroStrategy Inc ‘s future is going to take shape. Though it does mean drastic loss of revenue per license sold, but finally MicroStrategy Inc have realized they can’t continue being $$$ greedy for long. They have survived for 2 decades, but if they would have had remained same, they wouldn’t have been able to stay in BI market for long. I know the Fortune-100 companies will not let MicroStrategy Inc die as 90 out of them use MicroStrategy as the primary BI investment or only BI tool.

Coming back to fate change. I don’t see MicroStrategy Inc trying to capitalize on fresh availability of MicroStrategy professionals in job market. FRT has led to thousand of clients of seeing/trying MicroStrategy clients for the first time and realizing what were they missing for so many years. BO and Cognos are piece of crap in front of MSTR. They don’t match anything except the ease of development, but that leads to several other complexities in case of BO/Cognos too. I mean, metadata syncing.. never ever heard of that. :roll:

A bigger picture would become by Q1  2010. MicroStrategy World 2010 is due in a week and majority of sales lead would be getting closed by end of Q1 2010. I hope they are really doing good. (I do not consider myself good in doing anything other than MicroStrategy 😯 )

P.S. This is just thought that came in my mind. Blog topic doesn’t go with the blog post. :(

“Outer Join” in MicroStrategy


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

During the past few weeks, I was confronted with many interesting tasks of the MicroStrategy world. And once again I had to annoy me about the fact that there is no clever way to MicroStrategy, an outer join between the attributes to be generated.

In Menu Data / Data Options / Calculations / attribute – join method can be adjusted, although, as the connection is to be made between the attributes, but these settings will lead to a difficult to understand SQL, the unexpected also depending on the situation to a conclusion can lead (more) in one of the next post.

In addition to the modification of views, there is another common workaround, which is to create a dummy metric, which is defined for each combination of attributes.  This metric will be hidden in the OLAP area, or via formatting in the report. Example of such a metric would be a simple constant function Sum (0).

Such a dummy metrics produces the same result as if all the attributes of the template would be linked to a FULL OUTER JOIN.

But what if you want some attributes with a FULL OUTER JOIN, and then connect the other with LEFT OUTER JOIN?  A simple idea would be to modify the metric by means of dimensionality, namely, the LEFT OUTER JOIN attributes with the setting ignore add / None.

Great idea, but does not work!  From a no apparent reason, no metric dimensioned in MicroStrategy can be “conducting”, ie standing in a LEFT OUTER JOIN on the left side. Too bad!

The original article in German language can be read here.