1). What are Logical Views used for?
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.
2). How will Project Sources be configured in MSTR Office?
By editing the projectsources.xml, new project sources can be added.
3). Difference between standard, absolute and ignore condition in metrics?
Standard filtering allows the report filter to affect the metric.
Absolute filtering raises the report filter to the level of the target, so all subcategories in the categories included on the report are added together.
Ignore filtering disregards filtering criteria based on the attribute in the target and its related attributes (both parents and children).
4). What is the Comparison between Consolidations and Custom Groups?
A custom group is a set of special filters that can be placed on a template. It is made up of an ordered collection of elements called custom group elements. Consolidations are used to specify the data you want to view in your report. They allow you to group attribute elements in new ways without changing the metadata and warehouse definitions.
5). What is an object prompt?
An object prompt allows you to select which Microstrategy objects to include in a report, such as attributes, metrics, custom groups and so on. Object prompts can either determine the definition of the report template or the report filter.
6). How the reports are optimized?
VLDB properties allow you to customize the SQL that Microstrategy generates, and determine how data is processed by the Analytical Engine.
7). What is the order of precedence of VLDB properties?
Reports>Project>Database Instance>DBMS
8). Difference between Report Limit and Report filter?
A report limit specifies a set of criteria used to restrict the data returned in the report data set after the report metrics are calculated.
Report Filter applies the where condition to the query sent to warehouse to extract the results.
9). What is Metric Formula Join Type? How it is different with Metric Join Type?
This is basically used for Compound Metrics and determines how the different tables used in metric formula are joined.
Whereas the Metric Join Type determines how the metrics are joined to other metrics.
10). What are attribute roles?
A user defines two attributes that have the same definition but play different roles in the business model. In this example, attribute Origin Airport and Destination Airport are defined using the same Lookup Table and Column (Airport_ID). Both attributes share the same forms, or information about them (Description, Location, etc.). In the fact table, however, a separate column exists for each of their roles (Origin_Airport_ID and Destination_Airport_ID).
0 comments:
Post a Comment