Interview Questions.

Q1. What Information Is Shared By The Application Across Microstrategy Web Nodes?

MicroStrategy Web is designed to be as stateless as possible. Therefore, no information is shared through the MicroStrategy Web application across cluster nodes. All country statistics for strolling jobs is driven to the purchaser browser.When a record is submitted by means of a MicroStrategy Web person, the person will receive a wait page within the purchaser browser. This wait page will poll the MicroStrategy Web Server periodically for the popularity of the document. This polling is accomplished as new http requests. This http request will include all country statistics, including encrypted login records and MicroStrategy Intelligence Server connection information.

Q2. I Have A Fact Table At All Time Levels(date, Week...Year). I Have The Similar Fact Table At Year Level. If I Create A Report With A Fact Attribute And A Metric Based On That Fact........ How Do We For

The MSTR calculates the table key and primarily based on the important thing value it might use the best FACT desk. If it would not use the correct FACT desk for some motive, we can include the reference called FACTID inside the Metric formulation expression to indicate which FACT desk to be used in that specific metric.

Q3. Can Microstrategy Desktop Access Sap Data?

Yes. With the discharge of Microstrategy 8, Microstrategy Desktop includes a new dynamic records get admission to engine designed to get right of entry to multi-dimensional databases (MDDBs or OLAP Cube Databases) along with the ones from SAP Business Information Warehouse (BW) databases

Q4. How Do You Ensure Simultaneous Releases Across Multiple Operating Systems?

MicroStrategy Intelligence Server is engineered to be platform-impartial on a unmarried code base and is truly compiled accurately for every licensed running device. As a result, MicroStrategy can release Intelligence Server on all certified working structures at the same time with the identical features

Q5. How Does Microstrategy Object Manager Determine If Two Objects In Different Projects Are The Same?

To decide if  gadgets are the equal, MicroStrategy Object Manager compares their Object ID's. If these ID's are the equal, MicroStrategy Object Manager then compares the Version ID's. If the Version ID's are the identical, the Conflict Resolution grid lists the warfare as 'Exists Identically.' If the Version ID's are distinctive, the Conflict Resolution grid lists the conflict as 'Exists Differently.

Q6. How Can The User Determine The Object Id Of An Object?

To view the Object ID of an object, right-mouse click on at the object and choose 'Properties.' The Object ID and Version ID are listed on the 'General' tab.

Q7. What Is A Logical Size Of A Table And What Does It Depend On?

Logical length is Microstrategy manner of generating the fine suitable/optimized SQL to fetch the required statistics. Microstrategy follows an algorithm to calculate the logical length of a desk, which relies upon at the no of attributes and facts based totally at the table and additionally the placement of those attributes within the machine hierarchy. The logical length does no longer rely upon the real records (no of rows) within the database. If the candidate wers this than his concept is inaccurate

Q8. What Are Attribute Roles?

A person defines  attributes that have the same definition however play special roles within the enterprise model. In this case, attribute Origin Airport and Destination Airport are defined using the same Lookup Table and Column (Airport_ID). Both attributes percentage the equal paperwork, or records about them (Description, Location, etc.). In the reality table, but, a separate column exists for every of their roles (Origin_Airport_ID and Destination_Airport_ID).

Q9. What Is The Order Of Precedence Of Vldb Properties?

Reports>Project>Database Instance>DBMS

Q10. What Leads To A Cross-join Or How Does A Cross-join Occur?

Cross Joins occur whilst unrelated attributes(attributes that aren't related to a metric or any other attribute) are placed in a document

Q11. At Which Levels You Can Set The Vldb Properties? Which Level Has The Highest Pecedence?

VLDB Properties can be set at various levels like Report, Template, Metric, Project, Database Instance and DBMS stage. Out of this Report level has the best priority. It overrides all other degrees.

Q12. Does Microstrategy Intelligence Server Support Scheduling?

Yes, MicroStrategy Intelligence Server supports time-based totally and occasion-based totally schedules. These schedules mechanically trigger report execution and area a notification message inside the consumer's History folder upon completion.

Q13. Why Is It Required To Maintain A Parent-baby Relationship Among The Various Attributes? What Are The Various Types Of Relationships Depending On The Number Of Participants?

The figure-baby courting helps in organising the hierarchical shape to the whole logic and enterprise version. For instance, you may have the area to be a toddler of a selected yr characteristic. This will help us in having a modularized technique inside the design and could assist in setting up not unusual usage semantics. The various sorts of relationships can be one to one, many to one, many to many, one to many relationships.

Q14. How Do Users Receive Only Information That They Want?

Through an clean-to-use subscription internet web page, users specify what records they need. Some personalization alternatives encompass the language alternatives and unique facts criteria which include sure merchandise. Using this consumer profile, Microstrategy Narrowcast Server sends simplest the facts that the user has asked.

Q15. What Are Report Caches And How Many Types Are There?

A document cache is a result set from an performed record this is stored on MicroStrategy Intelligence Server. 4 types: matching caches, history caches, matching-history caches and xml caches.

Q16. Is It Possible For Different Nodes Of A Microstrategy Intelligence Server Cluster To Run Against Different Metadata Repositories?

No, all of the nodes within the same cluster should run towards the identical metadata

Q17. Difference Between Project Merge And Object Manager?

1. Object Manager can flow only some objects or simply the objects in a few folders. Project Merge movements all of the objects in a mission.

2. Object Manager must locate the dependents of the copied gadgets after which decide their differences before appearing the replica operation. Project Merge does not do a dependency seek, since all of the gadgets in the undertaking are to be copied.

Three. Project Merge can be run from the command prompt in Microsoft Windows.

Q18. Can Microstrategy Intelligence Server Scale Easily And Cost Effectively Based On My Growing Needs?

Yes. MicroStrategy Intelligence Server presents out-of-the-box clustering competencies that permit companies to leverage their preliminary investments and step by step scale as greater users and records are delivered to the system, or while special types of BI are required

Q19. What Is The Conflict Resolution Window?

The Conflict Resolution window presents the person with a me to decide how to cope with object conflicts among the supply undertaking and the vacation spot project. In addition, the Conflict Resolution window shows the object name within the unique project, the item call in the destination mission and the sort of war. Users might also specify a brand new name for the object depending at the movement selected

Q20. Is It Possible To Use Microstrategy Object Manager While Other Users Are Making Changes In Microstrategy Agent?

Using MicroStrategy Object Manager to duplicate/circulate gadgets around isn't always encouraged whilst different user classes are making adjustments the usage of MicroStrategy Agent, as it could result in metadata inconsistency. Project and schema locking save you multiple customers sessions from manipulating the schema at the identical time. This prevents metadata inconsistency from happening.

Q21. What Olap Capabilities Do I Have Within A Microstrategy Report Services Document?

Users have the capability to drill inside the document, drill anywhere, or disable drilling. Drilling skills can be carried out to a grid or graph, allowing customers to carry out an investigative analysis without delay on a dashboard, scorecard, or agency file. Users can drill out of the dashboard to research throughout the information warehouse or more than one statistics resources and generate new facts-wealthy reports.Using the multi-pick characteristic, enterprise customers can dynamically select any organization of elements and create derived element businesses at the fly. Elements can be removed or added dynamically and users can create their own calculations among numerous businesses or person gadgets

Q22. Can I Deploy A Single Bi Application In Multiple Languages?

Yes. Every factor of a BI software can be trlated and provided in more than one languages, which include all MicroStrategy consumer interfaces, metadata gadgets consisting of the names of news and files, and statistics within a facts warehouse.

Q23. What Are The Benefits Of Using Microstrategy Intelligence Server?

MicroStrategy Intelligence Server affords one centralzed architecture for all users' monitoring, reporting and analysis requirements. MicroStrategy Intelligence Server additionally offers scalability to analyze any amount of records, help for any variety of customers and a 24 X 7 running surroundings, with strong safety

Q24. What Are Level Metrics? Why Are They Needed?

The level metrics are the metric calculation which can be completed over the specific characteristic however on the unique stages or dimensions. For example, the variety of units bought is an attribute that we hold a count on. That metric can be calculated across time and region. Say quantity of gadgets bought in ultimate month and the variety of units sold in particular location of the u . S .. Here the vicinity and time are  specific tiers. Such stage primarily based metric provide analytical inference as to the overall performance of the organisation and so forth.

Q25. What Subtotaling Features Does Microstrategy Desktop Contain?

Microstrategy Desktop has more than 10 specific subtotaling features that useful resource evaluation of the statistics. Subtotals may be supplied at any level in the rows, columns and pages at the report.

Q26. What Specific Features And Functionality Do I Get With Olap Services?

With OLAP Services Microstrategy Web, Desktop and Office customers can:

Create unique file perspectives based off an Intelligent Cube. With OLAP Services, users can create particular report views by means of adding or putting off attributes and metrics contained in the Intelligent Cube. This permits pace-of-thought report advent and amendment with out a want to extract records from the data warehouse.

Create new on-the-fly metric calculations from present metrics in an Intelligent Cube. The new calculation is done with out filing a brand new request to the information warehouse.

Filter their view of the statistics within an Intelligent Cube. The filtering may be performed on Microstrategy Intelligence Server inside the Intelligent Cube.

Q27. What Are Report Filters And View Filters?

Report filters: document filters are the situations that accompany the file producing SQL statements. The record definitions have the filters as part of their definition.

View Filters: View Filters are the situations that come into play earlier than a particular result is presented to the person. Thus the view filters are not a part of the SQL statements like report definitions, as a substitute they're the filters implemented after the execution of the SQL statements, after the records is retrieved from the statistics warehouse.

Q28. How Does Microstrategy Object Manager Integrate With The Microstrategy Product Suite Security Model?

Security in MicroStrategy Object Manager is based totally at the MicroStrategy 7.X Product Suite protection model. All sports that may be performed in MicroStrategy Object Manager are governed by way of privileges and get admission to control lists. For instance, if a person is not allowed to access a sure folder in MicroStrategy Agent, they will not be capable of get right of entry to the folder in MicroStrategy Object Manager.

Q29. Can Microstrategy Desktop Access Operational Data Systems?

Yes. Microstrategy Desktop customers can use a brand new Operational SQL Engine to consist of information from any operational system using completely unfastened-shape SQL, which include stored methods and views

Q30. What Does Microstrategy Desktop Allow Users To Do?

Using Microstrategy Desktop, users can effortlessly get right of entry to and proportion important corporate statistics they want to make value-cutting decisions and improve commercial enterprise tactics. The records discovered in databases also can be used to help growth sales and raise income. Users can access this database and SAP records without having to analyze technical database question (SQL) or multi-dimensional expression (MDX) syntax.

Q31. How Long Does It Take To Get Microstrategy Desktop Up And Running?

Microstrategy Desktop installs in minutes and robotically gives a list of available Microstrategy Intelligence Servers. Within an hour, the set up and setup are completed

Q32. Can I Access Intelligent Cubes Without Olap Services?

Yes, with the best version of Microstrategy Web or Desktop, certain functions leverage the Intelligent Cubes. These capabilities include: document formatting down to mobile degree, column aliasing, drilling, pivoting, page-by means of, adding metric thresholds, adding subtotals, ranking and sorting. Please see the Web and Desktop version comparisons to decide exactly which Web or Desktop model includes the favored functionality.

Q33. Is Microstrategy Desktop Available In Other Languages?

Microstrategy Desktop is to be had in English, French, German, Spanish, Korean, Italian, Swedish, Japanese and Portuguese.

Q34. How Can Users Design Dashboards Quickly And Without Programming Experience Or Training?

MicroStrategy offers out-of-the field templates that provide a brilliant start line for dashboard designers. Each template consists of a chain of boxes, or panel stacks, that allow customers to speedy upload components to every panel stack, such as: textual content bins, shapes, reviews, grids, graphs, panel stacks, HTML containers, selectors, and widgets. Also, pre-formatted customized templates may be created to region the design experience inside the fingers of stop-customers. These pre-formatted templates can encompass the company brand and color format. Users can absolutely drag, drop, and select dashboard components to quickly layout a dashboard inside the depend of mins.

Q35. How Can You Impose Security Measures Into The Microstrategy.

Column stage protection set up by way of the enforcing user unique get entry to permissions within the database and having user particular connections.

Entire set of objects can be secured by using imposing folder and item level protection.

Row level security is imposed with the aid of having person particular safety filters for various information.

Q36. What Is A Cache?

A cache carries the homes and records of a document as soon as a report has been run. Caches can be stored in memory and/or on disk. When customers ask for a report this is cached, the Intelligence Server will retrieve the facts from disk or reminiscence as opposed to running a query on the data source. Cache introduction and usage securely leverages other customers' paintings, increases query performance and reduces the workload at the facts warehouse

Q37. What Are The Vldb Properties? Which Level Of Vldb Configurations Have The Highest Precedence?

The Very Large Data Base houses is the configuration set that manages the general way in which the database behaves and generates reviews. There are many such settings like check for go joins, intermediate table creation and kind and many others. The VLDB homes may be set at many specific level like metric level, characteristic stage, Database Instance level, mission degree or the DBMS degree. The highest precedence is given to the record stage of configurations.

Q38. What Are The Supported Languages For Microstrategy Intelligence Server?

MicroStrategy Intelligence Server is to be had in English (US and UK), French, German, Spanish, Italian, Portuguese (Brazilian), Swedish, Chinese (Simplified and Traditional), Korean and Japanese

Q39. Can Intelligence Server Integrate With My Existing Data Structure?

Yes. MicroStrategy Intelligence Server effortlessly integrates along with your present statistics shape with its support for the essential forms of schemas like Star, Snowflake, Hybrid, Denormalized, Normalized and Aggregated Schema. MicroStrategy Intelligence Server also integrates with SAP® BW InfoCubes and QueryCubes.

Q40. What Are The Tracing Options Available In Microstrategy Object Manager?

Tracing is to be had below the Tools/Diagnostics menu. These tracing options follow to every MicroStrategy product established on the device.To see the SQL that has been accomplished in opposition to the metadata, go to the Advanced tab and turn on 'SQL Tracing' beneath the DSS MDServer key.Function stage tracing may be executed with the aid of going to the Advanced tab and turning on 'Function Level Tracing' underneath the DSS ObjectManager key.

Q41. Can Reports Be Executed In Off-peak Periods?

Reports can be connected to time-based or occasion-primarily based schedules which might be described by means of the administrator. These schedules automatically trigger the document execution and area a notification message within the History folder on of completion.

Q42. What Happens If The Owner Of An Object Does Not Exist In The Destination Project?

If the proprietor of the supply item does not exist inside the destination mission, the consumer login for the vacation spot undertaking takes ownership of the item whilst it's miles copied or changed.

Q43. What Is The Difference Between Absolute Filtering And Standard Filtering?

When we use absolutely the filtering in definition of degree metric anything statistics we gain from the filter out is goingto be said as such and the the file filter out might be overridden by way of the absolute filter out settings. The general filtering the document filter out interacts with the metric filter out within the regular manner and what we gain could be formatted consistent with the record filter out settings

Q44. What Formatting Can Be Applied To The Information That Is Sent Out By Microstrategy Narrowcast Server?

Information can be formatted into HTML, undeniable textual content, Microsoft® Excel, or PDF files. The size and show of those documents are adjusted to match the email kind or the wireless device for distinct customers.

Q45. How Can You Make The Sql Query To Be Based On A Specific Table Of Your Choice?

The MSTR operates in this type of manner that the incoming queries and information retrievals are completed from the desk which has the least logical size. Thus if we pick a specific table to be the center of interest then we ought to try to reduce the logical size of that precise desk in order that it becomes substantially lesser than the alternative tables.

Q46. How Is The Number Of Passes In A Sql Query Significant In Performance Evaluation?

The variety of passes represents the quantity of instances the SQL query must be parsed and different components of the query is treated for every skip. The fewer passes we have the more efficient the query executes and quicker the reviews are generated.

Q47. If A Microstrategy Intelligence Server Node Is Removed From A Cluster Manually, Will Report Caches Be Lost?

If an administrator gets rid of a cluster node from a cluster, then all document caches that have been created through that cluster node could be inaccessible with the aid of the rest of the cluster, whether or not or not a separate report server is used as a common file cache. This behavior is via layout.

Q48. Does Microstrategy Web Support Clustering Via Cisco Local Router Or Any Other Third-party Clustering Software?

MicroStrategy Web relies on third-birthday party internet-clustering software to offer clustering functionality. MicroStrategy Web is designed to be stateless in order that each person MicroStrategy Web node can characteristic without the expertise of the existence of different nodes. Therefore, any third-party software used to cluster net servers may be used.

Q49. To Save Time, Can Many Reports Be Run At The Same Time?

Microstrategy Desktop can execute more than one reports concurrently. Report outcomes are stored in a private History folder when geared up

Q50. What Security Is Provided With Microstrategy Desktop?

Microstrategy Desktop affords a number of security options to make sure that information is stored exclusive and personal. To facilitate smooth deployment and minimal preservation, Microstrategy Desktop integrates with Windows NT and 2000 security and with Novell directory. As a end result, users who've logged into those structures will no longer want to go browsing once more.