Back to Blog
Dossier in microstrategy7/1/2023 ![]() ![]() 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. Here is a quick screenshot of how I was able to make it look using some fake data, if that is what you were indeed trying to do.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. Repeat the same for "Outbound Costs" and then work on formatting to merge the repetitive labels and center. Drag this new attribute above the metrics in the first column group (making sure it is still in the group). Name the attribute whatever you'd like and have the definition be "Inbound Costs" and set the data type to "String". To label them, right-click on any attribute in the dataset panel and select "Create attribute.". This groups them, but doesn't label them quite yet. Then, put the "Inbound Costs" into one column set and the "Outbound Costs" into another column set. This will allow you set the different sets of columns that behave differently. First, do "Change Visualization" on your grid and set it to "Compound Grid". If grouping metrics, it is a bit more involved. Might need to play with formatting to make sure that the repetitive cells are merged and centered, but that would group the attributes across the columns. Once you have the group made, then just drag in the original attribute under it. From there, put the elements into one group that is labeled "Inbound Costs" and make another that is labeled "Outbound Costs". Put the attribute in the columns, then right-click and select "Create Groups.". If grouping attributes, that is pretty straightforward. It will be a bit different if you are grouping attributes or metrics, but I think it should work either way. ![]()
0 Comments
Read More
Leave a Reply. |