Advanced reporting Flashcards

Business Intelligence
Terms Definitions
Metadata database stores what objects.
Application objects, configuration objects and schema objects.
A report is...
The focus of business intelligence investigations.
What objects comprise a report?
Template, filter, view
Three tier reporting architecture...
Data warehouse, metadata, iserver, and desktop
Four-tiered bi architecture...
Data warehouse, metadata, iserver,desktop, and Microstrategy web
Report execution query flow
1 request is made from a client interface., request passed to the kernel, kernel checks cache, obtains report definitions from metadata, request sent to SQL engine, results sent to query engine, query engine hits data warehouse, results to analytical engine where final calculations are performed then formats results and returns to kernel.
To have a report retained in cache, you must...
Save and close a report,then execute it. It is not sufficient to run the report from desktop only.
Iserver checks the following keys to see if a report is in cache..
Report Id, template ID and version, filter ID and version, security filter ID, prompt answers.
You can associate the following keys with a report...
User key, DB connections ID, database login ID.
To run a report, the request can be made from what applications?
Desktop, mstr office, web
T/F re-executing a report hits the cache first, then runs the report again, only if necessary?
False. Re-executing means the report is ran against the DW to ensure the cache is updated with the latest data.
T/F re-execution works very similar to re-prompt?
False. Re-execute does NOT re-prompt the prompts questions.
Defining the level for a metric involves considering what 3 settings?
Target, grouping, filtering
Re: level metrics, the target is the ________ level at which the metric calculates.
Attribute. Any attribute or hierarchy can be the target.
Grouping determines.....
How the metric aggregates.
Grouping options are....
Standard and none.
Metric filtering option governs the relationship between....
...the report filter and the calculation of the metric.
Filtering options include....
Standard, absolute, ignore, and none.
Re: SQL, when Filtering is set to standard it means...
There IS a WHERE clause in the SQL code.
Re: SQL, when grouping is set to none, it means....
The metric does not group by target. There is no group-by clause.
Re: SQL, when filtering is set to ignore..
Report filtering criteria is removed from the WHERE clause that calculates the metric.
Is a view part of every report in mstr?
No, a view is an Olap service and is not required for every report
What are report caches and where are they stored?
They are result sets that are stored in the iserver.
What is the difference between a report ID and a report version ID?
Version IDs are assigned when there is a change. VERSION IDs and IDs must match for a cached report to be used.
Can I grant execute permission without granting Use permission?
No, use is required to execute.
What are the two levels of security we consider in adv reporting?
Object and security filters
What are the 3 components that must be defined for level metrics?
Target, grouping and filter.
What is filter none, grouping none used for?
It forces a specific table to be utilized, even if it isn't the smallest table size. You must specify as many attributes as necessary to force the engine to use the desired table.
Non-aggregatable metrics are metrics that...
Should not be summed across a metric.
Non-aggregatable metrics are useful for what type of report?
Bank statements,. Inventory end levels, etc...
What are the 3 parts of a relationship filter?
Output level, filter qualification, and relate by
Attribute to attribute comparison filters enable you to create reports that....
Compare values of two attributes using their respective attribute forms.
Joint element lists are...
Combinations of attribute elements of different attributes that FILTER reports
What can you import using the import filter?
Excel and text files
Pass through functions allow you to use...
Functions built into the RDBMS platform.
RE: pass-through functions, the 5 apply statements are...
Apply simple, applyagg, applyolap, applycomparison, applylogic,
The two set qualification filters include:
Metric qualifications and relationship filters.
Relationship filters contain...
Filter qualification, output level, and a relation.
What are results from consolidations and custom groups based on, respectively?
Consolidations are based on groupings and custom groups are based on filter qualifications.
What prompts are supported in icube reporting?
EAMVO. Element, attribute qualification, metric qualification, value, object.
Two steps to utilize an intelligent cube are...
Create the icube, publish its set of data
A derived element is a grouping of elements on a report, that is defined by...
A list(group), filter, or calculation.
Report data options are grouped into three categories...
Calculations, display, and general.
Report data calculations include;
Report limit, metric join type, attribute join type, evaluation order, and subtotals.
Report data display options include:
Alias, object display, null value, and grid/graph mode.
"General" report data options include:
Drilling, advanced, and mstr mobile data view
T/F The report data option, report limits, is applied during metric calculation.
F - they are applied at the report level AFTER metrics are calculated.
The hierarchy (or precedence) for drill map associations is:
Report overrides template, template overrides object.
What 4 report data options can be used by find and replace?
DAMN. - drilling, advanced, mstr options and null values
Transformations are?
Schema objects used to compare like values over different time periods..
What are the components of transformations?
Member attributes, Member expressions, member tables, and mapping type.
T/F. You can apply metric filtering to both simple and compound metrics.
F - you can only apply filters (conditionality) to simple metrics.
What are level metrics?
They are metrics that allow you to control the level/dimension the metric is calculated at. They calculate percent to total values.
What level do metrics calculate at by default?
The lowest attribute level, which is called the report level.
What must be specified when you create a level metric?
A target, grouping of standard or none, and a filter type of standard, abs, ignore or none.
In level attributes, the grouping setting dictates...
How the level metric aggregates.
The filtering setting dictates...
How the report filter interacts with the level metric calculation.
Non-aggregatable metrics use what grouping options?
Beginning and ending grouping options
What are base formulas?
Simple metric formulas that are saved as separate objects that can be reused.
What are conditional metrics?
Metrics that contain their own filters.
How do you control the interaction between a report filter condition and a metric condition?
If they are related, you use the "remove related report filter elements" option.
If filtering criteria are related, it means they are...
...from the same hierarchy.
Nested metrics are....
Metrics that contains inner and outer formulas that calculate at different levels.
What is the differences between custom subtotals and user-defined subtotals?
Custom are in a report and control the display, user subtotals control the functions used to create subtotals and are created in the subtotal editor to be used as needed.
Attribute to attribute filtering allows you to...
...Create reports that compare attribute forms from two attributes.
Joint element list enables you to...
...choose attribute elements from different attributes to filter the report result set.
Dynamic dates....
Enables you to run a report that examines sales from previous dates. I.e., two months ago."rolling dates"
Import filter elements enable you to.... import lists of data from pre-existing files (excel, text) into a filter definition.
Qualifying on a metric allows you to...
... restrict the rows of data returned in a report, by metrics.
Metric Qualifiers are...
Metric value, rank, and percent.
Set qualification output level is set to....
...the attribute you want the metric to be evaluated on. Can also set a "break by"
Relationship filters enable us to define?
A relationship between two indirectly related attributes...without adding a metric on the report.
Relationship filters have 3 parts.
Output level, filter qualification, relation.
Relationship filters are usually used for....
Market basket and affinity analysis.
What else can provide filtering similar to relationship filtering?
Shortcut to a report.
Ship date_id > day_id +2 is an example of?
Attribute to attribute filtering.
A consolidation allows you to?
Group attribute elements and place them on a template, just like an attribute.
Consolidations are also known as?
Virtual attributes.
A custom group enables you to create...
Stacked reports, and apply separate filters to the different rows of a report.
Custom group banding options include...
Band size, band count, banding points, and banding on each distinct metric value.
How do you publish an icube?
Manually run it, or you can schedule the publication.
What are the different types of derived elements?
Group, filter, calculation, and all other.
Derived elements are defined by?
List,filter or calculation.
Count metrics can calculate against what types of tables?
Lookup tables org fact tables
/ 84

Leave a Comment ({[ getComments().length ]})

Comments ({[ getComments().length ]})


{[ comment.comment ]}

View All {[ getComments().length ]} Comments
Ask a homework question - tutors are online