![]() Go to the project configuration wizard of the project Q11) What are statistics tables and how do you configure the project statistics?Īns: Statistics tables contain data on the MicroStrategy system’s usage and performance and are populated by all projects that are configured to log statistics.ĭefine the statistics and enterprise warehouse database. Want to acquire industry skills and gain complete knowledge of Microstrategy? Enrol in Instructor-Led live MicroStrategy Training to become Job Ready! Q10) How do we resolve attribute roles?Īns: By creating explicit table alias for the same or enabling the Automatic Attribute Role recognition. In the fact table, however, a separate column exists for each of their roles (Origin_Airport_ID and Destination_Airport_ID). Both attributes share the same forms, or information about them (Description, Location, etc.). In this example, attribute Origin Airport and Destination Airport are defined using the same Lookup Table and Column (Airport_ID). Whereas the Metric Join Type determines how the metrics are joined to other metrics.Īns: A user defines two attributes that have the same definition but play different roles in the business model.This is basically used for Compound Metrics and determines how the different tables used in the metric formula are joined.Q7) Define the order of precedence of VLDB properties?Īns: Reports>Project>Database Instance>DBMS Q8) What is the Metric Formula Join Type? How it is different from the Metric Join Type? Q6) How the reports are optimized?Īns: VLDB properties allow you to customize the SQL that MicroStrategy generates, and determine how data is processed by the Analytical Engine. Object prompts can either determine the definition of the report template or the report filter. Q5) What is an object prompt?Īns: An object prompt allows you to select which MicroStrategy objects to include in a report, such as attributes, metrics, custom groups, and so on. They allow you to group attribute elements in new ways without changing the metadata and warehouse definitions. Consolidations are used to specify the data you want to view in your report. It is made up of an ordered collection of elements called custom group elements. Q4) Comparison between Consolidations and Custom Groups?Īns: A custom group is a set of special filters that can be placed on a template. Ignore filtering disregards filtering criteria based on the attribute in the target and its related attributes (both parents and children).Absolute filtering raises the report filter to the level of the target, so all subcategories in the categories included in the report are added together.Standard filtering allows the report filter to affect the metric.Q3) Difference between standard, absolute, and ignore conditions in metrics? Q2) How will Project Sources be configured in MSTR Office?Īns: By editing the projectsources.xml, new project sources can be added. This allows developers to model attributes and facts whose expressions span multiple tables. Once these Logical views are created, they are available to the report designer in a way similar to any other table. Microstrategy Interview Questions and Answers Q1) What are Logical Views used for?Īns: Logical Views allows application architects to create any desired view using MicroStrategy, without DBA involvement. Can Microstrategy Desktop access SAP data?.What is star schema and snowflake schema?.What are Level Metrics? And why are they required?.What are report caches and how many types are there?.Define the order of precedence of VLDB properties?.How will Project Sources be configured in MSTR Office?.Most frequently asked Microstrategy Interview Questions MicroStrategy Interview Questions for Experienced.MicroStrategy Administrator Interview Questions.Microstrategy Developer Interview Questions.Microstrategy Interview Questions and Answers.In this article, we will cover the following: Tekslate has collected the most frequently asked Microstrategy Advanced Interview Questions And Answers which are often asked in multiple interviews. ![]() Are you planning to attend an interview for the Microstrategy Advanced role but confused about how to crack that interview also what would be the most probable Microstrategy Advanced Interview Questions that the interviewer may ask? Well, you have reached the right place. ![]()
0 Comments
Leave a Reply. |