Wednesday, November 26, 2014

Microstrategy Interview Questions Part 6

Can users join data across SAP BW Info Cubes and Query Cubes?
Yes. Users can use Microstrategy Desktop to create reports that access SAP data and join data across SAP BW Info Cubes and Query Cubes as well as access multiple instances of SAP BW at once.
 Can Microstrategy Desktop join data across heterogeneous data sources?
Yes. Microstrategy 8 extends the Microstrategy data modeling flexibility to include integrated views of data across heterogeneous data stores. By mapping conforming dimensions from different sources, Microstrategy Desktop can automatically join data from multiple different sources in the same report document. Data can come from any source accessible by Microstrategy 8, including the data warehouse, data marts, SAP BW, and any number of operational system databases

Does Microstrategy provide predictive modeling capabilities commonly available in data mining tools?
Yes. Microstrategy 8 can calculate four of the primary data mining functions including neural network algorithms, clustering algorithms, regression algorithms, and tree algorithms.
 Can Microstrategy incorporate best-of-breed data mining insight into mainstream business reports and analysis?
Yes. Microstrategy 8 has extended its analytic engine with "Data Mining Services" capability that allows reports and analyses to include predictive capabilities in every Microstrategy report or analysis. Microstrategy 8 includes the new ability to import data mining models directly from best-of-breed data mining products from vendors like IBM, Teradata, SAS, and SPSS using the new PMML or predictive modeling mark-up language standard.

Can Microstrategy Desktop export data to other software applications?
You can export information from Microstrategy Desktop to text files, Microsoft Word, Microsoft Excel, Microsoft Access and HTML files. The formatting of the tables and data are preserved when you export to these file formats.

What data sources does Microstrategy Desktop support? 
You can access data in all the major databases including Oracle, IBM DB2, Informix, NCR Teradata, Microsoft Access, Microsoft SQL Server, Red Brick, Sybase and Non-Stop SQL.

 To save time, can many reports be run at the same time? 
Microstrategy Desktop can execute multiple reports simultaneously. Report results are saved in a personal History folder when ready.

 Can reports be executed in off-peak periods? 
Reports can be attached to time-based or event-based schedules that are defined by the administrator. These schedules automatically trigger the report execution and place a notification message in the History folder on completion

 What is Microstrategy OLAP Services?
Microstrategy OLAP Services is an extension to Microstrategy Intelligence Server that allows Microstrategy Web and Desktop users to manipulate Intelligent Cubes™. With OLAP Services end users can add or remove report objects, add derived metrics and modify the filter -- all with speed-of-thought response time against Intelligent Cubes. OLAP Services enables full multi-dimensional OLAP analysis within Intelligent Cubes, while retaining users' ability to seamlessly drill through to the full breadth and depth of the data warehouse.
What are the Intelligent Cubes used by OLAP Services?
Intelligent Cubes are user or administrator created multi-dimensional cubes that operate within Microstrategy Intelligence Server™. On Microstrategy's BI platform, creating an Intelligent Cube is as easy as creating a report. Intelligent Cubes enable Microstrategy to combine the speed and interactivity of multi-dimensional OLAP analysis and the analytical power and depth of relational OLAP 

Label microstrategy interview questions part 6

No comments:

Post a Comment