CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.




Get it now !!
Send your Resume to 6000 Companies
MicroStrategy Interview Questions & Answers - Learning Mode
COOLINTERVIEW.COM DATA WAREHOUSING INTERVIEW QUESTIONS MICROSTRATEGY INTERVIEW QUESTIONS QUESTIONS & ANSWERS - LEARNING MODE

MicroStrategy Interview Questions & Answers - Learning Mode

MicroStrategy is a business intelligence (BI), enterprise reporting, and OLAP (on-line analytical processing) software vendor. MicroStrategy?s software allows reporting and analysis of data stored in a relational database, multidimensional database, or flat data file. MicroStrategy describes its core reporting software as having a ?ROLAP? or ?Relational OLAP? architecture, meaning that a complex relational database can be expressed using a virtual multidimensional cube structure that can be more easily understood by business users who wish to navigate through the data.

Try MicroStrategy Interview Questions & Answers - Exam Mode

1

Sort By : Latest First | Oldest First | By Rating

MicroStrategy Interview Questions & Answers - Learning Mode
Try MicroStrategy Interview Questions & Answers - Exam Mode
Question: What is the Difference b/w Microstrategy and cognos Reporting Tool

Answer: cognos reportnet is only a web-based product but microstrategy is a web-based as well as desktop based. Source: CoolInterview.com
Question:
I have a requirement to create organization hierarchy like ' Sales Person(SP)1 to report to Manager 1, Manager1 reports to Manager2 and SP2 reports directly to Manger2 in Country 1 and In country 2 it might be change like SP1 directly reports Manger 2 and SP2 reports to Manager1, Manager1 reports to Manager 2' and in Country 3 there might be in some diff. manner '.In future there might be change in my organization structure, So I need to create flexible hierarchy to change in future.
So please suggest me a data model for this kind of Organization structure.

Thanks,
Naga


Answer: No answer available currently.
Question: What is Smart Metric?

Answer: THE Smart Metric property of a compound metric allows you to change the default evaluation order of the metric Source: CoolInterview.com
Question: In Microstrategy, how can you direct the sql generated to use a specifc table.

I know of using ApplySimple, but there are other ways too...



Answer: If you need to use a specific table , we need to play with the logical size of that table. Whenever MSTR frames a query it retrieves data from the table that has the least logical size and hence when you set the logical size of your table to be least compared to the other base table, MSTR will retrieve data from this specified table.

Source: CoolInterview.com
Question: In Microstrategy, what are Logical Views used for?

Answer: Logical Views allows application architects to create any desired view using MicroStrategy, without DBA involvement. Once these Logical views are created, they are available to the report designer in a way similar to any other table. This allows developers to model attributes and facts whose expressions span multiple tables. Source: CoolInterview.com
Question: What is the difference between view filter and report filter?

Answer: Report Filter:

A report filter?conditions appear in the SQL used to retrieve the report result set from the database. The report filter is created as part of the report and is saved with the report definition.

View Filter :

View filters do not modify the SQL for the report like normal report filters do. Instead, view filters are applied to the overall result set after the SQL is executed and results are returned from the data warehouse.
Source: CoolInterview.com
Question: What are the different types of JOIN operations?

Answer: Equi Join: This is the most common type of join which involves only equality comparisions. The disadvantage in this type of join is that there
Source: CoolInterview.com

1



India News Network
Latest 20 Questions
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
"Holiday Packages" announced as an advertisement are an example of _________: (a) Offer (b) Counter Offer (c) Invitation to Offer (d) None of the above
A match fixing contract between a player and a broker is a: (a) Valid Contract (b) Unenforceable Contract (c) Void Contract (d) Illegal Contract
When a bookseller sells a book on cash payment then it is called as ___________: (a) Unilateral Contract (b) Bilateral Contract (c) Executed Contract (d) Executory Contract
____________ agreements are created by situation: (a) Written (b) Oral (c) Void (d) Implied
Cache = 0.03125 Seconds