Category Archives: MicroStrategy

Nameless fear


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

Yesterday while waiting for fellas of Bangalore Motoring Club (BMC), I spoke with Sa and we had a nice discussion about commitment, emotional investment, love and fear. She is totally different kinda person. She can’t take risk and I always lived and live on edge. For her dating and love or filmy stuff and one should stay away from it. She laughs away when she sees people in park. Viola! and she found herself on the other side when me met. I had said once “I always do what my heart says” and “She is my parent’s choice”. These two things make her feel insecure and she doesn’t want to be attached and doesn’t want to get feeling of it. Well! it is a fault from both side. may be not. It is just different thinking. It can change with time. It can worse or even better. Don’t know what future holds. BTW, I need to describe her in one word. Thinking. The phone got cut when I was speaking. SIM has a problem. It would disconnect exactly after 30:01 minutes. I can prove it, but don’t want to.

Well, I always do what my heart says but I would be very reasonable than most sane person. But the fear thing was very bad to hear. Either I trust some one unconditionally or don’t trust. Things are not really good; at least I don’t feel good about the whole thing. I hate people when they don’t 101% trust me as I don’t waste my time thinning evil. Only evil mind (who know about evil things) don’t trust. Some fear…. why?? I’m puzzled.

BTW, may be time to say good bye to BMC has come. Meet got canceled. Guys wasted my 3 hours.

MicroStrategy Interview Questions 101


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

1. What is metadata?

2. What is two-tier connection?

3. What is three-tier connection?

4. What is difference between 2 and 3 tier connection?

5. What is ScanMD?

6. What is MD Doctor?

7. What is clustering?

8. How do you achieve schema object version control (similar to VSS)?

9. What are different kinds of objects in MicroStrategy?

10. How will you reset password of all users?

11. What are different modes you can run I-Server?

12. How can you make sure that I-Server would be running even if the application mode has crashed and how to get back the instance?

13. What is the difference between RW document and HTML document?

14. What are various authentication modes?

15. How can you configure WH authentication?

16. Does DLS affects MicroStrategy? What you need to do incorporate it?

17. What’s smart metric?

18. What’s fact table?

19. What is fact constellation schema? What is star schema? What is snowflake schema?

20. Should you have DATE as ID attribute form?

21. What is compound key?

22. What is a bridge/relationship table?

23. How will you resolve double counting in M-M relationship between two attributes?

24. What is Object Manager?

25. What will you do when I-Server crashes?

26. Where is Administrator’s password stored? Is it stored in encrypted?

27. What will you do if your Administrator has forgotten password or the account is locked?

28. How can you monitor the error received while running I-Server and report?

29. What is a surrogate key?

30. Why do we use a staging area?

31. Why do we need a DW?

32. Why do we use dimensional modeling in DW? Why not Relational?

33. How much history should we have in a DW?

34. What are the most important tables in a DW?

35. What is a fact and an attribute?

36. What is a batch?

37. Diferences between ROLAP, MOLAP and HOLAP?

38. What is a CUBE?

39. Why Kimball? Why not Inmon? Or vice versa? 😉

40. Performance with a relational based query vs dimensional?

41. What is ETL?

42. What types of DW’s are most common abroad?

43. How many MSTR projects have you worked? Explain in detail.

44. Tell us about your Roles & Responsibilities in your project.

45. Have you managed any team for MSTR project?

46. What are the two types of schemas available in DW?

47. Difference between Star schema and Snowflake schema.

48. What schema is used in your project? Why?

49. What are conformed dimensions?

50. What are Factless facts?

51. Explain 2-tier and 3-tier Architecture in MSTR including pros and cons.

52. What is 4-tier architecture?

53. What architecture is used in your project? Why?

54. What are the types of MSTR objects available?

55. Explain Schema objects. (One by one)

56. Have you created any Facts, Attributes for your project? How?

57. What are Transformations? Is there any transformations implemented in your project? Explain the example from your project.

58. What are the features available for MSTR Intelligence Server?

59. Explain Fact Structure. (4 types, one by one)

60. Explain Level Extension. How it is used in your project?

61. Explain Fact Relation.

62. Explain Fact Degradation.

63. Difference between View Filter and Report Filter.

64. What are the different types of Filters available? Explain each with example.

65. What is derived metrics? Explain the example from your project.

66. What is Compound Key Attribute? Give example from your project.

67. Explain VLDB properties in detail.

68. Similar to Visual SourceSafe (VSS) for version controlling, HOW can we achieve the same for Objects in MSTR?

69. Give the step-by-step approach followed for Testing MSTR reports, both from MSTR Desktop and MSTR Web.

70. Have you done any Estimation for MSTR reports?

71. How will you differentiate Simple, Medium and Complex reports while doing estimation for MSTR reports?

72. How to use Templates in MSTR?

73. What are Prompted Filters?

74. What is Bridge table?

75. Where will you customize the display for Null Values?

76. Explain the step-by-step technical approach after you get the Requirements from the Client.

Will be updating as and when I think of more questions. This is my list of question I generally ask if ask to interview a candidate. But keep in mind, this is just for initial cut off. Second round will have unique practical questions. Depends upon how much you have got to explore MicroStrategy.

Just 6 years to Sanju baba


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

Finally the verdict is out on Sanjay Dutt about his involvement in 1993 bomb blast. The !@#$%^&*() b****** youth icon could have had stopped whole bombing. His f****** knew about conspiracy but he sat on that information. He never had any threat from underworld. Generally, movie star are under threat from mobsters. On top of this, he can still appeal in supreme court.

This guy wept and shivered in TADA court, but what about those lives who are lost. Needless to say, B K Thakeray had helped Sanjay Dutt to get him out of court. It is very well known about the deal that happened between Shiv Sena and Late Sunil Dutt, father of Sanjay Dutt. Incidently, Sanjay Dutt’s father used to run for election from the constituency in which I live. He is said to be having good behavior and he got convicted under Arms Act not TADA. I don’t know what action Judge Kode is going to take on sting operation by a TV channel on the lawyer of Sanjay Dutt. It is very interesting that the person who gave, disposed and transported the arms to and fro Sanjay Dutt were charged and punished under TADA but he who kept arms at his home managed to skip the stringent law.

He is one of them and must be hanged. Court must set an example. The photos of Blast still linger in my mind very much. He could have had stopped it. Just because you are a honest, loved person doesn’t warrant you right to help people who waged war against the nation.

Life is zingalala


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

I had seen TATA Sky DTH service at Ashwin’s place. I was very impressed by the quality of reception and features provided. SO even I booked a connection. I knew that was like buying enmity with local cable operator.

The installation guys came at the time as planned. They had all the equipment to fit the dish, but the helper seemed to be a new guy so the main guy was a bit pissed. Specially, when an important screw was missing. Still, I must say everything went smooth and within 2 hours it was done. I must say, it was really damn nice seeing the TV after the connection was setup. It was amazing. Life is really a zingalala now. TATA is not better as far as pricing, schemes and features is concerned but it beats in picture quality and customer satisfaction. My main reason to buy TATA and I feel I was not wrong. Hope everything goes well.

Oye Pappe….Isko lagaya to life ekdum zingalala…

MicroStrategy 8.1 to be released


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

Wow…. Such a cool feature by MicroStrategy… Dynamic Dashboard…

One thing I must say (based on the views of people ho have never worked on MicroStrategy and seen me working on MicroStrategy). MSTR Inc has real innovative people. They always come up with new ideas to make things easier to end user. I have received several mails on MicroStrategy Inc manager, where they openly talk about (In mails) how their competent are duping their own customer and they (MSTR) should not follow the same. They should give their (MSTR’s) client fresh UI and complete stuff no half baked ideas like others.

Well this was very well confirmed by several people working on Business Objects and Cognos.

Initial cost of MSTR is exorbitantly high and maintenance is high, but cost cutting advantages in longterm are immense and no other BI tool can stand against MSTR.

Read about this new happening here.

BTW, I’m “still” working with Cybage. MicroStrategy haven’t been told that I left Cybage in Nov 2005 itself.