Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/14

Click to flip

14 Cards in this Set

  • Front
  • Back
What keys are used to identify a valid report cache?
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
Intelligent Cube
A copy of the report data saved in memory and used for manipulation of the view definition. (does not generate new SQL)
SQL Required (outside the intellegent cube) Yes or No
Removing objects from the report objects window
Yes
SQL Required (outside the intellegent cube) Yes or No
Adding an object to the report definition from the Object Browser
Yes
SQL Required (outside the intellegent cube) Yes or No
Drilling to objects not contained in the report objects window
Yes
SQL Required (outside the intellegent cube) Yes or No
Modifying the report filter
Yes
SQL Required (outside the intellegent cube) Yes or No
Adding an object to the report view from the report objects window
No
SQL Required (outside the intellegent cube) Yes or No
Moving an object to the report objects window from the report view
No
SQL Required (outside the intellegent cube) Yes or No
Drilling to objects contained in the report objects window
No
SQL Required (outside the intellegent cube) Yes or No
Modifying the view filter
No
SQL Required (outside the intellegent cube) Yes or No
Adding a derived metric based on report objects
No
Explain Report Cache Sharing
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)
View Filter
OLAP function that allows you to filter a report based only on the objects in the report objects window.
Dynamic Aggregation Function
OLAP function: Reports that are aggregated within the Intellegent cube ie: moving an attribute to the report objects window.