31). What is compound metric in Microstrategy?
A compound metric is based on arithmetic operators and non-group function, such as sum or average, which is applied to facts, attributes, or other metrics. It can also contain non-group functions or arithmetic operators, in addition to the required group function.
32). What is a view filter?
A view filter dynamically limits the data being displayed on a report without re-executing the report against the warehouse.
33). What is a consolidation?
Consolidations enable you to group together and to pick specific attribute elements. Further, consolidations allow you to place this grouping of attribute elements on a template just like an attribute. The elements of the consolidation appear as rows on your report, and they can have arithmetic calculations.
34). What is report limit?
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.
35). What is a drill path?
The drill map determines what options are available to you when you drill on a report object. These different options are referred to as drill paths, which include the destination of the drill.
36). What are drill path types?
Up, down, across, template, drill map.
37). What is view filter?
A view filter is a quick qualification applied in memory to the report data set. Because it affects only the view definition, the report does not have to be re-executed in the data warehouse.
38). What is derived metric?
A derived metric is a calculation based on the metrics already in the report. Derived metrics are generated based on the report data set.
39). What is security filter?
A security filter is a filter object that is used to narrow down the result set that users or groups can view when t hey execute reports or browse elements.
40). What is system prompts?
A system prompt is a special type of prompt that does not require an answer from the user; instead it is answered automatically.
41). What is transformation?
It is a schema objects that typically maps a specified time period to another time period.
0 comments:
Post a Comment