Microstrategy

What functionality is contained in MicroStrategy Administrator - Object Manager 7.x and 8.0.x?
MicroStrategy Administrator - Object Manager allows users to perform the following actions:
• Duplicate and upgrade projects
• Copy objects within and across related projects
• Move objects within a project
• Delete objects within a project
• Rename objects within a project

203. Why do businesses need to send information out to users proactively?
     • People do not have time to search through information to identify information that requires immediate action. An intelligent alerting system understands and constantly monitors the information users need, and delivers information only when users need it.

198. What types of flat files does the report cache on the MicroStrategy Intelligence Server 7.0 create? Are they accessible from other tools?

181. Should you have DATE as ID attribute form?
182. What is compound key?
183. What is a fact and an attribute?
184. What are Factless facts?
185. What are Transformations? Is there any transformations implemented in your project?
186. Explain Fact Structure(types, one by one)
187. Explain Level Extension. How it is used in your project?
188. Explain Fact Relation.
189. Explain Fact Degradation.

166. What is Microstrategy Desktop?

Microstrategy Desktop™ is a Windows client-server software application that provides integrated monitoring, reporting, and analysis capabilities.

167. What does Microstrategy Desktop allow users to do?

149. What is the difference between RW document and HTML document?
150. What’s smart metric?
151. What is a bridge/relationship table?
152. How will you resolve double counting in M-M relationship between two attributes?
153.  What is a CUBE?
154. What are differences between View Filter and Report Filter?
155. What are the different types of Filters available? Explain each with example.

131. What is metadata?
132. What is two-tier connection?
133. What is three-tier connection?
134. What is difference between 2, 3 and 4 tier connections?
135. How do you achieve schema object version control (similar to VSS)?
136. What are different kinds of objects in MicroStrategy?
137. What’s fact table?
138. Where is Administrator’s password stored? Is it stored in encrypted?

111. What is ScanMD?
112. What is MD Doctor?
113. What is clustering?
114. How will you reset password of all users?
115. What are different modes you can run I-Server?
116. 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?
117. What are various authentication modes?
118. How can you configure WH authentication?
119. Does DLS affect MicroStrategy?

91.  What is Freeform SQL?
92. What is an OLAP cube report?
93. How to apply OLAP?
94. How to handle many to many relationships?
95. If there are diff. customers how to define the data?
96. How to create dual key(dual key in composite key)
97. What is VLDB based performance tuning?
98. Have u used stored procedures to invoke MSTR?
99. What is compound metrics(is m1 + m2 a compound metrics)
100. What is Hetreogenous mapping?

76. How long does it take to get Microstrategy Desktop up and running?
Microstrategy Desktop installs in minutes and automatically presents a list of available Microstrategy Intelligence Servers. Within an hour, the installation and setup are completed.