Mstr Advanced Reporting Section 2

Front 1

What keys are used to identify a valid report cache?

Back 1

Report ID, Report Version ID
Template ID, Template Version ID
Filter ID, Filter Version ID
Security Filter ID
Prompt answers
also can use: User ID, Database connection ID, and Database Login ID

Front 2

Intelligent Cube

Back 2

A copy of the report data saved in memory and used for manipulation of the view definition. (does not generate new SQL)

Front 3

SQL Required (outside the intellegent cube) Yes or No
Removing objects from the report objects window

Back 3

Yes

Front 4

SQL Required (outside the intellegent cube) Yes or No
Adding an object to the report definition from the Object Browser

Back 4

Yes

Front 5

SQL Required (outside the intellegent cube) Yes or No
Drilling to objects not contained in the report objects window

Back 5

Yes

Front 6

SQL Required (outside the intellegent cube) Yes or No
Modifying the report filter

Back 6

Yes

Front 7

SQL Required (outside the intellegent cube) Yes or No
Adding an object to the report view from the report objects window

Back 7

No

Front 8

SQL Required (outside the intellegent cube) Yes or No
Moving an object to the report objects window from the report view

Back 8

No

Front 9

SQL Required (outside the intellegent cube) Yes or No
Drilling to objects contained in the report objects window

Back 9

No

Front 10

SQL Required (outside the intellegent cube) Yes or No
Modifying the view filter

Back 10

No

Front 11

SQL Required (outside the intellegent cube) Yes or No
Adding a derived metric based on report objects

Back 11

No

Front 12

Explain Report Cache Sharing

Back 12

Any results of non-SQL manipulations saved as a sparate report can be made to share the same cache (any view of a report created within the intelligent cube)

Front 13

View Filter

Back 13

OLAP function that allows you to filter a report based only on the objects in the report objects window.

Front 14

Dynamic Aggregation Function

Back 14

OLAP function: Reports that are aggregated within the Intellegent cube ie: moving an attribute to the report objects window.