MicroStrategy Upgrade: Manager’s considerations

  1. What is the Testing acceptance requirement? Just verification, snapshot.
  2. There should be some bunch of reports/dashboard for which look and feel should be verified.
  3. There should be bunch of dynamic dashboard to be verified on Mobile devices.
  4. If there is a Mobile Enterprise Management tools like Good or some App management tool, testing effort would be a lot more.
  5. Anything deleted under Administration folder under Project Source should be under a written confirmation.
  6. Several issues of MicroStrategy connectivity require changing hosts file. Organization *MUST* be able to readily changes to host file even if they have some umbrella policy.
  7. All machines must have latest version acrobat reader and flash player installed.
    8.For Images and few fonts to be shown in dashboard, they need to be copied into I-Server machine.
  8. No not-uplift related task should be accepted as part of uplift. Such small tasks are too much of distraction and usually run into server details or administrator rights issue.
  9. All remote machines should have good # of license to connect all onsite/offshore resources.
  10. All the prompt answers for any report verification to be provided by client or reports to be tested by them or any report testing that requires custom answers must be tested by business first.
  11. Projects must be connected to a meaningful database with meaningful data for verification.
  12. When a testing has been committed, then the testing criteria and what fulfills a minimum testing should be checked too.
  13. All document expected by client should have the format provided by them.
  14. As reports are required to be tested, MicroStrategy DBQuery tools should be published on Citrix and database connection information should be provided.
  15. If datamart reports are required to be tested, delete right on tables should be provided for testing purpose, as testing require data to be cleaned up loaded by DM report.
  16. Again for DM reports, select access should be provided for verification of dada load performed due to Datamart report.
  17. All folders created, images and font copies on E1 should be replicated on E2 and E3.
  18. Must not accept any development work as part of uplift.
  19. All hidden folders should be unhidden during course of Web Testing
  20. Everyone should have same version of MS Office
  21. Only Upgrade related defects should be fixed. If it is proved by Upgrade team that defect is a known issue on the new version or a defects is due to incorrect behavior of MicroStrategy, it should be passed on to Infra or Development team.
  22. Should have SELECT access on metadata database by all resources.
  23. On all the installations where defects are being logged, upgrade team must have admin access.
  24. Before accepting any Development/enhancement/cosmetics, even for extra money, an impact analysis must be done, it terms of breaking something stable and timeline. I just got a cosmetics request (to change all graph) from Portia one week prior to soft launch, when there are bigger defects lines up.
  25. DBA team should keep on monitoring the Log file size on weekly basis and during the migration period and one week prior to that, on daily basis.
  26. Criteria for an Upgrade defect must be defined.
    1. If objects are matching in both environment and still do not get matching results, this is a MicroStrategy defect not an Upgrade defect.
    2. Upgrade team should stop at all efforts after troubleshooting a defect and finding that to be a MicroStrategy defect.
    3. Upgrade team should not own fixing any MicroStrategy defects, how simple they would be.
  27. 28.If an issue reappears in new version (which was fixed), Uplift team responsibility is limited to troubleshooting and providing solution but not actual implementation, unless that related specific to uplift related.

About Ashish Tiwari

Ashish Tiwari has 8 years of experience solely working on various aspects of MicroStrategy (excluding SDK). He has experience in Financial domain and created reports having visibility of CXOs and BU heads. He spends his time watching Hollywood flicks. Favorite movie: The Shawshank Redemption.


Notice: compact(): Undefined variable: limits in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Warning: count(): Parameter must be an array or an object that implements Countable in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 399