MicroStrategy Custom Groups by Sushil Muzumdar


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

Look at following video on YouTube.

This is crazy to see what we’ve got done from 3i on YouTube. As video is off poor quality, let me tell you what is it. Currently there is no option to create Custom Group in MicroStrategy Web. This MicroStrategy 8.1.1 Web SDK customization made it possible. But wait! let me tell you something about this. We (my employer) were the first and probably only buyer of this. 3i employee Sushil (happens to be uploader of this video too) was the man behind this request (web CG) that some (of employer’s) client were asking for long.

About this application, this is not even fully made. This guy simply disappeared when he was wanted to fix the bugs. It doesn’t provide the option to set the level (none, report, custom) for a filter based on Metric, so that option is still not exposed to clients. Person who did QA of this application (she declared everything Pass) was fired. Sushil, we are facing the heat of your half hearted application. Specially we feel bad cause my employer paid from nose for this highly unstable application. Because of this we had to almost remade this application by someone else. You specifically didn’t provide any code documentation.

This CG customization runs into a problem every now and then. Last but not least, this works only and only in 8.1.1 and up and is not forward complaint to MicroStrategy 9.0, to be released soon. I don’t know if being forward complaint was something looked at during planning phase. BTW, MicroStrategy 9.0 provides in-memory CGs. ASAIK, as per licensing condition, he can not re-sell it and he is trying to sell it. You may land in soup for this.

What should you ask your future employer


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
Interview
  1. Work days in week? 4 days 5 days or 6 days?
  2. How many hours a day?
  3. How is salary credited and what day of month?
  4. Position/Designation offered?
  5. Do they provide free food? Do they have in-house kitchen?
  6. Do you give Meal vouchers as part of CTC? How much can I avail? Is there any cap due to position? How and when it is disbursed?
  7. Does the job require travel and what if yes what percent?
  8. To whom I’ll be reporting to and his designation?
  9. Relocation reimbursement and the upper limit? T&C.
  10. Initial accommodation in a new city? How many days?
  11. Dress code? (For me most important question)
  12. Number of leaves in a year. Leave policy in detail.
  13. How long is probation period?
  14. Entitlement of leaves during probation period?
  15. Anytime they mentioned year ask about financial or calendar?
  16. Joining date?
  17. Am I insured by new employer? Are you insured from day 1?
  18. Does your parent get Insurance protection (even if it is paid)?
  19. Do let them know the time you need to deny/accept the offer.
  20. Is LTA an optional component of CTC? If NOT opted, would it be given every month?
  21. Do I get an independent extension or shared? If shared among how many people do I need to share?
  22. Do I need to work from Home? What’s company policy regarding this? Do you provide laptop/ reimbursement Broadband charges?
  23. Do I get unrestricted internet access in office?
  24. Can I carry forward my MicroStrategy account?
  25. Are you MicroStrategy Inc listed partner/reseller/support provider?

Migrating a 2 tier project source to a 3 tier source


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

Technically, you don’t really require anything to make a 2 tier, just configure it using configuration manager (your access file). 2 Tier connection is also possible for a Oracle, SQL Server, or any other database.

There are two ways one can migrate a 2 tier (access) based project to Excel.

1. Project duplicate using Project duplication wizard or Object manager.
2. Import the access database into your relational database (Using ETL)

Types of objects in MicroStrategy


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

There are only and only three types of object in MicroStrategy. they are same follows:

  1. Schema
  2. Application
  3. Configuration

Note: Public objects is just a folder in metadata which “mainly” holds application objects, it is not a type of objects. Security Filter is a configuration object even though it is created the way application objects are created.

Teradata India – a sorry picture inside


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

Teradata is said to be the best back-end as far as MicroStrategy is concerned. Most of MSTR people I know, they have Teradata as the back-end. FYI, Walmart has the biggest implementation of MicroStrategy with more than 100 boxes of Teradata.

Now cut short to Teradata India, which is mainly involved in selling the Teradata boxes and then co-selling its consulting services (After all database requires some front-end to make use of it). My several freinds who are client side from Teradata have bitter experience. Teradata is just concerned about selling their boxes and letting employee “manage” things at client side of it own. Lots of people are working under duress.

They keep on advertising about MSTR position almost round the year but I fail to understand why their experience MSTR resources are working on different technology or worse on bench.

Last and the serious bomb. There is set targets for employees about Teradata certification. Obviously you need not pay for it. But, if you do not achieve it, you may get no raise at all. One of my friend’s friend was so busy with the work (he did a great job) that it was impossible for him to remove time and do the certification. You get a bomb that there is no raise as you have not completed any certification.

If you are planning to join Teradata, do a good due diligence.