Monthly Archives: May 2010

MicroStrategy is coming to India (May be)


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

Finally … finally.. it looks like that MicroStrategy, Inc would be setting up the offshore development center or at least some support office. I say looks like because MicroStrategy, Inc is run by a single man’s fanatics (or lunacy), that single man is CEO, who has finally realized the importance of setting up a shop in India (This guy still can have a change of mind). It is some what sad that MicroStrategy, Inc is last BI product maker setting up office in India (sad not because I’m an India, but their god that intelligence about the price advantage.) IBM, Microsoft, Intel, Google, Cognos, SAP.. you name it and they not only have call center, offshore development center but R&D division in India too.

MicroStrategy as a product has no future in India. Not because Indian don’t understand TCO but the Indian mentality that I must get to see (something physical or quick results) when I’m spending such a big money. Just to explain, I have few businessmen friends, who say “What the hell you work in Software? I don’t see it. I make building …… (add anything into construction).. worth tens of millions and people can see it.. what do you guys do. why should I spend so much money for something that I can’t see” This is not an isolated case but a great reflection of Indian mindset. I know of few shops who do business of INR 1 million a day and spend 3 hours (9 pm to midnight) just in (manual) accounting. They just hate computers. Tax evasion is also a reason, through records can be shred in computers too.

MicroStrategy most probably would be having office at Pune and may pull the team working on MicroStrategy QA and documentation at Cybage. The team there must be ~ 35. I don’t have any contact for last 2 years, but a guess. Few work is done by another company, I do not wish to name.

But I’m really thinking what the domain name they would be having. :)

Trick to sort on attributes inside Object Prompt


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

This is an old trick concerning sorting in reports and templates.
Let’s say your report uses an object prompt containing a number of attributes and you want the results to be ordered by those attributes. If you simply go to the ‘Advanced Sorting’ menu you will see that the attributes are not there, obviously because they are not part of the report itself.

Here comes the trick. Just add the attributes to the report, define the sorting and then remove them. Go again into the ‘Advanced Sorting’ menu and you will see that they are still there. Neat!

So now, when you execute the report and select your attributes from the object prompt in any combination, the Analytical Engine will know how to deal with them. Even if you play with the position of the attributes (rows, columns or page-by) the sorting options will be maintained.